Using the Cash Applied Report in Dynamics 365 Business Central
UG Expert Robb Delprado breaks down how to use the Cash Applied Report tool in Business Central.
Key Takeaways
- Overview: The Cash Applied Report is a valuable but often overlooked tool in Business Central. In BC 28.1 and earlier, it does not appear in the search, but it can be accessed from the Customer Card under Reports and bookmarked for quick access. The report can be filtered by customer or posting date to review how payments were applied.
- Useful applications: The report helps verify that customer payments are applied to the correct invoices. This makes it especially useful when training accounts receivable staff, as payments can be posted directly to a customer account without closing invoices. By reviewing the report regularly, organizations can confirm that payments have been properly matched to outstanding invoices.
- Example cases: Cash applications can be tracked regardless of whether payments are entered through cash receipt journals or bank deposits. In the demonstration, Robb used example payments and applied them to specific invoices, showing how multiple payment methods still produce a clear record of invoice applications.
- A beneficial tool: The Cash Applied Report is an effective reconciliation and audit tool. Running the report for a specific posting date allows users to verify all invoice applications and identify potential posting errors. It also provides auditors with a clear trail of how customer payments were applied, simplifying year-end testing and compliance reviews.
