Study guide

7.5 Cash Flow Forecasting Setup & Automation

Microsoft Certified: Dynamics 365 Finance Functional Consultant Associate MB-310

Track your progress as you read

Finished sections get a check mark.

1 Chapter 1: MB-310 Exam Overview & Financial Architecture

1.1 MB-310 Exam Structure, Skills Measured & Consultant Role 1.2 Dynamics 365 Finance Architecture, Legal Entities & Global Address Book 1.3 Hands-on Lab Strategy & Preparation Framework

2 Chapter 2: Chart of Accounts & Main Accounts

2.1 Designing Chart of Accounts & Main Account Types 2.2 Main Account Categories & Ledger Account Aliases 2.3 Balance Control Accounts & Year-End Opening Account Setup 2.4 Legal Entity Overrides for Main Accounts & Dimensions

3 Chapter 3: Financial Dimensions & Account Structures

3.1 Custom & Entity-Backed Financial Dimensions 3.2 Financial Tags: Limits, Storage & Ledger Settlement Use 3.3 Account Structures, Segment Criteria & Activation 3.4 Advanced Rules & Advanced Rule Structures 3.5 Derived Dimensions & Dimension Default Templates

4 Chapter 4: Ledgers, Calendars & Currencies

4.1 Fiscal Calendars, Period Statuses & Module Access Control 4.2 Posting Layers, Multi-GAAP Reporting & the Ledger Form 4.3 Currency Exchange Types, Rate Providers & Triangulation 4.4 Accounting & Reporting Currencies (Dual-Currency Architecture) 4.5 Foreign Currency Revaluation & Revaluation Posting Profiles

5 Chapter 5: General Ledger Journals & Allocations

5.1 Journal Names & Voucher Number Sequences 5.2 Journal Control & Posting Restriction Rules 5.3 Journal Entry, the One-Voucher Rule, Validation & Posting 5.4 Reversals, Storno Corrections & Excel Integration 5.5 Ledger Allocation Rules & the Four Allocation Methods 5.6 Allocation Processing & Periodic (Recurring) Journals

6 Chapter 6: Intercompany Accounting & Settlements

6.1 Intercompany Accounting Setup & Due-To / Due-From Postings 6.2 Intercompany Journal Processing & Multi-Company Vouchers 6.3 Ledger Settlements Configuration & Processing

7 Chapter 7: Cash and Bank Management

7.1 Bank Groups, Bank Accounts & Ledger Integration 7.2 Payment Formats, Bank FX Revaluation & Shared Payment Setup 7.3 Manual vs. Advanced Bank Reconciliation & Statement Formats 7.4 Matching Rule Sets, Reconciliation Execution & Reversals 7.5 Cash Flow Forecasting Setup & Automation 7.6 Customer and Vendor Netting

8 Chapter 8: Periodic Closing & Financial Consolidations

8.1 Financial Period Close Workspace, Closing Roles & Schedules 8.2 Year-End Close Configuration & General Ledger Balance Carryforward 8.3 Consolidations Online: Legal Entity Setup, COA Mapping & Currency Translation 8.4 Import Consolidations & Intercompany Elimination Rules

9 Chapter 9: Sales Tax & Withholding Tax

9.1 Sales Tax Engine Hierarchy, Authorities & Settlement Periods 9.2 Ledger Posting Groups, Sales Tax Codes & Calculation Methods 9.3 Sales Tax Groups, Item Sales Tax Groups & Tax Exemptions 9.4 Sales Tax Adjustments and Settle and Post Sales Tax 9.5 Withholding Tax & US 1099 Vendor Reporting

10 Chapter 10: Accounts Receivable Setup & Invoicing

10.1 Customer Master, Customer Groups & Shared Customers 10.2 Customer Posting Profiles & Account Code Precedence 10.3 Free Text Invoices, Recurring Invoice Templates & AR Charges 10.4 Sales Order Invoicing, Billing Classifications & Prepayments 10.5 Customer Payment Methods, Payment Processing & Customer Bank Accounts

