> ## Documentation Index
> Fetch the complete documentation index at: https://docs.getlago.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Export revenue recognition data

> Get your recognized and deferred revenue out of Lago for the close.

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

| Data                  | What it's for                                                                                 |
| --------------------- | --------------------------------------------------------------------------------------------- |
| Recognized revenue    | The revenue earned per period, for your income statement and revenue reconciliation.          |
| Deferred revenue      | The not-yet-earned balance, for your balance sheet.                                           |
| Journal entry details | The underlying double-entry lines, for posting to or reconciling against your general ledger. |
| Statements            | Balance and activity summaries for the period.                                                |

## 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.

<Tip>
  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.
</Tip>

## 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:

```html theme={"dark"}
<a href="https://app.eu-staging.getlago.com/customer/0bdb9e31-0455-46e9-9a73-b26e33a0a0e8/invoice/f1345e17-45a8-4295-95b2-dace4b877a29/overview" target="_blank">DEF-6175-043-001</a>
```

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`:

<CodeGroup>
  ```text Google Sheets theme={"dark"}
  =IFERROR(HYPERLINK(REGEXEXTRACT(C2,"href=""([^""]+)"""),REGEXEXTRACT(C2,">([^<]+)<")),"")
  ```

  ```text Excel theme={"dark"}
  =IFERROR(HYPERLINK(REGEXEXTRACT(C2,"href=""([^""]+)"""),REGEXEXTRACT(C2,">([^<]+)<")),"")
  ```
</CodeGroup>

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](/guide/revenue-recognition/reports/recognized-revenue). Use the [Journal Entry Details](/guide/revenue-recognition/reports/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.