How do I produce a reconciliation report?
The Customer ledger doesn't show how payments have been allocated. Some customers don't advise what their payments are for and end up being strange amounts. How can I build a report that shows what...
Forum Discussion
hi Jane7737
Try running sales register detail (all sales), then filter to the custmer in question and the date range you want.
once you run the report then go to insert/modify tab, over on the right hit the show/hide, scroll down on available columns and choose date closed, go back to filters tab and run report.
This will then show you all the ones close on a certain date (i.e.paid off with the deposit received from client).
Advise the clients to send a remittance advice in future so their money can be allocated how they want, or to pay each invoice individually with the invoice number as a reference.
I have a few clients who this happens to, and even though more work saves time in the long run when things like incorrect allocations happen.
You should get the client to send you details of what they wanted monies allocated to and then need to unallocate and redo correctly. Be very careful when doing this though, take a note of your last reconciled balance, make sure you have no interuptions while doing this, and reconcile again once completed.
Then you need to do the slow process of find transactions, enter the customer name and date range and drill down on the payments, which will show you how allocated. Print the screenshot so you can then try and marry with what the customer tells you how they wanted allocated. Some may have been allocated correctly and others not.
