Overview of importing deposits into QuickBooks Desktop
In QuickBooks desktop a deposit transactions is used to record direct payments made by customer for goods or services provided by the company. Using Zed Axis you can import deposits from text files or from Excel spreadsheets directly into QuickBooks Desktop.
Steps to import deposits into QuickBooks Desktop
Follow these steps:
- 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
Zed Support Download a sample deposit tab delimited text file
Where the fields appear in QuickBooks Desktop
Detailed description of the fields you can map.
|QuickBooks Field || Type||Description|
|Txn ID ||GUID ||Mandatory: Please specify a reference number to use when importing or when modifying deposits in QuickBooks.|
|Txn Date||Date Type||The date of the transaction.|
|Deposit To Account ||Str Type (159)||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.|
|Memo||Str 4095|| Additional information|
|Currency Ref||Str Type (64)||Currency of the deposit (only if you are using Multi Currency)|
|Exchange Rate||Float Type||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|
|Account Ref||Str (159)||MANDATORY FIELD the company files list of Chart of Accounts, for example Undeposited funds or Sales....|
|Amount||AmtType|| A monetary amount.|
|Entity Ref||Str (209)|| a customer, vendor, employee, or person on the QuickBooks "other names" list|
|Check Number||Str 11|| Reference number for the deposit|
|Payment Method Ref||Str 31|| The payment method|
|Class Ref||Str 159|| Refers to the class used|
|Deposit Line Memo||Str Type (4095)|| 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