The following can be imported as CSV file:
How to Import Accounts
Template: account_import.csv. Each row creates a chart-of-accounts account.
Field Name | Data Type | Required | Import Rules |
Name | Text | Required | Also accepts Account Name. At least 2 characters. Unique among active accounts. |
Category Type | Fixed list | Required | Also accepts Category. Exactly one of Assets, Bank, Credit Card, Equity, Expenses, Income, Trust, Liabilities, Other (case-sensitive). Any other value fails the row as blank. |
Category Sub Type | Fixed list | Optional | Also accepts Category Subtype, Sub Category Type, Sub Category. Must exactly match a sub type label, for example Assets: Accounts Receivable (A/R), and belong to the row's Category Type. A value that doesn't match is left blank. |
Number | Text | Optional | At least 4 characters. Unique among active accounts. |
Bank Account Number | Text | Optional | Also accepts Account Number. Required when Category Type is Bank or Trust. |
Parent Account Number | Lookup | Optional | Matched by number. The parent must have the same Category Type. |
Bank Routing Number | Text | Optional | Also accepts Routing Number. Required when Category Type is Bank or Trust. |
Opening Balance Amount | Currency | Optional | Also accepts Balance, Opening Balance, Opening Balance Amount Cents. Blank is 0. Also sets the account's current balance. |
Opening Date | Date | Optional | Also accepts Date. Blank is the date of the import. Can't be changed after the account is created. |
Description | Text | Optional | Also accepts Account Description. Unique among active accounts. |
Trust Liability Account | Lookup | Optional | Also accepts Liability Account. Used only for Trust accounts. Matched by name to a Liabilities account, which can be earlier in the same file. Blank links account 10019, Client Trust Liability. |
How to Import Account Settings
Template: account_setting_import.csv. Each row sets the default accounts for a matter, a contact or the firm.
If Matter is filled in, the row sets that matter's accounts.
Otherwise, if Contact is filled in, the row sets that contact's accounts.
Otherwise, the row sets the firm's accounts.
A matter, contact or the firm has one set of account settings. A row for a target that already has settings updates them.
Field Name | Data Type | Required | Import Rules |
Matter | Lookup | Optional | Also accepts Matter Number. Matched by number. |
Contact | Lookup | Optional | Also accepts Contact Number. Matched by number. Used only when Matter is blank. |
Accounts Payable Account | Account lookup | See note | Liabilities account |
Accounts Payable Paid Account | Account lookup | See note | Assets account |
Accounts Payable Pay When Paid Account | Account lookup | See note | Assets account |
Accounts Receivable Account | Account lookup | See note | Assets account |
Billed Fees Account | Account lookup | See note | Income account |
Checking Account | Account lookup | See note | Bank account |
Credit Card Processing Fees Account | Account lookup | See note | Expenses account |
Client Refund Account | Account lookup | See note | Liabilities account |
Firm Expense Account | Account lookup | See note | Expenses account |
Hard Costs Account | Account lookup | See note | Expenses account |
Interest Account | Account lookup | See note | Income account |
Operating Account | Account lookup | See note | Bank account |
Owners Equity Account | Account lookup | See note | Equity account |
Soft Costs Account | Account lookup | See note | Income account |
Trust Asset Account | Account lookup | See note | Trust account |
Unallocated Funds Account | Account lookup | See note | Income or Liabilities account |
Unbilled Client Cost Advanced Account | Account lookup | See note | Assets account |
Undeposited Funds Account | Account lookup | See note | Assets account |
Write Offs Account | Account lookup | See note | Expenses account |
Each account column is matched by name, only among accounts of the category shown.
Note: when a row creates new settings, all 19 account columns must match an account. When a row updates existing settings, a blank cell keeps the current account.
Import after: Accounts, plus Matters or Contacts when used.
How to Import Sales Taxes
Template: sales_tax_import.csv.
Field Name | Data Type | Required | Import Rules |
Name | Text | Required | Unique within the firm. |
Rate | Decimal | Required | Greater than 0 and at most 100. |
Apply By Default | Yes/No | Optional | Blank is No. |
Active | Yes/No | Optional | Blank is No. |
Start Date | Date | Optional |
|
End Date | Date | Optional |
|
Vendor | Lookup | Required | Matched by name. The vendor must be marked as a tax agency ("must be a tax agency"). |
Liability Account | Lookup | Required | Matched by name. |
Import after: Vendors, Accounts.
