I can help you with adding your journal entries, @shawna-barlette-. The option to import your journal entry in a .csv file is currently unavailable. That would be a great addition to the current features that we have, so I'll take note of it. I also encourage you to leave feedback from within the product. Here are the steps: Go to the Gear icon and select Feedback. Provide your product suggestion. Click on Next to submit feedback. You may consider adding them manually one by one or find a third-party app that works well and can integrate with QuickBooks Online that can import your .csv file. Here's how to add a journal entry: Go to the + New button and select Journal Entry. Enter your debit and credit amounts. Provide all necessary information. Click on Save and new or Save and close. Check out the following article for more information about when and why we enter journal entries: Create journal entries in QuickBooks Online. You can check for supported apps through the QuickBooks Apps Store or from the Apps menu. Here's how: Go to the Apps menu at the left pane to get to the Finds Apps page. Enter a keyword in the Search address. Select the app you want to use. Click on the Get app now button. Refer to this article to see the list of what you can be imported to QBO: Move your lists to QuickBooks Online. Let me know if you need further help importing your journal entries. I'm always here to help. Have a great rest of the day!

Question

Can we import lengthy journal entries using a .csv file?

Forum|Forum|3 years ago
March 3, 2023
2 replies
54 views

No text available

QuickBooks Online

MJoy_D

QuickBooks Team

I can help you with adding your journal entries, @shawna-barlette-.

The option to import your journal entry in a .csv file is currently unavailable. That would be a great addition to the current features that we have, so I'll take note of it. I also encourage you to leave feedback from within the product.

Here are the steps:

Go to the Gear icon and select Feedback.
Provide your product suggestion.
Click on Next to submit feedback.

You may consider adding them manually one by one or find a third-party app that works well and can integrate with QuickBooks Online that can import your .csv file.

Here's how to add a journal entry:

Go to the + New button and select Journal Entry.
Enter your debit and credit amounts.
Provide all necessary information.
Click on Save and new or Save and close.

Check out the following article for more information about when and why we enter journal entries: Create journal entries in QuickBooks Online.

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

Here's how:

Go to the Apps menu at the left pane to get to the Finds Apps page.
Enter a keyword in the Search address.
Select the app you want to use.
Click on the Get app now button.

Refer to this article to see the list of what you can be imported to QBO: Move your lists to QuickBooks Online.

Let me know if you need further help importing your journal entries. I'm always here to help. Have a great rest of the day!

P

Prozach

You know, I find this response SUPER WEIRD.

Back in January 2023 you posted an article about doing this very thing:
https://quickbooks.intuit.com/learn-support/en-au/help-article/import-export-files/import-journal-entries-quickbooks-online/L4tQBwbs7_AU_en_AU?uid=lltoaym5

From the article:

Step 2: Import your journal entries

Note: You can turn on class tracking to import journal entries with classes.

Go to Settings ⚙️, then select Import Data.
Select Journal Entries.
On the Download page, select Browse. Note: If you need help formatting your journal entries, select Download a sample file.
Find and select your CSV or Excel file. Select Open, then Next.
Map your information. Your Field represents the headers on your spreadsheet. From each small arrow ▼ icon, select the one that matches a field in QuickBooks Online.
Select Next. If there’s an error, edit the file and try again.
Select Start import.
Select Done.

Kinda strange when you come in and say this doesn't exist. but not so strange when you consider that quicken is pushing a 3rd party SaaS solution that does this. Seriously what serious accounting software can say with a straight face that they can't do CSV import?? thats like having a spreadsheet program that can't do SUM.

Fiat Lux - ASIA

Level 14

@Prozach

The link you mentioned is only applicable for QBO AU version.

Fiat Lux - ASIA

Level 14

@shawna-barlette-

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

Step 2: Import your journal entries

Sign up

Login with SSO

Let's get you signed in

Login with SSO