TEMPLATES & BUSINESS WORKFLOWS

Accrued Expenses Schedule in Excel: Month-End Accruals Made Simple (Free Template)

At month end some costs have already been used up but the bill has not arrived: the last few days of wages, the electricity since the last meter reading, the interest on a loan, a delivery that came without an invoice. If you only record expenses when the invoice arrives, the month looks more profitable than it was. An accrued expenses schedule fixes that. In this guide you will build one in Excel that calculates each accrual, ties the total to the ledger, writes the journal entry and its reversal for you, and compares the estimates with the real invoices next month.

Accrued expenses schedule in Excel at Sep 30, 2026 with wages of 3,720.00, electricity of 690.00 and professional fees of 750.00, a total of 5,615.00 that ties to the ledger.
Every accrual calculated, totaled and tied to the ledger.

Accrued expenses vs accounts payable vs prepaid expenses

ItemInvoice received?Paid?Balance sheet
Accrued expenseNoNoAccrued expenses (liability)
Account payableYesNoAccounts payable (liability)
Prepaid expenseYesYes, in advancePrepaid expenses (asset)

An accrual is an estimate of a cost you have incurred but not been billed for. Once the invoice arrives it belongs in accounts payable (see the accounts payable aging report), so never accrue an invoice that is already in payables. Prepaid expenses are the mirror image: paid before the cost is used, and tracked in the prepaid expense amortization schedule.

Free download: Get the accrued expenses schedule (.xlsx). It has an Accruals sheet with the schedule, ledger check and true-up, a Journal Entries sheet with the accrual and the reversal, an Accounts list and a How It Works sheet. Works in Excel 2010 and later, Microsoft 365 and Excel for the web.

Step 1: List what was used but not billed yet

Enter the period end in B2 (Sep 30, 2026). Then add one row per accrual: a reference, a description, the GL account and a short note on how you estimated it. The GL account cell has a drop-down list from the Accounts sheet, so every accrual lands on a real expense account.

Good places to look for accruals at month end:

  • Payroll: days worked since the last pay date.
  • Utilities: usage since the last meter reading or bill.
  • Interest on loans that is paid in arrears.
  • Professional fees for work done this month (bookkeeping, legal, audit).
  • Goods or services received without an invoice: delivery notes and purchase orders that are still open.
Excel accrued expenses schedule listing five accruals at Sep 30, 2026 with a reference, the expense, the GL account and how each amount was estimated.
One row per accrual, with its GL account and the basis of the estimate.
Checkpoint: Five accruals for Brightline Trading Co. at Sep 30, 2026: wages, electricity, a bookkeeping fee, freight and bank loan interest.

Step 2: Calculate each accrual

Each accrual is a base amount times a factor. The base is the number you know (a daily payroll, the last bill, a quote, the loan balance) and the factor turns it into the part that belongs to this month. In G5, filled down:

=IF(E5="","",ROUND(E5*F5,2))
AccrualBase amountFactorAccrued
Wages for Sep 28-301,240.00 per day3 days3,720.00
Electricity Sep 16-301,380.00 for 30 days15 / 30 = 0.5690.00
Q3 bookkeeping review750.00 quote1750.00
Freight on Sep 29 delivery251.00 rate card1251.00
Loan interest for September40,800.00 loan6% / 12 = 0.005204.00

The factor cell for interest holds the formula =6%/12, so the rate stays visible. Column H shows when each accrual reverses: =IF(A5="","",$B$2+1), the day after the period end.

Excel accrual calculation of base amount times factor: wages 1,240.00 times 3 days is 3,720.00 and electricity 1,380.00 times 0.5 is 690.00, each reversing on Oct 1, 2026.
Base amount x factor, rounded to cents.
Checkpoint: Electricity: 1,380.00 x 0.5 = 690.00. Wages: 1,240.00 x 3 = 3,720.00.

Step 3: Total it and tie it to the ledger

Row 15 totals the accruals. The schedule is the support for the Accrued expenses account (2200), so after posting, enter the ledger balance in G17 and compare:

=IF(ROUND(G15-G17,2)=0,"Ties","Check")

G19 counts rows that have a reference but no GL account, which would otherwise drop out of the journal entry:

=COUNTIFS(A5:A14,"<>",C5:C14,"")

COUNTIFS with two criteria (reference filled in, GL account blank) works the same way as counting overdue items with COUNTIFS.

The 5,615.00 here is the same accrued expenses line that appears on the balance sheet template for Sep 30, 2026, and its change from the year end flows into the cash flow statement.

Excel accrued expenses total of 5,615.00 compared with the ledger balance of 5,615.00, showing Ties and 0 lines without a GL account.
The schedule must agree with account 2200.
Checkpoint: Total accrued 5,615.00 = ledger 5,615.00: Ties. Lines without a GL account: 0.

Step 4: Build the month-end journal entry

