SinglePoint Custom Reports is the drag-and-drop report builder every commercial treasury team has been asking for. Drop any field onto the canvas, compose calculated fields, apply conditional formatting, group by any dimension, publish to a named schedule. Output formats pre-mapped for SAP, Oracle NetSuite, Microsoft Dynamics 365, Sage Intacct, QuickBooks Online and Workday Financials.
GL mapping lives inside Custom Reports — assign general ledger codes, cost centres and project codes to transactions based on originator, BAI type code, amount range or description text-match. The output flows directly into ERP GL import with zero manual re-keying.
Sign In to SinglePoint Standard Reports
Drag fields, compose formulas, apply conditional formatting, group and sub-total, preview with real data. No SQL, no scripting, no ticket to IT.
The calculated-field engine inside Custom Reports is intentionally compact — familiar enough that an Excel user sees it and starts building, powerful enough to replace bespoke spreadsheet macros.
Add, subtract, multiply, divide. Round, ceiling, floor, absolute value. Running balance, cumulative sum, moving average over N rows. Currency-aware math respects the transaction currency without manual conversion.
IF, AND, OR, NOT with nested branches. CASE statements for classification logic. Comparison operators on any typed field. Regex match on text fields for robust pattern-based rules.
Days between, weeks between, months between, business-day counts honouring the U.S. Federal Reserve holiday calendar. Value date vs posting date deltas. Aging buckets (0-30, 31-60, 61-90, 90+). Week-of-year, month-of-year, quarter classifications.
Concatenation, substring, upper/lower case, trim, length. Regex extract for pulling invoice numbers out of wire narratives. Soundex and fuzzy match for beneficiary normalisation across slight spelling differences.
Five canonical use cases that Custom Reports handles out of the box — these are the reports that 80% of commercial treasury teams rebuild manually in Excel every month.
| Use Case | Fields | Output | Refresh Cadence |
|---|---|---|---|
| GL Import — SAP IDoc | 24 | SAP FI IDoc | Daily 06:30 CT |
| NetSuite Bank Feed | 18 | CSV with GL codes | Hourly |
| Intraday Cash Position | 12 | XLSX dashboard | Every 15 min |
| Monthly Close — Dynamics 365 | 30 | Dynamics GL batch | Monthly |
| FX Exposure Summary | 20 | PDF executive pack | Weekly |
Custom Reports emits SAP FI IDocs with GL line items pre-allocated by mapping rules. NetSuite receives CSV bank feeds with GL account codes already resolved. Microsoft Dynamics 365 ingests GL batch files with cost centre and project allocations applied. All three connectors support dry-run preview so treasury can verify mapping before activating automated delivery.
Sage Intacct receives CSV uploads with entity, location and department dimensions. QuickBooks Online pulls via API with account mapping cached per customer. Workday Financials consumes the native Workday inbound integration feed. Every connector is bidirectional where the ERP supports write-back for reconciliation status.
Federal Reserve payment systems data feeds the business-day calendar used in Custom Reports date math.
Custom Reports works alongside these SinglePoint reporting capabilities.
Commercial Banking Portal — Topic Cluster