A/R Aging Detail Not Showing Applied Payments – Despite Correct Dates & Allocation

Natalie

hi, We’re using Reckon Accounts Hosted and having an issue with the Accounts Receivable Aging Detail Report.

The Problem:

Several client payments are not appearing in the A/R Aging Detail Report as at 30 April 2025 and 31 May 2025 — even though:

• The payments are dated in April (e.g. 24/04/2025)
• They were entered using Customers > Receive Payments
• They appear in the Customer Transaction List by Customer
• They have been correctly applied to invoices dated on or before the end of month.
• The full amount is shown as “Amount Applied”
• The transaction journal (Ctrl+Y) confirms they’re hitting the Accounts Receivable account
• The bank reconciliation for April is balanced and includes these transactions

Despite this, the payments do not reduce the balance in the April A/R Aging Detail report — making our aged debtors appear overstated or showing credit balances in April and May.

I have checked the payments:

• Payments weren’t entered via Receive Money or Make Deposit ✅
• Invoices are not future-dated ✅
• No filters are applied to the report ✅
• Amounts are actually applied to invoices ✅
• The AR account is correct in both payment and invoice ✅
• Report date is set correctly to 30/04/2025 ✅
• We’ve tested in multiple user logins ✅

Has anyone seen this before?

Is there a known issue with A/R aging reports missing correctly applied payments, or could this indicate data corruption?

Would love any advice or steps to troubleshoot further?

Thanks in advance!
Natalie

Acctd4

Hi @Natalie

Are you using Customer:Jobs ?

Natalie

Looking back, the issue seems to have started in March and continued through to May. Payments made during this time are visible in the Customer Transaction List and are applied to invoices dated on or before the report date, but they do not appear in the A/R Ageing Detail report.

I’ve double-checked everything:

• Payments are entered via Receive Payments
• Applied correctly (not left as credits)
• Use Accounts Receivable in the transaction journal
• No Customer:Job mismatch
• No report filters applied

I’ve also tested reports from June onwards, and they appear to be working correctly again the payments are showing as expected in the A/R Ageing Detail.

My next step I was thinking doing a File > Utilities > Rebuild Data and then Verify Data next to see if that corrects the issue for those earlier months?

Acctd4

Yes, I would recommend running the Rebuild Data 3 times (For some reason, THREE rebuilds fixes a lot of issues!) 🤞

Natalie

Is it simple to do the Rebuild data?

Acctd4

Yes 😊 The system just checks & "fixes" any corruptions identified.

The timeframe for it is very dependent on the health & size of your company file - For some it may take a few seconds or minutes, for others it may take hours (or even overnight in some cases)

Natalie

I did the Rebuild Data 3 times and didn't fix the issue. Any other suggests?

Thank you for your help!

Linda ABC

Can you provide a screen shot or two that shows the problem? Sometimes visualising will help us to know what is happening and offer a solution?

Natalie

Hi,

Here’s a more detailed explanation: The Problem (A/R Aging Detail Report)

In the A/R Aging Detail Report, under the “1–30 days” column:

• There should be multiple payments listed (Tyro, pet insurance, and client payments) from Vet Practice Invoices
• These payments were made during March, April, and May 2025
• Only some March payments show, none from April, and most of May are also missing
• Yet from 29th May onwards, everything is working correctly again
• The same process was followed during all periods

Our Standard Process (unchanged):

• Customers > Receive Payments
• Customer: Vet Practice Invoices
• Apply payment to a practice invoice (invoice is always dated prior to the payment date)
• Amount applied and saved correctly
• Transactions reconcile perfectly with our bank account
• Ctrl+Y shows all payments posting to Accounts Receivable

What We’ve Confirmed:

• This issue does not appear before March (Jan/Feb reports are accurate)
• From 29th May onwards, the aging report is also functioning as expected
• The Customer Transaction List shows all the payments correctly
• But the A/R Aging Detail report excludes them entirely during March–May
• All payments are made the same way, to the same customer, and linked to valid invoices

Acctd4

@Natalie Hmm 🤔

I’m happy to take a quick look later if you’d like? Just shoot me through an email direct.

Kris_Williams

have you tried deleting one of the problem payments and re entering? Or at least unapply a payment, record and reapply

Natalie

Hi, that would be amazing. My email is natalie@allambievet.com.au

Linda ABC

Kris's suggestion is a good one - would then determine if there was some corruption happening when these entries were made… although most corruption is fixed by the 3 x rebuild process?

Have you also checked that you dont have a hard drive issue? eg - have you had any power flicks or knocks to the machine? perhaps doing a check on the drive is worthwhile?

Linda ABC

Just a quick question - I may be missing something - but I just ran the AR Ageing Detail report on one of my Reckon files - with no adjustments to settings - the default setting is that Paid Status is Open… so that means any payments already applied to invoices as at the date you run the report - would not show up as the invoices are Closed - ie paid off? So I am not sure what you would normally be expecting to see?

If you run the Customer Balance Detail Report then I would expect you would see these payments against the invoices?

Try running this one too - even if it isnt what you want - it may give you a clue as to what is different to how it normally shows up for you?

Natalie

I ran a dummy test by creating a received payment 01/04/2025. It appeared correctly in the A/R Aging Detail report when run as of 30 April so the reporting and process are functioning properly now.

This confirms the issue is not with the report itself, but with the original March–May transactions, which seem to be affected by some kind of data corruption or broken internal link between the invoice and payment. These payments show as applied and reconciled but still don’t appear in the aging report.

I’m now wondering am I going to have to delete and re-enter all of those payments and invoices from that period just to fix the reporting?

Has anyone experienced this and found a workaround that doesn’t involve undoing reconciliations?

Kris_Williams

I would try unapplying the payment - save-then go back and reapply.

You don’t have to undo reconciliations if you do delete the payments, you just have to retick them in the reconciliation window after re entering

Linda ABC

Another suggestion - edit each transaction - sometimes even putting a full stop or some words in the memo - then saving again - can fix an issue?