📘 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 Two · Cash and Bank Management in Dynamics 365

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

🌟 Module Introduction

Welcome to Module Two! In Module One, we learned that Dynamics 365 is the “brain” of a bank. Now we are going to zoom in on one of the most important jobs: managing cash and bank accounts.

Think of a bank as a giant water tank. Money flows in (deposits) and flows out (withdrawals). The bank must know exactly how much water is in the tank at every second. That’s what Cash and Bank Management does – it tracks every drop of money.

In this module, we will learn how Dynamics 365 helps banks handle bank accounts, reconcile statements, process payments, and forecast cash flow – all in a way that is fast, safe, and automatic.

🎯 Learning Objectives

After this module, you will be able to:

• Explain what “cash management” means in a bank.
• Describe how Dynamics 365 tracks bank accounts and transactions.
• Understand the process of bank reconciliation – and why it matters.
• Explain how electronic payments work.
• Give examples of cash flow forecasting.
• Tell how Dynamics 365 helps banks stay safe and accurate.

📖 Warm-up Story · The Mystery of the Missing Naira

At Golden Chest Bank, the manager, Mr. Ade, was worried. The bank’s records showed they had ₦10,000,000 in the main account. But the bank’s own statement from the Central Bank showed ₦9,500,000. There was a difference of ₦500,000 – like a missing bag of money!

Every day, the bank had hundreds of deposits and withdrawals. Some were cheques, some were transfers, some were ATM withdrawals. It was like a puzzle with too many pieces.

Then, the bank installed Dynamics 365. The system automatically matched every transaction with the bank statement. It found that two cheques had not yet been cleared – that was the missing ₦500,000. The system reconciled everything in minutes. Mr. Ade smiled. He said, “This is like having a super detective in the computer!”

This module teaches you how Dynamics 365 solves such mysteries every day.

📚 Main Lessons

Lesson 1 · What is Cash and Bank Management?

Definition: Cash and Bank Management is the part of Dynamics 365 that watches over all the money in a bank’s accounts – where it comes from, where it goes, and how much is left.

Why important? Without it, a bank would not know its real balance. It could lend money it doesn’t have!

Simple explanation: It’s like a digital wallet that never forgets a single coin.

Real-life example: When you check your bank balance on your phone, Cash Management updates that number.

School example: The school’s canteen manager uses a register to record how much money was collected and spent each day.

Home example: A parent writes down all expenses in a notebook – but this is digital and automatic.

Nigerian example: A bank in Lagos uses Cash Management to track all the deposits from thousands of market traders.

Illustration:

  Cash Management = The Money Watchdog
  ┌──────────────────────────────────┐
  │  Deposits  →  Bank Account  →  Withdrawals  │
  │  (in)          (balance)        (out)        │
  └──────────────────────────────────┘

Mini summary: Cash Management keeps a perfect record of every naira in the bank.

Lesson 2 · Bank Accounts in Dynamics 365

In Dynamics 365, every bank account is set up like a digital file. It stores the account number, bank name, branch, currency (like Naira or Dollars), and the current balance.

Why important? So the system knows exactly which account to use for each transaction.

Real-life: A bank has a main account, a savings account, and a foreign currency account – all set up in the system.

School: The school has a general fund, a sports fund, and a library fund – each is like a separate bank account.

Home: A family might have a “groceries” jar and a “holiday” jar – Dynamics 365 does this digitally.

Nigerian: A bank in Kano sets up accounts for each branch – each has its own account number in the system.

Illustration:

  Bank Account Profile
  ┌──────────────────────────────────┐
  │  Account Name: Main Checking     │
  │  Account Number: 101-234-567     │
  │  Bank: First Bank Nigeria        │
  │  Currency: NGN                   │
  │  Balance: ₦15,000,000            │
  └──────────────────────────────────┘

Mini summary: Bank accounts in Dynamics 365 are like digital ID cards for money.

Lesson 3 · Transaction Types – What Moves Money?

A transaction is any action that changes the balance of an account. Deposits, withdrawals, transfers, and fees are all transactions.

Definition: Transaction types are categories that tell the system what kind of movement happened.

Why important? So the system can group and report transactions correctly – like separating deposits from fees.

Real-life: When you use your ATM card, it creates a “withdrawal” transaction.

School: Paying for a field trip is an “expense” transaction.

Home: Receiving pocket money is a “deposit” transaction.

Nigerian: A bank in Ibadan records loan repayments as a specific transaction type.

Illustration:

  Transaction Types
  ┌────────────┬────────────────────┐
  │ Type       │ Example            │
  ├────────────┼────────────────────┤
  │ Deposit    │ Cash paid in       │
  │ Withdrawal │ ATM cash out       │
  │ Transfer   │ Send to another    │
  │ Fee        │ Monthly service    │
  │ Interest   │ Money earned       │
  └────────────┴────────────────────┘

