Reports & Reconciliation#
Overview#
The Reports & Reconciliation module gives you complete visibility into your financial operations across the Cobre Portal. Generate detailed reports on demand, choose your preferred format and timezone, and download data whenever you need it—whether for daily reconciliation, monthly close, or audit requirements.This flexibility means your finance team can work with data in the format they need, when they need it, without waiting for batch processes or manual exports.
Accessing Reports#
All reports generated within your workspace are available in the Reports section of the side menu. This centralized hub lets you view, filter, and download any report you've created, making it easy to track your financial data over time.
Understanding Your Reports Dashboard#
The Reports section displays all generated reports in a comprehensive table format:| Column | Description |
|---|
| Period | The date and time range covered by the report |
| Report type | The category of data included (Movements, Transactions, Account statements, or Multicash) |
| Creation date | When the report was generated |
| ID | A unique identifier for each report |
| Status | Current state of the report |
Available: Ready to download
Processing: Being generated
Quick Filtering#
Use the filter options at the top to quickly find what you need:Period filter: Find reports by their coverage period
Creation date filter: Search by when the report was generated
Report type tabs: Switch between All, Movements, Transactions, Account statements, and Multicash views
Generating a New Report#
Click the "+ Generate report" button to create a customized report. The system guides you through a simple process to define exactly what data you need.Available Report Types#
Cobre Portal supports several report types, each designed for specific reconciliation and operational needs:Movements (Money Movement)#
Purpose: Track payment transactions across all your operations
Geographies: All (Mexico, Colombia, Peru)
Use cases: Daily reconciliation, payment tracking, cash flow analysis
Detailed report (money_movement_v1): Complete transaction data for current platform version
General report (money_movement_legacy_csv_v1): Summary format compatible with previous platform version
SPEI-specific (money_movement_mex_spei_csv_v1): Mexico SPEI rail transactions only
Transactions (Account Transactions)#
Purpose: View all activity within your Cobre Balance accounts
Geographies: All (Mexico, Colombia, Peru)
Use cases: Account reconciliation, balance verification, transaction history
Special feature: Timezone offset available to display timestamps in your local time
Account Statements#
Purpose: Monthly PDF statements for Cobre Balance accounts
Geographies: Colombia and Mexico only
Use cases: Formal documentation, audit requirements, monthly accounting close
Format: PDF (formatted document with client info, account details, and transaction summary)
Generation: One month per statement, language based on geography (Spanish for COL/MEX)
Idempotency: Requesting the same statement period returns the previously generated report
Counterparties#
Purpose: Export your counterparty database for analysis or integration
Use cases: Managing beneficiary lists, compliance reviews, integration with accounting systems
Step 1: Choose Report Type#
Select the type of data you want to report on:Movements: Details of money movements and payment transactions
Transactions: Account transaction history
Account statements: Comprehensive monthly account activity in PDF format
Multicash: Multi-account cash position reporting (for subscribed Colombia accounts)
Step 2: Select Report Structure (for Movements)#
When generating a Movements report, choose your level of detail:In-depth report of movements, available for this version
Use this when you need complete transaction-level detail for reconciliation or audit purposes
Basic summary of movements, used in the previous version of the platform
Use this for high-level overviews or when you need compatibility with legacy systems
Step 3: Filter Movement Type (for Movements)#
Narrow down which movements to include:All: Complete view of all movement activity
Through SPEI: Only movements processed through Mexico's SPEI rail
CSV: Perfect for Excel or Google Sheets analysis, data manipulation, and sharing with team members who prefer spreadsheets
JSON: Ideal for system integrations, automated processing, or feeding data into business intelligence tools
Step 5: Select Time Zone#
Choose the timezone that aligns with your team's location or reporting requirements.Available for: Transactions reports only (transactions_csv_v1 layout)
How it works: The timezone setting transforms the UTC timestamps in your report to display in your local time without altering the original data. This means you see when transactions occurred in your operational timezone while maintaining data integrity.
Americas: Bogotá, Ciudad de México, Lima, Santiago, Buenos Aires, São Paulo, New York, Los Angeles, Toronto, and more
Europe: London, Madrid, Berlin, Paris, Rome, Stockholm, and more
Asia: Tokyo, Seoul, Singapore, Dubai, Hong Kong, Bangkok, and more
Africa: Johannesburg, Cairo, Nairobi, Lagos, and more
Oceania: Sydney, Melbourne, Auckland, and more
| Location | Timezone |
|---|
| Bogotá, Colombia | UTC-05:00 |
| Ciudad de México, México | UTC-06:00 |
| Lima, Perú | UTC-05:00 |
Getting the timezone right ensures your report timestamps match your business hours and reconciliation processes. This is especially valuable for teams operating across multiple countries or coordinating with partners in different time zones.Step 6: Define Report Period#
Choose when you want to report on:| Period | Description |
|---|
| Today | Current day's activity (shows actual date, e.g., Dec 15) |
| Yesterday | Previous day's complete activity (e.g., Dec 14) |
| Last 7 days | Rolling week view (e.g., Dec 08 - Dec 15) |
| Current month | Month-to-date activity (e.g., Dec 01 - Dec 15) |
| Last month | Previous month's complete activity (e.g., Nov 01 - Nov 30) |
Define your own specific date range
Add precise hour ranges if you need to isolate activity within specific time windows
Step 7: Generate#
Once you've configured all parameters, click Generate. The report appears in your Reports section with a "Processing" status and becomes available for download once complete.
Downloading Reports#
After a report is generated and marked as Completed, users can download it in their chosen format.Steps to Download a Report#
1.
Navigate to the Reports section
2.
Locate your report in the table
3.
Click the download icon (↓) next to the report
Download Link for Multiple Reports#
If you need to download several reports at once, you can generate a secure download link that packages multiple reports into a single ZIP file:1.
Select the reports you want to download
2.
The system generates a secure download URL
3.
The link remains valid for 30 minutes
4.
Download the ZIP file containing all selected reports
Generating and Using Account Statements (PDF Reports)#
Account statements are formal PDF documents that provide a comprehensive monthly view of your Cobre Balance account activity. Unlike on-demand CSV or JSON reports, these statements follow a standardized format designed for formal documentation and compliance needs.What's Included in an Account Statement#
Each Cobre Balance Statement is divided into three sections:Complete details about the account owner
Account identification details
Account type and currency
Opening and closing balances for the month
Complete list of all transactions during the month
Each transaction shows whether it was a debit or credit
Running balance after each transaction
Transaction dates, descriptions, and amounts
Generating Account Statements#
| Parameter | Details |
|---|
| Eligibility | Only Cobre Balance accounts in Colombia (COL) and Mexico (MEX) |
| Time period | One calendar month per statement (e.g., "2025-05" covers May 1-31) |
| Timezone handling | Colombia accounts: UTC-05:00 / Mexico accounts: UTC-06:00 |
| Language | Spanish for both Colombia and Mexico statements |
| Format | PDF document with professional formatting |
How to Generate a Statement#
1.
Navigate to the Reports section
2.
Click "+ Generate report"
3.
Select Account statements as the report type
4.
Choose your Cobre Balance account
5.
Specify the statement month (YYYY-MM format, e.g., "2025-05")
Statement Idempotency#
If you request a statement for a period that's already been generated, the system returns the existing statement rather than creating a duplicate. This ensures:Consistent statement numbering for audit trails
Faster access to previously generated documents
No storage waste from duplicate files
When to Use Account Statements#
| Use Case | Description |
|---|
| Monthly Close | Generate statements for all accounts as part of your month-end close process for formal documentation. |
| Audit Requirements | Provide auditors with professionally formatted statements that show complete monthly activity with running balances. |
| Legal Documentation | Use statements when you need formal documentation for legal or compliance purposes. |
| Reconciliation with Local Banks | Match your Cobre account activity against traditional bank statements using familiar PDF format. |
| Historical Records | Archive monthly statements as permanent records of account activity for regulatory or internal purposes. |
MultiCash Reports for Colombia#
MultiCash is a standardized reporting format used by Colombian financial institutions for daily balance and transaction reporting. If you operate Cobre Balance Colombia accounts, you can subscribe to automatic MultiCash report generation, ensuring compatibility with local banking standards and streamlining your reconciliation with Colombian counterparties.What Makes MultiCash Different#
Unlike on-demand reports that you generate when needed, MultiCash reports are:Automatically generated daily for subscribed accounts
Formatted to Colombian banking standards for seamless integration with local systems
Split into two file types: Header files (daily balances) and Detail files (daily transactions)
Sequentially numbered with a consecutive identifier (1–9999) for audit trail continuity
Subscribing to MultiCash Reports#
To enable automatic MultiCash report generation for your Cobre Balance Colombia accounts:1.
Navigate to the Reports section
2.
Click on the MultiCash tab
3.
Click Subscribe for the accounts you want to include in daily reporting
Only Cobre Balance Colombia accounts are eligible for MultiCash reports
Once subscribed, reports generate automatically every day between 1:00 AM and 3:00 AM Colombia time
Subscriptions cannot be manually cancelled through the portal—contact Cobre Support if you need to modify your subscriptions
Understanding MultiCash Report Structure#
Each day, the system generates two reports per subscribed account:| Report Type | Description |
|---|
| Header Report (MultiCash - Header) | Contains daily balance summary information. Shows your end-of-day position for the account. Follows Colombian banking header format standards. |
| Detail Report (MultiCash - Detail) | Contains individual transaction details for the day. Includes all debits and credits that affected the account. Follows Colombian banking detail format standards. |
Both reports use the same consecutive numbering sequence, making it easy to match header and detail files for the same reporting period.Viewing MultiCash Reports#
Access your MultiCash reports through the dedicated MultiCash tab in the Reports section:| Column | Description |
|---|
| Period | The reporting day in format "DD MMM YYYY, 05:00 → DD MMM YYYY, 05:00 (UTC-05)". All periods reflect Colombia timezone (UTC-05:00). |
| Report type | Identifies whether the file is "MultiCash - Header" (balance summary) or "MultiCash - Detail" (transaction details) |
| Account | Shows your account alias and truncated account ID for easy identification |
| Creation date | When the report was generated (displayed in Colombia local time) |
| Status | Current state: Available (ready to download) or Processing (being generated) |
| Consecutive | Sequential number (1–9999) providing audit trail continuity. Numbers increment across all MultiCash reports for your workspace. Helps ensure no reports are missing when reconciling. |
Downloading MultiCash Reports#
Once a report shows "Available" status:1.
Locate the report in the MultiCash tab
2.
Click the download icon (↓)
3.
The file downloads in the standardized MultiCash format
Why MultiCash Matters for Colombia Operations#
Local Banking Compatibility: MultiCash is the standard format used by Colombian financial institutions. Using it means your reports integrate directly with local banking systems without format conversion or manual reformatting.Automated Daily Reconciliation: With reports generating automatically overnight, your finance team can start each day with fresh data already available in the exact format they need for reconciliation workflows.Audit Trail Integrity: The consecutive numbering system provides clear evidence that no reports are missing from your sequence—critical for compliance and audit requirements in Colombia.Separation of Balance and Detail: Having separate header and detail files lets different team members work with the data they need: treasury teams can monitor balances in header files while accounting teams can reconcile individual transactions from detail files.Timezone Consistency: All MultiCash reports reflect Colombia time (UTC-05:00), eliminating confusion when coordinating with Colombian banks, suppliers, or internal teams in Colombia.
Why This Matters#
Complete Audit Trail#
Every report is tracked with a unique ID, creation date, and defined period, giving you a permanent record of what data was accessed and when. For MultiCash reports, consecutive numbering adds an additional layer of audit integrity by making gaps immediately visible. Account statements use idempotency to ensure you can reference the same document consistently across audit processes.Timezone Accuracy#
Reporting in your local timezone eliminates confusion about when transactions occurred, especially critical for teams operating across Latin America's multiple time zones. MultiCash reports automatically use Colombia time (UTC-05:00) for consistency with local banking standards. Transactions reports support over 40 timezones worldwide, ensuring your data displays in the most relevant context for your operations.Choose the format that matches your workflow:CSV: Perfect for Excel analysis, pivot tables, and sharing with finance teams who prefer spreadsheets
JSON: Ideal for system integrations, automated processing, data warehouses, and feeding into business intelligence tools
PDF: Professional formatted statements for formal documentation, audit packages, and stakeholder presentations
MultiCash: Colombian banking standard format for seamless integration with local financial systems
On-Demand Access#
Generate reports whenever you need them rather than waiting for scheduled batch processes. This means:Faster month-end close when you need multiple reports quickly
Immediate responses to audit requests without waiting for batch runs
Real-time visibility into your cash position across multiple countries and currencies
Ability to investigate issues immediately with current data
Automated Compliance (MultiCash)#
For Colombia operations, automatic daily MultiCash report generation means you're always compliant with local banking standards without manual work. Your team can focus on analysis and decision-making rather than report generation and formatting.Multi-Rail and Multi-Geography Visibility#
With Cobre handling SPEI (Mexico), ACH Colombia, Bre-B, Fast Pay, and other rails through one platform, consolidated reporting across all payment methods and countries saves hours of manual data compilation. Generate a single report that shows all your cross-border movements regardless of the underlying payment infrastructure—something impossible when working with multiple traditional banking relationships.Idempotent Statements for Consistency#
Account statements use idempotency—requesting the same period twice returns the identical document rather than creating a new one. This ensures everyone in your organization references the same statement version, critical for compliance documentation and audit trails.API-Driven Extensibility#
Every report available in the portal can also be generated programmatically through Cobre's Reports API. This means you can:Automate report generation as part of your nightly reconciliation processes
Integrate Cobre reporting directly into your accounting systems
Build custom dashboards that pull fresh data on demand
Trigger report generation based on business events or thresholds
Best Practices#
Plan Your Reporting Cadence#
Establish regular reporting schedules that match your reconciliation process:Daily reports for operational reconciliation
Weekly reports for cash flow monitoring
Monthly reports for financial close and analysis
Note: These reports are generated manually by the user. The option to schedule automated report generation is not currently available—except for Colombia operations, where Multicash reports generate automatically. Build your daily workflow around their 1-3 AM generation window.
Use Consistent Timezones#
Select the timezone where your operations team is based to avoid confusion when cross-referencing reports with internal systems.Leverage Custom Ranges Strategically#
Use custom ranges when you need to:Investigate specific incidents or issues
Align with fiscal periods that don't match calendar months
Extract data for specific business events or campaigns
| Format | Best For |
|---|
| CSV | Sharing with finance teams, performing Excel analysis, or creating pivot tables |
| JSON | Feeding into accounting systems, data warehouses, or automated reconciliation tools |
| MultiCash (for Colombia) | Integrating with local banking systems or providing data to Colombian counterparties |
While reports remain available indefinitely, download and archive critical reports (month-end, quarter-end, year-end) to your internal systems for redundancy.Monitor Report Status#
If a report remains in "Processing" status for an unusually long time, it may indicate a technical issue. Contact Cobre Support to investigate.MultiCash Best Practices#
Track consecutive numbers: Keep a log of consecutive numbers to quickly identify any gaps in your reporting sequence
Download both files: Always download both Header and Detail reports together for complete reconciliation
Set up morning workflows: Since MultiCash reports generate overnight, schedule your team's reconciliation tasks to start after 3:00 AM Colombia time
Archive systematically: Organize downloaded MultiCash files by date and consecutive number for easy retrieval during audits
Common Scenarios#
Daily Reconciliation#
1.
Generate a "Yesterday" Movements report in CSV format
2.
Download and compare against your accounting system
3.
Use the report ID to reference specific reports when investigating discrepancies
4.
For Transactions reports, select your local timezone so timestamps match your business hours
Colombia Daily Reconciliation with MultiCash#
1.
Each morning after 3:00 AM Colombia time, access the MultiCash tab
2.
Download the previous day's Header report to verify end-of-day balances
3.
Download the Detail report to reconcile individual transactions
4.
Check the consecutive number to ensure no reports are missing from your sequence
5.
Import both files into your local banking system or accounting software
Month-End Close#
1.
Use "Current month" period to capture all activity through the last day of the month
2.
Generate both Movements and Transactions reports for complete visibility
3.
For formal documentation, generate PDF Account Statements for each Cobre Balance account
4.
Cross-reference account statements with detailed transaction reports for comprehensive accuracy
5.
Download multiple reports at once using the bulk download feature to create your complete month-end package
Monthly Account Statement Package#
1.
Navigate to Reports section
2.
For each Cobre Balance COL/MEX account, generate an Account Statement for the completed month
3.
Specify the statement month (e.g., "2025-05")
4.
Download all statements and archive them as permanent monthly records
5.
Distribute statements to stakeholders who need formal documentation
Audit Preparation#
1.
Determine the audit period and required account coverage
2.
Generate Account Statements (PDF) for all relevant months to provide formal documentation
3.
Generate Detailed Movements reports (money_movement_v1) for transaction-level data
4.
Export in both CSV (for auditor spreadsheet analysis) and JSON (for your systems)
5.
For Colombia operations, compile MultiCash reports using consecutive numbers to demonstrate complete reporting coverage
6.
Use the bulk download feature to package everything into a single ZIP file
7.
Provide auditors with the secure download link (valid for 30 minutes)
Multi-Country Operations Reporting#
1.
Generate separate Movements reports for each geography or payment rail
2.
Use Movement type filters to segment by payment rail (e.g., SPEI for Mexico)
3.
For Colombia accounts, leverage automated MultiCash reports
4.
Generate Account Statements for each country where you have Cobre Balance accounts
5.
Consolidate all data in your preferred analysis tool for cross-border visibility
Investigating Specific Transaction Issues#
1.
Use Custom Range to define the exact time period when the issue occurred
2.
For precise timing, add hour ranges to your custom period
3.
Select appropriate timezone to see transactions in your operational context
4.
Generate both Movements and Transactions reports to see multiple perspectives
5.
Use report IDs when communicating with Cobre Support about specific data sets
API-Driven Automation#
1.
Integrate Cobre's Reports API into your nightly batch processes
2.
Automatically generate previous day's reports for all geographies
3.
Download reports programmatically and feed directly into your reconciliation system
4.
Set up webhooks to receive notifications when reports complete processing
5.
Archive reports systematically in your document management system
FAQs#
General#
Q: How long are reports available for download?
A: Reports remain accessible indefinitely in the Reports section unless manually deleted. This applies to all report types including CSV, JSON, PDF statements, and MultiCash reports.Q: Can I generate multiple reports simultaneously?
A: Yes, you can create multiple reports, but each processes individually. You'll see each report appear with "Processing" status until complete.Q: Can I modify a report after generating it?
A: No, generated reports are immutable to maintain audit integrity. If you need different parameters, generate a new report with updated settings.Q: What should I do if a report is stuck in "Processing" status?
A: Reports typically complete within a few minutes. If a report doesn't complete within a reasonable time, contact Cobre Support with the Report ID for assistance.Q: What's the difference between Detailed and General Movements reports?
A: Detailed reports (money_movement_v1 layout) provide comprehensive transaction-level data with all available fields—use these for reconciliation and detailed analysis. General reports (money_movement_legacy_csv_v1 layout) offer summarized information compatible with the previous platform version—use these for high-level overviews or legacy system integration.Q: Can I schedule automatic report generation?
A: Currently, most reports are generated on-demand through the portal or API. MultiCash reports for Colombia accounts generate automatically once you subscribe. Contact your Cobre account manager if you have requirements for scheduled report generation of other report types.Q: How do I download multiple reports at once?
A: Select multiple reports and request a download link. The system packages them into a ZIP file with a secure URL valid for 30 minutes. This is especially useful for month-end close or audit packages.Q: Can I access these reports through the API?
A: Yes, all reports available in the portal can also be generated programmatically through Cobre's Reports API. This allows you to automate report generation and integrate reporting into your existing systems. Refer to Cobre's API documentation for technical details.Account Statements FAQs#
Q: Which accounts can generate PDF statements?
A: Only Cobre Balance accounts in Colombia (COL) and Mexico (MEX) are eligible for PDF account statements. This feature follows local banking documentation standards for these markets.Q: What language are the statements in?
A: Statements are generated in Spanish for both Colombia and Mexico accounts, following local market standards.Q: Can I get a statement for partial months or custom date ranges?
A: No, account statements cover complete calendar months only. Each statement follows the format "YYYY-MM" (e.g., "2025-05" for May 2025). The system automatically calculates the full month boundaries based on your account's geography and timezone.Q: What happens if I request the same statement twice?
A: The system uses idempotency—requesting a statement for a period that's already been generated returns the existing document rather than creating a duplicate. This ensures consistent documentation and audit trail integrity.Q: How does timezone affect monthly statements?
A: The month boundaries for statements are calculated in the account's local timezone:Colombia accounts: Month calculated in UTC-05:00
Mexico accounts: Month calculated in UTC-06:00
A: Yes, you can generate statements for any historical month where your account had activity. There's no time limit on historical statement generation.MultiCash-Specific FAQs#
Q: Which accounts are eligible for MultiCash reports?
A: Only Cobre Balance Colombia accounts can generate MultiCash reports. This feature is specifically designed to comply with Colombian banking standards.Q: When are MultiCash reports generated?
A: Once you subscribe, MultiCash reports generate automatically every day between 1:00 AM and 3:00 AM Colombia time (approximately 10:00 UTC). You don't need to manually request these reports.Q: Why do I see two reports per day for each account?
A: MultiCash format separates data into Header files (daily balance summaries) and Detail files (individual transactions). This structure follows Colombian banking standards and makes it easier to use the data for different purposes.Q: What is the "Consecutive" number and why does it matter?
A: The consecutive number is a sequential identifier (1–9999) that increments across all MultiCash reports. It provides an audit trail to verify that no reports are missing from your sequence—if you see consecutive numbers 245, 246, 247, you know you have continuous reporting coverage.Q: Can I unsubscribe from MultiCash reports?
A: MultiCash subscriptions cannot be cancelled directly through the portal. If you need to modify your subscriptions, contact Cobre Support.Q: What timezone do MultiCash reports use?
A: All MultiCash reports use Colombia time (UTC-05:00) to ensure consistency with local banking systems and operations.Q: What if I miss downloading a MultiCash report?
A: All MultiCash reports remain available indefinitely in the MultiCash tab. You can download historical reports at any time using the consecutive number to identify the reports you need.
Getting Support#
For additional assistance with report generation or accessing historical reports, contact Cobre Support through the portal or reach out to your account manager.Modified at 2025-12-24 15:41:23
