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

Used wrong company file. Any way to transfer, or at least print a report, of all transactions for the past two weeks?

After backing up prior to importing accountant changes, I opened the wrong company file and proceeded to use it for two weeks. Is there a way to transfer just the transactions needed to the correct file? Or at least, is there a report I can print that lists all of the transactions for the past two weeks so I will know what needs to be re-entered manually? I'm using QB Premier Manufacturing edition on a PC.

Thanks,

Denise
DDWorks

6 Comments 6
Fiat Lux - ASIA
Level 15

Used wrong company file. Any way to transfer, or at least print a report, of all transactions for the past two weeks?

You can use IIF to migrate data

https://quickbooks.intuit.com/learn-support/en-us/help-article/list-management/iif-overview-import-k...

 

If you are not familiar with IIF, use a 3rd party migration tool.

 https://get.transactionpro.com/qbd

 

Nicole_N
QuickBooks Team

Used wrong company file. Any way to transfer, or at least print a report, of all transactions for the past two weeks?

I've got you covered, @DDWorks. Let's work this out together so you can get back on track.

 

The option to copy transactions from one company file to another is possible for QuickBooks Desktop Premier and Enterprise Accountant versions only. If you're using an accountant version, here's how to transfer or copy your customer's transactions to your original file: 

 

First, you'll need to set the Preferences appropriately to allow the export.

 

  1. Disable the use of Account Number.
    1. From the Edit menu, choose Preferences.
    2. Select Accounting and choose the Company Preferences tab.
    3. Uncheck Use account numbers, then select OK.
       
  2. Disable Sales Tax.
    1. From the Edit menu, choose Preferences.
    2. Select Sales Tax and choose the Company Preferences tab.
    3. In the "Do you charge sales tax" section, select No, then choose OK.

 

Next is to create a Custom Transaction Detail report. Here's how:
 

  1. From the Reports menu, choose Custom Reports and select Transaction Detail.
  2. Select Customize Reports and modify the reports.
  3. To run the report, select OK.
  4. Memorize the report and save it as PDF if desired.

 

After that, you can now export the report in excel.

 

  1. While the report is open, select the Excel drop-down.
  2. Choose to Create New Worksheet.
  3. Select a new workbook, then choose Export.

 

Lastly, enter your transactions by batch in QuickBooks Desktop.
 

For a more detailed guide, refer to this article: Copy multiple transactions from one company file to another

 

I also encourage you to visit our QBDT Help page. From there, you can browse articles or get some ideas from other QuickBooks users and experts. This way, you'll get more insights that can help you with your accounting tasks.

 

Feel free to post a reply if you have additional questions about copying transactions from one company file to another. Take care and have a good one!

DDWorks
Level 2

Used wrong company file. Any way to transfer, or at least print a report, of all transactions for the past two weeks?

Thank you maryrosen. This solution would look promising if I had an Accountant edition but I don't. I didn't know I could export a report to an Excel file so thank you for that. Could I not use Utilities/Import/Excel file to bring that same information into the new file? Thanks for your help.

DDWorks
Level 2

Used wrong company file. Any way to transfer, or at least print a report, of all transactions for the past two weeks?

Thanks for your help. That does sound a little over my head. It might be easier for me to re-enter the information manually. Thankfully it's been slow lately so it wouldn't be horrible to do. I really do appreciate your assistance. Maybe it will help someone else.

JessT
Moderator

Used wrong company file. Any way to transfer, or at least print a report, of all transactions for the past two weeks?

Thank you for your feedback, Denise.

 

You can use the Utilities feature to import transactions, but the creating the file from the old company source file is the missing option. I'd also recommend adding the transactions manually instead of doing some uploads.

 

Please don't hesitate to reach back out if you have any other concerns. Take care and have a good one.

btks
Level 5

Used wrong company file. Any way to transfer, or at least print a report, of all transactions for the past two weeks?

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

Need to get in touch?

Contact us