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

• Opening General Ledger

  Reference the figures of the Trial Balance to enter the Debit/Credit balance of every account, except for Trade Debtors, Trade Creditors and Stock accounts. If users are performing Opening Entry after having passed the decided Opening Date, any ...

• GST F5 values and Trial 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 ...

• 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 ...

• Setting Up Opening Balance

  ENTERING OPENING BALANCE Opening GL, Sales Invoices, Supplier Invoices & Stock As you have not started your business yesterday, you are already operating with balances in your accounts. These need to be brought forward to system. First you have to ...

• 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 ...