If you will use QuickBooks Integration refer to this link.
Overview - Non-QuickBooks Users
The import (or 'source') data files typically would be created from within your accounting software.
They may be as simple as a check register that is saved to Excel or csv (comma delimited).
Or, they can be custom written data dumps from third party reporting packages, such as Crystal Reports.
The most popular choices for these files are:
•Excel spreadsheets
•Comma-separate (csv) files
•Tab-delimited files
| Date | Check Number | Payee | Amount |
| 12/10/2023 | 46275 | Princesa Isabel Vinhos | ($1,965.21) |
| 12/10/2023 | 46365 | Around the Horn | ($7,251.52) |
| 12/10/2023 | 46366 | Berglunds snabbkop | ($6,637.61) |
| 12/10/2023 | 46367 | Split Rail Beer and Ale | ($7,360.41) |
| 12/10/2023 | 46368 | Familia Arquibaldo | ($953.19) |
| 12/10/2023 | 46369 | Sante Gourmet | ($7,036.54) |
Basic
At a minimum, you will need to create a file with the following fields (in no particular order):
- Payee name / description
- Amount
- Check number
- Date
It is okay to create a file with additional columns.
In addition, your file may have blank rows, report headers, summation rows, etc... - this is also okay.
The system will skip/ignore non-transactional rows and unmapped columns.
