Company Budget Template

Give each department an annual budget, log approved expenses against it and watch spend, remaining balance and quarterly burn update live.

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

Budget Sheets

Tables

Departments, Expenses

Fields

19

Views

grid, dashboard, form

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.

Departments

8 fields · 5 sample rows

  • Budgets (Grid)
  • Overview (Dashboard)
DepartmentTextBudget ownerTextAnnual budgetCurrencyExpensesLink to another tableSpentRollupRemainingFormula% usedFormulaExpense countCount
EngineeringArjun Rao₹48,00,000AWS hosting — October, Contract QA engineer₹3,31,000₹44,69,0007%2
MarketingClaire Dubois₹25,00,000Google Ads — Diwali campaign₹3,20,000₹21,80,00013%1
SalesNeha Kapoor₹18,00,000Trade show booth, Bengaluru₹2,10,000₹15,90,00012%1
OperationsSanjay Patil₹12,00,000Co-working seats (12)₹1,56,000₹10,44,00013%1
People & HRFatima Sheikh₹9,00,000Leadership workshop₹85,000₹8,15,0009%1
Field details
Department · Text
Budget owner · Text
Annual budget · Currency
INR
Expenses · Link to another table
Links to Expenses
Spent · Rollup
sum of Amount via Expenses
Remaining · Formula
{Annual budget} - {Spent}
% used · Formula
IF({Annual budget}, {Spent} / {Annual budget}, BLANK())
Expense count · Count

Expenses

11 fields · 6 sample rows

  • All expenses (Grid)
  • Awaiting approval (Grid)
  • Submit an expense (Form)
  • Spend analysis (Dashboard)
ExpenseTextDepartmentLink to another tableCategorySingle selectVendorTextDateDateAmountCurrencyPayment methodSingle selectApprovedCheckboxQuarterFormulaReceiptAttachmentNotesLong text
AWS hosting — OctoberEngineeringSoftware & SaaSAmazon Web Services30 Oct 2026₹1,86,000Credit cardYesQ4 2026
Contract QA engineerEngineeringSalaries & contractorsTestCraft LLP7 Nov 2026₹1,45,000Bank transferYesQ4 2026
Google Ads — Diwali campaignMarketingAdvertisingGoogle India25 Oct 2026₹3,20,000Credit cardYesQ4 2026
Trade show booth, BengaluruSalesTravelExpo Partners11 Nov 2026₹2,10,000Bank transferQ4 2026
Co-working seats (12)OperationsOffice & facilitiesWeWork4 Nov 2026₹1,56,000Bank transferYesQ4 2026
Leadership workshopPeople & HRTrainingMindset Academy16 Nov 2026₹85,000UPIQ4 2026
Field details
Expense · Text
Department · Link to another table
Links to Departments
Category · Single select
Salaries & contractors, Software & SaaS, Advertising, Travel, Office & facilities, Equipment, Professional fees, Training
Vendor · Text
Date · Date
Amount · Currency
INR
Payment method · Single select
UPI, Credit card, Debit card, Bank transfer, Cash, Cheque
Approved · Checkbox
Quarter · Formula
IF({Date}, CONCAT('Q', ROUNDUP(MONTH({Date}) / 3, 0), ' ', YEAR({Date})), '')
Receipt · Attachment
Notes · Long text

Form view “Submit an expense” asks for: Expense, Department, Category, Vendor, Date, Amount, Payment method, Receipt, Notes.

Company Budget 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