The Month Changed. Why Are You Rebuilding the Same Report?
Separate incoming data, preparation rules and the final monthly report. Add reconciliation checks so next month does not mean rebuilding the same workbook.

The new sales export arrives. You copy last month’s workbook, clear some cells, paste the new rows and spend the next hour remembering which adjustments belonged to the method and which belonged only to last month.
A recurring report becomes easier to maintain when you separate the incoming evidence, the preparation rules and the final view. The month should supply new data without forcing you to rediscover the whole reporting process.
Keep three things distinct
Imagine a fictional florist preparing a monthly sales overview. The source file contains transactions. A preparation step makes its fields usable. The report groups the result around the owner’s question, such as which product categories changed compared with the previous period.
These are different jobs. If a correction is typed directly into the final summary, the next refresh may not preserve it. If an unusual transaction is silently deleted from the incoming file, a colleague may never know why the report differs from the original export.
Keep an untouched source copy, a deliberate preparation route and a clearly labelled output. Record any correction where it can be explained and repeated appropriately.
Write the rules before repeating the clicks
List the changes you make every month: recognising dates, keeping identifiers intact, assigning categories and deciding which records belong in the period. Then mark the adjustments that were exceptional.
An exceptional correction should not quietly become a permanent rule. A one-off category change for a single transaction can alter unrelated records if copied into next month’s process without review.
Power Query can record data-preparation steps in Excel. Whether you use it or a carefully documented manual routine, the important editorial question is the same: can somebody explain why each step exists?
Add a small reconciliation note
Before discussing the month, compare the source and prepared result. Record the incoming row count, a relevant total and any excluded or unmatched records. Choose checks that fit the meaning of the data; row count alone cannot tell you whether a file contains orders or order lines.
For the florist, an exception list might explain a cancelled transaction or a product code that needs classification. Keep unresolved cases visible rather than making the report look finished by removing them.
The note should let the owner distinguish a genuine business change from a change in how the data was prepared.
Try next month before calling it repeatable
Use a fictional second file with the same expected structure. Follow the written method and compare the output with your expectation. Include one unfamiliar category or incomplete record to see where review is needed.
If the method only works when its creator remembers an undocumented trick, improve the note or preparation step. If the new file changes structure, stop to assess that change rather than forcing it through the old assumptions.
A useful monthly routine leaves you with a report you can explain and a short record of what needs attention. The goal is to spend the next reporting conversation understanding the business, with the preparation method already visible.
Keep the reporting method connected
Explore the Make the Monthly Report Useful Before Making It Bigger guide and the related practical questions below.
- Sales Went Up. Are You Comparing the Same Kind of Month?
- Your Report Has Twelve Tabs. Which Decision Is It Helping You Make?
If you want a written practice route, review the Excel Monthly Reports with Matze course overview. It requires compatible Excel Desktop for Windows with Power Query; you build the report yourself.
Check the course contents and current price. Affiliate link: Superstore may earn a commission if you buy. Check current contents, requirements and terms before purchasing.
Technical reference: Microsoft: About Power Query in Excel. Checked 17 November 2026. The fictional business exercise and reporting recommendations above are Superstore editorial guidance.




Discussion 0
What did this article make you think about?