Treasurers and small-business owners often need just one card's activity for just one event or quarter. The cleanest approach is to import the card's transactions into a sheet and run a query that returns only the rows for that card between two dates. In Google Sheets a single QUERY formula does it, and the same idea works in Excel with a filter.
Who needs this?
Picture a volunteer treasurer for a community hockey club in Ontario. The club has one card used for tournament weekend costs. The committee asks for a report covering 14 to 16 February, with every charge listed and a total. She does not want the equipment budget or the registration deposits in the same list.
How do I set it up?
Put all your card exports into one sheet with these columns: A date, B card name, C description, D amount in Canadian dollars. If you only have one card, still keep column B filled, because it makes the sheet reusable when a second card arrives.
What query returns only one card and two dates?
In Google Sheets, this returns the matching rows: =QUERY($A$1:$D$500, "select A, C, D where B = 'Club card' and A >= date '2026-02-14' and A <= date '2026-02-16' order by A", 1). The final 1 tells it the first row is a header. Dates inside a QUERY must be written in year-month-day order with the word date in front, as shown.
For the total, wrap a second query: =QUERY($A$1:$D$500, "select sum(D) where B = 'Club card' and A >= date '2026-02-14' and A <= date '2026-02-16' label sum(D) ''", 1). In Excel, use SUMIFS with the same three conditions instead; QUERY is a Google Sheets function.
What would the committee see?
| Date | Description | Amount |
|---|---|---|
| Feb 14 | Ice time deposit | C$300.00 |
| Feb 14 | Pizza for volunteers | C$86.40 |
| Feb 15 | Trophies and medals | C$212.35 |
| Feb 16 | Printing, score sheets | C$41.25 |
| Feb 16 | Refund, unused ice time | -C$60.00 |
Total: 300.00 + 86.40 + 212.35 + 41.25 - 60.00 = C$580.00. These numbers are made up to show the mechanics.
How do I prove the report is complete?
Reconcile it. Take the card statement, find the balance before the first charge and after the last, and check that the difference matches the sum of your rows, allowing for any payment made to the card in the same period. If the statement cycle ends on 15 February, you may need the next statement too. A report that matches the statement lets the committee approve it without further questions.
Is there a middle path between a sheet and a full accounting system?
For a volunteer treasurer who also wants categories and receipts attached, an expense tracker can be handy. SpendixAI lets reports be filtered by account and date, keeps receipts with their transactions and exports CSV. It is built around India and INR and is a single-person workspace, not a tool for committees with approvals, so we would not point a Canadian club at it. As a checklist: look for account filters, date filters and a plain export.
Handling several cards in one report
Committees often have more than one card. Keep them all in the same sheet with the card name in column B and run the query once per card, changing only the name in quotation marks. Then add a small summary at the top with each card's total and a grand total. Because every row keeps its own card name, you can later answer what the second card paid for without going back to the statements. If two cards were used by different volunteers, add the cardholder's first name as a column for the committee's reference.
If the committee asks for more
- By category: add a category column and group with a pivot table or a second query using group by.
- By person: add a column for who made the purchase, if the club's rules allow multiple cardholders.
- Receipts: file a photo or scan per row, named with the date and amount.
For anything involving the club's financial statements or official filings, follow your organisation's rules and ask someone qualified.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


