Money basics

Turn Payment Screenshots Into Expense Entries in Three Passes

You have dozens of payment screenshots and no expense list. Here is a three-pass method with dollar examples to turn them into clean entries.

Editorial illustration for Turn Payment Screenshots Into Expense Entries in Three Passes

You have a camera roll full of payment confirmations and no list of what you spent. Nobody wants to retype forty screenshots in one sitting, so do not. Turn them into expense entries in three short passes: sort, read, then enter. Each pass is mechanical, which keeps it quick and keeps mistakes low.

Pass one: sort and clear the clutter

Start by moving all the payment screenshots into a single album or folder so that you are not scrolling through holiday photos. Then delete duplicates. A common source of double counting is taking two screenshots of the same confirmation, one when you paid and one when you checked.

  1. Create a folder for the month, for example Payments March.
  2. Move every payment screenshot into it.
  3. Sort by date, oldest first.
  4. Delete any screenshot that shows the same payment twice.
  5. Leave failed or pending payments in a separate folder until you know their outcome.

Pass two: read and note

Open the first screenshot and read four things: date, amount, who was paid, and the reference or note if one is shown. Write them in a sheet, one row per screenshot, with columns for date, payee, amount in dollars, and a category you decide on the spot. If you have the payment app's own history open, check there as well, because it often shows more detail than the screenshot.

Pass three: add the category and total

With the rows typed, add a category for each. Keep the list short. Seven or eight categories are plenty for a month: groceries, transport, eating out, bills, shopping, health, gifts and other.

To total a category in Excel or Google Sheets, with categories in column B and amounts in column C, use:

=SUMIFS($C$2:$C$200, $B$2:$B$200, "Groceries")

Change the word in quotes for each category, or put the category name in a cell and refer to it, as in =SUMIFS($C$2:$C$200, $B$2:$B$200, E2).

A worked example with invented numbers

Say you have 12 screenshots from one week and you read them like this.

DatePayeeAmountCategory
3 MarSupermarket$64.20Groceries
3 MarCoffee shop$6.50Eating out
4 MarTransit top-up$20.00Transport
5 MarPharmacy$18.75Health
6 MarSupermarket$41.30Groceries
7 MarTakeaway$27.45Eating out

For these six rows the grocery total is $64.20 plus $41.30, which is $105.50. Eating out is $6.50 plus $27.45, which is $33.95. The remaining six screenshots would be added the same way. When you tally everything, compare the sheet's total with your bank or card statement for the same dates; any gap points to a screenshot you missed.

What if the screenshot cuts off the amount?

Some confirmations show the amount in a small font or hide it behind a banner. Do not guess. Open the payment history in the app, or match the payment to the statement. If neither works, write the entry with a question mark and fix it at the end of the month.

What if I paid someone abroad?

Sometimes a screenshot shows two amounts: what you sent and what arrived in another currency. Record the amount you actually paid in your own currency as the expense, and add the other figure and the date in the notes column. Tools that let each expense carry its own currency can help, but the habit matters more than the tool.

How do I keep from facing a pile again?

  • Rename or move each screenshot to the month folder on the day you take it.
  • Spend ten minutes at the end of each week on passes two and three.
  • Delete a screenshot once its row is in the sheet and you are sure it is correct.
  • Keep one screenshot for any payment you may need to prove later, such as a deposit or a repair.

A weekly ten minutes beats a monthly two hours. The method does not change when the pile is bigger; it only takes longer.

SPENDIXAI JOURNAL

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

Explore your reports