Many shops start their accounts in Excel, and that is not a mistake. The file is familiar, it works on the computer without the internet, and it lets the owner arrange items and debts as they wish. The problem does not appear in the first week, but when the business grows: more than one person sells from different copies, customer debts accumulate, the item balance changes with every invoice while the spreadsheet is updated at the end of the night, and the tax authority asks for a report from the invoices themselves, not from a total recalculated at the end of the period.
The question is not “Is Excel bad?”, but: when is it still enough, and when does the cost of a mistake in it exceed the cost of accounting software? What follows is a practical discussion of moving lists from spreadsheets into common programs, with Sonbola as one local example among others.
When is Excel still enough?
Excel is a calculation and display tool, not a journal. It works for as long as the movement is light and one person holds the file: a limited number of invoices, most of them cash, stock counted periodically, and no detailed tax return yet, or the accountant prepares it from a small set of documents.
It also remains useful after you switch, for analysis or for preparing a list before import. The free Excel templates are starter lists for a preview, not the import template; use the template downloaded from the account.
Five signs the file is no longer enough
More than one person is editing, and you now have copies. The cashier sells from one sheet, and the accountant updates a copy on another computer. The spreadsheet does not prevent simultaneous writing, and it does not keep a clear log: who changed the price, when, and what the previous value was.
The balance in the file does not match the shelf. You sold a box and the quantity did not fall, or you moved a carton to the second warehouse by editing a cell. The error shows up at stocktaking. Inventory software assumes that the sales invoice itself reduces the balance in its warehouse.
Credit sales with no limit and no ageing. The “they owe us” sheet grows, and the customer disagrees with you because the statement is not tied to the invoices.
Sales are high and the till is low, and you do not know where the difference is. This is not necessarily theft or a loss. A credit invoice raises sales and does not bring cash in at that moment, and collecting an old debt raises the till without being today’s sale. Sonbola’s guide “High sales, little cash” separates three figures: the value of the sale, what was collected, and what remains on customers. If you mix them in one cell, nothing will warn you.
Tax or e-invoicing asks for a document from a system. In Saudi Arabia this is integration with the Fatoora platform; in the UAE there is a difference between a PDF file and an e-invoicing system; and in Jordan the national e-invoicing system is expanding. The spreadsheet may calculate the rate, but it does not issue a sequential invoice tied to the item’s tax, and it does not prevent deletion after issue as some systems require.
If two or more of these signs appear regularly, what you need is a document that posts its effect to stock and accounts at the same moment, not a tidier arrangement of columns.
The real difference: the spreadsheet records, the software posts
In Excel you type the number. If you forget to reduce the quantity, or to add the payment to the customer’s statement, the file still looks “correct”.
In accounting software, a sales invoice is not a row in a list: it reduces the quantity in its warehouse, increases cash or the customer’s debt, posts the tax to its account if tax is enabled, and the amount appears on the account statement. Invoice-line profit then differs from the shop’s net profit after expenses and returns, as the invoice-profit guide explains. That difference is what justifies the switch, not the look of a reports dashboard.
Moving from Excel: lists are one thing, balances another, history a third
The common mistake is to import the names and assume that the debts and the year’s movement came with them. There are three layers:
- Lists: items, customers and suppliers, and the chart of accounts.
- Opening balances on one agreed date: the quantity and value of each item, cash and bank, what customers owe and what is owed to suppliers. Importing the name alone does not transfer the debt, as the opening-balances guide and the guide to preparing an import in Sonbola Web explain.
- Previous history (old invoices and payments): most shops do not need to re-enter every old invoice. The better path is usually to agree with the accountant on an approved balance at the cut-off date, then go live from the next day.
Start with a copy, not the original, lock barcodes and mobile numbers as text so leading zeros are not dropped, review duplicates, then test a small sample before the full list.
How do common programs take an Excel file?
The programs below accept lists from a spreadsheet file. The difference is the format, what is imported beyond the lists, what happens if a row fails, and how an opening quantity is defined. This relies on their published documentation. We reviewed it on 13 November 2026.
Sonbola: a preview, then a single write that can be undone
In the desktop edition’s Excel import lesson, the path is “System data › Excel import”. One of three things is imported from an .xlsx or .xls file: contacts (customers, suppliers or employees), items, or the chart of accounts. The steps are: the file, column mapping, the preview, then the result. The documentation states: “No row is written before the operation succeeds in full”, and the import can be undone for as long as the records have not yet been used.
If the items file includes an opening quantity with the warehouse, a single opening-balance voucher is created. If the customers file includes balances with their accounts, a single opening entry is created. That combines lists and balances in one path, provided the warehouse and the accounts are chosen in the mapping.
In Sonbola Web, setup provides templates and reads xlsx, xls and CSV, with mapping and a preview. The guide states clearly that importing a customer list “does not mean posting all of their invoices, payments and history”, and that balances are prepared in a separate step. Details may differ between the desktop and web editions.
The desktop edition runs locally, so selling remains possible without the internet, as it was with the Excel file. For a wider comparison, see How do you choose accounting software for your shop? and working without the internet.
Zoho Books: an import per module, after inventory tracking is turned on
According to the Zoho Books import guide, you choose the module, upload a CSV, TSV or XLS file, map the columns, then preview before importing. The items guide explains that inventory tracking is turned on so that quantity is updated with sales and purchase invoices, and that import supports an opening stock. The guide to migrating from other systems requires tracking to be enabled first, and that the inventory start date matches the opening-balance date. The software is cloud-based: day-to-day work needs a connection after the move.
QuickBooks Online: an import order, and inventory cost on a FIFO basis
The common import questions say that QuickBooks Online accepts CSV, Google Sheets or XLS/XLSX, and that lists are imported in this order: the chart of accounts first, then customers, then suppliers, then products. Inventory tracking is in the Plus and Advanced plans. The guide to moving lists distinguishes the desktop product, which uses average cost, from the online product, which uses first in, first out (FIFO): importing the quantity creates a starting transaction dated on the import date, and no inventory effect can be recorded before that. If your shop costs stock another way, the accountant should review this difference before the move. A wider comparison is in Sonbola vs QuickBooks Online.
Odoo: a wide import, a test before you run it, and no automatic undo
The Odoo 19 export and import document says that data is imported into most objects from Excel (.xlsx) or CSV, including contacts, products, journal entries and orders. The path is: upload the file, map the columns, then “Test”, then “Import”. It warns that the import is permanent and cannot be undone, with the option of filtering records by creation date. Large files may hit a timeout, so they are split into batches. An external ID allows a record to be updated later instead of creating a duplicate. A flexible import does not replace setting up the sales, inventory and accounting apps first.
Daftra: several formats, and a warning about Arabic encoding in CSV
The Daftra guide to importing data from Excel accepts CSV, XLS and XLSX, and reads only the first sheet. It recommends downloading the sample, making the first row the headings, and writing dates in the account’s format or as 2026-01-31. Because Arabic is sometimes corrupted in CSV, it asks you to save the file with UTF-8 encoding or to use XLSX. After mapping, a result appears with the number of successes and failures and the row number. Some types — including customers, products, invoices and journal entries — run in the background. Invoices, not only lists, can therefore be transferred; and a messy file transfers the mess into the books.
Qoyod: a ready-made template whose format must not be changed, with the result by email
In the Qoyod help centre, import is done through an Excel template downloaded from the screen for products, services, expenses and bundles. The products category is created in the system first and then linked in the file, and required fields are filled in; if the product is stocked, sales and purchase prices must not be left blank. The documentation warns against changing the template’s formatting, and says that an error is emailed to the person who uploaded the file. The path is closer to “fill in our template” than to mapping the columns of your own free-form file.
What do these differences mean for a shop owner?
There is no single “best import” in the abstract. Three questions are enough:
- Do I see the error before it is written? Desktop Sonbola writes nothing until the whole batch succeeds, and allows an undo if the records have not been used. Odoo offers a test, then warns that the import is final. Daftra and Zoho show a preview or errors by row.
- Do I need to move old invoices, or only balances? Daftra and Odoo document the import of invoices or journal entries. Sonbola Web states that a customer list does not post their history. For most shops, a sound opening balance is enough.
- Where will I work after the move? Cloud software (Zoho Books, QuickBooks Online, Daftra, Qoyod) continues in the browser and needs the internet. Local software stays closer to the Excel habit if connection cuts are common in your shop.
Ask for the cost in writing for the size of your business, and try a sample before you close the old file. In Sonbola the package depends on the nature of the work, and the listed price starts from two hundred dollars, with a temporary trial and no permanent free plan for the shop.
A half-day test before you leave the file
On a trial copy or a training company:
- Import twenty items and ten customers from a cleaned copy of your file.
- Issue a cash invoice, a credit invoice, a purchase invoice, and a return for one item.
- Review the item balance, the customer statement, the till, and a simple sales or tax report.
- Match four figures with what you would have calculated by hand in Excel. If they differ, find the reason before you import the full list.
- Keep the final Excel file — after the cut-off date — for reading, and stop selling on it so you are not keeping two books for the same day.
Frequently asked questions
Should I keep using Excel after I switch?
Yes, for analysis or for review lists. Stop selling and updating balances on it, so it does not conflict with the software.
Does importing items and customers also transfer their debts and old invoices?
No. Lists transfer names, barcodes and prices. Debt and movement need opening balances or a document import, depending on what each program supports. In Sonbola Web, import does not post invoice and payment history.
Should I re-enter every invoice from last year?
Usually not. Agree with your accountant on a cut-off date and approved balances, and start from that date. Re-entering the full history is worthwhile only if an auditor or an official body asks for it.
A CSV file shows Arabic as broken characters. What should I do?
Save it with UTF-8 encoding, or use the Excel format (.xlsx). Daftra states this explicitly, and it is common in any program that reads CSV.
How long does the move take for a shop with a few thousand items?
Preparing the file and reviewing duplicates takes longer than the upload. Test a small sample, then upload the list after you have corrected the preview errors.
Sources
- Sonbola: From Excel to Sonbola Web — prepare your data before importing
- Sonbola: Excel import in the desktop edition (user guide)
- Sonbola: Opening balances before switching
- Sonbola: The difference between sales and collections
- Sonbola: Invoice profit is not the shop’s net profit
- Sonbola: How do you choose accounting software for your shop?
- Zoho Books: Import Data into Zoho Books
- Zoho Books: Items — inventory and import
- Zoho Books: Migrate to Zoho Books from other systems
- QuickBooks Online: Common questions about importing data
- Intuit: Move your lists from QuickBooks Desktop to QuickBooks Online
- Odoo 19: Export and import data
- Daftra: Importing data from Excel — preparing the file and mapping columns
- Qoyod: Importing products, services and expenses with an Excel template