For now, importing journal entries from the spreadsheet is unavailable. As a workaround, you can enter the data manually or you can search and use a third-party application instead. This is one of the great ways so you can save time and reduce manual errors.

You can check out supported apps through our QuickBooks Apps Store or from the Apps menu.

To do so, here's how:

In QBO, go to the Apps menu at the left pane to get to the Finds Apps page.
Enter a keyword in the Search address (i.e. import).
Select the app you want to use.
Click Get app now.

Furthermore, you may want to export some of your list reports to Excel, check out this article for the complete steps: Move Your List To QuickBooks Online.

Reach out to us if you need further assistance when importing journal entries. The Community is always right here to help you anytime.

4Gal

Level 5

@ddoran

Prepare your JE data with the following template

RefNumber	TxnDate	PrivateNote	IsAdjustment	Currency	ExchangeRate	Account	LineAmount	LineDesc	Entity	Class	Location
101	01/10/2020	Wire Transfer	FALSE			Savings	-50.00	Credit Savings
101	01/10/2020	Wire Transfer	FALSE			Checking	50.00	Debit Checking
102	01/10/2020	Wire Transfer	FALSE			Savings	200.00	Debit Savings
102	01/10/2020	Wire Transfer	FALSE			Checking	-200.00	Credit Checking

then use an importer tool to proceed

https://get.transactionpro.com/qbo

Sign up

Login with SSO

Let's get you signed in

Login with SSO