Overview
Never forget a subscription payment or regular expense again. The Recurring Expenses feature automatically creates transaction entries on the specified day of each month, ensuring your financial records are always complete.Recurring expenses are processed automatically every time the Dashboard loads, making your financial data always up-to-date.
How It Works
Automatic Processing
The system checks for recurring expenses daily:- On Dashboard Load: When you open the Dashboard, the system checks if today matches any recurring expense days
- Day Matching: If today’s date matches a configured day (e.g., the 15th), the expense is processed
- Transaction Creation: A new transaction entry is automatically created with all configured details
- Last Execution Tracking: The system records when each expense was last processed to prevent duplicates
System Checks Date
Each day, the system compares the current date with all active recurring expenses
Duplicate Prevention
The system checks the
ultima_ejecucion (last execution) date to ensure it hasn’t already been processed todayTransaction Created
A new expense transaction is created with:
- Type: “gasto” (expense)
- Category, amount, and payment method from the recurring expense
- Today’s date and time
- Description indicating it’s from a recurring expense
Managing Recurring Expenses
Creating a New Recurring Expense
Fill Required Fields
Enter the expense details:Required Fields:
- Nombre: Descriptive name (e.g., “Netflix Premium”)
- Día de Cobro: Day of month (1-31) when charged
- Monto: Amount in Mexican Pesos
- Categoría: Select from expense categories (default: Suscripciones)
- Método de Pago: Cash, Card, or Transfer (default: Tarjeta)
- Cuenta: Bank account or card name (optional)
Editing an Existing Expense
- Find the expense in the table
- Click the edit icon (pencil) in the Actions column
- Modify any fields in the form
- Click “Actualizar” to save changes
Deactivating an Expense
To temporarily stop an expense without deleting it:- Click the edit icon
- Uncheck the “Activo” checkbox
- Save the changes
Deleting an Expense
- Click the delete icon (trash) in the Actions column
- Confirm the deletion in the popup dialog
- The expense is permanently removed
Dashboard KPIs
The Recurring Expenses page displays three key metrics:Total Activos
Sum of all active recurring expenses per month
Gastos Activos
Number of active recurring expenses out of total
Próximo Cobro
Next upcoming charge date based on active expenses
Expense Table
The table displays all recurring expenses with:Columns
- Nombre: Expense name/description
- Día Cobro: Day of month when charged
- Monto: Amount in MXN (displayed in red with minus sign)
- Categoría: Assigned category
- Estado: Active or Inactive status badge
- Cuenta: Associated account/card
- Acciones: Edit and Delete buttons
Visual Indicators
- Active expenses: Full opacity, green “Activo” badge
- Inactive expenses: Reduced opacity (50%), gray “Inactivo” badge
- Color coding: All amounts shown in red to indicate outgoing money
Common Use Cases
Subscriptions
Streaming Services
Set up Netflix, Spotify, Disney+, etc. with their monthly charge dates
Software & SaaS
Track Adobe Creative Cloud, Microsoft 365, domain renewals, hosting fees
Regular Bills
Utilities
Electricity, water, gas bills that come on the same day each month
Rent & Mortgage
Monthly housing payments
Memberships
Gym & Fitness
Gym memberships, fitness class subscriptions
Professional Associations
Professional organization dues, club memberships
Configuration Details
Day of Month Logic
The system uses the day number (1-31) for matching:- Day 1-28: Works for all months
- Day 29-31: For months with fewer days, the expense processes on the last day of that month
If you set an expense for day 31, it will process on February 28 (or 29 in leap years), as those months don’t have a 31st day.
Payment Methods
Three options available:- Efectivo: For cash expenses (less common for recurring)
- Tarjeta: Credit or debit card payments (most common)
- Transferencia: Bank transfers and automatic ACH payments
Categories
All expense categories are available:- Suscripciones: Default for most recurring expenses
- Alimentación: Meal subscriptions, food delivery memberships
- Transporte: Transit passes, car lease payments
- Vivienda: Rent, mortgage, utilities
- Salud: Health insurance, gym memberships
- Entretenimiento: Streaming, gaming subscriptions
- Educación: Online courses, educational platforms
- Otros Gastos: Anything not fitting other categories
Technical Details
Processing Endpoint
- Fetches all active recurring expenses
- Checks if today matches the configured day
- Verifies the expense hasn’t been processed today
- Creates a transaction entry
- Updates the
ultima_ejecuciontimestamp
Database Fields
Each recurring expense stores:id: Unique identifiernombre: Display namedia_cobro: Day of month (1-31)monto: Amount (decimal)activo: Boolean active statuscategoria: Category namemetodo_pago: Payment methodcuenta: Optional account nameultima_ejecucion: Timestamp of last processing
Best Practices
Troubleshooting
Expense Not Processing Automatically
- Check Active Status: Ensure the “Activo” checkbox is enabled
- Verify Day: Confirm today matches the configured day
- Check Last Execution: Look at when it last processed - it won’t process twice in one day
- Open Dashboard: Processing happens on Dashboard load, so visit the Dashboard
Duplicate Entries
If you see duplicate recurring expense entries:- The system should prevent this automatically
- Check the
ultima_ejecuciondate in the database - Contact support if duplicates persist
Missing Transactions
If an expense should have processed but didn’t:- Verify the recurring expense exists and is active
- Check the day of month is correct
- Review the Dashboard console logs for processing messages
- Manually create the transaction if needed
Related Features
- Dashboard - View automatically created transactions
- Manual Entry - Manually record one-time expenses
- Reports - Analyze your recurring expense patterns