A bill tracker spreadsheet shows every bill your household pays, when each one usually leaves your account and which paycheck is meant to cover it. You can build most of it from a few months of bank and card transactions with one AI prompt, then check the parts that still need a person.
You probably know rent and the car payment by heart. The rest is scattered across checking and a card or two, under names like “CITY OF MAPLE GROVE UTIL WEB PMT” that don’t read like the water bill until you stop and look. And when a bill posts on the 1st and payday is the 4th, the money for it has to be in checking already.
Your statements already hold most of the answer. The prompt below asks an AI assistant to read your transactions, pull out the bills, find your paychecks and match each bill to the paycheck that covers it in the month you name. Treat what it returns as a first draft to check against your statements. The checks below show where a plan is most likely to slip.
When you’re done, you’ll have a checked list of every bill your statements show and a plan for which paycheck covers which bills next month. A free Google Sheet with the same columns, plus filled-in example sheets, is further down.
The job: every bill, when it posts and which paycheck covers it
A bill tracker answers three questions.
- What are all the bills? Anything that repeats on a schedule, including the credit card payment and the bills that ride on the card.
- When does each one usually leave your account? The day it posts, whether it’s on autopay and whether the amount changes.
- Which paycheck covers it? Each bill belongs to the last paycheck that lands before it. The first of the month is where this goes wrong, because rent can post before the month’s first payday.
The first two make a list. The third makes a plan, and it’s the part to check most carefully.
This post starts from your statements, so the assistant finds the bills for you. If you already have your bill list and only need the timing, the bill calendar template has a prompt that works from a list you type in.
A statement shows when money moved, not when the bill was due. For autopay bills the two are usually close. For a bill you pay by hand, they can be days apart.
What you’ll end up with
The prompt asks the assistant for four things:
- A bill tracker. One row per bill: its name, how it shows on your statement, which account pays it, the amount (or the range if it changes), how often it’s paid, the day it usually posts and whether it looks like autopay.
- Your paychecks. Who pays, how much, and the pattern, like every other week or twice a month.
- A paycheck plan for the month you name. Each paycheck date you should expect, the bills that post after it and before the next paycheck, a total for each paycheck and what’s left over.
- A short list of questions. Charges it couldn’t place, like one that might be a quarterly bill, so it asks you instead of guessing.
The plan is where the arithmetic matters. Say your rent is $1,650 and posts on the 1st, and the last paycheck before the month is $1,610.40. That paycheck is $39.60 short of rent on its own, so the gap has to come out of money already in checking. A row like that is the first thing to plan around.
What you need before you start
- Two to three months of transactions from every account that pays a bill. Usually that’s checking plus any card that carries a bill. Most banks and card issuers have a Download or Export option on the transactions page. Choose CSV, the plain spreadsheet format, if it’s offered.
- The month you want to plan. You’ll type it on its own line after your transactions.
To paste a CSV as text, open it in a plain text editor (Notepad on Windows; on a Mac, right-click the file, choose Open With, then TextEdit). Trim it using the next section, put a short label above each account’s transactions, like Checking or Card, so the assistant knows which account pays which bill, then select everything and copy. The prompt needs three columns from each line: date, description and amount. Real exports often carry extra columns, so trim them.
A bill paid from an account you leave out won’t show up. That includes a loan paid from a second checking account or a subscription on a card that lives in a drawer.
Before you paste anything
Remove what the tracker doesn’t need
The prompt needs three things from each line: the date, the description and the amount. That’s all, so everything else can come out before you paste. Delete or shorten account numbers and take out your name and address. Replace an account column with a nickname like Checking or Card.
Read the descriptions too. Some loan payments print an account number inside the description line. Trim it before you paste. And paste exported text, not screenshots of whole statements, which carry your name, address and full numbers.
That’s Run Your Household’s own rule, pieced together from the vendors’ privacy pages, not an official checklist. Anthropic’s help page does name bank account details among the things to be careful about sharing in a chat. (Claude Help Center)
Check the assistant’s training settings
ChatGPT: the “Improve the model for everyone” setting under Data Controls decides whether new chats are used for training. A Temporary Chat isn’t saved to your history or used for training, though OpenAI may keep it up to 30 days for safety. (OpenAI Data Controls FAQ)
Claude: Anthropic says it uses consumer chats for training only if you allow it, with the Help Improve our AI models setting under Settings, then Privacy. Check whether it’s on. Incognito chats aren’t used for training either way. (Anthropic Privacy Center, privacy settings)
Gemini: the Keep Activity setting, on your Gemini Apps Activity page, controls whether chats are saved and used to train Google’s models. With it off, Google says future chats aren’t used for training, though they’re kept for up to 72 hours. A temporary chat isn’t used for training either. (Gemini Apps Privacy Hub)
One catch applies to all three: a thumbs up or down, or other feedback you send, can let the company use that conversation to improve or train its models even with the setting off.
Setting names move around, so take a quick look before your first run.
The prompt that builds your bill tracker spreadsheet
Copy the whole block into a new chat. Below it, type Here are my transactions: and paste your labeled transactions. Then add one line on its own that names the month, like Month to plan: October 2026.
I'm going to paste a few months of transactions from my bank account and my credit card. Please turn them into a bill tracker I can check, then show me which paycheck covers which bills next month.
1. Find every bill. That's anything that repeats on a schedule: rent or mortgage, utilities, phone, internet, insurance, loan payments, childcare, memberships and subscriptions. A credit card payment counts as a bill too.
2. Leave out everyday spending that repeats but isn't a bill, like groceries, gas, restaurants and shopping. Leave out my paychecks and transfers between my own accounts.
3. If a charge shows up only once but could be a bill that's paid every few months or once a year, like insurance, an HOA fee or a membership, put it in a separate list and ask me how often it's paid. Don't guess.
4. If you aren't sure whether something is a bill, put it in a "Check with me" list and say why. Don't guess.
5. For each bill, give me one row with: bill name, how it shows on my statement, which account pays it, amount (or the range if it changes), how often it's paid, the day of the month it usually posts, and whether it looks like autopay. The date a payment posts isn't always the due date, so call that column "Usually posts around."
6. Find my paychecks. Tell me who pays, how much, and the pattern (every other week, twice a month and so on).
7. Then plan the month I name after my transactions. If I didn't name one, ask me which month before you plan it. List each paycheck date I should expect that month, and under each one, the bills that should post after it and before the next paycheck. Show a total for each paycheck and what's left over. If a bill lands before the month's first paycheck, it has to come from the last paycheck before the month starts. Name that paycheck and its date.
8. Bills charged to my credit card get paid through the card payment, so count them only once in the paycheck plan and tell me which ones they are.
9. Don't repeat any full account numbers in your answer.
Give me the full tracker and plan first. Put your questions and anything you weren't sure about at the end.Answer the assistant’s questions in the same chat. They’re how the prompt keeps it from guessing.
Why each line is there
The opening asks for a tracker first and a plan second, so you can trust one while you question the other. Line 1 names the credit card payment, which is easy to leave off because it pays for other spending.
Line 3 handles charges a few months can’t pin down. An insurance premium seen once might be quarterly or yearly, and a wrong guess puts a big number in the wrong month. Line 4 does the same for anything that might not be a bill at all.
Line 5 names the date column “Usually posts around” so you don’t mistake it for a due date.
Line 7 has you name the month and spells out which paycheck covers a bill that lands before the month’s first payday. Those are the two places a plan is most likely to slip. Line 8 keeps card-charged bills from being counted twice, and line 9 asks the assistant not to repeat full account numbers.
What a good answer has
A bill list that matches the recurring charges you can see on your statements, with nothing on it that’s everyday spending. A paycheck list that matches your pay pattern. A plan for the month you named, with a paycheck date, its bills, a total and a left-over figure for each paycheck. Questions at the end instead of guesses.
If the plan covers the wrong month or the bill list is missing a bill you can see on your export, tell the assistant what’s off in the same chat and ask it to recheck against what you pasted. If it’s still wrong, run the prompt again in a new chat.
Make it fit your household
Each of these is a change to what you paste, not to the prompt.
Only a checking account
Paste one block labeled Checking and skip the card.
More than two accounts
Give each account its own block and its own nickname, so the assistant knows which one pays which bill.
A different month
Change the last line, like Month to plan: November 2026.
Paid weekly or twice a month
Nothing to change. The prompt asks the assistant to find your pay pattern.
A bill that’s paid by hand
The date it posts can be days after it’s due. Look up the due date on the bill and add it to the spreadsheet yourself.
Yearly charges you don’t see in three months
Search a year of statements or your email for “annual” and “renewal,” and add what you find. The Household Bills Check gives recurring charges their own pass each month.
Check before you act
Sorting your transactions into bills and everything else is the easier job. The plan is where to look hardest.
- The month. Make sure the plan is for the month you named.
- The paycheck that covers the 1st. Find the last paycheck before the 1st on your own statement. A bill that posts before the month’s first payday has to come from that one. The free Household Bills Check worksheet has a page for matching each bill to money you can count on.
- The totals. Add each paycheck’s bills yourself. An assistant can say it left a payment out of the plan and then count it in the total anyway.
- Card-charged bills. If they also show up as separate lines under a paycheck, they’re counted twice. They should show up once, inside the card payment.
- Charges that showed up once. Insurance, HOA fees and memberships may be quarterly, twice a year or yearly. Answer the assistant’s question, or enter the right “How often” in the spreadsheet and let the monthly cost column spread it out. A charge labeled ANNUAL is probably yearly, but confirm it on the bill.
- Bills that change. Electric and the card payment are estimates. Use a recent or high amount and adjust when the bill arrives. Be wary of a “trend” drawn from three months of ups and downs.
- Posting dates versus due dates. Look up each bill’s real due date on the bill or account page, then mark the row in “Checked against the bill?” The bill calendar template shows how to turn a due date into the day the money has to be ready.
- Bill names. Rename any loan or charge you won’t recognize next month. A statement line may not say what the loan is for.
Then pick three rows from the tracker and find each one on your export. If one doesn’t match, tell the assistant which row in the same chat and ask it to recheck against what you pasted. When the two disagree, go with your export.
Two limits worth knowing. The assistant can’t see an account you didn’t paste. And it can’t pay anything or change a due date for you.
Get the free bill tracker spreadsheet
Make your own copy of the bill tracker spreadsheet
The link asks you to make a copy, which saves to your own Google Drive, so you’ll need a Google account. Prefer Excel? In your copy, choose File, then Download, then Microsoft Excel. There are six tabs.
- Start Here. The steps in order, and what the white and pale-blue cells mean.
- Bill Tracker. The nine columns in the table below. Monthly cost calculates. Choose “Card charge” in the Autopay? column for bills on a card, and the totals split into what’s paid from your accounts and what’s charged to a card.
- Paycheck Plan. Enter the month’s paychecks plus the last one before the month starts, then each bill with the date of the paycheck that covers it. “Bills total” and “Left over” calculate. Type each paycheck date in the bill list exactly as it appears in the paycheck table so the totals match.
- The Prompt. The same prompt as above, ready to copy, with a short checklist for before you paste and after the answer.
- Two example sheets. A filled-in tracker and a filled-in September plan, so you can see what a finished one looks like.
The blank sheets start with example rows. Delete them when you begin.
Then move your checked results in: copy or type each row from the assistant’s tracker into Bill Tracker, and each paycheck and its bills into Paycheck Plan. Where the assistant gave a range, use the most recent amount. Mark “Checked against the bill?” as you confirm each row.
The nine columns
| Column | What goes in it |
|---|---|
| Bill | A plain name you’ll recognize, like “Car loan” or “Water” |
| Shows on statement as | The description exactly as your bank prints it, so you can search for it later |
| Pays from | An account nickname, like “Main checking” or “Card” |
| Amount | The usual amount, or the most recent one if it changes |
| How often | Weekly, every other week, twice a month, monthly, quarterly, every 6 months, yearly or unclear |
| Usually posts around | The day it tends to clear, which isn’t always the due date |
| Autopay? | Yes, No, Unclear or Card charge |
| Monthly cost | Calculates from the amount and how often |
| Checked against the bill? | “Yes” once you’ve matched the row to a real bill or account page |
Add due dates and the timing
The timing work goes further than this post: the day you need to start a payment, when the money has to be in checking, and asking a biller to move a due date that lands in a tight week. That’s all in the bill calendar template. Your checked list is the starting point: copy it in, then add each bill’s due date from the bill itself. Prefer paper? The free Household Bills Check is a two-page monthly worksheet for the same check.
If your accounts are already connected
ChatGPT has a Finances feature that connects bank and card accounts through Plaid, a bank-connection service, and credit reports through Experian. According to OpenAI’s help page, it’s available in the US on Plus and Pro plans, on web, iOS and Android. It’s read-only, so it can’t move money, pay bills or change account settings, and synced data is deleted within 30 days after you disconnect. (OpenAI Finances help)
If you try the prompt there, the same checks apply, starting with which accounts are actually connected. Without a connection you trust, paste an export with the account numbers removed.
What to try next
- Map the due dates. The bill calendar template turns your checked list into start-by and money-ready dates.
- Find what’s quietly recurring. The subscription tracker template has an AI prompt that finds your recurring charges.
- Write down the things only you know. The household file template is an AI prompt that interviews you and writes the file.
Do this today: export the last three months from the account that pays your rent and run the prompt on it. Add your card export when you have a few more minutes. Until then, the bills charged to it stay hidden inside the card payment.
Educational notice: This article provides general educational information, not individualized financial or legal advice. Bill timing, posting dates and payment rules vary by company and account. AI assistants can make mistakes, so check every result against your own statements and bills.
