Merchant purchase
Add a posted purchase once under the category that best matches the evidence. Preserve the original merchant description outside this worksheet.
Monthly Credit Card Expense Calculator from Statement Activity
Enter the posted activity from one issued card cycle. The worksheet keeps purchases and advances apart from interest and fees, subtracts qualifying credits, and excludes card payments from expense.
Purchases and advancesplusInterest and feeslessRefunds and creditsequalsNet card expense
Preparing your private analysis
Your statement is being secured before analysis begins.
Leave this window open; your private results will load here when ready.
Use one closed billing cycle
Start with the issued statement, not a live account screen. The cycle summary fixes the posting window and keeps pending authorizations from being mixed with settled transactions.
Before entering totals, check whether the statement already nets refunds into a purchase subtotal. Enter every amount once. A posting-date review can resolve purchases near the closing date.
Decide where a row belongs before adding it
The label on the statement determines whether a row increases expense, reduces it, or belongs only in balance reconciliation.
Payment received
Do not treat a payment as negative spending. It reduces the amount owed but does not reverse the purchase that created the balance.
Refund or reversal
Subtract a credit only when it reverses activity included in this cycle. Keep fee reversals and reward credits separately identified.
Statement-cycle expense example
A cycle with $1,240 in purchases, a $100 cash advance, $22 interest, a $10 fee, and a $75 refund produces $1,297 of net statement expense.
A $500 payment made during the cycle does not change that expense figure. It changes the balance bridge. Keeping the $500 outside the expense calculation avoids treating debt repayment as if the original purchase disappeared.
How statement activity becomes a card-expense total
The worksheet keeps new spending, cash access, card costs, and reductions in separate lines. That distinction prevents a payment from being counted as negative spending and makes the result traceable to the statement summary.
- Gross card activity
- Purchases and cash advances are added before refunds. They remain separate because a cash advance can have a different fee and APR even though both increase the balance.
- Card costs
- Interest and issuer fees are shown apart from merchant spending. This answers how much the card itself added during the cycle without disguising those costs inside a shopping category.
- Net statement expense
- Verified refunds and statement credits reduce gross activity. Payments do not reduce expense because they settle an amount owed rather than reverse the purchase that created it.
Rows that should not be forced into the total
A clean result depends on transaction state and meaning. Leave an amount unresolved when the statement does not show whether it is a refund, payment, fee reversal, or pending authorization.
- Pending purchasesAn authorization can change or disappear before posting. Use issued-statement rows rather than mixing the closed cycle with a live pending list.
- PaymentsRecord payments for balance reconciliation, but do not subtract them from purchases when the question is how much new expense the statement contains.
- Refunds and reversalsSubtract only credits that actually reverse included activity. A reward credit, goodwill adjustment, or fee reversal may deserve a separate label.
Need the transactions behind these totals?
The private analyzer reconstructs statement rows, groups purchases, separates payments and credits, and checks balance movement before you rely on a cycle total.