Free for 30 days: NaliSuite cloud ERP for your business
Client Login
ETB
Client LoginRegister
Business Software

Accounting Software vs Spreadsheets in Ethiopia

4 min read Hostnali team

Accounting software dashboard compared with a spreadsheet for businesses in Ethiopia

Spreadsheets are deeply rooted in Ethiopian offices. Many accountants learned their trade on Excel, and a well-built workbook in Addis Ababa can be a small work of art. So the question is not whether Excel is a good tool. It is whether it is still the right tool for your business today.

What Excel does well

It would be unfair to start with the problems. A spreadsheet is:

  • familiar, so staff need no training;
  • flexible, so you can model a new product line or price change in minutes;
  • cheap, because it is already on most office computers.

For budgeting, quick calculations and one-off analysis, Excel remains excellent. The question is about the books themselves.

What goes wrong when the books live in Excel

Bank transfers without narration

Customers pay by bank transfer, often without quoting an invoice number. Matching each birr credit to the right customer is slow, and payments end up in a suspense list that grows every month.

One file, many hands

A sales officer in Hawassa and a cashier in Addis Ababa both need to record transactions. Emailing a file back and forth creates versions that never quite agree.

VAT and receipting

Where you are registered for VAT, the 15% rate has to be applied correctly on each sale and purchase. Ethiopia also has rules on sales registers and receipting; which apply to you depends on your registration, so confirm them with the Ministry of Revenues or your accountant. A spreadsheet can calculate a figure, but it cannot link that figure to the document behind it.

Myths worth dropping

“Our accountant prefers Excel.” Most accountants prefer accurate books. With software they can be invited with access for your accountant to review and close the same ledger the business uses, instead of receiving files.

“We will lose control of our data.” The books stay in one place instead of in copies of a file on different computers, and every figure is posted from a real invoice, bill or payment.

“It is only for big companies.” Plans are priced for small teams, and a single office gets the same core apps as a large group.

What the switch gives an Ethiopian business

JobIn ExcelIn NaliSuite
Recording salesTyped after invoicingPosted when the invoice is issued
Bank creditsMatched by searchingImported and matched
VAT at 15%Calculated from totalsCalculated per line
Several usersShared fileOne set of books online
ReportsBuilt monthlyAlways available

The Accounting app keeps the double-entry ledger, Invoicing issues the documents and reconciliation brings bank statements in. Invoices can also carry a pay link so customers pay by card or bank through your own provider; see online payments.

Planning the move around your financial year

Ethiopian businesses often prefer to switch at the start of a new financial year so that the year’s figures sit in one system.

  1. Close the year in your workbook.
  2. Export customers, suppliers and items.
  3. Import them and post the closing balances as opening balances.
  4. Enter any invoices and bills still open.
  5. Begin the new year in the software.

The switching guide has notes for anyone moving from QuickBooks, Sage or Tally.

A second example: an Adama flour mill

A flour mill near Adama buys wheat from traders, mills it and sells flour to bakeries and wholesalers on credit. Purchases are weighed and paid by bank transfer, and bakeries pay when they can. The mill’s spreadsheet recorded quantities in one workbook and money in another, so the cost of each tonne of flour was always an estimate.

In software, wheat purchases are bills that add stock, the milling step can be tracked with the Manufacturing add-on, and sales to bakeries are invoices that take flour out of stock again. Bank transfers are matched to the right bakery’s invoices. The owner can see stock, debts and profit in one place.

Ethiopian checklist before switching

  • Choose a start date at the beginning of the Ethiopian financial year, or a month that is easy to close.
  • Confirm with your accountant how VAT at 15% and any receipting rules will be handled.
  • Collect the TINs of business customers and suppliers.
  • List every bank account used for receipts, so reconciliation covers all of them.
  • Decide who records sales, who records purchases and who reviews the books.

Frequently asked questions

Can we keep using Excel for budgets?

Yes. Many businesses keep Excel for planning and use the software for the books. Lists can be exported to Excel or CSV whenever needed.

Is training needed?

Very little. Staff who can use Excel usually pick up invoicing and payments within a day.

Can amounts be shown in birr?

Your books and invoices use your local currency, with the option to invoice foreign customers in theirs.

Can we record purchases from traders who do not issue invoices?

Record each purchase as a bill with whatever document you receive, and ask your accountant how such purchases should be treated for tax.

Try NaliSuite

Keep Excel for what it is good at and move the books somewhere safer. Plans start at ₵25 a month, with a free trial. View the plans.

Keep reading

Related articles

Start your website with Hostnali

Hosting, domains and 24/7 support from one team.