How to use the Excel templates
- Pick a template: budget, invoice register, timesheet, inventory, attendance, sales or loan schedule.
- Set the language, currency, month and year, plus an optional title and company name.
- Click Create and open the .xlsx file in Excel, LibreOffice or Google Sheets.
Building a reliable spreadsheet takes time: formulas, formatting, drop-down lists. These templates are ready to use. You type your figures in the yellow cells and the rest is calculated: totals, differences, VAT, overdue days, monthly payments.
Seven templates are available. The monthly budget compares planned and actual amounts from a transactions sheet. The invoice register tracks net amount, VAT, gross total, client tax ID, payment status and days overdue. The timesheet works out weekly hours and overtime. The inventory follows stock in, stock out and reorder levels. The attendance sheet shows the month as a grid with codes (present, absent, late, leave, sick, public holiday). The sales tracker adds monthly totals, and the loan schedule calculates the monthly payment and a full amortization table.
Currencies include the US dollar, Canadian dollar, euro and pound. For a mortgage or car loan, enter the amount, annual rate and term in months; the whole table recalculates if you change a value in Excel.
There is nothing to upload: the template is built on demand and deleted from the server after 30 minutes.
Frequently asked questions
Are these Excel templates free?
Yes, every template is free, with no sign-up, and you can create them as often as you like.
Do the formulas work in Google Sheets?
Yes. The file is a standard .xlsx that opens with its formulas in Excel, LibreOffice Calc and Google Sheets.
Can I track VAT with the invoice register?
Yes: pick the rate on each line and the template works out the VAT and total, with paid/unpaid status and days overdue.
How does the loan schedule work?
Enter the amount borrowed, the annual rate and the term: the monthly payment, total cost, interest and month-by-month table are calculated.
Can I get the template in French?
Yes, choose Français under Language: titles, columns and instructions are in French.
Can I change the template?
Yes, it's your file: add rows, categories or columns as in any Excel workbook.