How to import multi lined transactions into QuickBooks Online

QuickBooks Online
If you have a transaction that has multiple lines on it your import file should be set up so that you have a line for each product or service or expense and then repeat the header info (eg customer info) and a common value that is mapped to the QuickBooks field RefNumber.  An example of this format is depicted below.  This is one invoice for Jane Doe with three items on it.  As you can see the customer name and RefNumber are repeated on each of the three lines.


Customer RefNumber Item Amount
Jane Doe 100 Green Beads 25.00
Jane Doe 100 Red Beads 25.00
Jane Doe 100 Clasp  5.00

Add Feedback