Fixing a double AR payment, when there is only one cheque

scenario

 invoice created for customer A, paid by the customer A into ‘cash to be deposited’, and a deposit slip is created

 then someone decides that customer B should have be invoiced

 

the correct process is

to void the payment and invoice for customer A (may need a credit note if either the invoice and/or payment can’t be voided)

 

and to recreate both for customer B

 

but say someone

adjusts the payment and changes customer A to customer B, gets the message

     you have modified the receipt by changing the customer name

     the original receipt will be voided and a new one created, using the customer's name

     do you want to continue ?

                to which they answer Yes, creating a deposit for customer B

 

and then they adjust the invoice from customer A to customer B

and then apply the deposit to the invoice

 

the problem is, the cheque is there twice

the original deposit is still there, full value, including that cheque amount

and 'make deposit' shows the payment a second time

there is only one cheque, which has been deposited, but now Sage thinks there is a second cheque to add to another deposit


how do I clean up this second cheque ?

when the payment was adjusted from customer A to customer B, two transactions (adjustment / correction) were created

db  AR

cr   cash to be deposited (adjustment to reverse original payment to customer A)

 

db  cash to be deposited

cr   prepaid sales/deposits (correction to create new payment for customer B)

 

the second entry is causing the duplicate cheque in ‘make deposit’

 

so to solve this issue,

create a journal entry to reallocate the correction amount to the clearing bank

db clearing bank

cr  cash to be deposited (with an appropriate comment)

 

and adjust the customer B payment, depositing to the ‘clearing bank’ instead of ‘cash to be deposited’

 

Parents Reply Children
No Data