How to import Multiple Line transactions using Multiple columns in SaasAnt Transactions (Desktop)

January 1, 2025

SaasAnt Transactions (Desktop) 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 LINES. 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.

Steps

  1.  Navigate to Import Settings (Edit >> Import Settings) and Turn on "Enable Column Based Multi Line Transactions Mapping"  in Miscellaneous tab.

  2.  Navigate to Mapping Screen ( Import >> File Upload >  Mapping)

  3. In the Saved Mappings dropdown, you need to select "Multi Line Mappings by Column"

 

std37.png

std38.png

            std39.png

Then we need to map FILE HEADERS to QuickBooks Fields.  You can map  upto 20 Multiple Line Product / Expense Lines using this mapping settings. You can map Product Name, Rate, Amounts etc.

If the file contains only the sales amounts, you can use DEFAULT / OVERRIDE Custom functions to feed the Item Names.

Automated data Import / Export to QuickBooks Online
Say goodbye to the hassle of managing transactions manually
Grow exponential with Clear Financial Visibility