11 Chapter 11: Credit Management & Collections

11.1 Credit Management Architecture & Customer Credit Groups 11.2 Risk Scoring, Credit Limits, Blocking Rules & Credit Holds 11.3 Aging Definitions, Collections Workspace & Customer Pools 11.4 Collection Letter Sequences & Interest Notes 11.5 Customer Write-Offs, Bad Debt & Write-Off Reversals

12 Chapter 12: Subscription Billing & Revenue Deferrals

12.1 Recurring Contract Billing, Billing Schedules & Milestones 12.2 Deferral Principles, Deferral Defaults & Schedule Calculation Methods 12.3 Recognition Processing, Expense Deferrals & Modifying Schedules 12.4 Multiple Element Revenue Allocation (MEA / ASC 606)

13 Chapter 13: Accounts Payable & Invoice Processing

13.1 Shared Vendors, Global Address Book & Vendor Groups 13.2 Vendor Posting Profiles, AP Parameters & Vendor Bank Accounts 13.3 Invoice Matching Setup (2-Way, 3-Way), Tolerances & Exceptions 13.4 Vendor Invoicing Methods, Journals & Invoice Automation

14 Chapter 14: Vendor Payments & Expense Management

14.1 Methods of Payment & the Vendor Payment Proposal Engine 14.2 Generating Payments, Centralized Payments & Check Lifecycle 14.3 Expense Management Configuration, Categories & Policies 14.4 Expense Reports Processing, Mobile Receipts & Intercompany Expenses

15 Chapter 15: Budgeting & Budget Control

15.1 Budget Models, Budget Codes & Allocation Terms 15.2 Budget Register Entries, Workflows & Budget vs. Actual 15.3 Budget Transfer Rules & Processing Budget Transfers 15.4 Budget Control Configuration, Cycles, Rules & Budget Groups 15.5 Budget Funds Available, Over-Budget Permissions & Document Budget Check 15.6 Budget Planning Framework, Organization Hierarchies & Planning Processes 15.7 Budget Plans, Scenarios, Allocations & Generating Register Entries

16 Chapter 16: Fixed Assets Configuration & Transactions

16.1 Fixed Asset Groups, Asset Records & Group/Book Mapping 16.2 Depreciation Profiles: Methods & Conventions 16.3 Fixed Asset Books, Derived Books & Posting Profiles 16.4 Fixed Asset Acquisition Pathways 16.5 Depreciation Proposals, Multi-Company Runs & Fixed Asset Budgets 16.6 Fixed Asset Disposals: Sale, Scrap & Disposal Accounting 16.7 Fixed Asset Splits, Transfers & Reclassification 16.8 Asset Leasing (IFRS 16 / ASC 842)

7.5 Cash Flow Forecasting Setup & Automation

Key Takeaways Explain This Topic AI

Cash flow forecasting aggregates projected inflows and outflows from sales orders, purchase orders, open AR and AP transactions, budgets, and ledger accounts.

Each main account must be flagged for cash flow forecasting and mapped to a liquidity account before it contributes to the forecast.

Cash flow forecasting setup exists per module — Accounts receivable, Accounts payable, Budget, and Inventory management each have their own parameters.

Customer payment predictions in Finance Insights use a trained model to estimate when an invoice will actually be paid, refining the rule-based forecast.

Last updated: August 2026

7.5 Cash Flow Forecasting Setup & Automation

Quick Summary: Corporate liquidity management requires precise visibility into future cash inflows and outflows, as well as mechanisms to optimize working capital. Cash Flow Forecasting in Microsoft Dynamics 365 Finance combines operational data across the General Ledger, Accounts Receivable, Accounts Payable, Sales Orders, and Purchase Orders to model liquidity horizons. Powered by Process Automation and Finance Insights AI Customer Payment Predictions , treasury teams anticipate cash crunches before they occur. Furthermore, the Customer and Vendor Netting framework allows organizations trading with dual-role counterparties to offset open payables against receivables, eliminating unnecessary cash transfers and bank transaction fees.

