nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How do I produce a reconciliation report?

Jane7737

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 I have attributed their payments to for comparison to what they think their payments are for?

AccountRight 2025.11.1.9

Find more posts tagged with

Accepted answers

All comments

Julie_A_C

hi @Jane7737

you could also try invoice transactions (accrual) select the customer and date range and exportto excel.

Then needs a bit of manipulation to get this

Invoice Transactions [Accrual]
1/07/2025 To 2/02/2026

	Src	Date	Account	Payments

00004359	677
00004296		17/10/2025	1-1180	$86.65
00004359	CR	17/10/2025	1-1180	$413.35
				$500.00

00004359	CR	3/11/2025	1-1180	$19.98
00004395	CR	3/11/2025	1-1180	$320.02
				$340.00

00004395	CR	14/11/2025	1-1180	$129.98
00004396	CR	14/11/2025	1-1180	$370.02
				$500.00

00004263	CR	5/12/25	1-1180	$46.87
00004396	CR	15/12/2025	1-1180	$79.98
00004407	CR	15/12/2025	1-1180	$373.15
				$500.00

00004407	CR	29/01/2026	1-1180	$76.85
00004414	CR	29/01/2026	1-1180	$423.15
				$500.00

Julie_A_C

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.

Jane7737

Thanks Julie, that is closer to what I was wanting. Doesn't really show when an invoice was part paid though. Had hoped for a report that would list the payment made with the associated invoices or part invoices that made up the total. This one still has to have manual calculations (invoiced weekly, paid monthly)

Julie_A_C

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.

Jane7737

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.

Doreen_P

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