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

# Integration with external billing systems

> Export reports to spreadsheets for integration with other systems

In **ADMICOM**, the `Reports > Sales` option allows exporting the complete database for integration with third-party billing systems.

The procedure is straightforward:

1. Select the date range for export.
2. Click **Report**.
3. Click the **Export to Excel** button.

This process should be performed **once a month** to obtain all commercial fields that ADMICOM stores for each advertising order. The resulting file can be imported by any external billing software used by the station.

***

### Custom management reports

ADMICOM also allows generating **custom report templates** that can be exported to Excel format for use by station management.

These reports enable analysis of data such as:

* Billable amounts per client.
* Sales by program.
* Sales by agency.
* Distribution by business category.
* Monthly totals.

In the `Reports > Sales` module, the upper right panel includes customization tools:

* Users can work with a **3-axis cube (X, Y, Z)** to organize data.
* Once designed, reports can be **saved** for reuse or **loaded** using the `LOAD / SAVE` buttons.
* The **PIVOT** button allows applying filters to generate virtually any type of possible report.

When the data is ready, simply export it using the **Excel** button. The resulting file can be:

* Imported into other programs that read spreadsheets.
* Used directly in Excel to design more detailed charts and management reports.

***

### Key fields for integration

Among all available report fields, some are **crucial for interrelating ADMICOM with the external billing system**:

* **Agency Number:**\
  Campaign code assigned by agencies.\
  Usually follows the format `1234/0`, where the digit after the slash indicates revisions (e.g., `1234/1` after a *Cancel and Replace* process).
* **Internal Number:**\
  Code assigned by ADMICOM to each new loaded order.\
  This number is **unique** and also follows the `1234/0` convention.\
  When using the *Cancel and Replace* function, the original schedule is kept with an expired date, and a new version is generated with incremental numbering (`1234/1`, `1234/2`, etc.).\
  This field is the most suitable for uniquely identifying orders in an external billing system.
* **Client:**\
  Name of the client to be billed.
* **Gross:**\
  Total amount to be billed.\
  (The report also includes partial amounts and intermediate discounts that may be useful for certain management systems).