Load Trial Balance
This module enables the user to upload the trial balance of individual entities.
Once the TB is uploaded and on clicking of upload button, below steps needs to be handled,
Validate TB data:
Validation condition:
The trial balance should sum up to zero.
For a trial balance to sum up to zero, these are the sub validations the tool will check
The opening balance should sum up to zero
Debit + Credit should sum up to zero
The closing balance, which is calculated by the tool, should sum up to zero.
The formula for calculating closing balance is as follows:
Closing Balance = Opening balance + Debit + Credit
All the GL codes in the trial balance should be mapped in the COA GL mapping of that entity.
Once the validation has passed, uploaded data needs to be saved.
If the validation fails, it needs to notify the user on the screen.
The load trial balance page enables the user to upload a trial balance.
There are 3 steps to save the TB
Step 1 – Upload trial balance
The user can upload the trial balance in step 1.
Step 2 – Validate the TB
There are 2 steps for validation.
Step 1 – The trial balance should sum up to zero.
For a trial balance to sum up to zero, these are the sub validations the tool will check
The opening balance should sum up to zero
Debit + Credit should sum up to zero
The closing balance, which is calculated by the tool, should sum up to zero.
The formula for calculating closing balance is as follows:
Closing Balance = Opening balance + Debit + Credit
Step 2 – All the GL codes in the trial balance should be mapped in the COA GL mapping of that entity.
If there are any errors in the TB, then the tool will not allow the user to go on to the next step.
The user will be able to map the unmapped GL codes in the COA GL mapping page using “Map GL” link against the error.
The unmapped GL codes will be listed in the page for the user’s reference as well.
If the user wishes to abort the trial balance in Step 2, the same can be done using “Abort TB Upload” button.
The user can go from step 2 to step 1 and upload another trial balance in case if there are any errors.
If there are no errors, then the tool will directly navigate to step 3 and save the TB in the database.
Step 3 – Save TB
On successful validation, the user will be able to save the trial balance.
This page will also list the previous versions of the trial balance that are being saved.
The user will also be able to download any of the trial balances using “Download” button.
By default, the latest trial balance will be used in the financial statements.
Start date and end date – to be auto picked.
The start date and end date in the Load TB page has to be populated based on 3 conditions.
1. If the entity is acquired before the project start date and is not stop consolidated till the end date of the project, then the start and end date will be same as project period.
2. If the entity is acquired before the project start date and is stop consolidated before the project end date, then the start date will be the project start date and end date will be the stop consolidation date.
3. If the entity is acquired after the project start date, then the start date will be the date of acquisition/date of investment and the end date will be the project end date.
Last updated