Moving a small business off spreadsheets: what to set up first
A practical order of work for Bahamian owners leaving spreadsheets: what to clean up, what to set up first, and the checks to run before you switch.
I'm Ty Wells, founder of IslandFlow, which GTS Bahamas makes in Freeport, Grand Bahama. I've watched a lot of owners outgrow their spreadsheets: a stock sheet on one laptop, a sales sheet on another, and staff hours in a notebook by the till. This guide gives you an order of work for moving off them, whatever system you end up using. The goal is to move clean information, in the right order, without losing track of money or stock along the way.
Step 1: List every spreadsheet you actually rely on
Before you set up anything new, write down every file, notebook and WhatsApp thread that holds business information. For each one, note:
- What it tracks (stock, sales, expenses, staff hours, customer balances).
- Who updates it and how often.
- Who reads it and what decision it feeds (reordering, paying staff, chasing a customer).
You will usually find two or three files that duplicate each other, plus one that nobody has touched in months. Mark the duplicates, decide which copy is the truth, and stop editing the others today. Moving three versions of the same list into a new system just moves the confusion.
Check: Can you name one person responsible for each list? If not, assign one before you move anything.
Step 2: Clean up your product and stock list first
For most retail shops, restaurants and trades, the product list touches everything else: sales, purchasing, stock counts and margins. Get it right first.
Work through your list and fix:
- Duplicate items. "Coke 12oz", "Coca-Cola can" and "COKE CAN" are probably one item. Pick one name.
- Consistent units. Decide whether you track by the case, the bottle or the pound, and stick to it for each item.
- Cost price and selling price for every item. Blank cost prices are the most common gap. Without them you can't see your margin.
- Categories. Keep them simple: a handful that match how you actually think about the business.
- Dead items. Anything you no longer sell should be marked inactive or removed, not left to clutter reports.
IslandFlow keeps a product and stock list with cost and selling prices for each item, so this is the shape of list you'd be working toward there too.
Check: Sort your list by cost price. Any item with a zero or blank cost needs attention before you move.
Step 3: Do a real stock count
A clean list with wrong quantities is still wrong. Pick a quiet day, or close early, and count what is physically on the shelves and in the back.
- Count by location if you have more than one shelf area, storeroom or branch.
- Have two people count high-value items separately and compare.
- Write down the date and time of the count. Your new system's opening stock should match that moment.
Expect differences between the count and your spreadsheet. Don't try to explain every one before you move. Record the counted figure as your opening balance and note the biggest gaps so you can watch those items closely in the first few weeks.
Check: Pick five items at random a week after the count and recount them. If they match what your records say, your process is working.
Step 4: Set up how money comes in and goes out
Next, decide how you'll record sales and expenses. Keep the structure plain:
- Income types: sales, services, delivery charges, whatever genuinely applies to you.
- Expense types: stock purchases, rent, utilities, wages, fuel, repairs, bank fees. Use the categories your accountant already uses if you have one. Ask them for their list.
- Payment methods: cash, card, bank transfer, cheque. Separating these makes it much easier to match against your bank statement.
Gather your opening balances from a single date: bank balances, cash on hand, what customers owe you and what you owe suppliers. Use the same date as your stock count if you can.
Check: Your opening bank balance in the new setup should match your bank statement to the cent for that date.
Step 5: Customers and suppliers
If you give credit to customers or buy on account, move those lists next.
- Merge duplicate customer and supplier entries.
- Confirm each outstanding balance against invoices, not memory.
- Note the payment terms you've actually agreed, not the ones you wish you'd agreed.
If you mostly sell for cash, you may only need a short supplier list. Don't build a customer database you won't maintain.
Step 6: Staff, hours and schedules
Staff information is sensitive, so treat it carefully. Move only what you need: names, roles, pay rates, start dates and the details your payroll process requires. Keep the original records somewhere secure rather than deleting them.
If you schedule shifts, write down how the rota really works before you rebuild it: who covers weekends, who can open, who can't work certain days. A new schedule that ignores those unwritten rules will get ignored.
Step 7: Tax and statutory settings
VAT and National Insurance obligations depend on your business, and the rules and rates can change. Don't copy a rate from an old spreadsheet or from memory. Before you set anything up, confirm current requirements with the Department of Inland Revenue for VAT and the National Insurance Board for NIB, and check with your accountant if you have one.
IslandFlow handles Bahamian VAT and NIB workflows alongside accounting, payroll, inventory, point of sale and staff scheduling. Whatever system you use, the settings are only as good as the figures you confirm from the official sources.
Step 8: Run old and new side by side, briefly
Don't switch off the spreadsheets on day one. For a short, fixed period, perhaps one or two weeks, record in both and compare at the end of each day:
- Do daily sales totals match?
- Does cash in the drawer match what the records say?
- Do stock levels for your top-selling items match?
When they match for several days running, set a firm date to stop using the old files. Then make the old spreadsheets read-only and keep them as an archive. Running two systems forever is worse than either one alone.
What to watch for
- Moving everything at once. Start with products, stock and money. Add the rest once those are steady.
- Moving history you don't need. Opening balances on a clear date usually matter more than years of old transactions. Keep old files archived for reference and for whatever retention period applies to your records; confirm that with the official source or your accountant.
- One person knows everything. Train at least two people on each daily task so a sick day doesn't stop the business.
- Skipping the bank check. Match your records to your bank statement weekly in the first month. Small errors caught early stay small.
- Price changes not recorded. When a supplier raises a cost, update the cost price that day, or your margins will look better than they are.
A quick checklist before you switch
- Every list has one owner.
- Duplicate products, customers and suppliers are merged.
- Every item has a cost price and a selling price.
- Stock is counted and dated.
- Opening bank and cash balances match your statement.
- Tax and NIB settings are confirmed with the official sources.
- Old and new records have matched for several days.
- Old spreadsheets are archived and read-only.
If you'd like to try this in IslandFlow, sign-up starts at islandflow.ai/start: the setup asks about the business, how it runs and the parts of IslandFlow you want, and creates your account last. The free trial is 14 days with no card.