Balance Sheet Template

List every asset, liability and equity account with this and last period’s balances, and check that the books balance.

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

Accounts

Fields

10

Views

grid, dashboard

Tables, columns and sample rows

The table in this template, with its real columns, field types and sample rows. Copy the template to edit it in Edesy Tables.

Accounts

10 fields · 8 sample rows

  • Balance sheet (Grid)
  • Summary (Dashboard)
AccountTextSectionSingle selectSub-typeSingle selectThis PeriodCurrencyLast PeriodCurrencyChangeFormulaChange %FormulaBalance CheckFormulaAs OfDateNotesLong text
Cash & bankAssetsCurrent₹8,20,000₹6,40,000₹1,80,00028.1%₹8,20,00019 Nov 2026
Accounts receivableAssetsCurrent₹4,50,000₹5,10,000₹-60,000-11.8%₹4,50,00019 Nov 2026
InventoryAssetsCurrent₹3,80,000₹3,00,000₹80,00026.7%₹3,80,00019 Nov 2026
Equipment (net of depreciation)AssetsNon-current₹11,50,000₹12,20,000₹-70,000-5.7%₹11,50,00019 Nov 2026
Accounts payableLiabilitiesCurrent₹2,90,000₹3,40,000₹-50,000-14.7%₹-2,90,00019 Nov 2026
GST payableLiabilitiesCurrent₹85,000₹70,000₹15,00021.4%₹-85,00019 Nov 2026
Term loan – HDFC BankLiabilitiesNon-current₹9,00,000₹10,00,000₹-1,00,000-10.0%₹-9,00,00019 Nov 2026₹1 L principal repaid this period.
Owner’s capital & retained earningsEquityOwner’s equity₹15,25,000₹12,60,000₹2,65,00021.0%₹-15,25,00019 Nov 2026
Field details
Account · Text
Section · Single select
Assets, Liabilities, Equity
Sub-type · Single select
Current, Non-current, Owner’s equity
This Period · Currency
INR
Last Period · Currency
INR
Change · Formula
{This Period} - {Last Period}
Change % · Formula
IF({Last Period}, ({This Period} - {Last Period}) / {Last Period}, BLANK())
Balance Check · Formula
IF({Section} = 'Assets', {This Period}, -{This Period})
As Of · Date
Notes · Long text

Balance Sheet Template: 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