Ph: +1 (619) 377-0977 (9 A.M to 5 P.M EST)

SaasAnt Support Portal

Submit a ticket My Tickets Blog
Login  Sign up

How to import Multiple Line transactions using Multiple columns?

SaasAnt Transactions (Online) provides an efficient way for importing multi line transactions into QuickBooks Online. It supports multiple line transactions for all types of Sales and Expense Transactions for QuickBooks.

Steps to import Multi Line Transactions into QuickBooks Online

If your QuickBooks import 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 types of transactions.

import Multiple Line transactions quickbooks

Assuming that we have a file to import to SaasAnt Transactions (Online) like the below example.

import Multiple Line transactions in quickbooks

In the mapping screen, we need to select "Multi-Line Mapping for Multi-Column" from the Mapping DROP DOWN Box.

multi line mapping quickbooks

Then we need to map FILE HEADERS to QuickBooks Fields. You can map up to 10 Multiple Line Product / Expense Lines using these mapping settings.

map quickbooks file headers

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.

map product service name quickbooks

In this example, We have mapped "Default Empty Column 1" to Product / Service Name.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.