Philip Wafula

Independent Accountant and Accounting Consultant. A DIY enthusiast

[Josh (Your CFO Guy) @YourCFOGuy]

🚨 I Built the World's GREATEST PivotTable... and You Can Get it FREE! 🚨

They said it couldn't be done...

I combined AI, Power Query & DAX to create something that shouldn't be possible:
A PivotTable system that handles your ENTIRE financial analysis in ONE CLICK.

You can analyze your entire profit and loss and drill down to multiple levels all the way to your transactions. Compare values against prior period, prior year, and even your budget - all updating with just ONE click.

This is easily worth hundreds (but you won't find it anywhere else, I've looked)

But for the next 48 hours only, I'm giving it away FREE 🎯"

Here's what makes it INSANE:
✨ ONE-CLICK updates for ANY time period
✨ Complete drill-down to transaction level
✨ Instant Prior Period & YoY comparisons
✨ Auto-calculating variances
✨ Budget vs Actual analysis
✨ Smart department filtering

The magic? I combined Power Query, Power Pivot, and AI assistance to build a system that:

- Updates your ENTIRE P&L instantly
- Drills down from summary to detail in seconds
- Compares against ANY period automatically
- Makes budget variance analysis a breeze

No more:
❌ Manual period adjustments
❌ Complex formula building
❌ Multiple spreadsheet versions
❌ Messy budget comparisons

Built with:
📊 Advanced DAX measures
📊 Smart data relationships
📊 AI-optimized formulas
📊 Automated refresh logic

Want the step by step tutorial + the template?

1. Like this post
2. Comment "send" below
3. Get immediate access

(Must follow, otherwise I can't DM)

[Africa First @AfricaFirsts]

Thread of interesting maps about Africa you haven't seen 🧵

1. Africa's Religious Divide.

[Philip Wafula @WafulaPhilip]

@ElayneOkaya Indian swahili

[Philip Wafula @WafulaPhilip]

@KRACare Hi, have you stopped processing MPESA payments?

[Philip Wafula @WafulaPhilip]

@KRACare are you aware that we cannot get emails from you. Including approved PIN applications

[Man - Like - Sparta @TomaSparta]

Retweet if you felt an #earthquake in nairobi

[Philip Wafula @WafulaPhilip]

@ntsa_kenya good afternoon, pls share an update of my digital license application made on 5/8/22 RCT # 009655449.

[Vala Afshar @ValaAfshar]

The ability to fold clothes properly is an important life skill https://t.co/BTLoWVm6sz

[Philip Wafula @WafulaPhilip]

@KRACare @greenXperience_ Finally!!!

[John W. Rich (Wealthy) @Cokedupoptions]

If FTX used a Big 4 Accounting Firm instead of Quickbooks, they could have kept the fraud going for a few extra years

[Val Katayev @ValKatayev]

Did you know there is a shadow bank that oversees $21 TRILLION of the world's money?

It has a dominating stake in every major S&P 500 company.

It directs Trillions for the Fed, Central Banks, and Govt Treasuries.

The global financial ecosystem is ruled by this ONE COMPANY.

[Clint Murphy @IAmClintMurphy]

I've spent 22+ years studying Finance with the last 7 as a CFO, and

I'll teach you How to Read a Balance Sheet in the next 7 minutes:

[Ross Harkness @THEROSSHARKNESS]

1. Get up at 6am
2. Put your phone away
3. Do 3 hours of deep work
4. Have all your tasks done by 9am

Then do whatever you want with the rest of your day.

[Mbabz @Kalasinga_]

That old muhindi lady that usually stops motorists to ask for money to buy some fuel upgraded to this Vitz.

[Prime Video Sport UK @primevideosport]

EXCLUSIVE CLIP
The atmosphere at Anfield can be intense 🔥

So Mikel Arteta prepares his players by blasting out You’ll Never Walk Alone during training 🎶 #AONArsenal

[SIA @Nymahsemoh_]

Jana we used the Express way from Entebbe to Jinja Exit past Kampala which was more than 50km. We paid 5000Ugksh ( 166ksh) Kanairo tunaibiwa 😂😂😂😂!!

[Afrisphere @Afri_shere]

How long will it take for @googlemaps to distinguish the main Mombasa road from the Nairobi Expressway in its directions and traffic estimates? via @JohnKieti #kenyantraffic

[Liverpool FC @LFC]

Few supporters have seen as much as this man in our 130-year history.

Ken Hirst: 90 Years A Red 🔴

[Mwango Capital @MwangoCapital]

Want to get into brokerage?
It is not an entirely profitable venture.

[Chart by @mwangoanalyst]