You can import deposits from text files or from Excel spreadsheets directly into QuickBooks using the Zed Axis software. Download and install the Zed Axis software on your computer
- Open your QuickBooks company file as Administrator and open Zed Axis
- Select your text file or spreadsheet which contains the deposits that you want to import.
- Set up the a Mapping of the columns in your deposits import file to the corresponding fields in QuickBooks
- Click Import and your deposits will be directly added to your QuickBooks company file:
For more information about importing deposits into QuickBooks, search the Knowledge Base, watch the movies in the Learning Centre, or raise a ticket with Zed Support
Download a sample deposit tab delimited text file
||Mandatory: Please specify a reference number to use when importing or when modifying deposits in QuickBooks.
||The date of the transaction.
||MANDATORY FIELD Refers to the account where these funds will be (or have been) deposited, typically a bank account. nb. QuickBooks will not permit you to make deposits to the Undeposited Funds account, try Receive Payments instead.
|| Additional information
||Currency of the deposit (only if you are using Multi Currency)
||The exchange rate is the market price for which this currency can be exchanged for the currency used by the QuickBooks company file as the "home" currency
||MANDATORY FIELD the company files list of Chart of Accounts, for example Undeposited funds or Sales....
|| A monetary amount.
|| a customer, vendor, employee, or person on the QuickBooks "other names" list
|| Reference number for the deposit
|| The payment method
|| Refers to the class used
|| Memo used at the line level
Error: Only QuickBooks can make deposits from Undeposited Funds
It is not possible to make deposits to the Undeposited Funds account, that is a restriction imposed by QuickBooks, you need to choose either a bank or asset account for the DepositToAccount
field, as an alternative you could use the Receive Payment