Spreadsheet Templates That Actually Calculate
Download ready-made Excel workbooks with the formulas already built in. They open in Excel, Google Sheets, Numbers, and LibreOffice.
Files are generated in your browser. No signup, no email required.
Inventory Manager · Small shops, makers, online sellers
Track stock on hand, see stock value, and flag items that need reordering.
- Stock value per item and in total
- Automatic Reorder / OK status
- Summary of units, value, and items to reorder
Product Profit Calculator · Marketplace and D2C sellers
Real profit and margin per product after tax, commission, payment fees, shipping, and ads.
- Removes GST/VAT included in the price
- Commission, fixed fee, and payment fees
- Profit and net margin per product
Freelancer Income Tracker · Freelancers and consultants
Log work, see earnings by client and month, and track what is still unpaid.
- Hours × rate per entry
- Totals and unpaid amounts by client
- Monthly earnings for 12 months
12-Month Cash Flow Planner · Small businesses and founders
Plan money in and out for a year and see when the bank balance runs low.
- Opening and closing balance carried month to month
- Income and expense categories
- Yearly totals
Personal Budget Planner · Individuals and households
Set a monthly budget, record actual spending, and see your savings rate.
- Budget vs actual for income and expenses
- Over / on-track status per category
- Savings and savings rate
Employee Attendance Tracker · Small teams, shops, clinics
Mark daily attendance with simple codes and get monthly totals per person.
- P / A / L / H codes for 31 days
- Present, absent, leave, and half-day counts
- Attendance % per employee
Project Profitability Tracker · Agencies, studios, consultants
See which projects and clients actually make money once hours are counted.
- Labor cost from hours × cost rate
- Profit, margin, and effective hourly rate
- Hours over or under estimate
Stock Reorder Planner · Retailers and e-commerce
Calculate reorder points and order quantities from sales speed and supplier lead time.
- Reorder point = daily sales × lead time + safety stock
- Counts stock already on order
- Suggested order quantity for your target cover
Business Template Bundle $12
All 8 templates above with room for 1,000 rows (the free versions have 200), plus 3 bundle-only templates:
- Invoice & GST Tracker: Track every invoice, GST charged, what is paid, and what is overdue, with monthly totals.
- Sales Pipeline & Forecast: Track deals by stage, see weighted pipeline value, and get a forecast and win rate.
- Expense & Subscription Tracker: Log expenses by category, spot recurring subscriptions, and see their true monthly and yearly cost.
How it works
- Pick a template and click Download .xlsx.
- Open it in Excel, or upload it to Google Drive and open with Google Sheets.
- Replace the sample rows in the yellow input cells with your own data.
- Totals, statuses, and summaries recalculate automatically. Each file includes a How to use sheet.
Templates built around the calculation, not just the layout
Many free templates are formatted tables with empty cells. These are working tools: the inventory manager flags what to reorder, the cash flow planner carries each month's closing balance forward and finds your lowest point, and the freelancer tracker totals unpaid invoices by client.
Every template uses standard functions such as SUMIFS, COUNTIF,
EDATE, and IF, so it works in any modern spreadsheet app and you can
read and adjust every formula. Input cells are highlighted in yellow; everything else calculates.
Who they are for
- Online sellers and shops: inventory, product profit, and stock reorder planning
- Freelancers, consultants, and agencies: income tracking and project profitability
- Small businesses: 12-month cash flow and staff attendance
- Individuals and households: monthly budget and savings rate
Use them in Google Sheets
Upload the downloaded file to Google Drive, then choose Open with Google Sheets. Formulas, formatting, and frozen headers carry over. To keep a reusable master, make a copy each month.
Related tools: Seller Profit Calculator · Excel Formula Builder · CSV & Excel Compare · JSON Compare · PDF Compare
FAQ
Does my data get uploaded or stored?
No. Processing runs entirely in your browser. Structura does not upload your files for processing and does not keep file contents on a server. Closing the tab clears the in-memory copy.
Is processing private / local-only?
Yes for the tool’s job. Your files stay on the device. Optional Cloudflare Web Analytics may record page views and anonymous events such as tool runs and downloads, never file contents or file names.
Are the templates really free?
Yes. Download and use them for personal or business use without signup.
Do they work in Google Sheets?
Yes. Upload the .xlsx to Google Drive and open it with Google Sheets. All formulas use functions that Sheets supports.
Can I change the formulas or add columns?
Yes. Nothing is locked. Formulas are fill-down friendly, and each template has a How to use sheet explaining what each column does.
Why is there sample data?
Sample rows show how the template works. Overwrite them with your own data or delete them; formulas on blank rows stay empty until you add data.
Do I need an account?
No. All Structura tools are free to use without signup.
Need a data tool we don’t have yet?
Tell us what you are trying to convert, clean, compare, or validate. We prioritize tools based on real requests. Want a template we do not have, such as invoicing, GST summaries, payroll, or a sales pipeline?
Request a tool →