All guides
Guide · Financials – G/L

Budgets and financial statements

Setting a budget by account and period, filling next year's budget from this year's, and the statements and custom layouts that compare them with what happened.

3 min read

Watch it done: Reports your way

A budget is a figure for each account in each period of the fiscal year. BeanDish keeps it beside your actual figures, so any statement can show the two side by side.

Setting a budget

Open Financials – G/L › Chart of Accounts and open an account. Its Budget tab holds a figure for every period of the fiscal year, the year-end adjustment period included. Type the figures and click Save budget.

Filling a whole year at once

Open Budgets. Choose the year to copy from and the year to fill, and base the new budget on that year's actual figures or its budget, with a percentage change — this year's plus five percent, say. Choose income and expense accounts or all accounts, and whether to include the adjustment period.

Click Preview: nothing is written yet. Check each account's source figure, new budget and change, then click Apply. Applying overwrites any budget already set for those periods.

The statements

Open Financials – G/L › Reports, choose a statement and its dates, and click Preview.

  • If your chart groups accounts under parent accounts, each group shows its total. Set Group level to 1 to see only the parents.
  • Narrow a statement to one project, or to a range of accounts.
  • The Balance Sheet shows balances as of the ending date, with net income not yet closed in equity. The Trial Balance lists every account's debit or credit balance.
  • Print a statement, or export it to PDF or Excel.

Budget against actual

Choose Account Budget vs Actual, a fiscal year, and a period or the whole year. Each account shows its budget, its actual figure and the variance.

Your own layout

When the standard statements don't fit, build your own. Click Custom statements › New layout, start from a template or a blank page, and set its sections, rows and columns — actual, budget, change, and percent of a line such as revenue. Preview it, click Create layout, then choose a period and click Run. Click an account on the result to open it.

See every step

The video above shows reports more broadly, including a custom profit and loss. The tutorial below goes step by step through a budget filled from this year's figures, the main statements, Budget vs Actual and a custom statement. The same tutorial is in BeanDish under Learn › Tutorials.

Budgets and financial statements, step by step

An account’s budget, next year’s budget filled from this year’s plus five percent, the Profit and Loss with its parent-account totals, the Balance Sheet and Trial Balance, Account Budget vs Actual, and a custom statement with budget, variance and percent-of-revenue columns. (4:33)