# Installment Payment Tracker Excel (Free Template)

> A free Excel installment tracker for shops that sell on payment plans: balance, past due, days late and a daily follow-up list for every customer.

Source: https://softwiro.com/templates/installment-tracker
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Installment Payment Tracker for Excel

A free Excel tracker for any business that lets customers pay in installments: furniture and appliance shops, phone and electronics stores, tutors, gyms, dealers and anyone selling on a payment plan. You enter each customer's plan once (price, down payment, number of monthly installments, first due date) and log every payment as it arrives. The sheet works out the installment amount, what has been paid, the balance, how much is past due, how many days late the oldest unpaid installment is, and a status. Each morning the Follow-up sheet lists who to call first. It opens in Excel, LibreOffice and Google Sheets and works in any currency.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-installment-tracker.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-installment-tracker-blank.xlsx)

Excel file (.xlsx) · 146 KB · 7 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

## Try the sheet here, on the example

The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.

## Example from the sheet

| As of | 46342 | Change the date, currency and report year on the Settings sheet. |  |
| --- | --- | --- | --- |
|  |  |  |  |
| Accounts | 10 |  |  |
| Total financed | 12,340.00 |  |  |
| Down payments received | 2,760.00 |  |  |
| Collected on installments | 4,790.00 |  |  |
| Outstanding balance | 7,550.00 |  |  |
| Past due amount | 1,810.00 |  |  |
| Late or due today (accounts) | 5 |  |  |
| Collected vs due to date | 72.6% |  |  |
| Status | Accounts | Past due | Balance |
| Current | 4 | 0.00 | 3,940.00 |
| Due today | 1 | 200.00 | 1,200.00 |
| Late | 4 | 1,610.00 | 2,410.00 |
| Paid off | 1 | 0.00 | 0.00 |

Example from the “Summary” tab, with the numbers and formulas that are in the file.

## What is inside

- Summary: Accounts, total financed, down payments, collected on installments, outstanding balance, past due amount, how many accounts are late or due today and how much of the amount due to date has been collected. Three charts: installments collected by month, accounts by status and past due amount by days late.
- Follow-up: The accounts that are late or due today, longest overdue first, with phone number, past due amount, days late, oldest unpaid due date, balance, collection status and your note. It fills itself; the first 50 are shown.
- Accounts: One row per customer plan. You type the price, down payment, number of installments and first due date; it calculates the amount financed, the installment, paid so far, balance, installments due, amount due to date, past due, oldest unpaid due date, days late and status. Room for 200 accounts.
- Payments: The log of every installment received: date, account ID from a dropdown, amount, method and receipt number. It shows the customer's name and flags an unknown account ID or a missing amount. Room for 2,000 payments.
- Settings: Business name, currency symbol, the "as of" date the sheet judges against, the report year and the list of collection statuses.

The file opens on a start tab (“Start here”) that explains how to use it.

## What makes it different

Most free installment templates give you a payment schedule to fill in by hand and a column where you tick Paid. This one keeps the schedule in formulas: you log what customers actually pay, and the sheet applies it to the oldest installment first, so a customer who paid part of an installment shows the rest as past due from the original date. The sample is a small appliance shop on 16 November 2026 with ten accounts, so you can see current, due today, late and paid-off accounts before you replace it with your own.

## How do I track installment payments in Excel?

Use two tables. The first has one row per customer plan: price, down payment, number of installments and the first due date. The second is a log with one row per payment, each carrying the account ID. The balance is then the amount financed minus the sum of that account's payments, and you never overwrite a paid amount; you add a row.

In this template the installment is (price - down payment) divided by the number of installments. In the sample, Priya Shah bought a washing machine for 1,200 with 300 down, financed 900 over 6 installments of 150, and has paid 450. The sheet shows a balance of 450.

## How do I see which customers are late?

The sheet compares what should have been paid by the "as of" date with what was paid. In the sample, with the date set to 2026-11-16, four accounts are late and one is due today. Sam Whitfield is the longest overdue: his oldest unpaid installment was due on 2026-05-08, so he is 192 days late with 700 past due. Priya Shah is 67 days late with 450 past due.

Past due means the installments whose due date has arrived but have not been fully paid. An account whose next installment is still in the future is Current, even if its balance is large. Type an earlier date in Settings to see how the same accounts looked on that day.

## What should I do with an installment plan that is partly paid?

Log the part payment as it arrives. The sheet applies payments to the oldest installment first, so Omar Haddad, who paid 390 of 600 financed against installments of 150, shows the third installment (due 2026-10-12) as the oldest unpaid one, 35 days late, with 210 past due.

Then record what you did. Pick a collection status for the account (Not contacted, Contacted, Promised to pay, Asked for extension, Not answering) and write a short note. Both appear on the Follow-up sheet, so the person calling sees the history. Whether you may charge a late fee or interest depends on your contract and local rules, so check them before adding one; this sheet does not add any.

## How to use it

1. On the Settings sheet type your business name, currency symbol and the "as of" date, the day you want the sheet to judge. Change it each morning (or type =TODAY() there).
2. On the Accounts sheet add one row per customer plan: account ID, customer, phone, item, price, down payment, number of monthly installments and the date of the first one.
3. On the Payments sheet log every payment a customer makes after the down payment: date, account ID (pick it from the list), amount, method and receipt number.
4. The Accounts sheet works out the financed amount, the installment amount, the total paid, the balance, the past-due amount, the oldest unpaid due date, the days late and a status.
5. After you contact a late customer, pick a collection status on the Accounts sheet and write a short note.
6. Open Follow-up each morning: it lists everyone who is late or due today, longest overdue first, with phone number and note. Summary shows totals and charts.

