Explanation of why the opening balance appears within transactions instead of in the opening balance field in reports, as the appearance of the balance depends on the entry date compared with the report start and end date. The system follows the following rule:
-
An entry whose date is before the report start date appears as an opening balance.
-
An entry whose date falls within the specified report period appears within the transactions.
Illustrative Example
-
An entry dated 31-12-2023
-
If you generate a report starting from 1-1-2024 → the entry appears as an opening balance.
-
If you generate a report starting from 31-12-2023 → the entry appears within the transactions.
-
-
For the entry dated 31-12-2023 to appear as an opening balance, you must generate the report from the date 1-1-2025
Rule Summary
-
Every entry older than the report start date = opening balance.
-
Every entry within the report period = transaction.
Simple Solution for the Entry to Appear as an Opening Balance Instead of a Transaction
-
Set the report period to start after the entry date, or edit the entry date so it is before the report start date you want to extract.
-
Generate the report (account statement or trial balance).
-
Verify that the entry appears in the opening balance section and not within the transactions.
Search Keywords:
How do I make the opening balance appear as the beginning-of-period balance and not as a regular entry transaction in the trial balance in Qoyod?