1. Cash Flow Forecasting Architecture & Source Integration

Cash flow forecasting projects future cash positions by evaluating pending commitments and expected collections across core ERP modules.

  • Navigation
  • Parameters: Cash and bank management > Setup > Cash and bank management parameters > Cash flow forecast

Setup: Cash and bank management > Cash flow forecasting > Cash flow forecast setup +---------------------------------------------------------------------------------------------------------+

  • | Cash Flow Forecasting Source Ecosystem |
  • +---------------------------------------------------------------------------------------------------------+
  • | |
  • | +--------------------------+ +--------------------------+ +----------------------------------+ |
  • | | General Ledger Budgets | | Accounts Receivable (AR) | | Accounts Payable (AP) | |
  • | | - Approved Budget Models | | - Open Customer Invoices | | - Open Vendor Invoices | |
  • | | - Dependent Cash Flow Acct| | - Sales Orders (Planned) | | - Purchase Orders (Planned) | |
  • | | - Cash Flow Forecast Setup| | - Recurring AR Invoices | | - Recurring AP Invoices | |
  • | +--------------------------+ +--------------------------+ +----------------------------------+ |
  • | | | | |
  • | +-----------------------+ | +-----------------------+ |
  • | v v v |
  • | +----------------------------------------------------+ |
  • | | D365 Cash Flow Calculation Engine | |
  • | | - Payment Terms & Cash Discount Days | |
  • | | - AI Customer Payment Predictions (Finance Insights)| |
  • | | - Dependent Liquidity Bank Account Mapping | |
  • | +----------------------------------------------------+ |
  • | | |
  • | v |
  • | +----------------------------------------------------+ |
  • | | Cash Flow Horizon & Liquidity Workspaces | |
  • | | - Cash Overview & Bank Position Inquiry | |
  • | | - Short-Term & Long-Term Cash Inflow/Outflow Grids | |
  • | +----------------------------------------------------+ |
  • +---------------------------------------------------------------------------------------------------------+
  • Module Source Breakdown

Operational Source Forecast Contribution Calculation Timing & Maturity Date Determination

General Ledger (GL) Revenue / Expense Budgets Budget transaction dates mapped to default cash flow accounts.

Accounts Receivable (AR) Cash Inflows (+) Open invoice due dates; modified by payment terms and AI payment prediction probabilities.

Sales Orders (SO) Projected Inflows (+) Requested receipt date / Confirmed shipping date + Customer payment terms.

Accounts Payable (AP) Cash Outflows (-) Open invoice due dates / Cash discount cutoff dates.

Purchase Orders (PO) Projected Outflows (-) Delivery date on PO lines + Vendor payment terms.

Budget Register Entries Macro Forecast (In/Out) Budget model periods mapped to liquidity accounts for long-term horizons.

Configuring Dependent Cash Flow Accounts

In General Ledger, operational revenue and expense accounts do not physically hold cash. To reflect their cash impact, consultants configure Dependent Cash Flow Accounts ( General ledger > Chart of accounts > Accounts > Main accounts > Cash flow tab ):

When an expense line is posted or budgeted to account 601200 (Office Supplies), D365 evaluates the dependent cash flow setting.

The system automatically generates a projected cash outflow on the linked primary liquidity bank account ( 110110 - Operating Bank ) based on assigned payment term days.

2. Cash Flow Process Automation & AI Payment Predictions

