Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hi All,
I acquired the assets of an existing company who used QB in Sept 2020. I already setup my new company file in QB. What I don't have is the old company's historical Profit & Loss data, which I am hoping to somehow import so that I can run Year Over Year and MOM type reports. For instance, I want to see how office expense in the new company in 2020 compares to the old company's office expense from 2019.
Is there a way to do this within QB itself so I can run the QB reports without having to do things manually in excel to compare?
I can provide the steps so you can run the report and compare your data in QuickBooks Desktop, jdoles214.
You need to import transactions from the old company using the Intuit Interchange Format (.IIF) files. Check out this page for the kit, sample files, and headers: IIF Overview.
Once you have the file ready, here's how to import them to QuickBooks:
You can also visit this Export, import, and edit IIF files for more details about the steps above.
After that, you can run the Profit and Loss report. Then, customize it to get your monthly or yearly office expense statements.
Let me show you how to run the report:
Feel free to comment below if you have follow-up questions. I'm always around to provide the steps you need.
If you are not familiar with IIF, you may utilize one of these migration tools
https:// transactionpro.grsm.io/qbd
https:// partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2
Thank you, Mary, follow up question:
- If I follow these steps, will it import transactions that would affect customer receivable agings, etc? I don't want that, I just want P&L data (income, cogs, expense), no balance sheet data, no other things.
- Can I do this by time frame, for instance if I only want to import P&L data from the old company from 2018 and 2019 only?
Thank you, Mary, follow up question:
- If I follow these steps, will it import transactions that would affect customer receivable agings, etc? I don't want that, I just want P&L data (income, cogs, expense), no balance sheet data, no other things.
- Can I do this by time frame, for instance if I only want to import P&L data from the old company from 2018 and 2019 only?
Good morning, @jdoles214.
Thanks for following up with us. I'm here to give you more information about importing the data.
You have two choices that you could use in this scenario. You can save a backup of your company data to compare it between the companies or import your transactions as IIF files (as mentioned by my colleague above). If you don't want all of your transactions, your best option may be to edit the IIF file in Excel, so it only includes transactions from a certain account or date ranges. Then you'll be able only to import the data you need.
However, I can see how importing only the P&L data without editing the IIF file would be beneficial for you and your business. If you'd like, I can submit a feedback request to our product development team, so this can be considered in a future update.
Please let me know if you have additional questions or concerns. I'll be here every step of the way. You can reach out to the Community at any time. Take care!
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