To exclude transfers from budget totals, give every row that only moves money between your own accounts a Transfer category, then leave that category out of your spending formulas. Savings deposits, credit card payments and moves between checking accounts are transfers. Check the result by confirming that the transfer rows across all accounts add up to zero.
Which statement rows are transfers rather than spending?
A transfer is a statement row that moves money between two accounts you own. The money leaves one account and arrives in another, so your total wealth does not change. Spending is money that leaves your accounts for good. The test is simple: if the other side of the row is also yours, it is a transfer.
Rows that are usually transfers:
- Moves to and from savings. "TRANSFER TO SAV 4471" on checking and "TRANSFER FROM CHK 0912" on savings.
- Credit card payments. "PAYMENT TO VISA CARD" on checking and "PAYMENT THANK YOU" on the card.
- Moves between two checking accounts, such as a joint account and a personal one.
- Funding a brokerage or retirement account you own, if you track it outside the spending budget.
Rows that look similar but are not transfers: a Zelle payment to a friend, rent paid by bank transfer to a landlord, or a loan payment. Each of those leaves your accounts for good. A loan payment can also be split into interest, which is a cost, and principal, which reduces the debt.
Tagging transfer rows in the budget sheet
Tag transfer rows by giving them their own category, such as Transfer, in the same column you use for groceries and rent. A payee lookup can catch most of them automatically, because banks print transfer rows with consistent text. Add rules for fragments like "TRANSFER TO", "TRANSFER FROM", "PAYMENT THANK YOU" and your card's payment text.
Tag both legs. The outgoing row on checking and the incoming row on savings are both transfers. If you only tag one, the other side lands in Income or Uncategorized and distorts that line instead.
Here is an example, with made-up rows from a checking and a savings statement:
| Account | Date | Description | Amount | Category |
|---|---|---|---|---|
| Checking | 2026-09-01 | PAYROLL ACME CO | 2,150.00 | Income |
| Checking | 2026-09-01 | TRANSFER TO SAV 4471 | -300.00 | Transfer |
| Savings | 2026-09-01 | TRANSFER FROM CHK 0912 | 300.00 | Transfer |
| Checking | 2026-09-05 | PAYMENT TO VISA CARD | -640.00 | Transfer |
| Checking | 2026-09-09 | KROGER #0412 | -86.40 | Groceries |
| Checking | 2026-09-14 | CITY WATER | -48.90 | Utilities |
Without tags, spending for these rows looks like $1,075.30. With transfers tagged and excluded, spending is $135.30, the groceries and water bill. The $640 card payment is not spending in this view; the purchases it paid for appear on the card statement in their own categories.
If you are budgeting paycheck by paycheck, the savings transfer is part of the plan, not an expense. The guide to a paycheck budget spreadsheet shows where planned transfers sit beside each payday.
Filtering transfers out of budget totals with SUMIFS
To filter transfers out of budget totals, add a condition to your spending formula that skips the Transfer category. With SUMIFS, a condition of "<>Transfer" keeps every category except transfers. Pair it with a condition that keeps only negative amounts, and you get money out with transfers removed.
In Excel or Google Sheets, with amounts in column D and categories in column E:
=-SUMIFS(D:D, D:D, "<0", E:E, "<>Transfer")
The leading minus turns spending into a positive number. If you also tag income, an income total that ignores transfers from savings looks like this:
=SUMIFS(D:D, D:D, ">0", E:E, "<>Transfer")
For a pivot table, filter the Category field and untick Transfer. For a chart, build it from the filtered totals, so the savings move never shows as a spike.
Refunds need the opposite treatment. A refund is not a transfer, because the money comes from a store, not from your own account. It belongs in the category of the original purchase. The post on recording refunds in a budget covers that case.
How can you check the transfers net to zero?
Check transfers by adding up every row tagged Transfer across all your accounts for the month. If every transfer has both legs in the sheet, the total is zero, because each amount out is matched by the same amount in. A non-zero total means a leg is missing, mis-tagged, or falls in a different month.
The check formula:
=SUMIFS(D:D, E:E, "Transfer")
When the result is not zero, work through these causes:
- One account's statement is missing. If you included checking but not savings, every savings transfer shows only one leg.
- A row is mis-tagged. A spending row tagged Transfer by an over-broad rule, such as "TRANSFER" catching a wire to a landlord.
- Timing. A transfer sent on the 31st may post on the 1st in the receiving account. Look one or two days either side of the month boundary.
- Card payments. The card side of a payment only nets to zero if the card statement is in the sheet.
A transfer total of exactly zero is good evidence the tagging is complete. Tagged, matched transfers also help if your statements ever need to show who paid whom, for example when gathering bank statements as evidence for small claims court.
Transfer edge case: credit card payments and double-counted purchases
A credit card payment is the transfer most likely to double count spending. The purchases appear on the card statement, and the payment that settles them appears on checking. Counting both counts every purchase twice. Treat the card payment as a transfer, and categorize the purchases from the card statement instead.
This only works if you include the card statement in the sheet. If you budget from checking alone, the card payment is the only trace of that spending, and leaving it out removes the spending entirely. In that case, give the card payment a category such as "Card spending" rather than Transfer, accepting that you lose the detail. A worked example of the double count is in budgeting with a credit card without double counting.
Two more cases deserve a rule:
- Paying more than the statement balance leaves a credit on the card. It is still a transfer.
- Interest and fees on the card are real costs. They appear on the card statement, and they belong in a Fees or Interest category, not Transfer.
If your card statements arrive only as PDFs, converting them is what lets you categorize the purchases. CheapBankConvert turns a PDF statement into CSV or Excel rows, priced per statement, with nothing to renew. It is in early access; get started to hear when it opens.