The Journal Entries sheet lists the expense accounts from the Accounts sheet. In B5, filled down, SUMIFS adds the accruals for each account:

=SUMIFS(Accruals!$G$5:$G$14,Accruals!$C$5:$C$14,A5)

The credit is one line to 2200 Accrued expenses for the total, =SUM(B5:B10). If you have two accruals on the same account, SUMIFS combines them into one debit. New to SUMIFS? See summing monthly values with SUMIFS.

AccountDebitCredit
6100 Wages3,720.00
6400 Utilities690.00
6600 Professional fees750.00
5300 Freight in251.00
7200 Interest expense204.00
2200 Accrued expenses5,615.00
Excel month-end journal entry built with SUMIFS: debits to wages, utilities, professional fees, freight and interest totaling 5,615.00 and one credit to accrued expenses.
SUMIFS turns the schedule into the journal entry.

Step 5: Reverse it on the first day of the next month

Columns D and E hold the reversing entry, dated Oct 1, 2026: the same amounts on the opposite sides. The reversal cancels the accrual, so when the real invoices arrive in October you post them to the expense accounts as usual. October then carries only the difference between the invoice and the estimate.

Two checks under the entries make sure nothing is lost:

CheckFormulaResult
Debits = credits=IF(AND(ROUND(B12-C12,2)=0,ROUND(D12-E12,2)=0),"Balanced","Check")Balanced
Every accrual is in the entry=IF(ROUND(B12-Accruals!G15,2)=0,"Ties","Check")Ties

The second check catches a GL account that is typed in the schedule but missing from the Accounts list: SUMIFS would skip it and the entry would be short.

Excel reversing journal entry dated Oct 1, 2026 debiting accrued expenses 5,615.00 and crediting each expense account, with Balanced and Ties checks.
The reversal cancels the accrual on Oct 1.
Try it: In Accruals row 10 add AC-06, Telephone for September, GL account 6400 Utilities, base amount 180, factor 1. The total becomes 5,795.00, the Utilities debit becomes 870.00, the entry still balances, and Schedule = ledger shows Check until the extra 180.00 is posted. Clear the row again.
Do not forget the reversal: Without it, the October invoices are booked on top of the September accruals and the expenses are counted twice. If your accounting software can schedule reversing entries automatically, use that option.

Step 6: Compare with the actual invoices

When the bills arrive, enter them in column I. Column J shows the true-up:

=IF(OR(G5="",I5=""),"",I5-G5)

A positive difference means you under-accrued and the extra cost lands in October; a negative one means you over-accrued. In the example, electricity came in at 702.40 against 690.00 accrued, so the total true-up is 12.40, or 0.2% of the accruals (G20). Small, consistent differences mean your estimating methods work. A large one is a reason to change the method, for example to use a meter reading instead of the last bill.

Excel accrual true-up comparing accrued amounts with actual invoices: electricity invoiced at 702.40 against 690.00 accrued, a total difference of 12.40 or 0.2 percent.
Actual invoices vs accruals: how good were the estimates?

Month-end accrual checklist

  • Payroll days since the last pay date are accrued, including employer taxes if they are material.
  • Open purchase orders and delivery notes have been checked for goods received but not invoiced (an invoice payment tracker helps).
  • Invoices that arrived before the books closed are in accounts payable, not accrued.
  • The total ties to account 2200 in the trial balance.
  • The reversal is scheduled for the first day of the next month.
  • Last month's true-ups have been reviewed, and recurring costs are in your monthly expense tracker.

Frequently asked questions

What is an accrued expense?

A cost that has been incurred in the period but not yet invoiced or paid, such as wages for the last days of the month or interest on a loan. It is recorded as an expense and a liability called accrued expenses.

What is the journal entry for an accrued expense?

Debit the expense account and credit Accrued expenses. On the first day of the next month, reverse it: debit Accrued expenses and credit the expense account.

Why reverse accruals?

So the real invoice can be posted normally next month without counting the cost twice. After the reversal, the next month only shows the difference between the invoice and the estimate.

Are accrued expenses a current liability?

Yes. They are normally settled within weeks, so they are shown under current liabilities on the balance sheet.

How accurate does an accrual need to be?

A reasonable estimate is enough. Use the best information you have (a quote, a rate card, the last bill) and review the true-up each month to improve the method.

Final checklist

  • Every accrual has a GL account and a basis for the estimate.
  • Lines without a GL account shows 0.
  • The journal entry shows Balanced and Ties.
  • Schedule = ledger shows Ties after posting.
  • The reversal is dated the first day of the next month.
  • Actual invoices are entered when they arrive and the true-up is reviewed.
Practice file: Download the accrued expenses schedule. Replace the yellow rows with your own accruals and add your expense accounts to the Accounts sheet; the entries and checks update automatically.

Close the month with confidence

Turn the accruals into a complete month-end with the profit and loss statement, browse the ready-to-use Excel templates, or visit the OneXcel Tutorial Hub for step-by-step guides.