To import a Trail Balance on Nomisma go to the Advisor Tools drop-down menu at the top of the client’s Bookkeeping dashboard and then select Trial Balance Entry. 

Click the CSV Sample button in the top right-hand corner to download the CSV template that will need to be populated and then be uploaded by first clicking the Choose File button, select the correct CSV file and then click Upload. 

There will be three columns within the CSV file: Ledger Code, Account Name and Balance. All Debits will appear as positive figures and all Credits will appear as negative figures within the Balance column. The ledger code can be any code that a previous system may have used but these will be mapped after being uploaded to Nomisma.  

You can also upload your own CSV file with a Ledger Code, Description, Debit and Credit columns and the system will be able to map these to the Trial Balance. 

Once the Trial Balance CSV file has been uploaded, map the CSV columns by selecting the correct options from the drop-down options under the Mapped With section to match with those on the CSV file.  

Then map the Account Codes by selecting the correct option from the drop-down menu under Account Code. Check that the correct Posting Date has been entered and then once all the mapping has been completed, click the Import button. Nomisma’s Trial Balance Memory feature will automatically recognise and apply the correct account codes for any similar future Trial Balance imports for a particular client. 

To locate the newly imported Trial Balance, go to Advisor Tools at the top of the page and select Journals. You are then able to make a copy, add any additional documents, edit or delete the Trial Balance within this page.