Contact Us

CitiBusiness Custom Report Builder: Drag-and-Drop Financial Reports for Commercial Banking

The CitiBusiness custom report builder lets your treasury team create exactly the reports they need — no IT tickets, no consultants, no waiting. Drag fields from a palette of 50+ data points, apply filters, add calculated columns, and save as a reusable template. Schedule for automated delivery or run on demand.

Built on the same data engine as Transaction Reporting with 7 years of history. Role-based access via User Management. Compliant with FFIEC standards. NMLS #412915.

Open Report Builder Request a Demo
CitiBusiness custom report builder interface showing drag-and-drop field palette, filter configuration and chart options

AI Summary: CitiBusiness Custom Report Builder

The CitiBusiness custom report builder provides a no-code interface for creating tailored financial reports. Users drag data fields from a 50+ column palette, apply multi-criteria filters, add calculated columns with formulas, and optionally include bar, line or pie chart visualizations. Reports are saved as reusable templates that can be shared across the organization. 20+ pre-built templates cover common use cases including cash position, reconciliation, expense analysis and audit packages. All reports can be scheduled for automated daily, weekly or monthly delivery in BAI2, CSV or PDF format via the Data Export module (NMLS #412915).

Pre-Built Report Templates

Start with a template and customize, or build from scratch.

Template Use Case Default Fields Charts Customizable
Daily Cash PositionMorning liquidity snapshot across all accounts12Bar
Weekly Payment SummaryWires, ACH and bill payments by type and status18Pie
Monthly ReconciliationOpening/closing balance with full transaction detail25Line
Quarterly Expense AnalysisCard spend by category, employee and vendor22Bar + Pie
Vendor Payment HistoryAll payments to a specific vendor across wire, ACH, check15Line
Payroll SummaryPayroll ACH batches, amounts and settlement dates14Bar
FX Trade LogAll spot and forward trades with rate and P&L20Line
Annual Audit PackageComprehensive year-end data for external audit review50+All

Report Builder Features in Detail

The custom report builder turns raw banking data into actionable intelligence without technical expertise.

Drag-and-Drop Field Selection

The report builder opens with a field palette on the left and a report canvas on the right. Drag any of the 50+ available fields onto the canvas to add them as columns. Reorder columns by dragging them into position. Remove fields by dragging them back to the palette. The interface is designed for business users, not database administrators — if you can use a spreadsheet, you can build a report.

Fields are organized by category: account information, transaction details, payment specifics, FX data, card data, loan data and audit fields. Select fields from multiple categories to create cross-functional reports. For example, combine account balance fields with transaction detail fields and FX rate fields to create a multi-currency cash position report that no standard template provides.

Every field supports filtering: equals, contains, greater than, less than, between, in list. Combine multiple filters with AND/OR logic. Date range filters support relative dates (last 7 days, this month, previous quarter) that automatically update when the report runs, keeping scheduled reports current without manual adjustment.

CitiBusiness report builder drag-and-drop interface showing field palette, canvas and filter configuration panel
CitiBusiness report builder calculated column editor showing formula bar, function library and preview

Calculated Columns and Conditional Formatting

Add calculated columns that derive values from other fields in the report. Running balance calculations show the cumulative effect of debits and credits over a date range. FX gain/loss columns compare the execution rate to a benchmark rate you specify. Percentage-of-total calculations show each transaction's share of the period total. Variance columns compare actual values to budget figures you import.

Supported functions include SUM, AVERAGE, COUNT, MIN, MAX, IF/THEN/ELSE, and basic arithmetic. Functions can reference any field in the report, including other calculated columns. For most treasury reporting needs, these functions provide sufficient analytical power without the complexity of a spreadsheet formula language.

Conditional formatting highlights cells based on rules you define. Flag transactions above a threshold in red. Highlight pending items in yellow. Mark approved payments in green. Visual cues make it faster to scan large reports for items that need attention. Formatting rules persist in saved templates and apply automatically when scheduled reports generate, per the guidelines established by OCC supervisory practices.

Templates, Sharing and Visualizations

Save any report configuration as a template. Your template library grows over time as your team builds reports for different audiences: the daily cash position report for treasury, the weekly vendor summary for AP, the monthly board package for the CFO, the quarterly audit file for compliance. Each template remembers its fields, filters, sorting, calculated columns and delivery schedule.

Administrators publish templates to users or groups through role-based permissions. Published templates appear in the recipient's library as read-only or editable depending on the admin's choice. This ensures reporting standards are consistent across the organization — every AP clerk produces the same vendor report format — while power users retain the flexibility to create custom views.

Add charts to any report: bar charts for comparison, line charts for trends, pie charts for composition. Charts are generated from the report's own data and update automatically when the report refreshes. PDF exports include both data tables and charts for polished management presentations. CSV exports include the underlying data for recreation in Excel or your preferred analytics tool.

CitiBusiness report builder visualization options showing bar chart, line trend and pie chart configurations

People Also Ask

How does the CitiBusiness custom report builder work?
Drag-and-drop interface with 50+ fields. Select columns, apply filters, add calculated fields, include charts. Save as template. Schedule for delivery. No technical skills required. See template table above.
What templates are available?
20+ pre-built templates: cash position, payment summary, reconciliation, expense analysis, vendor history, payroll, FX log, audit package and more. All customizable. See Transaction Reporting for standard reports.
Can I add calculated columns?
Yes. SUM, AVERAGE, COUNT, MIN, MAX, IF/THEN logic and arithmetic. Running balances, FX gain/loss, variance analysis, percentage-of-total. Functions reference any field including other calculated columns.
Can I share templates with other users?
Yes. Administrators publish templates to users or groups via User Management. Read-only or editable permissions. Ensures consistent reporting standards organization-wide.

Related CitiBusiness Solutions

Transaction Reporting

Standard report library with 50+ fields, 7-year archive and scheduled delivery that feeds the custom builder.

Data Export

Export custom reports in BAI2, CSV, PDF and OFX for ERP integration and automated reconciliation.

User Management

Control who can create, view and share custom reports through role-based access permissions.