@userclydebakeryglasg
As another option, you may utilize an importer tool to import many data fields.
https://transactionpro.grsm.io/qbo
The template should be like these
Invoice
| RefNumber | Customer | TxnDate | DueDate | ShipDate | ShipMethodName | TrackingNum | SalesTerm | Location | Class | BillAddrLine1 | BillAddrLine2 | BillAddrLine3 | BillAddrLine4 | BillAddrCity | BillAddrState | BillAddrPostalCode | BillAddrCountry | ShipAddrLine1 | ShipAddrLine2 | ShipAddrLine3 | ShipAddrLine4 | ShipAddrCity | ShipAddrState | ShipAddrPostalCode | ShipAddrCountry | PrivateNote | Msg | BillEmail | BillEmailCc | BillEmailBcc | Currency | ExchangeRate | Deposit | ToBePrinted | ToBeEmailed | AllowIPNPayment | AllowOnlineCreditCardPayment | AllowOnlineACHPayment | ShipAmt | ShipItem | DiscountAmt | DiscountRate | TaxRate | TaxAmt | DiscountTaxable | LineServiceDate | LineItem | LineDesc | LineQty | LineUnitPrice | LineAmount | LineClass | LineTaxable |
| 101 | Janice Johnson | 01/10/2020 | | 01/12/2020 | Ground | | Net 30 | | | 110 Main Street | Suite 2000 | | | Dallas | TX | 99875 | | 110 Main Street | Suite 2000 | | | Dallas | TX | 99875 | | Special Handling | Thank you for your order! | | | | | | 0 | N | Y | N | N | Y | 12 | Shipping | | 0,02 | | | Y | | MP3 Player | Blue MP3 Player | 2 | 55 | | | TAX |
| 101 | Janice Johnson | 01/10/2020 | | 01/12/2020 | Ground | | Net 30 | | | 110 Main Street | Suite 2000 | | | Dallas | TX | 99875 | | 110 Main Street | Suite 2000 | | | Dallas | TX | 99875 | | Special Handling | Thank you for your order! | | | | | | 0 | N | Y | N | N | Y | 12 | Shipping | | 0,02 | | | Y | | Leather Case | Leather Case | 2 | 10 | | | TAX |
| 101 | Janice Johnson | 01/10/2020 | | 01/12/2020 | Ground | | Net 30 | | | 110 Main Street | Suite 2000 | | | Dallas | TX | 99875 | | 110 Main Street | Suite 2000 | | | Dallas | TX | 99875 | | Special Handling | Thank you for your order! | | | | | | 0 | N | Y | N | N | Y | 12 | Shipping | | 0,02 | | | Y | | Gift Cards | Gift Cards | 2 | 5 | | | TAX |
| 102 | Leonard Walker Inc | 01/10/2020 | | | | | Net 30 | | | 9 Winding Road | | | | Winchester | NY | 12345 | | 9 Winding Road | | | | Winchester | NY | 12345 | | | Thank you for your order! | | | | | | 0 | Y | N | N | N | Y | | | | | | | Y | | Handhelds | Portable Game Player | 1 | 100 | | | TAX |
| 102 | Leonard Walker Inc | 01/10/2020 | | | | | Net 30 | | | 9 Winding Road | | | | Winchester | NY | 12345 | | 9 Winding Road | | | | Winchester | NY | 12345 | | | Thank you for your order! | | | | | | 0 | Y | N | N | N | Y | | | | | | | Y | | Software | 1 Year Warranty | 1 | 25 | | | TAX |
| 102 | Leonard Walker Inc | 01/10/2020 | | | | | Net 30 | | | 9 Winding Road | | | | Winchester | NY | 12345 | | 9 Winding Road | | | | Winchester | NY | 12345 | | | Thank you for your order! | | | | | | 0 | Y | N | N | N | Y | | | | | | | Y | | Extended Warranty | 1 Year Extended Warranty | 1 | 5 | | | TAX |
| 103 | Lisa Smith | 01/10/2020 | | | | | Net 30 | | | 19 Jerico Drive | | | | Bensalem | PA | 84256 | | 19 Jerico Drive | | | | Bensalem | PA | 84256 | | | We appreciate your business! | | | | | | 0 | N | Y | N | N | Y | | | | | | | | | Gift Certificate | $50 Gift Certificate | 1 | 50 | | | NON |
| 103 | Lisa Smith | 01/10/2020 | | | | | Net 30 | | | 19 Jerico Drive | | | | Bensalem | PA | 84256 | | 19 Jerico Drive | | | | Bensalem | PA | 84256 | | | We appreciate your business! | | | | | | 0 | N | Y | N | N | Y | | | | | | | | | Magazine Subscription | Annual Magazine Subscription | 2 | 12 | | | NON |
| 103 | Lisa Smith | 01/10/2020 | | | | | Net 30 | | | 19 Jerico Drive | | | | Bensalem | PA | 84256 | | 19 Jerico Drive | | | | Bensalem | PA | 84256 | | | We appreciate your business! | | | | | | 0 | N | Y | N | N | Y | | | | | | | | | Music Titles | Artist CDs | 3 | 12,5 | | | NON |
| 103 | Lisa Smith | 01/10/2020 | | | | | Net 30 | | | 19 Jerico Drive | | | | Bensalem | PA | 84256 | | 19 Jerico Drive | | | | Bensalem | PA | 84256 | | | We appreciate your business! | | | | | | 0 | N | Y | N | N | Y | | | | | | | | | Tee Shirt | Player Tee Shirt | 1 | 15 | | | NON |
Sales Receipt
| RefNumber | Customer | TxnDate | ShipDate | ShipMethodName | TrackingNum | Location | Class | BankAccount | PaymentMethod | PaymentRefNumber | BillAddrLine1 | BillAddrLine2 | BillAddrLine3 | BillAddrLine4 | BillAddrCity | BillAddrState | BillAddrPostalCode | BillAddrCountry | ShipAddrLine1 | ShipAddrLine2 | ShipAddrLine3 | ShipAddrLine4 | ShipAddrCity | ShipAddrState | ShipAddrPostalCode | ShipAddrCountry | PrivateNote | Msg | Currency | ExchangeRate | BillEmail | ToBePrinted | ToBeEmailed | ShipAmt | ShipItem | TipAmt | DiscountAmt | DiscountRate | TaxRate | TaxAmt | DiscountTaxable | LineServiceDate | LineItem | LineDesc | LineQty | LineUnitPrice | LineAmount | LineClass | LineTaxable |
| 101 | Janice Johnson | 01/10/2020 | | | | | | Checking | Check | 20013 | 110 Main Street | Suite 2000 | | | Dallas | TX | 99875 | | 110 Main Street | Suite 2000 | | | Dallas | TX | 99875 | | Special Handling | Thank you for your order! | | | [email address removed] | N | Y | | | | | 0,02 | | | Y | | Leather Case | Leather Case | 2 | 10 | | | TAX |
| 101 | Janice Johnson | 01/10/2020 | | | | | | Checking | Check | 20013 | 110 Main Street | Suite 2000 | | | Dallas | TX | 99875 | | 110 Main Street | Suite 2000 | | | Dallas | TX | 99875 | | Special Handling | Thank you for your order! | | | [email address removed] | N | Y | | | | | 0,02 | | | Y | | Gift Cards | Gift Cards | 2 | 5 | | | TAX |
| 102 | Leonard Walker Inc | 01/10/2020 | | | | | | Checking | Cash | paid cash | 9 Winding Road | | | | Winchester | NY | 12345 | | 9 Winding Road | | | | Winchester | NY | 12345 | | | Thank you for your order! | | | [email address removed] | Y | N | | | | | | | | Y | | Handhelds | Portable Game Player | 1 | 100 | | | TAX |
| 102 | Leonard Walker Inc | 01/10/2020 | | | | | | Checking | Cash | paid cash | 9 Winding Road | | | | Winchester | NY | 12345 | | 9 Winding Road | | | | Winchester | NY | 12345 | | | Thank you for your order! | | | [email address removed] | Y | N | | | | | | | | Y | | Software | 1 Year Warranty | 1 | 25 | | | TAX |
| 102 | Leonard Walker Inc | 01/10/2020 | | | | | | Checking | Cash | paid cash | 9 Winding Road | | | | Winchester | NY | 12345 | | 9 Winding Road | | | | Winchester | NY | 12345 | | | Thank you for your order! | | | [email address removed] | Y | N | | | | | | | | Y | | Extended Warranty | 1 Year Extended Warranty | 1 | 5 | | | TAX |
| 103 | Lisa Smith | 01/10/2020 | | | | | | Checking | Check | 4591 | 19 Jerico Drive | | | | Bensalem | PA | 84256 | | 19 Jerico Drive | | | | Bensalem | PA | 84256 | | | We appreciate your business! | | | [email address removed] | N | Y | | | | | | | | | | Gift Certificate | $50 Gift Certificate | 1 | 50 | | | NON |
| 103 | Lisa Smith | 01/10/2020 | | | | | | Checking | Check | 4591 | 19 Jerico Drive | | | | Bensalem | PA | 84256 | | 19 Jerico Drive | | | | Bensalem | PA | 84256 | | | We appreciate your business! | | | [email address removed] | N | Y | | | | | | | | | | Magazine Subscription | Annual Magazine Subscription | 2 | 12 | | | NON |
| 103 | Lisa Smith | 01/10/2020 | | | | | | Checking | Check | 4591 | 19 Jerico Drive | | | | Bensalem | PA | 84256 | | 19 Jerico Drive | | | | Bensalem | PA | 84256 | | | We appreciate your business! | | | [email address removed] | N | Y | | | | | | | | | | Music Titles | Artist CDs | 3 | 12,5 | | | NON |
| 103 | Lisa Smith | 01/10/2020 | | | | | | Checking | Check | 4591 | 19 Jerico Drive | | | | Bensalem | PA | 84256 | | 19 Jerico Drive | | | | Bensalem | PA | 84256 | | | We appreciate your business! | | | [email address removed] | N | Y | | | | | | | | | | Tee Shirt | Player Tee Shirt | 1 | 15 | | | NON |
