Cards and UPI

One Dashboard for All Accounts and Credit Cards (Canada Edition)

Get one dashboard for all your bank accounts and credit cards in Canada by tagging each as asset or liability and netting them in a simple sheet.

Editorial illustration for One Dashboard for All Accounts and Credit Cards (Canada Edition)

The simplest single view of accounts and cards is a sheet where each line is tagged either Asset or Liability. Assets are what you hold, such as chequing and savings. Liabilities are what you owe, such as credit cards and a line of credit. One formula subtracts the second total from the first and gives you a net figure in a second.

Why tag instead of using plus and minus signs?

People forget signs. One month a card balance is typed as 1,180 and the next as minus 1,180, and the total quietly swings. A Type column removes the decision: everything is entered as a positive number, and the formula decides what to add and what to subtract. It also makes the sheet readable by someone else, which matters if a partner or an adviser ever looks at it.

How do you set up the sheet?

  1. In row 1 write Account, Type, Balance, Checked on.
  2. In column B enter only the word Asset or Liability, spelled the same way every time.
  3. In column C enter balances as positive numbers.
  4. Put the total assets in a cell with =SUMIF($B$2:$B$30,"Asset",$C$2:$C$30).
  5. Put the total liabilities in the next cell with =SUMIF($B$2:$B$30,"Liability",$C$2:$C$30).
  6. In a third cell, subtract: assets cell minus liabilities cell.

SUMIF takes the range to test first, then the condition, then the range to add. The same formulas work in Excel and in Google Sheets. If you mistype a Type, such as Liabilty, the row is silently left out, so add a check cell: =COUNTA($A$2:$A$30)-COUNTIF($B$2:$B$30,"Asset")-COUNTIF($B$2:$B$30,"Liability") should show zero.

A worked example with made-up numbers

AccountTypeBalance (CAD)
ChequingAsset$2,450
SavingsAsset$5,200
Credit cardLiability$1,180
Line of creditLiability$3,000

Assets: 2,450 plus 5,200 is $7,650. Liabilities: 1,180 plus 3,000 is $4,180. Net: 7,650 minus 4,180 is $3,470. The check cell reads zero because four accounts are listed and all four are tagged.

What should you add once the basics work?

  • A Checked on date, so stale rows stand out.
  • A conditional colour that turns the date red when it is older than 35 days.
  • A column for the last four digits so you can tell two cards apart.
  • A row for money you are holding for someone else, entered as a Liability so it cancels out.

What does a negative net figure mean?

If liabilities come out higher than assets, the formula returns a negative number. That is not a verdict on you, only a fact about the day. A new loan taken for something that holds its use, or a card paid off slowly after a big purchase, can do this. Look at which liability is largest, note when it started, and write the date you expect it to shrink. Seeing the number each month is more useful than avoiding it.

How often should you update it?

Once a month is a fair start, ideally the day after your main income lands. Copy the sheet to a new tab with the month's name, so you can look back. Compare Net with the previous tab and write a single line about what moved it.

Where does a tool take over?

When the sheet grows beyond a few accounts, or you want to see activity inside each one, a tracker can save effort. SpendixAI is built around India and INR and is not offered in Canada, but its accounts view, which lists every account with its activity, is a useful pattern: every transaction belongs to one account, and that account is visible at a glance. If you use any such tool, confirm that it does not ask for your banking login.

A last-minute checklist

  1. Every account and card is on the sheet.
  2. Every row has a Type and a date.
  3. The check cell shows zero.
  4. Net is saved under today's date.
  5. Next month's reminder is set.
SPENDIXAI JOURNAL

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

Explore your reports