Check Import
A check transaction creates and records a check used to pay an expense, records an expense paid in cash and not entered as a bill, or records a non-check debit transaction, such as a debit card transaction, ATM transaction, or EFT (electronic funds transfer) payment. A check transaction records an expense directly to your books by debiting the expense account specified in the transaction detail and crediting the bank account selected for the check.
In the user interface, you can access the check record at Transactions > Bank > Write Checks.
For information about working with this record in the user interface, see Writing Checks.
Supported Check Sublist Data Imports
The check import supports the import of the following sublist data:
-
Accounting Books
-
Expenses
-
Items
Supported Check Subrecord Data Imports
The check import supports the import of the following subrecord data.
|
Subrecord |
Notes |
|---|---|
|
Items – Landed Cost |
Available when the Landed Cost feature is enabled on the Items & Inventory subtab at Setup > Company > Setup Tasks > Enable Features. |
|
Items – Inventory Detail |
Available when the Advanced Bin / Numbered Inventory Management Feature is enabled on the Items & Inventory subtab at Setup > Company > Setup Tasks > Enable Features. |
Check Import Example
The following table provides an example structure for a file to import check data. You can identify the account either by its name or its internal ID.
|
External ID |
Date |
Subsidiary |
Payee |
Amount |
Account |
|---|---|---|---|---|---|
|
CH–12345 |
6/3/2018 |
US – East Coast |
Anne Jenkins |
1500 |
Travel Expenses |
|
CH–12345 |
— |
— |
— |
1200 |
Automobile Expenses |
|
CH–12345 |
— |
— |
— |
800 |
Insurance Expenses |
|
CH–12346 |
6/4/2018 |
US – West Coast |
Tom Booker |
750 |
Meals & Entertainment |
|
CH–12346 |
— |
— |
— |
650 |
Rent Expense |
For details about fields that can be mapped in the check record, see the SOAP Schema Browser’s check reference page. You can use the field definitions here as a basis for creating your own CSV import template file. For information about working with the SOAP Schema Browser, see SOAP Schema Browser.