I am importing invoices but my item amount is not mapping, how do i fix this ?

Hi Godfred, thank you for reaching out here in the Community.

We can check your invoice file to ensure it will follow the correct mapping.

Before we begin, have you encountered any error messages while importing the invoice? When you mentioned fixing the item total, did you successfully import the file, but it displayed incorrect amounts? Any additional information or clarification you can provide would be greatly appreciated.

Please ensure that you’re using a CSV file and assign the correct fields for the Item amount while importing it. Your invoice file should include the following column header:

• Invoice number
• Customer
• Invoice date
• Due date
• Item amount
• Item tax code

Additionally, import errors often occur when Item amounts contain special characters other than a decimal point. To prevent issues in QuickBooks, make sure to remove any currency symbols (e.g., $, £, €) from the values before importing your file.

If needed, you can also download the sample file within QuickBooks Online to confirm that your mapping aligns properly with the format it requires.

Here's how:

1.  Go to Settings, then select Import data.
2. Choose Invoices.
3. Click the Download an example link to download the sample file.
   
   

On the other hand, if you’ve successfully imported the invoice but the amounts are incorrect, please check if the amounts in your import file were set as tax-inclusive or tax-exclusive. Differences here can cause the totals to be miscalculated within QuickBooks.

For more detailed guidance on importing invoices into QuickBooks Online, you can refer to this article: Import multiple invoices at once in QuickBooks Online.

Please let us know if you have additional questions or need further assistance.