📘 Module One · Welcome to Microsoft Dynamics 365 for Banking & Financial Services

👋 For beginners · easy words · lots of stories

🌟 Module Introduction

Imagine a giant bank that has millions of customers, thousands of employees, and money moving everywhere – like a busy city with cars, buses, and people all going different places. How does the bank keep track of everything? Who makes sure the money goes to the right account? How do they know if the bank is making a profit?

Microsoft Dynamics 365 is like the brain of a bank. It is a smart computer system that helps banks manage money, customers, loans, and reports – all in one place. This module is your first step into the world of Dynamics 365 for Banking and Financial Services. We will learn what it is, why banks love it, and how it helps them work better.

By the end of this module, you will understand the big picture – like looking at a map of a city instead of just one street.

🎯 Learning Objectives

After this module, you will be able to:

• Explain what Microsoft Dynamics 365 is – in your own words.
• Name three main jobs that Dynamics 365 does for a bank.
• Describe how the system helps with money, customers, and rules.
• Give examples of banking tasks that become easier with Dynamics 365.
• Understand why banks use computers to manage money instead of paper.

📖 Warm-up Story · The Big Bank Puzzle

Once upon a time, in a city called Financia, there was a bank named Golden Chest Bank. The bank had 50 branches and 20,000 customers. Every day, people came to deposit money, take loans, and pay bills. The bank used paper ledgers – huge books where they wrote every transaction by hand.

One day, a customer named Mrs. Adebayo wanted to know her account balance. The clerk had to look through 5 heavy books. It took 2 hours! Another customer, Mr. Okonkwo, complained that his loan payment was not recorded. The bank manager was stressed.

Then, a smart consultant said, “Why don’t you use a computer system that does all this in seconds?” That system was Microsoft Dynamics 365. The bank installed it, and suddenly, everything became fast, accurate, and easy. Mrs. Adebayo could check her balance on her phone. Mr. Okonkwo got instant receipt. The bank grew bigger and happier.

This module teaches you how that “smart brain” works.

📚 Main Lessons

Lesson 1 · What is Microsoft Dynamics 365?

Definition: Microsoft Dynamics 365 is a collection of smart computer programs that help businesses manage their money, customers, and daily work – all in one place.

Why important? Banks handle millions of transactions. Without a smart system, they would be slow and make many mistakes.

Simple explanation: Think of it as the “boss computer” that keeps track of everything a bank does.

Real-life example: When you deposit money at an ATM, Dynamics 365 can update your account instantly.

School example: Like a school register that records every student’s attendance, grades, and fees – but for a whole bank.

Home example: Like a family calendar that reminds everyone of birthdays, but much bigger and smarter.

Nigerian example: A microfinance bank in Lagos uses Dynamics 365 to give small loans to market women and track repayments daily.

Illustration:

  💡 Dynamics 365 = The Brain of the Bank
         |
         +---> Manages Money
         +---> Tracks Customers
         +---> Prepares Reports
         +---> Follows Rules

Mini summary: Dynamics 365 is like a super-smart assistant that helps banks run smoothly.

Lesson 2 · Why Banks Need Special Software

Banks are not like a small shop. They have many branches, thousands of customers, and strict government rules. A normal spreadsheet (like Excel) cannot handle all that. Special software like Dynamics 365 is built for big jobs.

Real-life example: A bank in Abuja has 1 million customers. Each customer has accounts, loans, and transactions. Dynamics 365 processes all this quickly.

School example: Imagine your school had 10,000 students. You need a computer to manage exams, not just a notebook.

Home example: A family with 5 people can use a notebook for expenses. A bank with 5 million people needs a computer.

Nigerian example: First Bank of Nigeria uses modern systems to serve over 10 million customers – that’s why they need Dynamics 365.

Illustration:

  🏦 Bank size    →   📊 Software needed
  Small shop      →   Excel
  Big bank        →   Dynamics 365

Mini summary: Banks need special software because they are huge, fast, and must follow many rules.

Lesson 3 · The Three Main Parts of Dynamics 365 for Banking

Dynamics 365 for banking has three main parts: Finance, Operations, and Customer Service. But we focus on the banking edition.

• Finance – manages money, accounts, and reports.
• Bank Management – handles bank accounts, reconciliation (matching records), and cash flow.
• Credit & Collections – tracks loans and ensures customers pay back.

Real-life example: When a customer gets a car loan, the Credit part tracks the payments, Finance records the money, and Bank Management ensures the bank has enough cash.

School example: Like a school with a finance office for fees, a library for books, and a sports department – all working together.

Home example: At home, you have a budget (finance), a chore list (operations), and a family calendar (customer service).

Nigerian example: A cooperative bank in Ibadan uses the credit module to give farmers loans for seeds and tractors.

Illustration:

  Dynamics 365 for Banking
  ┌─────────┬─────────────┬──────────────┐
  │ Finance │ Bank Mgmt   │ Credit/Collect│
  │ (money) │ (accounts)  │ (loans)       │
  └─────────┴─────────────┴──────────────┘

Mini summary: Dynamics 365 has different “departments” inside it, all connected.

Lesson 4 · How Dynamics 365 Helps with Customer Accounts

Every bank customer has an account. Dynamics 365 stores all customer details: name, address, phone, account number, and balance. It also records every deposit and withdrawal.

Why important? So the bank always knows who owns what money.

Simple: It’s like a digital filing cabinet that never loses papers.

Real-life: When you open a bank account, the bank puts your info into Dynamics 365.

School: Like a school database that stores each student’s name and grades.

Home: A contact list on your parents’ phone.

Nigerian: A customer in Kano opens a savings account; the system records it and gives a unique ID.

Illustration:

  Customer → Name, Address, Phone, Account #, Balance

Mini summary: Dynamics 365 is like a huge digital address book for all bank customers.

Lesson 5 · Managing Money – The Cash Management Part

This part tracks where money comes from and where it goes. It records deposits, withdrawals, transfers, and interest.

Real-life: When you pay with a debit card, the cash management system updates your balance.

School: Like the school’s petty cash book that records money for excursions.

Home: Your piggy bank – but digital and much faster.

Nigerian: A POS agent in Port Harcourt uses a bank account; every transaction is recorded in Dynamics 365.

Illustration:

  Money IN  →  Bank Account  →  Money OUT
  (deposits)   (Dynamics 365)  (withdrawals)

Mini summary: Cash management is like a digital cash register for the whole bank.

Lesson 6 · Loans and Credit – The Borrowing Side

Banks lend money to people and businesses. Dynamics 365 tracks the loan amount, interest rate, repayment schedule, and whether the customer pays on time.

Real-life: Your uncle takes a loan to buy a car. The system reminds him to pay every month.

School: A school lends textbooks to students; they must return them by the end of term.

Home: Borrowing a book from a friend – you promise to return it.

Nigerian: A farmer in Enugu gets a loan for fertilizer; the bank uses Dynamics 365 to track repayment after harvest.

Illustration:

  Loan given → Repayment plan → Track payments → Alert if late

Mini summary: The loan part makes sure the bank gets its money back with interest.

Lesson 7 · Bank Reconciliation – Matching Records

Reconciliation means checking that the bank’s internal records match the actual money in the bank account. Dynamics 365 does this automatically.

Real-life: You check your pocket money list against what you actually have.

School: The teacher checks the attendance register against the students present.

Home: Matching your shopping list with what you bought.

Nigerian: A bank in Benin compares its computer records with the Central Bank statement.

Illustration:

  Bank's books  ↔  Actual bank statement
       (must match!)

Mini summary: Reconciliation is like a “find the differences” game – but for money.

Lesson 8 · Reporting – Seeing the Big Picture

Dynamics 365 can create reports that show how the bank is doing – profit, losses, expenses, and income. Managers use these to make decisions.

Real-life: A report shows that the bank made N10 million profit last month.

School: End-of-term report card shows your grades.

Home: Family budget report shows how much was spent on food.

Nigerian: A bank in Kaduna generates a report to show the central bank.

Illustration:

  Data → Report → Decision

Lesson 9 · Security – Protecting Money and Information

Dynamics 365 has strong security to prevent hacking and fraud. Only authorized people can see sensitive information.

Real-life: You need a PIN to use your ATM card.

School: Only the principal can see teacher salaries.

Home: Parents keep important documents in a safe.

Nigerian: Bank staff in Lagos have different access levels – tellers see accounts, managers see everything.

Lesson 10 · Integration – Connecting with Other Systems

Dynamics 365 can talk to other software, like mobile apps, ATMs, and online banking portals. This makes banking seamless.

Real-life: You check your balance on your phone – the app connects to Dynamics 365.

School: The school’s payment portal connects to the bank’s system.

Home: Your smart TV connects to the internet.

Lesson 11 · Automation – Doing Things Without Humans

Dynamics 365 automates repetitive tasks like sending reminders, calculating interest, and generating statements.

Real-life: Automatic SMS when you receive money.

Nigerian: Automated loan repayment alerts to customers in Abuja.

Lesson 12 · Compliance – Following Government Rules

Banks must follow laws (like AML – Anti-Money Laundering). Dynamics 365 helps banks stay compliant.

Real-life: Reporting large transactions to the Central Bank.

Nigerian: CBN requires banks to report suspicious transactions; Dynamics 365 helps.

Lesson 13 · Customer Service – Happy Customers

Dynamics 365 helps banks respond faster to customer queries, complaints, and requests.

Real-life: A customer calls about a missing deposit; the agent finds it quickly.

Lesson 14 · Scalability – Growing with the Bank

As the bank grows, Dynamics 365 can grow too – adding more users, branches, and customers.

Real-life: A bank with 10 branches expands to 50; Dynamics 365 handles it.

Lesson 15 · Cloud vs On-Premises

Dynamics 365 can be used on the cloud (internet) or on the bank’s own servers. Cloud is popular because it’s flexible.

Real-life: Using Gmail (cloud) vs installing email on your computer.

📝 Key Vocabulary (simple definitions)

• Dynamics 365 – A smart computer system for businesses.
• Bank Reconciliation – Making sure your records match the bank’s records.
• Transaction – Any action that moves money: deposit, withdrawal, transfer.
• Customer Account – A record of a person’s money at the bank.
• Loan – Money you borrow and must pay back with interest.
• Interest – The extra money you pay for borrowing.
• Compliance – Following the rules.
• Automation – Letting the computer do tasks without human help.
• Cloud – Storing data on the internet instead of your own computer.
• Integration – Connecting different systems so they work together.

🧠 Important Concepts

• Centralized data: All information is stored in one system.
• Real-time processing: Updates happen instantly.
• Role-based access: Different people see different things.
• Audit trail: Every action is recorded for safety.

📋 Step-by-Step Explanations

How to open a customer account in Dynamics 365:

1. Click “Customers” menu.
2. Click “New Customer”.
3. Enter name, address, phone.
4. Assign account number.
5. Save – account is created.

How to process a deposit:

1. Find customer account.
2. Click “Deposit”.
3. Enter amount.
4. Save – balance updates.

🌍 Real-life Examples

• GTBank uses enterprise systems to manage millions of customers.
• Access Bank uses automation for loan approvals.

🇳🇬 Nigerian Examples

• UBA uses Dynamics 365-like systems for cash management.
• Sterling Bank uses digital banking integrated with core systems.

🎈 Fun Examples for Children

• Like a video game that saves your progress automatically.
• Like a magic book that writes everything you say.

🏡 Everyday Examples

• Using a mobile app to check your allowance.
• School lunch account that deducts money when you buy food.

👪 Parent Tips

• Explain to your child how banks use computers to keep money safe.
• Show them how you check your bank balance online.

🔎 Interesting Facts

• Dynamics 365 processes millions of transactions per second.
• It is used by over 200,000 companies worldwide.

🧾 Remember This

• Dynamics 365 is the brain of a bank.
• It helps with money, customers, and rules.
• It makes banking fast and safe.

❌ Common Mistakes

• Thinking it’s just like Excel – it’s much more powerful.
• Forgetting to reconcile accounts – leads to errors.
• Not using security features – can cause fraud.

✅ Best Practices

• Always back up data.
• Train staff properly.
• Regularly update the system.

📊 ASCII Illustrations

Flowchart: How a Deposit Works

  Customer deposits cash
         |
         V
  Teller enters amount
         |
         V
  Dynamics 365 updates balance
         |
         V
  Receipt printed
         |
         V
  Customer leaves happy 😊

Timeline: Daily Bank Cycle

  9 AM  → Open bank, start system
  10 AM → Process deposits
  12 PM → Approve loans
  3 PM  → Reconcile accounts
  5 PM  → Close, generate reports

Comparison Table

📌 End-of-Module Summary

In this module, we learned that Microsoft Dynamics 365 is a powerful system that helps banks manage money, customers, loans, and compliance. It is fast, secure, and can grow with the bank. We explored how it handles transactions, reconciliations, and reports. We also saw examples from Nigeria and everyday life.

❓ Frequently Asked Questions (10)

1. What is Dynamics 365? – A business system for managing money and customers.
2. Is it only for banks? – No, but we focus on banking.
3. Do I need to be a programmer? – No, you can use it with training.
4. Is it safe? – Yes, it has strong security.
5. Can it work without internet? – It can work on-premises too.
6. How much does it cost? – Depends on the bank’s size.
7. Can it connect to other apps? – Yes, it integrates with many systems.
8. How long to learn? – Basic use in a few weeks.
9. Is it used in Nigeria? – Yes, many banks use similar systems.
10. What is the cloud version? – Stored on Microsoft’s servers, accessible anywhere.

🔗 Matching Exercises

Match the term with the description:

📖 Scenario-based Exercises

Scenario 1: A customer says his account is missing N5,000. How would you use Dynamics 365 to check?

Scenario 2: The bank wants to give loans to 100 farmers. How can Dynamics 365 help track repayments?

👥 Group Activity

In groups of 3, pretend you are a bank team. List 5 things a bank does every day. Then explain which of those Dynamics 365 can help with.

🧑 Individual Activity

Draw a simple diagram showing how money moves from a customer to the bank and back. Label the steps.

🛠️ Mini Project

Create a “Bank in a Box” – a poster showing the three main parts of Dynamics 365 for banking: Finance, Bank Management, and Credit. Use pictures or drawings.

📝 Practical Assignment

Write a one-page report explaining why a bank in your city should use Dynamics 365. Mention at least 5 benefits.

🔑 Key Takeaways

• Dynamics 365 is a complete banking brain.
• It manages money, customers, and loans.
• It is secure, fast, and scalable.
• Banks in Nigeria use such systems to serve millions.

🗣️ Classroom Discussion Questions

• Why is it important for a bank to have a computer system?
• What would happen if a bank used only paper?
• How does automation help bank workers?

➡️ Preparation for Module 2

