You can prepare your JE data with the following template
RefNumber | Transaction Date | Account | Debit | Credit | Memo | Name | Class | Billable | Is Adjustment | Currency | Exchange Rate | Home Currency Adjustment | Amounts in Home Currency |
1 | 27/09/2020 | Checking | | 130 | PR 092518 | John Smith | | N | N | | | | |
1 | 27/09/2020 | Wages | 200 | | PR 092518 | John Smith | | N | N | | | | |
1 | 27/09/2020 | Payroll Taxes Payable | | 50 | PR 092518 | John Smith | | N | N | | | | |
1 | 27/09/2020 | Health Insurance Payable | | 20 | PR 092518 | John Smith | | N | N | | | | |
then use an importer tool to proceed. It's a one time license.
https://get.transactionpro.com/qbd
R/E = Retained Earnings account