Skip to main content
liza-careandcomp
April 3, 2023
Question

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

  • April 3, 2023
  • 5 replies
  • 0 views
Original commenter did not share additional details

5 replies

Bryan_M
Bryan_M
April 3, 2023

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
April 24, 2023

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
April 24, 2023

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.

Terms & ConditionsAccessibility statement