ValteraTools CFO services
  1. Valtera
  2. Tools
  3. Excel templates
Templates · .xlsx

Free Excel templates for finance and accounting

13 Excel templates plus contracts, acts and an invoice you fill in online. The Excel files have formulas built in and sample figures filled in. Just enter your own numbers in the yellow cells. Each template is available in Azerbaijani, Russian and English.

Updated:

Contracts, acts and invoices

Fill in online: the document is ready at once; download it as Word or print it.

Excel templates

Profit and loss statement (P&L)

Monthly revenue, expenses, EBITDA, net profit and margins.

1 sheets · 12 KB .xlsx ↓Open template →

13-week cash flow forecast

Weekly balance, cash gap warning and a view of the quarter.

1 sheets · 11 KB .xlsx ↓Open template →

Cash flow statement

Monthly cash movement by operating, investing and financing activities.

1 sheets · 11 KB .xlsx ↓Open template →

Balance sheet

Balance sheet at two dates, automatic check and liquidity ratios.

1 sheets · 10 KB .xlsx ↓Open template →

Financial model (3 years)

Linked P&L, balance sheet and cash flow. For banks and investors.

4 sheets · 19 KB .xlsx ↓Open template →

Budget vs actual

Monthly plan, actuals and variances, year to date.

3 sheets · 15 KB .xlsx ↓Open template →

KPI dashboard

Seven indicators and charts from six numbers.

1 sheets · 15 KB .xlsx ↓Open template →

Accounts receivable aging

Overdue by invoice, 0–90+ day buckets and a customer summary.

2 sheets · 36 KB .xlsx ↓Open template →

Cash book

Cash receipt and payment vouchers, running balance and period totals.

1 sheets · 20 KB .xlsx ↓Open template →

Timesheet and payroll

Daily timesheet, deductions at 2026 rates and total cost.

3 sheets · 18 KB .xlsx ↓Open template →

Product costing and pricing

Full cost, target price and which products earn too little.

1 sheets · 14 KB .xlsx ↓Open template →

Reconciliation statement (Excel)

Our and the counterparty's data, difference check.

1 sheets · 9 KB .xlsx ↓Open template →

Barter statement

The net amount is offset, VAT is paid to the deposit account.

1 sheets · 10 KB .xlsx ↓Open template →

How the templates are built

  • Yellow cell, blue number: you fill it in. Black number: a formula, do not change it.
  • The first sheet in each file is a short guide.
  • The figures are examples to show how the template works. Replace them with your own.
  • The files open in Excel, Google Sheets and LibreOffice. No macros.
  • Tax rates in the payroll template follow the 2026 rules.

Which template to start with

If financial management is new to your company, we suggest this order: first use the P&L to see profit month by month, then track cash gaps in advance with the 13-week cash flow forecast, then set up a plan vs actual routine with the budget and KPI dashboard. For a bank loan or an investor you need a financial model.

Frequently asked questions

Are the templates free?

Yes, no registration or email required. Download the file and use it.

Can I open a template in Google Sheets?

Yes. Upload it to Google Drive and open it with Google Sheets. Formulas and conditional formatting work.

Can you adapt a template to my company?

Yes. As part of its outsourced CFO service, Valtera builds the financial model, budget and management reports around your company.

Let us run the numbers

Valtera keeps the books and tax records of small and mid-sized companies and, as an outsourced CFO, takes responsibility for revenue growth and cash flow.