Skip to content
Office Supplies Inventory cover: a sample sheet with supply lines, lines to reorder and approved spend and a column chart, beside the Dashboard tab

Office Supplies Inventory

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
6
Style
Minimal
Difficulty
Beginner
Updated
November 13, 2026

Every slide (6)

Overview

This template is for an office manager or admin team that keeps pens, paper, toner and filing supplies in a cupboard. The Supplies tab holds every item with its category, count on hand, reorder point, unit cost and stock value, and flags items to reorder. The Requests tab records each request by date, person, department and item, works out the cost and shows whether it is approved, pending or declined. The Budgets tab compares approved spend with each department's quarterly budget.

Enter the stock you hold and the reorder level for each item before you start. Log requests as they come in, choosing the department and typing the item exactly as it appears on the Supplies tab so the cost calculates. Only approved requests count toward spend. Once a month, review the Budgets tab and the Reorder flags, then place orders for anything running low.

Useful for

  • Keeping the supplies cupboard stocked for a small office
  • Checking which department has used most of its budget
  • Approving requests against a quarterly supplies limit

What's included

  • 5 tabs: Dashboard, Supplies, Requests, Budgets, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Supplies: a table
  • Requests: a table
  • Budgets: a table
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Supplies tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

Why does a request show zero cost?

Each request cost is found by matching the item name against the Supplies tab. If the name in the Requests tab does not match exactly, the formula shows zero. Choose the item name from the Supplies tab, or copy it across, to fix the line.

Can I set a budget for a month instead of a quarter?

Yes. Enter the amount for whatever period you use in the Quarterly budget column on the Budgets tab. The sheet does not assume a set length of time, so a monthly figure works the same way. To start a new period, empty the Requests rows or duplicate the whole workbook.

Should declined requests count in spend?

No. The Budgets tab and the dashboard count only requests marked Approved. Pending requests appear in the pending count but not in spend, which gives a clear view of committed money. Declined requests stay in the list for your records.

  • #inventory
  • #office-supplies-inventory
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More inventory templates

See all 19

Also in Business operations

All business operations templates
Get this template

Preparing your template…