To estimate a utility bill accrual, divide the bill amount by the number of days in the service period, then multiply that daily rate by the service days that fall in the month you are closing. Book the result as utility expense and accrued utilities payable, then reverse it when the actual bill is recorded.
Utility providers bill on their own cycles, not yours. Unlike rent or insurance, where amounts and periods are fixed, utility expenses vary by consumption and arrive on staggered billing cycles that rarely align with calendar month-end.
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.
Calculating Utility Accruals with Daily-Rate Proration
Daily-rate proration assigns a utility bill to the accounting periods it spans. Divide the bill by the number of service days, then multiply the daily rate by the days that fall in the month you are closing.
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:
- Identify the billing period start and end dates from the utility bill itself.
- Count the total days in the billing period. Include the start date, exclude the end date (or follow your company's convention consistently).
- Divide total charges by total days to arrive at the daily rate.
- Count the days of that billing period falling within your accounting month.
- Multiply the daily rate by those days. That figure is your accrual.
Before you can run this calculation, extract the billing period start date, billing period end date, total charges, and available consumption figures (kWh, therms, CCF, or gallons). For multi-site close, keep one row per utility account and location with provider, cost center, billing dates, billed amount, daily rate, days accrued, accrual amount, and prior-month variance. Tools like Invoice Data Extraction let you automate utility bill data extraction from PDF utility bills so those fields are ready for your accrual schedule 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. If you need a broader framework for choosing AP accrual estimation methods by expense type, use it to decide when a simple prorated utility estimate is sufficient and when a more tailored model is worth the effort. 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 result is $1,064.47 in March expense and $1,935.53 in April expense, matching the service days in each month.
Quick Variance Check When the Actual Bill Arrives
When the actual bill arrives, compare the accrued amount with the actual prorated expense for the same service days. If the March accrual was $1,064.47 and the actual March portion is $1,120.00, the unfavorable variance is $55.53, or 5.2% of the accrual.
Common drivers are seasonal consumption, provider rate changes, billing-period date shifts, and one-time charges or credits. One variance may be noise; repeated variances by account and month indicate a methodology problem. Track the driver in the close file so next month's estimate can use a better base period, seasonal factor, or weighted daily rate where the variance is material.
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
Most companies allocate utility costs to departments using one of three bases:
-
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.
-
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.
-
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. Auditors will expect 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. Property finance teams facing the same problem across utility accounts, owner entities, and tenant recharges can adapt a Malta ARMS bill reconciliation workflow for multi-entity portfolios to keep the supporting schedule tied to each legal entity.
Extract invoice data to Excel with natural language prompts
Upload your invoices, describe what you need in plain language, and download clean, structured spreadsheets. No templates, no complex configuration.
Related Articles
Explore adjacent guides and reference articles on this topic.
Reconcile Malta ARMS Bills Across Property Entities
Reconcile Malta ARMS bills across property entities with an Excel close workflow for owner coding, monthly accruals, tariff checks, and tenant recharges.
How to Estimate AP Accruals: 4 Methods by Expense Type
Choose the right AP accrual estimation method by expense type, with audit evidence guidance, materiality rules, and true-up steps for month-end close.
Invoice Accrual and Reversal Process: A Complete AP Guide
Learn when to accrue uninvoiced liabilities, how to record journal entries, and how reversing entries prevent double-counting — with worked AP examples.