All articles

QuickBooks Retained Earnings Incorrect: Find and Fix It

9 min read CSVQBO Team
csv / xls / xlsx → .qbo
No file handy?

No account needed for your first conversions. We never store your bank login.

Short answer: retained earnings is wrong for one of exactly two reasons. Either somebody posted a transaction directly to the retained earnings account, which you can see in seconds, or a prior-year transaction was added, edited or deleted after that year closed, which you cannot see at all because QuickBooks never wrote a closing entry to look at. Check the first one first, because it takes thirty seconds to rule out.

Almost every retained earnings question starts the same way. The balance sheet shows a number in equity, the client asks where it came from, and there is nothing to click on. The account register looks empty or nearly empty. No journal entry says Close Year. The instinct is that something is broken. Usually nothing is broken, and the confusion is a direct consequence of how QuickBooks handles year end.

Where does QuickBooks get the retained earnings figure?

It calculates it. Retained earnings is a rollover of every previous fiscal year's net profit or loss, and QuickBooks performs that rollover automatically without recording a visible transaction. On the first day of your fiscal year, QuickBooks Desktop increases the retained earnings equity account by the previous year's net income and decreases net income by the same amount, so the new year starts with net income of zero. QuickBooks Online does the same swap electronically.

Intuit is explicit that Desktop does not create an actual transaction for the closing entries it makes. The program computes the adjustment at the moment you run a report, which is why you cannot QuickZoom into it and why the register looks bare. There is no entry because there was never an entry, only arithmetic performed on the fly.

That design has one very practical consequence. Since the rollover is recalculated every time you run a report rather than frozen into a transaction, changing any prior-year income or expense transaction today silently changes retained earnings today. Nothing warns you. Nothing logs it in the account. The number just moves.

Why can't I find the retained earnings closing entry?

Because it does not exist as a transaction. This is the single most common source of the panic. Bookkeepers coming from software that writes real closing journal entries go looking for one in QuickBooks, find nothing, and conclude the file is damaged. It is not. QuickBooks computes the close rather than posting it.

What you can see are transactions a human posted directly into the retained earnings account, and those are exactly what you are hunting for when the balance looks wrong. In QuickBooks Online, go to Accounting, then Chart of accounts, find Retained Earnings, open the Action column dropdown and choose Run report, then set the Report period to All Dates. Anything that appears there was put there by a person. In Desktop, run a QuickReport on the account and do the same read.

An empty report is useful information rather than a dead end. It tells you nobody posted directly to equity, which means the movement came from prior-year activity changing underneath the rollover.

How do I fix retained earnings in QuickBooks?

Work in this order, because the cheap checks eliminate most cases.

1. Run the retained earnings report over all dates. If a journal entry, deposit or bill shows up, you have found your culprit. Somebody used retained earnings as a plug, usually to force a balance sheet to agree with a tax return or a prior accountant's trial balance. Decide whether that entry was correct. If it was a legitimate prior period adjustment, leave it and document why. If it was a plug, reverse it and fix the real underlying error.

2. Compare each year's net income to what rolled in. Run a Profit and Loss report, set the date range to a full prior fiscal year, and note the net income. That figure, added to the retained earnings balance at the start of that year, should equal the balance at the start of the next year. Walk it forward year by year until one year fails to tie. That year is where your problem lives, and you have just narrowed a vague equity discrepancy down to twelve months.

3. Open that year's Profit and Loss Detail. Now you are looking for transactions dated in the closed year that were entered or modified after the year was closed. A bill posted in March of this year but dated to last December. A category change somebody made while cleaning up. A voided check that used to be an expense. Any of these move retained earnings without touching the equity account.

4. Reconcile the fixed number to the tax return. The equity your tax preparer reported is the outside check on all of this. If your books and the return disagree, one of them needs an adjusting entry, and it is worth re-running the prior year's financial statements from the corrected ledger so you are comparing complete statements rather than a single balance.

