Skip to main content
P
Pallavi-sharma
May 29, 2025
Question

decimal values change when syncing with erp—e.g., 15.12 becomes 15.13 in quickbooks. tested sandbox sends correct values. any ideas on fixing this?

  • May 29, 2025
  • 1 reply
  • 0 views

we've noticed an issue where decimal values sometimes change when syncing with the erp. for example, entering a credit card fee of 15.12 in the erp shows up as 15.13 in quickbooks. we've tested this in the sandbox, and the correct values are being sent. any guidance on this?

1 reply

I
Ivan_G
May 29, 2025

QuickBooks rounds any transaction amounts into two decimal points, including data from integrated apps like ERP, Pallavi.

 

It means that if you have an entry from ERP amounting to 15.125, once synced, QuickBooks will automatically round the value to 15.13. Please know that SandBox's system does not directly follow this guideline.

 

To handle this situation, you can manually change the Credit Card (CC) fee Amount directly in QuickBooks:

 

Take note that the interface varies by transaction type, and the image I've provided is a sample from a regular QuickBooks expense entry.

 

Need help managing your books? Our QuickBooks Live Expert Assisted team has your back. We have dedicated bookkeepers that can assist you with streamlining your accounting processes.

 

You can also access this article: Run a report. It can guide you through pulling up financial data and reviewing your company's stability.

 

Feel free to revisit this thread for further inquiries about your data's synchronization in the platform.

P
Pallavi-sharmaAuthor
May 30, 2025

We are sending 2 decimal from the database.

J
JamesDuanT
May 30, 2025

Thank you for keeping us updated about this, Pallavi-sharma.

 

Since the data from Sandbox ERP is already in 2 decimal and still not sync properly with QuickBooks Online, I'd recommend reposting this query in the Intuit Developer's Community. This is where API integration issues are addressed by engineers or personnel with expertise in third-party applications, particularly if you are developing an app for QuickBooks Online.

 

  1. Go to this link: https://help.developer.intuit.com/s/.
  2. Choose the QuickBooks Online tile.
  3. Click Ask as Question on the right.
  4. Log in to your Intuit account and enter your query.

 

After settling the differences and syncing concerns, you can go back to QuickBooks Online and review the amounts. Make sure the data on your reports are accurate for you to reconcile the accounts in the future. 

 

We'll get back to you if you require additional assistance.

Terms & ConditionsAccessibility statement