Hello and welcome to my official channel.
My name is Amaka Ifebunandu, a practising professional accountant based in Nigeria.
In this channel, you will learn basic to advanced Excel, Accounting Basics, Relevant Accounting Softwares and access to all Excel templates demo videos.
Basic to Advanced Excel skills will help you achieve more task in less time.
Practical knowledge of the basic accounting will help you manage your finance properly and make the right decisions.
Accounting software tutorials to gain easy mastery of it.
The Excel templates video will serve as a step by step guide on how to use each of the templates.
Send your Accounting & Excel questions, concerns, and problems to info@accountingonexcel.ng
New videos every week -- make sure to SUBSCRIBE, and turn on the notification bell so you don't miss a thing!
This channel is dedicated to educating and equipping you with all the skills and tools needed to Take Charge of Your Business & Personal Finance
Amaka Ifebunandu (dexcelcoach)
Which overhead cost changes with production activity?
5 days ago | [YT] | 2
View 0 replies
Amaka Ifebunandu (dexcelcoach)
Which cost is most often misclassified in a Manufacturing Overhead Budget?
1 week ago | [YT] | 0
View 0 replies
Amaka Ifebunandu (dexcelcoach)
Which of the following will most likely distort the Direct Labour Budget, even if production volumes are correct?
1 week ago | [YT] | 0
View 0 replies
Amaka Ifebunandu (dexcelcoach)
A company increases its production volume, but the standard labour hours per unit remain unchanged.
What happens to the Direct Labour Budget?
1 week ago | [YT] | 0
View 0 replies
Amaka Ifebunandu (dexcelcoach)
A company plans to produce 1,000 units of a product. Each unit requires 2.5 yards of material.
What is the budgeted material usage?
2 weeks ago | [YT] | 1
View 0 replies
Amaka Ifebunandu (dexcelcoach)
In a well-structured Excel budget model, why should assumptions be kept separate from calculations?
2 weeks ago | [YT] | 2
View 0 replies
Amaka Ifebunandu (dexcelcoach)
Which of the following best explains why production is not equal to sales in a manufacturing budget?
3 weeks ago | [YT] | 1
View 0 replies
Amaka Ifebunandu (dexcelcoach)
A company budgets sales of 300 units in January. Policy requires 10% of February sales to be held as closing inventory. February sales are forecast at 280 units.
What is the required closing inventory for January?
3 weeks ago | [YT] | 3
View 0 replies
Amaka Ifebunandu (dexcelcoach)
Most budgeting errors do not start in Excel.
.
.
.
They often begin with a limited understanding of how sales and production budgets interact.
.
.
Consider the following simple example from my current Budgeting in Excel series.
.
.
A manufacturing company produces Big, Medium, and Small luggage bags.
.
.
For January:
Budgeted sales for Big bags = 300 units
Management requires 10% of next month’s sales as closing inventory
This means production is not equal to sales.
Production must cover:
✔ Budgeted sales
✔ Plus required closing inventory
✔ Minus opening inventory
If you miss this logic, every budget that follows will be wrong:
✔ Materials budget
✔ Labour budget
✔ Overhead budget
✔ Cash budget
That is why in my latest tutorials, I:
✔ Build the Sales Budget properly first
✔ Then show how the Production Budget is derived directly from it
✔ Use Excel formulas, not manual calculations
✔ Structure the model so that one change in assumptions updates everything automatically
This is not a theory.
This is how budgeting is done in real organisations.
If you work in:
✔ Finance or accounting
✔ Manufacturing or operations
✔ NGO or donor-funded projects
✔ Or you are a student preparing for management accounting
You need to understand this properly.
🎥 Sales Budget in Excel (Part 1) 👇
https://youtu.be/CcQmfBfIl3k?si=Wvc6X...
🎥 Production Budget in Excel (Part 2) 👇
https://youtu.be/N0Xwm6ERa8w?si=zKoCn...
Watch them now and re-watch before the next lesson drops.
#BudgetingInExcel
#SalesBudget
#ProductionBudget
#ExcelForAccountants
#ManagementAccounting
#FinanceProfessionals
#PracticalAccounting
#DexcelCoach
3 weeks ago | [YT] | 4
View 0 replies
Amaka Ifebunandu (dexcelcoach)
Payroll Case Study: ₦6 Million Annual Salary under the New Nigeria Tax Law (2026)
One of the most effective ways to understand the New Nigeria Tax Law (effective January 1, 2026) is to see how it affects real payroll numbers.
Let’s walk through a simple payroll case study that I also demonstrate in my PAYE and Payroll Template tutorials.
Case Study Details:
Annual salary: ₦6,000,000
Employee is rent-paying and qualifies for maximum rent relief
Under the old tax law
Consolidated Relief Allowance (CRA):
20% of ₦6m (₦1.2m) + ₦200k = ₦1.4m
Taxable income = ₦6m − ₦1.4m = ₦4.6m
Annual PAYE = ₦896,000
Under the new tax law (2026)
CRA removed
Rent relief applied = ₦500,000 (maximum allowed)
Taxable income = ₦6m − ₦500k = ₦5.5m
Applying the new progressive tax bands:
First ₦800k @ 0% = ₦0
Next ₦2.2m @ 15% = ₦330,000
Remaining ₦2.5m @ 18% = ₦450,000
➡ Total PAYE = ₦780,000
Key Insight
Despite the taxable income appearing higher, the employee pays ₦116,000 less tax annually under the new law, resulting in a higher take-home pay.
This is exactly where many payroll errors occur:
CRA is still being applied
Incorrect use of new tax bands
PAYE figures not flowing correctly into payslips
How This Is Handled in Practice
In my PAYE video tutorial, I demonstrate how this computation is performed step-by-step in Excel using an automated Payroll Template specifically designed for the new tax law.
In the Payslip tutorial, I then show how:
✔ The computed PAYE
✔ Deductions
✔ Net pay
flow directly into a professionally formatted employee payslip without manual recalculation.
Why This Matters
Watching the videos and using the Payroll Template helps you:
✔ Understand the law beyond theory
✔ Apply it correctly in real payroll scenarios
✔ Reduce errors and compliance risks
If you handle payroll in Nigeria, case studies like this should be built into your payroll process, not guessed.
👉 PAYE Tutorial: https://youtu.be/ITTIBUKyMd0?si=-UR3Y...
👉 Payslip Tutorial: https://youtu.be/YoPjQKp8DVw?si=H8L4I...
👉 Payroll Template: Get the template here 👇
selar.com/payrollmanager
OR
selfany.com/payrollmanager
,
#payrollnigeria
#payenigeria
#newtaxlaw2026
#ExcelForPayroll
#HRNigeria
#accountingnigeria
#financeprofessionals
#dexcelcoach
#AccountingOnExcel
1 month ago | [YT] | 2
View 0 replies
Load more