> For the complete documentation index, see [llms.txt](https://docs.phocassoftware.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.phocassoftware.com/budgets-and-forecasts/contributor/open-baseline-comparative-or-opening-balance-data.md).

# Open baseline, comparative, or opening balance data

{% hint style="info" icon="key" %}
Permission: **Budgets & Forecasts**
{% endhint %}

When reviewing or contributing to a budget or forecast, you can open the source data to investigate the values used in a worksheet. This includes baseline data, comparative data, and, on a Balance Sheet tab, opening balances.

Use the worksheet's **Tab** menu to open the data:

* In a financial workbook, the data opens in Financial Statements.
* In an operational workbook, such as a Sales budget, the data opens in Analytics in a new browser tab. Your workbook remains open in the original tab.

## Baseline data

Baseline data is the data used to populate the worksheet initially. It comes from the stream, measure, and period selected during the budget or tab setup. Typically, this is the actual data from the prior year.

To open baseline data for an operational workbook:

1. Open the worksheet tab you want to investigate.
2. Click **Tab** > **Open baseline values in Analytics**.
3. Select the database and period from the submenu.

For example, in this Sales budget, select **Sales Dec 2025 - Nov 2026**.

<div align="left"><figure><img src="https://2974338405-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FaNH5UMuZXBHuAbFF7nI2%2Fuploads%2FIlsDpvfmMQzTQ0cnlfDB%2Fimage.png?alt=media&amp;token=6794aefe-4d42-4859-bca7-635cb445c130" alt="" width="563"><figcaption></figcaption></figure></div>

Analytics opens in **Period** mode in a new browser tab. Check the stream, measure, period, and filters to see which data you're viewing. In this example, the Sales stream, Revenue measure, and Dec 2025 - Nov 2026 period are selected, with a filter for 10 sales reps.

<figure><img src="https://2974338405-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FaNH5UMuZXBHuAbFF7nI2%2Fuploads%2FV8pZHRXrKj8KffcalCBG%2Fbudget-baseline-analytics.png?alt=media" alt="Sales baseline data open in Analytics in Period mode, with the Revenue measure, Dec 2025 to Nov 2026 period, and a filter for 10 sales reps."><figcaption></figcaption></figure>

To return to your workbook, switch to the original browser tab.

## Comparative data

Comparative data is available to display in the worksheet as comparison rows. It comes from the stream, measure, and period selected in the worksheet tab's comparison setup.

Open the **Tab** menu and select the comparative data you want to investigate. The menu wording depends on the workbook type and [comparison setup](https://docs.phocassoftware.com/budgets-and-forecasts/owner-and-administrator/edit-the-comparison-setup.md):

* If there is only one comparison row, its name is displayed in the **Tab** menu. For example, in a financial workbook, the label might say **Open ‘Actuals’ in Financial Statements**.
* If multiple comparison rows have been set up, such as last year's actuals, last year's budget, and the current year's forecast, open the submenu to select one. In a financial workbook, the menu option is **Open comparison row in Financial Statements**.

<div align="left"><figure><img src="https://content.gitbook.com/content/aNH5UMuZXBHuAbFF7nI2/blobs/vConEi4ZVHN37nYiRC3z/3601301505.png" alt="Tab menu showing options to open comparative data in Financial Statements."><figcaption></figcaption></figure></div>

In an operational workbook, comparative data opens in Analytics in a new browser tab. To return to your workbook, switch to the original tab.

The baseline and comparative data can be the same. For example, a budget might be populated with last year's actual values and use those same values for comparison. By default, the first comparison row is based on your budget workbook setup.

## Opening balance data

On the **Balance Sheet** tab, use the **Tab** menu to open the opening balances. This helps you check how the opening balances were pulled from Financial Statements into Budgets & Forecasts.

The Balance Sheet opens in Financial Statements with the stream, period, and measure defined in the Balance Sheet tab setup, and any budget filters applied.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://docs.phocassoftware.com/budgets-and-forecasts/contributor/open-baseline-comparative-or-opening-balance-data.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
