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 vs accounts payable vs prepaid expenses
| Item | Invoice received? | Paid? | Balance sheet |
|---|---|---|---|
| Accrued expense | No | No | Accrued expenses (liability) |
| Account payable | Yes | No | Accounts payable (liability) |
| Prepaid expense | Yes | Yes, in advance | Prepaid 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.
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.

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))
| Accrual | Base amount | Factor | Accrued |
|---|---|---|---|
| Wages for Sep 28-30 | 1,240.00 per day | 3 days | 3,720.00 |
| Electricity Sep 16-30 | 1,380.00 for 30 days | 15 / 30 = 0.5 | 690.00 |
| Q3 bookkeeping review | 750.00 quote | 1 | 750.00 |
| Freight on Sep 29 delivery | 251.00 rate card | 1 | 251.00 |
| Loan interest for September | 40,800.00 loan | 6% / 12 = 0.005 | 204.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.

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.

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.
| Account | Debit | Credit |
|---|---|---|
| 6100 Wages | 3,720.00 | |
| 6400 Utilities | 690.00 | |
| 6600 Professional fees | 750.00 | |
| 5300 Freight in | 251.00 | |
| 7200 Interest expense | 204.00 | |
| 2200 Accrued expenses | 5,615.00 |

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:
| Check | Formula | Result |
|---|---|---|
| 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.

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.

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.
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.
