Count card purchases, not card payments, in your spending total

Decide whose spending you are counting

A household spending total needs the accounts where the household actually buys things, not just the checking account that pays the bills. Write down the checking accounts, cards and savings accounts you include. If a partner's card is missing, say so. Calling an incomplete list “our spending” makes the number sound more complete than it is. Keep different currencies in separate totals; adding USD and EUR amounts won't give you a usable spending number.

For this worksheet, spending means purchases of goods and services, less identified purchase refunds. Moving money from your checking account to your savings account isn't a purchase. Paying your card isn't another purchase either: you already counted the groceries or travel on the card. If you also want fees and interest in a broader household-cost total, show those charges separately and count each once, rather than using the card payment as a substitute.

Account coverage also explains why an app may label things differently. In YNAB's transfer guide, updated September 24, 2026, you record a transfer when both accounts are included. When only the sending account is included, YNAB calls the outgoing transaction spending. That is an app boundary, not evidence that you bought something. In your own spreadsheet, a confirmed move to your own savings can stay outside purchase spending even if you haven't downloaded savings yet. Note the missing account instead of hiding it.

The purchases add up to $240, not $740

Here is one fictional household example, in USD, using September 2026 posted transactions. Checking, savings and one card are all included. There are three purchases, a card payment, a savings transfer and a later travel refund. Each transfer appears in both affected accounts, so the table has eight rows.

Purchases are 40 + 80 + 120 = 240. Adding the card payment would produce $440, counting the card purchases and their payment. Adding the savings transfer too would produce $740. Neither is a purchase-spending total. After the identified $20 travel refund, net purchase spending is 240 - 20 = 220.

Checking tells a different, equally useful story: 40 + 200 + 300 = 540 left that account. Savings received $300, so the combined checking-and-savings cash change is -540 + 300 = -240. The card refund didn't put cash into either bank account. Here, the $240 cash decline happens to equal purchases before the refund because the card payment equals the card purchases. Don't expect those totals to match in another month.

The zeroes in the spending column don't erase the payments. Those entries still explain the individual accounts. A payment stays outside purchase spending even when it pays for last month's purchases or an older card balance. You're measuring what you bought this month, not how much debt you paid off.

Keep one row per account entry

You can copy this fictional CSV into a spreadsheet to try the separation. It uses a chosen sign convention: purchases and outgoing transfers are negative; incoming transfers and the refund are positive. On card rows, a negative purchase increases what you owe, while a positive payment or refund reduces it. Your issuer's download may use the opposite signs. This is a review worksheet, not an accounting-app import file.

Row,Posted,Account,Description,Amount,Kind,Pair
C1,2026-09-03,Checking,Groceries,-40.00,Purchase,
K1,2026-09-05,Card,Groceries,-80.00,Purchase,
K2,2026-09-12,Card,Travel,-120.00,Purchase,
C2,2026-09-18,Checking,Card payment,-200.00,Transfer,P1
K3,2026-09-19,Card,Payment received,200.00,Transfer,P1
C3,2026-09-24,Checking,To savings,-300.00,Transfer,T1
S1,2026-09-25,Savings,From checking,300.00,Transfer,T1
K4,2026-09-28,Card,Travel refund,20.00,Refund,

Add a separate spending column: enter positive amounts for purchases, negative amounts for identified purchase refunds and zero for confirmed transfers. Leave unresolved entries marked “review” and show their count beside the subtotal, so a finished-looking number doesn't hide the work left to do. Income also stays outside purchase spending. For bank cash movement, use all signed checking and savings entries, including income and transfers, but no card rows.

In your real file, retain the original amount and description beside your review columns. Check a known purchase and payment before interpreting the signs, using the credit-card CSV sign guide if needed. If your bank supplies separate debit and credit columns, the debit/credit converter can help put them into one signed column. It cannot decide whether a row is your own transfer.

A statement month is not always a calendar month

If your card statement closes halfway through the month, its total mixes two calendar months. To cover September 1 through 30, you may need entries from two statements. Get all statements covering your chosen dates, then check each file against its statement before filtering to the month. For this worksheet, posted dates are a practical default because you can trace each included entry back to those records.

Chase's explanation of transaction and posting dates distinguishes when you make a purchase from when the issuer processes it. Those dates can differ. A purchase near month-end can therefore belong to one month on a purchase-date report and the next on a posted-date report. Neither choice fixes an error in the other; they answer different questions.

• Use purchase dates when your question is when you bought things. Keep posted dates too, so you can explain the difference from the statements, and flag rows whose purchase date you don't have.
• Use posted dates when you want purchases recorded by the bank within a calendar period. Keep pending activity outside that finished total and review it separately.
• Use the statement's own coverage when checking that statement. As Chase's billing-cycle guide explains, the cycle has its own start and closing dates and covers transactions that post within that period. Don't rename it a calendar month unless the dates match.

