Dates anchored to the contract.
Each reporting period is derived from the signature date. The configured delivery window then counts calendar days or business days, consulting a Colombian holiday calendar.
I redesigned and developed an end-to-end contractual financial reporting workflow: from contract-based deadlines to multi-level authorization and delivery evidence.
100+fiduciary reports sent daily
in the original operation
5contractual reporting
frequencies
End to endProcess reengineering,
architecture & development
Manual distribution and scattered business information made it difficult to track contractual deadlines and required attachments. Reports could be late or incomplete, while several business roles needed to review them.
The solution brought business setup, date calculation, preparation, cascading authorization, delivery and monitoring into one connected workflow.
Start with business setup, or use the sample batch. Your actions carry across all four views.
Illustrative screens recreated to protect business confidentiality. Based on a solution I designed and developed; all data shown is fictional.
Select a flow and open its actions to understand the architecture.
Each reporting period is derived from the signature date. The configured delivery window then counts calendar days or business days, consulting a Colombian holiday calendar.
Required fields, duplicate setup rules and mandatory attachments are checked before the workflow moves forward. There is no rejection state in this reporting process.
Preparers assemble the reports. Coordinators, directors and managers review in sequence. Delivery evidence records when the message was sent, who initiated it and which filenames were included.
I redesigned the process, built the canvas-app screens and functional workflows, structured SharePoint storage, implemented the Excel calculations and holiday data, connected the Outlook delivery, and developed reporting and analytics with Power BI and DAX.
Looking for someone who connects process design, Microsoft Power Platform and practical software engineering?
Start a conversation ↗Explore more solutions →