Mini summary: Transaction types help the system understand what happened to the money.

Lesson 4 · Bank Statements – The Bank's Report Card

A bank statement is a document that shows all the transactions that happened in an account over a period – like a report card for money.

Why important? The bank needs to compare its internal records with the bank statement to make sure they match – this is called reconciliation.

Real-life: Your parents check their bank statement every month to see what was spent.

School: The school gets a statement from the bank showing all deposits of school fees.

Home: You keep a list of what you spent your pocket money on.

Nigerian: A bank in Benin reconciles its statement with the Central Bank's records.

Illustration:

  Bank Statement (simplified)
  ┌────────┬────────────┬───────────┬─────────┐
  │ Date   │ Description│ Deposit   │ Withdraw│
  ├────────┼────────────┼───────────┼─────────┤
  │ 01/04  │ Deposit    │ ₦50,000   │         │
  │ 02/04  │ ATM        │           │ ₦10,000 │
  │ 03/04  │ Transfer   │ ₦20,000   │         │
  └────────┴────────────┴───────────┴─────────┘

Mini summary: Bank statements are like a diary of every transaction.

Lesson 5 · Bank Reconciliation – The Matching Game

Reconciliation is the process of making sure the bank’s internal records match the bank statement. If they don’t match, the bank must find the difference.

Why important? To catch errors, fraud, or missing transactions.

Real-life: You check your list of expenses against your bank statement to see if they agree.

School: The school checks its fee register against bank deposits.

Home: You count your piggy bank money and compare it to your spending diary.

Nigerian: A bank in Port Harcourt reconciles daily to avoid losses.

Illustration:

  Internal Records  ↔  Bank Statement
        (must be equal!)
  If not equal → Find the difference (reconciliation)

Mini summary: Reconciliation is like a puzzle – matching two sets of numbers.

Lesson 6 · How Dynamics 365 Automates Reconciliation

Instead of doing reconciliation by hand (which takes hours), Dynamics 365 uses rules to automatically match transactions. It can match by amount, date, or reference number.

Why important? It saves time and reduces mistakes.

Real-life: The system matches a deposit of ₦50,000 in the internal records with a ₦50,000 deposit on the bank statement.

School: The system matches the fees paid by students with the bank's deposit list.

Home: An app that automatically matches your budget with your bank transactions.

Nigerian: A bank in Abuja uses automated reconciliation to close the day's books in minutes.

Illustration:

  Automatic Matching Flow
  ┌──────────────┐     ┌──────────────┐
  │ Internal     │     │ Bank         │
  │ Transaction  │────▶│ Statement    │
  │ ₦50,000      │     │ ₦50,000      │
  └──────────────┘     └──────────────┘
          │                     │
          └─────────┬───────────┘
                    ▼
              ✅ Matched!

Mini summary: Dynamics 365 is a smart matching machine.

Lesson 7 · Electronic Payments – Sending Money Fast

Electronic payments are transfers of money from one account to another using computers – no paper or cash needed.

Why important? They are faster, safer, and cheaper than cash.

Real-life: Your parents pay the school fees via bank transfer.

School: The school pays its suppliers online.

Home: You buy a game online using a debit card.

Nigerian: A bank in Enugu uses Dynamics 365 to process bulk payments to farmers.

Illustration:

  Electronic Payment Flow
  Bank A  ──▶  Payment Instruction  ──▶  Bank B
  (sender)    (via Dynamics 365)       (receiver)

Mini summary: Electronic payments are like digital cheques that arrive instantly.

Lesson 8 · Cash Flow Forecasting – Predicting the Future

Cash flow forecasting is estimating how much money will come in and go out in the future. It helps the bank plan ahead.

Why important? So the bank knows if it will have enough cash to pay bills and loans.

Real-life: You predict how much pocket money you will have next month.

School: The school predicts fees for next term.

Home: A family forecasts expenses for the next holiday.

Nigerian: A bank in Kano forecasts cash needs for the farming season.

Illustration:

  Cash Flow Forecast
  ┌────────┬────────────┬────────────┐
  │ Month  │ Money In   │ Money Out  │
  ├────────┼────────────┼────────────┤
  │ Jan    │ ₦100M      │ ₦80M       │
  │ Feb    │ ₦90M       │ ₦85M       │
  │ Mar    │ ₦110M      │ ₦95M       │
  └────────┴────────────┴────────────┘

Mini summary: Forecasting is like looking into a crystal ball for money.

Lesson 9 · Cheques and Other Instruments

Cheques are paper orders to pay a specific amount from one account to another. Dynamics 365 can track cheques from issue to clearance.

