Managing cash across multiple locations is one of the most persistent operational challenges for businesses in the DRC — whether you run a security firm with zones in Goma, Bukavu, and Beni, an NGO with field offices across the East, or a retail chain with branches across Kinshasa.

The solution most finance teams reach for is a complex folder structure of individual zone spreadsheets, emailed daily and manually consolidated at HQ. This approach works — until someone forgets to send their file, enters data in the wrong column, or the CEO needs a real-time summary on a Sunday evening.

A Power Query–based multi-zone cashbook eliminates all of this.

How It Works

The system uses Microsoft Excel’s Power Query (Get & Transform Data) engine to automatically pull cash data from individual zone workbooks stored in a shared folder (SharePoint, OneDrive, or a local network drive), consolidate them into a single master cashbook, and refresh the summary with one click.

The Architecture

• Zone Files: Each location maintains its own simple Excel cashbook with standard columns: Date, Description, Category, Zone, Inflow (USD), Inflow (CDF), Outflow (USD), Outflow (CDF), Balance.
• Master Consolidation File: A central workbook uses Power Query to point to the shared folder containing all zone files. One query pulls all zone data dynamically — no manual copy-pasting.
• Summary Dashboard: Pivot tables driven by the consolidated data feed a real-time dashboard showing: closing balance by zone, total inflows/outflows by category, variance vs. budget, and flagged negative balances.

Key Steps to Build It

1. Standardise zone file column headers — Power Query requires consistency to merge correctly
2. Store all zone files in a single shared OneDrive or SharePoint folder
3. Use Power Query’s “From Folder” connector to point the master file at that folder
4. Write an M query that filters for .xlsx files only and expands the data table
5. Connect the consolidated query output to pivot tables and slicers
6. Set up automatic refresh on file open (Data > Connections > Properties > Refresh on Open)

Why This Matters in the DRC Context

In environments with unreliable internet, Power Query can be configured to work purely on a local LAN. In environments with USD/CDF dual-currency operations, the same cashbook structure handles multi-currency columns natively.

Valid Wave Consulting builds this exact system for clients across the DRC and Rwanda. Visit our Marketplace to purchase the ready-made Multi-Zone Cashbook template, or book a session to have us build a custom version for your infrastructure.