Solution Example collection 02
Workbook and Spreadsheet Rebuilds
Eight regional sales exports arrive each month. This rebuild keeps the file intake, Power Query logic, finance adjustments and final report checks visible in one retained Excel workbook.
- Files checked
- 192
- Invoice lines
- 150,000
- Power Query items
- 15
- Report checks
- 8 passed
Workbook anatomy
The monthly result does not begin on the report sheet.
Regional exports, credit notes and product costs enter separate queries. Finance adjustments join only after their approval is recorded, while failed invoice lines stay outside the issued result with a reason for correction.
One workbook rebuild, four points of control
Compare what arrives, what changes and what permits release.
This collection currently presents one verified Project. The useful comparison is therefore inside the routine: each stage carries a different record, judgement and question for the reviewer.
- 01
File intake
192 monthly files
The expected regional file set is checked before any sales line enters the reporting result.
Is every region and month present? - 02
Query lineage
15 named items
Folder intake, typed rows, mappings, adjustments, failed rows and the monthly output stay separate.
Which query changed the record? - 03
Finance decision
Approval kept visible
An adjustment remains a keyed record with its approval instead of becoming an unexplained formula overwrite.
Who approved this change? - 04
Release control
8 checks passed
The retained result is READY TO ISSUE. The workbook keeps the checks and the decision together.
Can the margin pack be issued?
Published workbook rebuild
Monthly Sales and Margin Workbook Rebuild
Eight regional teams send a sales export each month. Power Query combines the files, checks their columns, maps customers and products, and applies only adjustments approved by Finance. The reporting analyst can see which rows were held before the sales director reviews the margin pack.
- Monthly decision
- Are all eight files complete, are adjustments approved and is the regional sales and margin pack ready for review?
- Files and checks
- Working Excel workbook, 15 embedded Power Query items, eight passing report checks and a completed desktop open and refresh review.
- Limits
- The workbook uses deterministic non-client records derived from Microsoft Wide World Importers and does not measure a real distributor. The local build does not demonstrate a scheduled cloud refresh, shared-drive permissions, concurrent editing or a live ERP connection. The example demonstrates a controlled routine but does not prove time saved or suitability for every regional reporting process. The retained desktop Excel open and Refresh All review is dated 26 July 2026; repeat that native check after any later XLSX rebuild before release.
One invoice line
Trace REG-202601-004243 from file to margin.
The workbook evidence keeps the record key throughout. A reviewer can see the file, the approved change and the accepted monthly result without relying on a pasted total.
- 01regional invoice lines
The Scotland January file records the invoice line, quantity and net sales.
- 02approved adjustments
Finance approval changes the retained line by the recorded adjustment amount.
- 03monthly sales margin
The accepted line enters January sales and margin once after all checks pass.
What a handover should include
A formatted worksheet is not enough.
The workbook, query definitions, human decisions and release evidence must remain together. That is what makes the next refresh explainable and the handover credible.
- 01
Working workbook
The retained XLSX opens as a workbook and is inspected rather than replaced by a web render.
- 02
Power Query definitions
Named M definitions show how the files are connected, typed, mapped, checked and loaded.
- 03
Manual decisions
Finance adjustments retain a stable key and approval instead of disappearing into worksheet formulas.
- 04
Report checks
File, schema, duplicate, mapping and reconciliation checks remain beside the issue decision.
Built by Quanta Meridian using deterministic non-client example data. The source code, seed, assumptions and validation results are retained with the project.
Start with the workbook people already use
Separate file intake, adjustments and checks before automating them.
Bring the current workbook, a sample of its files and the steps people repeat each period. The first review does not require confidential or protected data.