The order of columns does not matter when exporting a check register from your accounting system. Once in the database they can be sorted or filtered by Vendor, Date, etc. It will automatically know the Fiscal year as well and sort by that based on the Check Date.
The Fields we are storing and can be included in your export from the accounting system are:
|
Field |
Required |
Notes |
|
Check Date |
Yes |
|
|
Check Number |
Yes |
|
|
Vendor Number |
Optional |
|
|
Vendor EIN Number |
Optional |
|
|
Vendor Name |
Required |
|
|
Description |
Optional |
Truncate or make field very large* |
|
Check Type |
Optional |
EFT, Paper, etc. |
|
Check Stat |
Optional |
Printed, Void, etc. |
|
Amount |
Yes |
|
*The description field can be very long in your accounting system. To avoid having the description wrap to a second row in your export file you may need to specify a long export field. This capability varies by accounting system.