Utilize the trial period of TP Importer for QBO to import Receive Payment data against your invoice
https://transactionpro.grsm.io/qbo
The template should be like this
| RefNumber | TxnDate | PaymentRefNumber | Customer | PaymentMethod | DepositToAccount | InvoiceApplyTo | LineAmount | PrivateNote | Currency | ExchangeRate |
| 1 | 28/11/2020 | 50245 | Janice Johnson | Check | Checking | 101 | 100.00 | | | |
| 2 | 28/11/2020 | 4908 | Leonard Walker Inc | Check | Checking | 102 | 138.78 | | | |
| 3 | 28/11/2020 | 4908 | Lisa Smith | Check | Checking | 103 | 126.50 | | | |
and the template for Sales Receipts
| 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! | | | | 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! | | | | 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! | | | | Y | N | | | | | | | | Y | | Handhelds | Portable Game Player | 1 | 100 | | | TAX |
