Introducing Reconciliation Export

Version 1.0.91

We've added a reconciliation export feature that lets agents download a full Direct Debit reconciliation report for any selected period — in CSV or XLSX format — ready to be imported directly into accounting software like Xero or Sage.

Why This Matters

Reconciling Direct Debit collections against your ledger has historically meant cross-referencing multiple sources: collection confirmations, sweep notifications, forwarding records, and clawback adjustments. The reconciliation export brings all of this into a single structured file, eliminating manual data gathering and reducing the risk of errors.

What's in the Report?

Each row represents one collection event and includes every data point needed to reconcile end-to-end:

• Mandate Reference — ties the row back to the specific DD mandate in the system.
• Tenant Name — the tenant associated with the payment.
• Property — the property address linked to the mandate.
• Collection Date — when funds were debited from the tenant's account via BACS.
• Amount — the gross collected amount.
• Status — the outcome of the collection (collected, failed, clawback, etc.).
• Sweep Date — when funds moved from the Modulr collection account to the Griffin DD holding account.
• Forward Date — when funds were released from the holding account to the agent's client account.
• Clawback Amounts — any reversals or clawbacks applied to the collection.
• Net Settled Amount — the final amount settled after all adjustments.

How to Use It

From the Reports Page

1. Navigate to Reports in the dashboard.
2. Select your desired date range.
3. Choose your preferred format — CSV or XLSX.
4. Click Download to generate and save the report.

Via the API

The export can also be triggered programmatically, making it easy to automate reconciliation workflows or pipe data into your own systems. See the Reports API reference for endpoint details, request parameters, and response formats.

Accounting Software Compatibility

Software	Recommended Format	Notes
Xero	CSV or XLSX	Use the bank statement import or manual journal import flow
Sage	CSV or XLSX	Compatible with Sage 50 and Sage Business Cloud
Other / Custom	CSV	Universally compatible with any spreadsheet or import tool

Notes

• Reports are scoped per agent — each agent only sees data for their own mandates and collections.
• The hold period and clawback reserve logic is reflected in the sweep and forward dates, so the report accurately represents the timing of fund movements as they occurred.
• Failed collections will appear with a failed status and zero net settled amount, making them easy to identify for follow-up.