# Create a Billing Report

Build a Soracom Query report showing historical SIM billing charges.

Execute a sample query in Soracom Query to display historic monthly billing total.

## Prerequisites

You must be subscribed to a Soracom Query plan. For details, see [Plan Management](https://docs.soracom.io/en/services/query/plans#plan-management).

## Step 1: Access Soracom Query

1. Sign in to the **[User Console](https://console.soracom.io/?coverage_type=g)**.

2. From the **☰ Menu**, expand **Soracom Query** and select **Soracom Query**.

   ![Soracom Query option in console menu](https://docs.soracom.io/_astro/show-3-active-sims-01.D0JNPATp_171h2O.webp)

3. Click **Launch Soracom Query Studio**.

   ![Launch Soracom Query Studio button](https://docs.soracom.io/_astro/show-3-active-sims-02.DvaIzwD-_YmPsh.webp)

4. Click **Advanced**.

   ![Advanced tab in Query Studio](https://docs.soracom.io/_astro/executing-sample-query-03.DgOeNlJd_Z1N0XRX.webp)

## Step 2: Execute a Sample Query

1. Click **Monthly billing total** in the Samples section.

   ![SQL query editor with billing history query](https://docs.soracom.io/_astro/executing-sample-query-04.BH3jkMtX_2fTpKl.webp)

2. When the SQL query is displayed, click **Run Query**.

   ![Execute query button](https://docs.soracom.io/_astro/executing-sample-query-05.BRT4btjW_13EOqd.webp)

   > [!WARNING]
   >
   > **The maximum character limit for SQL queries is 3,000 characters.**
   >
   > If your SQL query exceeds 3,000 characters, an error will be thrown. If you have exceeded the limit, reduce the number of characters in your SQL query within the allowable amount.

   The SQL execution results will be displayed.

   ![Query results showing billing history data](https://docs.soracom.io/_astro/executing-sample-query-06.IAFfe_3d_ZQdalU.webp)

If you want to edit the SQL for other parameters, use the editor to make your changes and click **Run Query** again.

> [!WARNING]
>
> For instructions on using the SQL Assistant to help generate SQL, refer to the [Show Connection Trends using Query](https://docs.soracom.io/en/services/query/connection-trends) example.