QuickBooks Online Users Cannot Drill Into Retained Earnings From the Balance Sheet

A recurring question in the QuickBooks Online community concerns Retained Earnings, the balance sheet line that holds profit kept in the business over time. Users click the figure expecting the transaction detail every other account provides. The drill-down comes back empty, and the accepted answer in the community thread explains both why and what to do about it.

The pattern tends to surface soon after a fiscal year turns. Someone reviewing the balance sheet notices the figure has grown, or it no longer matches the prior year’s profit as they expected. Clicking the line for an explanation leads nowhere. The question also resurfaces whenever someone outside the business, an accountant or a lender among them, asks what sits behind the number. What looks like missing data is actually the product working as designed.

Why can’t you click Retained Earnings?

Every other balance sheet account is a ledger of real entries. Retained Earnings is not. It holds the total of income and expenses from all previous fiscal years, and the software maintains it on its own.

At the start of each new fiscal year, QuickBooks Online moves the previous year’s net income or loss into Retained Earnings. That transfer happens whether or not you close your books; closing is a separate safeguard, not a trigger. The movement is an internal swap rather than a recorded transaction, so no report lists it. Unless entries have been posted directly to the account, there is nothing to drill into.

The workaround: an all-dates Profit and Loss report

Since the balance is built from net income, the accepted answer sends users there for the detail. The route runs through a standard report rather than the balance sheet.

Open the Reports menu, choose Standard reports, and select Profit and Loss. Set the report period to All Dates and refresh. Then click the Net Income figure. QuickBooks opens a transaction report spanning every date in the file, which is the closest thing to a Retained Earnings detail view the product provides.

Comparing the balance year by year

One cumulative number rarely satisfies anyone. Most people want to know which years built the balance and which ones drained it.

Open the Profit and Loss report and select Customize. Expand the rows and columns section, then choose the periods you want compared, such as individual fiscal years. For a single past year, set the report period to that year alone. The report splits net income across those spans, and each figure opens its own transaction detail through the same click. The result answers the question the balance sheet will not.

Limits of the account’s own report

The chart of accounts offers a Run report action on the Retained Earnings line, reached through Accounting and then Chart of accounts. It tends to be of little help here. In practice it shows only entries posted straight to the account, and the year-end swap never appears in it. A substantial balance can sit beside a nearly empty report, which is exactly the sight that sends people searching for answers. Treat it as a supplement rather than a substitute.

One more caveat comes from the accepted answer. Journal entries added by hand to Retained Earnings do not get picked up by these drill-down views. The all-dates Profit and Loss route remains the dependable one.

Report screens vary between accounts

Menus in QuickBooks Online reports have shifted over time, and some users now see an enhanced layout while others remain on the classic view. A label on your side may read slightly differently from the steps above. We have kept the wording loose for that reason. Either way, the approach holds: the Profit and Loss report, set to all dates, is where the detail lives.

For now this is a design choice rather than a malfunction. The software treats the year-end sweep as internal bookkeeping and keeps it out of sight. Anyone tracing Retained Earnings should start with the Profit and Loss report, not with the balance sheet figure itself.