AI Collections Dashboard Integration

via Freelancer ·

Budget / Salary$30–250
TypeFreelance project
LocationRemote
Posted1 hour ago
I run an ISP and live inside two systems every day—Splynx for service management and Zoho Books for accounting. I’m tired of exporting spreadsheets just to answer one simple question: “How much money did we actually collect today, this week, and this month?”

What I need is a small AI-driven agent that automatically pulls payment data from both Splynx and Zoho Books, reconciles it, and presents the numbers on a clean, real-time dashboard. No emails or mobile push—just a browser-based dashboard I can leave open on my screen.

Core expectations
• The solution must authenticate securely with both Splynx and Zoho Books APIs, fetch successful payments, and deduplicate any overlaps between the two systems.
• Calculations for daily, weekly, and monthly collections should refresh on a schedule I can adjust (daily at minimum).
• The dashboard should load quickly, show totals at a glance, and let me click into each period for a simple transaction list.
• Source code, environment instructions, and a short hand-off video are part of the delivery, along with one week of post-launch support to fix any data mismatches.

Accuracy is paramount: the totals on the dashboard should mirror Zoho Books within a rounding difference I can explain to my accountant. If you’ve handled API integrations and lightweight data visualisation before, this should be straightforward—I just need it done cleanly so I can focus on running the network, not reconciling numbers.
php mysql data visualization data analysis data integration api integration data management ai chatbot ai development ai automation
Apply on Freelancer →

Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.