Send and Import General Journal Entries

Thank you very much.  I like being able to send the journal entries to clients and use it all the time, I just wasn't sure if it would work between to two different operating systems.  We'll give it a shot!  Thank you for taking time to respond.

Hi to all,

i was reading your text because i want to know if i can upload the format (to help with the several journal entries we have) because the format used is not an excel that you can edit.

For example i have not access to QB but i know the entries which have to  be made and i want to know if i can send the entries ( in an excel format for example) to someone that has access to QB and then he/she can upload them directly in the system, but i send them in advance. This can be made? 

please dont ignore me! 

Hi there, dani_rodri.

Thanks for stopping by this afternoon, I don't see any reason that you can't provide the excel file to the person that has access to your QuickBooks account and have them upload it in the system. I did notice however that this is a QuickBooks for Mac thread, so if you're using a Mac version, you'll want to make sure you have the correct file extensions on the file. Below I'm attaching a list with all the file extensions supported with our product.

• QuickBooks file extensions. 

If you have any other questions or concerns, feel free to post here anytime. Thank you and have a nice afternoon. 

ummm then i need the format to upload a file into the QB sytem, you know the excel.... because i think QB is not going to recognize any format. In the case of journal entries, do you have a sample file to upload? 

Hi again, dani_rodri. 

The file extension for Journal Entries are .QBJ. If you're trying to import journal entries into your account, you can have your accountant send you a General Journal Entries file with a .qbj extension. From there you'll be able to have your person upload them into your QuickBooks account. 

You can refer to this article for additional information on Journal Entries and how they work: Use journal entries to adjust your client's books.

Thanks for your time and have a nice evening. 

I have Quickbooks premier 2020 but I can not find the Accountant menu.

I need to export and import general journal entries.

---

@zafersh wrote:

I have Quickbooks premier 2020 but I can not find the Accountant menu.

 

I need to export and import general journal entries.

---

Accountant Toolbox is only available in Premier Accountant and Enterprise Accountant.

You are able to export and import transaction data by IIF

https://quickbooks.intuit.com/learn-support/en-us/import-or-export-data-files/export-import-and-edit...

But due to its limitation, consider using one of these 3rd party migration tools instead.

https:// transactionpro.grsm.io/qbd

https:// partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

Thanks for your quick reply.

I follow that instruction and I can only export lists as IIF from File->Utilities->Lists to IIF Files

But I need to export General Journal entries. Is that possible without using a third party software?

Let me share details about exporting general journal entries in QuickBooks Desktop (QBDT) Premier 2020, @zafersh. This way, you'll be able to determine how to get the data you need and effectively manage your transactions.

Yes, you're correct. The General Journal isn't available on the list of data that can be exported using the IIF file using QBDT Premier 2020. You can only export the data listed in the Export window (i.e. Chart of Accounts, Customer/Vendor/Employee/Class List). However, it's still possible to acquire the information you need by exporting the Journal report to an Excel file from the Reports menu. Here's how:

1. Go to the Report menu.
2. Select Accountant & Taxes, then choose Journal.
3. Click the Customize Report button to focus on the info you need.
4. Select the Excel button.
5. Choose either Create New Worksheet or Update Existing Worksheet.

I've attached screenshots below that show the last three steps.

The QBDT program provides different reports that cater to your business needs. For the complete list of available reports, kindly check out this article: Understand reports. It also contains details about how QuickBooks generates one.

I',m also adding this article to learn more about other ways to import and export info in QBDT: Import and export data in QuickBooks Desktop. It contains related articles and things to keep in mind when importing and exporting data.

Please let me know if you have other concerns. I'm just around to help. Take care always.

Hi, you didn't answer a yes or no question. "No" is an askers' second favorite answer.

Hi elizabethaem!

For QuickBooks Desktop Accountant, there's no need to use third-party software. Allow me to share some details about it.

Accountants who use QuickBooks Desktop Accountant have the option to create a journal entry and send a copy to their clients. Then, their clients just need to import it to flow the changes into their file. You can follow the detailed steps here: Use journal entries to adjust your client’s books.

Another way is to export the General journal entries is through an Excel file, a third-party software. You can follow Rea_M's steps. You may also check this link to see what are the lists and transactions we can export and import: Import and export data in QuickBooks Desktop.

If you need more references and articles in using QuickBooks Desktop, please visit this page: QBDT Articles.

Keep on posting here if you have additional concerns. We'll respond as soon as we can.

Does this work if you are not using the MAC version?

Does thsi work if you are using the desktop version that is NOT Mac?

I'd be glad to join the thread and answer your question about importing journal entries, MAH5.

Yes, the steps given in the original response work for both the Mac and Windows version of QuickBooks Desktop. 

Let me also share a couple more articles about importing or exporting data for future references:

• IIF Overview for Importing Kit, Sample Files, and Headers
• Import or Export MS Excel Files
• Export Lists From the Old Company File Into a New Data File

Let me know if you need anything else. We're always here to guide and assist you anytime you need help.

You missed a step

correct steps:

File>Utilities>Import>General Journal Entries

not 

File>Import>General Journal Entries

Also, another important note.  You need to remove accountant's restrictions before importing or the import will fail  (I learned this by struggling for a bit)