Reversing A/R and A/P effects of vendor bill in closed accounting period

Suppose you create a client retainer in CORE and then a vendor bill for some related expenses, which shows up in the Expense Entries screen. These expense entries associated with the vendor bill are approved. Other charges along with these expenses are billed and the retainer is applied on it in the Invoices screen. Next, you pay the vendor bill (A/P check). You have deposited the retainer payment from the client along with the payment for the invoice. However, the vendor returns the A/P check. As this was done in a previous or closed accounting period on a cash basis, you now want to do the following:

  1. Reverse the A/R and A/P side of the vendor bill transaction in CORE
  2. Reverse the application of the retainer on the A/R invoice without having an incorrect amount show up under the client's transactions
  3. Use a method for the above that does not void any A/R or A/P transactions

Here is a summary of the transactions that you made:

  1. A/R transaction for retainer received
  2. A/P transaction for vendor bill created
  3. A/R transaction for invoice created and retainer applied to it
  4. A/P transaction for check written to pay vendor bill
  5. Deposit transaction that moved retainer and invoice payment into the checking account

To resolve the issue: 

1. Create the following cash-based entries in General Journal. Check CORE Help Center for details.

a) A/P cash General Journal transaction to void the A/P check sent to the vendor

b) A/P cash General Journal transaction to void the vendor bill

c) A/R cash General Journal transaction to void the application of retainer on the invoiced

d) A/R cash General Journal transaction to void the vendor bill cost on the invoice

2. After this, create a new retainer payment in the Payments screen as the original retainer payment has already been used, reconciled and cannot be voided. Check CORE Help Center for details

3. Then enter the last A/R cash General Journal transaction to void the effect of creating a new retainer in another accounting period as it is being reused. 

Note: Doing this increases the amount of client retainer paid or shows up under client's transactions, but you have a paper trail and General Journal that will back up the reasons for the discrepancies.

Was this article helpful?
0 out of 0 found this helpful