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

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 include 2017,2018,2019 entries.





As At : Include all entries up to the specified date.
If the Till date is set to 31 Dec 2018, the As At filter will include all dates up to 2018.




Period: Include only entries that fall within the specified date range.
If the From date is 01-Jan-2018 and Till date is 31-Dec-2018, then the period filter will only include 2018 period.




When generating Trial Balance,
you have to consider that the date filter you select affects the values.
eg. if i generate a Trial Balance using a 'As At' date filter.
this will include all values till the date specified.



this will have an impact on 'P&L' accounts, as this report will include earlier periods.
If you have done year end closing for each of your earlier periods, then the earlier periods P&L values would have been moved to the retained earnings account.
The Trial Balance will match up with P&L report (P&L report is created using a period date filter).
If no year end closing was done, then the earlier periods values would be still be in the P&L accounts and hence included when you generate the report using the 'As At' date filter.



    • Related Articles

    • Why is Current Profit/Loss at Balance Sheet different from Profit/Loss report

      Commonly when there is a difference in the P&L and BS this usually indicates that Year end closing was not done for a period. (note this may apply to multiple periods) Adjustments were made after year end closing was done. ( note this also can apply ...
    • 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' ...
    • 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 ...
    • 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 ...