This error occurs due to inconsistencies with brought forward balances relating to the asset codes
(nominal codes 601-678.02).
The Check B/fwd Balances Tool in the nominal ledger will help identify which codes are causing the
issue.
The B/fwd checker will check all b/fwd codes, but to resolve this format error you only need to look
specifically at the asset codes (601-687.02).
The B/fwd checker will show the following:
- Year - The year the issue relates to
- Actual - This is the actual amount posted in the nominal ledger for that particular code
- Expected - This is the amount the system expects to see based on last year’s posting, so based on this example, it is basing it of the total balance of 661+661.01+661.02+661.03+661.04+661.06 in the comparative year.
- Difference - This is the difference between the actual and the expected amount
An example shows the actual amount is 150 but the expected amount is 100.
From looking at the code 661 in the nominal ledger it shows a posting of 100 in the comparative year
and a posting of 150 in the current year. The issue is occurring because last year’s closing balance (100)
does not equal to this year’s opening balance (150).
Equation: 661+661.01+661.02+661.03+661.04+661.06 in the comparative year = 661 in the current year
Based on this, the client will need to decide if they should adjust either the current year postings or their comparative year postings to resolve the issue.
If they want to adjust the current year figures, they will need to post a journal adjustment. If they want
to adjust the comparative year postings, they will need to do this through the Comparatives option in the
Nominal Ledger.
In this example an addition of 50 has been posted to 661.01 in the comparative year to resolve the error.