How to import Operating Transactions

Overview: This will walk you through the steps to import your Operating Account Transactions from Excel into TrustBooks. 

Step 1. Start on the Dashboard Page select MISCELLANEOUS and IMPORT DATA

Step 2. This will open the Start Import Data Steps Page. Select Import Operating Account Transactions from the drop down. Under the Chart of Account Drop down select the Operating Bank Account you want to use and choose the file you want to import. Then select Next.

Step 3. The Map the Data page will appear. Match the columns from your spreadsheet that you imported with the corresponding fields in TrustBooks.

Step 4. Review the data and select the correct Chart of Accounts for the transaction. 

Step 5. Select the check box to the left of the transactions to import and select Import Data 

Step 6. You will receive an email once the import is complete. You can confirm that the items were imported by clicking  on the LEDGER on the Dashboard Page. This example is called Operating Bank Account.