Skip to main content

Finance Pro - Import Accounts and Account Settings

Finance Pro - Import Accounts and Account Settings

K
Written by Keith Bell

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.

Did this answer your question?