You can import a Trial Balance into the Accounts Production module using a CSV file using the steps below:


Step 1: Navigate to the Trial Balance section

Navigation: Accounts Production > Client > Tasks > Trial Balance > + Trial Balance > Mode of Import: CSV


See below for reference:


Step 2: Download and complete the CSV template

Once you select CSV as the import mode, you will be prompted to Download the Template file. Use this template to populate your Trial Balance transactions before importing the file.


Before completing the template, we recommend exporting the Capium default Chart of Accounts (COA)  as reference when populating the file.


See below for reference:


After importing the Trial Balance using the 'Create' button, you will need finalise the mapping in the below screen, then click confirm to complete the Import.


Step 3: Import the Trial Balance

Once you have completed the CSV template:

  1. Upload the completed CSV file.
  2. Click Create to import the Trial Balance.
  3. You will then be taken to the Mapping screen.
  4. Review and finalise the account mapping.
  5. Click Confirm to complete the import.


See below for reference:


Important: Make sure the account mapping is reviewed carefully before clicking Confirm, as this determines how the imported Trial Balance balances are assigned within Accounts Production.



Additional Help

Need Help?

If you need assistance or guidance, please contact your onboarding manager or email Support@capium.com, or call us on 020 3322 5578.