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

How to Switch from QuickBooks in Tanzania: A Guide

5 min read Hostnali team

Moving accounting data from QuickBooks to NaliSuite in Tanzania

Tanzanian businesses in tourism and trade often keep QuickBooks for accounts and everything else in spreadsheets. When volumes grow, the gaps show up at month-end. A planned switch fixes that.

What you gain

QuickBooks, Xero and Sage keep your books. NaliSuite keeps your books and runs the rest of the business: CRM, quotations, accounting, invoicing with M-Pesa or Airtel Money payments, stock, the till, HR and payroll, on one login. See the full comparison on the switch from QuickBooks page.

Questions to answer before you start

  • What is your cut-over date, and is your accounts team happy with it?
  • Which reports does your accounts team need from you each month in Tanzania?
  • Will your accounts team work in NaliSuite, or should you keep a QuickBooks or Xero sync?
  • How many branches, tills and warehouses need setting up?
  • Are there old invoices to write off before you import?
  • Does payroll move now, or after the ledger?

An example from Tanzania

A safari outfitter in Arusha with 24 staff used QuickBooks for accounts and a spreadsheet for tours, with deposits in USD and TZS. Matching deposits to bookings took days. After the switch, each tour has its quotation, invoice and deposit in one place, in either currency, and M-Pesa payments are matched automatically.

Step 1: export what you need

From QuickBooks, Xero, Sage or Excel, export:

  • clients and suppliers, with contact details and tax numbers;
  • product lines and services, with prices and, for stock items, quantities on hand;
  • the chart of accounts;
  • a trial balance report at your cut-over date;
  • open invoices and bills (what customers owe you and what you owe suppliers);
  • employees, if payroll moves too.

Clean your data before you import

An import is only as good as the spreadsheet behind it. Before you upload:

  • merge duplicate customers (the same company entered twice with different spellings);
  • delete suppliers you have not used in years;
  • make sure every product has a code, a unit and a price;
  • check that tax numbers are in the right column and format;
  • write off old invoices you know will never be paid, with your accounts team’s agreement.

Step 2: import in the right order

Order matters because each record depends on the one before it:

  1. Chart of accounts (or map yours to NaliSuite’s country pack).
  2. Contacts: clients and suppliers.
  3. Product lines and services.
  4. Starting balances from the trial balance report.
  5. Open invoices and bills.
  6. Stock quantities and values.

Each import is an Excel or CSV upload where you match your columns to NaliSuite’s fields.

Step 3: run both for a month

For one month, keep entering in both systems, or at least compare the totals: sales, debtors, creditors and bank balances. When they match, stop using the old one. Most differences come from starting balances or a few invoices entered in one system only, and they are quick to find with the two side by side.

Tanzania-specific details

Tanzanian businesses should import TINs for customers and suppliers, keep their EFD or fiscal receipt arrangements as their accountant advises, and connect M-Pesa or Airtel Money through their own accounts. Price lists can be kept in TZS and USD.

Stock, the till and payroll

Accounting is only part of the move. Load opening stock per shop or warehouse into Inventory so the till and the ledger start from the same numbers, and set up the point of sale for each branch. If payroll moves too, add employees with their contracts and statutory numbers; statutory payroll works out PAYE, NSSF, SDL and WCF from the first pay run.

Your first month after the switch

Plan the first month carefully. Week one: invoicing and receipts from NaliSuite only. Week two: purchases and supplier bills. Week three: bank reconciliation and M-Pesa or Airtel Money payments. Week four: stock count, payroll and the comparison with the old trial balance report. Firms in Dar es Salaam and Arusha that follow this order rarely need to go back.

Mistakes to avoid when switching

  • No cut-over date. Without one, transactions end up in both systems or neither.
  • Importing all history. Bring balances and open items; keep the old software as an archive.
  • Forgetting stock values. Opening stock in the ledger must match the stock count.
  • Switching at the busiest time of year. Pick a quieter month.
  • Not telling staff. Show the team the new till and invoicing screens before go-live.

Keeping a sync instead of a hard switch

You do not have to switch everything at once. With the QuickBooks and Xero Sync add-on, NaliSuite handles sales, stock and payroll while QuickBooks or Xero stays your accounts team’s ledger. Many firms run like this for a year before moving fully.

Coming from Tally or Odoo

The Tally and Odoo migration add-on brings ledgers, items and parties across from Tally and Odoo, so you do not have to rebuild them by hand.

What it costs

NaliSuite plans start at TZS 5,500 a month, with all 17 built-in apps on every plan, so you are not paying separately for accounting, invoicing, stock and payroll. Compare that with what you spend today on licences and add-ons, and on the hours spent re-keying data between them.

Frequently asked questions

Can we invoice in USD and TZS?

Yes. Price lists and invoices can be in the customer’s currency.

What about our fiscal receipts?

Check with TRA and your accountant how your invoices and receipts must be issued; NaliSuite keeps the records in one place.

How long does a switch take?

A small business can import its lists and balances in a day or two. Plan a month of comparison before you retire the old system.

Try NaliSuite

Every NaliSuite plan includes accounting, invoicing, stock, POS, HR and payroll, from TZS 5,500 a month. Start a free trial, import your lists and see your own numbers in it, or compare the plans.

Keep reading

Related articles

Start your website with Hostnali

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