How to move your shop from a paper notebook to a POS

Moving a shop from a paper notebook to a POS takes an afternoon, not a week: register the store, import your existing stock list from Excel, receive your stock as batches, and take the first sale. The notebook becomes the backup, not the system.

By Talemwa SolomonUpdated 21 July 20266 min read

Key takeaways

  • You do not retype your catalogue. Import the stock list you already keep in Excel.
  • Enter opening stock once, as batches, so expiry and cost are captured from day one.
  • Existing credit is entered as opening balances per customer, so no debt is lost in the move.
  • Start on one till; add staff PINs and a second counter once the first day has gone smoothly.

Can I switch without retyping everything?

Yes. The fear of retyping a whole shop is the main reason owners stay on paper, and it is misplaced. If you keep any kind of stock list in Excel, a good POS imports it: product names, prices, barcodes and quantities become your catalogue and opening stock in one upload. The work is an afternoon of setup, not a week of typing.

Here is the order that works, with the least disruption to trade.

Step 1: register your store

Create the store, name your branch and set an admin PIN. This is the one step that needs an internet connection; after the first sign-in, the till runs offline. Do it the evening before you go live so the counter is not waiting on it.

Step 2: import your catalogue from Excel

Upload the stock list you already keep. A good importer maps your columns (name, price, barcode, quantity) and creates the products and their opening stock together, so you are not entering the catalogue twice. Review the preview before you confirm; fix a wrong price now, not at the counter.

Step 3: receive your stock as batches

Enter what is on your shelves as received stock. Doing it as batches, with quantity, cost and (for perishables) an expiry date, means your margins and expiry alerts work from day one. For a shop with perishables this is worth the extra few minutes: the till can then sell oldest-stock-first and warn you before things expire.

Count as you go. The move to a POS is the one moment you will have a clean, honest count of the whole shop. Use it.

What about the credit people already owe me?

Do not lose it in the move. Enter each credit customer with their current balance as an opening amount, straight from the notebook. From then on, every credit sale and repayment updates that balance automatically, and the notebook becomes a backup you will stop needing.

Step 4: take the first sale

Scan or search an item, take the payment by cash, card, mobile money or credit, and print the receipt. That is the whole loop, and once it works once it works all day, with or without a connection. Run the first hour yourself before handing the till to staff.

Adding staff and a second till

Once the first day has gone smoothly, add your staff with their own PINs so every sale is attributed to a person, and open a second counter if you need one. Do this after go-live rather than before, because a shop learns the till fastest by using it for real trade instead of configuring it in advance.

Why keeping the records digitally matters beyond the shop

A notebook records what you sold. A till records it in a form you can be asked to produce. Uganda Revenue Authority expects a business to keep proper books of account, and a shop that already has dated, itemised sales history has answered that question before it is asked. The same history is what a bank looks for when a business applies for credit.

This is the part owners tend to discover a year in rather than on day one: the value of moving off paper is not only the faster counter, it is that twelve months later you can prove what the business did.

Frequently asked questions

Do I have to retype all my products to start using a POS?

No. If you keep a stock list in Excel, you import it. Product names, prices, barcodes and quantities become your catalogue and opening stock in one upload. Setting up is an afternoon of work, not a week of typing.

What happens to the credit my customers already owe when I switch?

You enter each credit customer’s current balance from the notebook as an opening amount. Every credit sale and repayment then updates it automatically, so no debt is lost in the move and the paper notebook becomes a backup you stop needing.

How long does it take to move a shop onto a POS?

An afternoon for a typical shop: register the store (the only step needing internet), import the catalogue from Excel, receive your stock as batches with cost and expiry, and take the first sale. Add staff PINs and extra tills after the first day has gone smoothly.

Want to talk it through?

Describe your shop and we will tell you honestly whether Stem fits, including if the free plan is all you need.

More guides