How to import Trust Account Transactions from an Excel Spreadsheet

Overview: This will walk you through the steps on how to import your Trust Account Transactions from an excel spreadsheet. Click here for the TrustBooks Template Import File. Import Template File

Note: The headings on the template file are listed below:

Date- Date of Transaction

Client - Client Name

Matter- Matter Name

Transaction - Transaction Number or Check # associated with the transaction

Payee- Who the transaction is paid too

Memo/Description- Notes or memos on the transaction

Amount- Positive number for a deposit and negative number for a payment 

Step 1: Start on the Dashboard page and select MISCELLANEOUS and then Import Data

Step 2: This will open up the Start Import Data Steps Page. Select Import Trust Account Transactions from the drop down and the Trust Account you want to import too. 

Step 3: Choose the excel file you want to import the information from into TrustBooks and select NEXT.

Step 4: From the drop list under each header map the data from your spreadsheet to match the fields in TrustBooks and select NEXT

Step 5: Review your data and select the check mark next to the items you want to import over.  Then select IMPORT DATA 

Note: You can select the top check box next to Date to select all items at once in the list.

Step 6. Congrats you have imported your transactions in! you can confirm everything has been entered in by clicking on the Trust Account Name on the Dashboard and opening up the View Trust Account page.