Importing bill payments into QuickBooks

You can import bills payments from text files or from Excel spreadsheets directly into QuickBooks using the Zed Axis software. 

1. Download and install the Zed Axis software on your computer
2. Open your QuickBooks company file as Administrator and open Zed Axis
3. Select your text file or spreadsheet which contains the bill payments that you want to import.
4. Set up the a Mapping of the columns in your bill payment import file to the corresponding fields in QuickBooks, as shown below.
5. Click Import and your bill payments will be directly added to your QuickBooks company file.

NB. To import a payment that pays multiple bills you need to have one row for each bill paid, and to group them together by using the same reference number. Be sure that the Total Amount equals the sum of the payment amounts or discount amounts.

For more information about importing bill payments into QuickBooks, search the Knowledge Base, watch the movies in the Learning Centre, or raise a ticket with Zed Support.

Sample Bill Payment Check import file
Sample Bill Payment Credit Charge import file

The following fields are the principal fields when importing bill payments into QuickBooks.

QuickBooks field	Type	Description
PayeeEntity	Str209	MANDATORY - Payee who is on the customer, vendor, employee or other names list
AP Account	Str159	Accounts payable account, if not mapped Axis uses the default AP account
TxnDate	Date	Date the bill was paid
Bank(Credit)Account	Str159	MANDATORY - Name of Account (Bank type for BillPaymentChecks or Credit type for CreditCardCharges) the funds are drawn from
IsToBePrinted	Bool	Whether Check has been printed (true or false)
RefNumber	Str11	Reference number for the Bill Payment
ApplyToBillRef	Str	Reference number of the bill being paid, should already be in QuickBooks
Memo	Str4095	Memo of for the payment
ExchangeRate	Float	Exchange rate against the QuickBooks Home currency
AppliedToTxnID	IDType	GUID of the bill if known
PaymentAmount	Amount	Amount being paid
DiscountAmount	Amount	Discount amount
DiscountAccount	Str159	Chart of Account for the discount to be allocated to

Article ID: 82, Created On: 10/21/2011, Modified: 10/21/2011