Ink Inventory Spreadsheet: Track Stock and Reorders

How-to basics · Updated November 21, 2026

An ink inventory spreadsheet is a simple way to track cartridges or bottles by printer, color, location, quantity, and reorder point. In Excel for Microsoft 365, start with a stock list and, if you want a history of changes, add a separate transaction log; a few formulas can calculate current stock and flag supplies to reorder.

What an ink inventory spreadsheet should track

The useful details are the ones that help someone identify the right ink, find it, and decide whether more is needed. A cartridge number alone may not be enough: printer models can use different supplies, and a color name such as “black” does not establish that two products are interchangeable. Record the manufacturer’s product or cartridge number, and the compatible printer or printer family.

For each distinct ink item, consider recording:

  • SKU or product number: the manufacturer’s identifier, or an internal code if you use one.
  • Description and compatibility: product name, cartridge or bottle type, and the printer models it fits.
  • Color: black, cyan, magenta, yellow, or the specific specialty color shown on the packaging.
  • Storage location: a cabinet, shelf, room, or bin that staff can locate.
  • Quantity and reorder point: how many usable units are on hand and the level at which purchasing should begin.
  • Cost and supplier details: optional fields that help with budgeting and repeat orders.
  • Last counted date and condition: useful when stock is checked infrequently or packages may be damaged.

Count each distinct product separately. Do not combine different cartridge numbers just because they fit the same printer, and do not count an opened or damaged item as a full usable unit unless your workplace has a clear rule for it.

A practical Excel layout

For an ordinary stock list, create a worksheet called Inventory and put one product per row. A useful column order is: A SKU, B product description, C compatible printer, D color, E storage location, F opening quantity, G on-hand quantity, H reorder point, I target quantity, J unit cost, K status, and L inventory value. Use a unique SKU for each distinct ink product so that similar descriptions do not get confused.

To preserve a record of stock changes, add a worksheet called Transactions with columns for date, SKU, type, and quantity. Enter each delivery as “Received” and each withdrawal or use as “Used.” Enter quantities as positive numbers in both cases; the calculation distinguishes receipts from usage. Use the same spelling for transaction types every time, and make sure the SKU matches the Inventory sheet exactly.

Keep one inventory row per product, rather than one row per physical cartridge. If you have several storage locations and need to know the quantity in each, either add a separate row for each SKU-location combination or track location-level counts in a more detailed stock ledger. Be consistent: the same quantity should not be counted in two places.

In Excel for Windows, select the headings and data and choose Insert > Table. A table makes it easier to filter by color, location, or reorder status and carries formatting into new rows. If you prefer a basic range, freeze the heading row with View > Freeze Panes > Freeze Top Row. On Mac, the equivalent ribbon commands are generally available, though their placement can differ slightly by Excel build.

Calculate current stock from a transaction log

A small inventory can be updated by changing the on-hand number after each purchase or withdrawal. A transaction log is more auditable: it records what changed and when, and lets the workbook calculate the balance from an opening count. The following setup assumes the Inventory columns above and a Transactions sheet where A contains dates, B contains SKUs, C contains the exact type labels “Received” or “Used,” and D contains positive quantities. The opening count is in Inventory!F2.

With those columns, enter this in Inventory!G2 and copy it down for each product. It adds logged receipts to the opening quantity and subtracts logged usage. If the opening quantity is 8, the log contains 12 received and 9 used for that SKU, the formula returns 11.

=F2+SUMIFS(Transactions!$D$2:$D$500,Transactions!$B$2:$B$500,A2,Transactions!$C$2:$C$500,"Received")-SUMIFS(Transactions!$D$2:$D$500,Transactions!$B$2:$B$500,A2,Transactions!$C$2:$C$500,"Used")

The example uses rows 2 through 500 for transaction entries, so increase the range if your log grows beyond row 500. A negative calculated balance usually indicates a missing opening count, an incorrectly entered SKU, or more recorded usage than available stock. It is a prompt to investigate, not proof that the physical count is negative.

Flag items that need reordering

A reorder point is the stock level at which you want to take action. It is not automatically the same as the quantity you want to purchase. Set the point with your supplier’s delivery time, how quickly the ink is used, and the consequences of running out in mind. A busy print room may need a higher buffer than a home printer used occasionally.

With current stock in Inventory!G and the reorder point in Inventory!H, put this formula in K2 and fill down. It returns “REORDER” when the balance is at or below the threshold, and “OK” otherwise. For example, a balance of 5 and a reorder point of 6 returns “REORDER.”

=IF(G2<=H2,"REORDER","OK")

To make the warning easy to notice, select the status cells and use Home > Conditional Formatting > Highlight Cells Rules to format cells containing “REORDER.” A filter on the status column can then show only items that need attention. Review the list before ordering: a flagged item may already be on a purchase order, or a recent delivery may not yet have been entered.

Estimate the value of stock

