Classified Balance Sheet

Classify accounts into current and non-current groups and get working capital, current ratio and debt-to-equity per period automatically.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

Finance

Tables

Periods, Line Items

Fields

23

Views

grid, dashboard

Tables, columns and sample rows

The 2 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

2 tabs23 fields10 sample rows

Views
  • Ratios (Grid view)
12 fields
Periods: 2 sample rows
RowPeriod (Text)Period End (Date)Line Items (Link to another table)Current Assets (Rollup)Total Assets (Rollup)Current Liabilities (Rollup)Total Liabilities (Rollup)Equity (Rollup)Working Capital (Formula)Current Ratio (Formula)Debt to Equity (Formula)Balanced? (Formula)
1
FY 2025-26
3 Apr 2026
Cash and cash equivalentsTrade payablesShare capital & reserves
₹900,000
₹900,000
₹650,000
₹650,000
₹250,000
₹250,000
1.38
2.60
Balanced
2
H1 FY 2026-27
2 Oct 2026
Cash and cash equivalentsTrade receivablesInventoriesProperty, plant & equipmentTrade payablesShort-term borrowingsLong-term loanShare capital & reserves
₹2,870,000
₹6,070,000
₹1,120,000
₹2,620,000
₹3,450,000
₹1,750,000
2.56
0.76
Balanced
Field details

Periods

Period · Text
Period End · Date
Line Items · Link to another table
Links to Line Items
Current Assets · Rollup
sum of CA via Line Items
Total Assets · Rollup
sum of TA via Line Items
Current Liabilities · Rollup
sum of CL via Line Items
Total Liabilities · Rollup
sum of TL via Line Items
Equity · Rollup
sum of EQ via Line Items
Working Capital · Formula
{Current Assets} - {Current Liabilities}
Current Ratio · Formula
IF({Current Liabilities}, ROUND({Current Assets} / {Current Liabilities}, 2), BLANK())
Debt to Equity · Formula
IF({Equity}, ROUND({Total Liabilities} / {Equity}, 2), BLANK())
Balanced? · Formula
IF(ROUND({Total Assets} - {Total Liabilities} - {Equity}, 0) = 0, 'Balanced', 'Out by ' & ({Total Assets} - {Total Liabilities} - {Equity}))

Line Items

Line Item · Text
Period · Link to another table
Links to Periods
Classification · Single select
Current assets, Non-current assets, Current liabilities, Non-current liabilities, Equity
Order · Number
Amount · Currency
INR
CA · Formula
IF({Classification} = 'Current assets', {Amount}, 0)
TA · Formula
IF(OR({Classification} = 'Current assets', {Classification} = 'Non-current assets'), {Amount}, 0)
CL · Formula
IF({Classification} = 'Current liabilities', {Amount}, 0)
TL · Formula
IF(OR({Classification} = 'Current liabilities', {Classification} = 'Non-current liabilities'), {Amount}, 0)
EQ · Formula
IF({Classification} = 'Equity', {Amount}, 0)
Notes · Long text

Classified Balance Sheet: questions

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates