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 .