About Lesson
This lesson will teach on how to import the trial balance into the system.
For first time adoption of the package, users are required to upload 2 years:
- comparative trial balance (without decimal/rounded figure)
- current year trial balance (with decimal place)
Upload comparative year of trial balance
- Navigate to TB> Convert and Import Excel TB
- Click on +Add Record
- Select year end to be imported: 2021-12-31
- Accounting package: others
- Upload Comparative-year-tb into the system.
- Click Submit button.
- Assignment of Account Code, Account Description, Debit & Credit of the column.
- You may click Round Up Figure check box to remove decimal place.
- Assignment of account type for each of the trial balance item.
Upload current year of trial balance
- Same method as comparative year trial balance but just have to select different year end upon uploading
Year end: 2022-12-31
Microsoft excel file: current-year-tb
Exercise Files