Reporting & Reconciliation Guide
JPMorgan Access provides robust reporting and reconciliation tools that help treasury professionals monitor account activity, match transactions, and generate insights for decision-making. From real-time balance reporting to detailed transaction-level reconciliation, the platform offers a comprehensive suite of reporting capabilities. This guide covers the key reporting and reconciliation features available within JPMorgan Access.
Account Reporting
Account reporting in JPMorgan Access provides a consolidated view of account balances and activity across all linked accounts. Reports can be customized to show specific accounts, date ranges, and activity types.
Key account reporting features include:
- Balance reporting — Current, available, and ledger balances per account
- Activity summary — Summary of debits, credits, and net activity for a selected period
- Multi-account view — Consolidated view across all J.P. Morgan and multi-bank accounts
- Historical balance data — Access to prior-day and historical balance information
- Intraday activity — Real-time transaction postings throughout the business day
Transaction Reporting
Transaction reporting provides detailed information about individual transactions posted to accounts. Users can search, filter, and sort transactions to analyze payment activity.
| Filter | Description |
|---|---|
| Date range | Filter transactions by posting or effective date |
| Transaction type | ACH, wire, check, deposit, fee, etc. |
| Amount range | Minimum and maximum transaction amount |
| Account | Specific account or account group |
| Status | Posted, pending, returned, etc. |
| Reference number | Search by transaction reference or trace number |
Reconciliation Tools
JPMorgan Access provides reconciliation tools that help organizations match bank transactions with their internal accounting records. Effective reconciliation ensures that all transactions are accounted for and discrepancies are identified promptly.
Automated Matching
The platform supports automated matching of bank transactions to internal records using rules-based logic:
- Amount matching — Match by exact or tolerance-based amounts
- Reference matching — Match by reference number, invoice number, or check number
- Date matching — Match by transaction date within a configurable window
- Combined criteria — Use multiple fields for higher-confidence matches
Manual Reconciliation
For transactions that cannot be matched automatically, JPMorgan Access provides a manual reconciliation interface where users can:
- Review unmatched transactions side-by-side with internal records
- Manually link transactions to specific accounting entries
- Add notes and explanations for unmatched items
- Flag items for further investigation
Custom Reports
JPMorgan Access allows users to create custom reports tailored to their specific needs. Custom reports can be saved, scheduled, and shared with other authorized users.
Report Builder Features
- Select data fields from a comprehensive list of available columns
- Apply filters to focus on specific transactions, accounts, or date ranges
- Sort and group data by multiple dimensions
- Add calculated fields for custom metrics
- Schedule reports for automatic generation and distribution
Scheduled Reports
Reports can be scheduled to run automatically on a recurring basis:
- Daily — Generate each business day at a specified time
- Weekly — Generate on a selected day of the week
- Monthly — Generate on a selected day of the month
- On-demand — Generate immediately when needed
Scheduled reports can be delivered via email, downloaded from the platform, or exported for integration with internal systems.
Data Export Options
JPMorgan Access supports multiple export formats to facilitate integration with accounting systems, ERPs, and other financial management tools:
| Format | Best For |
|---|---|
| CSV | Excel analysis, general-purpose import |
| XLSX | Formatted spreadsheets with formulas |
| XML | System integration, BAI2/ISO 20022 formats |
| Archival, reporting to stakeholders | |
| BAI2 | Standard bank reconciliation format |
| MT940 | SWIFT message format for international accounts |
BAI2 Reporting
BAI2 is a standard file format used for electronic bank reporting. JPMorgan Access can generate BAI2 files that contain detailed account balance and transaction information. These files are commonly imported into treasury management systems (TMS) and ERP systems for automated reconciliation.
BAI2 files include:
- Account identification and currency
- Opening, closing, and available balances
- Transaction detail with type codes
- Reference numbers and addenda information
Reporting Dashboard
The reporting dashboard in JPMorgan Access provides a visual overview of key metrics and trends. Users can customize their dashboard to display the information most relevant to their role:
- Daily cash position charts
- Payment activity by type
- Account balance trends over time
- Reconciliation status summary
- Exception and alert notifications
Best Practices for Reconciliation
- Reconcile daily — Match transactions every business day to identify issues early
- Use automated matching — Configure matching rules to handle the majority of transactions automatically
- Investigate exceptions promptly — Review unmatched items the same day they appear
- Maintain documentation — Add notes to reconciled items for audit trail
- Segregate duties — Different users should initiate payments and perform reconciliation