Where do I find the deposit import template?
You can find the link to the template in the import window under Process → Import Processes → Import Deposit.
What format should the import file be?
It must be in a csv file format.
The file layout is:
|Shortcut Number||Date mm/dd/yyyy||Amount **||Comment *||Project Code*||Transaction Number (1, 2, 3, etc. for each deposit)||Bank Shortcut Number|
Shortcut Number (income account to credit)
Amount (no $ or commas)**
Comment (optional. maybe blank but comma needed to separate fields)*
Project Code (optional. maybe blank but comma needed to separate fields)
Transaction Number (1, 2, 3, etc. for each deposit)
Bank Shortcut Number (bank account to use. Primary users must use subsidiary bank accounts in one and same primary bank account. Standard users must use the same bank account for all items of a transaction.)
I've fixed everything, and it's still not importing
Look for odd character's such as apostrophe's in names. Excel reads anything with an apostrophe as a text field.
You can always try downloading a "fresh" export file, then copy and paste the information from the file you are having trouble importing. Often, doing this gets rid of format issues that are hard to identify and permits you to import without errors.