Cost tracking is optional, but it can show how much money is tied up in supplies and help compare purchasing patterns. Enter a consistent per-unit cost in column J. Decide whether that means the latest purchase price, a standard cost, or another internal measure; mixing methods makes totals harder to interpret. If prices vary substantially, keep purchase dates and prices in a separate purchasing record rather than treating one figure as a precise accounting valuation.

With on-hand quantity in G2 and per-unit cost in J2, enter this in L2 and copy it down. If there are 11 units at a recorded unit cost of $18.50, the displayed result is $203.50. Format the result as currency using Home > Number; the cell’s display format changes how the number appears, not the underlying multiplication.

=G2*J2

The row values can be added to estimate the total inventory value, but the figure is only as reliable as the quantities and cost method behind it. It should not be treated as a formal financial or accounting valuation without checking the organization’s applicable procedures.

Set up the workbook for reliable use

A spreadsheet is only useful if people enter information in a consistent way. Establish a short procedure for receiving, issuing, and counting ink. For example, the person receiving a delivery can verify the product number, enter a “Received” transaction, and put the stock in its assigned location. A person taking a cartridge can log it as “Used” at the time it leaves storage, rather than relying on memory at the end of the month.

For cleaner entries, use Excel’s Data > Data Validation to create a list of allowed transaction types, such as “Received” and “Used.” You can also create a drop-down list of SKUs based on the inventory list, reducing spelling mismatches. In Microsoft 365, you can filter the table to locate a product or see all items below their reorder points. Keep a dated backup or use your organization’s normal file storage and version-history practices, particularly if several people update the workbook.

When physically counting stock, compare the count with the calculated balance, investigate the difference, and record a correction in a way that preserves the audit trail. One option is to use a clearly named adjustment transaction type and adapt the calculation to include it; another is to document adjustments separately under a written procedure. Avoid silently overwriting a formula-driven balance, because that removes the explanation for how the number was reached.

Common errors and how to avoid them

  • Similar products are treated as the same item. Use the exact product number and compatible printer information, not just a broad color label.
  • Transactions do not match the SKU. A trailing space or mistyped character can make a valid receipt invisible to a SUMIFS calculation. Use a consistent SKU list and check entries when a balance looks wrong.
  • Usage is recorded twice or not at all. Decide who records withdrawals and when. If a transaction is reversed, document the correction rather than simply adding an unexplained number.
  • Reorder points are copied without considering demand. Review them after changes in printer use, supplier lead times, or purchasing practices.
  • Damaged, expired, or opened supplies are counted as ready stock. Record unusable stock separately or remove it through a documented adjustment so purchasing decisions reflect what can actually be used.
  • Formula ranges stop too early. If a transaction log exceeds the rows included in the SUMIFS ranges, later activity will not affect the calculated balance. Extend the ranges or maintain the workbook’s defined capacity.

Ink packaging and storage guidance can differ by product. Follow the manufacturer’s instructions, keep supplies identifiable in their original packaging where practical, and avoid assuming that an old or damaged cartridge will perform like a new one. For disposal or recycling, check the manufacturer’s program and local requirements rather than putting every type of cartridge in ordinary waste.

When a spreadsheet is enough—and when it is not

A spreadsheet is often adequate for a small office, studio, school department, or home with a manageable number of ink products and a limited number of people updating stock. It is inexpensive to maintain, easy to tailor, and can be filtered without special inventory software. Its main weakness is process dependence: it will not know that a cartridge was removed unless someone records the change, and simultaneous edits or poorly controlled copies can produce conflicting information.

Consider dedicated inventory software when multiple sites need live stock visibility, purchasing approvals, barcode scanning, detailed user permissions, or links to purchasing and accounting systems. A shared workbook may still work for a small team, but agree on one authoritative file and who is allowed to change formulas and reference data. For a very small personal supply, a paper list or a simple note may be sufficient; use a spreadsheet when sorting, history, or reorder calculations provide genuine value.

Frequently Asked Questions

How do I make an ink inventory spreadsheet in Excel?
Make an Inventory sheet with one row per ink product and columns for SKU, printer, color, location, quantity, reorder point, and optional cost. Add a Transactions sheet if you want to calculate balances from receipts and usage, then use filters to review the stock list.

What is the best way to track ink usage?
Record each withdrawal as a dated transaction with the product SKU and quantity. If usage is not logged consistently, a periodic physical count can correct the balance, but the workbook will not show a complete history of what was used.

Should I track cartridges by printer or by color?
Track them by the exact product or cartridge number, then include both compatible printer models and color as descriptive fields. Color alone is not specific enough to distinguish products that may not fit the same printer.

What should my ink reorder point be?
Choose a threshold that allows time for purchasing and delivery before stock runs out. Consider typical usage and supplier lead time, then review the threshold if demand or delivery conditions change; a universal number will not suit every printer or workplace.

Can Excel warn me when ink is low?
Yes. A status formula can compare the on-hand quantity with a reorder point, and conditional formatting can highlight the warning. The alert is only current if receipts, usage, and stock corrections are entered accurately.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.