Subscription Management & Reporting Model

I need a single, reliable model that lets me keep an eye on every subscription our company signs—monthly, quarterly, and annual plans alike—and then turns that data into meaningful business information.

Here is what the finished solution has to do for me:

• Track all live and expired subscriptions in one place, flagging key dates and amounts.
• Compare budgeted versus actual spend at the click of a button so I can see overruns immediately.
• Handle provisioning logic and apportion each subscription cost across the correct cost centres or projects.
• Accept bulk uploads of signed‐off subscription approvals, then store those files for quick reference.
• Produce concise MIS packs that summarise totals, variances, and upcoming renewals.
• Capture and store the SAP document number tied to every payment along with any extra fields we decide are useful.
• Seamlessly plug into our custom internal software (this is essential) while remaining able to export to Excel or PDF for management circulation.

Acceptance criteria: the model must run without manual formula fixes, populate all reports from a single data entry, and generate each view in under 30 seconds on a standard workstation.

If you have experience stitching together finance data pipelines, reporting logic, and light workflow automation—especially where SAP references are involved—I’d like to see how you would approach this and the timeline you expect to meet.