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:
•Comma-separate (csv) files
|12/10/2023||46275||Princesa Isabel Vinhos||($1,965.21)|
|12/10/2023||46365||Around the Horn||($7,251.52)|
|12/10/2023||46367||Split Rail Beer and Ale||($7,360.41)|
At a minimum, you will need to create a file with the following fields (in no particular order):
- Payee name / description
- Check number
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.