In Module 2, we will dive deeper into Cash and Bank Management. We will learn how Dynamics 365 handles bank accounts, reconciliations, and electronic payments. Please review the vocabulary list and think about how your own bank account works.

🎉 End of Module One · You are now ready for Module Two!

📊 Module Three · Credit, Loans, and Collections in Dynamics 365

🔹 For beginners · easy words · fun stories · lots of examples

🌟 Module Introduction

Welcome to Module Three! In Module One, we met the “brain” of the bank. In Module Two, we learned how the bank tracks every naira. Now we dive into one of the most exciting parts: lending money and getting it back.

Banks don’t just keep money safe – they also lend it to people and businesses. This is called credit. When you borrow money, you promise to pay it back, usually with a little extra (interest). But sometimes people forget or can’t pay. That’s where collections come in – the bank’s way of reminding customers to pay.

In this module, we will learn how Dynamics 365 helps banks give loans, set credit limits, and collect payments – all while being fair and following the rules.

🎯 Learning Objectives

After this module, you will be able to:

• Explain what credit and loans are in a bank.
• Describe how Dynamics 365 sets credit limits for customers.
• Understand how the system tracks loan repayments.
• Explain what collections are and why they are important.
• Give examples of how the system helps banks manage risk.
• Tell how Dynamics 365 helps banks follow lending rules.

📖 Warm-up Story · The Farmer and the Loan

In a village in Oyo State, there was a farmer named Bamidele. He wanted to buy better seeds and a tractor to grow more crops. He needed ₦500,000, but he didn’t have that much money. So he went to Golden Chest Bank to ask for a loan.

The bank manager, Mrs. Funke, used Dynamics 365 to check Bamidele’s credit history – his past loans and payments. The system showed that he always paid back on time. So the bank approved the loan and set a repayment plan: ₦50,000 every month for 10 months.

Dynamics 365 sent Bamidele a reminder each month. He paid on time, and after 10 months, he owned his tractor and had extra money from the harvest. The bank was happy, and Bamidele was happy. That’s how credit helps people grow – and Dynamics 365 makes it all smooth.

📚 Main Lessons

Lesson 1 · What is Credit in Banking?

Definition: Credit is the ability to borrow money or get goods and services now with the promise to pay later.

Why important? It helps people buy homes, cars, and start businesses even if they don’t have all the cash now.

Simple explanation: It’s like a friend lending you ₦100 to buy lunch, and you pay back next week.

Real-life example: You use a credit card to buy a game, and your parents pay the bill at the end of the month.

School example: The school lets a student pay fees in instalments – that’s credit.

Home example: Your parents buy a TV on “buy now, pay later” – that’s credit.

Nigerian example: A market woman in Lagos gets a loan to buy more goods to sell.

Illustration:

  Credit = Borrow now, Pay later
  ┌──────────────────────────────────┐
  │  Bank gives money                │
  │         |                        │
  │  Customer buys seeds/tractor     │
  │         |                        │
  │  Customer repays monthly         │
  └──────────────────────────────────┘

Mini summary: Credit is a helpful tool that lets people get what they need today and pay over time.

Lesson 2 · The Loan Lifecycle

A loan goes through different stages: application, approval, disbursement (giving the money), repayment, and finally closure.

Why important? The bank needs to track each stage to know which loans are active, which are late, and which are paid off.

Real-life: You apply for a student loan, get approved, the school gets the money, you pay back over time.

School: The school gives a laptop to a student on loan; they return it at the end of the term.

Home: You borrow a book from the library – you take it, read it, and return it.

Nigerian: A bank in Kano processes a loan for a farmer – from application to full repayment.

Illustration:

  Loan Lifecycle
  ┌────────┐   ┌─────────┐   ┌────────┐   ┌──────────┐
  │ Apply  │──▶│ Approve │──▶│ Disburse│──▶│ Repay    │
  └────────┘   └─────────┘   └────────┘   └──────────┘
                                              │
                                              ▼
                                         ┌────────┐
                                         │ Closed │
                                         └────────┘

Mini summary: A loan is born, lives, and dies – Dynamics 365 tracks every breath.

Lesson 3 · Credit Limits – How Much Can You Borrow?

A credit limit is the maximum amount a bank will lend to a customer. It depends on the customer’s income, past loans, and ability to pay.

Why important? To protect the bank from losing too much money if the customer cannot repay.

Real-life: Your parents have a credit card with a limit of ₦500,000 – they can’t spend more than that.

School: The school allows each student to borrow only 2 library books at a time.

Home: You can only borrow ₦200 from your sibling per week.

Nigerian: A bank in Abuja sets a credit limit of ₦1 million for a small business owner.

Illustration:

  Credit Limit = Max Borrowing
  ┌──────────────────────────────────┐
  │  Customer A: ₦500,000 limit     │
  │  Customer B: ₦2,000,000 limit   │
  │  Customer C: ₦10,000,000 limit  │
  └──────────────────────────────────┘

Mini summary: Credit limits are like a fence – they keep borrowing safe.

Lesson 4 · Risk Scoring – Who is Trustworthy?

Risk scoring is a number that shows how likely a customer is to pay back a loan. Higher score = lower risk.

Why important? To help the bank decide whether to approve a loan.

Real-life: A customer with a high score gets a loan quickly; a low score may be rejected.

School: A teacher gives a "reliability score" to students who always return borrowed books on time.

Home: Parents trust you more if you always do your chores.

Nigerian: A bank in Lagos uses credit bureaus to get risk scores.

Illustration:

  Risk Score  →  Decision
  800+  →  Approve loan
  600-799 →  Approve with conditions
  Below 600 →  Reject or require collateral

Mini summary: Risk scores help banks lend wisely.

Lesson 5 · Interest Rates – The Cost of Borrowing

Interest is the extra money you pay for borrowing. It is a percentage of the loan amount.

Why important? It’s how the bank makes a profit from lending.

Real-life: You borrow ₦100,000 at 10% interest – you pay back ₦110,000.

School: The school charges a late fee if you return a book late – that’s like interest.

Home: Your sibling lends you ₦500 and asks for ₦550 back – that’s interest.

Nigerian: A bank charges 15% interest on a business loan.

Illustration:

  Interest = Principal × Rate × Time
  Example: ₦100,000 × 10% × 1 year = ₦10,000 interest

Mini summary: Interest is the price you pay for using someone else's money.

Lesson 6 · Repayment Schedules – When to Pay

A repayment schedule is a plan that shows how much to pay each month and when.

Why important? So the customer knows exactly when and how much to pay.

Real-life: You get a loan and agree to pay ₦10,000 every 1st of the month for 12 months.

School: The school gives a payment plan for school fees: ₦50,000 per term.

Home: Your parents pay for the TV in 6 monthly instalments.

Nigerian: A bank in Ibadan sets a repayment schedule for a farmer based on harvest seasons.

Illustration:

  Repayment Schedule
  ┌────────┬─────────────┐
  │ Month  │ Payment     │
  ├────────┼─────────────┤
  │ Jan    │ ₦50,000     │
  │ Feb    │ ₦50,000     │
  │ Mar    │ ₦50,000     │
  │ ...    │ ...         │
  └────────┴─────────────┘

Mini summary: Repayment schedules keep both bank and customer on track.

Lesson 7 · Collections – When Customers Don’t Pay

Collections is the process the bank uses to remind and persuade customers to pay overdue loans.

Why important? To recover money and reduce losses.

Real-life: The bank sends an SMS reminder, then a letter, then calls the customer.

School: The school calls parents when fees are overdue.

Home: Your parents remind you to return borrowed money.

Nigerian: A bank in Enugu uses automated calls to remind customers of overdue payments.

Illustration:

  Collections Process
  ┌──────────────┐
  │ Payment due  │
  └──────┬───────┘
         ▼
  ┌──────────────┐
  │ Reminder SMS │
  └──────┬───────┘
         ▼
  ┌──────────────┐
  │ Follow-up    │
  │ call         │
  └──────┬───────┘
         ▼
  ┌──────────────┐
  │ Escalate to  │
  │ collections  │
  │ agency       │
  └──────────────┘

Mini summary: Collections is the bank’s gentle (and sometimes firm) reminder system.

Lesson 8 · Automating Collections with Dynamics 365

Dynamics 365 can automate collections – sending reminders, generating dunning letters, and even flagging high-risk accounts.

Why important? Saves time, ensures consistency, and improves recovery rates.

Real-life: The system automatically sends an SMS 5 days before payment is due.

School: The school portal sends automated fee reminders.

Home: A family app sends a reminder to pay the electricity bill.

Nigerian: A bank in Abuja uses automated dunning (reminder) letters.

Illustration:

  Automated Reminder Flow
  Due Date Approaching → System sends SMS/Email → Customer pays → Updated

Mini summary: Automation makes collections efficient and less stressful.

Lesson 9 · Credit Management Dashboard

Dynamics 365 has a Credit Management workspace that gives a full view of all customers, their credit limits, and overdue amounts.

Why important? Managers can see the big picture and take action quickly.

Real-life: A credit manager sees which customers owe the most and focuses on them.

School: The school bursar sees a list of all parents who haven’t paid fees.

Home: You see a list of who owes you money.

Nigerian: A bank in Lagos uses the dashboard to monitor loan portfolios.

Illustration:

  Credit Dashboard (simplified)
  ┌────────────┬──────────┬────────────┐
  │ Customer   │ Limit    │ Overdue    │
  ├────────────┼──────────┼────────────┤
  │ Adebayo    │ ₦1M      │ ₦200,000   │
  │ Okonkwo    │ ₦500K    │ ₦0         │
  │ Okafor     │ ₦2M      │ ₦500,000   │
  └────────────┴──────────┴────────────┘

Mini summary: The dashboard is the control panel for credit.

Lesson 10 · Collections Strategies – Being Fair and Effective

Banks use different strategies based on how late the payment is. Early reminders are gentle; late ones are firmer.

Why important? To treat customers fairly while recovering money.

Real-life: 1 day late – SMS; 15 days late – phone call; 30 days late – letter.

School: 1 week late – note; 1 month late – meeting with parents.

Home: You remind a friend once, then again, then stop lending.

Nigerian: A bank in Ilorin has a 3-stage collections strategy.

Illustration:

  Collections Strategy
  Stage 1 (1-7 days)  →  Friendly reminder
  Stage 2 (8-30 days) →  Phone call
  Stage 3 (>30 days)  →  Formal letter / visit

Mini summary: Different situations need different actions.

Lesson 11 · Write-offs – When the Bank Gives Up

Sometimes a customer never pays. The bank then writes off the loan as a loss. This is called a write-off.

Why important? To clean the books and accept reality, but also to learn from mistakes.

Real-life: The bank says, “This loan will not be repaid,” and removes it from expected income.

School: The school forgives a student’s fees if the family can’t pay.

Home: You lend money to a friend who never pays back – you “write it off.”

Nigerian: A bank writes off bad loans after 180 days.

Illustration:

  Loan Write-off Process
  Loan overdue > 180 days → Review → Decision to write off → Remove from books

Mini summary: Write-offs are tough decisions but sometimes necessary.

Lesson 12 · Collateral – The Bank’s Safety Net

Collateral is something valuable the customer gives to the bank as security, like a house or car. If the customer doesn’t pay, the bank can take the collateral.

Why important? To reduce the bank’s risk.

Real-life: You give your watch as collateral to borrow ₦500.

School: The school keeps a student’s ID card until they return all books.

Home: You leave your phone with a friend as security for a loan.

Nigerian: A bank in Kano takes a farmer’s land as collateral.

Illustration:

  Collateral = Security
  Loan Amount: ₦1,000,000
  Collateral: House worth ₦2,000,000
  If no repayment → Bank sells house to recover money

Mini summary: Collateral is like a promise backed by something valuable.

Lesson 13 · Credit Bureaus – Sharing Information

Credit bureaus are companies that collect information about people’s borrowing and repayment. Banks share and get data from them.

Why important? To check if a customer has bad history with other banks.

Real-life: Before giving a loan, the bank checks your credit report.

School: The school talks to other schools to check a student’s behaviour.

Home: You ask your friends if they know a person before lending money.

Nigerian: The Credit Bureau Association of Nigeria helps banks share data.

Illustration:

  Bank → Credit Bureau → Customer History → Bank decides

Mini summary: Credit bureaus help banks avoid risky customers.

Lesson 14 · Compliance – Following the Lending Rules

Banks must follow laws about lending, interest rates, and collections. Dynamics 365 helps banks stay compliant.

Why important? To avoid fines and protect customers.

Real-life: The bank cannot charge more than the legal interest rate.

School: The school cannot force a student to pay extra fees without notice.

Home: Parents follow rules for giving pocket money.

Nigerian: The Central Bank of Nigeria sets lending rules.

Illustration:

  Compliance = Following the Law
  Rules about: Interest rates, collection practices, data privacy.

Mini summary: Compliance keeps the bank honest and safe.

Lesson 15 · Integration with Customer Service

Credit and collections are connected to customer service. If a customer has a problem, the service team can see loan details and help.

Why important? To solve issues quickly and keep customers happy.

Real-life: A customer calls about a wrong charge – the agent sees the loan and fixes it.

School: The front office can check fee records for parents.

Home: Your parents keep a record of who owes whom.

Nigerian: A bank in Abuja connects collections with customer care.

Mini summary: Integration makes everything work together.

📝 Key Vocabulary (simple definitions)

• Credit – The ability to borrow money or get goods now and pay later.
• Loan – Money given by the bank that must be paid back with interest.
• Interest – The extra money paid for borrowing.
• Credit Limit – The maximum amount a customer can borrow.
• Risk Score – A number that shows how safe it is to lend to someone.
• Repayment – Paying back the loan in instalments.
• Collections – The process of getting overdue payments.
• Collateral – Valuable property given as security for a loan.
• Credit Bureau – A company that tracks people’s borrowing history.
• Compliance – Following the laws and rules.

🧠 Important Concepts

• Risk vs Reward: Banks balance the risk of lending against the reward of interest.
• Customer Relationship: Good credit management builds trust.
• Automation: Systems do repetitive work like sending reminders.
• Data Sharing: Banks share information to make better decisions.

📋 Step-by-Step Explanations

How to approve a loan in Dynamics 365:

1. Customer submits loan application.
2. System checks credit score and history.
3. Credit officer reviews.
4. If approved, system creates loan agreement.
5. Money is disbursed to customer’s account.

How to set up a collections plan:

1. Define overdue stages (e.g., 7 days, 30 days).
2. Set actions for each stage (SMS, call, letter).
3. Automate reminders in the system.
4. Monitor collections dashboard.

🌍 Real-life Examples

• GTBank uses credit scoring to approve personal loans.
• Access Bank has automated collections for overdue loans.

🇳🇬 Nigerian Examples

• First Bank uses collateral (like land) for large loans.
• Sterling Bank integrates with credit bureaus for risk checks.

