Difference in Account payable summary and Balance sheet

Prabesh

Has anyone experienced a situation where the Accounts Payable (AP) Summary does not match the Balance Sheet, while the Supplier Centre balances and Balance Sheet do match?

I have escalated this issue to Reckon Technical Support. After more than two months, the only solution they have suggested is to unreconcile the bank transactions from 2013 and reconcile everything again, which is simply not practical for a large business with many years of transactions.

I also requested to speak with a supervisor or team manager, but my request was declined.

To help identify the issue, I provided support with two sample suppliers where the balances differ and asked if they could identify the remaining suppliers contributing to the discrepancy. Unfortunately, this request was ignored.

Has anyone faced a similar issue?

• Were you able to resolve it?
• Is there a way to escalate this to a team manager or a higher level of technical support?

Any advice or suggestions would be greatly appreciated. Thank you.

Datarec

Hi @Prabesh

How often do you typically compare these reports?

When did you first encounter this issue whereby the report balances for the Accounts Payable account does not match in the way you are expecting?

Have you already put your data file through the built-in file integrity checking tools (Verify Data / Rebuild Data)?

How to perform a data file verification (Verify Data) in Reckon Accounts Hosted - Reckon Community

Can you clarify a few details and let us know what you've already tried to isolate and identify the factors contributing to the issue?

Report Clarification
When referring to the "Accounts Payable Summary", could you confirm whether this means:

1. A/P Ageing Summary, or
2. Supplier Balance Summary

Clearly identifying the report in question is important so we can accurately assess the issue.

Understanding the Scope

• Is the discrepancy limited to a specific period or date range?
• Have you tried adjusting the start and end dates to determine how far back the issue occurs?
• When did the balances last match as expected, and on which specific day does the discrepancy first appear?

Transaction Review
For the suppliers you have already identified as showing discrepancies:

• Have you identified the specific transactions contributing to the difference?
• Are there transactions appearing in one report (e.g., via a Balance Sheet drill-down) but not in the other report?

Recommended Approach: Narrowing Down the Issue
To help isolate the cause, you can take a methodical approach:

1. Generate the reports "Balance Sheet" and the other report and filter supplier Names in smaller groups (e.g., those beginning with A–D, then E–H, etc.).
2. Compare the Accounts Payable balances in both reports for each group of names.
3. Identify which group introduces the discrepancy.

Once you’ve identified a specific group of suppliers, narrow it down further.

The once you've identified a specific supplier:

• Filter both reports to show only that supplier.
• Adjust the date range to determine:
  • When the figures match
  • The exact day the discrepancy begins

From there, review the transactions present on that day to pinpoint the cause.Note
There isn’t a quick way to resolve this—it requires a methodical process of elimination to identify the affected suppliers and the transactions responsible.