Small Business & Invoicing
Free Excel templates for invoices, quotes, cash flow, payroll, VAT, stock and pricing for small businesses. Each file has a logo header, a How to use sheet, and formulas that calculate for you.
Invoicing and sales
-
Invoice Generator
Create an invoice with line items, VAT and the balance still due.
Downloads: loading…
Download .xlsx -
Quote and Estimate Template
Price a job with line items, a discount and VAT, with a validity date.
Downloads: loading…
Download .xlsx -
Accounts Receivable Aging Report
See which client invoices are unpaid and how long they are overdue.
Downloads: loading…
Download .xlsx -
Sales Pipeline Tracker
Track deals by stage, with weighted values for your open pipeline.
Downloads: loading…
Download .xlsx -
Client Contact List
Keep client details and see who needs a follow-up call.
Downloads: loading…
Download .xlsx -
Refunds and Returns Log
Log refunds and returns with reasons, status and totals.
Downloads: loading…
Download .xlsx
Money in and out
-
Purchase Order Log
Track purchase orders from approval to delivery and see open order values.
Downloads: loading…
Download .xlsx -
Accounts Payable Tracker
Track supplier bills, what is paid, and what is due soon or overdue.
Downloads: loading…
Download .xlsx -
Petty Cash Register
Track petty cash in and out with a running balance and a cash count check.
Downloads: loading…
Download .xlsx -
Expense Claim Form
Itemise expenses and flag any line that is missing a receipt.
Downloads: loading…
Download .xlsx -
Mileage Log
Log business journeys and calculate mileage claims at your rate.
Downloads: loading…
Download .xlsx -
VAT and Sales Tax Calculator
Calculate VAT and gross totals for each item at its own rate.
Downloads: loading…
Download .xlsx
Reporting and planning
-
Profit and Loss Statement
Enter income and costs to see gross, operating and net profit.
Downloads: loading…
Download .xlsx -
Cash Flow Forecast
Forecast monthly cash in and out, and find the lowest cash point.
Downloads: loading…
Download .xlsx -
Break-even Analysis
Find the sales volume that covers your costs and the profit at planned sales.
Downloads: loading…
Download .xlsx -
Business Plan Financial Projections
Project three years of revenue, costs and profit from your assumptions.
Downloads: loading…
Download .xlsx -
Asset Depreciation Schedule
Calculate straight-line depreciation by year for each asset.
Downloads: loading…
Download .xlsx -
Product Pricing and Margin Calculator
Set selling prices from markups and see margins and target prices.
Downloads: loading…
Download .xlsx
Stock, staff and suppliers
-
Inventory Stock Count Sheet
Compare system stock with physical counts and value the differences.
Downloads: loading…
Download .xlsx -
Reorder Level Calculator
Work out when to reorder each item from sales rate, lead time and safety stock.
Downloads: loading…
Download .xlsx -
Stock Valuation (FIFO and LIFO)
Value cost of sales and remaining stock with FIFO and LIFO side by side.
Downloads: loading…
Download .xlsx -
Payroll Calculator
Work out tax, contributions and net pay, using example rates you can replace.
Downloads: loading…
Download .xlsx -
Timesheet with Overtime
Record weekly hours and calculate regular hours, overtime and gross pay.
Downloads: loading…
Download .xlsx -
Shift Rota
Plan shifts for each person and see hours and cover per shift.
Downloads: loading…
Download .xlsx -
Supplier Comparison
Compare supplier prices for each item and see the cheapest overall.
Downloads: loading…
Download .xlsx