🎈 Fun Examples for Children

• Like borrowing a toy from a friend and promising to return it.
• Like a game where you have to pay “coins” to keep playing.

🏡 Everyday Examples

• Your parents use a credit card for groceries and pay the bill monthly.
• You lend your friend ₦100 and they pay back ₦110 – that’s interest.

👪 Parent Tips

• Teach children that borrowing is a responsibility.
• Show them how to check credit card statements.

🔎 Interesting Facts

• The first credit card was issued in 1950.
• In Nigeria, the average loan interest rate is around 15-20%.

🧾 Remember This

• Credit helps people get what they need today.
• Interest is the cost of borrowing.
• Collections help banks recover money.
• Collateral protects the bank.

❌ Common Mistakes

• Lending to risky customers without checking credit.
• Not following up on overdue loans.
• Charging interest above the legal limit.

✅ Best Practices

• Always check credit history.
• Automate reminders.
• Have clear collections policies.

📊 ASCII Illustrations

Flowchart: Loan Approval Process

  Application
       |
       V
  Credit Check
       |
       V
  Approve? → Yes → Disburse Money
       |
       No
       |
       V
  Reject with reason

Timeline: Collections Process

  Day 1  →  Payment due
  Day 5  →  SMS reminder
  Day 15 →  Phone call
  Day 30 →  Formal letter
  Day 60 →  Escalate to agency

Comparison Table: Secured vs Unsecured Loan

📌 End-of-Module Summary

In Module Three, we explored credit, loans, and collections. We learned that credit allows people to borrow money for important things like education, farming, or business. We saw how Dynamics 365 sets credit limits, calculates interest, and tracks repayments. We also discovered how collections help banks recover overdue loans, and how automation makes the process smooth. We learned about risk scoring, collateral, and credit bureaus – all tools that help banks lend wisely and fairly.

You now understand the life cycle of a loan – from application to repayment to collections – and how Dynamics 365 manages every step.

❓ Frequently Asked Questions (10)

1. What is credit? – Borrowing money now and paying later.
2. What is a loan? – Money the bank gives you to pay back with interest.
3. What is interest? – The extra money you pay for borrowing.
4. What is a credit limit? – The maximum you can borrow.
5. What is a risk score? – A number that shows how likely you are to pay back.
6. What happens if I don’t pay? – The bank will start collections.
7. What is collateral? – Something valuable you give as security.
8. What is a credit bureau? – A company that tracks your borrowing history.
9. Can Dynamics 365 automate collections? – Yes, it can send reminders and letters.
10. Why is compliance important? – To follow the law and protect customers.

🔗 Matching Exercises

Match the term with the description:

📖 Scenario-based Exercises

Scenario 1: A customer has a loan of ₦1,000,000 and has missed 3 payments. What steps should the bank take using Dynamics 365?

Scenario 2: A new customer wants a loan of ₦5,000,000 but has no credit history. How can the bank decide?

👥 Group Activity

In groups, design a simple credit policy for a school that lends books to students. Include credit limits, interest (late fees), and collections steps.

🧑 Individual Activity

Write a list of 5 things you have borrowed in the past year. For each, note if you paid back on time and what happened if you didn’t.

🛠️ Mini Project

Create a poster showing the loan lifecycle – from application to closure – with illustrations and simple explanations.

📝 Practical Assignment

Write a 2-page report on how a small bank in Nigeria can use Dynamics 365 to manage credit and collections effectively. Include at least 5 specific features.

🔑 Key Takeaways

• Credit is a powerful tool for growth.
• Banks must manage risk carefully.
• Collections help recover money.
• Dynamics 365 automates and simplifies the whole process.
• Following rules protects everyone.

🗣️ Classroom Discussion Questions

• Is it always good to borrow money? Why or why not?
• What would happen if banks didn’t have collections?
• How can technology help people get loans faster?

➡️ Preparation for Module 4

In Module 4, we will explore Accounts Payable and Expense Management – how banks pay their own bills and manage expenses. We will learn about vendor payments, invoice matching, and employee expenses. Get ready to see how the bank spends money too!

🎉 End of Module Three · You are ready for Module Four!

🧾 Module Four · Accounts Payable and Expense Management in Dynamics 365

🔹 For beginners · easy words · fun stories · lots of examples

🌟 Module Introduction

Welcome to Module Four! In previous modules, we learned how the bank manages cash, loans, and credit. But banks also have to pay their own bills – for electricity, rent, salaries, and office supplies. This is called Accounts Payable (AP).

Think of a bank as a big house. It needs to buy food, pay the gardener, and fix the roof. All these costs must be tracked, approved, and paid on time. Dynamics 365 helps banks do this efficiently, saving time and avoiding mistakes.

In this module, we will learn how Dynamics 365 handles vendor invoices, employee expenses, and payment approvals – making sure the bank spends money wisely and follows the rules.

🎯 Learning Objectives

After this module, you will be able to:

• Explain what Accounts Payable (AP) is and why it matters.
• Describe how Dynamics 365 manages vendor invoices.
• Understand the invoice matching process.
• Explain how employee expenses are handled.
• Give examples of automation in AP.
• Tell how the system helps the bank control spending.

📖 Warm-up Story · The Bank's Electricity Bill

At Golden Chest Bank, the electricity bill arrived every month. The account department had to check the bill, get approval, and pay the vendor. But sometimes, bills got lost, payments were late, and the bank paid extra fees.

One day, the finance manager, Mr. Chidi, decided to use Dynamics 365 for all payments. The system stored vendor details, automatically matched bills to purchase orders, and sent payments on time. The bank never paid a late fee again. Mr. Chidi said, “This is like having a personal assistant for every bill!”

This module teaches you how Dynamics 365 makes paying bills easy and error-free.

📚 Main Lessons

Lesson 1 · What is Accounts Payable?

Definition: Accounts Payable (AP) is the department that handles all the money the bank owes to others – like vendors, suppliers, and employees.

Why important? To make sure the bank pays its bills on time and keeps good relationships with suppliers.

Simple explanation: It’s like the bank’s “to-pay” list.

Real-life example: The bank buys office chairs – the AP team pays the furniture company.

School example: The school pays the caterer for lunch every day.

Home example: Your parents pay the electricity bill – that’s AP at home.

Nigerian example: A bank in Lagos pays its security company monthly.

Illustration:

  Accounts Payable = Paying the Bank's Bills
  ┌────────────────────────────────────┐
  │  Vendor sends invoice              │
  │         |                          │
  │  AP team checks and approves       │
  │         |                          │
  │  Payment is sent to vendor         │
  └────────────────────────────────────┘

Mini summary: AP is the bank’s way of paying what it owes.

Lesson 2 · Vendors – Who the Bank Pays

A vendor is any person or company that provides goods or services to the bank. Examples: IT companies, cleaning services, and office suppliers.

Why important? The bank needs to keep vendor details – name, address, bank account – to make payments.

Real-life: The bank buys computers from Dell – Dell is a vendor.

School: The school buys books from a bookstore – the bookstore is a vendor.

Home: Your parents buy groceries from a shop – the shop is a vendor.

Nigerian: A bank in Ibadan pays a generator service company – that’s a vendor.

Illustration:

  Vendor Record
  ┌──────────────────────────────────┐
  │  Name: Furniture World           │
  │  Address: 123, Lagos             │
  │  Phone: 080-123-4567             │
  │  Bank Account: 0123456789        │
  └──────────────────────────────────┘

Mini summary: Vendors are the people the bank pays for things.

Lesson 3 · Purchase Orders – The Bank's Shopping List

A purchase order (PO) is a document that the bank sends to a vendor when it wants to buy something. It says what, how many, and at what price.

Why important? To make sure the bank gets what it ordered and at the agreed price.

Real-life: You write a list of items to buy from the store – that’s like a PO.

School: The school sends a PO to the book supplier for textbooks.

Home: A shopping list before going to the market.

Nigerian: A bank in Enugu sends a PO for office stationery.

Illustration:

  Purchase Order
  ┌──────────────────────────────────┐
  │  Item: 50 Chairs                 │
  │  Price: ₦10,000 each             │
  │  Total: ₦500,000                 │
  │  Delivery: 15th May               │
  └──────────────────────────────────┘

Mini summary: POs are like official shopping lists.

Lesson 4 · Invoices – The Vendor's Bill

An invoice is a document the vendor sends to the bank to request payment for goods or services delivered.

Why important? It tells the bank how much to pay and when.

Real-life: You get a bill from the mechanic after fixing your car.

School: The school gets an invoice from the caterer for meals.

Home: The electricity company sends a monthly bill.

Nigerian: A bank in Lagos receives an invoice for security services.

Illustration:

  Invoice Example
  ┌──────────────────────────────────┐
  │  From: Furniture World           │
  │  To: Golden Chest Bank           │
  │  Amount: ₦500,000                │
  │  Due Date: 30th May              │
  └──────────────────────────────────┘

Mini summary: Invoices are the vendor’s request for payment.

Lesson 5 · Invoice Matching – Checking the Bill

Invoice matching is the process of checking that the invoice matches the purchase order and the goods received. If they don’t match, the bank investigates.

Why important? To avoid overpaying or paying for things not received.

Real-life: You check your grocery receipt against what you bought.

School: The school checks the book invoice against the delivery.

Home: Your parents compare the electricity bill with the meter reading.

Nigerian: A bank in Abuja matches invoices to delivery notes.

Illustration:

  Invoice Matching
  ┌─────────────┐   ┌─────────────┐   ┌─────────────┐
  │ Purchase    │   │ Goods       │   │ Invoice     │
  │ Order (PO)  │   │ Received    │   │             │
  └─────────────┘   └─────────────┘   └─────────────┘
         │                  │                  │
         └──────────────────┼──────────────────┘
                            ▼
                   All match? → Pay
                   No → Investigate

Mini summary: Matching protects the bank from paying too much.

Lesson 6 · Three-Way Matching – The Most Complete Check

Three-way matching compares the purchase order, goods receipt, and invoice. All three must agree before payment is made.

Why important? It provides the highest level of control.

Real-life: You check the order form, the package, and the bill before paying.

School: The school checks the PO, delivery, and invoice.

Home: Your parents check the online order, the package, and the credit card bill.

Nigerian: A bank in Kano uses three-way matching for all large purchases.

Illustration:

  Three-Way Matching
  ┌────────┐ ┌──────────┐ ┌────────┐
  │  PO    │ │ Receipt  │ │Invoice │
  └────────┘ └──────────┘ └────────┘
      │          │           │
      └──────────┼───────────┘
                 ▼
             All Equal → Pay

Mini summary: Three-way matching is the gold standard for invoice checking.

Lesson 7 · Payment Terms – When to Pay

Payment terms are the rules that say when the payment is due. For example, “Net 30” means payment is due 30 days after the invoice date.

Why important? To manage cash flow and take advantage of early payment discounts.

Real-life: You buy a phone and have 30 days to pay.

School: The school pays the vendor within 30 days.

Home: Your parents pay the credit card bill by the due date.

Nigerian: A bank in Ilorin has payment terms of 15 days for small vendors.

Illustration:

  Payment Terms
  ┌──────────────┬─────────────────┐
  │ Term         │ Meaning         │
  ├──────────────┼─────────────────┤
  │ Net 30       │ Due in 30 days  │
  │ Net 60       │ Due in 60 days  │
  │ 2/10 Net 30  │ 2% discount if  │
  │              │ paid in 10 days │
  └──────────────┴─────────────────┘

Mini summary: Payment terms set the deadline for payment.

Lesson 8 · Discounts – Saving Money by Paying Early

Vendors sometimes offer a discount if the bank pays early. For example, “2% discount if paid within 10 days.”

Why important? To save money for the bank.

Real-life: You get a 5% discount if you pay your school fees early.

School: The school gets a discount on books if they pay early.

Home: Your parents get a discount for paying the cable bill early.

Nigerian: A bank in Lagos takes advantage of early payment discounts.

Illustration:

  Early Payment Discount
  Invoice: ₦100,000
  Discount: 2% if paid in 10 days
  Pay ₦98,000 instead of ₦100,000 – Save ₦2,000!

Mini summary: Discounts are a reward for paying early.

Lesson 9 · Employee Expenses – Reimbursing Staff

Employees often spend their own money on bank-related activities – like travel, meals, or supplies. The bank reimburses them through expense management.

Why important? To make sure employees are not out of pocket and to track spending.

Real-life: A bank manager travels to another city; the bank pays for the hotel and food.

School: A teacher buys supplies for the classroom; the school pays back.

Home: Your parents pay for your school trip; you get reimbursed.

Nigerian: A bank in Abuja reimburses staff for transport to meetings.

Illustration:

  Expense Reimbursement
  Employee spends money → Submits receipt → Bank approves → Employee gets paid back

Mini summary: Expense management makes sure employees are paid back for work-related spending.

Lesson 10 · Expense Policies – The Rules for Spending

Banks have expense policies that set limits on what employees can spend and on what. For example, hotel stays cannot exceed ₦50,000 per night.

Why important? To control costs and prevent misuse.

Real-life: You have a budget for school supplies – you can’t spend more than that.

School: The school has a policy for field trip spending.

Home: Your parents have a rule for how much you can spend on snacks.

Nigerian: A bank in Enugu has a policy for staff entertainment expenses.

Illustration:

  Expense Policy Example
  ┌──────────────────────────────────┐
  │  Meal allowance: ₦5,000/day     │
  │  Hotel: max ₦50,000/night       │
  │  Transport: ₦200/km              │
  └──────────────────────────────────┘

Mini summary: Expense policies keep spending in check.

Lesson 11 · Automation in AP – The System Does the Work

Dynamics 365 automates many AP tasks: matching invoices, sending reminders, and posting payments. This saves time and reduces errors.

Why important? So the AP team can focus on important tasks instead of data entry.

Real-life: The system automatically matches 90% of invoices.

School: The school system automatically sends fee reminders.

Home: Your family app automatically pays bills on the due date.

Nigerian: A bank in Lagos uses automation to process 1,000 invoices daily.

Illustration:

  Automation Flow
  Invoice arrives → System matches → Approves → Pays → Done!

Mini summary: Automation makes AP fast and reliable.

Lesson 12 · Workflow Approvals – Getting Permission

Before a payment is made, it often needs approval from a manager. Dynamics 365 has workflows that send invoices to the right people for approval.

Why important? To ensure proper authorization and prevent fraud.

Real-life: You need your parent’s permission to use the credit card.

School: The principal must approve large purchases.

Home: Both parents agree before buying a new TV.

Nigerian: A bank requires two signatures for payments above ₦1 million.

Illustration:

  Workflow Approval
  Invoice → Manager approves → Director approves → Payment

Mini summary: Workflows ensure the right people say “yes” before money goes out.

Lesson 13 · Vendor Payments – Sending the Money

