Utility Bill Accruals: How to Estimate, Allocate, and Reverse

Utility providers bill on their own cycles, not yours. A typical electric company might meter from the 21st of one month to the 20th of the next, while your general ledger closes on the 31st. That mismatch means every month-end close requires an estimate: how much of each outstanding utility bill belongs to the period you're closing?

This is the core problem behind utility bill accruals. Unlike rent or insurance, where amounts and periods are contractually fixed, utility expenses vary by consumption and arrive on staggered billing cycles that almost never align with calendar month-end. The result is a recurring estimation exercise that touches every utility account across every location.

The daily-rate proration formula gives you a straightforward method to split a bill across accounting periods. Divide the total bill amount by the number of days in the billing period to get a daily rate, then multiply by the number of days falling in your accounting month.

Take a $3,000 electric bill covering March 21 through April 20. That billing period spans 31 days, producing a daily rate of $96.77. If you're closing March 31, eleven days of that billing period (March 21–31) fall in March. Your accrual: $96.77 × 11 = $1,064.47. The remaining $1,935.53 belongs to April.

The dollar impact of getting this wrong is larger than many controllers assume. The U.S. commercial sector spent $238.4 billion on energy in 2023, with electricity alone accounting for $177.3 billion, according to U.S. commercial sector energy expenditure data from the EIA. For a multi-site business managing dozens of utility accounts across electricity, natural gas, water, and telecom, even a few percentage points of proration error compound quickly. A 5% miscalculation on a $50,000 monthly utility spend across ten locations puts $25,000 in the wrong period.

The accuracy of each utility expense accrual depends on a handful of specific data points pulled from every bill: the billing period start and end dates, the total charges, and where available, consumption figures (kWh, therms, gallons) that inform trend-based estimates. Pulling these inputs consistently from PDF bills across dozens of providers and formats is where the accrual process most often breaks down, particularly at scale.

Calculating Utility Accruals with Daily-Rate Proration

The core of any utility accrual is a single question: how much of this bill belongs to the current accounting period? Daily-rate proration gives you a repeatable, defensible answer. The method works the same whether you're accruing for electricity, natural gas, water, or telecom.

Daily Rate = Total Bill Amount / Days in Billing Period

Accrual Amount = Daily Rate × Days Falling in Current Month

Here is the calculation in five steps:

1. Identify the billing period start and end dates from the utility bill itself.
2. Count the total days in the billing period. Include the start date, exclude the end date (or follow your company's convention consistently).
3. Divide total charges by total days to arrive at the daily rate.
4. Count the days of that billing period falling within your accounting month.
5. Multiply the daily rate by those days. That figure is your accrual.

Before you can run this calculation, you need specific data points from each bill: the billing period start date, billing period end date, total charges (ideally broken into demand charges, usage charges, and taxes/fees), and consumption figures (kWh, therms, CCF, or gallons depending on the utility type). Extracting these fields consistently from PDF bills across dozens of providers and formats is the practical bottleneck for most finance teams. Tools like Invoice Data Extraction let you automate utility bill data extraction from PDF utility bills, pulling billing period dates, charge breakdowns, and consumption figures directly into structured output so the numbers are ready for your accrual spreadsheet without manual keying.

Worked Example 1: Electric Bill

Your company receives an electric bill for $4,650.00 covering the billing period March 12 through April 10 (30 days). You need the accrual for March.

• Daily rate: $4,650.00 / 30 days = $155.00 per day
• Days in March: March 12 through March 31 = 20 days
• March accrual: $155.00 x 20 = $3,100.00

When the April bill arrives and you close March, you book $3,100.00 as the utility expense accrual for March. The remaining $1,550.00 ($155.00 x 10 days in April) hits April's expense when you perform the same proration on the next cycle.

Worked Example 2: Natural Gas Bill

A natural gas bill totals $2,280.00 for the period February 22 through March 24 (30 days). You need accruals for both February and March.

• Daily rate: $2,280.00 / 30 days = $76.00 per day
• Days in February: February 22 through February 28 = 7 days
• February accrual: $76.00 x 7 = $532.00
• Days in March: March 1 through March 24 = 24 days
• March accrual (from this bill): $76.00 x 24 = $1,824.00

Note that March will also pick up a prorated share of the next gas bill covering March 25 onward. The two pieces together form the complete March natural gas expense.

When the Simple Daily Rate Falls Short

Utility costs are not uniform across the year. Heating bills spike in winter; cooling costs climb in summer. The straightforward daily-rate approach assumes costs are evenly distributed across the billing period, and that assumption holds well when the entire billing period falls within a single season. A January gas bill prorated into January and February is unlikely to distort your numbers.

The risk appears when your accrual spans a seasonal transition. A billing period from mid-March through mid-April, for example, may blend the tail end of winter heating with early spring usage. In these cases, a flat daily rate can over-accrue the warmer days or under-accrue the colder ones.

A practical rule of thumb: use the prior year's same-month actual as a sanity check. If your calculated accrual for April deviates significantly from last April's actual expense, investigate whether a seasonal shift is the cause. For utilities with highly seasonal consumption patterns (natural gas for heating, electricity for cooling-heavy facilities), some teams maintain weighted daily rates derived from twelve months of historical bills. This adds complexity, so reserve it for cases where the variance is material to your financial statements. For most billing periods that sit cleanly within one season, the simple daily-rate proration is both accurate enough and far easier to audit.

---

Journal Entries for Booking and Reversing Utility Accruals

The accrual estimate means nothing until it hits the general ledger. Getting the journal entries right, and getting the reversal mechanics right, is what prevents double-counted expense or a phantom liability sitting on your balance sheet months after the bill was paid.

The full cycle has three entries, executed in sequence each period. Here they are using the $1,064.47 electricity accrual from the daily-rate proration example, the March portion of a $3,000 bill covering March 21 through April 20.

Entry 1: Book the Accrual at Month-End

On the last day of March, record the estimated utility expense for the unbilled portion:

Date	Account	Debit	Credit
March 31	Electricity Expense	$1,064.47
March 31	Accrued Utilities Payable		$1,064.47

This entry ensures March's income statement carries the electricity cost that belongs to March, even though the bill won't arrive until late April. Accrued Utilities Payable is a current liability sub-account under Accrued Liabilities, kept separate from trade AP so you can track unbilled utility obligations at a glance.

Entry 2: Reverse the Accrual at Period Open

On the first day of April, the reversing entry posts automatically (most ERP and GL systems support auto-reversing journal entries flagged at creation):

Date	Account	Debit	Credit
April 1	Accrued Utilities Payable	$1,064.47
April 1	Electricity Expense		$1,064.47

After this entry posts, Accrued Utilities Payable drops back to zero and Electricity Expense carries a temporary credit balance of $1,064.47 in April. That credit balance is intentional; it exists to offset part of the actual invoice when it's recorded.

Why reverse at all? Without the reversal, recording the full invoice through accounts payable would double-count the expense. The reversal zeroes out the estimate so the actual bill can post cleanly.

Entry 3: Record the Actual Invoice

The utility company's invoice arrives on April 22 covering the billing period March 21 through April 20, totaling $3,000.00. Your AP team records it normally:

Date	Account	Debit	Credit
April 22	Electricity Expense	$3,000.00
April 22	Accounts Payable — Electric Co.		$3,000.00

How the Numbers Net Out

Trace the Electricity Expense balance across both months to confirm each period gets its fair share:

March: The accrual entry posts $1,064.47 of expense. That covers the 11 days of the billing cycle that fell in March (March 21–31), and it's the only electricity expense March carries.

April: The reversal creates a ($1,064.47) credit, then the actual invoice adds $3,000.00. Net April electricity expense: $1,935.53. That $1,935.53 represents the 20 days of the billing cycle that fall in April (April 1–20), exactly the remaining portion of the bill.

The total across both months equals the $3,000.00 invoice. No double-counting, no missing expense, and each month's P&L reflects usage for the days that actually occurred within it.

Reversal Method vs. True-Up Method

The auto-reversal approach shown above is the most common method for utility accruals because it keeps the process mechanical and predictable. Flag the accrual entry as auto-reversing, and your GL handles Entry 2 without anyone touching it. For organizations running dozens or hundreds of utility accounts, this is the only approach that scales without manual intervention each period.

Some organizations prefer a true-up method instead: the accrual stays on the books until the actual bill arrives, at which point the accountant debits Accrued Utilities Payable (instead of Electricity Expense) and credits Accounts Payable, clearing the liability directly. The trade-off is real. True-up gives you better visibility into unbilled utility amounts at any point in the month, useful if management reviews accrued liabilities mid-period. But it requires someone to manually match each incoming bill against its corresponding accrual and clear it, which introduces friction and error risk when you're managing accruals across many accounts.

For most teams running month-end close under deadline pressure, the reversing entry method is the safer default. It follows the same pattern used in the general invoice accrual and reversal workflow, and the actual invoice posts through normal AP processing with no special handling.

---

Allocating Utility Costs by Department and Location

Once you have calculated the accrued utility amount for the period, the next step is splitting that figure across the departments, cost centers, or locations that consumed the resources.

Choosing an Allocation Base

Three allocation bases cover the vast majority of corporate utility cost allocation by department scenarios:

1. Square footage. Allocate proportionally based on each department's occupied floor area. This is the most common basis for heating, cooling, and lighting costs because energy consumption for climate control and illumination correlates directly with physical space. It is straightforward to calculate and easy to audit.

2. Headcount. Allocate by the number of employees in each department. This works best in shared-space offices where departments do not occupy distinct, separately measurable areas. It is a reasonable proxy for consumption of water, restroom supplies, and break-room utilities.

3. Metered usage. Allocate based on sub-meter readings that capture actual consumption per department or zone. This is the most accurate method, but it requires metering infrastructure that many facilities lack. Where sub-meters exist, use them; the precision eliminates allocation disputes.

Worked Example: Splitting a $45,000 Electricity Bill

A single building houses four departments. The monthly electricity bill is $45,000. You allocate by square footage because the building has dedicated floors per department and electricity costs are driven primarily by HVAC and lighting.

Department	Occupied Area	Allocation %	Allocated Cost
Department A	20,000 sq ft	40%	$18,000
Department B	12,500 sq ft	25%	$11,250
Department C	10,000 sq ft	20%	$9,000
Department D	7,500 sq ft	15%	$6,750
Total	50,000 sq ft	100%	$45,000

The journal entry to book this allocation splits the single utility expense line across four cost center accounts:

Account	Debit	Credit
Electricity Expense — Dept A (CC 4100)	$18,000
Electricity Expense — Dept B (CC 4200)	$11,250
Electricity Expense — Dept C (CC 4300)	$9,000
Electricity Expense — Dept D (CC 4400)	$6,750
Accounts Payable (or Accrued Utilities)		$45,000

If you are working with an accrual rather than an actual invoice, the credit side hits your accrued utilities liability instead. The cost center debits remain the same.

Hybrid Allocation by Utility Type

Not every utility bill should use the same allocation base. Many organizations apply different bases depending on what drives consumption for each utility type:

• Electricity and natural gas — square footage allocation (driven by HVAC and lighting load per area)
• Water and sewer — headcount allocation (consumption scales with the number of people using facilities)
• Telecom and internet — user count or device count allocation (driven by the number of connected endpoints)

Document the chosen basis for each utility type in a formal cost allocation policy. This ensures consistency from period to period, prevents ad hoc changes that distort trend analysis, and gives auditors a clear rationale for how shared costs flow to individual cost centers.

Sequencing: Proration First, Then Allocation

The order of operations matters. You calculate the accrual using daily-rate proration to estimate the utility cost for the reporting period. Then you allocate that accrued amount across cost centers using your chosen basis.

When the actual bill arrives and the amount differs from your estimate, the variance needs to follow the same allocation percentages. If you accrued $45,000 but the actual bill is $47,500, the $2,500 variance is allocated 40/25/20/15 across the four departments: $1,000 to Dept A, $625 to Dept B, $500 to Dept C, and $375 to Dept D. Pushing the full variance into a single department or a catch-all account defeats the purpose of the allocation.

Multi-Entity Facilities

When multiple legal entities share a single facility, the allocation carries intercompany implications. The entity that receives the utility bill books the full payable, then allocates portions to sister entities through intercompany expense recharges. Each entity records its share as a utility expense with a corresponding intercompany payable or receivable.

The allocation methodology for shared facilities across legal entities should be formally documented and applied consistently. Transfer pricing rules may apply in cross-border scenarios, and auditors will expect to see a written policy that supports the allocation percentages used. Square footage allocation is the most defensible basis here because it is objective, verifiable from lease agreements or building plans, and does not shift period to period without a physical change in space usage.

---

Managing Multi-Site Utility Accruals at Scale

A single-site utility accrual is straightforward arithmetic. Multi-site operations turn that arithmetic into a matrix. A company with 15 locations, each receiving 3–4 utility bills (electric, gas, water, telecom) on different billing cycles, faces 45 to 60 individual accrual calculations every month-end close. Each bill carries its own billing period dates, rate structures, and seasonal usage patterns, and every one of them depends on accurate source data pulled from a PDF that looks different from the last.

At this scale, the failure mode shifts. The risk is no longer a single miscalculated accrual. It is systemic drift across locations, where transcription errors in billing period dates or charge amounts cascade through proration formulas, cost allocations, and consolidated journal entries. Days of close time get consumed not by analysis but by data wrangling.

A Standardized Multi-Site Accrual Workflow

The only way to keep multi-site utility cost allocation manageable is to enforce a repeatable process across every location and every provider. The workflow breaks into five steps:

1. Collect bills as they arrive. Utility bills trickle in throughout the month. Centralize them in a shared folder or document management system organized by location and utility type, rather than waiting until close to gather everything at once.
2. Extract key data points from each bill. For every bill, you need three things: the billing period start and end dates, the total charges, and consumption volume. This is the step where format inconsistency across providers creates the most friction.
3. Apply the daily-rate proration formula. Using the extracted billing period and charges, calculate the daily cost rate and prorate for the days falling within your accounting period.
4. Allocate costs by location and department. Map each prorated amount to the correct cost center. Some locations may split utilities across departments (warehouse vs. office space within the same facility), requiring a secondary allocation layer.
5. Generate the consolidated accrual journal entry. Roll up all location-level accruals into a single journal entry or a set of entries organized by entity, depending on your chart of accounts structure.

The Accrual Schedule as Your Working Paper

The tool that holds this workflow together is a utility accrual schedule, a tracker that serves as both the calculation engine and the audit trail. At minimum, it should contain one row per utility account per location, with columns for:

• Location name and cost center code
• Utility type and provider
• Billing period start and end dates
• Total billed amount
• Daily rate
• Days requiring accrual
• Calculated accrual amount
• Prior-month accrual (for variance tracking)

This schedule becomes the supporting documentation behind your month-end journal entry. When auditors or reviewers ask how a $14,200 consolidated utility accrual was derived, the answer is a single spreadsheet that traces back to every source bill. Variance columns that compare each month's accrual to the prior month and to actual bills flag outliers before they reach the general ledger.

Solving the Data Capture Bottleneck

For teams managing fewer than ten utility accounts, manually keying billing dates and amounts into the accrual schedule is tedious but feasible. Beyond that threshold, manual extraction becomes the bottleneck that delays close, not the accrual math itself.

The problem is structural. Utility bills arrive as PDFs from dozens of different providers, each with a different invoice layout. One electric provider prints the billing period in the upper right corner; another buries it in a table on page two. Gas bills from municipal utilities look nothing like those from national providers. A finance team member copying data from 50+ PDFs into a spreadsheet is doing repetitive, error-prone work that directly determines the accuracy of every downstream number.

Automating utility bill capture and data extraction removes this manual step entirely. Invoice Data Extraction is built for exactly this problem. You upload the full batch of utility bills, up to 6,000 files per session, regardless of provider or format. Using natural-language prompts, you instruct the AI to pull the specific fields your accrual schedule requires: billing period dates, total charges, consumption volumes, account numbers, service addresses. The output arrives as a structured Excel or CSV file that maps directly into your accrual tracker.

The critical advantage for multi-site teams is format normalization. Whether a bill comes from a regional electric cooperative, a national telecom carrier, or a municipal water authority, the extraction process produces the same consistent output structure. A 60-bill extraction that previously took a full day of manual keying compresses into minutes, and the transcription errors that silently corrupt accrual calculations disappear at the source.

With clean, structured data feeding the accrual schedule automatically, the finance team's effort shifts from data entry to review and analysis, identifying the locations where accruals are trending higher than expected or where billing anomalies need investigation.

---

Reconciling Utility Accruals Against Actual Bills

Every utility accrual is an estimate, and every estimate eventually meets reality. The reconciliation step, comparing what you accrued against the actual invoice, is where you close the loop and, just as importantly, where you build the data to make next month's estimate better.

Running the Variance Analysis

When the actual utility bill arrives, pull the accrual you booked for the corresponding period and run a straightforward comparison. Three numbers matter: the dollar variance, the percentage variance, and the direction (favorable or unfavorable).

Suppose your March electricity accrual for a warehouse location was $1,064.47, based on a daily-rate proration of the prior bill. The actual invoice arrives and the prorated March portion comes to $1,120.00. That produces:

• Dollar variance: $1,120.00 − $1,064.47 = $55.53
• Percentage variance: $55.53 ÷ $1,064.47 = 5.2%
• Direction: Unfavorable (actual exceeded the estimate)

An unfavorable variance means the period's expense was understated by the accrual; a favorable variance means it was overstated. Record the true-up adjustment when you book the actual invoice and reverse the accrual, so the correct expense hits the general ledger.

Common Variance Drivers

Most utility accrual variances trace back to a short list of causes. Knowing which ones apply to your accounts saves time during analysis:

1. Seasonal consumption shifts. Heating and cooling loads swing with weather. A mild February followed by a cold March will push gas costs above a February-based daily rate estimate.
2. Rate changes. Provider rate increases, fuel surcharges, or tiered pricing thresholds that kick in at higher consumption levels all create gaps between an estimate derived from last month's rate and this month's actual cost.
3. Billing period date shifts. Some providers occasionally adjust billing cycle start and end dates by a day or two, which changes the number of days in the billing period and throws off a proration that assumed a fixed cycle length.
4. One-time charges or credits. Connection fees, estimated-vs.-actual meter read adjustments, demand charges, and rebates appear irregularly and are nearly impossible to predict in a daily-rate model.

When you identify the driver, note it. That annotation becomes the basis for both the variance commentary and any methodology adjustment.

Using Variance History to Sharpen Future Estimates

A single month's variance tells you little. A pattern across several months tells you everything. Track variances by utility account and by calendar month in a simple log or spreadsheet: account, period, accrued amount, actual amount, dollar variance, percentage variance, and driver.

After three to six months of data, look for systematic bias. If your electricity accruals for a manufacturing facility run 3–5% below actuals every June through August, that is not random noise; it is a seasonal pattern your daily rate is not capturing. The fix is to build a seasonal adjustment factor into the daily rate for those months, either by using the prior year's same-month bill as the basis or by applying a multiplier derived from the historical variance average.

The target is a variance rate that stays within the materiality threshold your organization defines. For individual utility accounts, a 5–10% tolerance is common. Accounts that consistently breach that threshold need a methodology change: a different base period, a seasonal factor, or a switch from simple daily-rate proration to a regression-based estimate that accounts for weather or production volume.

Communicating Variances to Management

When variances are significant or recurring, include a brief commentary in the month-end close reporting package:

• Which utility accounts had material variances
• The primary driver for each (rate change, weather, one-time charge)
• Whether the accrual methodology is being adjusted going forward

This prevents questions during financial statement review and gives leadership visibility into an expense category that, for facilities-heavy organizations, can be material in aggregate. If your close process does not already include a standard format for estimate variances, the same structure used for other accrued expenses (rent true-ups, insurance adjustments) works here. An AP month-end close checklist that includes a line item for utility accrual reconciliation keeps this step from falling through the cracks.