Apple Numbers automatically saves a spreadsheet while you work, according to Apple's iPhone guide. That makes a small stock sheet a practical place to begin if you want to track inventory on iPhone. Create one row per product variant, enter an opening count, then record quantities received and removed. The walkthrough below uses a simple daily sheet with a separate movement log. It also explains what to check before relying on the phone away from an internet connection.
What you need
Have your iPhone, Numbers installed, a count of the products you want to track and somewhere to keep supplier or sales references. Complete the download while connected. Start with a small group of products so you can check the method before entering your whole shop.
Decide what one unit means. A box of twelve pens and one loose pen cannot share an unexplained quantity. For this example, the unit is one individual item. If you sell both boxes and singles, choose a consistent base unit or maintain clearly separate records.
Give every separately stocked variant a short code. A blue notebook and a red notebook need distinct rows if you want to know which colour is running out. The sample codes below are invented for this walkthrough; use whatever naming convention your business can maintain.
This guide is for a basic quantity record. It is not a tax valuation system, payment terminal or substitute for specialist stock controls where those are required. Keep customer payment details outside this sheet.
Step by step
1. Create and name the working spreadsheet
Open Numbers and create a blank spreadsheet using the new-spreadsheet control and template chooser. Apple documents these controls in its Numbers iPhone user guide. Labels and icon placement can vary with your version.
Name the file something specific, such as “Shop inventory — November 2026”. Apple's current rename instructions are to open the spreadsheet, tap More in the toolbar, choose Rename, enter the name and tap Done.
Choose one working file and make its purpose clear. Avoid keeping several files called “stock final” or “stock updated” on the same phone. An archive is useful only when everyone knows which file receives new transactions.
Before entering real stock, type a test product, close the document and reopen it. Confirm that you can find the same file and that the entry is present.
2. Build one row for each product variant
Use the first row for headings. Create columns A through H as follows:
| Column | Heading | What goes here |
|---|---|---|
| A | Product code | Your unique short identifier |
| B | Product name | A clear name including variant |
| C | Opening | Count at the beginning of the day |
| D | Received | Units added during the day |
| E | Removed | Units sold or otherwise taken out |
| F | Expected | Calculated balance |
| G | Counted | Physical count at your review |
| H | Difference | Counted minus expected |
For row 2, enter code NB-BLU and product name “Notebook — blue”. Use a real opening count when you begin live tracking; for the practice example, enter 24 in C2.
Leave price and supplier columns out initially unless you need them for a clear purpose. A narrow sheet is easier to inspect on a phone. You can add a second sheet for extra product details later.
For a fuller preparation routine, the stock-take walkthrough explains how to organize the physical count before using it as an opening balance.
3. Calculate expected stock and test the arithmetic
The arithmetic for this daily design is:
Expected = Opening + Received − Removed
In row 2, the formula for F2 is =C2+D2-E2. The formula for H2 is =G2-F2. Enter these as formulas in Numbers rather than as labels. Apple provides formula and cell-reference instructions through its calculation guide.
Use 24 opening units, 10 received and 7 removed. Expected stock should be 27. If you physically count 26, the difference should be −1.
Test another row separately before copying formulas through the sheet. Check that the second product uses its own row references. A formula can be valid spreadsheet syntax while pointing to the wrong cells.
Keep G and H blank until you do the physical count, or treat any temporary difference as unfinished. A zero in the counted column should mean you actually counted zero, not that nobody has checked yet.
4. Record stock movements without losing the explanation
The daily summary shows totals, so keep a second table or sheet named “Movements”. Give it columns for date, product code, direction, quantity, reason and reference.
For the example, add a receipt of 10 notebooks with the supplier's delivery reference. Add a removal of 7 with your sales reference. Enter quantities as positive numbers and use the direction field to distinguish stock in from stock out.
Update the daily Received and Removed totals from this log. These are cumulative totals for that day, not the quantity from only the latest transaction. After another sale of 2 notebooks, Removed becomes 9 and Expected becomes 25.
The formulas above do not automatically total a separate movement log. This beginner method requires you to maintain those daily totals manually. Keep that limitation visible so a polished spreadsheet does not create false confidence.
Separate sale, damage, gift and other removal reasons in the log. Do not label every reduction a sale if that is not what happened. Retain the explanation when correcting an entry rather than silently replacing an old quantity.
5. Check local access before working offline
Apple's move instructions allow moving a spreadsheet between iCloud and the iPhone. With the file open, use More, then Move, and choose the intended location. If you need a local working file, choose an available folder under On My iPhone.
Make this decision before starting shared work: Apple warns that moving a shared spreadsheet can affect participants in some circumstances. A local file also does not mean colleagues have its latest contents.
Test the actual workflow away from the network. Close the file, temporarily disable the phone's internet connections and reopen it. Add a clearly labelled test movement, confirm the calculation, close it and reopen again. Restore connectivity afterward and remove or reverse the test entry with a note.
Do this with sample data before relying on the process during a busy sale. Offline access and a recoverable backup are different requirements; confirm both separately.
6. Reconcile and start the next day cleanly
At closing time, compare the expected balance with a physical count for the products you are reviewing. Investigate differences before changing the opening figure.
Suppose the sheet expects 27 blue notebooks but the shelf has 26. Recount, check recent movements and look for an unrecorded removal or an entry against the wrong colour. A difference shows a mismatch; it does not prove theft or identify a cause.
Record the explanation and correction when you establish one. Keep the prior daily sheet as a dated archive. For the next day, use the reviewed closing balance as Opening and reset Received and Removed to zero.
Do not carry yesterday's receipts into today's Received total as well as including them in Opening. That counts the same units twice.
Troubleshooting
The sheet shows a negative expected quantity. Check the opening count, duplicate removals, missing receipts and unit definitions. If a pack was entered as twelve units in one place and one unit elsewhere, correct the underlying record consistently.
A formula appears as text or returns an error. Confirm that you entered formula mode and referenced the intended cells. Try the sample arithmetic again in a spare row. Avoid overwriting the formula cell with the number you expected to see.
A correct balance becomes wrong after copying a row. Inspect its references. Each product's formula must use that product's opening and movement cells. Test at least two rows with different values before trusting a larger table.
The file will not open without a connection. Reconnect and check its location and availability. Apple notes that opening an iCloud spreadsheet downloads it to the device, but do not assume a filename in a browser proves the file is ready for offline work. Repeat your offline test after changing storage arrangements.
The number is correct but the item still runs out. A balance is not a purchasing decision. Consider your supplier timing and expected demand separately. The reorder-point example shows one way to organize that decision.
Other ways to do it
A paper stock card can be enough when transactions are infrequent and one person maintains it. Use the same product codes and movement reasons so a later transfer to a phone does not require guessing.
A dedicated inventory or POS app may fit better when manually updating totals becomes difficult. Check whether it supports your required sales workflow, low-stock reminders and offline operation. Verify any needed backup, export or multi-device behaviour before moving all records; those capabilities vary between products.
For other approaches, see the offline POS comparison. Choose around your actual transaction volume and recordkeeping needs, rather than assuming the most complicated option will be the most reliable.
How Cela can help
Cela is an iPhone POS and inventory app whose verified feature description includes offline operation, sales tracking, inventory control and low-stock alerts. Those features may suit a shop that needs more structure than a manually maintained daily spreadsheet.
Before switching, try a small set of products and check the complete receipt, sale and correction workflow against a physical count. Confirm any backup or export requirements directly; this guide does not assume features beyond the supplied description. A dedicated app can support recordkeeping, but your opening quantities and transaction entries still need to be accurate.
Frequently asked questions
Can I track inventory on my iPhone without a dedicated app?
You can use a spreadsheet for a small quantity record. Give each product variant its own row, record an opening count and maintain receipts and removals. Keep a separate movement log so you can explain changes, and check the balance against physical stock.
Does an iPhone inventory spreadsheet automatically record sales?
The simple Numbers method in this guide does not connect to a checkout or automatically total a movement log. You must record each movement and update daily totals yourself. If that becomes difficult to maintain, evaluate a dedicated POS and inventory app.
How do I check whether my stock sheet works offline?
Prepare sample data, confirm the file's storage location and close it. Temporarily disable internet connections, reopen the file, make a test entry and check that it persists after reopening. Restore connectivity afterward and confirm your backup process separately from local access.
Why does my counted stock differ from my spreadsheet?
Possible explanations include an incorrect opening count, missed movements, duplicate entries, mixed units or a transaction recorded against the wrong product variant. Recount and inspect the log before making a correction. A mismatch alone does not establish the cause.
Conclusion
Start with a few products, clear units and one working file. Enter an opening count, record every movement and verify the expected balance against the shelf. Test local access before a trading day without reliable internet, and keep a recoverable copy through a backup method you have checked. When manual totals become hard to maintain, evaluate a dedicated inventory app using the same small, known set of transactions.