Skip to main content
Getly

Command menu

Jump to a page or search the catalog

Excel templates 2026: invoice, inventory and tracker checks

Before you buy an Excel template for invoices, inventory or a budget, check the file type, macros, Google Sheets support and locked formulas.

7 min read
1,228 words
Excel templates 2026: invoice, inventory and tracker checks

An Excel template looks finished in a screenshot and fails in the first ten minutes of real use: the currency is wrong, the dates read backwards, a formula breaks the moment you add a row, or the file opens with a yellow security bar you are not sure you should click. Most of that can be checked before you pay. This guide covers the four templates people search for most (invoices, inventory, budgets and dashboards) and the questions that decide whether a file will work for you.

We read the spreadsheet shelves on Getly to see what sellers actually ship, measured October 2026: the Excel Templates, Spreadsheets & Calculators and Budget Planners & Trackers categories together hold 330 active listings. The median paid price is $12.00, and the middle half of the shelf sits between $7.00 and $12.99. One shop holds 34.2% of these listings, so treat the shares below as a picture of a fairly concentrated shelf, not of the whole spreadsheet market.

First check: what file you are actually buying

On this shelf 57.9% of listings deliver an .xlsx file directly and 31.8% deliver a zip archive, usually with several workbooks or an extra PDF guide inside. The files are tiny: the median download is about 0.02 MB. That is normal. A spreadsheet is formulas and formatting, not pictures, so a small file says nothing bad about quality.

The file extension tells you more than the size:

  • .xlsx is a standard workbook without macros. It opens in Excel, in Excel for the web, in Google Sheets, in Apple Numbers and in LibreOffice. This is the safest format to buy.
  • .xlsm is a workbook with macros (small VBA programs). Macros can automate buttons such as "new invoice" or "clear month", but they do not run in Google Sheets, Excel for the web or Numbers, and Excel blocks them by default for files downloaded from the internet.
  • .xltx is an Excel template file. Opening it creates a new copy each time, which is handy for invoices.
  • .zip means you will unzip first. A good listing tells you which files are inside.

Macros: useful, but read the warning

23.0% of listings on the shelf mention macros or VBA. If a template relies on them, you will see a security notice the first time you open it. On Windows, Excel marks files from the internet and may show "Microsoft has blocked macros from running because the source of this file is untrusted". The fix is to right-click the file, open Properties and tick "Unblock", but only do that for files from a seller you trust and only after you know what the macros do.

Three questions to ask before buying a macro template:

  • Does the listing say what each macro does? "Button creates a new numbered invoice" is a good answer; "advanced automation" is not.
  • Does the workbook still work if macros are off? Many good templates use macros only for convenience, and every formula still calculates.
  • Do you need it on a Mac, a phone or in Google Sheets? If yes, a macro template is the wrong choice.

Google Sheets: say it or assume it will not work perfectly

60.6% of listings on the shelf mention Google Sheets. That is useful, because "works in Sheets" is not automatic. Most formulas carry over, but some features do not: VBA macros, some chart styles, form controls such as checkboxes made the Excel way, Power Query and certain newer functions. If the listing promises Google Sheets, it should say whether you get a separate Sheets version (often a "make a copy" link) or whether you upload the .xlsx yourself.

If you upload an .xlsx to Google Drive, open it with Google Sheets and choose File, then Save as Google Sheets. Then test the one formula you care about most, for example the invoice total or the stock count, before you type real data.

Invoices: numbering, tax and currency

Only 11.8% of listings on the shelf mention invoices, so this is a smaller choice than budgets or dashboards. What to check in an invoice template:

  • Invoice numbers. Does the template number invoices for you, or do you type them? Automatic numbering usually needs a macro or a log sheet.
  • Tax lines. Can you set a tax rate, or turn tax off? A template built for one country's VAT layout can be awkward elsewhere.
  • Currency. The currency symbol usually comes from cell formatting. Check that you can change it in Format Cells and that totals do not show "$" in a cell you formatted as euros.
  • Logo and details. A placeholder for your logo, address and payment details should be obvious, not hidden in a locked header.
  • Export to PDF. You will send invoices as PDF. The print area should fit one page.

Inventory and stock trackers

Inventory templates are rarer still: 8.2% of listings mention inventory. The good ones separate three things: a product list, a log of movements (in and out) and a summary that calculates stock from the log. A template where you overwrite the stock number by hand is a list, not a tracker. Check that the summary uses formulas such as SUMIFS that read the whole log column, so new rows are counted automatically, and look for a reorder level column that flags low stock.

Budgets and dashboards

26.7% of listings mention budgets and 60.9% mention a dashboard, which in practice means a summary sheet with charts. Before you buy:

  • Look at how categories are set up. Can you rename and add categories, or are they fixed in formulas?
  • Check the date logic. A monthly budget should not break when a month has 31 days or when you start in a month other than January.
  • Ask how the dashboard reads data. Charts built on Excel Tables grow when you add rows; charts built on fixed ranges stop at row 100.

Locked formulas and protected sheets

Many sellers protect formula cells so that a stray keystroke cannot delete them. That is good practice, as long as you can still type in the input cells. A listing should say whether sheets are protected and whether a password is included. If you plan to change the layout, ask for the password before buying; some sellers give it, some do not.

Dates and decimal separators

Spreadsheets follow your computer's regional settings. A template made in the US expects 10/26/2026 and a full stop as the decimal mark; in Germany Excel expects 26.10.2026 and a comma. Formulas usually adapt, but text typed into cells does not. If dates look wrong after opening, check File, Options, Advanced in Excel, or File, Settings, Locale in Google Sheets.

What the screenshots should show

Only 44.2% of spreadsheet listings show more than one image. One picture of a colourful dashboard does not tell you how the input sheets look. The images worth having are: the input sheet with sample data, the summary or dashboard, the settings sheet (currency, tax, categories) and a phone or Sheets view if the listing claims it works there. If those are missing, ask the seller before buying. Getly listings have a refund window of at least 30 days, but a template that simply does not fit your workflow is easier to avoid than to return.

Browse the shelves: Excel templates, spreadsheets and calculators and budget planners and trackers.

Ready to start selling?

Independent marketplace for digital creators. Keep 80–90% of every sale. Accept cards and stablecoins.