Frequently Asked Questions

Everything you need to know about using the M-Pesa Processor

This guide will walk you through the process of importing M-Pesa statement files (Header and Lines) into D365 Finance and Operations using Data Management.

1
Access Data Management

Navigate to: Workspaces > Data Management

2
Create Import Project
  • Click Import tile
  • Enter project name (e.g., "M-Pesa Statement Import")
  • Select Excel as source data format
3
Add Header Entity
  • Search for Bank statement header
  • Upload M-Pesa-Header.xlsx
4
Add Lines Entity
  • Search for Bank statement lines
  • Upload M-Pesa-Lines.xlsx

⚠️ Important: Always import Header BEFORE Lines!

5
Execute Import

Review entities and click Import

6
Validate Import

Check Cash and bank management > Bank statements

7
Reconcile Statement

Match and post bank reconciliation

The opening balance is the account balance at the start of the statement period. This should match the closing balance from your previous statement. If this is your first statement, enter the initial account balance.

The closing balance is automatically extracted from your M-Pesa statement file. Look for a row labeled "Closing Balance" in your Excel file.

Common reasons for import failures:

  • Incorrect file format - ensure you're using the generated Excel files
  • Duplicate Statement ID - each statement must have a unique ID
  • Missing required fields - check the field mapping in D365
  • Bank account doesn't exist - ensure MPESA bank account is set up in D365

Each time you process a statement, it generates a unique Statement ID based on the timestamp. However, you should avoid uploading duplicate statements to D365 to prevent reconciliation issues.

Go to Cash and bank management > Bank accounts and create:

  • Bank account number: MPESA
  • Currency: KES
  • Account type: Bank
  • Main account: Link to appropriate ledger account

Error: "Bank account not found"

Solution: Create the MPESA bank account in D365 F&O before importing statements.

Error: "Duplicate Statement ID"

Solution: This statement has already been imported. Check the History page.

Balances don't match

Solution: Verify that:

  • Opening balance matches previous closing balance
  • Closing balance was correctly extracted
  • All transactions were properly imported

📞 Need More Help?

If you encounter issues not covered in this FAQ: