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
Tables
Periods, Line Items
Fields
23
Views
grid, dashboard
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
| Row | Period (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 |
| Row | Line Item (Text) | Period (Link to another table) | Classification (Single select) | Order (Number) | Amount (Currency) | CA (Formula) | TA (Formula) | CL (Formula) | TL (Formula) | EQ (Formula) | Notes (Long text) |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Cash and cash equivalents | H1 FY 2026-27 | Current assets | 1 | ₹1,250,000 | ₹1,250,000 | ₹1,250,000 | ₹0 | ₹0 | ₹0 | |
| 2 | Trade receivables | H1 FY 2026-27 | Current assets | 2 | ₹980,000 | ₹980,000 | ₹980,000 | ₹0 | ₹0 | ₹0 | |
| 3 | Inventories | H1 FY 2026-27 | Current assets | 3 | ₹640,000 | ₹640,000 | ₹640,000 | ₹0 | ₹0 | ₹0 | |
| 4 | Property, plant & equipment | H1 FY 2026-27 | Non-current assets | 1 | ₹3,200,000 | ₹0 | ₹3,200,000 | ₹0 | ₹0 | ₹0 | |
| 5 | Trade payables | H1 FY 2026-27 | Current liabilities | 1 | ₹720,000 | ₹0 | ₹0 | ₹720,000 | ₹720,000 | ₹0 | |
| 6 | Short-term borrowings | H1 FY 2026-27 | Current liabilities | 2 | ₹400,000 | ₹0 | ₹0 | ₹400,000 | ₹400,000 | ₹0 | |
| 7 | Long-term loan | H1 FY 2026-27 | Non-current liabilities | 1 | ₹1,500,000 | ₹0 | ₹0 | ₹0 | ₹1,500,000 | ₹0 | |
| 8 | Share capital & reserves | H1 FY 2026-27 | Equity | 1 | ₹3,450,000 | ₹0 | ₹0 | ₹0 | ₹0 | ₹3,450,000 |
Periods
Line Items
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.
Employees group receipts into expense reports, managers approve them, and the reimbursement due is worked out for you.
2 tables · 25 fieldsInvoice Tracker TemplateTrack invoices from draft to paid with GST totals, partial payments and days overdue, plus outstanding balance per client.
2 tables · 26 fieldsBalance Sheet TemplateList every asset, liability and equity account with this and last period’s balances, and check that the books balance.
1 table · 10 fieldsBusiness Budget TemplatePlan annual budget lines by department, log real expenses against them and see year-to-date variance at a glance.
2 tables · 19 fieldsGrant Budget TemplateBuild funder-ready grant budgets with cost-share, justification and burn rate, and keep unallocated award money in view.
2 tables · 24 fieldsPetty Cash LogRecord every petty cash voucher and top-up with approvals and receipts, and see each cash box’s live balance and top-up alert.
2 tables · 23 fields