Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowMy 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!
Utilize the trial period of TPExporter
https:// transactionpro.grsm.io/qbd
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.
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.