Real-life: Your grandfather gives you a birthday cheque.

School: The school receives cheques from parents for fees.

Nigerian: A bank in Lagos processes thousands of cheques daily.

Illustration:

  Cheque Lifecycle
  Issue Cheque → Give to Payee → Payee Deposits → Bank Clears → Money Moves

Mini summary: Cheques are paper promises that Dynamics 365 tracks.

Lesson 10 · Bank Transaction Codes – A Secret Language

Bank statements use codes to describe transactions (like “ATM” or “INT” for interest). Dynamics 365 maps these codes to transaction types so it understands them.

Real-life: You see “POS” on your statement – that means you used a point-of-sale machine.

School: The school sees “TFR” – that means a transfer.

Nigerian: A bank maps CBN codes to internal categories.

Illustration:

  Code Mapping
  Bank Code  →  Internal Type
  ATM        →  Withdrawal
  INT        →  Interest Earned
  CHG        →  Service Fee

Mini summary: Codes are like a secret language the system translates.

Lesson 11 · Multi-Currency Management

Banks deal with different currencies – Naira, Dollars, Euros. Dynamics 365 can handle multiple currencies and convert them using exchange rates.

Real-life: Your parents send money from the UK, and the bank converts it to Naira.

School: The school receives donations in Dollars.

Home: You exchange your travel money to local currency.

Nigerian: A bank in Abuja handles foreign remittances.

Illustration:

  USD 100 × Exchange Rate 500 = ₦50,000

Mini summary: Multi-currency helps banks work globally.

Lesson 12 · Interest Calculation – The Bank's Reward

Banks pay interest on savings and charge interest on loans. Dynamics 365 calculates interest automatically based on rules.

Real-life: Your savings account earns 5% interest per year.

School: The school earns interest on its fixed deposit.

Home: You earn interest from your savings box (if you invest).

Nigerian: A bank in Ilorin calculates interest on savings accounts daily.

Illustration:

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

Mini summary: Interest is the bank's way of rewarding savings.

Lesson 13 · Bank Reconciliation Reports

After reconciliation, Dynamics 365 can generate reports that show the reconciled balance and any differences.

Real-life: The manager gets a report showing all cleared and uncleared items.

School: The school gets a reconciliation report for the term.

Nigerian: A bank presents reconciliation reports to the board.

Illustration:

  Reconciliation Report
  Bank Balance: ₦10,000,000
  Less: Uncleared cheques: ₦500,000
  Equals: Book Balance: ₦9,500,000

Mini summary: Reports show the final reconciled position.

Lesson 14 · Security in Cash Management

Cash Management has strict security. Only authorized staff can approve payments or view sensitive data.

Real-life: You need a PIN to withdraw cash.

School: Only the bursar can approve payments.

Home: Parents keep the ATM card safe.

Nigerian: A bank uses two-factor authentication for large transfers.

Mini summary: Security keeps money safe from theft and errors.

Lesson 15 · Integration with Other Banking Systems

Dynamics 365 connects with ATMs, mobile apps, and online banking to update balances in real time.

Real-life: Your mobile banking app shows your balance – it gets data from Dynamics 365.

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

Home: A budgeting app connects to your bank account.

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

Mini summary: Integration makes everything work together seamlessly.

📝 Key Vocabulary (simple definitions)

• Cash Management – The system that tracks all money movements.
• Bank Statement – A list of transactions from the bank.
• Reconciliation – Making sure two sets of records match.
• Transaction – Any deposit, withdrawal, or transfer.
• Electronic Payment – Money sent digitally.
• Forecast – A prediction of future money flow.
• Cheque – A paper order to pay money.
• Interest – Money paid for using someone else's money.
• Currency – The type of money (₦, $, €).
• Integration – Connecting different systems together.

🧠 Important Concepts

• Real-time updates: Balances change instantly after each transaction.
• Audit trail: Every action is logged for security.
• Automation: The system does repetitive work without human help.
• Data accuracy: The system reduces human errors.

📋 Step-by-Step Explanations

How to reconcile a bank statement in Dynamics 365:

1. Import the bank statement file (electronic).
2. The system matches transactions automatically.
3. Manually review any unmatched items.
4. Post the reconciliation to update balances.
5. Generate a reconciliation report.

How to make an electronic payment:

1. Create a payment journal.
2. Enter vendor or customer details.
3. Enter the amount and date.
4. Approve the payment (if required).
5. Generate the payment file and send to bank.

🌍 Real-life Examples

• GTBank uses automated reconciliation to process millions of daily transactions.
• Access Bank uses electronic payments for salary disbursement.

🇳🇬 Nigerian Examples

• First Bank uses cash flow forecasting to plan for liquidity needs.
• Zenith Bank integrates Dynamics 365 with its mobile app for real-time balances.

