Everyday AI · Daily life
Track bills and income for this month
Do you want one place to see income received, bills paid, what is still due and how much is left?
Listen to this guide
AI narration · English · Prompt text stays on the page
Try ElevenLabs ↗ · Affiliate link
What you will make
A reusable monthly tracker that shows income received, expenses paid, unpaid bills and the money left.
What you need
A short private list of income, expenses, due dates and payment status. You can begin with the fictional sample rows instead of real figures.
Before you start
Choose Google Sheets or Notion. A statement can help, but the tracker usually needs only selected transaction rows or totals. If you use one, make a redacted copy first and hide your name, address, account and customer numbers, QR codes, barcodes, transaction references, and any balance or transaction that is not needed.
What to do
- Choose Google Sheets if you want automatic totals, or Notion if you prefer a clean database with separate views. Both can hold the same information.
- Write a private list of your income, regular expenses and due dates. Use broad payment labels such as Cash, Bank or GCash. Leave out account numbers, card numbers, PINs, passwords and one-time passwords.
- Paste the prompt below into ChatGPT, Claude or Gemini. Ask it to build the structure for your chosen tool, then copy the result into a new sheet or Notion database.
- Test the tracker with the five fictional sample rows first. Check that received income, paid expenses, unpaid bills and the remaining amount are calculated correctly.
- Replace the examples with your own figures. Update the status when money is received or a bill is paid, and review the tracker once a week.
Try this prompt
Replace [Google Sheets or Notion] and [month year]. Start with fictional entries before adding your own figures.
Help me build a reusable monthly bills and income tracker in [Google Sheets or Notion] for [month year]. Keep it simple enough for a beginner to update every week.
Create one main table with these fields in this order:
1. Date
2. Month in YYYY-MM format
3. Type: Income or Expense
4. Category
5. Description
6. Amount in PHP
7. Due date
8. Paid or received date
9. Status: Expected, Received, Unpaid, Paid or To confirm
10. Recurring: Yes or No
11. Payment method: Cash, Bank, GCash, Maya, Card or Other
12. Notes
Also create a monthly summary that shows:
- income actually received
- expenses already paid
- bills still unpaid
- money left after paid expenses
- money expected to remain after all listed bills are paid
For Google Sheets, give the exact formulas and cell locations for a Transactions tab and a Summary tab. Add dropdowns for Type, Status, Recurring and Payment method. Add a filter for the selected month and highlight unpaid bills that are due within seven days.
For Notion, give the exact property type for every field. Create four views: This month, Unpaid bills, Income and Recurring items. Explain how to use Calculate → Sum at the bottom of the Amount column for each filtered view.
Add five clearly labelled fictional sample rows so I can test the totals. Then give me a short weekly routine and explain how to duplicate the tracker for a new month without deleting the old records.
Use only numbers I provide after the test. Never invent income, fees, balances, due dates or payments. Mark missing details "To confirm". Do not ask for account numbers, card numbers, passwords, PINs, OTPs or government IDs. If I use bank-statement information, remind me to provide only the selected rows or a redacted copy with identity, account, QR, barcode and transaction-reference details hidden.See a sample result
Illustrative example. Your answer may differ.
Illustrative test only: ₱20,000 salary received; ₱2,000 freelance income expected; ₱1,850 electricity unpaid; ₱1,499 internet paid; ₱3,000 groceries paid. The summary should show ₱20,000 received, ₱4,499 paid, ₱1,850 unpaid, ₱15,501 left now and ₱13,651 expected after the listed unpaid bill. Replace every sample row before using the tracker.
Before you use it: Check the sample totals with a calculator before entering real figures. Then compare every amount, status and due date with your own receipts or statements. This tracker is a planning record, not a bank statement, accounting record, tax calculation or financial recommendation. If you use a statement, share only needed rows or a redacted copy. Temporary or incognito chat settings can reduce some retention or model-improvement use, but they do not replace redaction.
Try this follow-up
Check these totals line by line. Show the formula used for each total and mark any missing amount or date To confirm.
If the answer is not right
If a total is wrong, compare each formula range with the Transactions columns and ask the AI to correct only that formula. Keep the original data until the totals match your calculator.