How do I produce a reconciliation report?

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

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.

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)

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.

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

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.

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