cancel
Showing results for 
Search instead for 
Did you mean: 
jdoles214
Level 2

new company profit and loss reporting after acquiring an old company

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?

5 Comments 5
MaryLandT
Moderator

new company profit and loss reporting after acquiring an old company

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:

 

  1. Sign in to your company file as an admin.
  2. Go to File and select Switch to Single-user Mode.
  3. Make a backup of your company file. This way you can restore it if the data doesn't import the way you expected.
  4. Go to the File menu and select Utilities then Import. Select Import IIF Files.
  5. Browse to your IIF file.
  6. Select it, then click Open.
  7. Click OK to confirm your data was imported.

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:

 

  1. Go to Reports menu at the top.
  2. Pick Company & Financial and Profit & Loss Detail.
  3. Click Customize Report to filter the data depending on your business needs.
  4. Select OK.

Feel free to comment below if you have follow-up questions. I'm always around to provide the steps you need.

Fiat Lux - ASIA
Level 15

new company profit and loss reporting after acquiring an old company

@jdoles214 

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

 

jdoles214
Level 2

new company profit and loss reporting after acquiring an old company

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?

jdoles214
Level 2

new company profit and loss reporting after acquiring an old company

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?

Tori B
QuickBooks Team

new company profit and loss reporting after acquiring an old company

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!  

 

 

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us