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
Tables
Accounts
Fields
10
Views
grid, dashboard
The table in this template, with its real columns, field types and sample rows. Copy the template to edit it in Edesy Tables.
10 fields · 8 sample rows
| AccountText | SectionSingle select | Sub-typeSingle select | This PeriodCurrency | Last PeriodCurrency | ChangeFormula | Change %Formula | Balance CheckFormula | As OfDate | NotesLong text |
|---|---|---|---|---|---|---|---|---|---|
| Cash & bank | Assets | Current | ₹8,20,000 | ₹6,40,000 | ₹1,80,000 | 28.1% | ₹8,20,000 | 19 Nov 2026 | |
| Accounts receivable | Assets | Current | ₹4,50,000 | ₹5,10,000 | ₹-60,000 | -11.8% | ₹4,50,000 | 19 Nov 2026 | |
| Inventory | Assets | Current | ₹3,80,000 | ₹3,00,000 | ₹80,000 | 26.7% | ₹3,80,000 | 19 Nov 2026 | |
| Equipment (net of depreciation) | Assets | Non-current | ₹11,50,000 | ₹12,20,000 | ₹-70,000 | -5.7% | ₹11,50,000 | 19 Nov 2026 | |
| Accounts payable | Liabilities | Current | ₹2,90,000 | ₹3,40,000 | ₹-50,000 | -14.7% | ₹-2,90,000 | 19 Nov 2026 | |
| GST payable | Liabilities | Current | ₹85,000 | ₹70,000 | ₹15,000 | 21.4% | ₹-85,000 | 19 Nov 2026 | |
| Term loan – HDFC Bank | Liabilities | Non-current | ₹9,00,000 | ₹10,00,000 | ₹-1,00,000 | -10.0% | ₹-9,00,000 | 19 Nov 2026 | ₹1 L principal repaid this period. |
| Owner’s capital & retained earnings | Equity | Owner’s equity | ₹15,25,000 | ₹12,60,000 | ₹2,65,000 | 21.0% | ₹-15,25,000 | 19 Nov 2026 |
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 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 fieldsClassified Balance SheetClassify accounts into current and non-current groups and get working capital, current ratio and debt-to-equity per period automatically.
2 tables · 23 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