The Accounts Payable Transaction Import reads an Excel file that you specify and then imports each row of that file as unposted transactions.
NOTE: This option can also be accessed from Manage > Unposted Transactions.
- Select Import Transactions.
- File Name: Click Choose File. Browse to the folder where the file is located and select the file to import.
- Click Import to continue or Cancel to return to the Transactions page.
File Layout:
The order of the columns below does not matter, but the first field in each column must contain the descriptions listed below.
Required columns are shown with an asterisk (*). However, only the account structure levels that you are using need to be specified. For example, if you are only using funds and departments in your chart of accounts, you only need to specify "FundNumber" and "DepartmentNumber" columns in your Excel file. Also, the AccountSub field only needs to be specified if you are using Sub-Accounts.
- CompanyNumber*
- Vendor* (duplicate Vendor and Invoice# creates 1 invoice with multiple detail lines)
- InvoiceDate*
- RegionNumber*
- SuperFundNumber*
- FundNumber*
- LocationNumber*
- CostCenterNumber*
- DepartmentNumber*
- AccountNumber* (expense account)
- AccountSub*
- Description*
- Amount*
- Type
- “I” or [blank] = Invoice
- “Q” = Quick Check
- “M” = Manual Check (requires two additional columns: PaymentDate and CheckNumber)
- “A” = Adjustment
- “E” = Electronic Funds Transfer (requires two additional columns: PaymentDate and ConfirmationNumber)
- “S” = Send EFT to Manage Payments
- Invoice#
- DueDate
- Project (project number)
- Campaign
- BoxOn1099 (use “short name” from table below)
- Note
NOTE: The header names are case-sensitive (e.g., “date” or “DATE” will not work, must be “Date”).
List of 1099 options:
| Short Name | Description |
| Int | Interest |
| Box 1 | Misc. Box 1 - Rents |
| Box 2 | Misc. Box 2 - Royalties |
| Box 3 | Misc. Box 3 - Other Income |
| Box 4 | Misc. Box 4 - Federal Income Tax Withheld |
| Box 5 | Misc. Box 5 - Fishing boat proceeds |
| Box 6 | Misc. Box 6 - Medical and health care payments |
| Box 8 | Misc. Box 8 - Substitute payments in lieu of dividends or interest |
| Box 10 | Misc. Box 10 - Gross proceeds paid to an attorney |
| Box 13 | Misc. Box 13 - Excess golden parachute payments |
| Box 14 | Misc. Box 14 - Nonqualified deferred compensation |
| Box 15 | Misc. Box 15 - State Tax withheld |
| NEC 1 | NEC Box 1 - Nonemployee compensation |
| NEC 4 | NEC Box 4 - Federal Income Tax withheld |
| NEC 5 | NEC Box 5 - State Tax withheld |
| R | Retirement - R - Used for non-taxable retirement |
| R2 | Retirement - R2 - Used for taxable retirement |
| R3 | Retirement - R3 - Used for capital gains |
| R4 | Retirement - R4 - Used for Federal tax withheld from retirement |
| R5 | Retirement - R5 |
| R9 | Retirement - R9 |
Updated