cancel
Showing results for 
Search instead for 
Did you mean: 
bryangslc
Level 1

Exporting and editing journal entries outside of quickbooks (csv, ms excel)

My company has not tracked direct/indirect costing for a few of our subsidiaries and doing it manually transaction by transaction in QuickBooks will be arduous. Is there a way to export data to entries to excel, edit it there, and then import it again with our inputted direct/indirect cost allocations.  Thank you!

2 Comments 2
Fiat Lux - ASIA
Level 15

Exporting and editing journal entries outside of quickbooks (csv, ms excel)

Utilize the trial period of TPExporter

https:// transactionpro.grsm.io/qbd

 

RCV
QuickBooks Team
QuickBooks Team

Exporting and editing journal entries outside of quickbooks (csv, ms excel)

Great to have you here, bryangslc.

 

In QuickBooks Desktop, we can only export the files as an Intuit Interchange Format (.IIF) file for the journal entry. From there, you can edit the IIF files and enter the details for direct/indirect cost allocations. Then, import the IIF file to your software again. Just go to Files and click Utilities. Then, tap Import and choose General Journal Entries

 

If you're trying to import journal entries into QuickBooks from an Excel file, then that option is unavailable. What we can do is convert the Excel file to IIF file. Using this file format allows us to import and export the general journal entries to and from QuickBooks Desktop. I'd suggest visiting the Intuit Marketplace to see applications that you can use in converting the file to .IIF.

 

I've attached some articles you can use to learn more about the data you can import in QuickBooks:

If you are an accountant, you can create journal entries in your copy of your client’s company file. Then, enter the details for direct/indirect cost allocations and email them back so your client can add them to their books. See Use journal entries to adjust your client’s book article for more details. 

 

Visit our Bring in your data page for more insights about importing your data to QuickBooks Desktop.

 

I'd like to know how you get on after trying the solutions provided, as I want to ensure this is resolved for you. Feel free to reply to this post and I'll get back to you, Take care always.

Need to get in touch?

Contact us