Business Loan & Finance Agreement Tracker Spreadsheet
This spreadsheet works out what each of your loans, overdrafts and finance agreements actually costs you, rather than the rate printed on the paperwork.
An arrangement fee taken off before the money arrives, a flat rate quoted on a sum you only ever half have, a balloon at the end that keeps the balance high the whole way through, or a factor with no rate on it anywhere — all of it is legal, all of it is quoted in good faith, and none of it appears in your accounts. You type in what actually reached your account, what leaves it each period and how many times, and the file works out the rate you are really paying.
What is in it
- Agreements — 40 rows, with thirteen things typed per agreement.
- Payments — 700 rows, one per payment that left the bank.
- By Lender — how much of you any one lender is holding.
- By Type — the same money, borrowed nine different ways.
- What You Have Pledged — everything behind the borrowing added up, with any asset carrying more than one agreement flagged.
- Start Here, Setup and an Overview that puts the whole position on one screen.
Who it is for
Any business carrying borrowing it did not take out all at once: term loans, overdrafts, hire purchase, asset finance, invoice finance, supplier credit, cards and directors’ loans. It is built for the way businesses actually borrow — several lenders, several agreements, security spread across whatever was available at the time, and personal guarantees signed on different afternoons. If you cannot find the rate on some of them, leave that column blank; the effective rate does not come from it.
The worked example
The worked position inside the file has 11 agreements, $800,500 borrowed and $1,052,814 to be repaid — a cost of credit of $252,314. The weighted rate on the paperwork is 7.7%. What is actually being paid is 18.4%: a gap of 10.7 points, or $315 for every $1,000 borrowed.
The dearest line has no rate printed on it anywhere, because it is a factor rather than a rate — $60,000 borrowed on a Monday and $76,800 repaid over thirty-nine weeks, which works out at 95.2% a year. The same file totals what has been signed for personally: $214,000, or 40.7% of everything still owed, across five of the eleven agreements.
How it works
Compatible with Microsoft Excel 2016 or newer on Windows or Mac, Google Sheets, and LibreOffice. No macros, no add-ons, no account to create, nothing to install.
The download has two workbooks: one with the example above already filled in, so you can see what every column expects, and the same file completely blank for your own figures. A plain-English guide comes as a PDF. Order on WhatsApp — $9
Orders are taken on WhatsApp: message me and I’ll send the payment details, then the files as soon as the payment is confirmed.
A look inside the file
Questions people actually ask
How do I work out the real cost of a loan when no rate is printed on it?
From four numbers you already have: what actually reached your account, what leaves it each period, how many times, and anything owing at the end — the file works the effective annual rate out from those, so you never need the quoted rate. In the worked position eleven agreements carry a weighted paper rate of 7.7% while what is actually being paid is 18.4%, a gap of 10.7 points and $315 of credit cost per $1,000 borrowed. One agreement shows 0% on the paperwork and 95.2% in real money: $60,000 borrowed on a Monday, $76,800 repaid over thirty-nine weeks, because it is a factor and not a rate.
Is this for personal debt or for a business?
It works for any borrowing, but it is built for a business: lenders, security, personal guarantees, balloons, invoice finance, supplier credit, hire purchase, overdrafts, cards and directors' loans. It holds 40 agreements and 700 payment rows across eight linked tabs. It also totals what you have signed for in your own name — $214,000 in the worked position, 40.7% of everything still owed, across five of the eleven agreements.
I do not know the rate on some of them, and one is a variable rate — what do I do?
Leave the rate blank; the effective rate comes from what you borrowed, what you pay and how many times, and the rate column exists only so the file can show you the gap. For a variable rate, put the terms in as they stand today, and when the rate changes, change the payment — the file re-prices that agreement from that day forward. Everything you type comes off the agreement itself and your own bank statements, so nothing has to be requested from a lender.
Does it work in Google Sheets or do I need Excel?
Both — it is built as .xlsx for Excel 2016 or newer on Windows or Mac, and it loads into Google Sheets through File then Import then Upload. LibreOffice opens it too. No macros, no add-ons, no account to create, nothing to install and no subscription: you download the file and it is yours.
Will it tell me whether to refinance or settle early?
No, and it does not try to — it is not financial, tax or legal advice, and nothing in it is a recommendation to borrow, refinance or settle. It gives you the two numbers that conversation should start from: what each agreement really costs, and what clearing it early would cost. In the worked position early settlement penalties total $13,733, but $4,618 of that sits on one agreement and four others carry no penalty at all. It is not connected to any bank or lender — nothing syncs, nothing logs in, and I never ask for a password or a lender portal.
Need it built around your business?
This file assumes borrowing drawn in one currency and repaid in regular instalments — loans, overdrafts, hire purchase, invoice finance, cards and directors’ loans. If yours works differently — a revolving facility that is redrawn every month so there is no fixed term, borrowing taken in a second currency where the repayment moves with the rate, or a merchant cash advance repaid as a percentage of daily card takings — I can build the same effective-rate arithmetic around the way your agreements actually run.
All other templates are listed on the Excel & Google Sheets Templates page.