Money Matters

Reducing spreadsheet rework in a multi-site FQHC’s month-end close

Multi-site FQHC finance teams lose time rebuilding site, grant, and program reports in spreadsheets. Where that time goes, and how to win it back.

Published September 24, 20266 min read Share

In many multi-site federally qualified health center (FQHC) finance teams, what slows the close is rework, not the people doing it. When site, grant, and program codes are hard to report on consistently, finance teams may spend extra time rebuilding board packs and grant reports in Excel. That rework can delay month-end reporting and leave less time for variance analysis, cash and accounts receivable (AR) forecasting, and payer review.

We’ll walk through why the sector’s growth pattern strains workbook-based closes, what the manual roll-up costs your team, and what the close looks like when it runs on a dimensional general ledger.

Key takeaways

• A slow close is often a reporting-structure problem, not a people problem: rebuilding site, grant, and program views in spreadsheets after each close adds work that grows with every new location.
• Health center locations have grown much faster than organizations: according to the National Association of Community Health Centers (NACHC), whose analysis of Uniform Data System (UDS) data includes look-alikes, sites rose about 17% between 2020 and 2023 while the number of organizations rose about 2%.
• A dimensional general ledger keeps the dimensions you configure, such as site, program, and grant, intact through the close, so reporting by them becomes a filter rather than a rebuild.
• Grant reporting and audit preparation are easier when approvals and grant tags live in the finance system rather than in email threads and workbook versions.

Here’s what we’ll cover

How growth adds reporting work

Health Resources and Services Administration (HRSA) data show that in 2025, 1,356 federally funded health centers served about 32.7 million patients, and another 170 look-alike health centers served about 1.65 million. Locations have grown much faster than organizations. According to NACHC’s analysis of UDS data, the number of health center organizations rose from 1,462 in 2020 to 1,496 in 2023, while the number of sites rose from 13,867 to 16,270, an increase of about 17%.

For finance, each new site adds another location to track; each new service line can add program and grant dimensions. Managed care contracts add yield calculations on top of that. A workbook that handled one clinic and two grants does not scale easily to five sites, several federal and state grants, multiple payers, and a handful of other funding streams, not without manual work at every close that grows as the organization does.

For many health centers, the problem is not separate books. It is one ledger whose structure was not set up for this many dimensions. Site, grant, and program get squeezed into account segments or class codes, and the real reporting happens in Excel: entries re-tagged by grant, costs allocated across programs, site views rebuilt by hand. Organizations that grew through acquisition, or that run affiliates such as a foundation or a property company, carry a second layer on top: separate trial balances that have to be consolidated before any of that work can start.

What the manual roll-up costs

The direct cost is time. While the close is still open, final numbers for variance analysis, cash and AR forecasting, and payer analysis are not ready, and the longer the close runs, the older those numbers are when they arrive.

Payer analysis also tends to become ad hoc. Finance, electronic health record (EHR), and revenue cycle data often live in separate systems, which slows reconciliation and makes payer yield harder to see. By the time the CFO can see cost per visit by site or yield by payer, the period may be weeks old.

Board finance committees face the same lag. When the board pack is built from a finished workbook, a follow-up question about program performance or grant spend often means another off-cycle extraction, and definitions can drift from one version to the next.

Audit preparation is the third cost. When approvals sit in email and allocations sit in workbooks, assembling evidence for auditors and funders means tracing who approved what, and when, across inboxes and file versions.

What the close looks like on a dimensional ledger

A close built on a dimensional general ledger works differently. Transactions carry the dimensions you configure, typically site, program, and grant, with payer and provider added where they apply, such as on patient revenue and provider costs. Configured and populated consistently, those dimensions make reporting by any of them a filter rather than a rebuild. For organizations with separate entities, a system with appropriately configured consolidation capabilities can also automate roll-ups and intercompany eliminations.

The practical effect is that the close that produces your financial statements also produces the cost and revenue views your board and grant managers ask for, by site, program, and grant. Variance analysis can start from ledger data as soon as it is posted, rather than waiting for the workbook.

Dimensions that survive consolidation

The key requirement is that dimensions survive consolidation intact. When those dimensions are native to the general ledger rather than applied in a workbook, the board summary, grant reports, and payer reviews start from the same source. Account reconciliations and review still happen, but the finance team spends far less time reconciling one spreadsheet version against another.

What recaptured time looks like

Hunter Health, a multi-location FQHC in Wichita, Kansas, shows what recaptured time can look like. According to its Sage customer story, the finance team used Sage Intacct to decentralize purchasing, automate monthly bank reconciliations, and streamline grant reporting, and the month-end close went from a full month to under 10 business days. Those changes happened together, so the result does not isolate a single cause, and one organization’s result is not a sector benchmark. It does show where the time goes: manual steps such as paper approvals, bank reconciliations, and grant roll-ups.

For a controller or CFO, the useful starting point is your own close: which reports get rebuilt every month, which mappings keep failing, and which reconciliations and approvals have to stay. Then test whether a system can carry site, grant, and program consistently, report by them without a rebuild, and, if you run affiliates, consolidate them without a workbook.

Frequently asked questions

What is a dimensional general ledger and why does it matter for multi-site FQHCs?

A dimensional general ledger stores attributes such as site, program, and grant on transactions, with payer or provider where they are relevant. For a multi-site FQHC, this means site, grant, and program reports are a filter on the ledger rather than a separate rebuild in Excel, and the board summary and grant reports start from the same numbers.

How does multi-entity consolidation differ from a spreadsheet roll-up for community health centers?

In a spreadsheet process, grant, program, and site reporting is rebuilt in Excel each period, and any affiliated entities are consolidated by hand on top of that. Both steps grow slower as the organization adds sites. A dimensional ledger carries those attributes on each relevant transaction, so site and grant views are available without a rebuild. For organizations with separate entities, a system with appropriately configured consolidation capabilities can also automate the roll-up and intercompany eliminations.

Is cloud-based FQHC accounting software realistic for a smaller multi-site health center?

Often, yes. Small finance teams frequently manage several sites, grants, and programs with only a handful of people, so rebuilding reports by hand takes a larger share of their time. A cloud platform also removes the need to host and maintain servers on site, although integrations, user administration, and security still need an owner.

Read Hunter Health’s customer story to see how the Wichita, Kansas FQHC cut its month-end close from a full month to under 10 business days and gained visibility by department and by grant.

Browse more topics from this article

• Business intelligence
• CFO
• Cloud financial management