Upload Initial Balances – A summary of the activity
You can upload initial balances from an external source. This external source could be an MS-Excel worksheet or an XML data sheet. This upload facility has been provided to save the time required for entering the initial balances in the case of voluminous data. This activity is used, based on the business requirements of the organization. You must have defined financial years / periods, the finance books and the account codes before the balances are uploaded to the system.
This page allows you to search and select a finance book, currency and the financial year / period for which you want to upload the initial balances. The system updates the “Completed” status with respect to the initial balance entry for the finance book. The uploaded initial balance is then posted as the opening balance for the finance book for the selected financial year / period.
What you can do in this activity
To save time for entering voluminous initial balance data can be uploaded from an external source. This external source could be an MS-Excel worksheet or it could also be an external source.
Go to “Upload Initial Balance” page.
Select the finance book and upload the details.