Once the invoice is approved, Dynamics 365 sends the payment to the vendor – electronically, by cheque, or via bank transfer.

Why important? To settle the bank’s obligations.

Real-life: The bank pays the IT company for new computers.

School: The school pays the bus company for transport.

Home: Your parents pay the plumber for fixing the tap.

Nigerian: A bank in Ibadan uses electronic transfers for all vendor payments.

Illustration:

  Payment Process
  Approve → Generate Payment File → Send to Bank → Vendor receives money

Mini summary: Vendor payments are the final step in AP.

Lesson 14 · Reporting and Analytics – Seeing the Big Picture

Dynamics 365 provides reports on AP – total payables, aging of invoices, and spending trends. This helps managers make decisions.

Why important? To understand where the bank’s money is going.

Real-life: The manager sees that office supply costs have increased.

School: The school sees how much was spent on books this term.

Home: Your parents review their monthly spending report.

Nigerian: A bank in Kano uses AP reports for budget planning.

Illustration:

  AP Report (sample)
  ┌────────────┬─────────────┬────────────┐
  │ Vendor     │ Total Paid  │ Outstanding│
  ├────────────┼─────────────┼────────────┤
  │ Vendor A   │ ₦5,000,000  │ ₦1,000,000 │
  │ Vendor B   │ ₦2,000,000  │ ₦500,000   │
  └────────────┴─────────────┴────────────┘

Mini summary: Reports help managers see the full picture.

Lesson 15 · Integration with General Ledger

All AP transactions are automatically posted to the General Ledger – the bank’s main accounting record. This ensures that all spending is properly recorded.

Why important? So the bank’s financial statements are accurate.

Real-life: When the bank pays for electricity, the expense is recorded in the ledger.

School: The school’s payments are recorded in the school’s accounts.

Home: Your parents record expenses in a budget app.

Nigerian: A bank’s AP system feeds directly into its general ledger.

Illustration:

  AP → General Ledger → Financial Statements

Mini summary: Integration keeps the bank’s books in order.

📝 Key Vocabulary (simple definitions)

• Accounts Payable (AP) – The department that pays the bank’s bills.
• Vendor – A company or person the bank buys from.
• Purchase Order (PO) – A document to order goods or services.
• Invoice – A bill from a vendor requesting payment.
• Invoice Matching – Checking that the invoice matches the PO and delivery.
• Payment Terms – Rules about when payment is due.
• Discount – A reduction in price for early payment.
• Expense – Money spent by an employee on work-related items.
• Workflow – A series of steps for approval.
• General Ledger – The main accounting record.

🧠 Important Concepts

• Control: AP systems prevent fraud and errors.
• Efficiency: Automation saves time.
• Transparency: All spending is tracked and reported.
• Compliance: The bank follows laws and policies.

📋 Step-by-Step Explanations

How to process an invoice in Dynamics 365:

1. Receive invoice from vendor.
2. Enter invoice into system.
3. System matches with PO and goods receipt.
4. If matched, invoice is approved.
5. Payment is scheduled and made.

How to submit an employee expense:

1. Employee creates expense report.
2. Attaches receipts.
3. Submits for approval.
4. Manager approves.
5. Reimbursement is paid.

🌍 Real-life Examples

• GTBank uses AP automation to process thousands of invoices.
• Access Bank has a workflow for approval of large payments.

🇳🇬 Nigerian Examples

• First Bank pays its IT vendors via electronic transfer.
• Zenith Bank uses expense management for staff travel.

🎈 Fun Examples for Children

• Like using a shopping list (PO) and checking the receipt (invoice).
• Like getting pocket money and showing what you bought.

🏡 Everyday Examples

• Your parents pay the electricity bill.
• You buy a snack and get a receipt – that’s an invoice.

👪 Parent Tips

• Show your child how you pay bills online.
• Explain that companies also have bills to pay.

🔎 Interesting Facts

• The first invoice was used thousands of years ago in ancient Egypt.
• Automation can reduce invoice processing costs by 80%.

🧾 Remember This

• AP is how the bank pays its bills.
• Matching prevents overpayment.
• Expense policies control spending.
• Automation makes everything faster.

❌ Common Mistakes

• Paying an invoice without matching – could pay too much.
• Ignoring early payment discounts – losing savings.
• Not tracking employee expenses – leads to overspending.

✅ Best Practices

• Always use three-way matching.
• Automate where possible.
• Regularly review expense policies.

📊 ASCII Illustrations

Flowchart: Invoice Processing

  Receive Invoice
        |
        V
  Enter into System
        |
        V
  Match with PO and Receipt
        |
        V
  All Match? → Yes → Approve → Pay
        |
        No
        |
        V
  Investigate and Resolve

Timeline: Monthly AP Cycle

  Week 1 → Receive invoices
  Week 2 → Match and approve
  Week 3 → Schedule payments
  Week 4 → Make payments and reconcile

Comparison Table: Two-Way vs Three-Way Matching

📌 End-of-Module Summary

In Module Four, we explored Accounts Payable and Expense Management in Dynamics 365. We learned that AP is responsible for paying the bank’s bills on time. We covered purchase orders, invoices, and the matching process – especially three-way matching, which ensures accuracy. We also learned about payment terms, discounts, and employee expenses. Automation and workflows make the process efficient and secure. Finally, we saw how AP integrates with the General Ledger for complete financial visibility.

You now understand how Dynamics 365 helps the bank control spending, avoid fraud, and maintain good vendor relationships.

❓ Frequently Asked Questions (10)

1. What is Accounts Payable? – The department that pays the bank’s bills.
2. What is a vendor? – A company the bank buys from.
3. What is a purchase order? – A document to order goods.
4. What is an invoice? – A bill from a vendor.
5. What is invoice matching? – Checking that the invoice matches the order.
6. What is three-way matching? – Matching PO, receipt, and invoice.
7. What are payment terms? – Rules for when to pay.
8. What is an expense policy? – Rules for employee spending.
9. How does automation help? – It saves time and reduces errors.
10. What is a workflow? – A series of approval steps.

🔗 Matching Exercises

Match the term with the description:

📖 Scenario-based Exercises

Scenario 1: The bank receives an invoice for ₦500,000 for office chairs, but the purchase order was for ₦450,000. What should the bank do?

Scenario 2: An employee submits a meal expense of ₦10,000, but the policy says ₦5,000 maximum. How should the bank handle it?

👥 Group Activity

In groups, design a simple expense policy for a school that includes limits for travel, meals, and supplies. Share your policy with the class.

🧑 Individual Activity

Create a list of 5 expenses your family has each month. Categorize them as “fixed” (same amount) or “variable” (changes).

🛠️ Mini Project

Build a sample invoice processing flow using paper cutouts. Show the steps from invoice receipt to payment.

📝 Practical Assignment

Write a 2-page report on how a bank can use Dynamics 365 to automate its AP process. Include at least 5 benefits.

🔑 Key Takeaways

• AP is essential for managing the bank’s payments.
• Matching prevents errors and fraud.
• Discounts save money.
• Expense policies control spending.
• Automation makes AP efficient.

🗣️ Classroom Discussion Questions

• Why is it important to pay vendors on time?
• What could happen if the bank doesn’t match invoices?
• How can employees help control expenses?

➡️ Preparation for Module 5

In Module 5, we will explore Fixed Assets and Asset Leasing – how the bank manages its property, equipment, and leases. We will learn about depreciation, lease accounting, and asset tracking. Get ready to see how the bank takes care of its own buildings and equipment!

🎉 End of Module Four · You are ready for Module Five!

🏢 Module Five · Fixed Assets and Asset Leasing in Dynamics 365

🔹 For beginners · easy words · fun stories · lots of examples

🌟 Module Introduction

Welcome to Module Five! In this module, we will learn about the big things a bank owns – like buildings, land, computers, and ATM machines. These are called fixed assets.

Think of a bank as a big company. It doesn’t just have money in accounts; it also has physical property. Just like you might have a bicycle or a smartphone, the bank has offices, servers, and furniture. Over time, these things lose value – like a car that gets older. This is called depreciation.

Sometimes the bank doesn’t buy a building – it rents (leases) it. This is called asset leasing. Dynamics 365 helps the bank track all these assets, calculate their value, and manage leases according to accounting rules (like IFRS 16).

🎯 Learning Objectives

After this module, you will be able to:

• Explain what fixed assets are and give examples.
• Describe how Dynamics 365 tracks assets.
• Understand depreciation – why assets lose value.
• Explain what asset leasing is.
• Give examples of lease accounting (IFRS 16).
• Tell how the system helps the bank manage its property.

📖 Warm-up Story · The Bank's New Building

At Golden Chest Bank, the board decided to buy a new office building in Abuja for ₦500 million. It was a big investment. The finance team had to record this in the system as a fixed asset.

Every year, the building lost a little value because of wear and tear – that’s depreciation. Dynamics 365 automatically calculated this and showed the building’s current value. The bank also leased some office equipment – like printers – instead of buying them. The system tracked those leases too.

The bank’s accountant, Mrs. Ngozi, said, “With Dynamics 365, I know exactly what our assets are worth and when leases expire. It’s like having a digital warehouse manager.”

📚 Main Lessons

Lesson 1 · What are Fixed Assets?

Definition: Fixed assets are long-term physical items a company owns and uses in its business, like buildings, land, vehicles, and equipment.

Why important? They represent a big investment and must be tracked for accounting and tax purposes.

Simple explanation: It’s like the bank’s “big toys” – things that last a long time.

Real-life example: The bank’s headquarters building is a fixed asset.

School example: The school’s building and buses are fixed assets.

Home example: Your family’s car and house are fixed assets.

Nigerian example: A bank in Lagos owns its branches – they are fixed assets.

Illustration:

  Fixed Assets – Examples
  ┌──────────────────────────────────┐
  │  Buildings                       │
  │  Land                            │
  │  Vehicles                        │
  │  Computers & Servers             │
  │  ATM machines                    │
  │  Office furniture                │
  └──────────────────────────────────┘

Mini summary: Fixed assets are the bank’s long-lasting property.

Lesson 2 · Why Track Fixed Assets?

Banks must track assets to know their value, calculate depreciation, and for insurance and tax purposes.

Why important? To have accurate financial statements and make good decisions.

Real-life: The bank needs to know if it should repair or replace an old ATM.

School: The school needs to know the value of its buses for insurance.

Home: Your parents keep records of major purchases for insurance.

Nigerian: A bank in Enugu tracks its generators for maintenance planning.

Illustration:

  Why Track Assets?
  ┌──────────────────────────────────┐
  │  Know value for accounting       │
  │  Plan for repairs/replacements   │
  │  Insurance purposes              │
  │  Tax deductions                  │
  └──────────────────────────────────┘

Mini summary: Tracking helps the bank manage its property wisely.

Lesson 3 · Depreciation – Assets Lose Value

Depreciation is the gradual decrease in the value of an asset over time because of use, wear and tear, or age.

Why important? To match the cost of the asset with the income it generates over its life.

Real-life: A car loses value every year – it depreciates.

School: School computers become outdated – their value goes down.

Home: Your phone’s value drops after a year.

Nigerian: A bank’s delivery van depreciates over 5 years.

Illustration:

  Depreciation Over Time
  Year 0: ₦100,000 (new)
  Year 1: ₦80,000
  Year 2: ₦60,000
  Year 3: ₦40,000
  Year 4: ₦20,000
  Year 5: ₦0 (fully depreciated)

Mini summary: Depreciation shows that assets lose value as they get older.

Lesson 4 · Straight-Line Depreciation – The Simple Method

Straight-line depreciation spreads the cost of the asset evenly over its useful life. Same amount each year.

Why important? It’s the easiest and most common method.

Real-life: A ₦500,000 computer with a 5-year life depreciates ₦100,000 each year.

School: School buses depreciate evenly each year.

Home: Your bicycle’s value decreases by the same amount each year.

Nigerian: A bank in Kano uses straight-line for office furniture.

Illustration:

  Straight-Line Depreciation
  Cost: ₦1,000,000
  Useful life: 10 years
  Annual depreciation: ₦100,000
  After 5 years: ₦500,000 remaining value

Mini summary: Straight-line is like a constant drip – same amount every year.

Lesson 5 · Declining Balance Depreciation – Faster Early Loss

Declining balance depreciates more in the early years and less later. It’s faster than straight-line.

Why important? Some assets lose value quickly when new (like electronics).

Real-life: A new car loses more value in the first year than in the fifth.

School: New computers lose value faster in the first year.

Home: A new phone loses a lot of value in the first year.

Nigerian: A bank uses declining balance for IT equipment.

Illustration:

  Declining Balance
  Year 1: ₦400,000 (from ₦1,000,000)
  Year 2: ₦240,000
  Year 3: ₦144,000
  Year 4: ₦86,400
  Year 5: ₦51,840

Mini summary: Declining balance is a “fast start” method.

Lesson 6 · Fixed Asset Lifecycle in Dynamics 365

The asset lifecycle has stages: acquisition (buying), depreciation, maintenance, and disposal (selling or scrapping).

Why important? To manage the asset from “birth” to “death.”

Real-life: The bank buys a building, uses it for 20 years, then sells it.

School: The school buys a bus, uses it, then sells it.

Home: Your family buys a car, uses it, then sells it.

Nigerian: A bank in Ibadan tracks its generators through their full lifecycle.

Illustration:

  Asset Lifecycle
  ┌────────┐   ┌──────────┐   ┌──────────┐   ┌────────┐
  │ Acquire│──▶│ Depreciate│──▶│ Maintain │──▶│ Dispose│
  └────────┘   └──────────┘   └──────────┘   └────────┘

Mini summary: Every asset has a life story – Dynamics 365 records it.

Lesson 7 · Asset Leasing – Renting Instead of Buying

Asset leasing is renting an asset for a period instead of buying it. The bank pays regular rent.

Why important? Leasing saves the bank from a big upfront cost.

Real-life: The bank leases office space in a mall.

School: The school leases photocopiers.

Home: Your family leases a car for 2 years.

Nigerian: A bank in Abuja leases its backup generators.

Illustration:

  Leasing vs Buying
  Buying: Pay full price upfront.
  Leasing: Pay monthly rent for a period.

Mini summary: Leasing is like renting – no big purchase needed.

Lesson 8 · IFRS 16 – Lease Accounting Standard

IFRS 16 is an accounting rule that says most leases must be recorded as assets and liabilities on the balance sheet.

Why important? To make financial statements more transparent.

Real-life: A bank must show leased buildings as assets and liabilities.

School: The school must record its photocopier lease.

Home: You don’t have to worry about IFRS 16 at home.

Nigerian: Nigerian banks follow IFRS 16 for lease accounting.

Illustration:

  IFRS 16 – Lease Recognition
  Lease Contract → Right-of-Use Asset + Lease Liability
  Asset: Office building (right to use)
  Liability: Obligation to pay rent

Mini summary: IFRS 16 makes sure leases are recorded properly.

Lesson 9 · Right-of-Use (ROU) Asset

A Right-of-Use (ROU) asset represents the value of the right to use a leased asset.

Why important? To show the economic benefit of the lease.

Real-life: The bank has the right to use the office building for 10 years.

School: The school has the right to use the photocopier for 3 years.

Home: You have the right to use a rented car for the weekend.

Nigerian: A bank in Port Harcourt records ROU assets for its branches.

Illustration:

  ROU Asset = Right to Use
  Example: Lease office for 5 years
  ROU asset = present value of all rent payments

Mini summary: ROU is the value of the right to use something you don’t own.

Lesson 10 · Lease Liability – The Debt for Leases

A lease liability is the obligation to pay rent over the lease term. It’s like a debt.

Why important? To show the bank’s future payment obligations.

Real-life: The bank owes rent for the next 10 years – that’s a liability.

School: The school has a liability for photocopier lease payments.

Home: You have a liability to pay for the rented car.

Nigerian: A bank in Enugu records lease liabilities for its ATMs.

Illustration:

  Lease Liability = Rent Debt
  Lease term: 5 years
  Annual rent: ₦10 million
  Total liability: ₦50 million (discounted)

Mini summary: Lease liability is the “debt” of future rent.

Lesson 11 · Lease Classification – Operating vs Finance Leases

Leases are classified as operating (short-term, like a car rental) or finance (long-term, like a building).

Why important? Different accounting treatment.

Real-life: Renting a car for a day is operating; leasing a building for 20 years is finance.

School: Renting a bus for a trip is operating; leasing a school building is finance.

Home: Renting a movie is operating; leasing a car for 3 years is finance.

Nigerian: A bank classifies its head office lease as finance.

Illustration:

  Lease Types
  ┌───────────────┬─────────────────┐
  │ Operating     │ Finance         │
  ├───────────────┼─────────────────┤
  │ Short-term    │ Long-term       │
  │ No ownership  │ Ownership-like  │
  │ Example: car  │ Example: office │
  │ rental (1 day)│ lease (10 years)│
  └───────────────┴─────────────────┘

Mini summary: Classification depends on the length and nature of the lease.

Lesson 12 · Asset Impairment – When Value Drops Unexpectedly

Impairment is when an asset’s value suddenly drops because of damage, market changes, or obsolescence.

Why important? To write down the asset’s value to its real worth.

Real-life: A fire damages a bank branch – the building’s value drops.

School: A school bus is in an accident – its value drops.

Home: Your phone gets water damage – its value drops.

Nigerian: A bank in Lagos writes down a property after market changes.

Illustration:

  Impairment Example
  Asset value before: ₦100,000,000
  Damage: ₦30,000,000
  New value: ₦70,000,000

Mini summary: Impairment is a sudden drop in value.

Lesson 13 · Asset Disposal – Selling or Scrapping

Disposal is when the bank sells, gives away, or scraps an asset.

Why important? To remove the asset from the books and record any gain or loss.

Real-life: The bank sells an old building.

School: The school sells old buses.

Home: Your family sells an old car.

Nigerian: A bank in Ibadan disposes of old computers.

Illustration:

  Disposal Process
  Asset → Decide to sell/scrap → Remove from books → Record gain/loss

Mini summary: Disposal is the final stage of an asset’s life.

Lesson 14 · Fixed Asset Reports in Dynamics 365

Dynamics 365 generates reports showing asset values, depreciation, and lease information. These help managers make decisions.

Why important? To have a clear view of the bank’s property.

Real-life: The manager sees a report of all assets and their values.

School: The school sees a list of all its assets.

Home: Your parents keep a list of household items for insurance.

Nigerian: A bank in Abuja uses asset reports for annual audits.

Illustration:

  Asset Report (sample)
  ┌────────────┬──────────┬──────────────┐
  │ Asset      │ Cost     │ Depreciation │
  ├────────────┼──────────┼──────────────┤
  │ Building   │ ₦500M    │ ₦50M         │
  │ Computers  │ ₦10M     │ ₦2M          │
  │ Vehicles   │ ₦20M     │ ₦5M          │
  └────────────┴──────────┴──────────────┘

Mini summary: Reports show the status of all fixed assets.

Lesson 15 · Integration with General Ledger

All asset transactions (purchase, depreciation, disposal) are automatically posted to the General Ledger, keeping the bank’s accounts accurate.

Why important? For complete financial records.

Real-life: When the bank buys a building, the purchase is recorded in the ledger.

School: The school records bus purchases in its accounts.

Home: Your parents record major purchases.

Nigerian: A bank’s fixed assets feed into its general ledger.

Illustration:

  Fixed Assets → General Ledger → Financial Statements

Mini summary: Integration ensures accurate accounting.

📝 Key Vocabulary (simple definitions)

• Fixed Asset – A long-term physical item a company owns.
• Depreciation – The decrease in value of an asset over time.
• Straight-Line Depreciation – Equal depreciation each year.
• Declining Balance – Higher depreciation in early years.
• Lease – A contract to rent an asset for a period.
• IFRS 16 – An accounting standard for leases.
• Right-of-Use (ROU) Asset – The value of the right to use a leased asset.
• Lease Liability – The obligation to pay rent.
• Impairment – A sudden drop in asset value.
• Disposal – Selling or scrapping an asset.

🧠 Important Concepts

• Asset Management: Tracking assets from acquisition to disposal.
• Depreciation Methods: Different ways to calculate value loss.
• Lease Accounting: Recording leases as assets and liabilities.
• Compliance: Following IFRS 16 and other rules.

📋 Step-by-Step Explanations

How to add a fixed asset in Dynamics 365:

1. Go to the Fixed Assets module.
2. Click “New Asset”.
3. Enter asset details (name, cost, life).
4. Choose depreciation method.
5. Save – asset is recorded.

How to process a lease under IFRS 16:

1. Enter lease contract details.
2. System calculates ROU asset and liability.
3. Post the initial journal entry.
4. Each period, record rent and interest.

🌍 Real-life Examples

• GTBank owns many branches – tracked as fixed assets.
• Access Bank leases office equipment – uses IFRS 16.

🇳🇬 Nigerian Examples

• First Bank has a large property portfolio – managed in Dynamics 365.
• Zenith Bank leases ATMs – recorded as ROU assets.

🎈 Fun Examples for Children

• Like your bicycle losing value as it gets older.
• Like renting a game console for a weekend instead of buying it.

🏡 Everyday Examples

• Your family’s car loses value each year.
• Renting a house instead of buying it – that’s a lease.

👪 Parent Tips

• Explain to your child that big items like cars and houses lose value.
• Show them how leases work – like renting a car.

🔎 Interesting Facts

• Depreciation is used in accounting to match costs with income.
• IFRS 16 was introduced in 2019 to make leasing more transparent.

🧾 Remember This

• Fixed assets are long-term property.
• Depreciation shows loss of value.
• Leasing is renting, not buying.
• IFRS 16 makes lease accounting clear.

❌ Common Mistakes

• Forgetting to depreciate assets.
• Not recording leases properly.
• Ignoring impairment when value drops.

✅ Best Practices

• Regularly review asset values.
• Use the correct depreciation method.
• Comply with IFRS 16.

📊 ASCII Illustrations

Flowchart: Asset Lifecycle

  Acquisition
       |
       V
  Depreciation (each year)
       |
       V
  Impairment check (if needed)
       |
       V
  Disposal (sell or scrap)

Timeline: Asset Depreciation

  Year 1: ₦100,000
  Year 2: ₦80,000
  Year 3: ₦60,000
  Year 4: ₦40,000
  Year 5: ₦20,000

Comparison Table: Straight-Line vs Declining Balance

📌 End-of-Module Summary

In Module Five, we explored fixed assets and asset leasing. We learned that fixed assets are long-term items like buildings and computers. We covered depreciation methods – straight-line and declining balance – and how assets lose value over time. We also learned about asset leasing, IFRS 16, ROU assets, and lease liabilities. Finally, we saw how Dynamics 365 tracks assets from acquisition to disposal, integrates with the General Ledger, and generates reports.

You now understand how the bank manages its physical property and leases, ensuring accurate financial records and compliance with accounting standards.

❓ Frequently Asked Questions (10)

1. What is a fixed asset? – Long-term property like buildings.
2. What is depreciation? – Loss of value over time.
3. What is straight-line depreciation? – Equal depreciation each year.
4. What is declining balance? – Higher depreciation early on.
5. What is a lease? – Renting an asset.
6. What is IFRS 16? – A rule for lease accounting.
7. What is a ROU asset? – The right to use a leased asset.
8. What is a lease liability? – The debt from future rent.
9. What is impairment? – A sudden drop in value.
10. What is disposal? – Selling or scrapping an asset.

🔗 Matching Exercises

Match the term with the description:

📖 Scenario-based Exercises

Scenario 1: The bank buys a building for ₦1 billion with a 50-year life. How much depreciation per year using straight-line?

Scenario 2: The bank leases a fleet of cars for 5 years. How should it record this under IFRS 16?

👥 Group Activity

In groups, list 5 fixed assets a bank might have. For each, decide if it should use straight-line or declining balance depreciation.

🧑 Individual Activity

Draw a timeline showing the value of a ₦500,000 car over 5 years using straight-line depreciation (₦100,000 per year).

🛠️ Mini Project

Create a simple fixed asset register on paper for a school. Include buildings, buses, and computers. Show cost, depreciation, and current value.

📝 Practical Assignment

Write a 2-page report explaining how a bank should manage its fixed assets and leases using Dynamics 365. Include at least 5 features.

🔑 Key Takeaways

• Fixed assets are long-term property.
• Depreciation spreads the cost over time.
• Leases are recorded under IFRS 16.
• Dynamics 365 tracks everything automatically.

🗣️ Classroom Discussion Questions

• Why do assets lose value?
• Is it better to lease or buy? Why?
• How does tracking assets help a bank save money?

➡️ Preparation for Module 6

In Module 6, we will explore Budgeting and Regulatory Compliance – how the bank plans its finances and follows laws. We will learn about budget control, tax configuration, and electronic reporting. Get ready to see how the bank plans its spending and stays on the right side of the law!

🎉 End of Module Five · You are ready for Module Six!

📊 Module Six · Budgeting and Regulatory Compliance in Dynamics 365

🔹 For beginners · easy words · fun stories · lots of examples

🌟 Module Introduction

Welcome to Module Six! In this module, we will learn how the bank plans its spending (budgeting) and follows government rules (regulatory compliance).

Think of a bank as a family. A family plans how much to spend on food, rent, and school fees – that’s a budget. The bank also has to follow laws – like paying taxes and reporting large transactions. Dynamics 365 helps the bank do all this automatically.

🎯 Learning Objectives

After this module, you will be able to:

• Explain what budgeting means in a bank.
• Describe how Dynamics 365 helps with budget planning.
• Understand budget control – stopping overspending.
• Explain what taxes are and how the system handles them.
• Give examples of regulatory reporting (like CBN reports).
• Tell how the system helps the bank stay compliant.

📖 Warm-up Story · The Bank's Birthday Party

At Golden Chest Bank, the staff wanted to celebrate the bank’s 10th anniversary with a big party. But the finance team had to plan carefully – how much could they spend without hurting the bank’s budget?

Using Dynamics 365, they created a budget for the party. They entered amounts for food, decorations, and music. The system showed them if they were overspending. The party was a success, and the bank stayed within its budget.

Also, the bank had to pay taxes on its profits. Dynamics 365 calculated the taxes automatically and generated reports for the government. The bank never missed a deadline.

📚 Main Lessons

Lesson 1 · What is Budgeting?

Definition: Budgeting is the process of planning how much money you expect to receive and how much you will spend over a period.

Why important? To avoid spending more than you earn and to achieve financial goals.

Simple explanation: It’s like making a plan for your pocket money.

Real-life example: The bank plans its income and expenses for the next year.

School example: The school plans its budget for the term – salaries, books, maintenance.

Home example: Your family plans how much to spend on groceries each month.

Nigerian example: A bank in Lagos creates a budget for the upcoming year.

Illustration:

  Budget = Plan for Money
  ┌────────────────────────────────────┐
  │  Income: ₦1,000,000,000           │
  │  Expenses: ₦800,000,000           │
  │  Surplus: ₦200,000,000            │
  └────────────────────────────────────┘

Mini summary: Budgeting is planning your money.

Lesson 2 · Why Banks Need Budgets

Banks use budgets to control spending, plan for growth, and make sure they have enough money to operate.

Why important? To avoid running out of money and to make smart decisions.

Real-life: The bank budgets for marketing, salaries, and technology upgrades.

School: The school budgets for new classrooms.

Home: Your family budgets for a holiday.

Nigerian: A bank in Abuja budgets for new branches.

Illustration:

  Why Budget?
  ┌──────────────────────────────────┐
  │  Control spending                │
  │  Plan for the future             │
  │  Avoid debt                      │
  │  Make informed decisions         │
  └──────────────────────────────────┘

Mini summary: Budgets help banks stay in control.

Lesson 3 · Budget Planning in Dynamics 365

Dynamics 365 has a Budget Planning tool that lets the bank create budgets for different departments and periods.

Why important? To make budgeting easy and collaborative.

Real-life: The marketing team creates a budget for campaigns.

School: The school creates a budget for each department.

Home: Your family uses a spreadsheet to plan expenses.

Nigerian: A bank in Ibadan uses Budget Planning for all departments.

Illustration:

  Budget Planning Steps
  ┌────────────┐   ┌─────────────┐   ┌────────────┐
  │ Create     │──▶│ Review &    │──▶│ Approve &  │
  │ Budget     │   │ Adjust      │   │ Submit     │
  └────────────┘   └─────────────┘   └────────────┘

Mini summary: Budget Planning helps build budgets together.

Lesson 4 · Budget Control – Stopping Overspending

Budget control checks if a transaction would exceed the budget. If it would, the system can warn or block it.

Why important? To prevent overspending.

Real-life: The system blocks a purchase order if it would go over the budget.

School: The school system stops a purchase if it exceeds the budget.

Home: Your parent says “no” if you ask for more than the budget allows.

Nigerian: A bank in Enugu uses budget control for all expenses.

Illustration:

  Budget Control Flow
  Purchase Request → Check Budget → Over Budget? → Block or Warn

Mini summary: Budget control is the guardian of the budget.

Lesson 5 · Tax Configuration – Setting Up Taxes

Banks must collect and pay taxes. Dynamics 365 has tax configuration to set up tax rates, authorities, and periods.

Why important? To comply with tax laws and avoid penalties.

Real-life: The bank charges VAT on services and pays it to the government.

School: The school pays taxes on its income.

Home: Your parents pay sales tax on purchases.

