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.
Completing a cashbook job
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 Ledger using the Excel source option.
Refer to the following support article for more information: โHow to import a trial balance in a dataset using Excel, as well as the How to set up a cashbook job module in the Active Ledger Essentials course.
๏ปฟโ
You may also wish to use the below template if you are preparing a basic cashbook job.