Description
Automate our monthly financial reporting pipeline (QuickBooks Online + ClickUp) We're a marketing agency looking to automate a monthly reporting process we currently assemble by hand across several systems. This is a well-defined project with an objective pass/fail test (details below), so we know exactly what "done" looks like. What we need built A pipeline that pulls data from our systems, runs our specific profitability math, and produces a monthly report automatically when we close the books: - Pull revenue by client and by service line from QuickBooks - Online (read-only) - Pull labor hours by employee, client, and service line from ClickUp (read-only) - Ingest monthly media spend by client (we'll advise the cleanest source — API or structured spreadsheet) - Apply our agency P&L logic — gross margin, then delivery margin after labor, then overhead to net — sliceable two ways: by account and by service line - Assign a green/yellow/red profitability status per account and per service line, with month-over-month trend - Deliver a monthly report package (executive summary + detail) automatically at book close - Include a "chat about this report" feature so we can ask questions of the numbers in plain language (e.g., "why was labor on Client X high this month?") - A lightweight weekly check that confirms everyone has entered their time in ClickUp and flags who hasn't The system must be read-only on our source systems — it never writes back to or edits QuickBooks or ClickUp. T