Books

Books

Open in ChatGPT
Ask ChatGPT about this page
Open in Claude
Ask Claude about this page

Balance Sheet

The Balance Sheet shows the financial position of your company. It shows the balances of your asset, liability, and equity accounts at the end of each period.

Click Reports > Balance Sheet in the sidebar. On a phone, tap Reports in the bottom tabs, tap the report title, and then tap Balance Sheet. The report opens with three monthly periods. The newest period ends today.

For the controls that all reports share, such as the filters on a phone, export, and print, see Reports.

How Frappe Books Calculates the Balances

Frappe Books uses the ledger entries of your submitted documents. It does not use draft documents or cancelled documents. The balance in a column is the total of all the entries of the account up to the last day of that period. The balance starts at the first ledger entry of the account, not at the start of the period.

Section Accounts Balance Total Row
Assets Root type Asset The debits minus the credits Total Asset (Debit)
Liabilities Root type Liability The credits minus the debits Total Liability (Credit)
Equity Root type Equity The credits minus the debits Total Equity (Credit)

A group account shows the total of the accounts below it. The report shows only the accounts that have ledger entries. For more information about root types, see Chart of Accounts.

The Profit in the Balance Sheet

Your income and expense accounts show in the Profit and Loss Statement. Frappe Books does not move the profit to an equity account. So the Balance Sheet adds two rows after the sections:

Balance Sheet with three monthly columns that shows the liabilities, the equity, the Provisional Profit / Loss row, and the Total (Credit) row.

Row Shows
Provisional Profit / Loss (Credit) The total income minus the total expenses, from the first ledger entry up to the date of the column. A loss is a negative amount.
Total (Credit) The total liability, plus the total equity, plus the profit or loss. It is equal to Total Asset (Debit).

The two rows do not show when the profit is zero in all the columns. For more information, see Accounting Basics.

Filters

The Balance Sheet has the same filters as the Profit and Loss Statement, such as Periodicity, Based On, and Hide Group Amounts. For the descriptions, see Filters. Two filters work differently:

  • With Until Date, each column shows the balances on the last day of its period. For example, a To Date of 15 September 2026 with three monthly periods shows the balances on 15 September, 15 August, and 15 July. If the To Date is the last day of a month, each period ends on the last day of its month.
  • Consolidate Columns shows one column with the balances on the last day of the date range.

Read the Report

On a computer, each column after the accounts shows one period. The newest period is first. The column header is the last day of the period.

On a phone, the report shows one column. By default, it shows the newest period. To show a different period, tap Column, and then tap the period. To see the balances of an account in all the periods, tap the account.

Last updated 2 weeks ago
Was this helpful?
Thanks!