Import receive payments into QuickBooks

You can import receive payments into QuickBooks from text files or from Excel spreadsheets directly using the Zed Axis software.  Download and install the Zed Axis software on your computer
  1. Open your QuickBooks company file as Administrator and open Zed Axis
  2. Select your text file or spreadsheet which contains the receive payments that you want to import.
  3. Set up the a Mapping of the columns in your invoice import file to the corresponding fields in QuickBooks, as shown below
  4. Click Import and your invoices will be directly added to your QuickBooks company file.
When importing receive payments into QuickBooks you essentially have three choices on how the payments should be applied:
  • Auto Apply (AutoApply =  true)- This will let QuickBooks automatically apply the payments based on whether it can match the amount of the payment if not then it will apply them to the oldest outstanding invoice first.
  • As a credit (AutoApply = false) - This will not apply it to any outstanding transactions and will just apply it as a credit to the customers account. 
  • Apply to specific invoices (ApplyToInvoiceRef) - will apply the payment to the specific invoices and will only apply the Payment amount to that invoice
NB. To import receive payments into QuickBooks that pays multiple invoices you need to have one row for each invoice paid, and to group them together by using the same reference number. The Total Amount should equal the sum of the payment amounts or discount amounts, if it is greater then this will leave an overpayment and credit on the Customers account.

Receive payments sample import file For more information about importing receive payments into QuickBooks, search the Knowledge Base, watch the movies in the Learning Centre, or raise a ticket with Zed Support

Receive payments into QuickBooks

 



The following fields are the principal fields when importing receive payments into QuickBooks:
 

QuickBooks fieldFormatDescription
Customer Full NameStr 209Mandatory: Customer name as it appears in QuickBooks, if Axis cannot find a Customer then it will create a new customer record
AR AccountStr 31Refers to an Accounts Receivable Account in QuickBooks
Txn DateDateThe date of the transaction
Ref NumberStr 20Mandatory: The reference number for the Receive Payment
Apply To InvoiceStr 11Only use if Is Auto Apply is not mapped.The Invoice reference number to which the payment will be applied, if paying multiple invoices you should have multiple lines in the same ReceivePayment transaction..more
Total Amount Total amount of money received. The sum of the PaymentAmount amounts cannot be greater than the TotalAmount, or you will receive an error.
Exchange RateFloatThe exchange rate to be used if the receive payment is paying a Customer that is in a foreign currency ONLY when using Multicurrency
Payment MethodStr 31A customers payment method, for example, cash, check, or Master Card. Should match the payment types set in QuickBooks.
MemoStr 4095Description associated with the payment
Deposit To Account Str 159Refers to the account where these funds will be (or have been) deposited. If not provided, it will default to Undeposited Funds.
Is Auto Applytrue or falseMandatory if Apply To Invoice is not mapped. If IsAutoApply is true, QuickBooks applies Total Amount to any outstanding transaction that exactly matches TotalAmount. If no exact match is found, the payment is applied to the customer jobs outstanding transactions, beginning with the oldest one.If IsAutoApply is false, QuickBooks receives the payment but does not apply it to any outstanding transaction. Instead, the amount will appear as a credit on the customer job’s next transaction ...more
Payment AmountAmtMandatory if Apply To Invoice method is used. Represents the amount assigned to a particular receivable. (Do not map if you are using AutoApply as true or false)
Discount AmountAmtThe amount of the discount
Discount AccountStr159 Refers to the account where this discount is tracked
Set Credit Memo RefStrThe existing Credit Memo Ref Number in QuickBooks which you want to link the Receive Payment too
Set Credit AmountAmtThe amount of the payment that is to be applied to the existing Credit Memo 
Set Credit OverrideBoolExpected values true or false
Discount Class Full NameStr 159The class to be used on the Discount Amount

 

Error - Apply To Ref does not exist in invoice - this message appears when you have mapped the field Apply To Invoice and the invoice number that you are specifying is not found in QuickBooks, or has been fully paid, or is not for the same Customer that has been specified, or the AR account does not match, or there are duplicate Invoice numbers used and the first invoice found is not the correct one.

Error - "You need to delete this transaction from the deposit before you can edit its name or amount." - This message is saying that the Receive Payment transaction you are trying to import has already been deposited into a bank account and QuickBooks is not permitting you to edit something that is already deposited, this is standard QuickBooks behaviour.
 

Error - Object "<U23-..........>" specified in the request cannot be found. - The error can be caused by a number of factors. First check that the customer name and the Invoice reference number you are applying the payment too exist and that the invoice is in fact for that customer (sometimes the invoice reference may have been used previously for another customer ie duplicated, in which case you may need to change the Invoice Ref Number). Also check that date of the payment is not prior to the invoice. Check that if you are mapping AR Account (Accounts Receivable) that the Invoice is posted to that specific AR Account in QuickBooks.

Error - The transaction object <.........> may only be provided once in this request - The error occurs in QuickBooks and is due to the fact that in a single grouped payment there are two or more lines where the payment is being applied to the same Invoice Reference number. Total all the payments together into one line for each invoice in the payment file.


Error - You cannot pay more than the amount due
Cause -  The receive payment transactions that you are importing is being applied to an invoice where the outstanding balance is less than the amount being paid, QuickBooks will not permit you to apply a payment greater than the amount that is due on the invoice.
Resolution -  Adjust the amount being paid to be equal to or less than the outstanding amount. Also check that the payment is being applied to the correct invoice.  As an alternative if the payment is an over payment you can auto apply the payment and the over payment will be added as a credit to the customers account.



 

Feedback

Add Feedback
Is there a list of "Payment Method" types standard to Quickbooks. For example is 'e-check' simply 'e-check' or 'echeck' or 'e-CHECK'.
Phil Glau (August 2, 2019 at 7:32 PM)
Yes there is a Payment Method List in QuickBooks that it should match with
Steve (August 6, 2019 at 8:06 AM)

Add Feedback