Importing receive payments into QuickBooks

You can import receive payments from text files or from Excel spreadsheets directly into QuickBooks 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 a payment 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. Be sure that the Total Amount equals the sum of the payment amounts or discount amounts.

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 field Format Description
Customer Full Name Str 209 Mandatory: Customer name as it appears in QuickBooks, if Axis cannot find a Customer then it will create a new customer record
AR Account Str 31 Refers to an Accounts Receivable Account in QuickBooks
Txn Date Date The date of the transaction
Ref Number Str 20 Mandatory: The reference number for the Receive Payment
ApplyToInvoice Str 11 Only use if IsAutoApply 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.
Payment Method Str 31 A customers payment method, for example, cash, check, or Master Card. Should match the payment types set in QuickBooks.
Memo Str 4095 Description associated with the payment
Deposit To Account   Refers to the account where these funds will be (or have been) deposited. If not provided, it will default to Undeposited Funds.
IsAuto Apply true or false Mandatory if ApplyToInvoice is not mapped. If IsAutoApply is true, QuickBooks applies TotalAmount 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 Amount Amt Represents the amount assigned to a particular receivable. (Do not map if you are using AutoApply as true or false)
Discount Amount Amt The amount of the discount
Discount Account Str159  Refers to the account where this discount is tracked

 

Error - ApplyToRef does not exist in invoice - this message appears when you have mapped the field ApplyToInvoice 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.

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.  Also check that date of the payment is not prior to the invoice.  Check that if you are mapping ARAccount (Accounts Receivable) that the Invoice is posted to that specific ARAccount 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.

 

Add Feedback