Overview: Firms working with clients without an accounting software file may need to import their bank statements or transactions into an Active Ledger dataset. This guide outlines the available options for handling this cashbook use case.
Please refer to the Glossary for definitions of key terms used in this article.
Creating a Cashbook job in Active Ledger
Active does not support direct import of bank statements or bank transactions. However, you can manually enter individual bank transactions as journal entries in a dataset if necessary. A more efficient approach is to create and maintain an Excel template to record bank transactions, then use these transactions to generate a trial balance within the same Excel template. You can then import that trial balance into Active using the Excel source option. Please refer to the help article on importing a trial balance from Excel.
How to import a trial balance in a dataset using Excel
The ‘how to set up a cashbook job module’ in the Active Ledger Essentials course also provides more information around this https://training.businessfitness.com.au/p/active-ledger-and-reporting-essentials
A sample Excel template is also included below to assist you.