We often come across the questions like

  • What you mean by field mapping?
  • How do I do that?
  • I don’t understand field mapping. It is confusing.

Field Mapping is not a daunting task if you approach it in a systematic way.

 

What is Field Mapping?

  

Field Mapping” is a process in which you map your file Headers with QuickBooks Fields. As per our guidelines, Excel Transactions takes the first line of your file as the HEADERS.

 

We need to map each HEADER from your FILE to equivalent QuickBooks Fields. This helps our application to understand your data.


What is QuickBooks Field?

 

We have named the fields available in  QuickBooks page based on its functionality. QuickBooks Fields will vary based on each type of transactions. We have explained in detail about each fields in the corresponding import article. You can check this in the below articles.

 

1.  Import Articles for All type of Transactions (U.S QuickBooks Online)

2.  Import Articles for All type of Transactions (AU, UK, CA & other Countries QuickBooks Online)

 

For example, the below image depicts QuickBooks Fields for Invoice.




How to map the Fields or Where do I do the Field Mapping?


After you upload your file, you will see the field mapping screen in Excel Transactions. Here is the example of field mapping screen.



Left Side of the page contains your File Headers and Right side of the page contains “QuickBooks Fields”. You need to select the “QuickBooks Fields” for each File Header if it is needed.


The drop down of "QuickBooks Fields" has the explanation about each field. if you want to know more about that field, click on "?" (Blue Colour Icon). It will display the QuickBooks field in QuickBooks view. See the below example. This is the best way to confirm your understanding.


How do I verify my Field Mapping Configuration?


It is a tough question. Isn’t it?  But we have a simple answer. You just need to click on “Preview Mapping” button and we will display your field mappings in QuickBooks View. You can verify each and every file header against QuickBooks UI.

 


Can I Save my Mappings?


Of course! You can. 

Sometimes, you may receive the files via different channels (3rd party software, manually entered & etc.). So, you need to save the field mappings for each file types.

You can save these mappings by clicking “Save Mapping”. You can select the required mapping from your saved mappings list.

To make it simple for you, “Excel Transactions” will save your mappings automatically even if you missed to save the mappings. “Excel Transactions” remembers everything.


Some Useful Tips:


Default Value:


Sometimes, you need to enter the same value for all the rows of your file. 

For example, if your file does not have Customer Name or Account Name, then you need to edit your file & add that information. 


However, You can skip this activity by below settings.

Just add one empty column and give Default Value in the Text Box located right side of each QuickBooks Field.

 

Default Columns:

 

In the earlier example (given above), you need to have at least one empty column to handle the situation. We want to help you little more. So we have added 3 “Default Columns” for you.

You can use these “Default Columns” to map any constant values such as Expense Account, Customer or Vendor Name.