Gold is the lifeblood of any trading company, and managing it well is the difference between a thriving enterprise and a cautionary tale told in taverns along the Sword Coast. For the Waterdeep Trading Company, the Cash and Bank Management module in Dynamics 365 Finance is where every coin, deposit, payment, and reconciliation is tracked with precision and purpose.

Cash and Bank Management is the module that connects the treasury to the ledger. It governs how bank transactions are categorized, how accounts are structured and reconciled, how statements are imported and matched, and how outgoing payments are secured against fraud. Greta Ironfist has made it clear: every gold piece that enters or leaves the company's vaults must be accounted for, verified, and posted to the correct ledger account. Whether the company is settling a trade agreement with a merchant guild, disbursing wages to dockworkers, or reconciling a month of transactions against the Bank of Faerûn's statement, these configurations ensure that the treasury operates with transparency, accuracy, and control.

What You Will Learn in This Guide

Cash and Bank Controls:  Establish the foundational rules for banking operations by configuring bank transaction types, transaction groups, reason codes, posting profiles, and module parameters. These controls determine how every movement of funds is categorized, posted, and reported.

Bank Accounts:  Configure the bank accounts that manage the company's cash flow, from creating bank groups and individual accounts to printing branded checks, linking accounts to the legal entity, performing reconciliations, and reviewing account statistics.

Advanced Bank Reconciliation:  Transform reconciliation from a manual, line-by-line process into an automated workflow. This module covers approval workflows, enabling advanced reconciliation, configuring number sequences, adding statements manually, mapping transaction codes, using the reconciliation worksheet, and building matching rules.

Bank Statement Import:  Automate the ingestion of bank statement data by retrieving XSLT transformation templates, configuring import data projects, defining statement formats, linking accounts to import formats, and importing BAI2 statement files for immediate reconciliation.

Positive Pay:  Protect outgoing payments with a fraud-prevention mechanism that generates verified payment files for the bank. This module covers configuring Positive Pay formats and generating the files that ensure only authorized disbursements are processed.

By completing these labs, we will have built a comprehensive banking framework for the Waterdeep Trading Company, one that supports daily cash operations, automates reconciliation, and secures every payment that leaves the treasury.