Excel Transactions provides an efficient way to import multi line transactions. It supports multi line transactions for all type of Sale and Expense Transactions.
If your file has MULTIPLE LINE TRANSACTIONS in MULTIPLE ROWS. then you need to follow THIS LINK .
This guide explains how to import MULTIPLE LINE TRANSACTIONS if the details are spread in MULTIPLE COLUMNS.
Let's get into an experiment. We can assume that we need an INVOICE with multiple line items as below. Of course, the logic works as same for all type of transactions.
Assuming that we have a file like below example.
In mapping screen, we need to select "Multi Line Mapping for Multi Column" from Mapping DROP DOWN Box.
Then we need to map FILE HEADERS to QuickBooks Fields. You can map upto 10 Multiple Line Product / Expense Lines using this mapping settings.
If you don't have PRODUCT / SERVICE NAME in a separate column, you can use the DEFAULT EMPTY COLUMN and DEFAULT VALUE in the mapping screen.
In this example, We have mapped "Default Empty Column 1" to Product / Service Name .