**Before you start:**

- Capacity: 200 accounts, 2,000 payments, and the Follow-up list shows the 50 longest-overdue accounts.
- Installment = (price - down payment) / number of installments, rounded to 2 decimals. The last installment is not adjusted; the balance always comes out exact.
- Installments fall due monthly on the same day as the first one. A first due date after the 28th uses the 28th, so every month has that day.
- Payments are applied to the oldest installment first. A partial payment leaves the rest of that installment past due from its original date.
- The down payment is recorded on the account, not on the Payments sheet.
- The status is judged on the "as of" date. Type an earlier date to see the position on that day.
- Use one currency in one workbook. The currency symbol on Settings is only a label.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-installment-tracker.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-installment-tracker-blank.xlsx)

Excel file (.xlsx) · 146 KB · 7 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

## Still running this on Excel?

This sheet needs someone to copy every invoice and payment into it. In Accountwiro an invoice and a payment are recorded the moment they happen, and the customer's balance shows in a single statement of account.

| In this sheet | In Accountwiro |
| --- | --- |
| You copy every invoice and payment into the sheet by hand. | It shows the customer's invoices, payments and outstanding balance in a single statement of account. |
| Invoices are typed or copied by hand. | It creates an invoice by scanning a barcode or searching by product name, calculates discounts and taxes, and sends it to the customer over WhatsApp. |
| Stock shortages are discovered late. | It updates quantities after every sale and alerts you when a product drops below the required level. |
| Anyone who opens the sheet sees every number. | Permissions per user: the sales employee issues invoices, and the warehouse employee manages stock without access to financial data. |

[See Accountwiro](https://softwiro.com/product/budoor) · [Ask for a demo](https://softwiro.com/contact)

## When your work grows: a custom system instead of the sheet

A sheet is a great start. When more than one person works on your data, when it grows, or when you need alerts and reports of your own, we build you a custom system at competitive prices. This is what changes:

| In the sheet | In a custom system |
| --- | --- |
| Monthly installments only | Weekly, fortnightly or custom schedules, each with its own due dates |
| You call late customers from the list | Reminders go out automatically and the replies are logged |
| Payments typed by hand | Payments arrive from the card terminal, bank transfer or a customer portal |
| One file for one shop | Several branches with a combined view for the owner |
| Charts in the workbook | A live dashboard of collections and arrears on your phone |

### Extra features in the app

- Automatic reminders by SMS or WhatsApp a few days before each installment and again when one is late
- A customer can pay online or show a receipt from their phone, and the payment is applied to the right account
- Receipts and a statement of account printed or sent to the customer at any time
- Several staff members recording payments, each with their own permissions
- Interest, late fees and grace periods calculated from your contract terms
- Installment sales linked to stock and invoices, so the sale, the plan and the payments live in one place

[Ask for your custom system](https://softwiro.com/contact)

## Frequently asked questions

### Is this installment tracker really free?

Yes. Download it, use it in your business and change anything you like. You do not need to sign up to open the file.

### Does it work in Google Sheets and LibreOffice?

Yes. It uses ordinary formulas such as SUMIFS, COUNTIFS, INDEX and MATCH, so it works in Excel 2016 and later, LibreOffice and Google Sheets.

### How many customers and payments can it hold?

200 accounts and 2,000 payments, and the Follow-up sheet shows the 50 longest-overdue accounts. When the file is full, save a copy and start a new one with the open balances.

### Can it handle weekly or irregular installments?

No. Installments are monthly, due on the same day of the month as the first one. A first due date after the 28th uses the 28th so every month has that day. For irregular plans you can still log whatever the customer pays, but the due dates and the late status follow the monthly rule.

### Does it charge interest or late fees?

No. The installment is the amount financed divided by the number of installments. If your contract includes interest or fees, add them to the price or ask for a version that calculates them, and check your local rules first.

### Is the template free?

Yes, with no sign-up and no email address. Use it, edit it and share it as you like.

### Does it work in Google Sheets and on mobile?

The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.

### What is the difference between the white and the gray cells?

You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.

### Can I use the sheet from an AI assistant?

Yes. Add our MCP server (URL [https://softwiro.com/api/mcp](https://softwiro.com/api/mcp), no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: [https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html](https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html)

All the templates in this group: [Free Excel templates for cars: showroom, rental, workshop and maintenance](https://softwiro.com/templates/for-cars)

More free templates for: Shops and stores

## More free templates

- Cash Book Template for Excel
- Invoice Template with Invoice Log (Excel)
- Inventory Tracking Spreadsheet for Excel
- Customer Statement Template with Aging (Excel)
- Clothing Store Inventory Spreadsheet (Size and Color) for Excel
- Multi-Location Inventory Spreadsheet for Excel
- Social Media Content Calendar Template for Excel
- Class Schedule Maker for Excel
- GPA Calculator for Excel (Weighted and Unweighted, by Term)
- Lesson Plan Template for Excel with Curriculum Tracker
- Donation Tracker Spreadsheet for Nonprofits (Excel)
- Expiry Date Tracker for Excel (Inventory)
- HOA Dues Tracking Spreadsheet for Excel
- HOA Budget Template for Excel

[All templates](https://softwiro.com/templates) · [Free tools](https://softwiro.com/tools)
