Refund Scenario - A supplier will send a request for a deposit of prepayment to the Accounts Payable group. The following is a basic overview of the standard account suggested by Oracle for the entry of a prepayment with a refund from the supplier.
1. Enter a prepayment invoice to the supplier.
Prepayment Account (default) - DR.
Liability Account - CR.
2. Pay the prepayment invoice to the supplier.
Liability Account - DR.
Cash Clearing Account - CR.
3. Reconcile payment in cash management.
Cash Clearing Account - DR.
Cash Account - CR.
The supplier sends a refund check for ‘some amount’ (XX) of the original prepayment.
___________________________________________________________________________________________
4. The Accounts Payable person enters a ‘dummy’ invoice with invoice number ‘Refund XXXXX’ in the amount of the refund.
Expense Account DR. ******Cash Account workaround.
Liability Account CR.
5. Match the invoice to the original prepayment invoice.
Liability Account DR.
Prepayment Account (default) CR.
___________________________________________________________________________________________
At this point, the refund has never been officially recorded in Payables or in Cash Management. The refund will not show any or Oracle’s standard reports. Oracle’s standard process for recording refunds of prepayments includes an additional step to record the refund in Payables and in Cash Management.
6. The Accounts Payable person enters a ‘dummy’ Debit Memo.
Liability Account DR.
Expense Account CR.
7. The debit memo is ‘paid’ with the entry of the refund check.
Cash Clearing DR.
Liability Account CR.
8. The refund is reconciled through Cash Management
Cash DR.
Cash Clearing CR.
___________________________________________________________________________________________
******The Cash account can be used for logging the payment to the correct GL account. However, there are no provisions to have the refund show up on the AP standard reports or to be cleared through Cash Management.
Thursday, April 10, 2008
Accounting for Refunds within Oracle Payables
Subscribe to:
Post Comments (Atom)
3 comments:
Nice one. There could be some other scenarios which call for a supplier refund, like:
1. Its possible that we have a situation where there is a routine goods return to a supplier, which calls for a supplier refund.
2. Also, in a previous proj of mine there used to be a council tax that used to be paid to the county every month, and any excess payment made to the concil used to be refunded to the company back which used to be recorded as a supplier refund.
Nice post.Accounting dubai and offshore company formation services in Dubai by leading audit firm in the region, Alnoman & Ravi Chartered Accountants based in Dubai
Post a Comment