Skip to content

Manage Budgets

Manage Budgets

Create budgets, track spending, and compare actual vs planned expenses.

Time: 15–30 minutes per budget Module: Account Budget Permissions: Accountant or Budget Manager


Prerequisites

  • Chart of accounts configured
  • Analytic accounts defined
  • Budget positions created
  • Access to Accounting menu

Overview

The Budget Management system enables:

  • Budget creation and tracking
  • Department-wise budgeting
  • Budget position definitions
  • Actual vs planned analysis
  • Variance reporting
  • Multi-period budgets
  • Budget alerts

Budget Structure

Budget
└── Budget Lines
├── Budget Position (Accounts)
├── Analytic Account (Cost Center)
├── Period (Date Range)
└── Planned Amount
ComponentDescription
BudgetOverall budget document
Budget PositionGroup of GL accounts
Budget LineIndividual budget allocation
Analytic AccountDepartment/cost center

Steps

1. Create Budget Positions

Define account groups for budgeting:

  1. Navigate to Accounting → Configuration → Budget Positions
  2. Click New
  3. Configure position:
FieldAction
NamePosition name
AccountsSelect GL accounts
CompanySelect company
  1. Click Save

Common Positions:

  • Salary Expenses
  • Operating Expenses
  • Marketing Costs
  • Travel Expenses
  • Equipment Purchases
  • Training Costs

2. Create Budget

  1. Navigate to Accounting → Budgets → Budgets
  2. Click New
  3. Configure budget:
FieldAction
Budget NameDescriptive name
ResponsibleBudget owner
Start DateBudget period start
End DateBudget period end
CompanySelect company
  1. Click Save

3. Add Budget Lines

Define allocations:

  1. Open budget record
  2. Navigate to Budget Lines tab
  3. Click Add a line
  4. For each allocation:
FieldAction
Budget PositionSelect position
Analytic AccountCost center
Start DateLine period start
End DateLine period end
Planned AmountBudget amount
  1. Add all lines
  2. Click Save

4. Confirm Budget

Activate the budget:

  1. Review all lines
  2. Verify totals
  3. Click Confirm
  4. Budget becomes active
StateDescription
DraftBeing created
ConfirmedActive budget
RevisedUnder revision
DonePeriod completed

5. Monitor Budget Usage

Track spending:

  1. Open budget

  2. View lines with:

    • Planned Amount
    • Practical Amount (Actual)
    • Theoretical Amount
    • Percentage used
  3. Identify variances

6. Analyze Variances

Compare planned vs actual:

  1. Navigate to Accounting → Reporting → Budget Analysis
  2. Set parameters:
FieldAction
BudgetSelect budget
PeriodDate range
AnalyticFilter by dept
  1. Generate report
  2. Review variances

7. Revise Budget

If adjustments needed:

  1. Open budget
  2. Click Set to Draft
  3. Modify lines
  4. Re-confirm

Field Reference

Budget Position (account.budget.post)

FieldTechnical NameTypeRequiredDescription
NamenameCharYesPosition name
Accountsaccount_idsMany2manyNoGL accounts
Companycompany_idMany2oneYesCompany

Budget (crossovered.budget)

FieldTechnical NameTypeRequiredDescription
Budget NamenameCharYesBudget name
Responsibleuser_idMany2oneNoOwner
Start Datedate_fromDateYesPeriod start
End Datedate_toDateYesPeriod end
StatestateSelectionYesBudget status
Budget Linescrossovered_budget_lineOne2manyNoAllocations
Companycompany_idMany2oneYesCompany

Budget Line (crossovered.budget.lines)

FieldTechnical NameTypeRequiredDescription
Budgetcrossovered_budget_idMany2oneYesParent budget
Budget Positiongeneral_budget_idMany2oneNoAccount group
Analytic Accountanalytic_account_idMany2oneNoCost center
Analytic Plananalytic_plan_idMany2oneNoPlan
Start Datedate_fromDateYesLine start
End Datedate_toDateYesLine end
Paid Datepaid_dateDateNoPayment date
Planned Amountplanned_amountMonetaryYesBudget amount
Currencycurrency_idMany2oneNoCurrency

Educational Budget Example

Annual Operating Budget

Budget: FY 2024 Operating Budget
Period: Jan 1 - Dec 31, 2024
Department: Computer Science
├── Faculty Salaries: $500,000
├── Lab Equipment: $50,000
├── Software Licenses: $20,000
├── Research Grants: $30,000
└── Travel: $10,000
Total: $610,000
Department: Library
├── Staff Salaries: $200,000
├── Book Acquisitions: $100,000
├── Digital Resources: $50,000
└── Maintenance: $20,000
Total: $370,000

Capital Budget

Budget: Capital Expenditure 2024
Period: Jan 1 - Dec 31, 2024
├── New Lab Building: $2,000,000
├── IT Infrastructure: $500,000
├── Sports Facility: $300,000
└── Transportation: $200,000
Total: $3,000,000

Views Available

ViewFeatures
ListAll budgets
FormBudget details
PivotAnalysis table
GraphVisual charts

Budget Dashboard

Shows:

  • Total budgets
  • Budget utilization
  • Over-budget alerts
  • Department comparison

Reports

ReportDescription
Budget AnalysisPlanned vs actual
Variance ReportDifferences
Department SummaryBy cost center
Period ComparisonMonth/quarter trends

Troubleshooting

IssueCauseSolution
No actual dataNo transactionsPost journal entries
Wrong varianceDate mismatchAlign periods
Cannot modifyBudget confirmedSet to draft
Missing positionNot createdCreate budget position
Zero practicalWrong analyticCheck analytic account

Best Practices

  1. Realistic planning: Base on historical data
  2. Regular monitoring: Review monthly
  3. Variance analysis: Investigate deviations
  4. Timely updates: Revise when needed
  5. Department involvement: Include stakeholders
  6. Documentation: Note assumptions

Security Notes

RoleCapabilities
Budget ManagerFull CRUD
AccountantCreate and monitor
Department HeadView own department
AuditorView all budgets