Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
how do I import Journal Entries into Quickbooks online from excel file.
Solved! Go to Solution.
I appreciate the screenshot you've provided, @deepti3_1.
Regarding the steps that are shared above, they apply to QBO Canada (CA). However, the option to import journal entries may be a great way to save time and reduce manual errors, is currently unavailable in QuickBooks Online United States (US). But don't worry, there's a workaround for this. You can explore third-party apps to import JE as a workaround.
You can check for supported apps through this link: QuickBooks Apps Store or from the Apps menu.
Here's how:
You would see several third-party apps available that can help you import data into QBO. These apps provide additional functionalities, such as data validation and advanced mapping options, to enhance your importing experience.
I would also note that having this option could be helpful for your business. Our Product Engineers are always looking for ideas to improve QBO, and we encourage collaboration with our customers to identify areas for improvement.
Furthermore, if you want to see the list of what you can import to QBO, refer to this article: Move your lists to QuickBooks Online.
If there's anything more I can help you about managing journal entries, just let me know by leaving a comment below or posting again. Have a great day ahead.
Have you checked this one?
Hi deepti3_1,
The information provided by 4Gal provides the information you need, to successfully import your journal entries seamlessly. I would just like to add, that you can download a sample file from QuickBooks Online, to get a full view of the required elements for a smooth transition. Here's how;
1. Open your Settings ⚙ and select Import Data
2. Click on the Journal Entries tile
3. Hit the link to Download an example
Note; Ensure there are no empty columns, or blank lines on your spreadsheet.
4. Prepare your spreadsheet and save it where it's easy to locate
5. Proceed with the import process.
Please don't hesitate to reach back out with other questions. We are always happy to help!
Hi deepti3_1,
Thanks for getting back to us here. Sadly, I cannot view the screenshot you provided. Please confirm which QuickBooks product your are subscribed to. We're here to help!
its Quickbooks Online
I appreciate the screenshot you've provided, @deepti3_1.
Regarding the steps that are shared above, they apply to QBO Canada (CA). However, the option to import journal entries may be a great way to save time and reduce manual errors, is currently unavailable in QuickBooks Online United States (US). But don't worry, there's a workaround for this. You can explore third-party apps to import JE as a workaround.
You can check for supported apps through this link: QuickBooks Apps Store or from the Apps menu.
Here's how:
You would see several third-party apps available that can help you import data into QBO. These apps provide additional functionalities, such as data validation and advanced mapping options, to enhance your importing experience.
I would also note that having this option could be helpful for your business. Our Product Engineers are always looking for ideas to improve QBO, and we encourage collaboration with our customers to identify areas for improvement.
Furthermore, if you want to see the list of what you can import to QBO, refer to this article: Move your lists to QuickBooks Online.
If there's anything more I can help you about managing journal entries, just let me know by leaving a comment below or posting again. Have a great day ahead.
Ok, thank you for your guidance.
Will that tool work on our behalf? I mean if I provide them GL, can they import on our behalf?
If yes, how do we contact them and provide them GL?
They only provide the tool. You will need to purchase a third-party service to import your data. But it will be expensive unless what you need is to convert your data to QB Online
Where can we purchase third party service to import data?
And can you give me any information about the price, how much they will charge for this ?
You can send an email to info at fiatlux dot co dot id
They can convert data to QB Desktop and QB Online
Ok Thanks for the information.
Does anyone know when will QuickBooks Online will allow me to import without the need of 3rd party software?
I reside in the US.
Hello samba001. Welcome to the thread. I'll be glad to share more info about importing journal entries. QuickBooks Online Canada allows you to import your journal entries. I encourage you to check out this helpful article that shows you how to: Import journal entries in QuickBooks Online. You're welcome to ask questions as you browse through the article. I've got your back.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here