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.
