> For the complete documentation index, see [llms.txt](https://docs.xorosoft.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.xorosoft.com/xoroerp-1/reports/accounting/balance-sheet-by-date.md).

# Balance Sheet by Date

### What is Balance Sheet By Date?

XoroSoft's **Balance Sheet By Date** report in the Reporting module provides a detailed view of the company's financial position across multiple dates. The report displays account balances for different periods, allowing users to compare financial values over time.

The report presents account balances under different account types, such as Bank and Undeposited Funds, along with the corresponding Account Name. Values are displayed for each available date, as well as a **Total** column that provides the overall balance for the selected account.

{% hint style="info" %}
To access the Balance Sheet By Date report, go to **Menu > Reports > Accounting > Balance Sheet by Date**
{% endhint %}

Selecting the **Balance Sheet By Date** report opens the report viewer, where users can select the required reporting period. The report displays the financial balances as of the selected date and provides a breakdown of account balances across multiple dates.

### Selecting Reporting Template

After choosing the **Balance Sheet By Date** option, you'll be prompted to choose a document template. Select the required report template from the **Select Document Template** dropdown to open the report.

<figure><img src="https://3188343778-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkf8DNCjEfcSm64PCPcmf%2Fuploads%2FkhMLjPeYXtdQNjnRQMcO%2Fimage.png?alt=media&amp;token=43781c9c-37fb-41c0-a562-a35f0098cb02" alt=""><figcaption></figcaption></figure>

<figure><img src="https://3188343778-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkf8DNCjEfcSm64PCPcmf%2Fuploads%2FHnHEosbgRMBUdTqoJYM8%2Fimage.png?alt=media&amp;token=420f6ad2-a231-40b9-92e0-14ea08c05708" alt=""><figcaption></figcaption></figure>

#### Balance Sheet By Date Components

The Balance Sheet By Date report provides a date-wise view of account balances. The report contains account information along with the corresponding balances for multiple dates.

The report consists of the following key components:

* **Account Type:** Displays the classification of the account, such as Bank or Undeposited Funds.
* **Account Name:** Displays the name of the account for which the balance is reported.
* **Amount:** Displays the balance of the selected account for each date included in the report. Each date is displayed as a separate column, allowing users to compare account balances across different dates.
* **Total:** Displays the total balance for the respective account across the dates displayed in the report.

### Fields and Interactive Elements

The **Balance Sheet By Date** report provides drill-down functionality for account balances. Users can click on an amount displayed for an account to view the transactions that make up the selected balance.

For example, clicking an amount for an account opens the **Balance Sheet Account Details By Date** window. This window provides detailed information about the transactions associated with the selected account and date.

The detailed view contains the following fields:

| **Field**        | **Description**                                                                                          |
| ---------------- | -------------------------------------------------------------------------------------------------------- |
| **Txn Number**   | This numerical value serves as a unique identifier generated by XoroERP for referencing the transaction. |
| **Txn Type**     | Represents the type of transaction associated with the selected account, such as Customer Deposit.       |
| **Date**         | Displays the date on which the transaction occurred.                                                     |
| **Account Name** | Displays the name of the account associated with the transaction.                                        |
| **Entity Name**  | Displays the entity associated with the transaction.                                                     |
| **Ref Number**   | Displays the reference number associated with the transaction.                                           |
| **Store**        | Displays the store associated with the transaction.                                                      |
| **Amount**       | Displays the monetary value associated with the transaction.                                             |

The detailed transaction view also displays the total amount for the transactions returned for the selected account and date.

<figure><img src="https://3188343778-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkf8DNCjEfcSm64PCPcmf%2Fuploads%2FKj5nRQzS0V4PoqGVs6AE%2Fimage.png?alt=media&amp;token=647e0f68-eb5a-43e2-96ef-391f94bc47f8" alt=""><figcaption></figcaption></figure>

Furthermore, users can click on an individual **Txn Number** to open the journal view of the transaction. The journal view provides a more detailed view of the financial entries associated with the selected transaction, including its Debit and Credit entries.

<figure><img src="https://3188343778-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkf8DNCjEfcSm64PCPcmf%2Fuploads%2F6j9YjSG1mri2X2QpZrCQ%2Fimage.png?alt=media&amp;token=1bb99f4e-5a7b-4258-a3d0-b5c0ea5dee4d" alt=""><figcaption></figcaption></figure>

#### Period

XoroERP allows users to select the timeframe for which they want to view the Balance Sheet By Date report. The **Period** panel is displayed on the right side of the report viewer and provides several predefined period options.

Users can select options such as:

* **Custom**
* **Today**
* **This Week**
* **This Week-To-Date**
* **This Month**
* **This Month-To-Date**
* **This Calendar Quarter**
* **This Calendar Quarter-To-Date**
* **This Fiscal Quarter**
* **This Fiscal Quarter-To-Date**
* **This Calendar Year**
* **This Calendar Year-To-Date**
* **This Fiscal Year**
* **This Fiscal Year-To-Date**
* **Yesterday**
* **Last Week**
* **Last Week-To-Date**
* **Last Month**
* **Last Month-To-Date**
* **Last Calendar Quarter**
* **Last Calendar Quarter-To-Date**
* **Last Fiscal Quarter**
* **Last Fiscal Quarter-To-Date**
* **Last Calendar Year**

Selecting a period updates the report to display the corresponding account balances.

### Balance Sheet By Date Report Header Icons

* **Refresh:** This allows you to refresh the report after changing the reporting criteria.
* **Toggle Print View:** This feature enables you to switch the display mode specifically for printing the report.
* **Download:** This feature allows users to export and download the report in the available file formats.
* **Print:** This allows users to print the displayed report.
* **Toggle Parameter Area:** This allows users to show or hide the parameter area on the right side of the report viewer.
* **Zoom In and Zoom Out:** These features allow users to adjust the report's display size for easier viewing and analysis.
* **Toggle Full Page Width:** This feature allows users to expand the report to utilize the available page width or return it to the standard viewing width.
* **Search:** This allows users to search for specific information within the report.

### FAQ

**1. Can I generate a monthly Balance Sheet report?**

The **Balance Sheet by Date** report provides the desired month-wise output. You can generate and review the report for an individual instance.


---

# 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 dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.xorosoft.com/xoroerp-1/reports/accounting/balance-sheet-by-date.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

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.