KinMol vs Excel
A spreadsheet is flexible and you already know it. KinMol keeps the same records, ties them together, and lets your team work in them at once.
Many shops keep sales and stock in an Excel sheet: a row per sale, a sheet per month, formulas for the totals. It does exactly what you build it to do.
Side by side
Ringing up a sale
- Excel sheet
- Typed into a row, with the price typed by hand.
- KinMol
- Tap items at the till. Prices come from your list and are set by the server, so nobody sells at a price you did not set.
VAT
- Excel sheet
- Formulas you set up and check yourself.
- KinMol
- VAT at 13% or zero, set per item and worked out on every bill. The VAT sales and purchase books download in IRD’s format as Excel or PDF.
More than one person
- Excel sheet
- One file. Copies drift once it is sent around.
- KinMol
- Everyone works in the same records at once, and each person sees only what their role allows. The database enforces it.
Stock
- Excel sheet
- Updated by hand after each sale.
- KinMol
- Each sale updates the count, by branch, with sizes and colours, batches and expiry.
The books
- Excel sheet
- A separate sheet, or a separate program.
- KinMol
- Double-entry books in the same place: trial balance, profit and loss, balance sheet and the day book.
Getting data out
- Excel sheet
- It is already a spreadsheet.
- KinMol
- Download sales, stock value, the day book, purchases, expenses and suppliers as CSV or Excel.
When it may still suit you
If you build your own models and reports, keep Excel for that. Download from KinMol into it whenever you need to.
Moving from Excel
- 1
Bring your items across
In Stock, open Import stock and choose a CSV or Excel (.xlsx) file. Download the template there so the columns match. KinMol reads these columns: name, item_type, subtype, sku, unit, price, cost, vat, opening_count, reorder_level, batch_no, expires_on, brand, size, colour, details. Common names such as item, product, MRP, qty and code are understood too.
- 2
Check, then import
Up to 5,000 rows a file. KinMol checks every row and tells you which ones have a problem before you import. Rows go in batches of 50, and any row that fails is listed with the reason.
- 3
Customers and suppliers
Import customers and suppliers from an Excel or CSV file on their own pages, with a check of every row first.
- 4
Your books
In Accounts, open Import. Bring ledgers with their opening balances (name, group, code, opening, phone, email, pan), what each customer and supplier owed you (kind, name, amount, currency, fx_amount, rate, pan, phone, email), or unpaid bills (kind, name, bill_no, bill_date, amount, phone, email). CSV, Excel or a Tally XML export, up to 5,000 rows a file.
Every claim about KinMol on this page is something that works today. See exactly what is live and what is not. See what’s live
Other comparisons
Try it with your own items
Free to run your business on. Import your sheet, ring up a sale, and see the books.
Start free