How to Track Cash Spending (When Your Bank Can't)

To track cash spending, log each cash purchase at the moment you pay: the amount, what it was for, and "cash" as the payment method. Don't count ATM withdrawals as spending. A withdrawal just moves money from your bank to your wallet, so treat it as a transfer. Then count your wallet once a week to catch anything you missed.

That's the whole method. The rest of this guide explains why cash is so easy to lose track of, how to handle withdrawals without counting anything twice, and how to build a cash vs card report in Google Sheets.

Why cash disappears from your budget

Cash hasn't gone away. In the Federal Reserve's 2025 Diary of Consumer Payment Choice, which covers 2024, cash made up 14% of US consumer payments, about seven cash payments per person each month. That figure hasn't changed since 2020.

Those seven payments are the ones a budget loses, for three reasons:

• Your bank sees the withdrawal, not the purchases. A $100 ATM withdrawal shows up as one line. The tacos, the parking meter, the tip and the farmers market eggs it paid for never appear anywhere.
• Bank-linked apps can't fix this. An app that reads your bank feed sees what your bank sees. Most label the withdrawal "Cash" or "Transfer" and leave it there, so either your cash spending is missing or it shows up as one large, meaningless "Cash" category. (More on how those feeds work in what Plaid does with your data.)
• Cash purchases are small and frequent. A $4 coffee doesn't feel worth remembering, and by evening you won't. Small cash purchases are where "where did my money go?" usually comes from.

So cash has to be tracked by hand. The good news: logging it by hand takes seconds, and it tells you what you actually bought, which a bank feed never does, even for card payments.

How do you track cash spending?

Use one sheet for all your spending, cash and card together, and add a Payment column. Here's the setup:

Make Payment a dropdown (in Google Sheets: Insert → Dropdown) so every entry reads "Cash" exactly, with no stray "cash " or "CASH" spellings breaking your formulas later. If you use Voice Sheet's free Personal Finances template, which has Date, Category, Amount and Notes, add the Payment column yourself.

Keep cash and card in one sheet. Separate sheets make it harder to see a full month's spending, and your budget only works when it sees everything.

The log-at-payment rule

The single habit that makes cash tracking work: log it before your wallet goes back in your pocket.

Logging later is where entries go missing. By evening you'll remember the $22 lunch and forget the $3 tip and the $2 parking. At the moment you pay, you know the exact amount and what it was for.

To make that fast enough to actually do:

1. Keep the entry short. Amount, what, payment method: "farmers market 18 cash". Your sheet's columns handle the rest.
2. Use whatever's fastest on your phone. A home screen shortcut to your sheet, a notes app you paste in later, or voice entry. With Voice Sheet, you say "tacos 14 cash", and it saves a row with the amount, category and "Cash" in the Payment dropdown.
3. Don't wait for signal. Markets, festivals and parking garages often have no reception. Voice Sheet queues entries offline and syncs them to your sheet when you're back online.
4. Batch truly tiny items. If you buy three $1 items at a stall, one "market snacks 3 cash" entry is fine. You want an accurate total, not a perfect receipt.

Voice input in Voice Sheet is English only, and it doesn't scan receipts. If you collect paper receipts, you'll still type or say each one.

How to handle ATM withdrawals (the transfer rule)

This is where most cash budgets go wrong. Take a $100 withdrawal, of which you spend $60 this week:

• Logging the withdrawal as spending shows $100 spent, even though $40 is still in your wallet.
• Logging the withdrawal and the purchases shows $160 spent. That's double counting.
• Logging only the purchases shows $60 spent. Correct.

So a withdrawal is a transfer: money moving from your bank account to your wallet. Nothing has been spent yet. Spending happens when the cash leaves your wallet, and that's what you log as an expense.

Keep a withdrawals tab

You don't have to ignore withdrawals altogether. Put them on a separate tab, called something like "Cash In", with two columns:

Cash you receive also goes here: a friend paying you back, a birthday card, or cash from selling something. This tab isn't spending, so your budget totals never see it. It exists for one check.

The weekly wallet check

Once a week, count the cash in your wallet and compare it with what your log says should be there:

Expected cash = last week's count + Cash In this week − cash spending logged this week

If you count $35 and expected $41, you've got $6 of unlogged spending. Add it as one entry, "Unlogged cash, 6", and move on. Don't try to reconstruct it.

The gap tells you how well the habit is working. A few dollars a week is normal. If it's $30 every week, you're logging later instead of at the moment you pay, and a daily reminder will help.

Cash back, foreign cash and shared bills

• Cash back at a store: split it. The groceries are a card expense, and the cash back goes on your Cash In tab.
• Foreign cash: log purchases in the local currency, in a separate sheet for the trip. Voice Sheet supports 30 currencies, one per spreadsheet, and doesn't convert between them, so keep each trip's cash in that trip's sheet. Our guide for travelers covers the setup.
• Paying a friend back in cash: log only your share as an expense, and add a note saying who you paid.

Build a cash vs card report in Google Sheets

Once Payment is a column, your sheet can show how much of your spending goes through cash. These formulas assume an Expenses tab with Date in column A, Category in B, Amount in C and Payment in D.

Cash spent this month:

=SUMIFS(Expenses!C:C, Expenses!D:D, "Cash", Expenses!A:A, ">="&EOMONTH(TODAY(),-1)+1, Expenses!A:A, "<"&EOMONTH(TODAY(),0)+1)

Change "Cash" to "Card" for the card total. The date window resets itself on the 1st of each month. If the date part is new to you, see our SUMIFS by month guide.

Category by payment method, this month:

=QUERY(Expenses!A2:D, "select B, sum(C) where C is not null and A >= date '"&TEXT(EOMONTH(TODAY(),-1)+1,"yyyy-mm-dd")&"' group by B pivot D", 0)

This returns one row per category, with one column for Cash and one for Card. It usually shows a pattern quickly. Cash tends to concentrate in a few categories, like food, transport, tips and markets, and those categories are usually the ones over budget.

Cash share of spending: divide the cash total by the total of both. If cash is 5% of your spending, the weekly wallet check is enough. If it's 30%, cash deserves its own line in your budget.

Because withdrawals live on their own tab, none of these totals double count. The same goes for Voice Sheet's budget dashboard, which compares spending in your Expenses rows with your budget per category: log purchases, not withdrawals, and it stays accurate.

Cash is where manual tracking beats a bank feed

Bank-linked budgeting apps are good at card payments and blind to cash. If cash is a real part of how you pay, you need a manual log anyway, and a manual log can cover your card spending too. That's the case for tracking without a bank feed, which we cover in full in how to track expenses without linking your bank.

Voice Sheet works that way. There's no bank linking or aggregator, and every entry, cash or card, becomes a row in your own Google Sheet. Voice entry is part of Premium. On the free plan, you can log the same entries with a form built from your sheet's columns.

The short version

• Log cash purchases at the moment you pay, with "Cash" in a Payment column.
• An ATM withdrawal is a transfer, not spending. Keep withdrawals on a separate tab.
• Count your wallet weekly, and log any gap as one "Unlogged cash" entry.
• Use SUMIFS or QUERY on the Payment column to see cash vs card by category.
• Small, frequent cash purchases are the ones worth catching.