Getting started

How many transactions in a month? Count across chequing and credit cards

Count your real monthly transactions across a chequing account, savings and a credit card without counting the same dollars twice, with an example in C$.

Editorial illustration for How many transactions in a month? Count across chequing and credit cards

The simplest answer is to add up the spending rows on every account you use, but the trap is counting the same money twice. If you pay a credit card from your chequing account, that payment is one row on one statement and the purchases are rows on another. Count the purchases, skip the payment, and your total will match what you actually spent.

Which accounts go into the count?

Everything you spend from: chequing, any credit card, a debit card on a second account, and a payment app that draws from one of them if it shows on the account statement. Savings accounts usually hold only transfers and interest, so they rarely add spending rows. Download each statement for the same calendar month and mark every row with its account name so you can audit it later.

How do I keep from counting twice?

Think of the accounts as pipes. Money coming into the chequing account from work is income. Money moving from chequing to savings, or from chequing to the card, is movement between pipes, not spending. The purchases on the card are spending. Only rows where money leaves your pipes for a shop, a landlord, a utility or a person count.

AccountRows on statementRows skippedRows counted
Chequing38632
Credit card47245
Savings440
All accounts891277

In this made-up month the skipped rows were own-account transfers and the card payment on chequing, the two payments received on the card, and the savings interest and transfers. Counted spending is 77 rows.

How do I get the figure with formulas?

  1. Paste all statements into one sheet: Date in A, Description in B, Amount in C with money out positive, Account in D.
  2. In column E mark skipped rows with the word Skip.
  3. Count with =COUNTIFS($C$2:$C$400,">0",$E$2:$E$400,"<>Skip").
  4. Count per account with =COUNTIFS($D$2:$D$400,"Credit card",$C$2:$C$400,">0",$E$2:$E$400,"<>Skip").
  5. Total with =SUMIFS($C$2:$C$400,$E$2:$E$400,"<>Skip").

Say the total is C$3,124.00. Divided by 77 rows, the average is C$40.57, since 77 times 40 is 3,080 and the remaining 44 divided by 77 is about 0.57.

How can I tell the count is right?

Reconcile each account. Take the opening balance, add everything that came in, subtract everything that went out, and compare with the closing balance on the statement. If the two figures do not match, a row is missing or was pasted twice. Do this for every account before you trust the count; it takes a couple of minutes and saves an afternoon of confusion later.

What does the count tell me?

  • Rows per account show which card or account takes most of your daily life.
  • A big gap between rows on the card and rows on chequing may mean the card is your default for small buys.
  • Rising rows with a steady total point to more small purchases.
  • Rows that appear every month at the same amount are your recurring commitments.

What about cash and e-transfers between friends?

Cash taken from a machine is one row on the statement, even if you spend it on twenty small things. Count the withdrawal as spending, and if you want the detail, keep a short note of what the cash was used for. Transfers to a friend who is repaying you or splitting a dinner are rows too. If a friend sends you money for your shared meal, treat it like a refund and keep it outside the count, so the number reflects what you paid for yourself.

Keeping it up

Set a reminder for the first of each month, download the previous month, and add one line to a log: month, rows counted, total and average. Over a few months you will see your range, and you can stop guessing about how often you reach for a card.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports