Location: Accounts Production module > Client Specific > Tasks > Trial Balance


Trial Balance is a bookkeeping worksheet in which the balances of all ledgers are compiled into debit and credit columns. A company prepares a trial balance periodically, usually at the end of every reporting period.



Under Tasks > Trial Balance, you will find a list of all the trial balances that have been created/imported into Capium. You can add/import a new trial balance by clicking on ‘+ Import Trial Balance’. As you click on this button the following pop-up appears:


Reference number of trial balance will create, by default, the sequence generated automatically. You can edit the reference as per your choice.

Name (if any) to be given to trial balance will come. Start date and End date for which trial balance is to be prepared will come. By default, the period of 12 months will be taken from the start date. Both of these dates are editable.

There are Five methods for importing trial balance:

  • Bookkeeping

  • CSV Import

  • Manual Entry

  • QuickBooks Online Import

  • Xero Import


Bookkeeping 

This will take the data from bookkeeping for the company for which report is to be prepared. 

When you click on ‘Import/Create’ tab a new page appears showing the trial balance containing balances of the ledgers with a total of Debit and Credit which is always equal unless there is an error. Nothing can be edited.


This option is suitable only for the clients whose bookkeeping is maintained.


CSV Import

This option is used to import the ledgers and its balances in CSV format stored on the Local Computer.


Manual Entry

You may create trial balance by selecting the manual option and clicking on ‘import/create’ tab.

  • A new page appears where the details of account ledgers and their balance are to be filled.

  • The new item can also be added by clicking on’ Add New Item’.

  • Once all the details are filled and the total of Debit and Credit are equal you may save it.

  • On saving, trial balance will be added to the list on the main page.


QuickBooks Online Import

This method allows you to directly import a Trial Balance from QBO. Upon importing those entries, you will need to map the Trial Balance according to Capium's Chart of Accounts


Xero Import 

This method allows you to directly import a Trial Balance from Xero. Upon importing those entries, you will need to map the Trial Balance according to Capium's Chart of Accounts


Click here for a walkthroug on how to prepare a set of Accounts 


Click here for a walkthroug on how to prepare a set of Accounts