Skip to main content

I am integrating Zapier with Quickbooks Online, and when I create an expense, I get the following error: The app returned "Invalid Number".
Is there any documentation on the Zapier integration? We would like to know what the api is expecting.

We currently have the following input when testing the Zap:

  • Payee Type: Vendor

  • Payee: Testing

  • Payment Type: Check

  • Account: 1010 1 WF Checking 6354

  • Payment Method: 2

  • Item Description: 207 Brandywine

  • Account Description: Zaxby's

  • Account Amount: $1,111.00

  • Item Amount: $1,110.00

  • Date: February 11, 2025

  • Print Later: False

  • Account Number: 110

  • Billable Status: Not Billable

  • Tax Code: NON

  • Customer: 742

  • Quantity: 1

  • Unit Price: $0.00

  • Tax Code (Item): NON

  • Item Number: 1

  • Memo: Test Memo

  • Total Tax: $0.00

  • Location: Outside EU

  • Currency: USD

  • Exchange Rate: 10.0

The Response: Failed to create an expense in QuickBooks Online
The app returned "Invalid Number".

There are developers that are working on this issue so please loop them in the response.

This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.

Hi ​@Amodi,

 

Your QuickBooks Online integration error ("Invalid Number") likely stems from a mismatch in data formatting. Ensure that amounts are entered without currency symbols or commas (for example, 1111.00 instead of $1,111.00), the exchange rate is valid, and account/item numbers match actual QuickBooks entries. If the issue persists, it is recommended that you contact Zapier support for further troubleshooting.

 

As for your question about documentation, you can find our QuickBooks Online integration help documentation here: https://zapier.com/apps/quickbooks/integrations


Hi there, ​@Amodi 👋

How are things going on this? Was it an issue with the formatting of the number as Jammer suspected?

Happy to lend a hand if you’re still stuck at, just let us know! 🙂