To ensure that cash flow forecasts continuously reflect operational changes (e.g., new sales orders created, purchase orders confirmed, invoices paid), Dynamics 365 Finance leverages the Process Automation framework and Finance Insights machine learning models. +---------------------------------------------------------------------------------------------------------+

  • | Process Automation & AI Payment Prediction Architecture |
  • +---------------------------------------------------------------------------------------------------------+
  • | PROCESS AUTOMATION (System administration > Setup > Process automations) |
  • | - Recurrence: Nightly Batch (01:00 AM) |
  • | - Task: Recalculate Cash Flow Forecast across all Legal Entities (USMF, DEMF, GBSI) |
  • +---------------------------------------------------------------------------------------------------------+
  • |
  • v
  • +---------------------------------------------------------------------------------------------------------+
  • | FINANCE INSIGHTS / AI CUSTOMER PAYMENT PREDICTIONS |
  • | - Ingests: Customer payment history, invoice amounts, seasonality, customer credit score |
  • | - Evaluates: Invoice INV-8801 ($50,000, Due: Sept 10) |
  • | - Prediction Output: |
  • | * On-Time Probability (Sept 10): 15% |
  • | * Late 30 Days Probability (Oct 10): 80% ──> Cash Flow shifts $50,000 inflow to October forecast! |
  • | * Very Late (60+ Days): 5% |
  • +---------------------------------------------------------------------------------------------------------+
  • Setting Up Cash Flow Process Automation

Navigate to Cash and bank management > Cash flow forecasting > Cash flow forecast setup .

In the Action Pane, click Process automation .

Create a new automation schedule:

Schedule name: Daily_CashFlow_Recalc .

Execution time: 01:00:00 (Daily).

Include sources: Check General ledger budget, Accounts receivable, Accounts payable, Sales orders, and Purchase orders.

Click Finish . The background batch service executes incremental forecast refreshes automatically.

Finance Insights: Customer Payment Predictions

Traditional forecasting relies on the invoice Due date to project AR collections. However, customers frequently pay late. With Finance Insights / Customer Payment Predictions activated via Power Platform AI Builder:

Machine learning models classify open AR invoices into three risk buckets: On-time , Late , and Very late .

The cash flow calculation engine dynamically shifts expected cash collection dates to the predicted payment date, drastically reducing forecast error.

3. Making a Main Account Visible to the Forecast

A main account contributes nothing to the cash flow forecast until it is explicitly enabled. On Cash and bank management > Setup > Cash flow forecasting setup , each relevant main account is flagged for cash flow forecasting and pointed at a liquidity account — the bank or cash account the movement is expected to hit.

  • Setup area What it configures
  • General ledger Which main accounts forecast, and their liquidity accounts
  • Accounts receivable How many days after the due date customers actually pay, and the AR liquidity account
  • Accounts payable Expected payment lag on vendor invoices, and the AP liquidity account
  • Budget Which budget model feeds the forecast, and over what horizon
  • Inventory management How purchase and sales order lines translate into expected cash

The most common implementation failure is an incomplete general ledger setup: the forecast runs, produces a number, and quietly omits whole categories of cash movement because those accounts were never flagged.

4. Which Documents Feed the Forecast

  • Source Contributes Timing basis
  • Open customer invoices Inflow Due date plus the configured AR delay
  • Open vendor invoices Outflow Due date plus the configured AP delay
  • Confirmed purchase orders not yet invoiced Outflow Expected receipt date plus lead time
  • Confirmed sales orders not yet invoiced Inflow Expected ship date plus terms
  • Budget register entries Both Budget period
  • Ledger balances on forecast-enabled accounts Both Posting date

This is why an approved but uninvoiced purchase order still appears as a projected outflow: the forecast deliberately looks past posted transactions into committed but unposted documents.

5. Running and Refreshing the Forecast

Forecast data is calculated and stored , not computed live on every page open. The Calculate cash flow forecasts periodic process, normally scheduled as a nightly batch, refreshes the stored projection. A stale forecast that "ignores yesterday's orders" is almost always an unscheduled or failed batch rather than a setup error.

Results surface through the Cash overview workspace and the cash flow forecast inquiries, where the projection can be sliced by legal entity, bank account, and currency, and viewed in either the accounting currency or a chosen reporting currency.

Exam trap: Cash flow forecasting is a projection , not a subledger. It posts nothing, changes no balances, and does not reserve funds. Anything in a scenario about blocking a transaction for lack of money is budget control, not cash flow forecasting.