MatSmartShop
Log in Get started free

For whoever owns stock

Items & Purchases

Your catalogue, your stock, and every movement in and out of it.

12 min read · 6 screenshots

Everything here sits under OPERATIONS → Items & Purchases, which opens three screens: Inventory Center (the overview), Item List (the catalogue), and Purchase & Adjustment List (the log of everything that has ever moved stock). A fourth screen, Item Detail, opens from inside the first two and is where most questions actually get answered.

The one idea to hold on to. An item's selling price and its cost are separate things, kept in separate places on purpose. The selling price lives on the item. Cost arrives with each purchase. Nothing you do on the Record stock form will change what you charge customers — and that is deliberate, not an oversight.

1. Inventory Center

The first stop — what you hold, what it's worth, and what is moving.

Inventory Center showing a date range selector and four cards: total products, low stock, out of stock and total stock value, plus two Top 5 Fastest Movers charts by units sold and by sales value, above an inventory list
Inventory Center — four headline figures, two fastest-mover charts, and the inventory list beneath.
CardWhat it tells you
Total ProductsHow many items are in your catalogue.
Low StockItems at or below their reorder level — your buying list.
Out Of StockItems at zero or below.
Total Stock ValueWhat the stock on hand is worth at cost.

The two Top 5 Fastest Movers charts answer different questions and are worth reading together. By Units Sold shows what leaves the shelf most often; by Sales Value shows what actually brings in money. An item can top one chart and be absent from the other — that gap is usually where a pricing or stocking decision is hiding.

The Date Range selector at the top applies to the fastest-movers charts only. The four cards always describe stock as it stands right now.

2. Item List

Items List with columns for item name, item type, purchase rate, sales rate, quantity, reminder level and a manage gear button, plus Create Item, Upload from Excel and Export to Excel buttons and a search box
Item List — the full catalogue, with the three ways of getting items into it along the top.
ColumnMeaning
Item NameYour internal name. Click it to open Item Detail.
Item TypePRODUCT (has stock) or SERVICE (does not). Services always show quantity 0 — that is correct, not a fault.
Purchase RateCost price.
Sales RateWhat you charge.
QuantityStock on hand.
Reminder LvlThe reorder point — see section 8.
ManageThe row's actions.
Item row gear menu open showing Stock Details, Edit Item and Delete Item
Each row's gear menu: Stock Details, Edit Item, Delete Item.
Deleting an item is not the same as hiding it. An item with history behind it is woven into past invoices and stock movements. If a product is simply discontinued, leave it in place — it costs you nothing and keeps your old records readable.

2.1 Negative quantities

A negative figure in the Quantity column means the system has recorded more going out than ever came in. It is almost never a counting error at the till — it is stock that was sold before it was ever entered as received, or purchases that never synced. Fix it with a stock adjustment (section 6) once you have counted the shelf, and treat a large negative as a sign that the item's purchase history is incomplete.

3. Creating items

Create Item opens a form that lets you queue several products before saving any of them.

Create New Items dialog with fields for item name, item type, purchase rate, sales rate, quantity available and reminder level, an optional item image, an Add To List button, an empty list table and a Save button
Create New Items — fill the row, Add To List, repeat, then Save once.
  1. Item Name and Item Type (Product or Service).
  2. Purchase Rate — what it costs you. Sales Rate — what you charge.
  3. Quantity Avail — opening stock. Use it only for what is on the shelf the day you create the item; everything arriving afterwards should come in as a purchase so the cost is recorded.
  4. Reminder Lvl — the reorder point.
  5. Item Image (optional) — worth adding. The photo shows as a thumbnail in the New Sale item picker, so staff can confirm they've grabbed the right product at a glance.
  6. Add To List, repeat for as many items as you're entering, then Save.

4. Item Detail — the stock passbook

Click any item name to open it. This screen answers "why does it say I have this many?"

Item Detail for plates showing five cards for current stock, reorder level, sales price, stock value and retail value, a Stock History table with date, activity, change and running balance, and a Stock Level Trend chart
Item Detail — the five figures, the movement history, and the trend.

4.1 The five cards

CardMeaning
Current StockUnits on hand.
Reorder LevelMinimum before restock.
Sales PricePer unit, as charged.
Stock ValueWhat you're holding, at cost.
Retail ValueThe same stock at selling price, with the margin percentage.

4.2 Stock History

Every purchase, sale, adjustment and transfer for this item, each with the change it made and the running balance afterwards. Rows run newest first, so the balance on the top row is today's figure.

This is the tool for a disputed stock number. Work down the column until the balance stops matching what you believe, and the row where it diverges is the movement to investigate. A Received PURCHASE +100 against a Sold SALES −5 reads at a glance.

4.3 Trend, sales and the rest

Lower half of Item Detail showing the stock level trend chart with a dashed reorder level line, a Sales and Orders panel with total sold and sales value, and View Sales Records, View Purchases and Print buttons
The trend chart carries a dashed reorder line, so periods below it are visible at a glance.
  • Stock Level Trend — stock over time, with the reorder level drawn as a dashed line. Stretches below that line are stock-outs you may not have noticed.
  • Sales & Orders — total units sold and total sales value for this item.
  • View Sales Records / View Purchases — drill into the transactions behind those figures.
  • Print — a printable copy of the item's position.

