Money basics

Turn Payment Screenshots Into Expense Entries (Canada Edition)

Turn payment screenshots into expense entries in Canadian dollars, with a duplicate check and a worked example from a house-move month.

Editorial illustration for Turn Payment Screenshots Into Expense Entries (Canada Edition)

Payment screenshots pile up fastest in the busiest months, and the busiest month is also the one where you most need a record. Take a month with a move: a deposit, a moving crew, cleaning supplies, a handful of small payments for odds and ends. To turn the screenshots into expense entries, sort by size first, enter the big ones carefully, and then sweep up the small ones.

Why sort by size instead of date

In an ordinary month the screenshots are mostly small, and date order is fine. In a move month, three or four large payments carry most of the money, and a mistake in one of them matters far more than a mistake in a coffee. So start with a size-sorted list. If your gallery cannot sort by amount, scan once and set aside every screenshot with a number above a threshold you choose, such as 100 dollars.

The steps

  1. Collect all payment screenshots from the month into one folder.
  2. Pull out the large ones and enter them first, with extra care: date, payee, amount, purpose.
  3. Confirm each large one against your bank record, because these are the payments you may later need to prove.
  4. Enter the small ones in a batch, category by category if you can.
  5. Run a duplicate check before you total anything.

The duplicate check

Duplicate screenshots are common. You take one when you pay and another when you show it to someone, or a payment app sends a receipt that you also capture. In your sheet, sort by amount and then by payee, and look for two rows with the same amount and payee within a day. If you can tell that they are one payment, delete one. If they could be two, check your statement. A genuine repeat, such as two bus tickets, is not a duplicate.

A worked example in Canadian dollars

Say the month of the move produced these entries after sorting.

DatePayeeAmountNote
1 JunLandlordC$1,450.00Deposit for new place
14 JunMoversC$620.00Truck and two helpers
14 JunMoversC$620.00Duplicate screenshot, deleted
15 JunHardware shopC$87.35Hooks and shelf brackets
16 JunCleaning suppliesC$34.90Cloths and cleaner
20 JunInternet installerC$60.00Set-up visit

After deleting the duplicate, the total is 1,450.00 plus 620.00 plus 87.35 plus 34.90 plus 60.00, which comes to C$2,252.25. If you had left the duplicate in, the sheet would have said C$2,872.25, a C$620.00 overstatement that would have looked like a real expense.

How should I label one-off costs?

Give moving costs their own category so that they do not distort the month's everyday spending. A move-month total of C$2,252.25 compared with an ordinary month of C$900 could scare you into the wrong conclusion. Say that the month contained one-off costs and show them separately, so the underlying monthly picture is clear.

What if a screenshot does not say what the payment was for?

Write the purpose yourself on the same day, from memory, while it is still fresh. Weeks later, "Payment to J. Singh, C$620" could be anything. A note beside it, written promptly, makes it a record.

Splitting a large payment across categories

A single screenshot can cover more than one purpose. A hardware shop payment might include both shelves for the new flat and tools you will keep. If you know the split, enter two rows that add up to the screenshot total and label each. If you do not, keep one row with the full amount and a note that the split is unknown.

A closing routine

  • Sort and enter the large payments first.
  • Confirm each against your bank record.
  • Check for duplicates by amount and payee.
  • Put one-off costs in their own category.
  • Keep a screenshot or statement line for anything you might need to prove.
SPENDIXAI JOURNAL

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

Explore your reports