cancel
Showing results for 
Search instead for 
Did you mean: 
kaiumuddin156-gm
Level 1

I want to import invoice amount with fraction using csv file. Whenever I import invoices with fraction, it gets rounded. I don't want amounts to be rounded. Please advise

I want to import invoice amounts with fractions using a CSV file. Whenever I import invoices with fractions ($475.50), they get rounded ($476). I don't want amounts to be rounded. I want the amounts to be imported as they are ($475.50). When I receive payments, I need to edit all the fractioned amounts. That kills my time. Would you please help me with how to stop rounding?
Solved
Best answer September 27, 2021

Best Answers
MorganB
Content Leader

I want to import invoice amount with fraction using csv file. Whenever I import invoices with fraction, it gets rounded. I don't want amounts to be rounded. Please advise

Hey there, kaiumuddin156-gm.

 

Thanks for reaching out for support here in the Community. I want to make sure you're able to import invoices via CSV in QuickBooks Online.

 

It sounds like you're on the right track and you should be able to import the exact number without the system rounding up the invoice amount. I recommend double checking the number formatting to make sure it is set to allow decimal points. Here's how:

 

1. Click the Gear icon in the top right corner.

2. Select Account and Settings.

3. Choose the Advanced tab on the bottom left.

4. In the Other preferences check the Number format.

5. Click Save if any changes are made.

 

Here's a visual of how this will look:

 

 

With this info you'll be able to import invoices with the exact amount needed. Please don't hesitate to reach back out if you have any other questions. I'll be here to help.

View solution in original post

1 Comment 1
MorganB
Content Leader

I want to import invoice amount with fraction using csv file. Whenever I import invoices with fraction, it gets rounded. I don't want amounts to be rounded. Please advise

Hey there, kaiumuddin156-gm.

 

Thanks for reaching out for support here in the Community. I want to make sure you're able to import invoices via CSV in QuickBooks Online.

 

It sounds like you're on the right track and you should be able to import the exact number without the system rounding up the invoice amount. I recommend double checking the number formatting to make sure it is set to allow decimal points. Here's how:

 

1. Click the Gear icon in the top right corner.

2. Select Account and Settings.

3. Choose the Advanced tab on the bottom left.

4. In the Other preferences check the Number format.

5. Click Save if any changes are made.

 

Here's a visual of how this will look:

 

 

With this info you'll be able to import invoices with the exact amount needed. Please don't hesitate to reach back out if you have any other questions. I'll be here to help.

Need to get in touch?

Contact us