How are the balance and overdue amount calculated?

Balance = amount incl. VAT minus the payments from the “Payments” sheet; overdue is the balance on a contract whose term has already expired.

How do I enter a contract with no end date?

In the “End date” column, type the word “open-ended”.

In the register choose “incl. VAT”, “VAT on top” or “no VAT”; the rate comes from the settings or from a separate column.

No, only ordinary Excel 2007 formulas.

← All templates

Contract Register with Term and Payment Tracking — Excel Template

Contract register: expiry dates, VAT, payments, balance and overdue amounts, traffic-light status, a list of expiring contracts and a summary with a chart.

490 ₽

≈ 5 USD

Blank template + filled-in example · Excel 2007+, LibreOffice, Google Sheets

Payment is processed securely by YooKassa in Russian rubles. If your card is declined, email us at info@хижняков.рф and we will arrange another way to pay.

What it is for

Keep all your contracts in one table and see in time which ones are about to end, which have no payments, and where payment exceeded the contract amount. Excel calculates paid, balance and overdue amounts from the payments automatically.

What is inside

“Settings”: VAT rate, VAT mode, number of days before a warning, and lists of contract types, counterparties and responsible persons.
“Register”: up to 300 contracts; term (a date or “open-ended”), amount, VAT “incl.” or “on top”, renewal, responsible person, paid, balance, overdue, warnings and a traffic light.
“Payments”: up to 1,500 payments linked by contract number.
“Expiring”: a list of contracts nearing their end, sorted by urgency without macros.
“Summary”: by type and counterparty, top 10 by balance, and a chart of expiries by month.

Who it is for

Lawyers, procurement specialists, accountants, managers of small organizations and self-employed people.

Compatibility

Excel 2007 and later, LibreOffice. No macros or external links. The VAT rate is an editable setting: check the current value. The file is in English.

Questions and answers

How are the balance and overdue amount calculated?: Balance = amount incl. VAT minus the payments from the “Payments” sheet; overdue is the balance on a contract whose term has already expired.
How do I enter a contract with no end date?: In the “End date” column, type the word “open-ended”.
How is VAT handled?: In the register choose “incl. VAT”, “VAT on top” or “no VAT”; the rate comes from the settings or from a separate column.
Do I need macros?: No, only ordinary Excel 2007 formulas.