1. Home
  2. Insights
  3. The QuickBooks Closing Date: The Lock That Keeps Last Year From Changing

QuickBooks & systemsThe QuickBooks Closing Date: The Lock That Keeps Last Year From Changing

How the QuickBooks closing date works, how to close the books in QuickBooks Online, and why locking prior periods keeps last year's numbers from changing.

By Umaima WaheedUpdated

The short answer5 min read

The QuickBooks closing date is a setting that locks transactions dated on or before a chosen date. After it's set, anyone who tries to add, edit or delete a transaction in that period sees a warning or needs a password. It doesn't post any entries or move net income. It just protects finished periods from accidental changes.

Read the full answer

Your CPA files the tax return in March, based on books that showed $142,300 of net income. In August, someone deletes a "duplicate" from last November and recategorizes a few old charges. Last year's net income in QuickBooks is now $139,850.

Nothing announced it. The tax return still says $142,300. The books say something else. And next spring, your CPA starts the new year from a balance sheet that no longer matches what they filed.

This is the problem the QuickBooks closing date exists to prevent. Here's what it does, what it doesn't do, how to set it, and what to do on the day someone really needs to change last year.

What the QuickBooks closing date actually does

The closing date is a lock. Pick a date, and every transaction dated on or before it is protected. Depending on your settings, anyone who tries to change one gets a warning, or has to enter a password.

That's all it does. Which surprises people, because "closing the books" sounds like a big ceremony.

  • It doesn't create any journal entries.
  • It doesn't move profit into retained earnings. QuickBooks does that on its own at the start of each fiscal year, without any closing date at all. Last year's net income shows up in Retained Earnings on the balance sheet automatically.
  • It doesn't stop anyone from entering transactions after the date.

Think of it as the lid on a jar. The contents are already in there. The lid keeps them from spilling.

How to close the books in QuickBooks Online, step by step

In QuickBooks Online:

  1. Go to the Settings gear, then Account and settings.
  2. Open the Advanced tab.
  3. In the Accounting section, turn on Close the books.
  4. Enter the closing date (for example, December 31 of last year, or the last day of the most recently closed month).
  5. Choose either "Allow changes after viewing a warning" or "Allow changes after viewing a warning and entering password." Pick the password option.
  6. Set a password, save, and store the password somewhere other than a sticky note on the monitor.

In QuickBooks Desktop, the setting lives under Edit, then Preferences, then Accounting, then Company Preferences, where you set the closing date and password.

The warning-only option is a speed bump people drive over without slowing down. The password is the actual lock.

When to set it (and move it)

A practical rhythm:

  • Monthly: after each month is reconciled and reviewed, move the closing date to that month's last day. This is how you lock a prior period in QuickBooks every month, not just once a year.
  • Yearly: once your CPA has finalized the tax return and any adjusting entries they gave you are recorded, make sure the closing date covers the full year.

The monthly habit is the better one. It means a reconciled month stays reconciled, which prevents most beginning balance problems before they start. Our guide to the month-end close process shows where this step belongs in the order of the close. Our year-end close checklist covers the December and January version.

A worked example: the August edit that didn't happen

Imagine a hypothetical e-commerce company with a bookkeeper, a part-time operations manager and an owner who all use QuickBooks. Last year's books closed at $142,300 of net income, and the CPA filed on that number.

The closing date is set to December 31, with a password only the controller has.

In August, the operations manager notices a $2,450 inventory purchase from last November that looks like a duplicate of a later entry. They go to delete it, and QuickBooks asks for the closing date password. They don't have it, so they flag it to the bookkeeper instead.

The bookkeeper checks. It wasn't a duplicate: one was a deposit on an order, the other was the balance. Both were real. Last year stays at $142,300, the CPA's numbers still match, and the closing date earned its keep in about four seconds.

When last year really needs to change

Sometimes it does. Your CPA posts year-end adjustments, or a genuine error turns up. A few rules keep this clean:

  1. Talk to whoever owns the books (a controller or your accountant) before changing a closed period.
  2. If the tax return is already filed, check with your CPA. Often the right answer is a correcting entry in the current year rather than an edit to last year, and that's a call your CPA makes.
  3. Make the change, then move the closing date back where it was.
  4. Note what changed and why, so the CPA isn't surprised at the next handoff.

QuickBooks Online also has an Exceptions to Closing Date report that lists transactions changed after the closing date was set. It's worth running before every year-end handoff, because it tells you exactly what moved. Our article on how the bookkeeper and CPA handoff should work covers what else belongs in that package.

Questions owners ask

Does setting a closing date in QuickBooks close the year?

Not in the sense of posting entries. QuickBooks moves net income to Retained Earnings automatically at the start of each fiscal year. The closing date only locks transactions on or before that date so they can't be changed without a warning or password.

Can an admin still change transactions before the closing date?

Yes, with the password, and with the warning-only setting anyone with the right access can override it. That's why the password should be held by the person responsible for the books, and why the exceptions report is worth checking.

How often should I update the closing date?

Monthly, after each month is reconciled and reviewed. At minimum, set it once the year's books are final and your CPA has what they need.

Want closed months to stay closed?

Our controller services team runs a monthly close with review, sets the closing date when each month is done, and keeps the password with the person accountable for the numbers. For more practical notes on closes, controls and CPA handoffs, sign up for The ABFI Accounting Brief. Last year will thank you, in its own unchangeable way.

Start with one call

Talk with ABFI about your books. Bring your questions and your messiest account, and we'll tell you which plan fits.

Or call (804) 391-4002