Skip to main content
Revenue recognition data is meant to feed your accounting close. You can export the figures from Lago to reconcile against your general ledger and bring them into your accounting or ERP system. Every report and graph in the revenue recognition section is exportable. You can pull the underlying figures out in multiple formats to work with them in a spreadsheet, a BI tool, or your accounting system.

​
What you can export

​
When to export

Most teams export at month-end, once the reporting period is settled, to:
  • Reconcile recognized revenue against the general ledger.
  • Post or verify journal entries in their accounting system.
  • Hand finance a clean record of deferred revenue carried into the next period.
Export after the period’s billing is finalized. In-arrears usage and true-ups settle at invoicing, so exporting before invoices are issued can capture figures that are still moving.

​
Clickable fields in exports

Some fields in the reports are clickable links back to the Lago app, like an invoice that opens its overview page. In the export, these come through as HTML so the link is preserved. A clickable invoice field looks like this in the exported file:
To turn that raw HTML into a clean clickable cell, wrap it in a formula that pulls out the URL and the label. Assuming the HTML sits in cell C2:
The cell then shows the invoice number (DEF-6175-043-001) and links straight to the invoice in Lago. Apply the formula down the column to convert every linked field at once.

​
What this means for your reports

The export mirrors what you see in the reports. Use the Journal Entry Details as the line-level source of truth when you need to trace any exported figure back to the billing event that produced it.