5. Purchase & Adjustment List

Every entry that has moved stock, other than sales. Open it from Items & Purchases → Purchase & Adjustment List. The page is headed Purchases & stock adjustments and has two tabs: History and Scan a paper.

5.1 The buttons at the top

  • Record stock opens the entry form (section 6).
  • Scan a paper jumps to the Scan a paper tab (section 6.4).
  • More holds Upload purchases (many purchases from a spreadsheet), Upload adjustments (a stock count or corrections from Excel) and Export to CSV (everything on the list). The uploads are covered in the Upload & Scan guide.

5.2 The History tab

  • Dates — pick a period, or press All dates to see everything ever recorded.
  • Summary tiles — Bought from vendors (money), Stock added (adjustments) and Stock removed (adjustments) (units), and Vendors bought from.
  • Type chips — show only one kind of entry. Each row's Type badge reads Purchase, Stock added, Stock removed, Transfer in or Transfer out (transfers come from the Consolidator).
  • Search — by item, vendor or type.
  • Columns — Date, Item, Type, Vendor, Qty, Unit cost and Value. Value is what the vendor billed. Where no amount was recorded (older entries, and every adjustment) it shows in grey as quantity × unit cost.

A row with no vendor is an adjustment; a row with a vendor and a value is a purchase. That difference is the subject of section 7.

6. Recording a purchase or an adjustment

Record stock opens one form for a whole vendor bill or a whole stock count — as many lines as the paper has, saved together.

6.1 Step by step

The form has three buttons at the top. Choose one first:

ButtonUse it for
PurchaseBought from a vendor. Adds stock and records what you paid or still owe.
Add stockFound, returned or miscounted stock. No vendor, no payment.
Remove stockDamaged, expired, lost or used up. Taken off at the item's average cost.
  1. Choose what you are recording — Purchase, Add stock or Remove stock.
  2. Date — defaults to today. Change it to the day the stock really moved. A future date shows a warning.
  3. Vendor (Purchase only) — who you bought from. A new supplier? The Add a vendor link opens Vendors & Transactions — add them there first, then come back.
  4. Add the items — type in Search an item to add… and press Enter. Each pick shows how many you have and its cost. Add as many lines as the bill has.
  5. Fill each line — Quantity (whole numbers only) and Unit cost (for Remove stock this shows the Avg. cost and cannot be changed). The line shows its Line total and the After figure — how many you will have once it is saved. After turns red if it would go below zero.
  6. Payment (Purchase only) — the totals box shows the bill total. Paid follows the total until you type your own figure; untick Paid in full if you are paying part now. Still owed to vendor shows what is left. If you paid anything now, choose Paid with (the payment type).
  7. Press Save, read the summary (for example "… for ₦45,000, leaving ₦15,000 owed") and confirm.
Selling prices do not change here. Buying stock never changes what you charge. To change a price, edit the item on the Item List or use Upload Data → Prices.

6.2 What the form stops you doing

MessageWhat to do
Choose the vendor you bought from.Pick a vendor. A new one must be added on Vendors & Transactions first.
…quantity must be a whole number.Stock is counted in whole units. Record 2, not 1.5.
Amount paid cannot be more than the total.To pay a vendor in advance, record it on the vendor's page instead.
A Cash vendor must be paid in full.A vendor named Cash is always paid in full. To record a balance owed, pick the real vendor.
Choose how you paid.You entered a paid amount, so choose the payment type.

6.3 If some lines fail

Lines are sent in batches. If a batch fails, the lines already saved stay saved and are taken off the form; the message says how many were recorded. Press Save again to send the rest. Nothing was recorded means no line was saved — check your connection and try again.

6.4 Scan a paper instead of typing

The Scan a paper tab turns a supplier's receipt, a delivery note or your own handwritten list into entries — handwriting is fine.

  1. Choose Purchase (goods a vendor sold you) or Stock adjustment (a stock count, damages or shortages).
  2. Take or upload a photo. A long sheet? Add several photos; their lines are added together.
  3. Check what was read: correct a line, or untick it to leave it out. Nothing is saved until you confirm.

Each photo uses usage units. When you confirm, the History tab refreshes with the new entries. The same reader is described in full in the Upload & Scan guide.

6.5 From the dashboard's low-stock list

The Buy link next to a low-stock item on the dashboard opens this form with that item already on it.

7. Purchases vs adjustments — and why it matters to your costs

Both move the quantity. Only one of them tells the truth about money.

PurchaseAdjustment
Changes stockYesYes
Records a vendorYesNo
Records what you paidYesNo
Creates a payable if unpaidYesNo
Feeds your average costYes, at the rate you enteredAt whatever cost is on the entry — zero if you leave it blank
The costing trap. Putting bought stock in as an adjustment with no cost tells the system you acquired those units for nothing. That pulls the item's weighted average cost down, which inflates the profit on every subsequent sale and understates your stock value. It is a quiet error — nothing looks wrong on screen — and it compounds each time. If money changed hands, record it as a purchase.

The reverse mistake is milder but still worth avoiding: recording a recount or a breakage as a purchase invents a vendor liability you don't owe.

8. Reorder levels and low stock

The Reminder Level (called Reorder Level on Item Detail) is the figure that drives your Low Stock alerts — on the Inventory Center card, on the dashboard, and as the dashed line on the item's trend chart.

Set it to cover the time it takes to restock, not to zero. If a product takes a week to arrive and you sell five a week, a reorder level of five means you run out exactly as the new stock arrives; ten gives you a week of cover. Items left at zero never alert, which is why a store can have seventy items out of stock and no warnings.

9. Doing it in bulk

Everything in this guide has a bulk equivalent, covered fully in the Upload & Scan guide:

One at a timeIn bulk
Create ItemUpload Data → Items, or Upload from Excel on the Item List
Record stock → PurchaseUpload Data → Purchases
Record stock → Add stock / Remove stockUpload Data → Stock Adjustments, or More → Upload adjustments on the purchases page
Editing an item's priceUpload Data → Prices
Typing from a paper delivery note or stock countThe Scan a paper tab on the purchases page, or Upload Data → Scan A Report

10. Quick reference

I want to…Do this
See what needs reorderingInventory Center → Low Stock
Know what my stock is worthInventory Center → Total Stock Value
Find out why a stock figure is wrongItem List → click the item → Stock History
Add a productItem List → Create Item
Record a delivery from a supplierPurchase & Adjustment List → Record stock → Purchase (one form for the whole bill)
Write off damage or expiry…same form → Remove stock
Correct stock after a count…same form → Add stock or Remove stock for the difference
Enter a supplier's paper receipt without typingPurchase & Adjustment List → Scan a paper
Change a selling priceEdit the item (or Upload Data → Prices) — not the purchase form
See everything that moved stock this monthPurchase & Adjustment List → History → pick the dates
See what I owe suppliersVendors & Transactions, fed by the unpaid part of each purchase

If something looks wrong

  • Quantity is negative. More has gone out than was recorded coming in. Count the shelf, then post an adjustment — and check whether purchases for that item were ever entered.
  • A service shows quantity 0. Correct. Services don't carry stock.
  • Profit looks too good. Check whether stock was brought in as zero-cost adjustments instead of purchases.
  • Stock value looks too low. Same cause.
  • An item never appears in Low Stock. Its reorder level is probably 0.
  • A price changed unexpectedly. It did not come from a purchase entry — that form cannot change selling price. Look at item edits and the Prices upload.
  • Stock History and current stock disagree. The last row's running balance is the authority; if it doesn't match the card, raise it with support rather than adjusting over the top.
Inventory management software that tells you what to reorderKnow what you have, what it cost and what to reorder. Item history, reorder levels, supplier purchases and stock reports on web, Android and desktop.

More guides

Sales & CustomersMaking a sale, invoices, payments, and customer statements. Dashboards & ReportsEvery dashboard panel and every report: sales, profit, money owed, stock health, and why two figures can disagree. Expenses, Vendors & BudgetsRecord bills paid now or later, keep each supplier's account, pay vendors, approvals for big bills, cash advances to staff, and budgets. Bank & CashHow much money you have and where it is, checking with your bank each month, bank charges, and checking a customer's transfer receipt. Store Setup, Users & SecuritySign-up and sign-in, your store profile and tax, payment types, sales points, staff accounts and permissions, and the login audit. Usage, Billing & HelpPlans, usage units, topping up and earning more, subscribing, and where to get help. Upload & ScanLoad data in bulk from a spreadsheet, or straight from a photo of your counter book. Customer Follow-UpText customers who owe you or have gone quiet, and set up automatic thank-yous, payment notes and date messages. Merchant Storefront (Wildfire)Publish items online, run offers and coupons, take orders, handle back-orders, and buy SMS units. Affiliate MarketingGive people their own link to your storefront, then approve and pay the commission on what they sell. Seasonal Sales PlaybookRun festive sales on your online store: 15 activities in order, from your free profile to your first offer, each with a short video. AssociationsYour own words, funds, contributions and dues, spending and approvals, advances to officers, meetings, and the treasurer's report. ConsolidatorEvery store on one dashboard, side-by-side reports, stock across outlets, transfers and price updates. Android AppSell from your phone, scan with the camera, and keep working with no internet. Desktop (Windows Till)Setting up and running MatSmartShop on a PC till, with its own offline database. Shopper's GuideHow to order from your storefront link. Share it with buyers as it is.

All tutorials and videos

Still stuck? We answer questions too.

Check the FAQs, or email us directly.

Browse FAQs Email Support
MatSmartShop

Point of sale, inventory and bookkeeping for multi-store retailers — online or offline.

PRODUCT
SOLUTIONS
LEGAL
CONTACT
2nd Floor Olajire House 3, Ilupeju Bypass Road, Lagos, Nigeria. info@matsmartshop.com +234-903 090 6660 +234-909 294 2048 (WhatsApp)
© 2026 Magnet Consulting Associates Limited. All rights reserved.