Demo Reconciliation · 305 Example (Project 450848)
| Transactions Tab (119 rows) | Front Sheet | Difference | |
|---|---|---|---|
| Actual Costs | 172,678.40 | 172,678.40 | 0.00 |
| Labour | 48,595.07 | 48,595.07 | 0.00 |
| Sub-Contractor | 95,525.30 | 95,525.30 | 0.00 |
| Materials & Plant | 28,558.03 | 28,558.03 | 0.00 |
| Actual Sales | 147,564.64 | 147,564.64 | 0.00 |
On the Transactions tab, Materials & Plant is Materials 23,106.35 plus Plant 5,451.68. The front sheet reports the combined 28,558.03 as Materials.
Question · Can the Source Tables Feed Power BI?
Yes, using the CVR spreadsheet as the datasource. Power BI only sees the transactions in the file, not the whole source database.
- Save the CVR workbook in a SharePoint or OneDrive folder with a fixed name, for example
CVR_CurrentMonth.xlsm. The synced folder works like any local folder, so dropping the file in is a normal save. No reason not to use SharePoint or OneDrive here. - In Power BI Desktop: Get Data → Excel workbook → connect using the file's SharePoint or OneDrive web link (not the synced local path) → pick the Transactions table.
- Build the report and Publish to the Power BI Service.
- Each month, overwrite the file in the same location with the same name.
- Refresh picks up whatever file is sitting there. Nothing to rewire. Because the file is in SharePoint or OneDrive, refresh also works in the Service with no gateway.