Receipt organisation
How to match receipts to bank transactions
Compare receipt records with bank CSVs using a worked example. Review timing, repeated amounts, currency differences and unresolved transactions.
By Pengwu · · 5 min read
The takeaway
Different posting dates or currencies need an explanation. Matching purchase records is a separate task from a full bank reconciliation.
Compare the receipt and bank record side by side. Check the date, supplier, amount, currency and supporting document, then record the decision and any open question.
Compare the records before deciding
Receipt record E011
- Supplier
- Transit Example
- Purchase date
- 2026-09-30
- Amount
- AUD 18.60
- Reference
- R-011.pdf
Bank line T012
- Description
- TRANSIT
- Posted date
- 2026-10-02
- Outflow
- AUD 18.60
- Example link
- E011
Fictional practice data. Changes stay in this example; no records are saved.
You can do this beside a paper statement, in a local spreadsheet or in Google Sheets. The important part is preserving both source lists and documenting your decisions. This walkthrough is a manual purchase-record comparison, not a complete bank reconciliation or an automatic matching feature in Gexpense.
Download the fictional expense CSV, bank review CSV or workbook containing both. The bank review contains completed teaching decisions; start a fresh review-status column for your own records. Its document references are fictional labels, with no receipts attached.
1. Keep the bank export and expense list separate
Save an untouched copy of each export. In a working spreadsheet, put transactions and expenses on separate tabs with headers. For CSV imports in Google Sheets, use File → Import and choose an available destination that keeps the working records intact. Google's import guide explains destination and separator options, which vary by file type.
Confirm which account and dates the bank export covers. Check whether money leaving the account is positive, negative or in a separate debit column. The practice CSV uses a clearly labelled positive Outflow column. Do not assume your bank uses the same convention.
Add a stable transaction ID, an expense-reference field, review status and reason. Keep the bank's description unchanged; a separate note can explain a supplier name you recognise.
2. Find candidates using several details
Start with currency and amount, then review the dates and merchant description. Open the original document before accepting a match. A purchase date can differ from a statement's posted date, and a bank description can differ from a trading name.
In the fictional data, the AUD 24.00 CloudKite receipt dated 2 September corresponds to the CLOUDKITE bank line posted 3 September. Record E002 against T001 and keep the explanation. For an unclear case, leave it unresolved rather than picking the nearest-looking line.
Treat one-to-many cases carefully. A single payment may relate to several documents, while a card repayment may represent many underlying purchases. Do not duplicate a payment across expense rows just to make the visible amounts match. Ask your accountant about cases you cannot explain.
3. Review the exceptions instead of forcing them to match
Scroll sideways to compare all columns.
| Example | Review action |
|---|---|
| Two PAPER TRAIL lines for AUD 42.80 | Use R-004 and R-005 to distinguish the two purchases |
| USD 15 receipt; AUD 23.10 bank line | Check statement conversion details and any fees; do not equate unlike amounts |
| AUD 200 transfer between own accounts | Keep this fictional movement outside the purchase matching list |
| UNKNOWN CARD for AUD 27.40 | Investigate the charge and obtain the supporting document |
| 30 September receipt posted 2 October | Record the timing difference and review the next statement |
The two Paper Trail purchases are both valid in this fictional exercise. Matching the first bank line twice would leave the second purchase unexplained even though the amounts look right. The duplicate review guide shows why date and amount alone cannot decide which entry to remove.
4. Keep an unresolved list with useful next actions
For each unmatched or uncertain item, note what is missing and who can answer it. Examples include “request the invoice”, “check the next statement”, and “ask about the foreign-currency payment”. Do the same for expenses that have no obvious payment: they may have been paid in cash, from a different account or in a different period.
Eight September AUD bank lines in the practice file have reviewed links to example expenses totalling AUD 280.70. Another AUD 18.60 September receipt posts in October. That explains why the September AUD expense report totals AUD 299.30 without requiring the selected September bank outflows to equal it.
Keep the currency question, unknown charge and separate transfer visible. Do not turn missing information into a zero or mark the whole account reconciled because several purchases match.
5. Understand where this review ends
A full reconciliation considers the accounts and balances, not just receipt rows. The IRS Publication 583 section on reconciling a checking account includes bank charges and timing items such as deposits and uncleared checks. This worksheet does not implement that complete process or replace your accountant's work.
Once the purchase review is useful, create the monthly expense report and include unresolved items in your accountant handoff.
Gexpense currently helps with receipt extraction, reviewed entry and filing in its connected Sheet and Drive folder. It does not connect to your bank or perform this comparison automatically. If capturing the originals is the part slowing you down, start with the receipt workflow and keep the statement review as a separate step.
Frequently asked questions
Should purchase and bank dates always match?
No. A transaction can post later. Keep both dates and explain the difference using the receipt and statement.
Does Gexpense reconcile my bank account?
No. Gexpense handles receipt extraction, reviewed saving and filing. The comparison in this guide is manual and is not a complete bank reconciliation.