🎈 Fun Examples for Children

• Like a video game that tracks your coins – every time you collect a coin, the counter goes up.
• Like a magic piggy bank that knows exactly how much you put in and take out.

🏡 Everyday Examples

• Using a prepaid card to buy lunch – the balance decreases automatically.
• Checking your school account to see if your fees are paid.

👪 Parent Tips

• Show your child how you check your bank statement online.
• Explain that the bank uses computers to keep money safe.

🔎 Interesting Facts

• Over 50% of bank transactions in Nigeria are now digital.
• Dynamics 365 can process thousands of transactions per second.

🧾 Remember This

• Cash Management tracks every naira in the bank.
• Reconciliation makes sure records match the bank statement.
• Electronic payments are fast and safe.
• Forecasting helps the bank plan ahead.

❌ Common Mistakes

• Forgetting to reconcile regularly – leads to errors.
• Not mapping transaction codes – the system can't understand the statement.
• Ignoring small differences – they can add up.

✅ Best Practices

• Reconcile bank accounts daily.
• Automate as much as possible.
• Use security features to prevent fraud.

📊 ASCII Illustrations

Flowchart: Bank Reconciliation Process

  Import Statement
        |
        V
  Auto-Match Transactions
        |
        V
  Review Unmatched Items
        |
        V
  Manual Match or Adjust
        |
        V
  Post Reconciliation
        |
        V
  Report Generated ✅

Timeline: Daily Cash Management Cycle

  8 AM  → System starts, yesterday's reconciliation checked.
  9 AM  → Process overnight electronic payments.
  10 AM → Import bank statements from Central Bank.
  11 AM → Auto-reconcile.
  12 PM → Review exceptions.
  2 PM  → Approve payments for the day.
  4 PM  → Forecast cash position.
  5 PM  → End-of-day report.

Comparison Table: Manual vs Automated Reconciliation

📌 End-of-Module Summary

In Module Two, we explored the world of Cash and Bank Management in Dynamics 365. We learned that the system tracks all bank accounts, transactions, and statements. Reconciliation is like a matching game that ensures accuracy. Electronic payments make transfers fast and safe. Cash flow forecasting helps the bank plan for the future. We also learned about security, multi-currency, and integration with other systems.

You now understand how Dynamics 365 acts as a digital guardian of the bank's money, ensuring every naira is accounted for.

❓ Frequently Asked Questions (10)

1. What is cash management? – It’s tracking all money in and out of a bank.
2. Why is reconciliation important? – To catch errors and fraud.
3. Can Dynamics 365 handle foreign currency? – Yes, it converts automatically.
4. How long does reconciliation take? – With automation, minutes.
5. Are electronic payments safe? – Yes, with encryption and security.
6. What is a bank statement? – A list of all transactions.
7. Can the system forecast cash? – Yes, based on past data.
8. What if a transaction doesn't match? – The system flags it for review.
9. Is training needed? – Yes, but the system is user-friendly.
10. How does it connect to mobile apps? – Through integration and APIs.

🔗 Matching Exercises

Match the term with the description:

📖 Scenario-based Exercises

Scenario 1: The bank’s records show ₦1,000,000, but the bank statement says ₦950,000. What steps would you take to reconcile?

Scenario 2: A customer wants to make a large transfer to another country. How would Dynamics 365 handle the multi-currency conversion?

👥 Group Activity

In groups, create a simple reconciliation process for a school’s bank account. List the steps the school would take to ensure records match the bank statement.

🧑 Individual Activity

Draw a timeline of a typical day for a bank’s cash management team. Include key tasks like importing statements, reconciling, and forecasting.

🛠️ Mini Project

Build a paper “Bank Statement” for a week. Include 5 deposits and 5 withdrawals. Then reconcile it with a mock internal record. Show the matched and unmatched items.

📝 Practical Assignment

Write a short essay (2 pages) explaining why a small bank in Nigeria should use Dynamics 365 for cash management. Mention at least 5 features and their benefits.

🔑 Key Takeaways

• Cash Management is the heart of a bank’s operations.
• Reconciliation ensures accuracy and trust.
• Electronic payments are the future.
• Forecasting helps banks stay prepared.
• Dynamics 365 automates and secures all these processes.

🗣️ Classroom Discussion Questions

• What would happen if a bank never reconciled its accounts?
• Why are electronic payments better than cash?
• How can forecasting help a bank avoid running out of money?

➡️ Preparation for Module 3

In Module 3, we will move to Accounts Receivable, Credit, and Collections. We will learn how Dynamics 365 manages loans, credit limits, and collections. Please think about how you borrow money or use a credit card – we will explore that next!

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

🧾 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!