How to Move from Manual Billing or Excel to a POS System

Many successful Sri Lankan shops still run on bill books, a calculator and an Excel sheet. It works — until stock goes missing, the month-end count takes a weekend, or you need to know which products actually make money. Moving to a POS system is easier than most owners expect. Here is the step-by-step plan we use when we set up new customers.

Signs it's time to switch

• You can't say how much stock you have without counting it.
• Customers wait while bills are written or totals are added up.
• Cash at the end of the day rarely matches the bill book.
• You re-type sales into Excel at night.
• You don't know your best sellers, slow movers or real profit margins.

Step 1: Choose offline or cloud

For one shop with patchy internet, an offline POS is simplest. For several branches, cloud POS lets you see everything from your phone. Our offline vs cloud guide explains the trade-offs.

Step 2: Prepare your item list

This is the most important step. Create a spreadsheet with one row per product:

• Item name (as you want it on the bill)
• Category (for example, Beverages, Paint, Accessories)
• Barcode, if the product has one
• Cost price and selling price (and wholesale price, if you use one)
• Unit of measure (piece, kg, box, metre)
• Supplier

If you already keep stock in Excel, you're halfway there. We import the file directly, so there is no need to type items again.

Step 3: Decide on barcodes

Packaged goods already have barcodes. For loose items, house brands and goods without labels, the POS can generate and print your own barcodes on a label printer.

Step 4: Set up the counter hardware

You need a Windows computer, a thermal receipt printer and a barcode scanner; a cash drawer is strongly recommended. Read POS machine price in Sri Lanka for what each item does.

Step 5: Do an opening stock count

Pick a quiet evening or a Sunday, count everything, and enter the quantities as your opening stock. From that moment, the POS deducts every sale and adds every GRN automatically — this is the last full manual count you'll do in a rush.

Step 6: Set users and permissions

Give each cashier their own login. Decide who can give discounts, process returns, void bills or edit prices. Supervisor authorisation prevents expensive mistakes and makes every transaction traceable.

Step 7: Train your team

Cashiers usually learn billing in an hour or two; managers need a little longer for GRNs, stock and reports. Most of our customers are trained in one or two days, in Sinhala, Tamil or English.

Step 8: Go live

• Run the POS and the old method side by side for a day if it gives you confidence.
• Keep the old bill book for emergencies only.
• Check the end-of-day report against your cash on the first few days.

Step 9: Start using the reports

After two weeks you'll have real data: best-selling items, slow movers, profit by category and sales by hour. That is where the POS starts paying for itself — better purchasing, fewer stock-outs and less dead stock.

Common worries

• "My staff aren't good with computers." Billing is scan, total and print. If they can use WhatsApp, they can bill.
• "What if the internet goes?" Offline POS doesn't need it for billing.
• "What if the computer breaks?" Automatic backups keep your data safe, and it can be restored on a new machine.
• "Is it expensive?" Offline POS starts at Rs. 70,000 one-time; cloud starts at Rs. 4,900 per month. See the POS price page.

A realistic first-week timeline

• Day 1: install software and hardware, import your item list, set users.
• Day 2: opening stock count after closing; enter quantities.
• Day 3: cashier and manager training; test bills, returns and GRNs.
• Days 4–7: go live, check the end-of-day report each evening, fix any item names or prices that need adjusting.

Moving from another POS?

If you already use an older POS or accounting software, export your items, customers and suppliers to Excel or CSV. We import those lists so you keep your product names, prices and customer balances. Old sales history can stay in the previous system for reference while new sales start in Visiro.

Whether you run a retail shop, a hardware store or a supermarket, the steps are the same. We handle the import, setup and training for you.

Frequently asked questions

Do I have to close my shop to switch to a POS?

No. Setup and training happen around normal hours, and the opening stock count can be done after closing or on a quiet day.

Can you import my Excel stock file?

Yes. Send us your item list and we import names, categories, barcodes, prices and suppliers.

What if my products don't have barcodes?

The POS can generate and print barcodes for loose items and house brands, or cashiers can search by name.

How long does staff training take?

Usually one or two days in total, in Sinhala, Tamil or English.

Next steps

Compare every option in our POS system guide for Sri Lanka, check current packages on the POS system price page, or book a free demo and we'll show you the switch-over process with your own products.