Both Chase pages were checked on October 17, 2026; neither retrieved page showed an update date. They describe a US issuer, not every bank's export format. Check what the date column in your own download means, and don't silently mix purchase dates from one account with posted dates from another. If the exports overlap, resolve the overlapping copies within each account before totaling them.

Match the transfer, but keep both sides

Seeing the same payment in checking and on the card is expected. In YNAB's credit-card payment guide, updated October 11, 2026, a card payment is explicitly a transfer: an outflow in the paying account and an inflow in the card account, not a duplicate. Our worksheet gives those two entries the same pair reference, P1, and keeps them both.

For your own records, confirm the sending and receiving accounts, amount, direction and payment or transfer details. Matching amounts are a lead, not enough on their own. A payment to somebody else is not automatically an internal transfer just because it uses a bank-transfer service. Nor does the word “payment” make a row your card payment.

If only one side appears, first check whether the other account or part of the date range is missing. In the fictional CSV, checking records the payment before the card does. A cutoff between those entries would leave an unmatched row without changing what the payment was. Search the receiving account's adjacent period, but keep each entry on its actual date in the cash report.

Suppose S1, the savings receipt, is missing from your files. If the transfer confirmation identifies your own savings account and the amount, mark C3 “confirmed own-account transfer; receiving record missing.” You can exclude it from purchases, but you cannot claim to have checked both sides or completed the combined bank-cash total. If you cannot identify the destination, leave C3 unresolved and call the spending result provisional. Don't invent a receipt to make the pair balance.

Missing the entire card history is a bigger gap. Removing the checking payment avoids one wrong classification, but it doesn't recover the card purchases. Get the card detail before calling the result complete; the amount paid is not a reliable substitute for purchases in your chosen month. Ask the bank or issuer about an unexplained payment record rather than deciding from the spreadsheet that it went through or failed.

Refunds reduce purchases; cash needs another record

The example's $20 refund reduces travel spending because it is explicitly tied to that purchase. Your real credit entries need the same identification. A card payment, reward credit and merchant refund should not all become negative groceries just because they reduce the card balance. Keep a purchase reference beside the refund and leave an unidentified credit unclassified until you know what it is.

For the posted-date method used here, subtract the refund in the period when it posts. If the original purchase was in an earlier month, say that the current total includes a refund of earlier spending. A category can consequently be negative for the month. That is more honest than moving the credit to an arbitrary date to make the report look normal. You can make a separate purchase-linked view, but label it differently and don't subtract the same refund twice. A promised refund that hasn't posted belongs in a follow-up note, not this posted total.

Cash has a different missing-detail problem. An ATM withdrawal tells you cash left the bank, not what you bought with it or whether you still have it. If you track a cash wallet and receipts, treat the withdrawal as a transfer to cash and count the actual cash purchases. Count any separately identified withdrawal fee as a cost, not as money received by the wallet.

Without that record, show “cash withdrawn; use unknown” separately. You can choose withdrawals as a rough cash-spending proxy, but say so and don't add cash receipts on top of the same withdrawals. Neither approach lets a bank statement alone reveal unrecorded cash purchases. Our fictional $220 total contains no cash spending.

Put the limits beside the number

If you share the total with someone else, include enough detail for them to see what it covers. For the complete fictional dataset above, a short note is enough:

September 2026, posted dates, USD. Checking, savings and one card included. Purchases $240 less an identified $20 travel refund: $220 net purchase spending. The $200 card payment and $300 savings transfer are excluded from purchases, with both sides retained. Checking fell $540; checking and savings together fell $240. No cash purchases, fees or interest are included in this example. No unresolved rows.

Change that last sentence if any records are missing. A known subtotal with a clear gap is more useful than a finished-looking total that quietly leaves out a card.

For a separate account-by-account cash report, use the monthly cashflow tool with posted checking and savings rows. Leave transfers included to see each account's full cash movement. Keep currencies separate and don't label that result purchase spending.

Use your bank's native transaction download where available; if the missing historical detail exists only in PDFs, AnyStatement can turn those statements into rows for this review, but you still decide which entries are transfers.

We opened the linked YNAB and Chase guidance on October 17, 2026, and independently checked the fictional CSV with Python decimal arithmetic: all eight rows, both transfer pairs, purchase totals and bank-cash totals. We also checked missing-record and cutoff cases. We didn't test a live YNAB account, a bank download or this worksheet in Excel. This is a way to describe household purchases, not a tax calculation, debt-repayment plan or decision about a disputed transaction.