Reports & Analytics - Sistema Financiero

Reports provide detailed views of your financial data with powerful filtering, sorting, and export capabilities for in-depth analysis.

Overview

The Reports feature offers multiple viewing perspectives on your financial data, from daily snapshots to monthly overviews, with advanced filtering and pagination for handling large datasets.

Reports pull from the same transaction database as the Dashboard but offer more granular control and viewing options.

Report Views

Time-Based Views

Choose how to aggregate and display your financial data:

Daily View

Shows transactions grouped by individual days, ideal for:

Daily reconciliation
Tracking day-to-day patterns
Analyzing last 7 days of activity

Weekly View

Groups transactions by week number within months:

Week-over-week comparisons
Identifying weekly patterns
Covers last 28 days (4 weeks)

Monthly View

Aggregates by month for high-level overviews:

Month-to-month trends
Annual planning
Shows last 12 months

Custom Range

Select any specific date range:

Project-specific analysis
Quarter or year-end reports
Custom business periods

Switching Between Views

Open Reports

Navigate to the Reports section from the main menu

Select View

Click one of the four view buttons:

Diaria (Daily)
Semanal (Weekly)
Mensual (Monthly)
Personalizada (Custom)

For Custom: Set Dates

If you selected Custom:

Click the date picker panel
Choose start and end dates
Click “Aplicar” (Apply)

View Updates

The report automatically refreshes with the new time frame

Summary Cards

At the top of every report, three summary cards display aggregate metrics:

Total Income

Color: Green gradient background
Shows: Sum of all income transactions in the selected period
Format: Mexican Pesos with two decimal places

Total Expenses

Color: Red gradient background
Shows: Sum of all expense transactions in the selected period
Format: Mexican Pesos with two decimal places

Net Balance

Color: Blue gradient (positive) or Orange gradient (negative)
Shows: Income minus expenses
Indicator: Color changes based on whether you’re in the positive or negative

Filtering & Sorting

Transaction Type Filters

Filter the report to show only specific transaction types:

Todos (All): Display all transactions
Ingresos (Income): Show only income transactions (green)
Gastos (Expenses): Show only expense transactions (red)

The transaction count updates in real-time as you apply filters, helping you see exactly how many transactions match your criteria.

Column Sorting

Click any column header to sort by that field:

Fecha (Date/Time): Sort chronologically
Tipo (Type): Group by income vs. expense
Categoría (Category): Alphabetical by category
Monto (Amount): Numerical order by transaction size
Método (Payment Method): Group by payment type

Sort Direction:

First click: Ascending order (↑)
Second click: Descending order (↓)
Visual indicator shows which column is sorted and direction

Transaction Table

Grouped Display

Transactions are grouped by time period based on your selected view:

Daily View: Groups by date (e.g., “06/10/2025”)
Weekly View: Groups by month and week number (e.g., “octubre 2025 - Semana 2”)
Monthly View: Groups by month (e.g., “octubre 2025”)

Group Headers

Each group shows:

Period label (date/week/month)
Total for that period (income minus expenses)
Color-coded: Green for positive, red for negative

Transaction Rows

Each transaction displays:

Column	Description	Format
Fecha/Hora	Date and time	DD/MM/YYYY HH:MM
Tipo	Transaction type	Badge: Green (Ingreso) or Red (Gasto)
Categoría	Category name	Text
Descripción	Details or notes	Text (truncated if long)
Método	Payment method	Efectivo, Tarjeta, or Transferencia
Monto	Amount	+/- $XXX.XX MXN

Visual Design

Row Colors:
- Income rows: Light green background
- Expense rows: Light red background
Hover Effect: Rows become slightly darker on hover
Dark Mode: Colors adapt for dark theme
Responsive: Table scrolls horizontally on small screens

Pagination Controls

Handle large datasets efficiently with built-in pagination:

Items Per Page

Choose how many transactions to display:

20: Default, good for quick scanning
50: Medium datasets
100: Larger reviews
500: Export-sized views

Anterior (Previous): Go to previous page
Siguiente (Next): Go to next page
Page Indicator: Shows current page and total pages
Range Display: Shows which transactions are visible (e.g., “Showing 1-20 of 287”)

Pagination resets to page 1 whenever you change filters or sorting to ensure you don’t miss data.

Data Export

Preparing for Export

Set Your Criteria

Select the time period (view)
Apply any filters (type, category)
Set items per page to 500 for maximum data

Navigate All Pages

Use pagination to cycle through all pages, reviewing the data

Browser Tools

Use browser developer tools to access the API data directly:

