Importing CSV file - issue with having to map Customer field this week

Forum|Forum|1 day ago
August 24, 2026
1 reply
1 view

We import invoices weekly from a standard CSV file with no problems but this week we are having to map the Customer field from CSV file to QB which has previously been remembered from every other import (that field is tagged red instead of green like all the other mapped fields are). All other fields in the spreadshhet, which has not changed, are mapped correctly apart from the Customer field. Why has this suddenly changed and how do I get QB to ‘remember’ it in future, as it always has done in the past?

QuickBooks Online

GianSeth_A1

QuickBooks Online matches the fields in your CSV file by looking at the header text. If the Customer field turns red, it may be because of a small change in the column header, such as an extra space, a spelling error, or a hidden character that doesn’t match what QuickBooks expects.

As long as your column headers in the CSV file stay the same every week, QuickBooks Online will remember your field mappings from the last import.

To make it remember next time:

Manually map the Customer field for today's import to get it through.
Open your CSV file and check the exact spelling and text of your Customer column header.
Keep that exact text identical for every weekly import. As long as the header text doesn't shift, QuickBooks will automatically recognize and map it in green next week.

Check out this page for a reference guide on review mapping and the import process: Import multiple invoices at once in QuickBooks Online.

Let me know if you have other questions. I'm always here to help.

Sign up

Login with SSO

Let's get you signed in

Login with SSO