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
 
QuickBooks Online Field Format Description
DocNumber Str 21 MANDATORY FIELD - Deposit Reference number, duplicate DocNumbers are accepted in QuickBooks, see also Auto Numbering
Txn Date date The date of the deposit, If you leave TxnDate out the mapping, the current date in QuickBooks Online will be used.
Department Ref Name Str Name of the department
Currency Ref Name Str Reference to the currency to be used for the Deposit, (only multicurrency files) if blank assumed as Home Currency
PrivateNote Str 4000 User entered, organization-private note about the transaction. This note will not appear on the transaction records by default.
Txn Status Enum Status 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 Description Str 4000 Description of the line item
Line Amount Num 10.5 MANDATORY FIELD - The Amount of the line item
Linked Txn Doc Number Str Transaction the deposit is linked to
Linked txn Txn Type Enum Type of transaction the deposit is linked to ie Invoice
Deposit Line Entity Name Str The Customer or job associated with the deposit
Deposit Line Entity Type   Typically Customer
Deposit Line Class Ref Name Str The class to be associated with the line of the deposit
Deposit Line Account Ref Name Str The account from with the deposit is allocated to ie typically and Income type account
Deposit Line Payment Method Ref Name Str The payment method used for the deposit (ie Cash, Check, Credit Card)
Deposit Line Check Num Str Reference number for the deposit line
Deposit Line Txn Type Enum Type of the payment transaction
Deposit Line Tax Code Ref Str Non-US versions only Sales/Purchase tax code associated with the Line
Deposit Line Tax Applicable On Enum Required 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   Account to be used to deposit the funds into
Txn Tax Code Ref    
Cash Back Account Ref Str The 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
GlobalTaxCalculation enum Non-US version only - Whether the Amounts are excluding TaxExcluded, TaxInclusive and NotApplicable
 

Add Feedback