Introduction
Looking for an easier way to get a batch of invoices entered?
You can now import a spreadsheet of invoice information into a new A/P batch.
Table of Contents
Where Is It Found
File Format
Column | Contains | Comments |
A | Vendor # | Required on every line |
B | Invoice # | Required on every line |
C | Invoice Date | Required for new invoices. MM/DD/CCYY or MMDDYY format |
D | Invoice Amount | Required for new invoices. |
E | Invoice Description |
|
F | Hold Status | WD (when due) / NC (next check) / WS (when scheduled) |
G | G/L Account | When blank, system will pull vendor default account or APG. |
H | Distribution Amount | When blank, system will assume Invoice Amount. |
I | Distribution Description |
|
J | Scheduled Due Date | Only for scheduled payments (Hold Status WS) |
K | Scheduled Amount Due | Only for scheduled payments (Hold Status WS) |
L | Check Date | Manual Check batches: required on 1st line of invoice |
M | Check ID | Manual Check batches: required on 1st line of invoice. Up to 6 digit check number or full 12 digit e-payment id. Checking account code (CKA) per batch header. |
N | Check Amount Paid | Manual Check batches: required on 1st line of invoice. |
O | Discount Taken | Manual Check batches: optional. |
Note: A manual check batch may not have scheduled payments (due date and amount due fields) imported.