Hi there, sdonbosco.
Thanks for reaching out to the Community. I'm here to provide some insights about the amount difference between the balance sheet and supplier ageing total. This can happen when the Ageing Report defaults to Current. You'll want to change the ageing method report to the As of Report Date.
Here's how:
- Open the A/R Ageing report.
- Select Customise.
- Select Ageing.
- Under Ageing Method, choose Report Date.
- Select Run report.
I encourage checking out this article for more details: How to get your Ageing Reports to match.
You can also read this link about the Balance Sheet and Accounts Payable Ageing report disagreement for your reference.
Please tag me directly if you need anything else.