Skip to main content

​
Overview

The Accounting (Contabilidad) module provides financial oversight and reporting capabilities for accounting staff. This role-specific interface focuses on sales verification, payment tracking, and financial exports.

​
Access Requirements

To access the accounting module, your employee account must have the Contador role assigned. This role is restricted to accounting department staff.
The accounting dashboard is accessible at /contabilidad/ventas after logging in with a Contador account.

​
Key Capabilities

Sales Review

View all sales transactions with detailed financial information

Payment Plans

Access down payment schedules and track payment status

Financial Reports

Generate and export payment plan reports to Excel

Project Filtering

Filter sales data by construction project

​
Main Features

​
Sales Transaction List

The main accounting dashboard displays all sales and separations with key financial details: Displayed Information:
  • Client Details: Name, document number, contact information
  • Property Information: Apartment/Local number, tower, floor
  • Financial Summary:
    • Base value (valor_base)
    • VAT/IVA amount
    • Total sale value (valor_total)
    • Down payment amount (cuota_inicial)
    • Remaining balance (valor_restante)
  • Payment Terms:
    • Payment method (forma_pago)
    • Down payment term (months)
    • Payment frequency
  • Sales Agent: Employee responsible for the sale
  • Transaction Date: Sale or separation date
  • Project: Associated construction project
Route: GET /contabilidad/ventas Filtering Options:
  • Filter by project (proyecto_id query parameter)
  • Results ordered by sale date (most recent first)

​
Sale Details View

Click on any sale to view comprehensive transaction details including:
  • Complete client profile
  • Property specifications
  • Full payment breakdown
  • Related documents
  • Payment plan (if applicable)
  • Transaction history
Route: GET /contabilidad/ventas/{id}

​
Down Payment Plan Report

The consolidated down payment report (Plan Pagos CI) provides a comprehensive view of all scheduled down payment installments across all sales. Report Features:
  • Lists all cuotas (installments) from active payment plans
  • Shows payment status (Pending, Paid, Partial, Overdue)
  • Displays due dates and amounts
  • Links to client and property information
  • Sortable and filterable data
Route: GET /contabilidad/reportes/plan-pagos-ci Data Included:
  • Cuota number and due date
  • Payment amount
  • Payment status
  • Client name and document
  • Property identifier (apartment/local number)
  • Project name
  • Associated sale ID

​
Excel Export

Generate Excel reports of down payment plans for external analysis or record-keeping. Route: GET /contabilidad/reportes/plan-pagos-ci/export Export Contents:
  • All cuota details from the report view
  • Formatted for accounting software import
  • Includes headers and proper data types
  • Generated using Maatwebsite/Excel package
The export creates a downloadable .xlsx file with the naming pattern: plan-pagos-ci-{date}.xlsx

​
Common Workflows

​
Reviewing Daily Sales

1

Access Sales Dashboard

Navigate to Contabilidad → Ventas from the main menu
2

Review New Transactions

Sales are sorted by date (newest first). Review recent entries for:
  • Correct pricing and calculations
  • Proper client and property associations
  • Valid payment terms
3

Verify Payment Plans

For sales with down payment plans, click through to verify:
  • Down payment percentage meets project minimum
  • Payment schedule aligns with agreed terms
  • Cuota amounts sum correctly to down payment total

​
Generating Monthly Payment Reports

1

Access Payment Plan Report

Navigate to Contabilidad → Reportes → Plan Pagos CI
2

Review Current Period

Filter or sort by due date to focus on current month payments:
  • Identify overdue payments
  • Check pending installments
  • Verify paid amounts match records
3

Export to Excel

Click the Export button to download the report
4

Process in Accounting Software

Import the Excel file into your accounting system for reconciliation

​
Project-Specific Financial Review

1

Select Project Filter

On the sales dashboard, use the project dropdown to filter by construction project
2

Analyze Project Financials

Review all sales for the selected project:
  • Total sales volume
  • Average sale values
  • Payment term patterns
  • Outstanding balances
3

