To report on a single credit card for a set period, export that card's transactions as a CSV file, filter to your two dates, and total the amount column. The only trap is the dates: the first and last day must be included, and refunds must be netted off. Here is the whole process using a business trip as the example.
Why would I need a report for just one card?
Say you put a three-week work trip, March 3 to March 24, on your personal card and your employer wants the costs listed. Your card also paid for groceries and streaming that month, and none of that belongs in the report. You need one account, one window and nothing else.
How do I pull out only those dates?
- Download the card's transactions for the statement periods covering March as a CSV file, using whatever export option your card issuer offers. Check your own account pages for where it is; we cannot describe a particular issuer's menus.
- Open the file in Excel or Google Sheets and make sure the date column is real dates, not text. Click a date cell and see whether it right-aligns by default; if it left-aligns, it is probably text.
- Type the start date in one cell, say H1, and the end date in H2.
- Use a filter or a formula to show only rows between them.
- Total the amount column, and subtract any refunds that fall in the window.
Which formula gives the total?
With dates in column A, descriptions in B and amounts in C (charges positive, refunds negative), this formula totals the window: =SUMIFS($C$2:$C$500, $A$2:$A$500, ">="&$H$1, $A$2:$A$500, "<="&$H$2).
To list the rows themselves in Excel 365, 2021 or Google Sheets, use =FILTER($A$2:$C$500, ($A$2:$A$500>=$H$1)*($A$2:$A$500<=$H$2), "No matches"). Older versions of Excel do not have FILTER; use the filter button on the header row instead and choose a date range.
What does the result look like?
| Date | Description | Amount |
|---|---|---|
| Mar 3 | Airline ticket | $412.60 |
| Mar 5 | Hotel, 8 nights | $960.00 |
| Mar 9 | Taxi to client office | $38.40 |
| Mar 14 | Client dinner | $146.25 |
| Mar 18 | Hotel refund, one night | -$120.00 |
The total is 412.60 + 960.00 + 38.40 + 146.25 - 120.00 = $1,437.25. These are invented numbers; the point is that the refund row reduces the total rather than being left out.
What if the trip spans two statements?
Download both periods and paste them into one sheet before filtering. A trip from late February into early March straddles two statement cycles, and a report built from only one of them will quietly miss half the costs. After combining, sort by date and check that no row appears twice at the join between the two files.
Can an app do this without a spreadsheet?
If you keep your transactions in SpendixAI, its reports can be filtered by account and by date, so a one-card, one-period report is a filter rather than a formula. It reads bank and card statements uploaded as PDF, CSV or Excel, and you review rows before saving. It is built around India and INR, so we are not suggesting it suits a US card; I mention it as an example of what account-and-date filtering looks like.
Before you send the report
- Confirm the total against the statement lines for those dates, not just the sheet.
- Remove personal items that slipped into the window, such as a pharmacy stop on the way to the airport.
- Attach receipts for anything over the limit your employer has told you about.
- Keep the original CSV unaltered in a separate file in case someone asks how you got the figures.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

