October 21, 2026
QuickBooks closing date before you migrate: lock the old file after your tie-out
The short answer: set a closing date in the old QuickBooks Desktop file as soon as the final reconciliation and tie-out are signed off, so nobody can quietly change a number you have already converted. If the old file stays editable after cutover, the two systems drift apart and the opening balances you migrated stop matching the file you may need to defend in an audit or a tax query.
Why the old file needs locking
A migration copies history as it stood on one day. If someone back-dates a bill, edits an invoice or voids a payment in the old file afterwards, the new system never hears about it. Weeks later the trial balance in the new system differs from the old file by an amount nobody can explain. A closing date removes the problem: Intuit describes it as a way to stop changes that can affect your reports.
How to set it
Intuit’s QuickBooks Desktop help article (page showing an update of 8/4/2026) gives the steps:
- Windows: sign in as the admin, then choose Company > Set Closing Date.
- Mac: choose Company > Users and Passwords > Set Closing Date.
- Enter the closing date and a closing date password, then select OK.
Write the password down and store it with the migration paperwork. If the person who set it leaves, an unrecorded password turns a simple correction into a support case.
When to set it: the sequence we recommend
This is our working order, not an Intuit requirement. Adjust it to your accountant’s advice.
- Finish the cleanup first. Fix opening balance equity, Undeposited Funds and unapplied payments while the file is still open. After the lock, every fix becomes a dated adjustment.
- Reconcile every bank and card account through the conversion date. Our guide to a wrong beginning balance covers the common snags.
- Take the tie-out reports. Save the trial balance, A/R and A/P aging and inventory valuation as PDFs as of the conversion date.
- Set the closing date to the conversion date, with a password.
- Convert, then compare. Match the new system’s opening balances to the saved reports. If they differ, you know the old file was not changed in between.
One more thing to check before the lock: automatic memorized transactions that are still scheduled in the old file. Retire them first so they do not post twice after cutover. The same freeze applies when you move from Online back to Desktop with Intuit’s migration tool; see Online to Desktop: migration tool vs conversion.
What if you must correct something after the lock?
Do not remove the lock casually. The better habit is to correct in the new system with a dated adjusting entry and record why. If the fix truly belongs in the old file, an admin can change the date, make the edit and restore the date. Log each change so the tie-out reports stay explainable.
One detail from Intuit’s article is useful here. When you void a check dated before the closing date and the check hit an expense account, QuickBooks offers to create a journal entry in the earlier period and a reversing entry in the current period. You can still void without the entries. Choosing the entries keeps the earlier period unchanged and moves the correction into the open period, which is usually what an accountant wants.
Worked example
Illustrative only. A services firm converts on 31 December with a 30 December bank reconciliation signed off. The bookkeeper saves the six tie-out PDFs, sets the closing date to 31 December and stores the password with the project file. In February an old client disputes an invoice from October. Because the old file is locked, the bookkeeper issues a credit memo in the new system dated February, with a note referencing the old invoice number, and the opening balances still match the PDFs.
What the Intuit article does not tell you
The help article we read does not say how a closing date behaves when a file is condensed, converted or exported, and we make no claim about that. Test on a copy: set the date, run a trial export, and check the result before the live cutover. This is general information; confirm retention and audit needs with your accountant.
Frequently asked questions
Where do I set a closing date in QuickBooks Desktop?
Intuit says to sign in as the admin on Windows and choose Company > Set Closing Date. On Mac, choose Company > Users and Passwords > Set Closing Date. Enter the date and a password, then select OK.
Should I set the closing date before or after converting?
We suggest setting it after your final reconciliation and tie-out reports are saved, and before or at the moment of conversion, so the old file cannot drift from what you migrated.
Can I still void a check dated before the closing date?
Intuit says that for a check posted to an expense account, QuickBooks prompts you to create a journal entry in the earlier period and a reversing entry in the current period, and you can void without creating the entries.
Will the closing date survive a conversion?
Intuit’s help article does not address conversion or export, so assume nothing. Set the date again in the new system if it supports one, and test on a copy first.
Another thing the old file holds is its edit history: the QuickBooks Online audit log is kept for two years, so decide what to record from it before you cut over.
Related service: QuickBooks support