Nigerian: A bank in Lagos configures VAT and withholding tax.

Illustration:

  Tax Setup
  ┌──────────────────────────────────┐
  │  Tax Rate: 5%                    │
  │  Tax Authority: FIRS             │
  │  Tax Period: Monthly             │
  └──────────────────────────────────┘

Mini summary: Tax configuration makes sure taxes are calculated correctly.

Lesson 6 · Sales Tax – VAT and GST

Sales tax (like VAT) is a tax added to the price of goods and services. The bank collects it from customers and pays it to the government.

Why important? To comply with tax laws.

Real-life: The bank charges 7.5% VAT on service fees.

School: The school charges VAT on school fees (if applicable).

Home: You pay VAT when you buy a phone.

Nigerian: Banks in Nigeria collect VAT and remit to FIRS.

Illustration:

  Sales Tax (VAT) Example
  Service fee: ₦100,000
  VAT (7.5%): ₦7,500
  Total paid: ₦107,500

Mini summary: Sales tax is a tax on goods and services.

Lesson 7 · Withholding Tax – Tax at Source

Withholding tax is a tax deducted from payments to vendors or contractors. The bank withholds the tax and pays it to the government.

Why important? To ensure taxes are paid on income.

Real-life: The bank deducts 5% from a contractor’s payment and pays it to FIRS.

School: The school withholds tax from a consultant’s fee.

Home: Your parents don’t withhold tax – it’s for businesses.

Nigerian: Banks in Nigeria withhold tax on vendor payments.

Illustration:

  Withholding Tax
  Payment to vendor: ₦100,000
  Withholding (5%): ₦5,000
  Vendor receives: ₦95,000
  Tax paid to government: ₦5,000

Mini summary: Withholding tax is tax deducted before payment.

Lesson 8 · Tax Exemptions – When No Tax is Charged

Some items or customers are exempt from tax. Dynamics 365 can handle exemptions.

Why important? To follow rules and avoid overcharging.

Real-life: The bank doesn’t charge VAT on export services.

School: The school may be exempt from some taxes.

Home: Some food items are tax-exempt.

Nigerian: A bank in Abuja applies exemptions for government transactions.

Illustration:

  Tax Exemption Example
  Customer: Government agency
  Service: ₦1,000,000
  Tax rate: 0% (exempt)
  Total: ₦1,000,000

Mini summary: Exemptions mean no tax is charged.

Lesson 9 · Electronic Reporting (ER) – Filing Taxes Electronically

Electronic Reporting is a tool in Dynamics 365 that generates tax files in the format required by the government.

Why important? To file taxes quickly and correctly.

Real-life: The bank generates an XML file for VAT returns.

School: The school generates a tax report for the tax authority.

Home: Your parents don’t file taxes electronically.

Nigerian: Banks use ER to file VAT and withholding tax returns.

Illustration:

  Electronic Reporting Flow
  Data → ER Format → Tax File → Submit to Government

Mini summary: ER makes tax filing easy.

Lesson 10 · Regulatory Compliance – Following the Rules

Regulatory compliance means following laws and regulations. Dynamics 365 helps banks comply with rules like AML (Anti-Money Laundering) and CBN regulations.

Why important? To avoid fines and legal trouble.

Real-life: The bank must report large transactions to the government.

School: The school follows education ministry rules.

Home: Your family follows traffic laws.

Nigerian: Banks in Nigeria must comply with CBN guidelines.

Illustration:

  Compliance Areas
  ┌──────────────────────────────────┐
  │  AML (Anti-Money Laundering)     │
  │  Data Privacy                    │
  │  Tax Reporting                   │
  │  Capital Adequacy                │
  └──────────────────────────────────┘

Mini summary: Compliance means following the law.

Lesson 11 · AML – Anti-Money Laundering

AML is a set of rules to prevent criminals from using banks to hide illegal money. Banks must monitor transactions and report suspicious activity.

Why important? To stop crime and protect the bank.

Real-life: The bank flags a deposit of ₦50 million from an unknown source.

School: The school doesn’t deal with AML – it’s for banks.

Home: Your parents don’t deal with AML.

Nigerian: Banks in Nigeria have AML compliance teams.

Illustration:

  AML Process
  Monitor Transactions → Flag Suspicious → Report to Authorities

Mini summary: AML stops money laundering.

Lesson 12 · Tax Reports – Showing the Government

Dynamics 365 can generate tax reports that show all taxes collected and paid. These are submitted to the tax authority.

Why important? To prove that the bank is paying the right amount of tax.

Real-life: The bank generates a VAT return report.

School: The school generates a tax report for the ministry.

Home: Your parents don’t generate tax reports.

Nigerian: Banks use tax reports for FIRS.

Illustration:

  Tax Report (sample)
  ┌────────────┬─────────────┬────────────┐
  │ Tax Type   │ Collected   │ Paid       │
  ├────────────┼─────────────┼────────────┤
  │ VAT        │ ₦5,000,000  │ ₦4,800,000 │
  │ Withholding│ ₦2,000,000  │ ₦2,000,000 │
  └────────────┴─────────────┴────────────┘

Mini summary: Tax reports show the government what the bank owes.

Lesson 13 · Audit Trail – Tracking Every Change

An audit trail is a record of every change made in the system – who did it, when, and what was changed. This is important for compliance.

Why important? To show that the bank is following rules and to detect fraud.

Real-life: The system records when a user changes a tax rate.

School: The school system records who changes fees.

Home: Your parents keep receipts for major purchases.

Nigerian: Banks use audit trails for CBN inspections.

Illustration:

  Audit Trail Entry
  User: John Doe
  Action: Changed tax rate from 5% to 7.5%
  Date: 15-May-2026 10:30 AM

Mini summary: Audit trails keep a history of all actions.

Lesson 14 · Localization – Adapting to Nigerian Laws

Localization means configuring Dynamics 365 to follow Nigerian laws and regulations – like VAT rates, tax authority (FIRS), and reporting formats.

Why important? To be fully compliant with Nigerian rules.

Real-life: The bank configures VAT at 7.5% and uses FIRS tax codes.

School: The school follows Nigerian education laws.

Home: Your family follows Nigerian traffic laws.

Nigerian: All banks in Nigeria localize Dynamics 365.

Illustration:

  Localization for Nigeria
  ┌──────────────────────────────────┐
  │  VAT: 7.5%                       │
  │  Tax Authority: FIRS             │
  │  Reporting: FIRS format          │
  │  Currency: NGN                   │
  └──────────────────────────────────┘

Mini summary: Localization makes the system fit Nigeria.

Lesson 15 · Integration with General Ledger

All budget and tax transactions are posted to the General Ledger, ensuring the bank’s financial records are complete and accurate.

Why important? For accurate financial statements and compliance.

Real-life: Tax payments are recorded in the General Ledger.

School: The school’s budget is linked to its accounts.

Home: Your parents record expenses in a budget app.

Nigerian: A bank’s tax data flows into the General Ledger.

Illustration:

  Budgets & Taxes → General Ledger → Financial Statements

Mini summary: Integration keeps the books accurate.

📝 Key Vocabulary (simple definitions)

• Budget – A plan for income and spending.
• Budget Control – Preventing overspending.
• Tax – Money paid to the government.
• VAT – Value Added Tax, a type of sales tax.
• Withholding Tax – Tax deducted at source.
• Electronic Reporting – Filing taxes electronically.
• Compliance – Following laws and rules.
• AML – Anti-Money Laundering.
• Audit Trail – Record of all changes.
• Localization – Adapting to a country’s rules.

🧠 Important Concepts

• Planning: Budgeting is about planning ahead.
• Control: Budget control prevents overspending.
• Taxation: Banks must pay taxes correctly.
• Compliance: Following rules is essential.

📋 Step-by-Step Explanations

How to create a budget in Dynamics 365:

1. Go to Budget Planning.
2. Select the budget cycle (e.g., 2026).
3. Enter income and expense amounts.
4. Submit for approval.
5. Approve and activate the budget.

How to file VAT electronically:

1. Generate the VAT return using Electronic Reporting.
2. Review the report for accuracy.
3. Submit to FIRS via the government portal.
4. Record payment in the system.

🌍 Real-life Examples

• GTBank uses budgeting to plan for expansion.
• Access Bank files VAT returns electronically using Dynamics 365.

🇳🇬 Nigerian Examples

• First Bank complies with CBN regulations using Dynamics 365.
• Zenith Bank uses Electronic Reporting for FIRS submissions.

🎈 Fun Examples for Children

• Like planning how to spend your birthday money.
• Like saving receipts to show your parents what you bought.

🏡 Everyday Examples

• Your family budgets for monthly groceries.
• You save part of your pocket money for a toy.

👪 Parent Tips

• Teach your child about budgeting with pocket money.
• Explain that banks pay taxes just like families.

🔎 Interesting Facts

• The first budget in history was created in 1760 in the UK.
• Nigeria’s VAT was introduced in 1993.

🧾 Remember This

• Budgeting helps plan spending.
• Budget control stops overspending.
• Taxes must be paid correctly and on time.
• Compliance keeps the bank safe.

❌ Common Mistakes

• Not using budget control – leads to overspending.
• Forgetting to file taxes – results in fines.
• Not updating tax rates – causes errors.

✅ Best Practices

• Use budget control for all departments.
• Automate tax filing with Electronic Reporting.
• Regularly review compliance processes.

📊 ASCII Illustrations

Flowchart: Budget Process

  Plan Budget
       |
       V
  Submit for Review
       |
       V
  Approved? → Yes → Activate Budget
       |
       No
       |
       V
  Revise and Resubmit

Timeline: Tax Calendar

  Jan 31 – VAT return due
  Feb 28 – Withholding tax due
  Mar 31 – Company income tax due

Comparison Table: VAT vs Withholding Tax

📌 End-of-Module Summary

In Module Six, we explored budgeting and regulatory compliance. We learned that budgeting is planning income and spending, and budget control prevents overspending. We also covered taxes – VAT, withholding tax, and exemptions – and how Dynamics 365 configures and calculates them. Electronic Reporting makes tax filing easy. Compliance with regulations like AML and CBN rules is critical, and the system provides audit trails and localization for Nigeria.

You now understand how the bank plans its finances and follows the law using Dynamics 365.

❓ Frequently Asked Questions (10)

1. What is budgeting? – Planning your money.
2. What is budget control? – Stopping overspending.
3. What is VAT? – A tax on goods and services.
4. What is withholding tax? – Tax deducted at source.
5. What is Electronic Reporting? – Filing taxes electronically.
6. What is compliance? – Following the law.
7. What is AML? – Anti-Money Laundering.
8. What is an audit trail? – Record of changes.
9. What is localization? – Adapting to Nigeria’s rules.
10. How does Dynamics 365 help? – It automates budgeting and tax tasks.

🔗 Matching Exercises

Match the term with the description:

📖 Scenario-based Exercises

Scenario 1: The marketing department wants to spend ₦10 million, but the budget has only ₦8 million left. What should the system do?

Scenario 2: The bank has collected ₦5 million in VAT. How should it file and pay this to FIRS?

👥 Group Activity

In groups, create a simple budget for a school for one term. Include income (fees) and expenses (salaries, books, maintenance).

🧑 Individual Activity

List 5 taxes that a bank might pay in Nigeria. For each, explain briefly what it is.

🛠️ Mini Project

Create a poster showing the budget cycle – from planning to approval to monitoring. Include key steps and controls.

📝 Practical Assignment

Write a 2-page report on how a bank can use Dynamics 365 for budgeting and tax compliance. Include at least 5 features and benefits.

🔑 Key Takeaways

• Budgeting is planning money.
• Budget control prevents overspending.
• Taxes must be paid correctly.
• Compliance is essential.
• Dynamics 365 automates all of this.

🗣️ Classroom Discussion Questions

• Why is it important to budget?
• What happens if a bank doesn’t pay taxes?
• How can technology help with compliance?

➡️ Preparation for Module 7

In Module 7, we will explore Financial Reporting and Consolidation – how the bank creates reports and combines data from multiple branches. We will learn about Management Reporter, consolidation, and Power BI dashboards. Get ready to see how the bank tells its financial story!

🎉 End of Module Six · You are ready for Module Seven!

📈 Module Seven · Financial Reporting and Consolidation in Dynamics 365

🔹 For beginners · easy words · fun stories · lots of examples

🌟 Module Introduction

Welcome to Module Seven! In this module, we will learn how the bank tells its financial story – through reports. And if the bank has many branches, it must combine their numbers into one big report – this is called consolidation.

Think of a bank as a giant jigsaw puzzle. Each branch is a piece. Consolidation is putting all the pieces together to see the whole picture. Dynamics 365 helps the bank create beautiful reports that show profits, losses, and everything in between.

🎯 Learning Objectives

After this module, you will be able to:

• Explain what financial reporting is.
• Describe how Dynamics 365 creates reports.
• Understand the key financial statements: Income Statement and Balance Sheet.
• Explain what consolidation is and why it matters.
• Give examples of how reports help managers make decisions.
• Tell how the system integrates with Power BI for dashboards.

📖 Warm-up Story · The Bank's Big Report

At Golden Chest Bank, the CEO, Mr. Ade, wanted to know how the bank performed in 2025. He needed a report showing all the money earned and spent. The finance team used Dynamics 365 to generate an Income Statement and a Balance Sheet.

The bank had branches in Lagos, Abuja, and Port Harcourt. Each branch sent its numbers to the head office. The system consolidated them into one report. Mr. Ade could see that Lagos was the most profitable branch. He used this information to plan for the next year.

📚 Main Lessons

Lesson 1 · What is Financial Reporting?

Definition: Financial reporting is the process of creating statements that show a company's financial performance and position.

Why important? To help managers, investors, and regulators understand the bank's health.

Simple explanation: It’s like a report card for the bank.

Real-life example: The bank publishes an annual report for shareholders.

School example: Your school report card shows your grades and attendance.

Home example: Your parents keep a budget to track income and expenses.

Nigerian example: A bank in Lagos reports to the Central Bank of Nigeria (CBN).

Illustration:

  Financial Reporting = Bank Report Card
  ┌────────────────────────────────────┐
  │  Income Statement (Profit/Loss)    │
  │  Balance Sheet (Assets/Liabilities)│
  │  Cash Flow Statement (Money Flow)  │
  └────────────────────────────────────┘

Mini summary: Financial reports show how the bank is doing.

Lesson 2 · The Income Statement – Profit and Loss

The Income Statement (also called Profit and Loss) shows how much money the bank earned (revenue) and spent (expenses) over a period. If revenue is higher, the bank made a profit.

Why important? To see if the bank is making money.

Real-life example: The bank earned ₦100 million from loans and paid ₦60 million in salaries – profit is ₦40 million.

School example: The school earns from fees and spends on salaries – profit is surplus.

