You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close
Home > How to Import Using Transaction Pro Importer > Desktop Importer > Import Multi-Line Transactions into QuickBooks Desktop
Import Multi-Line Transactions into QuickBooks Desktop
print icon

QUESTION

 

How does Transaction Pro Importer know when there are multiple detail lines on a transaction when importing into QuickBooks Desktop (QBDT)?

 

RESOLUTION

 

Importer knows how to group multiple lines onto the same transaction when importing transactions such as Invoices, Sales Receipt, Bills, et cetera based upon a common repeating value that is mapped to the field RefNumber. The reference number column must be sorted so that all like reference numbers are grouped together before importing.

 

In the example below, the column Invoice Number would be mapped to the field RefNumber on the Importer mapping screen. When imported, two Invoices will be created. Jane Doe's Invoice 101 will have three detail lines, and Mark Jones's Invoice 102 will have two detail lines.


 

Invoice Number

Date

Customer

Item

Amount

101

12/15/2020

Jane Doe

Widget A

10.00

101

12/15/2020

Jane Doe

Widget B

12.00

101

12/15/2020

Jane Doe

Widget C

14.00

102

12/18/2020

Mark Jones

Top-A

18.00

102

12/18/2020

Mark Jones

Top-B

16.00



 

Feedback
18 out of 54 found this helpful

scroll to top icon