AR and AP Not Reconciling to Trial Balance QuickBooks Premier 2018
Good day,
My company been experiencing an issue in QuickBooks Premier Edition 2018 where the Accounts Receivable (AR) and Accounts Payable (AP) summary reports no longer reconcile with the Trial Balance (TB). This issue began in January 2025, but after further investigation, we noticed the discrepancy now traces all the way back to June 2012, even though this was not an issue before.
To provide some context:
We report in Jamaican dollars (JMD), and our company also invoices customers in USD:
- The JMD side of the AR transactions agrees — AR JMD and TB JMD both show 18,192,041.56 J MD.
- However, the USD side does not reconcile —
- TB USD: 21,253,078.57 JMD
- AR USD: 22,108,352.92 JMD
- Resulting in a difference of $855,274.35 JMD.
Therefore, in May 2025, the AR Summary shows a total of $40,300,394.48, while the TB shows $39,445,120.13, resulting in a difference of $855,274.35.
The same issue is occurring where the AP summary is not reconciling to the TB:
- The JMD side of the AP transactions agrees — AP JMD and TB JMD both show 12,471,408.69 JMD.
- However, the USD side does not reconcile —
- TB USD: 9,292,176.46 JMD
- AP USD: 9,472,722.08 JMD
- Resulting in a difference of $180,545.62 JMD.
Therefore, in May 2025, the AP Summary shows a total of $21,944,130.77, while the TB shows $21,763,585.15, resulting in a difference of $180,545.62.
We are currently using:
- QuickBooks Premier Edition 2018
- Microsoft Excel 2003 for reconciliation work
We would like to ask:
- Has anyone else encountered this issue before?
- Could this be related to the age of the software or a data corruption issue?
- Is there a recommended fix or tool to repair the file?
- Would upgrading to a newer version of QuickBooks help?
Any advice or insight would be greatly appreciated. Thank you in advance!
Best regards,
Ven