Run a conciliation report (Cuadratura)
Use this procedure to compare documents between your ERP and Paperless Colombia and confirm data consistency.
- Go to Ambiente de Facturación.
- Select Generación de Reportes.
- Click Cargar de Cuadraturas.
- Click Choose File and select the file exported from your ERP.
- Select the Periodo.
- Select the Documentos a cuadrar.
Cuadrar TODO: Reconcile all documents.
Cuadrar solo POS: Reconcile only Point of Sale (POS) documents (you can filter by branch).
Cuadrar solo BACKOFFICE: Reconcile only backoffice documents.
- Click Cargar.
Review the results to check for discrepancies:
- OK
- Document exists in both systems with matching data.
- Not in Paperless
- Document exists in your ERP but not in Paperless.
- Not in ERP
- Document exists in Paperless but not in your ERP file.
- Amount mismatch
- Document exists in both systems but amounts differ.
- Duplicate
- Duplicate document detected.
You can download the conciliation results as a CSV or TXT file for further analysis.
View Bitácora de Cuadratura
- Go to Ambiente de Facturación.
- Select Generación de Reportes.
- Select Bitácora de Cuadraturas.
- Use the filters to find the conciliation run you want.
- Click the download icon in the Descargar column.
The conciliation results file downloads to your computer.
Note: Conciliation can run daily, weekly, or monthly, based on your company's needs.