SinglePoint Transaction Reporting is the workhorse report every controller, treasurer and payment operations lead runs daily. More than 60 filterable fields per record, saved views, scheduled delivery, and native export to BAI2, SWIFT MT940, SWIFT MT942, CSV and PDF — all inside the same authenticated SinglePoint session.
This page walks through the full field catalogue, the saved-view workflow, scheduling cadences and the export paths that feed QuickBooks, SAP, Oracle NetSuite, Microsoft Dynamics 365, Sage Intacct and Workday Financials. The Federal Reserve payment systems context makes field-level accuracy non-negotiable for commercial reporting.
Build a Custom Report Export Formats
The 60+ filterable fields in SinglePoint Transaction Reporting group into seven families. Every field can be combined as a filter, sort key, group key or column.
Transaction type, sub-type, BAI Type Code, SWIFT message type (MT103, MT202, MT202COV, MT900, MT910), channel (web, mobile, API, file), originator ID and reference number. This family anchors every SinglePoint Transaction Reporting query.
Amount in transaction currency, amount in USD equivalent, currency code, FX rate applied, spread versus mid-market, fee amount, fee type and net settlement. SinglePoint Transaction Reporting stores both gross and net for multi-currency reconciliation.
Beneficiary name, beneficiary bank SWIFT BIC, beneficiary account, intermediary bank, originator name, originator bank, ordering institution and purpose code. Counterparty fields in SinglePoint Transaction Reporting power AP, AR and OFAC reconciliation.
Initiation timestamp (UTC), posting date, value date, settlement date, effective date (for ACH), and cut-off window. SinglePoint Transaction Reporting exposes every date stamp for accurate intraday and prior-day positioning.
Initiator user ID, approver user IDs (up to three levels of dual-control), release timestamp, status (pending, approved, released, rejected, returned), rejection reason and audit note. SinglePoint Transaction Reporting ties every transaction to the chain of human decisions.
GL code, cost centre, project code, entity, department, custom tags and invoice reference. SinglePoint Transaction Reporting carries GL mapping into the BAI2 and CSV export for direct ERP posting.
Six pre-built SinglePoint Transaction Reporting views cover the most common commercial workflows. Every pre-built view is fully editable and save-able.
| Report | Fields | Format Options | Schedule |
|---|---|---|---|
| Daily activity | 24 default fields, 60+ available | BAI2, CSV, PDF | Daily 6:00am CT |
| Wire register | 32 fields incl. BIC and MT type | CSV, PDF, MT940 | Daily or real-time |
| ACH origination log | 28 fields incl. SEC code | NACHA, CSV, PDF | Daily post-release |
| FX trade blotter | 22 fields incl. rate and spread | CSV, PDF | Daily 5:00pm CT |
| Positive pay exceptions | 18 fields | CSV, PDF | Intraday every 60 min |
| User audit trail | 15 fields | CSV, PDF | Weekly Monday 7am CT |
SinglePoint Transaction Reporting lets you persist any filter combination, schedule automated delivery and distribute results to multiple recipients with role-based controls.
A SinglePoint Transaction Reporting saved view captures filter set, column layout, sort order and grouping. Saved views are either private (visible only to the creator) or shared (visible to the entire Company ID). Company Administrators can lock saved views so no downstream user can alter the definition, a control that aligns with SOX segregation-of-duties.
SinglePoint Transaction Reporting supports daily, intraday, weekly and monthly schedules. Delivery channels include in-portal download, email (PDF only), secure SFTP (all formats with optional PGP) and direct ERP connector (BAI2 to Kyriba, ION and SAP TRM). The audit trail records every scheduled run and every recipient delivery.
A compressed reference for the SinglePoint Transaction Reporting dimensions treasury and finance teams use most often.
Real-time balance dashboard with intraday positioning.
Drag-and-drop builder with calculated fields.
BAI2, MT940, CSV and PDF with SFTP delivery.
Role-based permissions and dual-control.
Reports on iOS and Android with biometric sign-in.
ZBA, sweeps, positive pay and lockbox.
Commercial Banking Portal — Topic Cluster