Reporting & Reconciliation Guide

OldNational provides a robust set of reporting and reconciliation tools that enable businesses to make informed cash management decisions. This guide covers all reporting features, data export formats, and reconciliation options available on the platform.

Table of Contents

1. Balance Reporting
2. Transaction Search
3. eStatements
4. Custom Report Templates
5. Data Export Formats
6. Scheduled Report Delivery
7. NACHA Detail File Report
8. Account Reconciliation
9. EDI Detail Reports

Balance Reporting

Balance Reporting provides a snapshot of your account positions:

• Current balance: Real-time balance as of the current moment.
• Available balance: Funds available for withdrawal or transfer.
• Previous day balance: Closing balance from the previous business day.
• Multi-account view: View balances across all enrolled accounts in a single report.
• Historical balances: Access 13 months of balance history.

Creating a Balance Report

1. Navigate to Reporting or Balance Reporting.
2. Select the account(s) to include.
3. Choose the date range.
4. Select the report format (on-screen, PDF, CSV, etc.).
5. Generate and view or download the report.

Transaction Search

Search for specific transactions across your accounts using multiple filters:

• Date range: Search within a specific period (up to 13 months of history).
• Amount: Search by exact amount or range.
• Check number: Find specific check transactions.
• Description: Search by transaction description text.
• Transaction type: Filter by credits, debits, ACH, wire, check, etc.

Search results can be viewed on-screen, downloaded, or saved as a report template for future use.

eStatements

Electronic statements replace paper statements with digital versions:

• Access up to 24 months of eStatements and Analysis eStatements.
• View statements online or download as PDF.
• Receive email notifications when new statements are available.
• Environmentally friendly — reduce paper waste.
• More secure than paper statements sent through the mail.

Custom Report Templates

OldNational allows you to create custom report templates tailored to your specific needs:

1. Navigate to Reporting section.
2. Select Create Report Template or equivalent option.
3. Choose the data fields to include (date, amount, description, account, etc.).
4. Set filters (account, date range, transaction type).
5. Choose the output format (PDF, CSV, BAI2, etc.).
6. Save the template with a descriptive name.
7. Optionally, schedule the report for automatic delivery.

Data Export Formats

OldNational supports multiple export formats for integration with accounting systems:

Format	Description	Common Use
PDF	Portable Document Format	Human-readable reports, archival
CSV	Comma-Separated Values	Excel/spreadsheet analysis
BAI2	Bank Administration Institute format	Corporate cash management systems
MT940	SWIFT message format	International bank reconciliation
CAMT052	ISO 20022 standard	Modern ERP systems, global reconciliation
QFX	Quicken Financial Exchange	Quicken software import
QBO	QuickBooks Online format	QuickBooks Online import

Scheduled Report Delivery

Automate report delivery to save time:

• Email delivery: Reports sent to specified email addresses on a schedule.
• FTP/SFTP delivery: Files delivered to your FTP server for automated processing.
• Scheduling options: Daily, weekly, monthly, or custom schedules.
• Multiple recipients: Send to multiple email addresses or FTP locations.
• Format selection: Each scheduled report can use a specific export format.

NACHA Detail File Report

The NACHA Detail File Report displays incoming ACH payment information:

• View all incoming ACH credits and debits.
• See originating company names and IDs.
• Access addenda records with remittance information.
• Download in NACHA format for posting to your accounting system.
• Useful for accounts receivable matching and cash application.

Account Reconciliation

Account reconciliation services automate the matching of paid checks to issued items:

Partial Reconciliation

• Provides an electronic file of all checks paid during a period.
• Your accounting system matches paid checks against your issued file.
• Simplest and most cost-effective option.

Full Reconciliation

• Bank performs the matching of issued checks to paid checks.
• Provides supplemental reports including outstanding checks, voids, and exceptions.
• Most thorough option for businesses with high check volumes.

Deposit Reconciliation

• Allows a single deposit account to serve multiple locations.
• Each deposit is coded with a location identifier.
• Reports break down deposits by location for easy allocation.

EDI Detail Reports

Electronic Data Interchange (EDI) remittance information is available for ACH payments that include addenda records:

• View invoice numbers, payment amounts, and discount terms.
• Access up to 9,999 addenda records per CTX payment.
• Export EDI data for automated accounts receivable posting.
• Supports ANSI X12 820 remittance format.

Related Guides