Creating a Refund

Personify is a receivables system and does not issue checks. What we can do, however, is create vouchers which are requests for checks from an external payables system. We generate a transaction against a Payables Transfer Account and this transaction is sent to the GL in the normal way. From there, the payables system would generate a check.

 

Personify has a number of interfaces to various AP systems and depending on the AP system, the transfer is handled in different ways as allowed by that system. Typically, the AP system creates its own AP transaction which washes out the AP transfer account. The rest of the typical payables transaction, the offset accounts, is passed to the GL through the normal process.

 

Refunds can be made for the following receipt types:

·            Cash - Refunds are made in full in the currency selected.

·            Credit - Only the most recent receipt against the line item(s) in question will be refunded. Credit balances are always refunded first unless the user selects a specific line item. These are fundamentally different from refunds as generated from checks. When a receipt being refunded is a credit card, the refund must go to that credit card unless the user specifically requests this through the UI. A voucher transaction is still created but not against the payables transfer account. For credit cards, the transaction is a debit to AR (or PPL) and credit to the credit card receivable account from the original batch. If you are processing a refund that has been presettled, then it does not get processed through the credit card processing system (it already has been) but the same transaction gets created against the credit card receivables account.

·            Check - A voucher is created that is transferred to the GL for payment through the AP system.

 

If a full refund is indicated, then the full amount of the receipt will be refunded. The order line total should be $0. If there are multiple currencies involved and the full amount of one currency is refunded and the amount goes in the second currency, the system verifies that the full amount of the first currency was refunded without any rounding. All rounding issues are reflected and corrected in the base amount. Refunds are made based on the original receipt types referenced by specific orders and line items

Transaction Structure

Refunding a receipt will create type ‘2’ transactions with the following format:

Voucher – Check Requests for Invoiced Order

            DR       AR
            CR        TIMSS Accounts Payable Transfer

In the AP transfer a true AP transaction will be created:

            DR       TIMSS Accounts Payable Transfer
            CR        Accounts Payable

Then the check is cut:

            DR       Accounts Payable
            CR        Cash

Voucher – Check Requests for Un-invoiced Order

            DR       PPL
            CR        TIMSS Accounts Payable Transfer

Credit Card Refunds for Invoiced Orders

            DR       AR
            CR        Credit Card Receivables

Credit Card Refunds for Un-invoiced Orders

            DR       PPL
            CR        Credit Card Receivables

Source of the Accounts

Debit:  The AR and PPL accounts are found at the order_detail level  (order_detail.AR_Account and order_detail.PPL_Account).  One FAR_TXN and two FAR_TXN_DETAIL records are created for each order_detail record referenced by a receipt.

 

Credit:  The Accounts Payable account is found by app_org_unit.payable_account for the order_master.org_id, order_master.org_unit_id combination.    The Credit Card Receivables account is accessed by finding the batch number and receipt type from the far_receipt record and finding the reference far_batch_detail.debit_account.

Logic for Refund Creation

Minimum information needed for the process:

·            Receipt_No

·            Amount

·            Collection of Order_No and Order_Line_No

 

1.    Create the objects for the FAR_Voucher, FAR_Txn, and FAR_Txn_Detail records and populate with either default information or information passed in based on the templates below.

a.    Verify that the receipt has bee posted and that the receipt has not been transferred (the processing logic should have already prevented this, however.)

b.    Note: Refunds are typically created against specific receipts so that the refund transaction (FAR_Txn type=2) can carry with it the original receipt_no.  Each FAR_TXN created must reference a specific receipt.

c.    For each order/line number combination that the refund affects:

i.      Note that the debit account is different depending on whether the order has been invoiced and the credit account will be different depending on whether this is a credit card.

ii.     If the refund is to a credit card

·            If this is a credit card refund and the refund date is the same day as the credit card receipt, then process this as a credit card VOID or cancellation rather than a refund.

·            If the “settled credit card” flag is set to ‘Y’, then do not send to the credit card company but still create the same TIMSS transaction.

·            If this is a credit card refund and the refund date is not the same date as the credit card receipt, process the credit card transaction as a CC refund transaction.

iii.   If the refund is NOT to a credit card, it is by definition a check request or voucher.

iv.    Create a FAR_Txn type=2 record for each order against which the refund was applied. 

v.     Create the FAR_Txn_Detail distribution as outlined above.  The transaction templates indicate the source for the GL account and other information needed.

vi.    Verify that sum(FAR_Txn_Detail.base_amount) = zero.  This verifies at least that debits=credits.

vii.  Do intercompany processing to balance each transaction by company within each set of far_txn_detail records.

d.    FAR_Voucher record will be created for the refund itself.

To create a refund:

1.    From the Customer Financial Analysis screen, select the appropriate line item and click Create Refund.
The Cancellation and Refunds screen displays.
Cancellation_and_Refund.png

2.    On the Refund Only tab, enter the Refund Amount and any Notes on Advices. These are notes related to the refund that can be printed on the refund check. For example, the order number of the refunded item.

3.    If necessary, check the Multiple Receipts Involved checkbox.

4.    On the Receipts Referenced tab, review the receipts referenced for the order. Highlight the appropriate order.

5.    If the order was paid by credit card the Refund to Specific Credit Card tab is displayed.

6.    Enter the name and address information for the credit card.

7.    From the list of Receipt Numbers on the left, select the receipt you wish to create the refund for.

8.    Select the Expiration Date of the credit card.

9.    Enter the Refund Amount to be refunded to the credit card.

10.  Select the appropriate checkboxes:

·            Credit Card Receipt – when checked indicates the order was placed by credit card. This is read-only.

·            Pre-Settled – when checked, indicates the credit card is pre-settled so you do not need to send the transaction to the credit card company because it has already been processed. You should still create the transaction in Personify.

·            Refund by Check – when checked, indicates the refund will be provided by check.

11.  If the order was paid by check the Refund to Specific Check tab is displayed.

12.  Enter the Check Number and Amount to be refunded.

13.  Select the appropriate checkboxes:

·            Check Pre-Cut – when checked, indicates the check was generated and sent to the payor prior to creating the refund voucher. So the voucher status is posted and the refund is not passed to the AP system.

·            Refund by Check – when checked, indicates the refund will be provided by check.

14.  Enter any Notes on Advices. These are notes related to the refund that can be printed on the refund check. For example, the order number of the refunded item.

15.  Click Process.