Why I Built a Professional Finance Toolkit Instead of Buying One: The Honest Story

I have looked at hundreds of Excel finance templates.

Not exaggerating. Hundreds. Gumroad. Etsy. Creative Market. Google searches at eleven at night when I should have been sleeping. Templates with beautiful dashboard designs and colour schemes that looked like they were made by someone who spent more time choosing fonts than understanding what a profit and loss statement actually is.

I kept downloading them. I kept opening them. And I kept closing them within ten minutes because the same problem appeared every single time.

They were built by designers pretending to be accountants.

Clean. Pretty. Professionally formatted. And fundamentally broken in ways that only someone who has actually managed real money across real financial systems would immediately recognise.

Formulas that referenced themselves and created circular errors the moment you entered real data. Currency conversion that assumed everyone earned in dollars and spent in dollars. Category structures copied from American personal finance blogs that had no relevance to anyone managing income across East Africa. P&L statements that looked correct until you compared them to ACCA standard financial reporting and realised they were missing entire sections that any qualified accountant would consider non-negotiable.

I kept buying them anyway. Because the alternative was building from scratch and I had enough going on already.

What I actually used at work

At Hodan Global Money Remittance in Nairobi I managed over a million dollars in international transfers every single month. The financial tracking systems we used were not beautiful. They were functional. Built by people who understood that a finance tool is not a design project. It is a system that has to work correctly every single time because real money depends on it.

At Continental Forex Bureau I managed daily transactions of up to one hundred and fifty thousand dollars. Zero discrepancies over three years. That discipline does not come from a pretty dashboard. It comes from systems that are structurally correct. Systems where every formula does exactly what it says it does. Systems where the closing balance at the end of the day matches reality to the cent.

At Hyperloop Haulier in Zambia I prepared financial statements for a logistics company running more than fifty trucks across six countries. Six countries means six currencies. Six currencies means exchange rate management is not an afterthought. It is the foundation of every financial calculation in the entire system.

I used Excel for all of this. Not QuickBooks. Not Xero. Not any of the cloud accounting platforms that the YouTube tutorials recommend. Excel. Because Excel is universal, flexible and does exactly what you tell it to do without a subscription fee and without requiring an internet connection in locations where internet connections are unreliable.

The moment I decided to build my own

I was sitting in Dar es Salaam trying to track my EarnNomad HQ income properly. Fiverr earnings in dollars. Gumroad sales in dollars. Affiliate commissions in dollars. Writing income in pounds from a UK client. A small project payment in Kenyan shillings from a contact in Nairobi.

I opened the most recent template I had downloaded. A beautifully designed thing that had cost me fifteen dollars and had four stars from thirty seven reviews on Etsy. I tried to enter a Kenyan shilling payment.

There was no currency conversion functionality. The template assumed a single currency. The workaround suggested in the instructions was to manually convert everything to dollars before entering it.

Manually convert. Before entering.

I am an ACCA part qualified accountant with a BSc in Applied Accounting from Oxford Brookes University in the UK. I have managed foreign exchange operations professionally for years. And this fifteen dollar template was asking me to manually convert currencies before entering data into a finance tracking system.

I closed the template. I opened a blank Excel workbook. And I started building.

What I built and why it is different

The Professional Multi Currency Business Finance Toolkit took me longer to build than I expected. Not because the technical work was difficult. Because I kept going back and adding things that I realised were missing only when I tried to use the toolkit for real financial tracking and discovered the gap.

The Currency Module came first. Thirty two currencies. Pre-loaded exchange rates. A VLOOKUP system that pulls the correct rate automatically the moment you select a currency in any other sheet. Update one rate in the Currency Module and every transaction in every sheet recalculates instantly. That is how currency conversion should work in a professional finance tool. Not manually. Automatically.

The Income Tracker came next. Not just amount and date. Client name. Project description. Income category. Invoice number. Currency. Local amount. Exchange rate pulled automatically. USD equivalent calculated automatically. Payment status selected from a dropdown. Everything a freelancer or consultant managing multiple clients across multiple currencies actually needs.

The Expense Tracker followed the same logic. Category dropdown with sixteen options that reflect real business expense categories not American personal finance blog categories. Payment method dropdown that includes mobile money, Wise and Payoneer alongside the standard options that Western templates include. Billable flag for expenses that can be recovered from clients. All converting to USD automatically.

The P&L Statement was the one I was most particular about. Because I have seen too many Excel templates with P&L statements that are structurally incorrect. Missing the distinction between gross profit and operating profit. Conflating cost of sales with operating expenses. Using category structures that would make any qualified accountant uncomfortable.

Mine follows ACCA standard presentation. Revenue. Cost of sales. Gross profit. Gross margin. Operating expenses broken down correctly. Operating profit. Tax. Net profit. Every line pulling automatically from the Income and Expense trackers. Zero manual calculation required.

The Invoice Tracker solved a problem I was experiencing personally. The gap between sending an invoice and receiving payment is where freelance income gets lost. Not because clients are dishonest. Because nobody has a clear system for tracking which invoices are outstanding, which are overdue and which clients need a gentle reminder. The Invoice Tracker gives you that system. Payment status dropdown. Due date tracking. Overdue visibility. Complete payment history by client.

The Cash Flow sheet, the Financial Goals tracker and the Dashboard came together as the system that ties everything else into a coherent financial picture. Open the dashboard and see your total income, total expenses, net profit, profit margin, cash position, burn rate and financial health status. All from data entered once in the individual sheets. All updating automatically.

Nine sheets. Thirty two currencies. ACCA standard financial reporting. Built by someone who has actually managed real money at scale across East Africa and who needed this tool to exist before it did.

Who this is for

This toolkit is not for African freelancers making their first hundred dollars online. That is not the audience I built it for.

It is for global business owners, consultants, remote workers and entrepreneurs managing income from multiple clients in multiple countries in multiple currencies who are tired of finance tracking systems that were built by people who have never actually managed money professionally.

It is for the UK based consultant with clients in three countries. The UAE business owner managing income in dirhams, dollars and euros simultaneously. The Australian remote worker receiving pounds from a London client and dollars from a New York client. The East African professional building international income and needing a tool that handles the multi-currency reality of that income without requiring manual conversion at every step.

It works for anyone. In any currency. In any country.

Twenty nine dollars. One time payment. Instant download. Thirty day money back guarantee.

The link is here: buildingafrica.gumroad.com/l/multi-currency-finance-toolkit

And if you are the kind of person who wants to understand what is inside before deciding whether it is right for you — I published a complete video walkthrough on the EarnNomad HQ YouTube channel showing every single sheet with real data entered. Watch that first. Then decide.

Follow the full EarnNomad HQ journey at buildafricanow.blogspot.com and on Twitter at @EarnNomadHQ.

---