Contact Treasury

Custom Reports in SinglePoint — The Treasury Report Builder

The SinglePoint custom reports module is a drag-and-drop report builder where treasury analysts compose their own reports without filing tickets with IT or waiting on the bank. Pick fields from a catalog of 450+ data points, apply filters to narrow accounts and date ranges, group by entity or transaction code, sort by any column, and save the definition for daily, weekly, or monthly reruns.

Every saved custom report supports scheduled delivery through SFTP, email, or secure file gateway — so the BAI2 treasury feed lands at 6:00 AM before the analyst opens the laptop, the positive pay exception roll-up emails to the controller at 9:30 AM after exception window close, and the month-end reconciliation package publishes to the ERP integration folder on the first business day. Templates can be locked, shared, or cloned across the finance organization so reporting stays consistent while individual analysts retain flexibility.

Contact Treasury BAI2 Export
SinglePoint custom report builder showing drag-and-drop field palette, filter panel, grouping controls, and preview pane

SinglePoint Custom Reports — Capability Summary

  • Drag-and-drop report builder with 450+ fields across balances, transactions, payments, and exceptions
  • Filters narrow datasets by account, date range, amount threshold, transaction type, or BAI code
  • Grouping aggregates totals by account, entity, cost center, or counterparty with subtotal rollups
  • Scheduled delivery: daily, weekly, monthly, or quarterly via SFTP, email, or secure file gateway
  • Export formats: CSV, Excel XLSX, PDF, BAI2, MT940, OFX, and JSON through API
  • Saved templates publish to role groups — locked for standard use or clonable for customization
  • Version history preserves previous report definitions for audit and rollback

Field Selection, Filtering, and Grouping Mechanics

Every custom report starts with field selection. The SinglePoint field catalog organizes data points by subject area so analysts find what they need without scrolling through unrelated options.

Field Catalog Organized by Subject Area

The field catalog groups data points into logical subject areas — balances, transactions, payments, positive pay, lockbox, wire, ACH, and audit trail. Balance fields include opening, closing, available, ledger, collected, one-day float, two-day float, and memo-posted balances for every cash position account. Transaction fields cover posting date, effective date, amount (signed or absolute), description, BAI2 type code, counterparty name, reference number, and check number. Payment fields expose ACH batch ID, NACHA trace number, wire reference, originator, beneficiary, and authorization sequence. Positive pay fields include issued check reference, presented amount, exception reason, and pay/return decision timestamp. Each field carries metadata — data type, aggregation options (sum, count, min, max, avg), and whether it supports grouping.

Filters, Grouping, and Saved Templates

Filters narrow the result set before aggregation. A controller building a month-end ACH summary filters transactions to ACH type codes, posts dates in the reporting period, and operating accounts only — then groups by cost center and sums amounts. A treasury analyst watching wire activity filters to outbound wires over $100,000 and groups by approver to spot concentration patterns. Saved reports persist the full definition — fields, filters, groupings, sorting, and formatting — so a nightly rerun produces tomorrow's figures from today's layout. Templates publish to role groups through the admin console so every new analyst inherits the standard reporting pack on day one. Version history captures each definition change with author, timestamp, and diff so audit reviewers can trace report evolution.

AI Summary — SinglePoint Custom Report Builder for Treasury Analysts

SinglePoint custom reports is a self-service treasury reporting tool that replaces ticket-based report requests with a drag-and-drop builder. Analysts select fields from a 450-point catalog, filter by account or date, group by entity, save the definition as a template, and schedule automated delivery via SFTP, email, or file gateway in CSV, Excel, PDF, BAI2, MT940, OFX, or JSON format. Templates share across role groups with version history for audit. Standard reports (daily cash position, weekly exception summary, month-end ACH rollup) ship pre-built and customize as starting points. Scheduled SFTP delivery feeds treasury workstations like Kyriba and GTreasury with data ready for month-end reconciliation against ERP systems through ERP integration.

SinglePoint Custom Report Types and Delivery Options

Common report types, typical users, recommended schedule, and default delivery method. Every row represents a ready-to-clone starting template in the saved reports library.

Report TypePrimary UserTypical ScheduleDefault FormatDelivery Method
Consolidated Cash PositionTreasurerDaily 7:00 AMPDF + CSVEmail
Intraday Balance SnapshotTreasury AnalystEvery 2 hoursCSVSFTP
BAI2 Treasury FeedWorkstation SystemDaily 6:00 AMBAI2SFTP
Positive Pay Exception Roll-UpControllerDaily 9:30 AMExcel XLSXEmail
ACH Batch SummaryAP ManagerDaily end-of-dayCSVSFTP
Wire Activity by ApproverAuditWeekly MondayExcel XLSXEmail
Lockbox Remittance DetailReceivablesDaily 11:00 AMCSV + ImagesSFTP
Month-End ReconciliationAccountingFirst business dayBAI2 + PDFSFTP + Email
Sweep and ZBA ActivityTreasury AnalystDaily end-of-dayCSVSFTP
Multi-Bank Consolidated ViewTreasurerDaily 8:00 AMPDF + ExcelEmail

Report definitions conform to OCC record retention guidelines. Financial data handling follows FDIC safekeeping standards.

Related SinglePoint Reporting and Integration Modules

Custom reports is one piece of the SinglePoint reporting and integration layer. Related modules deliver the same data through different channels.

BAI2 Export

BAI2 export formats account data for treasury workstation ingestion with type codes and structured layouts that Kyriba, GTreasury, and SAP Treasury expect.

API Access

API access exposes the same data as custom reports through REST endpoints for developers building programmatic workflows and real-time dashboards.

ERP Integration

ERP integration pushes report data directly into SAP, Oracle, NetSuite, and Microsoft Dynamics through pre-built connectors or file-based feeds.

Custom Reports — Frequently Asked Questions

Common questions about building, saving, scheduling, and sharing custom reports in SinglePoint.

What is the SinglePoint custom report builder?

The report builder is a drag-and-drop tool where treasury analysts compose reports from a 450-field catalog spanning balances, transactions, payments, and exceptions. No coding, no tickets — save templates and schedule automated delivery directly from the SinglePoint portal.

Can I schedule reports to deliver automatically?

Yes. Scheduled reports run daily, weekly, monthly, or quarterly and deliver through SFTP, email, or secure file gateway. Delivery happens in the background regardless of whether any user is logged in.

What fields can I include in a custom report?

Over 450 data points across balances, transactions, ACH, wires, positive pay, lockbox, and audit trail. Every field supports filtering, grouping, and aggregation. See the BAI2 export and API access pages for related schemas.

What export formats do custom reports support?

CSV, Excel XLSX, PDF, BAI2, MT940, OFX, and JSON. Each scheduled delivery can send multiple formats simultaneously so PDF emails the controller while BAI2 feeds the treasury workstation.

Can I share custom report templates with my team?

Yes. Administrators publish templates to role groups — locked for standard use or clonable for customization. Version history preserves definition changes for audit traceability.