Fix up customer payments


You guys are always a great help to me, so hopefully someone can help me with this one.
We had a customer with a very overdue account. We started to receive these payments into our account and because of the description, we thought it was a different customer. I put these payments through as 'sale receipts'. Our financial year is from 1 Jan to 31 Dec and some of these payments were received in late 2019. I can't just go and delete and 'receive payment' against the correct customer, as we have been audited and had our AGM, so I can't touch any transaction from 2019.
I have tried to do it a few ways, but I end up with a negative balance against the customer I was putting the payments to and nothing against the customer, that the payments should be allocated against.
I am sorry, I am not always the best at describing things, so I hope I am not causing too much confusion.
Thank you in advance for any assistance.
Regards Jules
Comments
-
You could Receive Payment against the correct customer and bank it to a Clearing bank account, then enter a cheque from the same account posting to the income account that the Sales Receipt used. Clearing account will be zero and the original income from the sales receipt will now be reversed. Use tax code GST on cheque1
-
Thank you so much, it worked.
I have used your advice to other people in this community, to help me, on several occasions.
Thanks for all your help.
Kindest regards Jules0 -
You’re very welcome, glad it worked for you0
-
Good suggestion Kris!
I’m thinking using the "GST" tax code again on the transfer cheque would double-up on the GST amount though ?
… Just tried it & noted the cheque wouldn’t allow a sales tax code on it anyway.
However, using "NCG" instead, meant it reversed the GST double-up on the sale side & increased it by the difference on the purchase side, resulting in the correct GST outcome:
... & correct Net Sales result:
... & correct GST Payable account result:
& correct (zero) records for both customers:
Shaz Hughes Dip(Fin) ACQ NSW, MICB
Reckon Accredited Professional Partner Bookkeeper / Registered BAS Agent (No: 92314 015)
Accounted 4 Bookkeeping Services
Ballajura, WA
0422 886 003
Shaz Hughes Dip(Fin) ACQ NSW, MICB
*** Reckon Accredited Partner (AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! ***
* Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *
Accounted 4 Bookkeeping Services
Ballajura, WA
(NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)
1