What is an account roll-up?

Definition

An account roll-up is the way detailed accounts are added into a higher total on a report. You still post to the small accounts, and the statement shows the group.

This is a reporting step, not a new posting. Cafe receivables and wholesale receivables keep their own balances, and the Balance Sheet may print only one receivables line.

Where it shows up

Balance sheet: Related to the grouped totals on the statement.

P&L: Related to the grouped totals on the statement.

Cash flow: Related to nothing extra.

See also: Chart Of Accounts · Trial Balance · Chart Of Accounts Mapping

When you look at a Balance Sheet, you rarely see every account the shop uses. You see grouped totals, such as cash, receivables, and payables.

The Trial Balance still lists every account. The roll-up is what happens between that list and the statement the owner reads.

A high grouped total means the accounts inside that group add to a large number. It does not tell you which customer or which location is driving it.

On the Income Statement, flower sales, workshop sales, and delivery fees may sit on three accounts and still print as one revenue line. The ledger keeps the split even when the statement does not.

You will meet the same idea on a location report. The shop may keep rent in two accounts and still show one rent total when the owner wants a simple page.

How it works

The chart of accounts holds the detailed accounts. A report map says which of those accounts belong on which statement line.

How a roll-up usually works:

• Keep detail in the ledger (for example 1200 and 1210)
• Map those accounts to one statement line in the report definition
• Let the software add the group when the report runs
• Nest groups when needed (receivables into current assets with cash and inventory)
• Fix missing or double-mapped accounts so the group is neither short nor too high

Numbers often share a prefix so the add-up is obvious. 1200 and 1210 can both roll into accounts receivable.

The software does the adding when the report runs. Nobody posts a third entry to a total-receivables account unless the books are set up that way on purpose.

If an account is left off the map, its balance still sits in the ledger. It simply never appears on that statement line.

If an account is mapped twice, the group is too high. That is a mapping error, not extra cash.

A location report can cut the other way. The same rent accounts may stay split by shop so one store's cost is not hidden inside a company-wide total.

The roll-up does not change the underlying balances. It only decides how those balances are shown.

Example

A florist keeps 1200 for cafe accounts receivable and 1210 for wholesale accounts receivable. At month end, 1200 shows $2,400 and 1210 shows $1,600.

The Trial Balance prints both lines. The Balance Sheet prints one receivables figure of $4,000.

The owner still needs the split to call the cafe and the wholesaler. The bank and the landlord only need the grouped total.

If the florist later adds 1220 for event work sitting as a receivable, that new account has to join the same group. Miss it, and $800 never shows on the statement.

The $4,000 is not a new posting. It is 1200 plus 1210, shown as one line.

Common mix-ups

A roll-up is not a journal entry. Nothing is debited or credited when the report adds 1200 and 1210.

A roll-up is not the same as combining companies. Consolidation puts two legal entities together, while a roll-up puts two accounts from the same books onto one line.

A roll-up is not renaming. Changing Cafe AR to Receivables on the account itself hides the detail in the ledger, but a roll-up keeps the detail and only groups it on the report.

Related terms

• Chart Of Accounts: The organized list of every account used to record transactions.
• Account Number: The numeric code that places an account in the chart of accounts.
• Trial Balance: A listing of every ledger account balance, used to check that debits equal credits.
• Balance Sheet: A statement showing what a business owns, what it owes, and what is left for owners at a single point in time.
• Income Statement: A statement showing revenue earned and expenses incurred over a period, ending in net income.
• Chart Of Accounts Mapping: Aligning one account structure to another for reporting or system migration.
• Consolidation: Combining multiple entities into one set of financial statements.
• Departmental P&L: An income statement split by department, location, or product line.