Importing Multiple Line Transactions into QuickBooks

QuickBooks Desktop (Pro, Premier or Enterprise)
Transaction Pro Importer knows how to group multiple lines onto the same transaction (eg invoice, bill, journal entry etc.) based upon a common repeating value (eg invoice number) that is mapped to the QuickBooks field, RefNumber.  In the example below if you map the column, Invoice No., to the QuickBooks field, RefNumber, on the Transaction Pro Importer mapping screen, two invoices will be created (Jane Doe's will have three lines and Mark Jones' will have two lines).
 

Invoice Number

Date

Customer

Item

Amount

101

12/15/2011

Jane Doe

Widget A

10.00

101

12/15/2011

Jane Doe

Widget B

12.00

101

12/15/2011

Jane Doe

Widget C

14.00

102

12/18/2011

Mark Jones

Top-A

18.00

102

12/18/2011

Mark Jones

Top-B

16.00



You can also review an article on our blog on importing multi-lined transactions here.
 
 

Add Feedback