The following can be imported as CSV file:
How to Import Vendor Invoices (Invoices Only)
Template: vendor_invoice_import.csv. Each row creates a vendor invoice without lines. The bill amount stays 0 until lines are imported. Status starts as invoiced.
Field Name | Data Type | Required | Import Rules |
Description | Text | Optional |
|
Vendor | Lookup | Required | Also accepts Vendor Name. Matched by name. |
Number | Text | Required |
|
Invoice Date | Date | Required | Also accepts Date. |
Due Date | Date | Required | On or after Invoice Date. |
Skip Accounting | Yes/No | Optional | Blank is No. When Yes, the invoice's lines don't post to the general ledger. |
Import after: Vendors, Accounts.
How to Import Vendor Invoices (Lines Only)
Template: vendor_invoice_line_import.csv. Each row adds a line to an existing vendor invoice.
Field Name | Data Type | Required | Import Rules |
Vendor Invoice Number | Lookup | Required | Also accepts Number. Matched by number. |
Amount | Currency | Required | Also accepts Amount Cents. Greater than 0. |
Debit Account | Lookup | Required | Also accepts Debit Account Name. Matched by name. |
Description | Text | Optional |
|
Location | Lookup | Optional | Also accepts Location Name. Matched by name. With general ledger allocations off, blank uses the firm's default. With them on, blank fails the row. |
Division | Lookup | Optional | Also accepts Division Name. Same rules as Location. |
Expense | Lookup | Optional | Also accepts Expense Number. Matched by number. An expense can be on only one vendor invoice line. |
After each batch, each invoice's bill amount is set to the total of its lines.
With accounting on, each line credits Accounts Payable and debits the Debit Account, dated the invoice date, unless the invoice has Skip Accounting.
Can't run while a Vendor Invoices import is in progress.
Import after: Vendor Invoices, Accounts, and Locations, Divisions and Expenses when used.
How to Import Vendor Invoices (Invoices & Lines)
Template: full_vendor_invoice_import.csv. The file is split into invoices and lines, which follow the two sections above.
Column | Used for |
Number | The invoice number, and the invoice each line belongs to |
Vendor, Invoice Date, Due Date, Skip Accounting | The invoice |
Description | Both. The invoice uses the first row's value; each line uses its own. |
Line Amount | The line's Amount |
Debit Account, Location, Division, Expense | The line |
Column names must match exactly. Invoice values come from the first row with each Number. Every row becomes a line.
If any invoice row fails, the lines file isn't processed and shows "The invoices import failed, so this file was not processed. Fix the invoices errors and re-run the import."
How to Import Recurring Vendor Invoices (Invoices Only)
Template: recurring_vendor_invoice_import.csv. The importing member is recorded as the creator.
Field Name | Data Type | Required | Import Rules |
Number | Number | Required | Unique within the firm. |
Name | Text | Required |
|
Frequency Type | Fixed list | Required | daily, weekly or monthly. Not case-sensitive. |
Frequency Interval | Number | Required | Greater than 0. |
Status | Fixed list | Required | active or inactive. Not case-sensitive. |
Start Date | Date | Required |
|
End Date | Date | Required | After Start Date. |
Vendor | Lookup | Required | Matched by name. |
Days of Week | List | Optional | Comma-separated day names. Unrecognized names are dropped. |
Days of Month | List | Optional | Comma-separated numbers 1–31. Other values are dropped. |
A Frequency Type or Status outside the list fails the whole import, not just the row.
Import after: Vendors.
How to Import Recurring Vendor Invoices (Lines Only)
Template: recurring_vendor_invoice_line_import.csv.
Field Name | Data Type | Required | Import Rules |
Recurring Vendor Invoice Number | Lookup | Required | Also accepts Recurring Vendor Invoice, Number. Matched by number. |
Amount | Currency | Required | Also accepts Amount Cents. Greater than 0. |
Debit Account | Lookup | Required | Also accepts Debit Account Name. Matched by name. |
Description | Text | Optional |
|
Location | Lookup | Optional | Also accepts Location Name. Matched by name. Blank uses the firm's default. Required when general ledger allocations are on. |
Division | Lookup | Optional | Also accepts Division Name. Matched by name. Blank uses the firm's default. Required when general ledger allocations are on. |
Can't run while a Recurring Vendor Invoices import is in progress.
Import after: Recurring Vendor Invoices, Accounts.
How to Import Recurring Vendor Invoices (Invoices & Lines)
Template: full_recurring_vendor_invoice_import.csv. The file is split into invoices and lines, which follow the two sections above.
Column | Used for |
Number | The invoice number, and the invoice each line belongs to |
Name, Vendor, Frequency Type, Frequency Interval, Status, Start Date, End Date, Days of Week, Days of Month | The invoice |
Line Amount | The line's Amount |
Debit Account, Description, Location, Division | The line |
Column names must match exactly. Invoice values come from the first row with each Number. Every row becomes a line.
If any invoice row fails, the lines file isn't processed.
How to Import Vendor Payments
Template: vendor_payment_import.csv. Each row creates a vendor payment. The importing member is recorded as the creator. Payments aren't applied to invoices here; use Vendor Payment Allocations.
Field Name | Data Type | Required | Import Rules |
Number | Number | Required | Also accepts Payment Number. Unique within the firm. |
Payment Date | Date | Required | Also accepts Date. |
Account | Lookup | Required | Also accepts Account Name. Matched by name. Must be a Bank account. |
Vendor | Lookup | Required | Also accepts Vendor Name. Matched by name. |
Amount | Currency | Required | Also accepts Amount Cents. Greater than 0. |
Skip Accounting | Yes/No | Optional | Blank is No. When Yes, the payment's account transaction isn't created and its allocations don't post to the general ledger. |
Import after: Vendors, Accounts.
How to Import Vendor Credits
Template: vendor_credit_import.csv. Each row creates a vendor credit.
Field Name | Data Type | Required | Import Rules |
Memo | Text | Optional |
|
Cash | Yes/No | Optional | Blank is No. When the credit is allocated, Yes posts against the firm's Checking account; No posts against Firm Expense. |
Number | Number | Required | Unique within the firm. |
Vendor | Lookup | Required | Also accepts Vendor Name. Matched by name. |
Transaction Date | Date | Required | Also accepts Date. |
Amount | Currency | Required | Also accepts Amount Cents. Greater than 0. |
Skip Accounting | Yes/No | Optional | Blank is No. When Yes, the credit's account transaction isn't created and its allocations don't post to the general ledger. |
Import after: Vendors.
How to Import Vendor Payment Allocations
Template: vendor_payment_allocation_import.csv. Each row applies part of a vendor payment to a vendor invoice.
Field Name | Data Type | Required | Import Rules |
Vendor Invoice Number | Lookup | Required | Also accepts Vendor Invoice. Matched by number. |
Vendor Payment Number | Lookup | Required | Also accepts Vendor Payment. Matched by number. |
Allocation Amount | Currency | Required | Also accepts Amount. Greater than 0. |
Invoice limit, per row. An invoice's allocations can't exceed its bill amount ("Allocation amount exceeds the bill amount").
Payment limit, whole file. After all rows are saved, if any payment's allocations exceed its amount, every row from the file is removed and the import fails with "Allocation amounts cannot exceed the vendor payment amount".
On success, invoice statuses are updated to invoiced, partially paid or paid, and each payment's allocated amount is updated.
With accounting on, each allocation credits the payment's account and debits Accounts Payable, dated the payment date, unless the payment has Skip Accounting.
Can't run while a Vendor Payments import is in progress.
Import after: Vendor Invoices with lines, Vendor Payments.
How to Import Vendor Credit Allocations
Template: vendor_credit_allocation_import.csv. Each row applies part of a vendor credit to a vendor invoice.
Field Name | Data Type | Required | Import Rules |
Vendor Invoice Number | Lookup | Required | Also accepts Vendor Invoice. Matched by number. |
Vendor Credit Number | Lookup | Required | Also accepts Vendor Credit. Matched by number. |
Allocation Amount | Currency | Required | Also accepts Amount. Greater than 0. |
Invoice limit, per row. An invoice's allocations can't exceed its bill amount.
Credit limit, whole file. If any credit's allocations exceed its amount, every row from the file is removed and the import fails with "Allocation amounts cannot exceed the vendor credit amount".
With accounting on, each allocation credits Accounts Payable and debits Checking (Cash = Yes) or Firm Expense (Cash = No), dated the credit's Transaction Date, unless the credit has Skip Accounting.
Can't run while a Vendor Credits import is in progress.
Import after: Vendor Invoices with lines, Vendor Credits.
How to Import Check Request Templates
Template: check_request_type_import.csv. Reviewers aren't part of this import.
Field Name | Data Type | Required | Import Rules |
Name | Text | Required | Up to 255 characters. Unique within the firm. |
Account | Lookup | Required | Matched by name. The account must have a routing number and an account number. |
Location | Lookup | Required | Matched by name. |
Import after: Accounts, Locations.
How to Import Check Requests
Template: check_request_import.csv. The importing member is recorded as the creator. Location is copied from the check request template.
Field Name | Data Type | Required | Import Rules |
Number | Number | Required | Unique within the firm. |
Description | Text | Optional | Up to 2,000 characters. |
Amount | Currency | Required | Greater than 0. |
Check Request Template | Lookup | Required | Also accepts Check Request Type. Matched by name. |
Vendor | Lookup | Required | Matched by name. |
Status | Fixed list | Required | Awaiting Review, Rejected or Approved. |
Invoice Date | Date | Required |
|
Due Date | Date | Required |
|
Term Days | Number | Optional |
|
Vendor Invoice Number | Text | Optional |
|
The importing member can't be a reviewer on the selected template, or the row fails.
After each batch, each request gets one reviewer record per template reviewer, with the imported Status.
Import after: Check Request Templates, Vendors.
