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
Hey Jane7737,
You can check the Sales Customer Detail report, which shows all sales to selected customers within a date range, including invoice line items and quantities, making it easier to see what was billed at a detailed level. Alongside that, the Receivables Reconciliation report in Summary or Detail view can be used as a solid starting point for reconciliation, as it shows outstanding balances per customer and helps you track how payments, credits and invoices tie together.
Cheers,
Doreen
Thanks Doreen but those reports aren't pulling the info that I need. Basically what I am looking for is a remittance report that shows in one screen how each payment was allocated.
Like this, but for multiple payments made over a period of time rather than having to drill into each payment individually.
Hi Jane7737,
Thanks for clarifying what you’re looking for, that makes sense. AccountRight doesn’t have a single report that’s labelled as a “remittance report over a period”, but the closest built‑in option is the Customer Payments report. This shows each payment and the invoices it was allocated to, which gives you that remittance‑style view across a date range. You can also visit our Sales reports for more information.
Regards,
Earl
