Import deposits into QuickBooks Online

Overview of importing deposits into QuickBooks Online

In QuickBooks Online a deposit transaction is used to record 
  • a direct deposit (payment) made by a customer for goods or services supplied by a company; or
  • a linked deposit that links to an existing transaction.
Using Zed Axis it is possible to import deposits directly into QuickBooks Online.  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.

Steps to import deposits

Follow these steps:
  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.

More help?



Where the fields appear in QuickBooks


Import deposits into QuickBooks Online
 

Detailed descriptions of the fields you can map


QuickBooks Online FieldFormatDescription
Doc NumberStr 21MANDATORY FIELD - Deposit Reference number, duplicate Doc Numbers are accepted in QuickBooks, see also Auto Numbering
Txn DatedateThe date of the deposit, If you leave Txn Date 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 multi currency 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, SalesReceipt
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 Tax Code 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
Exchange Rate Total amount of the deposit, calculated by QuickBooks
Global Tax CalculationenumNon-US version only - Whether the Amounts are excluding TaxExcluded, TaxInclusive and NotApplicable