Import deposits into QuickBooks Online

It is possible to import deposits directly into QuickBooks Online using Zed Axis.  This article outlines the steps to achieve, describes the field that you can map, has some sample templates you can refer to and a detailed description of the fields that you can map your data to and what data is expected when importing into QuickBooks Online.
 
  1. Open Zed Axis on the desktop and select QuickBooks Online from the connection types and click connect.
  2. You will be prompted for your QuickBooks Online login details to give Zed Axis permission to connect to your file
  3. Once you are connected click on the Import tab 
  4. Browse to the file that you wish to import into QuickBooks Online, once open the content of the file will be displayed in the preview panel.
  5. Select the option to Add a New Mapping and then select the transaction type of Deposit
  6. Map the columns in your import file to the corresponding fields in QuickBooks Online, and Save the mapping you can then use the mapping for subsequent imports
  7. Finally click Import and Zed Axis will validate and process your import into QuickBooks Online, during in the import process you will see a progress summary.
 
Import deposits into QuickBooks Online
 

Deposits.txt Sample Template

QuickBooks Online FieldFormatDescription
DocNumberStr 21MANDATORY FIELD - Deposit Reference number, duplicate DocNumbers are accepted in QuickBooks, see also Auto Numbering
Txn DatedateThe date of the deposit, If you leave TxnDate out the mapping, the current date in QuickBooks Online will be used.
Department Ref NameStrName of the department
Currency Ref NameStrReference to the currency to be used for the Deposit, (only multicurrency files) if blank assumed as Home Currency
PrivateNoteStr 4000User entered, organization-private note about the transaction. This note will not appear on the transaction records by default.
Txn StatusEnumStatus of the transaction (possible values are Draft, Overdue, Pending, Payable, Paid, Trash and Unpaid)
Custom Field Name 1 Field name for the custom field at header level (see importing custom fields)
Custom Field Value 1 Field value for the custom field at header level (see importing custom fields)
Custom Field Name 2 Field name for the custom field at header level (see importing custom fields)
Custom Field Value 2 Field value for the custom field at header level (see importing custom fields)
Custom Field Name 3 Field name for the custom field at header level (see importing custom fields)
Custom Field Value 3 Field value for the custom field at header level (see importing custom fields)
Line DescriptionStr 4000Description of the line item
Line AmountNum 10.5MANDATORY FIELD - The Amount of the line item
Linked Txn Doc NumberStrTransaction the deposit is linked to
Linked txn Txn TypeEnumType of transaction the deposit is linked to ie Invoice
Deposit Line Entity NameStrThe Customer or job associated with the deposit
Deposit Line Entity Type Typically Customer
Deposit Line Class Ref NameStrThe class to be associated with the line of the deposit
Deposit Line Account Ref NameStrThe account from with the deposit is allocated to ie typically and Income type account
Deposit Line Payment Method Ref NameStrThe payment method used for the deposit (ie Cash, Check, Credit Card)
Deposit Line Check NumStrReference number for the deposit line
Deposit Line Txn TypeEnumType of the payment transaction
Deposit Line Tax Code RefStrNon-US versions only Sales/Purchase tax code associated with the Line
Deposit Line Tax Applicable OnEnumRequired is TaxCode specified - indicates if tax is on sale or purchase. Valid values Sales or Purchase
Line Custom Field Name 1 Field name for the custom field at Line level (see importing custom fields)
Line Custom Fields Value 1 Field value for the custom field at Line level (see importing custom fields)
Line Custom Field Name 2 Field name for the custom field at Line level (see importing custom fields)
Line Custom Fields Value 2 Field value for the custom field at Line level (see importing custom fields)
Line Custom Field Name 3 Field name for the custom field at Line level (see importing custom fields)
Line Custom Fields Value 3 Field value for the custom field at Line level (see importing custom fields)
Deposit To Account Ref Name Mandatory Account to be used to deposit the funds into
Txn Tax Code Ref  
Cash Back Account RefStrThe asset account for the cash back transaction
Cash Back Amount Amount of the cash back
Cash Back Memo Memo for the cash back
Txn Source  
Total Amt Total amount of the deposit, calculated by QuickBooks
ExchangeRate Total amount of the deposit, calculated by QuickBooks
GlobalTaxCalculationenumNon-US version only - Whether the Amounts are excluding TaxExcluded, TaxInclusive and NotApplicable
 

Add Feedback