Skip to main content

Finance Pro - Import Accounts Payable Data

Finance Pro - Import Accounts Payable Data

K
Written by Keith Bell

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.

Did this answer your question?