Home / Blog

How to move from a notebook to an inventory app without losing a day's sales

Published 19 November 2026 · 2 min read · By the Invoicer team

To move from a notebook to an inventory app, list your products, upload them in bulk from a CSV file, count your opening stock, then record every sale in the app while you keep the notebook for one week as a check.

Do not switch on your busiest day

Pick a quiet day. The goal is that on day one, your app shows the same stock as your shelves. Everything after that is just recording sales.

Step 1: List your products

Write each product with its name, cost price, selling price and quantity. If you sell sizes or colours, list each as a variant. If your products are already in Excel or Google Sheets, you are most of the way there.

Step 2: Upload them in bulk

Typing hundreds of products by hand is where most people give up. Invoicer lets you upload products from a CSV file and gives you a template to follow. Save your sheet as `.csv`, upload it, and check the preview before confirming.

Step 3: Count your opening stock

Count the shelves once, carefully. The count you enter now is the base for every figure later. Our stock count guide shows a quick method that works for a small shop.

Step 4: Record debts you are owed

Add customers who owe you, with the amounts, so they are tracked from day one. See how to track customers who owe you money.

Step 5: Run both for a week

Keep the notebook for seven days and compare the end-of-day totals. Differences show you what you forgot to record. After a week with no gaps, retire the notebook.

Frequently asked questions

Can I upload my products from Excel?

Save the sheet as a CSV file and upload it. Invoicer gives you a template so the columns match.

Do I need to enter every product before I start selling?

No. Start with your best sellers and add the rest as you go, but your stock figures are only accurate for products you have counted.

How long does the switch take?

Many shops finish setup in an afternoon: list, upload, count, then start recording sales.

Reach out on WhatsApp