Zapier Copilot — SeQura ↔ Holded (Accounting) Daily Reconciliation

Use this in Zapier Agents Copilot to generate a daily reconciliation report between SeQura and Holded. It replaces the classic Shopify example with SeQura and explicitly integrates with Holded (accounting).

Trigger: Schedule by Zapier — Every Day at 02:00 UTC

Instructions to follow (paste into Copilot)

1. Retrieve all completed transactions from SeQura for the previous day.
2. For each SeQura transaction, search for a corresponding transaction in Holded using a unique identifier (e.g., order ID, invoice number, or a custom reference).
3. If a matching transaction is found in Holded: a. Compare the transaction amount, date, status, and any associated fees between SeQura and Holded. b. If all key details match, mark the transaction as successfully reconciled. c. If any details do not match, flag the transaction as a discrepancy, noting the differences.
4. If no matching transaction is found in Holded for a SeQura transaction, flag the SeQura transaction as "missing in Holded".
5. Retrieve all new or updated transactions from Holded for the previous day that are relevant to SeQura (e.g., payments received via SeQura).
6. For each relevant Holded transaction, search for a corresponding transaction in SeQura using the same unique identifier.
7. If no matching transaction is found in SeQura for a Holded transaction, flag the Holded transaction as "missing in SeQura".
8. Compile a comprehensive reconciliation report including: a. A list of all successfully reconciled transactions. b. A list of all discrepancies found, detailing the differences. c. A list of SeQura transactions missing in Holded. d. A list of Holded transactions missing in SeQura.
9. Send the reconciliation report to the designated accounting email address.

Expected outcome: A daily report is generated, providing a clear overview of the reconciliation status between SeQura and Holded, highlighting any discrepancies or missing entries for manual review and action.

Prompt reconciliation Agent (daily)

Instructions to follow (paste into Copilot)

Reconciliation Agent (daily)

Act as my finance assistant. For each disbursement for merchant ABC-123 in the last 24 hours:
1) Verify totals and currency
2) Check fee breakdowns (fixed, variable, shopper fees, VAT)
3) Flag retentions/adjustments over €50
4) List orders missing secondary references
5) Output a summary table and a bullet list of anomalies.

Reporting Agent (monthly)

Generate a monthly summary for merchant ABC-123 including:
- Total disbursements and average fee %
- # of transactions and disputes/adjustments
- Top 5 largest adjustments with references
Return a Markdown report and a CSV block for export.

Anomaly Agent (ad‑hoc)

Compare this month’s disbursements vs. last month for merchant ABC-123.
Highlight unusual fee patterns and retained amounts.
Recommend follow-ups with references to disbursement IDs.

Replace ABC-123 with your merchant reference; consider pinning these as Saved prompts in your client.