Home example: Your parents earn salaries and spend on food, rent, and school fees.

Nigerian example: A bank in Ibadan reports its profit to shareholders.

Illustration:

  Income Statement (simplified)
  ┌────────────────────────────────────┐
  │  Revenue (Income)    ₦100,000,000 │
  │  Expenses            ₦ 60,000,000 │
  │  Profit              ₦ 40,000,000 │
  └────────────────────────────────────┘

Mini summary: Income Statement = Revenue – Expenses = Profit.

Lesson 3 · The Balance Sheet – Assets and Liabilities

The Balance Sheet shows what the bank owns (assets) and what it owes (liabilities) at a specific date. Assets must equal liabilities plus equity.

Why important? To show the bank's financial position.

Real-life example: The bank has ₦500 million in assets (buildings, loans) and ₦300 million in liabilities (deposits, debt) – equity is ₦200 million.

School example: The school owns buildings (assets) and owes salaries (liabilities).

Home example: Your family owns a house (asset) and has a mortgage (liability).

Nigerian example: A bank in Abuja shows its assets and liabilities in its annual report.

Illustration:

  Balance Sheet (simplified)
  ┌────────────────────────────────────┐
  │  Assets              ₦500,000,000 │
  │  Liabilities         ₦300,000,000 │
  │  Equity              ₦200,000,000 │
  │  Total = Assets = Liab. + Equity  │
  └────────────────────────────────────┘

Mini summary: Balance Sheet = What you own – What you owe.

Lesson 4 · Cash Flow Statement – Money in Motion

The Cash Flow Statement shows the cash coming in and going out over a period. It helps the bank understand its liquidity.

Why important? To know if the bank has enough cash to pay bills.

Real-life example: The bank receives cash from loans and pays cash for salaries.

School example: The school collects fees and pays staff.

Home example: Your parents receive salaries and pay bills.

Nigerian example: A bank in Kano reports its cash flow to the CBN.

Illustration:

  Cash Flow Statement (simplified)
  ┌────────────────────────────────────┐
  │  Cash Inflows (receipts) ₦80M     │
  │  Cash Outflows (payments) ₦60M    │
  │  Net Cash Flow        ₦20M        │
  └────────────────────────────────────┘

Mini summary: Cash Flow shows money moving in and out.

Lesson 5 · Financial Reporting in Dynamics 365

Dynamics 365 has a powerful Financial Reporting tool (formerly Management Reporter) that creates professional reports. You can design row and column definitions to get exactly what you need.

Why important? To create reports quickly and accurately.

Real-life example: The bank generates a monthly Income Statement.

School example: The school creates a report for the board of governors.

Home example: Your parents use an app to track expenses.

Nigerian example: A bank in Lagos uses Financial Reporting for CBN returns.

Illustration:

  Financial Reporting in Dynamics 365
  ┌────────────┐   ┌────────────┐   ┌────────────┐
  │ Row        │──▶│ Column     │──▶│ Report     │
  │ Definition │   │ Definition │   │ Output     │
  └────────────┘   └────────────┘   └────────────┘

Mini summary: Financial Reporting makes report creation easy.

Lesson 6 · Drill-Down – Getting to the Details

Drill-down lets you click on a number in a report to see the underlying transactions. It’s like opening a box to see what’s inside.

Why important? To investigate numbers and ensure accuracy.

Real-life example: The manager clicks on ₦10 million salary expense to see the list of employees.

School example: You click on a grade to see your scores.

Home example: Your parents click on a grocery expense to see the receipts.

Nigerian example: A bank auditor uses drill-down to check transactions.

Illustration:

  Drill-Down Example
  Report: Salary Expense ₦10M
  Click → List of 50 employees with amounts

Mini summary: Drill-down helps you see the details behind the numbers.

Lesson 7 · Consolidation – Combining Branches

Consolidation is the process of combining financial data from multiple companies or branches into one set of reports.

Why important? To see the big picture of the whole group.

Real-life example: The bank has branches in 5 cities – consolidation combines them.

School example: A school group with 3 campuses combines their finances.

Home example: Your family combines income from both parents.

Nigerian example: A bank group with subsidiaries consolidates for CBN.

Illustration:

  Consolidation Process
  Branch A   Branch B   Branch C
      |          |          |
      └──────────┼──────────┘
                 ▼
          Consolidated Report

Mini summary: Consolidation combines all branches into one report.

Lesson 8 · Why Consolidation is Important

Consolidation gives a complete view of the bank's financial health. It also helps with compliance and decision-making.

Why important? To avoid seeing only part of the picture.

Real-life: The CEO needs to know the total profit of all branches.

School: The principal needs to know the total fees collected from all campuses.

Home: Your parents need to know the total family income.

Nigerian: A bank group consolidates for shareholders.

Illustration:

  Why Consolidate?
  ┌──────────────────────────────────┐
  │  See overall performance         │
  │  Compare branches                │
  │  Comply with regulations         │
  │  Make group-level decisions      │
  └──────────────────────────────────┘

Mini summary: Consolidation shows the full story.

Lesson 9 · Intercompany Eliminations

When branches trade with each other, those transactions must be removed during consolidation – this is called intercompany elimination.

Why important? To avoid double-counting revenue and expenses.

Real-life example: Branch A lends money to Branch B – the loan and interest must be eliminated.

School example: One campus buys supplies from another – this must be removed.

Home example: Your parents transfer money between accounts – it’s not income.

Nigerian example: A bank eliminates intercompany loans in consolidation.

Illustration:

  Intercompany Elimination
  Branch A sells to Branch B: ₦10M
  Consolidation: Remove the ₦10M to avoid double-counting

Mini summary: Eliminations remove internal transactions.

Lesson 10 · Consolidation in Dynamics 365

Dynamics 365 has a Consolidation module that automatically combines data from multiple legal entities and eliminates intercompany transactions.

Why important? To make consolidation fast and error-free.

Real-life example: The bank runs consolidation at month-end.

School example: The school group consolidates at year-end.

Home example: Your family uses a spreadsheet to combine incomes.

Nigerian example: A bank group uses Dynamics 365 for consolidation.

Illustration:

  Consolidation in Dynamics 365
  Legal Entities → Consolidation Process → Consolidated Report

Mini summary: Dynamics 365 automates consolidation.

Lesson 11 · Management Reporter – Custom Reports

Management Reporter is a tool within Dynamics 365 that lets you build custom financial reports with rows, columns, and tree structures.

Why important? To create reports that fit your exact needs.

Real-life example: The bank creates a report showing profit by branch.

School example: The school creates a report showing fees by class.

Home example: Your parents create a custom budget report.

Nigerian example: A bank in Abuja uses Management Reporter for board reports.

Illustration:

  Management Reporter
  ┌──────────────────────────────────┐
  │  Row Definitions → Define lines  │
  │  Column Definitions → Define cols│
  │  Tree Definitions → Group entities│
  └──────────────────────────────────┘

Mini summary: Management Reporter builds custom reports.

Lesson 12 · Power BI Dashboards – Visual Reports

Power BI is a tool that creates colorful dashboards with charts and graphs. It connects to Dynamics 365 for real-time data.

Why important? To make data easy to understand at a glance.

Real-life example: The CEO sees a dashboard with profits, loans, and expenses.

School example: The principal sees a dashboard with attendance and fees.

Home example: Your parents see a pie chart of expenses.

Nigerian example: A bank in Lagos uses Power BI for executive dashboards.

Illustration:

  Power BI Dashboard (concept)
  ┌──────────────┬──────────────┐
  │  Profit:     │  Loans:      │
  │  ₦40M        │  ₦100M       │
  ├──────────────┼──────────────┤
  │  Expenses:   │  Customers:  │
  │  ₦60M        │  10,000      │
  └──────────────┴──────────────┘

Mini summary: Power BI makes reports visual and interactive.

Lesson 13 · Report Distribution – Sharing Reports

Dynamics 365 can distribute reports via email, SharePoint, or print. The system can schedule reports to be sent automatically.

Why important? To get the right information to the right people on time.

Real-life example: The finance team sends a monthly report to the CEO.

School example: The school sends a report to the board.

Home example: Your parents share a budget report with each other.

Nigerian example: A bank sends reports to CBN electronically.

Illustration:

  Report Distribution
  Dynamics 365 → Email / SharePoint → Recipients

Mini summary: Distribution gets reports to the right people.

Lesson 14 · Report Security – Who Can See What

Dynamics 365 has security roles that control who can view or modify reports. Only authorized users can see sensitive data.

Why important? To protect confidential information.

Real-life example: Only the finance director can see the full profit report.

School example: Only the principal can see teacher salaries.

Home example: Parents keep financial documents private.

Nigerian example: A bank restricts access to CBN reports.

Illustration:

  Report Security
  Role: Finance Manager → Full access
  Role: Branch Manager → Branch only
  Role: Employee → No access

Mini summary: Security keeps reports safe.

Lesson 15 · Integration with General Ledger

All reports are based on data from the General Ledger. Integration ensures that reports are accurate and up-to-date.

Why important? For accurate and timely reporting.

Real-life example: The Income Statement pulls data from the General Ledger.

School example: The school's financial report comes from its accounts.

Home example: Your budget app pulls data from your bank account.

Nigerian example: A bank's reports are generated from the General Ledger.

Illustration:

  General Ledger → Financial Reports → Consolidated Reports

Mini summary: Integration ensures reports are accurate.

📝 Key Vocabulary (simple definitions)

• Financial Reporting – Creating reports about money.
• Income Statement – Report of profit or loss.
• Balance Sheet – Report of assets and liabilities.
• Cash Flow Statement – Report of cash moving in and out.
• Consolidation – Combining data from multiple sources.
• Intercompany Elimination – Removing internal transactions.
• Drill-Down – Clicking to see details.
• Management Reporter – Tool for custom reports.
• Power BI – Tool for visual dashboards.
• Security – Controlling who sees reports.

🧠 Important Concepts

• Accuracy: Reports must be correct.
• Timeliness: Reports must be delivered on time.
• Completeness: All data must be included.
• Security: Data must be protected.

📋 Step-by-Step Explanations

How to generate an Income Statement in Dynamics 365:

1. Open Financial Reporting.
2. Select the Income Statement report definition.
3. Choose the period (e.g., January 2026).
4. Click Generate.
5. Review and print or export.

How to run consolidation:

1. Open the Consolidation module.
2. Select the legal entities to consolidate.
3. Choose the period.
4. Run the consolidation process.
5. Review the consolidated report.

🌍 Real-life Examples

• GTBank publishes annual reports with Income Statement and Balance Sheet.
• Access Bank uses Power BI for executive dashboards.

🇳🇬 Nigerian Examples

• First Bank consolidates its subsidiaries for CBN reporting.
• Zenith Bank uses Management Reporter for board reports.

🎈 Fun Examples for Children

• Like combining your pocket money from different sources.
• Like a video game summary screen showing your score and items.

🏡 Everyday Examples

• Your family combines income and expenses for a budget.
• You combine savings from your piggy bank and gift money.

👪 Parent Tips

• Show your child how you review your bank statement.
• Explain that companies also have "report cards."

🔎 Interesting Facts

• The first consolidated financial statement was published in the 1800s.
• Power BI is used by over 250,000 companies worldwide.

🧾 Remember This

• Financial reports show the bank's health.
• Consolidation combines branches.
• Eliminations remove internal transactions.
• Security protects sensitive data.

❌ Common Mistakes

• Forgetting to eliminate intercompany transactions.
• Using wrong periods for reports.
• Not securing sensitive reports.

✅ Best Practices

• Run reports regularly.
• Use drill-down to verify numbers.
• Set up security roles appropriately.

📊 ASCII Illustrations

Flowchart: Report Generation

  Data → Report Definition → Generate → Review → Distribute

Timeline: Monthly Reporting Cycle

  Week 1: Close previous month
  Week 2: Generate reports
  Week 3: Review and analyze
  Week 4: Distribute to stakeholders

Comparison Table: Financial Statements

📌 End-of-Module Summary

In Module Seven, we explored financial reporting and consolidation. We learned about the three key reports: Income Statement, Balance Sheet, and Cash Flow Statement. We saw how Dynamics 365 creates these reports using Financial Reporting and Management Reporter. Consolidation combines data from multiple branches, and intercompany eliminations remove internal transactions. Power BI dashboards make data visual, and security ensures reports are safe. Finally, we learned how reports are distributed and integrated with the General Ledger.

You now understand how the bank tells its financial story using Dynamics 365.

❓ Frequently Asked Questions (10)

1. What is financial reporting? – Creating reports about money.
2. What is an Income Statement? – Shows profit or loss.
3. What is a Balance Sheet? – Shows assets and liabilities.
4. What is a Cash Flow Statement? – Shows money in and out.
5. What is consolidation? – Combining data from branches.
6. What is intercompany elimination? – Removing internal transactions.
7. What is drill-down? – Clicking to see details.
8. What is Management Reporter? – Tool for custom reports.
9. What is Power BI? – Tool for visual dashboards.
10. How does Dynamics 365 help? – It automates reporting and consolidation.

🔗 Matching Exercises

Match the term with the description:

📖 Scenario-based Exercises

Scenario 1: The bank has branches in Lagos and Abuja. Lagos shows ₦100M profit, Abuja shows ₦50M. What is the consolidated profit?

Scenario 2: Branch A sold ₦10M of services to Branch B. How should this be treated in consolidation?

👥 Group Activity

In groups, create a simple Income Statement for a school. Include fees as revenue and salaries, books, and maintenance as expenses.

🧑 Individual Activity

Draw a simple Balance Sheet for a bank with assets (loans, buildings) and liabilities (deposits, debt).

🛠️ Mini Project

Create a poster showing the three main financial statements and explain what each one tells about a bank.

📝 Practical Assignment

Write a 2-page report on how a bank can use Dynamics 365 for financial reporting and consolidation. Include at least 5 features and benefits.

🔑 Key Takeaways

• Financial reports show the bank's health.
• Consolidation combines branches.
• Eliminations remove internal transactions.
• Dynamics 365 automates everything.
• Power BI makes reports visual.

🗣️ Classroom Discussion Questions

• Why is it important for a bank to have accurate reports?
• How does consolidation help a bank with multiple branches?
• What could go wrong if intercompany transactions are not eliminated?

➡️ Preparation for Module 8

In Module 8, we will explore System Integration and Development – how Dynamics 365 connects with other systems and how it can be customized. We will learn about APIs, data management, and security. Get ready to see how the bank’s systems work together!

🎉 End of Module Seven · You are ready for Module Eight!

🔌 Module Eight · System Integration and Development in Dynamics 365

🔹 For beginners · easy words · fun stories · lots of examples

🌟 Module Introduction

Welcome to Module Eight! In this final module, we will learn how Dynamics 365 talks to other systems (integration) and how it can be customized (development).

