importing journals into QB Online

Hello John, We just need to confirm a few things. That you have classes turned on in Quickbooks, have you formatted the columns at all in the CSV? Are there any extra unneeded columns in the CSV? Can you try formatting the column that does not show, making sure it's named the same and that any extra columns are removed? Let us know if that works for you. If not we can investigate what's happening.

Hi Emma - Yes classes is turned on. I haven't formatted any columns in the csv file. Some columns are not used eg name and location but they are still in the csv file. I've tried the import with the test drive version of QBO and it sees all the csv headers so I don't understand why I can't see the headers in my version of QBO

Thanks

John

Thank you for following up, John290.

I'd like to help and share what I know about importing journal entries in QuickBooks Online.

To ensure a smooth import, you might wanna to turn off account numbers before you begin importing journal entries. You can easily turn it back on once you successfully import those entries.

Make sure everything is correct in your spreadsheet before you begin importing journal entries. Also, If your spreadsheet has new accounts, be sure to add them first on your chart of accounts.

Below are following information (at least) that must be included in the file:

• Journal No
• Journal Date
• Journal Code
• Account Name
• Journal
• Debits
• Credits
• Select date format

Once you've make sure everything is in place, you can start importing your journal entries.

Here's how:

1. Go to the Gear :gear: icon, then choose Import Data.
2. Tap on Journal Entries.
3. On the Download page, click Browse. Note.
4. Find and select your CSV or Excel file. Select Open, then Next.
5. 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.
6. Click on Next. If there’s an error, edit the file and try again.
7. Hit Start import.
8. Select Done.

You can also go back to the Download page to select Download a sample file if you need help formatting your journal entries.

After that, you can check and edit the journal entries using the search function: How to search for transactions in QuickBooks Online.

Just let me know if you still have other questions about journal entries. I'll be happy to help. Have nice week!

I'm trying to import a journal file (CSV) with 140 entries attributed to subcustomers of a customer, but the file returns errors on all alines saying there's no known contact.  I have verified that Ican however, enter an entry manually without any issue with the exact same name, ie: JONES FAMILY: Jessica. What's the issue?

Hello there, @HPCI. We greatly value your participation in the Community. I appreciate your efforts in taking the time of finding solutions to import a journal file (CSV) in QuickBooks Online.

I understand how challenging it is for you when unexpected behavior prevents you from finishing tasks on time. I'd like to know if you've already followed the steps outlined above by my colleague. If not, I suggest doing so.

If the issue persists despite your troubleshooting efforts, I advise getting in touch with our QuickBooks Online Live Support Team. They have the appropriate tools and a safe environment to look into it further and may create a case if necessary.

To contact support, please click this link: Help and support.

If you need assistance with validating your transactions and balancing your accounts, refer to the following articles:

• Categorise and match online bank transactions in QuickBooks Online
• Reconcile transactions that are older than your opening balance in QuickBooks Online

Please get in touch with us if you have additional questions or need assistance with any QuickBooks-related concerns. Feel free to reply or to post again in the Community forum. We're available 24/7. Enjoy your day!

@HPCI 

Use the trial version for a 3rd party importer tool to isolate the problem.

https://get.transactionpro.com/qbo