Skip to main content

Finance Pro - Import Banking Data

Finance Pro - Import Banking Data

K
Written by Keith Bell

The following can be imported as CSV file:

How to Import Deposits

Template: bank_deposit_import.csv. Each row creates a bank deposit. The importing member is recorded as the creator. The deposit total comes from its deposit lines.

Field Name

Data Type

Required

Import Rules

Number

Number

Required

Unique within the firm. A duplicate number fails every row in its batch of 1,000 with a database error.

Date

Date

Required

Account

Lookup

Required

Matched by name. Must be a Bank or Trust account.

  • Import after: Accounts.

How to Import Deposit Lines

Template: bank_deposit_line_import.csv. Each row adds a payment or receipt to a deposit. There is no amount column; the amount comes from the payment or receipt.

Field Name

Data Type

Required

Import Rules

Bank Deposit Number

Lookup

Required

Matched by number.

Payment Number

Lookup

See note

Matched by number. Used when filled in, even if Receipt Number is also filled in. A payment made with a credit memo (write-off) payment method can't be deposited.

Receipt Number

Lookup

See note

Matched by number. Used only when Payment Number is blank.

Memo

Text

Required

  • Note: Each row needs a Payment Number or a Receipt Number.

  • A payment or receipt can be on only one deposit line.

  • With accounting on, each line debits the deposit's account and credits Undeposited Funds, dated the deposit date. The deposit total is updated and the payment or receipt is marked deposited.

  • Import after: Deposits, and Payments or Receipts.

How to Import Bank Transactions

Template: bank_transaction_import.csv. Each row creates a bank transaction with source Imported and status Uncleared. Bank transactions don't post to the general ledger.

Field Name

Data Type

Required

Import Rules

Name

Text

Required

Category

Text

Optional

Free text.

Amount

Currency

Optional

Blank is 0.

Date

Date

Required

Account

Lookup

Required

Also accepts Account Name. Matched by name.

  • Import after: Accounts.

How to Import Receipts

Template: receipt_import.csv. Skip Accounting isn't importable for receipts.

Field Name

Data Type

Required

Import Rules

Number

Number

Required

Also accepts Payment Number. Unique within the firm.

Date

Date

Required

General Ledger Account

Lookup

Required

Matched by name. The account credited when the receipt posts.

Payment Method

Lookup

Required

Matched by name.

Amount

Currency

Required

Greater than 0.

Reference

Text

Optional

Up to 50 characters.

Description

Text

Optional

Up to 255 characters.

Note

Text

Optional

Up to 500 characters.

Payor

Lookup

Optional

Matched by name to a contact.

Division

Lookup

Optional

Matched by name. Blank uses the firm's default. Required when general ledger allocations are on.

Location

Lookup

Optional

Matched by name. Blank uses the firm's default. Required when general ledger allocations are on.

  • With accounting on, each receipt credits the General Ledger Account and debits Undeposited Funds.

  • Import after: Accounts, Payment Methods, and Contacts, Divisions and Locations when used.

Did this answer your question?