Buy Now Pay Later Tracker Spreadsheet | Installment Plan and Payment Calendar Planner for Excel and Google Sheets | Your True Monthly Cost

Your credit report can't see them. That's why you can't either.

Four instalment plans do not show up on a credit report. They do not show up as a recurring line in a banking app. They do not feel like debt at checkout. What they show up as is a bank balance that is smaller than it should be on the third of the month, and nobody can say why.

This is the inventory that makes them visible. Twenty connected tabs that take every instalment plan, every card minimum and every fixed loan payment and turn them into one number, one calendar and one warning.

WHAT IT ANSWERS

· What do I actually owe every month — plans AND minimums, in one figure
· How much of that would a lender reading my credit report never see
· Which days do three payments land on one paycheck
· How low does my account actually go, and when
· What does an extra fifty dollars a month buy me — interest, or a date

THE THREE THINGS THIS FILE DOES THAT A PAYOFF TRACKER CANNOT

1. THE TRUE MONTHLY OBLIGATION. Every card minimum plus every instalment plus every fixed loan payment, in one number, against your own take-home pay. In the worked sample that is $666.08 a month.

2. PAYMENT-DATE COLLISION. Your own dates on a real ninety-day calendar, with the worst three-day window found for you. In the worked sample $403.78 falls due across three days — four separate payments against one paycheck — and the projected balance bottoms out at $234.22. This is arithmetic the workbook does on dates you type in. It is not a research finding, and the file says so on the tab.

3. THE INVISIBLE SHARE. How much of this month's obligation is not in any credit score today. In the worked sample $449.98 — sixty-seven point six percent, two thirds of everything leaving the account.

WHAT IS INSIDE — ALL TWENTY TABS

1 Start Here — three steps, the settings every other tab reads, and the tab map 2 Dashboard — the obligation, the invisible share, the worst day, the debt-free month 3 BNPL Plans — provider, instalment, how many are left, next date, autopay account, late-fee terms as your own agreement states them, and a bureau flag you set 4 Instalment Calendar — ninety days of dates on a real calendar plus every scheduled payment as a list 5 Credit Cards — balance, limit, utilisation, APR, minimum due, statement and due dates, and the interest accruing this month 6 Loans & Other — auto, personal, medical payment plans, family loans 7 True Monthly Obligation — the tab that names the product 8 Collision Radar — day by day and pay period by pay period 9 Paycheck Map — a year of pay periods: in, out, and what is actually left 10 Payoff Planner — month by month to zero, avalanche or snowball 11 Extra Payment Simulator — what an extra amount buys, and the difference between buying interest savings and buying calendar 12 Interest & Fees Ledger — what each debt costs per month and over its life 13 Statement Reconciler — the provider's number against this file's, so a forgotten plan surfaces 14 Autopay Register — every automatic debit and the account it actually hits 15 Buffer & Overdraft Guard — the lowest the account gets and the days below your cushion 16 Holiday Watch — what December finances, and the January obligation it creates 17 Wins & Milestones — every plan's end date and the monthly amount it gives back 18 Rules & Guardrails — your household's own written rules, with a weekly log 19 Know Your Rights — what is verified, what is not, and the date each was checked 20 Reference & Sources — every fact with its source, URL and check date

THE TAB NOBODY ELSE SHIPS

Tab 19 tells you the truth about what is unsettled, because a lot is.

· Most instalment plans are not reported to the credit bureaus — Federal Reserve Bank of Richmond, Economic Brief 26-05, February 2026
· Buy-now-pay-later does not affect your credit score today. FICO announced BNPL-inclusive scores in June 2025; per FICO's own blog of 12 March 2026 those models still await bureau data at scale
· The consumer bureau's Pay-in-4 interpretive rule was withdrawn on 12 May 2025 and no replacement is coming, so do not assume a Pay-in-4 plan carries credit-card billing rights
· Experian (March 2025) and Affirm (November 2025) publicly contradict each other about whether other lenders can see this history. This file cites both, dated, and does not pick a winner
· What the FTC's advance-fee rule means if anyone offers to fix your debt for money up front (16 CFR 310.4(a)(5))

Every line is dated and sourced. Nothing in this file is a statistic somebody remembered.

WHAT YOU GET

· The 20-tab workbook in four colour themes — Editorial, Colorful, Light and Dark. One engine, identical maths, pick the one you like looking at
· Works in Microsoft Excel and in Google Sheets. Portable formulas only, so both agree on every figure
· A hosted Google Sheets copy link, so you can start in one click
· Quick-Start PDF — ten minutes, once
· Free lifetime updates. Buy once, no subscription, nothing extra to buy inside

HOW IT WORKS

You type four things per plan: the provider, the instalment amount, how many instalments are left, and the next date. Cards want the balance, the limit, the APR and the due date. Everything else on all twenty tabs builds itself out of those. Ten minutes, once.

Input cells are cream with brown text. Calculated cells are white. You can always tell at a glance what you may type in.

NO LOGIN, NO BANK CONNECTION, NO ACCOUNT

This is a spreadsheet. It never asks for a password, never connects to a bank or a provider, and never sends anything anywhere. Nothing you type leaves the file. That is deliberate — the whole problem is that this information lives in four apps you do not control, and the fix is a file you do.

THE FIGURES SHOWN ARE A WORKED SAMPLE, NOT A CUSTOMER

The file ships with an invented household — four plans, three cards, $8,299.79 owed and a $666.08 monthly obligation of which $449.98 is in no credit score today. It is not a customer and not a case study. Delete the sample rows and every figure on every tab redraws itself around yours.

WHAT THIS IS NOT

A record-keeping and arithmetic tool. Not financial, legal or tax advice. Not a credit repair service. Not a substitute for the terms of your own agreements. The collision figures are this workbook's own calculation on your own dates — no study links instalment autopay timing to overdraft events, and the file will not tell you otherwise.

PAIRS WELL WITH

· Debt Payoff Tracker — the deeper snowball-versus-avalanche toolkit, with a debt-free date chart and payment history. If payoff mechanics are the job you are hiring for, buy that one. This file points at it rather than duplicating it. https://www.etsy.com/mx/listing/4522933915/hoja-de-calculo-para-el-metodo-de-la
· Paycheck Budget Spreadsheet — for the money that is left once the obligation is paid. https://www.etsy.com/mx/listing/4524036009/hoja-de-calculo-para-presupuesto-por
· Budget Planner Spreadsheet — the whole month, not just the debt. https://www.etsy.com/mx/listing/4522930455/planificador-de-presupuesto-en-hoja-de

INSTANT DOWNLOAD

Your files are available the moment the payment clears, in your Etsy Downloads and by email. Free lifetime updates: if this file gets better, you get the better version.

Know the number before it knows you.