How do I adjust retained earnings in QuickBooks Online?

Through a journal entry, and only after you have identified what the adjustment is actually correcting. Select New, then Journal Entry, date it to the first day of the current fiscal year rather than inside the closed period, and post the correcting amount to Retained Earnings with the offsetting side to whatever account was actually wrong. Write a memo that says what you are fixing and why, because whoever looks at this in two years will otherwise see an unexplained plug in equity.

Dating matters more than people expect. An entry dated inside a closed year changes prior-year reports that have already been filed against, and if you have a closing date set it will prompt for the password. Dating it to the first day of the open year keeps the closed year's filed figures intact while putting the correction in the right account. If the amount is material and prior-year returns were filed on the wrong number, that is a conversation with the tax preparer, not a bookkeeping decision.

Why is retained earnings negative in QuickBooks?

Usually because the business has genuinely accumulated more losses than profits, which is completely normal for a company in its first few years or one coming off a bad stretch. Negative retained earnings is called an accumulated deficit and it is a real accounting condition, not an error message.

It is only a red flag when the sign does not match the story. If the company has been profitable every year and retained earnings is still negative, look for owner draws or distributions being coded straight to retained earnings instead of to a separate Owner's Draw or Distributions equity account. That is the most common cause of a profitable company showing a deficit, and it is worth separating because a lender reading the balance sheet cannot tell accumulated losses from money the owner took out when both land in the same account.

The other version of this is an S corporation where distributions, basis and retained earnings have never been kept apart. Fix the account structure first, then the balance usually explains itself.

How do I stop retained earnings from changing again?

Set a closing date and a closing date password. In QuickBooks Desktop this lives under company preferences and it forces anyone who tries to enter or edit a transaction affecting the closed fiscal year to type the password first. QuickBooks Online has the equivalent under account and settings. Without it, any user with edit rights can quietly change last year at any time, and since the rollover is recalculated rather than stored, last year's equity moves with them.

Set it every year as part of closing, not once and never again. A closing date from three years ago protects three-year-old data and leaves the two most recent years wide open, which is where the edits actually happen.

The second habit is a short reconciliation between the books and the filed return at the same time each year. Comparing the equity section to the return once, deliberately, catches the drift while the transactions are still recent enough that somebody remembers them. Waiting until a lender or a new accountant asks means reconstructing a three-year-old decision from nothing.

What about opening balance equity?

Different account, related mess, and the two get confused constantly. Opening Balance Equity is a temporary holding account QuickBooks creates when you enter opening balances for accounts, and it is supposed to be emptied into retained earnings or owner's equity once the file is set up correctly. Retained earnings is the permanent accumulation of prior-year results. If your file has a stubborn balance in Opening Balance Equity, that is its own cleanup job, covered in the opening balance equity cleanup guide.

A balance sheet that will not balance at all is a third, separate problem with a different diagnostic path, and it is worth ruling out before you spend an afternoon on equity accounts. The balance sheet out of balance walkthrough narrows that one to a single date.

The short version for a client cleanup

Run the retained earnings report over all dates and look for human entries. Walk each year's net income forward and find the year that does not tie. Open that year's Profit and Loss Detail and look for transactions dated in the closed year but touched afterward. Correct with a dated, documented journal entry in the open year. Then set a closing date password so it does not happen again. Most retained earnings mysteries end at step one or step two.

If the underlying problem is that a year's bank activity was never fully entered, the fix starts further upstream. Getting a full year of transactions into QuickBooks accurately is its own exercise, and importing them beats keying them: the best CSV to QBO converter comparison covers the tools that turn a bank CSV export into a file QuickBooks will accept, and the reconcile a year of QuickBooks in one sitting guide covers the order to do it in. For a broader pass, the new client cleanup checklist puts equity in sequence with everything else worth checking.

Convert your CSV to QBO now

Upload your CSV or Excel statement, map the columns, and download a QuickBooks ready QBO file in seconds.

Start converting