Think of a bank as a city. Dynamics 365 is the central building. But the bank also has ATMs, mobile apps, and online banking – they all need to connect. And sometimes, the bank wants to add new features to Dynamics 365 – that’s development.

🎯 Learning Objectives

After this module, you will be able to:

• Explain what system integration is.
• Describe how Dynamics 365 connects with other systems.
• Understand the role of APIs and OData.
• Explain what data management is.
• Give examples of customizations (like Chain of Command).
• Tell how security is managed in integrations.

📖 Warm-up Story · The Bank's Digital City

At Golden Chest Bank, customers used mobile apps, ATMs, and online banking. But these systems needed to talk to Dynamics 365. If a customer deposited money at an ATM, the balance had to update in the core system immediately.

The IT team used APIs (like messengers) to connect everything. They also used Data Management to import customer lists from Excel. When they wanted a new report, they wrote a small customization using Chain of Command – without breaking the main system.

📚 Main Lessons

Lesson 1 · What is System Integration?

Definition: System integration is the process of connecting different software systems so they can share data and work together.

Why important? So the bank's systems are not isolated – they can talk to each other.

Simple explanation: It’s like connecting different apps on your phone so they share information.

Real-life example: The mobile banking app gets balance data from Dynamics 365.

School example: The school’s attendance system connects to the fee system.

Home example: Your smartwatch connects to your phone.

Nigerian example: A bank’s ATM connects to Dynamics 365 for balance updates.

Illustration:

  Integration = Systems Talking
  Mobile App ←→ Dynamics 365 ←→ ATM

Mini summary: Integration makes systems work together.

Lesson 2 · Why Integration Matters for Banks

Banks have many systems – core banking, CRM, ATMs, online banking. Integration makes everything seamless.

Why important? To provide a smooth customer experience and real-time data.

Real-life: When you check your balance on the app, it’s real-time from the core system.

School: The school portal shows fee balances from the finance system.

Home: Your budgeting app syncs with your bank account.

Nigerian: A bank in Lagos integrates its USSD banking with Dynamics 365.

Illustration:

  Why Integrate?
  ┌──────────────────────────────────┐
  │  Real-time data                  │
  │  Better customer experience      │
  │  Reduced manual work             │
  │  Accurate reporting              │
  └──────────────────────────────────┘

Mini summary: Integration makes banking fast and smooth.

Lesson 3 · APIs – The Messengers

API (Application Programming Interface) is a set of rules that allows two systems to talk to each other. It's like a messenger that delivers requests and responses.

Why important? APIs are the standard way to integrate systems.

Real-life: The mobile app uses an API to ask Dynamics 365 for your balance.

School: The school portal uses an API to check student records.

Home: A weather app uses an API to get weather data.

Nigerian: A bank uses APIs to connect its mobile app to Dynamics 365.

Illustration:

  API = Messenger
  Request: "What is my balance?"
  API: delivers request → System: responds → API: delivers response

Mini summary: APIs are messengers between systems.

Lesson 4 · OData – A Special API for Data

OData (Open Data Protocol) is a type of API that is used to query and update data. It’s like a language for asking questions about data.

Why important? OData is used extensively in Dynamics 365 for integration.

Real-life: An external app uses OData to get a list of customers.

School: A parent app uses OData to get fee balances.

Home: A fitness app uses a similar protocol to get step counts.

Nigerian: A bank uses OData to sync customer data with a CRM.

Illustration:

  OData = Data Language
  Request: GET /Customers?filter=city eq 'Lagos'
  Response: List of customers in Lagos

Mini summary: OData is a language for getting and updating data.

Lesson 5 · Data Management – Moving Data in Bulk

Data Management is a tool in Dynamics 365 that lets you import and export large amounts of data, like customer lists or transactions.

Why important? To move data efficiently.

Real-life: The bank imports a new customer list from Excel.

School: The school imports student data from a spreadsheet.

Home: Your family imports contacts to a new phone.

Nigerian: A bank uses Data Management to update customer records.

Illustration:

  Data Management Process
  Excel File → Import → Dynamics 365 → Validate → Save

Mini summary: Data Management moves data in bulk.

Lesson 6 · Change Tracking – Knowing What Changed

Change tracking records when data is created, updated, or deleted. It helps external systems know what to sync.

Why important? To avoid syncing all data every time – just sync the changes.

Real-life: The mobile app only syncs new transactions since last check.

School: The portal only shows new fee payments.

Home: Your phone only syncs new photos.

Nigerian: A bank uses change tracking for incremental updates.

Illustration:

  Change Tracking
  Data changes → Tracked → External system syncs only changes

Mini summary: Change tracking makes syncing efficient.

Lesson 7 · Power Platform – Low-Code Integration

Power Platform (Power Apps, Power Automate, Power BI) allows integration without writing much code. It’s like building with LEGO blocks.

Why important? To enable non-developers to build solutions.

Real-life: The bank creates a Power App for staff to submit expense claims.

School: The school creates a Power Automate flow to send fee reminders.

Home: You use IFTTT (similar) to connect apps.

Nigerian: A bank uses Power Automate to send SMS alerts.

Illustration:

  Power Platform
  ┌──────────────────────────────────┐
  │  Power Apps   → Custom apps      │
  │  Power Automate → Workflows      │
  │  Power BI     → Dashboards       │
  └──────────────────────────────────┘

Mini summary: Power Platform makes integration easy.

Lesson 8 · Development – Customizing Dynamics 365

Development is when you write code to add new features or change how Dynamics 365 works.

Why important? To meet unique business needs.

Real-life: The bank adds a custom field to track loan purpose.

School: The school adds a custom report for student performance.

Home: You write a script to organize your files.

Nigerian: A bank adds a custom module for microfinance loans.

Illustration:

  Development Process
  Requirement → Design → Code → Test → Deploy

Mini summary: Development customizes the system.

Lesson 9 · X++ – The Programming Language

X++ is the programming language used in Dynamics 365 Finance and Operations. It’s used to write business logic.

Why important? To extend the system's functionality.

Real-life: A developer writes X++ code to calculate loan interest.

School: A developer writes code to calculate late fees.

Home: You might not use X++ at home.

Nigerian: A developer in Lagos writes X++ for a bank.

Illustration:

  X++ Code (concept)
  public void calculateInterest()
  {
      // Code to calculate interest
  }

Mini summary: X++ is the language for customizing Dynamics 365.

Lesson 10 · Chain of Command – Safe Customization

Chain of Command (CoC) is a pattern that lets developers extend existing code without modifying the original. It’s like adding a new step to a recipe without changing the original recipe.

Why important? To avoid breaking the system when updating.

Real-life: A developer adds a validation check before a loan approval.

School: A developer adds a check before fees are posted.

Home: You add a new step to your morning routine.

Nigerian: A bank uses CoC to add custom logic to standard processes.

Illustration:

  Chain of Command
  Original Code → Your Code (pre/post) → Original Code continues

Mini summary: CoC extends code safely.

Lesson 11 · Data Entities – Data Containers

Data entities are like containers that hold data for import/export. They make it easy to move data in and out of Dynamics 365.

Why important? To simplify data integration.

Real-life: The bank uses the "Customer" data entity to import customers.

School: The school uses "Student" data entity.

Home: You use a "Contacts" container to import contacts.

Nigerian: A bank uses data entities for CBN reporting.

Illustration:

  Data Entity = Container
  [Customer Entity] → Contains name, address, account number

Mini summary: Data entities simplify data movement.

Lesson 12 · Security – Protecting Data

Security is critical in integrations. Dynamics 365 uses roles and permissions to control who can access what.

Why important? To prevent unauthorized access.

Real-life: Only the finance team can view bank account details.

School: Only the principal can see teacher salaries.

Home: Parents have the password for the family account.

Nigerian: Banks use security to protect customer data.

Illustration:

  Security Layers
  User → Role → Permissions → Data

Mini summary: Security keeps data safe.

Lesson 13 · Performance – Making it Fast

Performance is about how quickly the system responds. Integration must be optimized to avoid delays.

Why important? To provide a good user experience.

Real-life: The mobile app should load balances quickly.

School: The portal should load fee data fast.

Home: Your apps should open quickly.

Nigerian: Banks optimize for high transaction volumes.

Illustration:

  Performance Tips
  ┌──────────────────────────────────┐
  │  Use efficient queries           │
  │  Limit data transferred          │
  │  Cache frequently used data      │
  └──────────────────────────────────┘

Mini summary: Performance is about speed.

Lesson 14 · Monitoring – Watching the System

Monitoring is checking that integrations are working and performance is good. Dynamics 365 has tools for monitoring.

Why important? To catch issues early.

Real-life: The IT team monitors API calls for errors.

School: The IT team checks if the portal is working.

Home: You check your internet speed.

Nigerian: A bank monitors its ATMs and online banking.

Illustration:

  Monitoring Dashboard
  ┌──────────────────────────────────┐
  │  API calls: 1,000/min           │
  │  Errors: 0                       │
  │  Response time: 200ms            │
  └──────────────────────────────────┘

Mini summary: Monitoring keeps systems healthy.

Lesson 15 · Future Trends – What's Next?

Integration and development are always evolving. AI, machine learning, and real-time integration are the future.

Why important? To stay ahead.

Real-life: AI-powered chatbots will integrate with Dynamics 365.

School: AI could predict student performance.

Home: Smart devices integrate with apps.

Nigerian: Banks are adopting AI and real-time integrations.

Illustration:

  Future Trends
  ┌──────────────────────────────────┐
  │  AI & Machine Learning           │
  │  Real-time integration           │
  │  Event-driven architectures      │
  └──────────────────────────────────┘

Mini summary: The future is smarter and faster integration.

📝 Key Vocabulary (simple definitions)

• Integration – Connecting systems together.
• API – A messenger between systems.
• OData – A language for data queries.
• Data Management – Tool for importing/exporting data.
• Change Tracking – Recording what data changed.
• Power Platform – Low-code tools for integration.
• X++ – Programming language for Dynamics 365.
• Chain of Command – Safe way to extend code.
• Data Entity – Container for data.
• Security – Protecting data.

🧠 Important Concepts

• Interoperability: Systems must work together.
• Scalability: Systems must handle growth.
• Security: Data must be protected.
• Maintainability: Systems must be easy to update.

📋 Step-by-Step Explanations

How to integrate a mobile app with Dynamics 365:

1. Create an API endpoint in Dynamics 365.
2. Use OData to expose data.
3. In the mobile app, call the API.
4. Handle the response and display data.
5. Implement security (authentication).

How to import customer data using Data Management:

1. Prepare an Excel file with customer data.
2. Go to Data Management in Dynamics 365.
3. Select the "Customer" data entity.
4. Upload the file and map fields.
5. Run the import and validate.

🌍 Real-life Examples

• GTBank uses APIs to connect its mobile app to core systems.
• Access Bank uses Power Automate for workflow automation.

🇳🇬 Nigerian Examples

• First Bank uses OData for data integration with partners.
• Zenith Bank uses Data Management for customer onboarding.

🎈 Fun Examples for Children

• Like connecting your game console to the internet.
• Like syncing your phone contacts to the cloud.

🏡 Everyday Examples

• Your family uses a shared calendar app – that’s integration.
• Your phone syncs photos to the cloud automatically.

👪 Parent Tips

• Explain how your phone connects to different apps.
• Show how devices sync data automatically.

🔎 Interesting Facts

• The first API was created in the 1960s.
• Power Automate has over 300 connectors to different systems.

🧾 Remember This

• Integration connects systems.
• APIs are messengers.
• Data Management moves bulk data.
• Security protects data.

❌ Common Mistakes

• Not using change tracking – leads to slow syncs.
• Ignoring security – leads to data breaches.
• Not monitoring integrations – leads to undetected failures.

✅ Best Practices

• Use APIs for real-time integration.
• Use Data Management for bulk data.
• Implement strong security.
• Monitor integrations regularly.

📊 ASCII Illustrations

Flowchart: Integration Architecture

  Mobile App → API → Dynamics 365 → Database
       ↑                  ↓
       └──────────────────┘

Timeline: Data Sync Process

  Step 1: Change occurs in Dynamics 365
  Step 2: Change tracking records it
  Step 3: External system queries changes
  Step 4: External system updates its data

Comparison Table: Integration Methods

📌 End-of-Module Summary

In Module Eight, we explored system integration and development. We learned that integration connects Dynamics 365 with other systems using APIs, OData, and Data Management. Power Platform provides low-code tools for integration. Development extends the system using X++ and Chain of Command. Security and performance are critical. Monitoring ensures everything works smoothly. Finally, we looked at future trends like AI and real-time integration.

You now understand how the bank's systems work together and how they can be customized.

❓ Frequently Asked Questions (10)

1. What is integration? – Connecting systems together.
2. What is an API? – A messenger between systems.
3. What is OData? – A language for data queries.
4. What is Data Management? – Tool for importing/exporting data.
5. What is change tracking? – Recording what changed.
6. What is Power Platform? – Low-code integration tools.
7. What is X++? – Programming language for Dynamics 365.
8. What is Chain of Command? – Safe way to extend code.
9. What is a data entity? – Container for data.
10. How does Dynamics 365 help? – It provides tools for integration and customization.

🔗 Matching Exercises

Match the term with the description:

📖 Scenario-based Exercises

Scenario 1: The bank wants to connect its ATM network to Dynamics 365. How should it do this?

Scenario 2: The bank needs to import 10,000 new customers from an Excel file. What tool should it use?

👥 Group Activity

In groups, design a simple integration between a school’s attendance system and its fee system. Explain how data would flow.

🧑 Individual Activity

List 5 systems a bank might have and explain how they could integrate with Dynamics 365.

🛠️ Mini Project

Create a diagram showing how a mobile app, an ATM, and online banking connect to Dynamics 365. Label the APIs and data flows.

📝 Practical Assignment

Write a 2-page report on how a bank can use integration and development to improve its operations. Include at least 5 examples.

🔑 Key Takeaways

• Integration connects systems.
• APIs are messengers.
• Data Management moves bulk data.
• Power Platform enables low-code.
• X++ and CoC extend the system.

🗣️ Classroom Discussion Questions

• Why is integration important for banks?
• What could go wrong if an API fails?
• How can customization help a bank stand out?

🎓 Course Wrap-Up

Congratulations! You have completed all eight modules of the Microsoft Dynamics 365 for Banking and Financial Services course. You now have a solid foundation in how Dynamics 365 helps banks manage cash, credit, fixed assets, budgeting, reporting, and integration.

Remember, this is just the beginning. Dynamics 365 is a vast system, and there is always more to learn. Keep exploring, keep asking questions, and keep building your skills.

Next steps: Consider getting certified, practicing with a demo environment, or diving deeper into specific modules like Cash Management or Financial Reporting.

🎉 End of Module Eight · You have completed the course!