fetch('/api/transacciones?vista=mensual')
  .then(r => r.json())
  .then(data => console.log(data))

Process Data

Copy the JSON data and convert to CSV/Excel using your preferred tool

For regular exports, consider building a simple script that calls the /api/transacciones endpoint with your desired parameters.

Common Report Workflows

Daily Reconciliation

Select Daily View
Review today’s transactions at the top
Compare amounts with bank statements
Verify all transactions are recorded
Note any discrepancies for investigation

Weekly Business Review

Select Weekly View
Focus on current week’s group
Compare with previous week
Identify trends: which days are highest revenue?
Adjust operations based on patterns

Monthly Financial Close

Select Monthly View
Choose the completed month
Filter by Gastos to review all expenses
Switch to Ingresos to verify all income
Review the net balance for the month
Compare with budget targets

Tax Preparation

Use Custom Range for tax year
Set date range (e.g., Jan 1 - Dec 31)
Set items per page to 500
Filter by category to separate deductible expenses
Export transaction data
Provide to accountant or tax software

Budget Analysis

Select Monthly View for last 6-12 months
Note the income and expense totals
Calculate averages
Identify spending categories consuming most budget
Set targets for next period

Performance Considerations

Data Limits

The API enforces a maximum of 500 transactions per request to maintain performance. For larger datasets:

Use pagination to navigate through data
Apply filters to reduce result set
Use narrower date ranges
Query by category for focused analysis

Loading States

The report displays a loading spinner during data fetches:

Typically completes in under 1 second
May take longer for custom ranges spanning multiple months
All filtering and sorting happens client-side after initial load

Accessibility Features

Keyboard Navigation: Tab through filters and pagination controls
Screen Reader Support: Table headers and labels properly tagged
High Contrast: Works with browser high contrast modes
Focus Indicators: Clear focus outlines on interactive elements
Responsive Text: Scales with browser zoom

API Integration

Developers can access report data programmatically:

Endpoint

GET /api/transacciones

Query Parameters

Parameter	Values	Description
`vista`	`diaria`, `semanal`, `mensual`, `personalizada`	Time aggregation view
`fecha_inicio`	`YYYY-MM-DD`	Start date (required for personalizada)
`fecha_fin`	`YYYY-MM-DD`	End date (required for personalizada)

Example Requests

# Monthly view (last 12 months)
curl https://your-domain.com/api/transacciones?vista=mensual

# Custom date range
curl https://your-domain.com/api/transacciones?vista=personalizada&fecha_inicio=2025-01-01&fecha_fin=2025-03-31

# Weekly view
curl https://your-domain.com/api/transacciones?vista=semanal

Response Format

{
  "data": [
    {
      "id": "123",
      "fecha": "2025-10-09T14:30:00Z",
      "tipo": "gasto",
      "categoria": "Alimentación",
      "monto": 450.50,
      "descripcion": "Compra en supermercado",
      "metodo_pago": "tarjeta"
    }
  ],
  "vista": "mensual"
}

Dashboard - Real-time overview of financial metrics
Manual Entry - Add transactions to analyze
Recurring Expenses - Automatic expense tracking

Core Features

AI Features

Data Management

​Overview

​Report Views

​Time-Based Views

Daily View

Weekly View

Monthly View

Custom Range

​Switching Between Views

​Summary Cards

​Total Income

​Total Expenses

​Net Balance

​Filtering & Sorting

​Transaction Type Filters

​Column Sorting

​Transaction Table

​Grouped Display

​Group Headers

​Transaction Rows

​Visual Design

​Pagination Controls

​Items Per Page

​Navigation

​Data Export

​Preparing for Export

​Common Report Workflows

​Daily Reconciliation

​Weekly Business Review

​Monthly Financial Close

​Tax Preparation

​Budget Analysis

​Performance Considerations

​Data Limits

​Loading States

​Accessibility Features

​API Integration

​Endpoint

​Query Parameters

​Example Requests

​Response Format

​Related Features

Build docs developers (and LLMs) love

Overview

Report Views

Time-Based Views

Switching Between Views

Summary Cards

Total Income

Total Expenses

Net Balance

Filtering & Sorting

Transaction Type Filters

Column Sorting

Transaction Table

Grouped Display

Group Headers

Transaction Rows

Visual Design

Pagination Controls

Items Per Page

Navigation

Data Export

Preparing for Export

Common Report Workflows

Daily Reconciliation

Weekly Business Review

Monthly Financial Close

Tax Preparation

Budget Analysis

Performance Considerations

Data Limits

Loading States

Accessibility Features

API Integration

Endpoint

Query Parameters

Example Requests

Response Format

Related Features