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

Multi Line Transactions(SPLIT Transaction) Import Made Easy!

SaasAnt Transactions (Online) provides an efficient way to import multi line transactions. It supports multi line transactions for all type of Sale and Expense Transactions. It works on the below principle.


The each line of your file should have a common value such as Transaction Id or Ref No. Our application groups the transactions using the common value (Transaction Id or Ref No). 


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.

So the file should be like below sample. The Invoice No is used to group the line items. You can ask me that do you need to have common Invoice Number in continuous rows. It is not required. Our app groups the transactions based on common Invoice Number even it spreads across the file. So simple.

For your understanding, we have listed the common ID should be used to group the line transactions.


Common ID for Multi Line
 Invoice No
Sale Receipt
Sale Receipt No
Credit Memo
Credit Memo No
Estimate No
Journal Entry
 Journal No
Purchase Order
Ref No
Refund Receipt
Refund Receipt No
Vendor Credit
Ref No
Deposit No
Bill Payment
Ref No
Bill No
Check No
Ref No
CreditCard Credit
Ref No

You can refer our sample templates to see more examples.


Some Interesting Hacks:


Some of us might be still thinking about some strange issue. 

  • What should we do if we don't have Common Ref No like Invoice No or Ref No?  

Well! It is not quite complex issue to come over. 


You just need to find the common unique number or field like Sale Id or Tracking Id or Product Name or Some Description. Then map that unique field to Common Id (Refer above TABLE). Our app will take care of grouping. 


Wait.. there is one more thing you need to. You need to disable "Assign Transactions Ref No from file" in Import Settings.


Did you find it helpful? Yes No

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