How to import a deposit
There is an import template that you may download and modify using your own data:
Find the link to the template in the import window under Process → Import Processes → Import Deposit.
The import file format is as follows:
- It must be in a csv file format.
- The file layout is:
A Shortcut Number (income account to credit)
B Date (mm/dd/yyyy)
C Amount (no $ or commas)**
D Comment (optional. maybe blank but comma needed to separate fields)*
E Project Code (optional. maybe blank but comma needed to separate fields)
F Transaction Number (1, 2, 3, etc. for each deposit)
G 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 characters such as apostrophes 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.