Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowWe are needing to start a new QuickBooks company file with existing company file data due to current file size of 1.63G. Can I please get a complete how to with step-by-step instructions on how to perform this task. I will require information on how to also get payroll information into new QuickBooks company file. Please provide additional links if needed for any other items that are needed when starting a new company file.
What QB Desktop edition and year version do you have? QB Desktop 2024 Pro Plus or else?
We are using QuickBooks Enterprise 24.0 Mfg and Wholesale with multi user
Good day, Brita2. I can certainly provide you with the complete details you need. Let's begin by creating a new company file from your existing file.
Here's how:
Once your new company file is created, let's proceed with moving your payroll information. Please note that there’s no option to import payroll-related details, you'll need to enter them manually into your new company.
Here are the steps to enter payroll information:
1. From the Help menu, choose About QuickBooks.
2. Press Ctrl + Alt + Y or Ctrl + Shift + Y to open the Setup YTD Amounts window.
3. enter the YTD in the Employee Summary Information, click the employees and enter the amount of their salary.
4. Select Next until you reach the Enter prior payments section.
5. In the Enter Prior Payments window, click Create Payment to input all prior payroll tax and non-tax payroll liability payments you’ve made during the current or previous years.
6. Enter the Payment Date and For Period Ending date accordingly (in many cases, these dates will be the same).
7. In the Taxes and Liabilities field, choose the payroll tax item that you’ve already paid and want to record in QuickBooks Desktop. Enter the amount. You can add a memo to remind you what the payment is for (Payments for prior quarters are entered as lump sums, and current
quarter payments are entered per payroll).
8. Select the Accounts Affected button to choose how you want the payment to impact your Chart of Accounts (COA):
However, If you're only concerned about the company file size, you can follow the steps in this article to reduce it: Create new company files from existing ones in QuickBooks Desktop. Please note that this process will not create a new company file from scratch, it will only reduce and create a unique copy of your original file.
If you have specific questions about transferring your payroll subscription to the new company file, I recommend contacting our QuickBooks Desktop Payroll Live Support team. They have the tools and expertise to securely process the transfer in the system and provide you with suitable options.
Please don't hesitate to leave us a response if you have other questions or concerns.
Have you tried using the Condense Data utility?
Yes, our current file is corrupt and cannot be rebuilt due to size of 1.63G. Therefore, I need step by step instructions as we are starting our NEW Company file as of 01/01/2026 and only entering opening balances from 12/31/2026 from current company file.
You can purchase a 3rd party service to fix your company file and condense it. Contact @Fiat Lux - ASIA directly via email and they can help you resolve this issue.
We do not want to have the file rebuilt by a 3rd party. I would like the step by step instructions on how to proceed with new file creation from opening balances, as i stated above.
Can I also get instructions on how to handle uncleared checks, deposits, and credit card charges/credits with starting a new company from open balances?
Sure thing, Brita2!
I'm happy to help you manage your uncleared transactions when starting a new company file.
Since you've already used the Condense Data utility, QuickBooks brings over summarized totals rather than individual transaction details. To ensure your bank reconciliation matches, you’ll need to manually recreate any uncleared items.
To recreate uncleared checks, expenses, and credit card charges, you'll have to use the original date and reference/check number. Then, assign the transaction to Opening Balance Equity (not the original expense account). Doing so prevents double-counting the expense, as it was already recorded in your old file.
As for deposits that were sitting in the Undeposited Funds or were sent but haven't appeared on your statement, here's what you'll need to do:
Alternatively, if you have a high volume of transactions, you can return to your old company file, reconcile all outstanding items first, and then run the Condense Data utility again. This will result in a cleaner starting balance.
To ensure your books remain audit-ready, I recommend consulting your accountant. They can review these entries to confirm your opening balances are perfectly aligned.
If you have any other questions, feel free to visit the Community again!
Hi, @Brita2
Just checking in to see if the solution we shared worked for you.
Please let us know if everything is now working smoothly or if you're still experiencing any challenges.
We'll be glad to assist further if needed.
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