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 to
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 to.
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! 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.