Reconcile a card billing cycle
See this course’s project requirements
A reconciled fictional card statement with daily-interest estimate, grace-period decision, payment allocation and a deadline plan.
Keep your working files in your own notebook or software. Save a private description, checklist, and work link in My Proof.
What to include
- A reconciled credit-card transaction register and statement check.
- A billing-cycle timeline with current balance, statement balance and applicable payment action.
- A balance-days interest worksheet with rate units and calculation limits.
- A payment-allocation ledger with category balances and a total-debt check.
- A promotional repayment calendar with a full-payoff check and offer-type comparison.
- A next-statement audit with credited payments, new charges and an exception note.
Review and revise
Use these criteria to check your work and choose what to improve.
- All supplied records reconcile and the decision uses the named case rules.
- Calculations show units, intermediate values and a second check.
- Changed-input practice revises the affected result and identifies uncertainty.
- The final project combines six lesson records, separates fictional assumptions from current rules, and states a supported next step.
Want more background?
The idea in everyday life
This is an original fictional practice case. No account, payment, personal record or outside participation is required. Opening balance $200; purchases $120; fee $5; payment $100; refund $20; interest $0.
A card balance is a debt roll-forward: opening balance plus charges and fees, less payments and credits.
Reconcile a card billing cycle — worked practice
A card balance is a debt roll-forward: opening balance plus charges and fees, less payments and credits.
Use paper or a local table; label all amounts as fictional USD unless the case names another unit. Opening balance $200; purchases $120; fee $5; payment $100; refund $20; interest $0.
Card activity
Paste at A1.
| AID | BType | CUSD | DBalance direction |
|---|---|---|---|
| OPEN | Prior debt | 200 | Opening |
| P1 | Purchase | 120 | Add |
| F1 | Fee | 5 | Add |
| PM1 | Payment | 100 | Subtract |
| RF1 | Refund | 20 | Subtract |
| INT1 | Interest | 0 | Add |
Copy as plain text
1. Step 1: Classify additions and reductions
Create ID, type, addition, reduction and running-debt columns. Enter OPEN $200; put P1/F1/INT1 in additions and PM1/RF1 in reductions using the supplied activity table.
You should see: Add $120 and $5; subtract $100 and $20.
A card balance is a debt roll-forward: opening balance plus charges and fees, less payments and credits.
2. Step 2: Compute the closing statement balance
Compute the closing statement balance.
You should see: 200+120+5−100−20=$205.
Keep this intermediate result so the final decision can be checked.
3. Step 3: Match each row to its supplied evidence
Tick P1, F1, PM1, RF1 and INT1 once each against the supplied card activity table. If a row is missing, preserve it in an exception log instead of overwriting the total.
You should see: Five changes are represented once each.
Keep this intermediate result so the final decision can be checked.
4. Step 4: Prepare a statement check
Prepare a statement check.
You should see: Closing debt $205; refund is not additional income for this card roll-forward.
Keep this intermediate result so the final decision can be checked.
What to finish
A reconciled credit-card transaction register and statement check.
Watch for this
Adding a refund to debt rather than subtracting the credit.
How can I tell I understand it?
Reconcile a credit-card balance from dated charges, fees, credits and payments on a new supplied case, with a visible intermediate check and no unsupported real-world promise.
Quick knowledge check
Answer all 3 questions. Get at least 2 right and the lesson completes automatically.
You’ll get an explanation for each answer. Signed in? Your results save to your account.
Pass the check. We’ll save the progress.
Answer all 3 questions above and get at least 2 right. You can review the explanations and try again.
Go to the knowledge checkTools, templates, and lesson sources
Tools and templates
Tools open in a new tab so you can keep your place here.
Sources and further reading
Explore the references behind this lesson.
Source & access notes · checked 2026-10-01
Official page opened/read during Money expansion authoring; checked the relevant concept and access state. These sources do not establish funding eligibility.
Access: Readable official webpage inspected with the web reader on 2026-10-01. No interactive-tool operation is claimed.
Reuse: Original fictional practice, questions and calculations; paraphrased concepts with a source link. No source exercise copied.
Report a problem with this lesson
Tell us what went wrong. Please leave out personal information and private project contents.