Automate Payment Status Data Entry

I have already consolidated several scattered spreadsheets into a single hub and introduced live pipeline tracking for our projects. The remaining gap is the routine capture of payment and add-on status updates, which is still being entered by hand. I want that final step fully automated. Your task is to build an end-to-end workflow that pulls each new payment event from our existing systems, records the status in our central database, and immediately reflects any changes in the dashboard my team uses every day. Think Zapier, Make.com, custom API scripts or whichever stack you know best—the goal is a hands-off, real-time feed that never misses a transaction. I am especially interested in freelancers who can point to previous automation work rather than basic typing projects, so in your message focus on the experience you have integrating payment data and keeping status fields in sync across platforms. Acceptance criteria for the hand-off: • A working automation that runs without manual intervention • All payment and add-on status fields update in real time (or near real time, <5 min) • Clear documentation showing how the flow is configured, how to troubleshoot failures, and how to extend it later Once the workflow is running smoothly we can look at optimizing our photographer scheduling and other departments in similar fashion, but for now this project is strictly about eliminating manual payment-status data entry.