Page Comparison

Getting Started - Download the template

Importing trust receipts and payments is relatively easy. A standard layout is required and you can download the template from the import screen. 

...

How to complete the 'Receive Funds' template

The downloaded spreadsheet template will have headings which look like those in the screenshot below.  Some sample data has also been entered in this spreadsheet.

Image Removed

A brief explanation of each heading is set out below:

Account ID (Required): 

This is the ID from the very left hand side of the Actionstep accounts list in the Chart of Accounts.  

1. Tip
   title Go to the Chart of Accounts
   Accounting > Accounts > Accounts List

2. You will then see the Chart of Accounts.  The ID is on the left hand side as indicated in the screenshot below.  You are likely to be using '90' as the 'Trust Current' account in many pre-configured systems (as in the screenshot below), or you may have set up your own trust account.  Select the correct Account ID from this list to populate Field A in the above spreadsheet.

Image Removed

Received Date (Required): 

These don't all have to be the same date.  Dates must be in the format YYYY-MM-DD (eg 2012-06-21)

Action ID (Required):

This is the associated Action (or Matter) ID in Actionstep.  You will normally have created these when you imported your contacts and matters in an earlier import.  If you don't know these, you can connect the trust account data to these IDs after the import by using the Actionstep search function to find the correct Action ID.  If you do this, make sure you only choose the "Editable Upload" option in the Receive Funds (Bulk) screen (as per the screenshot below).  

Image Removed

Action External Reference:

This is usually the reference you used in your previous system and would usually have been used to import your matters into Actionstep previously.  It is not essential if you do not know it.

Payer ID (Required):

This is the contact ID from Actionstep.  One way to find this, would just search for the contact in the system, and then the ID will be displayed as in the screenshot below.  Alternatively you can export all of your contacts from the Contacts List in Actionstep, and then search through the exported list in a spreadsheet program such as Excel™.

Image Removed

Payer External Reference:

This is the name of the client and is optional.  You would not need this if you have already entered the "Action External Reference" or "Action ID" as above.

Payer Name (Required):

This is the contact name in Actionstep.

Amount (Required):

This is the amount or dollar value. 

Memo (Required):

This is journal memo.

Generate Receipt:

This won't generally be required if you are importing this data from another system.  Usually you would have generated the relevant receipts in the old system first, and will only be importing the opening balances into Actionstep.  However, if you wish to generate a receipt in Actionstep, put Y into this field. 

Receipt Number:

Optional.

Clear Payments:

Optional.

Payment Method (Required):

Cash, cheque, EFT etc.

Check Date (could also be called 'Cheque' Date depending on what part of the world you are in):

Again this is optional but refers to the date the check (cheque) was written.

Reference Type/Value 1, 2 etc.:

...