How to import journal entries into QuickBooks Online using Axis Online


Follow these steps to import journal entries in batch into QuickBooks Online US Edition using Axis Online.

Follow these steps

  1. Click on the Create button to start a new Axe and enter the name of the Axe
  2. Step One – Select File Upload and browse to the file that contains the journal entries that you want to upload into QuickBooks Online
  3. Step Two – Select the Event as a File upload and when that occurs create a journal entry, and then next.
  4. Step ThreeMapping the fields on an journal entry to the columns in your uploaded file
              Hints for mapping
              You will need to map at a minimum the Mandatory fields that are highlighted with an Exclamation icon
If you do not have the data to map then you can use a Constant value as shown in the mapping or use a function to translate or transform your data
You also have the option to to select the option to use Auto-numbering and whether to Skip or Overwrite if the transaction already exists.
Select the option to set the Item settings in case you need Axis to create Items that are not already matched.
Once you have finished click the Save mapping and then Next
  1. Step 4 – Lets test it and save it - 

Demonstration on how to import Journals into QuickBooks Online using Axis Online

QuickBooks Online FieldFormatDescription
Doc NumberStr 21MANDATORY FIELD - Journal Entry Reference number, duplicate Doc Numbers are accepted in QuickBooks, see also Auto Numbering
Txn DatedateThe date of the journal entry, If you leave TxnDate out the mapping, the current date in QuickBooks Online will be used.
AdjustmentBooleanIndicates if the journal is an adjustment value true or false
Currency RefStr 3Currency to be used on the journal entry (use only if Multi currency enabled in the company file), use 3 letter code for currency ie USD, CAD, GBP, AUD, EUR
Exchance RateDecThe number of home currency units it takes to equal one unit of currency specified in Currency Ref (use only if multi currency enabled in the company file)
Line DescriptionStr 4000Description for the journal line
Line Billable StatusenumThe billable status of the journal entry, values Billable, NotBillable, HasBeenBilled
Line Entity TypeenumThe type of Entity that the line is set to ie Customer, Vendor or Employee must be mapped if you are mapping Line Entity
Line Entity Name of a customer, vendor or employee associated to the journal entry, when posting to the Account Receivable account you must have a Customer, and when posting to the Accounts Payable account you must have a Vendor name
Line Account MANDATORY FIELD General ledger account name (or journal number) the journal line is posted to. nb. Use Full Account Name as appears in QB
Line Class Class associated to the journal entry line
Line Department Department associated to the journal entry line
Line Tax CodestrTax Code to be used on this journal line (IN, UK, AU editions only)
Line Tax Applicable OnenumWhether the tax is on a sale or purchase, Possible values Sales or Purchase .Required if Line Tax Code mapped (IN, UK, AU editions only)
Line Tax AmountDTax Amount of the line .Required if Line Tax Code mapped (IN, UK, AU editions only)
Debit10.5 formatMANDATORY FIELD The debit line amount
Credit10.5 formatMANDATORY FIELD The credit line amount
Private Note
Str 4000User entered, organization-private note about the transaction. This note will not appear on the transaction records by default.