Amaka runs a catering business in Abuja. Every week she opens the same Excel file, copies last week's invoice, changes the customer name, updates the items, tries to remember whether this client gets a 5% discount, manually calculates the VAT, and then saves it as a PDF — if she can find the right export button.
She has been doing this for three years. She does not know how many invoices she sent last month without being paid. She does not know how much VAT she has collected this quarter. And twice in the last year, she sent a client the wrong invoice number because she forgot to update it after copying.
If any of this sounds familiar, this post is for you.
Excel is not a bad tool. It is a spreadsheet — built for calculations, data analysis, and financial modelling. It is genuinely excellent at those things.
Invoicing is not those things.
Invoicing requires:
Excel does none of these automatically. You are doing all of it manually, every time, and every manual step is a chance for an error.
The real cost: If invoicing takes you 20 minutes in Excel and 3 minutes in proper software, you are spending 17 minutes per invoice on work a computer should do. For a business sending 10 invoices a week, that is nearly 3 hours every week — over 12 hours a month — doing repetitive manual work.
Duplicate invoice numbers are a real problem. If you send two invoices with the same number, your accounting is wrong, your client may pay the wrong one, and NRS (Nigeria Revenue Service) will question your records in an audit. Proper invoicing software assigns numbers automatically and never repeats one.
VAT in Nigeria is 7.5%. That sounds simple. But what about invoices that mix VAT-exempt items and taxable items? What about when a client pays in dollars and the exchange rate changes? What about late fees added after the fact? Each of these scenarios requires manual recalculation in Excel. Software handles all of it instantly.
When Amaka wants to know who has paid her, she opens five different Excel files, checks her bank app, and tries to remember which WhatsApp message was a confirmation. There is no single view of outstanding invoices. Proper invoicing software shows you exactly who owes you, how much, and since when — in one screen.
Every new invoice starts with retyping the client's name, address, and email. If the client changes their business address, you may send three invoices to the wrong address before anyone tells you. A proper system stores client details once and fills them in automatically.
Excel PDFs look like Excel PDFs. They do not have your logo, consistent margins, or a professional layout. Clients notice. First impressions matter — an invoice is a document your client sees every time you ask them to pay you.
Since 1 January 2026, the Nigeria Revenue Service (NRS — previously called FIRS) has been pushing Nigerian businesses toward e-invoicing compliance. A compliant invoice needs:
Excel can produce a document with all of these fields. But it will never guarantee they are filled in correctly, in the right format, every time.
This is the question that stops most people. "I have three years of invoices in Excel — do I lose all of that history?"
No. You do not need to migrate old invoices. Here is the practical approach:
① Pick a start date — the first of next month works well. All new invoices go into Lucrive.
② Keep your Excel files as an archive — you can still open them if a client disputes an old invoice. You are not deleting anything.
③ Set up your business profile once — enter your business name, address, TIN, logo, and bank account details. This takes about 10 minutes and you never do it again.
④ Add your regular clients — create a client record for each business or person you invoice regularly. Takes 2 minutes per client.
⑤ Create your first invoice — select the client from your saved list, add the items, and Lucrive calculates the VAT and total automatically. Your first invoice will take about 3 minutes. Your tenth will take 90 seconds.
Let us walk through Amaka's weekly invoice for a corporate catering client.
In Excel:
Total: ~17 minutes
In Lucrive:
Total: ~3 minutes
Over 40 invoices a month: 680 minutes saved vs 120 minutes. That is nearly 9 hours of your month returned to you.
Lucrive's free plan includes 10 invoices every 30 days — enough for many MSMEs to get started without spending anything. If you send more than 10 invoices every 30 days, the Professional plan gives you unlimited invoices, along with additional features like expense linking and full financial reporting.
Start free: You do not need a credit card to sign up. Your first 10 invoices every billing cycle are completely free.
This is where Lucrive's invoice tracking earns its value. Once you send an invoice:
No more digging through emails. No more "I think I sent it..." No more embarrassing moments where you realise you never actually sent an invoice you thought you had.
Honestly? Habit. Excel is familiar. Changing a workflow takes a few days of mental adjustment even when the new way is clearly better.
The way to make it stick: do not try to use both. Pick your start date, create your Lucrive account, and send your very next invoice from there — not from Excel. The second time will feel easier. The fifth time will feel natural.
Amaka made the switch in January. By March, she told me she could not believe how much time she had been wasting. She can now see, in one glance, that she has four outstanding invoices totalling ₦480,000 — and she knows exactly which clients to follow up with today.
That kind of visibility is not possible in Excel. Not without building a whole separate tracking system.
Lucrive is built specifically for Nigerian MSMEs. invoices with TIN and VAT fields, automatic VAT calculation, client management, and PDF generation — all in one place, all free to start.
Create your first invoice at lucrive.io →
It takes less time than formatting your next Excel template.
People and businesses in our examples are illustrative, not real Lucrive customers. Figures are worked examples: confirm your own position with a qualified tax adviser.