Stockertim Dictionary · Artificial intelligence · Technology
Control total
Also called control totals, batch total, check total
In short
A total calculated independently from the source data and compared with the processed or summarised data to confirm that nothing was lost or counted twice.
- Intermediate
- Concept
- Checked
In detail
A control total is a simple check that a summary still matches its source. Before data are filtered, merged, pivoted or loaded into another system, the analyst records a total from the source, such as the number of rows or the sum of an amount column. After processing, the same total is calculated from the result. If the two agree, nothing was lost or doubled; if they differ, something went wrong.
The idea comes from accounting and batch processing, where clerks added up a batch of documents before keying them in and compared the figure afterwards. It suits AI-assisted analysis well, because a generated formula, pivot or query can look perfectly reasonable while silently dropping rows or counting some twice.
Common causes of a mismatch are a join that matches one row to several, a filter that excludes blanks, a pivot range that stops short of the last rows and duplicate records. The size of the difference often points to the cause: a gap equal to one order's value suggests that order was doubled.
Good practice is to state the control totals in the analysis log and on the final summary, so readers can see that the regional figures add up to the grand total and that the grand total matches the source.
Worked example
The source file holds 2,500 orders worth US$92,000. An assistant-built pivot after merging a customer table shows US$95,400 across three regions.
- Difference: US$95,400 - US$92,000 = US$3,400
- The merged file has 2,512 rows, so 2,512 - 2,500 = 12 extra rows
- Twelve customers appear twice in the customer table, and their orders total US$3,400.
- After fixing the merge, regions: US$42,500 + US$31,200 + US$18,300 = US$92,000
- Rows by region: 1,180 + 860 + 460 = 2,500
The corrected pivot matches the source on both value and row count, and the control totals are shown under the table.
In practice
Analysts, accountants and data engineers record control totals before and after every major step, such as cleaning, merging, loading and summarising. Finance teams reconcile reports to ledgers this way, and auditors look for evidence that it was done.
Watch out
- A matching value total can hide offsetting errors; check row counts as well.
- A control total taken after processing is not independent; take it from the source first.
Learn it properly
Official sources
- Technology · International Auditing and Assurance Standards Board
- AI Risk Management Framework · National Institute of Standards and Technology
Facts last checked on 3 November 2026.
Education, not advice: the Stockertim Dictionary explains what terms mean. It never recommends buying or selling anything.