ConsoliSheetMonthly reports drift. Someone renames a heading, adds a total row, or changes the sheet layout, and a process that worked in January quietly breaks in April.
The problem is distributed editing, not Excel
Once several people can edit their own copy of a template, the copies gradually diverge. A recurring consolidation process has to tolerate harmless variation, such as a reordered column, without silently absorbing a genuinely changed one, such as a renamed field with a different meaning.
Make the exception, not the rule, do the work
Most months, most submissions will match the schema exactly. Design the process so those files pass through with no manual intervention, and spend your attention only on the files that actually changed.
Why monthly reports stop combining correctly
This gradual change has a name: spreadsheet schema drift. The usual causes are small and well-meant:
- A renamed heading. Revenue becomes Sales Value because that is what the new finance lead calls it.
- An inserted column. Someone adds a Notes or Commentary column in the middle of the table.
- A moved header row. A title and reporting period are added above the table, so the headings now start on row 4.
- A total row. A subtotal is added below the data and gets counted as a record.
- An older template. One contributor reuses last year’s file, with last year’s columns.
Each one breaks a position-based process, and most also break a Power Query folder combine built on January’s file. Power Query Combine Files problems explains the specific errors and fixes.
A monthly checklist
- Compare each file’s headings with last month’s, not just with the template.
- Check where the header row is in each file.
- Look for new columns, and for columns that have gone missing.
- Check that no total or subtotal rows are being treated as data.
- Reconcile this month’s row count and totals with each submission.
Common questions
Should every contributor use the same template?
A shared template helps, but a robust monthly process should still detect when a real submission drifts from it, because eventually one will.
How do I trace a wrong figure back to its source after consolidation?
Keep a Source File column in the output. It is the difference between a two-minute check and re-opening every submission.
How do I combine monthly Excel reports when people change the columns?
Match columns by heading rather than position, compare each month’s headings with the agreed list, keep new columns visible rather than dropping them, and confirm any renamed heading before it is merged with an existing column. Keep a Source File column so each row can be traced to its submission.
Why does my monthly consolidation break when the files change?
Most processes assume the structure of the first file: the same columns, in the same order, with the headings on the same row. A renamed heading, an inserted column, a moved header row or a new total row breaks that assumption, often without an error message.
Doing this every month already?
Upload this month’s submissions together. Headings that differ only in formatting are matched automatically. ConsoliSheet suggests a few common equivalents, combined only if you accept them, and keeps every other heading as its own column unless you combine it yourself, so a new or renamed heading stays visible instead of disappearing. Each consolidation is a separate run: column decisions are not saved for next month. Over five business columns, uploading, review and the preview stay free; you pay only for the complete file. Compare One-off and Pro
Try Quick Consolidate