When I import my invoices via .csv QB is rounding differently so my amounts are different by upto 10p. Any ideas?

Forum|Forum|3 years ago
April 3, 2023
1 reply
3 views

No text available

QuickBooks Online

Bryan_M

QuickBooks Team

You're in the right place, Liza.

When you import an invoice, it's normal for QuickBooks Online (QBO) to round the amount by 10p since QBO is designed to work like this.

With this, if you want to intact the correct amount, I recommend using a third-party app in importing CSV files to avoid changes and rounding of amounts.

You might have more questions about errors in importing transactions using CSV, you can read this article: Common errors for importing bank transactions using CSV.

If you want to learn how to get transactions from your bank or credit card and manually import them, feel free to read this article: Manually upload transactions in QuickBooks Online.

Click the Reply button below if you have questions about exporting and importing data in QuickBooks Online. I'll be happy to lend a hand. Take care.

liza-careandcompAuthor

Thanks for the reply, what format should I be using to try and avoid this happening? Currency, general, number? Wonder if there are any other ways round it as it is causing lots of problems with matching up our payments made vs invoices imported? Thanks

Ashleigh1

Level 14

Hello Liza-careandcomp, thanks for coming back to us, there is no way to stop the rounding from happening in QuickBooks, what you would need to do is just use the resolve the difference option so that you can match them all up.

Sign up

Login with SSO

Let's get you signed in

Login with SSO