In Google Sheets, select a Paid column, choose Insert, then Checkbox, and each cell becomes a tick box holding TRUE when ticked and FALSE when not. Add a conditional formatting rule so ticked rows are struck through, and use =SUMIF($D$2:$D$30,FALSE,$C$2:$C$30) to total what is still to pay.
How do you lay out the bill tracker?
- A: Bill name
- B: Due date (a real date)
- C: Amount in rupees
- D: Paid, the checkbox column
Fill rows 2 to 30 with your recurring bills: rent, society maintenance, electricity, broadband, phone, insurance instalment. Select D2:D30 and choose Insert, Checkbox. Every cell shows an unticked box.
How do you strike through paid bills?
- Select A2:D30.
- Open Format, Conditional formatting. Set Format cells if to Custom formula is.
- Type =$D2=TRUE.
- Under Formatting style choose strikethrough and a grey text colour. Press Done.
Now ticking a box fades the whole row. The dollar sign before D keeps the test on column D while the row number moves down. For a second rule that warns about overdue bills, add a custom formula =AND($D2=FALSE,$B2<$F$1) where F1 holds =TODAY(), with a red text colour. Putting TODAY in a cell keeps the rule short.
What is still to pay this month?
Unticked boxes hold FALSE, so SUMIF can add the amounts beside them:
- Total still unpaid: =SUMIF($D$2:$D$30,FALSE,$C$2:$C$30)
- Number of unpaid bills: =COUNTIF($D$2:$D$30,FALSE)
- Unpaid and due by the end of this month: =SUMIFS($C$2:$C$30,$D$2:$D$30,FALSE,$B$2:$B$30,"<="&EOMONTH(TODAY(),0))
EOMONTH with 0 returns the last day of the current month. Rows where D is empty, with no checkbox at all, are not counted as FALSE, so make sure every bill row has a box.
What does it look like with sample numbers?
| Bill | Amount | Paid |
|---|---|---|
| Rent | ₹18,000 | Ticked |
| Society maintenance | ₹3,500 | Not ticked |
| Electricity | ₹2,350 | Not ticked |
| Phone | ₹499 | Ticked |
With these invented amounts, the unpaid total is 3,500 plus 2,350, which is ₹5,850. The paid total is 18,000 plus 499, which is ₹18,499. Together they make ₹24,349, the whole month's bills, so you can check that nothing has dropped out of the sums.
Add a Paid on column in E if you want a date. Resist the formula =IF(D2,TODAY(),""), because TODAY() recalculates daily and every paid bill would show today's date tomorrow. Instead click the cell and press Ctrl and the semicolon key, which types the current date as a fixed value. For a progress figure, =COUNTIF($D$2:$D$30,TRUE)/COUNTA($A$2:$A$30) gives the share of bills ticked: with two of the four bills above paid, that is 2 divided by 4, or 50 percent, shown as a percentage once you format the cell.
How do you reset for next month?
Copy the sheet for each month (right-click the tab, then Duplicate) and untick everything with a single move: select D2:D30 and press the spacebar, which toggles the box in a selection. A cleaner method is to keep each month as its own tab, named Jul 2027 and so on, so you also keep a record of what was paid.
Next steps
- Add a Paid on column with a date you type once the payment clears.
- Sort by due date so that the next bill is always at the top.
- Add a notes column if you like, but keep passwords and logins out of the sheet.
A note on rows: keep one row per bill instance, not one per bill type. If electricity is due every month, give each month its own row on its own tab, so that the paid tick belongs to a specific due date and last month's tick never hides this month's pending bill.
When bills need reminders and a link to what actually left your account, SpendixAI's Pro plan includes bills alongside budgets and savings goals, with spending from your imported statements.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


