Card receipts to Excel

What it reads from a card slip

A card receipt shows the merchant name and address, the date and time, a masked card number, an authorization code and the amount, and sometimes a tip line. ReceiptMoa records the date, merchant name and total. Card numbers and authorization codes are filtered out so they aren't mistaken for amounts, and they never go into the table or the Excel file.

Files download as card-receipts_date_time.xlsx with a sheet called Card receipts.

Reconcile against your statement

The main reason to log card receipts is to check them against your statement.

1. Download your statement from your bank or card issuer as CSV or Excel and paste it into a sheet named Statement.
2. Put the downloaded receipt table next to it.
3. Match rows by amount and date. A statement line with no receipt is a charge you should recognize or query. A receipt with no statement line was paid with another card or was voided.

Charges often post a day or two after the purchase, so match on amount within a small date window. If the statement's date is in column A and the amount in column C, =COUNTIFS(Statement!C:C, D2, Statement!A:A, ">="&B2, Statement!A:A, "<="&B2+3) returns 0 for receipts with no matching charge in the following three days.

When the merchant name looks unfamiliar

Card slips and statements often show the business's legal name or the payment processor's label rather than the name above the door. Fix it in the table if you'd rather see a familiar name. The Excel file uses whatever the table says.

Tips written in by hand

On restaurant slips where you write in the tip, the reader only sees the printed numbers, and a tip line isn't treated as the total. If the amount actually charged includes a handwritten tip, update the total in the table so it matches your statement.

Frequently asked questions

Is it safe to add receipts showing part of my card number?

Photos are read inside this browser and never uploaded. Card numbers aren't added to the table or the Excel file.

Can I mix credit and debit card receipts?

Yes. Their layouts are nearly identical, so they can go in together. Add a Card column in Excel if you want to split spending by card.

Why does a refund slip show up as a regular amount?

Refund and void slips usually print the amount as a positive number, so they appear as an extra row. Delete both the original purchase row and the refund row, or note the refund in a separate column.