Import bills into QuickBooks Online

With Zed Axis you can import bills into QuickBooks Online from text, Excel and IIF files.  Follow the standard steps to connect to QuickBooks Online, browse to the file that contains the bills you wish to import and map the columns in your import file to the corresponding fields in QuickBooks Online.
 
 
 
Description of the fields that you can map to in QuickBooks Online
 
 
QuickBooks Online Field Format Description
DocNumber Str 21 MANDATORY FIELD - Bill reference number, duplicate DocNumbers are accepted in QuickBooks, see also Auto Numbering
Txn Date date The date of the bill, If you leave TxnDate out the mapping, the current date in QuickBooks Online will be used.
PrivateNote Str 4000 User entered, organization-private note about the transaction. This note will not appear on the transaction records by default.
DepartmentRef   The department of Location used to classify the Bill
CurrencyRef Currency Code The currency that is being used on the bill (only required if not Home Currency) ie USD, EUR, AUD, GBP more
Exchange Rate Decimal The number of home currency units equal to one of the currency being imported (ie CurrencyRef) more
Line Description   Description for the expense line
Line Amount   Amount of the expense
Line Customer Ref   Customer name associated with the expense
Line Account Class   Class associated with the expense
Line Account Ref   Name of the expense account
Line Billable Status   Billable status of the expense values Billable, NotBillable, HasBeenBilled
Line Account Tax Code   Tax code associated with the expense line
Vendor Ref   MANDATORY FIELD - Full name of the vendor
AP Account   The Accounts Payable account the purchase is credited
Sales Term   Reference to the terms for the purchase
Due Date   Date payment is due if not provided defaults to Sales Terms date
Global Tax Calculation   Method to which tax is applied - TaxExcluded, TaxInclusive or NotApplicable
Line Item Description Str 4000 A descriptive text field for the Item
Line Item Amount Num 10.5 MANDATORY FIELD - The Amount of the line item ie Qty x Unit Price
Line Item Ref   MANDATORY FIELD - The name of the item purchased
Line Item Class   Class for the line item
Line Item Qty Decimal Number of items ordered
Line Item Unit Price Decimal Unit price of the item
Line Item TaxCode   Tax code used for the item
Line Item Customer   Customer associated with the item purchase
Line Item Billable Status   Billable status of the expense values Billable, NotBillable, HasBeenBilled

 

Troubleshooting Errors

Business Validation Error: There is no account associated with the item Item Name Is it marked for purchase, and has an account associated with it - The error occurs because the item you are importing on the bill is not set up correctly for purchasing, please go into QuickBooks Online, edit the Product and make sure in the Purchasing Information you have selected an Expense Account, then retry the import.

Required parameter Line.AccountBasedExpenseLineDetail.AccoutRef is missing in the request - This error occurs when Axis has not been able to identify the Line Account (Expense) that is being used on the bill.  To address this please check that the account that you are importing (ie Office Supplies or Auto:Fuel) exists and matches exactly in QuickBooks Online and that you are using the Full Account name as described here.  Also make sure that there is not a space at the end of the account name this will also result in a mismatch.

 

By Steve Batten

 

Add Feedback