QuickBooks Desktop Error Messages

Error 3210: QuickBooks error message: You cannot pay more than the amount due.

Error 3210: While trying to Add a(n) ReceivePayment with name or order number of ..., QB responded: The "AppliedToTxnAdd payment amount" field has an invalid value "...". QuickBooks error message: You cannot pay more than the amount due.

Description

When syncing a transaction to QuickBooks, the following error message is encounter in the Connex log:

Error 3210: While trying to Add a(n) ReceivePayment with name or order number of ..., QB responded: The "AppliedToTxnAdd payment amount" field has an invalid value "...". QuickBooks error message: You cannot pay more than the amount due.

Cause

Transactions in QuickBooks must be balanced, else QuickBooks will not allow Connex to insert the transaction, resulting in this error message. This can happen most often if the sales tax percentage of the e-commerce platform is calculated differently than QuickBooks; if a discount or coupon code causes the order to have a negative balance; or in relation to QuickBooks Group Items.

Solution

1. Rounding Issues & Tax Calculation

Connex will change the payment total to match QuickBooks, if there is a difference in the balance due or balance total. This is reflected on the transaction with a line item called "rounding." No changes are required on your end, as this is automatic. Connex will likewise log an error message that says Connex changes the payment amount to match the order total.

This can likewise occur if QuickBooks and the integration in question calculate tax differently.

2. Grouped Items

A grouped item's price is the sum of its items. In many cases, the price is different in QuickBooks and your website. Connex will fix the discrepancy.

3. Merchant Fees

If you subtract merchant fees from sales, then Connex will subtract the fees from your payment. No changes are required on your end.

4. Tax Mappings

Your website calculates 17.644 in tax. QuickBooks rounds down to 17.64. Your website rounds up to 17.65. This means your QuickBooks invoice is one cent less than the payment.

Tax calculations or grouped items can create different totals in QuickBooks and your website

If the amount is greater than a cent, Connex will fix it and log an error. This error happens, when your website charges a different tax rate than QuickBooks. To resolve this issue, follow these steps:

  1. Login to Connex.
  2. Click manage.
  3. Click sales tax.
  4. Ensure codes for the state or county are mapped correctly.