Cross-Reference with Project Budget

Compare sales revenue against project financial projections

​
Data Access Patterns

​
Sales Query

The accounting module uses the following data model access pattern:
routes/web.php:452
Route::middleware(['auth', 'check.cargo:Contador'])->prefix('contabilidad')->group(function () {
    Route::get('/ventas', [ContabilidadVentasWebController::class, 'index'])
        ->name('contabilidad.ventas.index');
    
    Route::get('/ventas/{id}', [ContabilidadVentasWebController::class, 'show'])
        ->name('contabilidad.ventas.show');
    
    Route::get('/reportes/plan-pagos-ci', [ContabilidadVentasWebController::class, 'planPagosCI'])
        ->name('contabilidad.reportes.plan_ci');
    
    Route::get('/reportes/plan-pagos-ci/export', [ContabilidadVentasWebController::class, 'exportPlanPagosCI'])
        ->name('contabilidad.reportes.plan_ci.export');
});

​
Relationships Loaded

For optimal performance, the accounting views eager-load related models:
app/Http/Controllers/Contabilidad/ContabilidadVentasWebController.php:23
$ventas = Venta::with([
    'cliente',
    'empleado',
    'apartamento.estadoInmueble',
    'apartamento.torre',
    'local.estadoInmueble',
    'proyecto',
    'formaPago',
])->orderBy('fecha_venta', 'desc')->get();

​
Permissions and Restrictions

​
What Contador Role Can Do

✅ View all sales and separations
✅ View payment plans and schedules
✅ Export financial reports to Excel
✅ Filter sales by project
✅ Access detailed transaction information

​
What Contador Role Cannot Do

❌ Create or modify sales
❌ Edit client information
❌ Change payment terms
❌ Delete transactions
❌ Access project configuration
❌ Manage employees or users
❌ Configure pricing policies The Contador role is read-only for financial verification and reporting purposes.

​
Best Practices

Review new sales daily to catch data entry errors early. Verify:
  • Client names match legal documents
  • Property identifiers are correct
  • Financial calculations are accurate
  • Payment terms align with company policies
Monitor the payment plan report regularly:
  • Flag overdue payments for collections
  • Prepare monthly payment summaries
  • Track payment trends by project
  • Identify clients requiring payment reminders
Maintain an organized archive of exported reports:
  • Export monthly payment reports on the 1st of each month
  • Name files consistently (e.g., 2026-03-plan-pagos-ci.xlsx)
  • Store in accounting records system
  • Retain for audit trail and tax purposes
Coordinate with sales and management teams:
  • Report discrepancies to sales managers
  • Notify management of payment delays
  • Share financial insights for decision-making
  • Request clarification on unusual transactions

​
Integration with Other Modules

​
Sales Module

  • Sales are created by sales representatives (Asesora Comercial)
  • Accounting reviews and verifies transactions post-sale
  • Payment plans are auto-generated based on sales terms

​
Management Dashboard

  • Management (Gerente) can also export payment reports
  • Financial KPIs in management dashboard sourced from same data
  • Coordinate with management for financial goal tracking

​
Client Module

  • Client information displayed in accounting is managed by sales/admin
  • Accounting identifies client data issues but cannot modify records
  • Report client data discrepancies to administrators

​
Troubleshooting

If expected sales are missing from the dashboard:
  • Verify the project filter is not excluding transactions
  • Confirm transactions are saved (check with sales team)
  • Ensure your Contador role is properly assigned
  • Check for date range filters that may hide older sales
If Excel export doesn’t download:
  • Check browser pop-up blocker settings
  • Ensure sufficient server memory for large exports
  • Verify Maatwebsite/Excel package is installed
  • Try filtering to a smaller date range
If payment plan data is incomplete:
  • Confirm sales have payment plans generated
  • Payment plans only exist for sales with cuota_inicial > 0
  • Separations don’t have payment plans until converted to sales
  • Check with sales staff that plan generation completed

Build docs developers (and LLMs) love

Get started for freeTalk to us