DISPARITY IN REPORTS @GL & SUBLEDGERS

A 1-cent discrepancy between your Customer (Supplier) Outstanding Statement and the Trade Debtors (or Creditor) Account in the General Ledger (GL) can be frustrating but is quite common, especially in high-volume or complex accounting environments. Here's a breakdown of possible reasons this tiny discrepancy can occur:

TRANSACTIONAL CAUSES

1. Rounding Differences

Source: System round amounts differently between sub-ledger and GL.

• Example: An invoice with 1 Trade Debtor account may post with multiple Sales Control accounts (different products posting to different accounts) and the rounding of each line may give rise to a 1-cent discrepancy when summed. Tax calculations are done by product level within a bill, and a big list of items could give rise to such an incidence. 
• Impact: Over time or across many transactions, this can lead to a cumulative 1-cent difference.

2. Foreign Currency Rounding / Exchange Differences

Source: If you're dealing with foreign currency customers, exchange rate rounding differences can cause minor discrepancies.

• Example: The sub-ledger converts currency and gain/loss at a higher number of decimals; whereas the GL always work at 2 decimal.
• Impact: 1-cent gaps due to conversion and rounding.

3. Manual Journal Entries in GL

Source: An accountant might have posted a manual journal directly to the Trade Debtors GL without reflecting it in the customer sub-ledger.

• Example: Writing off a small balance or correcting an earlier error.
• Impact: Creates discrepancies between detailed customer records and the GL control account.

REPORT AND DATABASE DESIGN CAUSE

 In our database design, the Customer Invoice transactions, Payment & Allocation transactions and GL Debtor postings are maintained in 4 different database tablesets. These are independent of each other and deliberately kept separated. They then act as a self-checking mechanism for one another. For example:

• AR& APTables (Group 1) will show outstanding debtors/creditors from GL perspective with exchange gain-loss factored in. 
• AR/AP Allocations (Group 2) will show allocations (partial or full made against each customer or supplier invoice
• Customer Transaction Tables (Group 3) will show invoices, debit/credit notes and receipts, with no reference to exchange gain-loss.  
• Trade Debtor/Creditor Control (Group 4) – these GL based values are posted directly to the GL from every transaction after tax and discounts are computed. 

To generate the following reports:

• Customer Ledger– the data source is Group 1, Group 2 and Group 3 tables. 
• Customer Outstanding and Aging Reports– data source is Group 1and 3 tables.  
• GL/ Trial Balance Debtor/Creditor Balance – data source is Group 4 tables

The cross-reference nature of these tables create a self-checking mechanism, where all the above 3 sets of reports should tie with each other. In reality, they may be out by 1 or 2 cents.

WILL YOUR AUDITOR QUERY YOU FOR SUCH DIFFERENCES?

Short answer:Probably not - as long as you can explain it.Materiality is usually what the auditor considers:

• Auditors focus on material differences — ones that could misstate financial statements or mislead users.
• A 1-cent discrepancy is immaterial in almost all contexts.
• If your total Trade Debtors are, say, $50,000 or more, a $0.01 variance is less than 0.00002% — essentially negligible.

So no, your auditor is unlikely to challenge a 1-cent difference on its own.

HOW SHOULD YOU FIX OR DEAL WITH IT?

You have 3 options, depending on your accounting policy and system:

Option 1: Leave it if it's immaterial

• If the discrepancy is persistent and explainable (e.g. rounding), and your policy allows for immaterial differences, simply document it and move on.
• Best practice: Include a note in your reconciliation:

“Reconciling difference of $0.01 due to rounding discrepancy between AR sub-ledger and GL. Reviewed and deemed immaterial.”

Option 2: Post a correcting journal

• If your organization requires zero variance, you can post a small rounding adjustment journal to align the GL and sub-ledger.
• Example:

Dr / Cr Trade Debtors          $0.01

   Dr / Cr Rounding Adjustment    $0.01

Option 3: Investigate before adjusting

If you're not sure why the 1-cent difference exists:

• Compare individual customer balances in the sub-ledger to supporting transactions.
• Check for:
  1. FX differences
  2. Partial payments
  3. Misapplied credits
  4. Manual journal entries
• This helps rule out a hidden larger error masked by a net small discrepancy.

FINAL RECOMMENDATION

• Keep your reconciliation transparent.
• Document any small discrepancies clearly (e.g. on your month-end working papers).
• Only adjust if your policy or internal controls require it.

* END *

end* END *

* END *

* END *