Balance Carry-Forward and Closing Fiscal Year
Hello All,
With this blog, I would like to outline the Process of executing Balance carry forward and Closing year.
To close year, Below Prerequisites must be fulfilled.
– The preceding fiscal year is closed.
– You have performed a depreciation run for the fiscal year.
– You have performed balance carry-forward for the year.
You perform balance carry forward as the last phase of year-end closing, which usually means that you do this in the new fiscal year. The opening balances of the balance sheet accounts need to have been posted at this point.
Balance carry-forward transfer the Balance of G/L account from one year to next year. This will ensure that Net profit/Loss is correctly reported in the balance sheet.
The balance sheet accounts and the profit and loss accounts are carried forward as follows:
- The balances of the balance sheet accounts are carried forward into the next fiscal year. This ensures that the closing balances of the balance sheet accounts in the fiscal year being carried forward are the same as the opening balances in the new fiscal year. i.e Closing balance of G/L for year FY = Opening balance of G/L for year FY+1
- The balances of the profit and loss accounts are cumulated and transferred to the corresponding balance sheet account for annual net profit or loss. This ensures that closing balances and opening balances of the profit and loss accounts are always zero.
To make the opening balances of G/L accounts available before balance carry forward is completed, you need to perform balance carry forward in two steps:
Step 1: Carry the G/L account balances forward
This accomplishes the following:
- The balances of the balance sheet accounts are carried forward to the same accounts in the new fiscal year.
- The balances of the profit and loss accounts are cumulated and transferred to the income statement closing account. This ensures that the closing and opening balances of the profit and loss accounts are zero.
Once you have completed Step 1, you can continue to make postings to the fiscal year being carried forward. However, be aware that such postings increase the number of journal entries that need to be carried forward because change documents have to be posted in addition to the journal entries themselves. Change documents update the closing balances in the fiscal year being carried forward and the opening balances of the affected G/L accounts in the new fiscal year.
Step 2: Calculate and carry forward profit/loss
This step is the last activity in your balance carry forward process. You perform this step after all postings to the fiscal year to be carried forward have been made.
You can only perform this step once you have completed Step 1 in an update run.
Step 2 posts the balance of the income statement closing account to the balance sheet item Equity either of the annual net profit account or the annual net loss account, depending on whether it is a debit or credit balance at the company level. The balance of the annual net profit account or of the annual net loss account is then carried forward to the new fiscal year.
In order to execute the Balance carry-forward in
Step 1 – Last allowed step for period 012 in year should be 990 – Closing balance or higher (i.e 990 or 991)
Step 2 – Last allowed step for period 012 in year should be 991 – Profit and loss calculation of retained earnings and First allowed step for the period 001 in next year must be 001 – Opening balance.
You can find more information about the different closing steps and its use in the help center document : Closing Steps
After Performing Both the steps in update mode, you can block the period 012 by following below steps
- General ledger work center
- Set of books and assigned companies view
- Click on Open and close period
- Select the row
- Click on Close period
- Click on Save
Now You can close the fiscal year.
- General ledger work center
- Set of books and assigned companies view
- Click on Edit Fiscal Year
- Select the row
- Click on Close Year
- Click on Save
Regards,
Harshal
Hi Harshal,
This is a very helpful blog. Can you please tell me if there is a way in ByDesign to post transactions to a previously closed financial year, after the balance carryforward runs were posted? There are some exceptional situations when client wants to recalculate and re-post the retained earnings. How can this be achieved in ByDesign?
Thank you,
Sebastian
Hi Sebastian,
You need to again reverse the balance carryforward in a method that
Reverse step 2 first then followed by step 1 of balance carry forward.
Then post the transactions which are pending.
Let me know if you need further information.
Thanks
Lokesh Sharma
Hi Lokesh,
Since the GL Account balances migration does not support for "Closing balances of G/L accounts" GL Type OCLSBS - Opening or closing - balance sheet" So do we need to consider a different GL and upload and after imported into SAP ByD do we need to run the Balance Carry forward for getting the same effecting the account for closing balances?
Please guide.
Thanks,
Very informative article. I'd a query though. I found a difference in one of the ledgers which is because of difference in Opening Balance of that ledger. CAn you tell me how is this possible.