Trial Balance/General Ledger values not matching with Ageing values.

Trial Balance/General Ledger values not matching with Ageing values.

When comparing the Trial Balance values against Ageing, we are looking at the Trade Debtor/Creditor accounts.

Ageing Report
In order for the report to generate values, the Trade Debtor/Creditor accounts needs to have the following information.
'Who' , 'How much' , 'How long'

'Who' this is the Business Partner. the Trade Debtor/Creditor account needs to have a BP. So that the system can identify
who owes your or who you owe.

'How much' this is the document, with the document you will know the values of what is owed.

'How long' this is also the document, the document has a due date.

when you use the AP/AP modules these information is required. you cannot complete the transaction without specifying those information.

Journal Entry Module
The JE allows you to create entries into the GL.
The module does not have a lot of restriction as it is meant for advance usage.
In JE you can directly affect the Trade Debtor/Creditor without the 'Who','How long'.
This is where the difference between GL values and Ageing value start.

The first step is to identify the transactions. (the example will be base on the Trade Debtor)

Step 1.

Using the GL module.
Select the date filter to Balance.
Select the account filter to Trade Debtor account
Select the Document type filter to only Journal Entry.



the documents that appear are the documents where the Trade Debtor account is affected.

Next go through the entries. Verify that each entry that affects the Trade Debtor account has the required information specified.

Step 2.
Edit the JE.
AT the Trade Debtor account entry, verify the following.
Business Partner is selected.
Type has a value.
Document has a value.


If all three columns have values the entry has been done correctly.
Please note there maybe multiple entries affecting the Trade Debtor account in the document, check each row.


    • Related Articles

    • Date range in Trial Balance, Balance Sheet and P&L

      When generating reports in the system the date range filters affect the values you generate. Our system has the following range filters. Balance:  Include all entries till today's date. If today's date is in 2019. when i select balance filter it will ...
    • GST F5 values and Trail Balance/GL

      F5 values may not match up with what the values from the TB or GL. this due to the values included in the F5. Entries that go into the F5. New transaction that have been created with the post date in the current period. New transaction that have been ...
    • Drill Down Function

      4.3 FINANCIAL REPORTS 4.3.1 Drill Down Function Location Action Remark Report> Trial Balance  Click REPORT activity  Click FINANCIAL  Click TRIAL BALANCE module At Trial Balance: This will trigger the General Ledger to pop-up.  ...
    • Intercompany Trading Setup for Balance Sheet / Trial Balance

      This setup for for companies that: participate in trading within its own group of companies (subsidiaries, sister company, parent organisation etc.), and need to generate Balance Sheet and Trial Balance reports that separate Debtor and Creditor ...
    • Viewing Transaction GL Entries

      4.1 DETAILS TRACING 4.1.1 Viewing Transaction GL Entries General Ledger (GL) entries can be found in all the modules in Sales and Purchases activities, except for Quotation, Delivery Order and Purchase Order Module Location Action Remark SALES> ...