User created a client retainer in BillQuick 20xx. User also created a vendor bill for some expenses, which showed up in the Expense Log screen. These expense entries for the vendor bill were then approved. Other charges along with these expense entries were billed on an invoice and the retainer was applied on it in Billing Review. Next, user sends an A/P check for the vendor bill payment to the vendor. User has deposited the retainer payment from the client along with the payment for the invoice. However, the vendor returns the A/P check. Since this was done in a previous or closed accounting period on a cash basis, user wants to do the following:
1. Reverse the A/R and A/P side of the vendor bill transaction in BillQuick 20xx
2. Reverse the application of the retainer on the A/R invoice without having an incorrect amount show up under Client > Summary > Retainer Paid or Client > History
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 the user 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 the General Journal:
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) 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 Payment screen as the original retainer payment has already been used, reconciled and cannot be voided.
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 will unfortunately increase the amount on the Client > Summary > Retainer Paid screen or Client > History but you have a paper trail and General Journal that will back up the reasons for the discrepancies.