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

SaasAnt Support Portal

Submit a ticket My Tickets Blog
Welcome
Login  Sign up

Multi Line Transactions (SPLIT Transaction) Import Made Easy!


SaasAnt Transactions (Online) provides an efficient way to import multi line transactions into QuickBooks Online. It supports multi-line transactions for all types of Sales and Expense Transactions. It works on the below principle.

 

Each line of your QuickBooks Import file should have a common value such as Transaction Id or Ref No. SaasAnt Transactions (Online) application groups the transactions using the common value (Transaction Id or Ref No).


Importing Multi Line Transactions into QuickBooks Online:

  

Let's get into an experiment. We can assume that we need to add an INVOICE in QuickBooks with multiple line items as below. Of course, the logic works as same for all types of transactions.


import multi line transactions into QuickBooks


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


import multi line transactions into QuickBooks


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

                                

TransactionCommon ID for Multi Line
Invoice Invoice No
Sale ReceiptSale Receipt No
Credit MemoCredit Memo No
EstimateEstimate No
Journal Entry Journal No
Purchase OrderPO No
PaymentRef No
Refund ReceiptRefund Receipt No
Vendor CreditRef No
DepositDeposit No
Bill PaymentRef No
BillBill No
CheckCheck No
ExpenseRef No
CreditCard CreditRef No



You can refer to our sample templates to see more examples.

 

Some Interesting Hacks:

  

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

  • What should we do if we don't have Common Ref No like Invoice No or Ref No?
  • Well! It is not quite a 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). SaasAnt Transactions will take care of grouping unique fields in QuickBooks.

  

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.