Skip to main content

Budget reports: summary, budget vs actual, performance by month

Three reports turn your budget into something you can print or send to the board.

M
Written by Michael Bollinger

Three reports turn your budget into something you can print or send to the board. Budget Summary shows the budget on its own, the numbers the board approved. Budget vs Actual Summary puts the budget next to what really came in and went out over a period. Budget Performance by Month shows one month against its budget, with year-to-date totals beside it.

Before you start: you need Reports access. Picking dates, exporting, scheduling and adding a report to a packet work the same as on every report. See Run, filter, export and favorite a report. The reports read your live budget, not drafts. To set up or change the budget, see Budgets overview.

All three are in the Business Overview Reports section of Reports.

Report

Opens on

Filters

Use it when

Budget Summary

This FY

Starting date / Ending date, Report mode, Hide $0.00 balances

You need a clean copy of the approved budget.

Budget vs Actual Summary

This month

Starting date / Ending date, Separate budget / actual ranges, Hide $0.00 balances

The board asks "are we on budget?" for a month, a quarter or the year so far.

Budget Performance by Month

The current month

Month, Year, Year-to-date basis, Hide $0.00 balances (off by default)

You report monthly and want the month and the year to date on one page.

Click any category on these reports to open its Account Register for the same dates and see the entries behind the actual.

Tip: The Budget Overview page under Budgets shows the same comparison with cards and charts, and lets you click into a category's transactions. These reports are the printable version. See Compare the budget to actuals.

Budget Summary

The budget alone, by category, for the dates you pick. Nothing actual is on it.

  1. On Reports, click Budget Summary.

  2. Pick the range. It opens on This FY, your fiscal year.

  3. Choose a Report mode:

    • Summary — one Total per category for the whole range.

    • Yearly — one column per calendar year in the range, then Total.

    • Monthly — one column per month (for example Jan '26), then Total.

  4. Keep Hide $0.00 balances on to leave out categories with no budget. Turn it off to list every category.

  5. Click Show results. Changing the mode reruns the report.

The report lists Income categories with subcategories under their parent and a Total for line for each parent, then Total Income, then Expenses and Total Expenses, then Net Total (budgeted income minus budgeted expenses). The first column is Category.

  • Counts: the amount in your live budget for each month in the range. Months are whole months: a range from the 15th still takes that month's full budget.

  • Leaves out: drafts, and categories you've deleted from the chart of accounts.

In a report packet, the same report is offered as Budget Summary, Budget - Monthly and Budget - Yearly. See Report packets.

Budget vs Actual Summary

Budget, actual and the difference for each category, over one period.

  1. On Reports, click Budget vs Actual Summary.

  2. Pick the range with Starting date and Ending date. It opens on This month.

  3. Click Show results.

The columns are Category, Budget, Actual and Variance, in Income, Total Income, Expenses, Total Expenses and Net Total sections.

Hide $0.00 balances leaves out categories with no budget and no actual in the range.

Compare different budget and actual periods

Turn on Separate budget / actual ranges to compare, for example, the full-year budget against actuals so far.

  1. Turn on Separate budget / actual ranges.

  2. Under Budget date range, set the months of budget to use.

  3. Under Actual date range, set the dates for the actuals.

  4. Click Show results.

The Budget and Actual column headings change to the two date ranges, and the subtitle reads Budget: … / Actual: ….

Budget Performance by Month

One month's budget and actual, the year to date, and the full year's budget.

  1. On Reports, click Budget Performance by Month.

  2. Pick the Month and Year.

  3. If your fiscal year doesn't start in January, choose the Year-to-date basis: Fiscal year (the default; the page shows Current fiscal year: with its dates) or Calendar year. Associations with a January fiscal year don't see this choice.

  4. Click Show results.

Column

What it is

Category

Income and expense categories, with subcategories under their parent

Month Budget / Month Actual / Month Variance

The month you picked

YTD Budget / YTD Actual / YTD Variance

From the start of the fiscal or calendar year through the end of that month

Year Budget

The whole fiscal or calendar year's budget

If nothing matches you'll see No results found and No data matched the selected filters. Adjust the month, year, or basis and try again.

How to read the variance

On every budget report, a positive Variance is good news and a negative one is bad news:

Variance is

Example

Income

Actual minus Budget

Budget $250.00, actual $200.00 → -$50.00: you took in $50 less than planned.

Expenses

Budget minus Actual

Budget $1,000.00, actual $1,200.00 → -$200.00: you spent $200 more than planned.

Net Total

Actual net minus budgeted net

Negative means your surplus came in lower than planned.

So income under budget and spending over budget both show as negative numbers.

Which column shows how much budget is left? Is there a Balance column? What's left to spend on an expense line is its Variance: budget minus actual. None of the three budget reports has a Balance column. To see what's left of the full year's budget, run Budget vs Actual Summary with Separate budget / actual ranges turned on, the whole year under Budget date range and the year so far under Actual date range.

The Balance column you see after clicking a category is on the Account Register that opens, and it means something else. It's a running total of the entries listed: it starts at $0.00 on the report's first day and goes up with each expense, so it shows what has been spent so far, not what remains. Spending isn't subtracted from the budget there, because the register doesn't know the budget. If that register's first row reads Starting balance for category … and the running total starts from that amount, an amount was typed as the category's Starting balance in the chart of accounts. A starting balance is for actual spending from before you used PayHOA and counts as actual on your reports, so it isn't the place for a budget figure. To remove it, go to Budgets → Chart of accounts, click the category, change Starting balance to 0 and click Save changes. See Add, edit, nest, delete and restore categories.

What "actual" counts

Actuals follow the same rules as the profit and loss reports, on your association's basis (cash or accrual). See Profit and loss reports and Cash vs accrual, and the fiscal year.

Counts

Doesn't count

Approved, categorized bank transactions in an income or expense category

Transactions still on For review, uncategorized and excluded transactions

Journal entries to an income or expense category

Transfers between your own accounts, including reserve contributions recorded as transfers

Payables (bills), once

Money moved between balance-sheet accounts

Owner invoices (accrual) or owner payments as they reach the bank (cash), once

Deleted invoices, and payments that failed or were returned

  • Reserve contributions. A transfer to your reserve account is never an expense, so it won't show against a "Reserve contribution" budget line. To show reserve contributions as an actual, record the transfer and then post a journal entry that debits a Reserve contribution expense category and credits a reserve equity account. See Showing reserve contributions on your budget.

  • Income invoiced and then paid counts once: on accrual by the invoice date, on cash when the payment reaches the bank.

  • Deleted transactions, payments and payables don't count, but you'll still see them in the register. If you delete a duplicate, for example a payable payment you entered by hand after the bank's copy was matched, Actual on Budget vs Actual Summary no longer includes it. The Account Register that opens when you click the category still lists the deleted item, followed by a line that starts Reverse: for the same amount on the same date. The two net to zero, and Actual is the total after both. To check, compare Actual with the Total for line at the bottom of that register. If a deleted item has no Reverse: line, or Actual still includes it, contact PayHOA's accounting support (accounting@payhoa.com or 859-249-8828) with the category, the dates and the item's amount. See Deleted and changed items on the ledger.

  • Deleted categories that still have a budget or actuals in the range stay on Budget vs Actual Summary and Budget Performance by Month so the totals add up. Budget Summary leaves them out.

  • Cash basis: the Prepayments line. On cash basis, the budget vs actual reports can show a Prepayments line under Income: money owners paid with no open invoice to apply it to, so it has no income category yet. It has no budget, so its variance equals the amount. It moves into the right category when the credit is applied to an invoice. To see which units it belongs to, run Prepayments by Unit. See Payment reports and Reports: common questions.

On the older accounting system: the same line is called Uncategorized Account Credits. On accrual basis, a bank deposit in an income category counts as actual income only if the transaction is marked Outside Revenue. Hide $0.00 balances has no effect on Budget vs Actual Summary. See Accounting V2 and V1: what changes in your reports and chart.

Troubleshooting

Problem

What to do

The report shows no budget

Your live budget has no amounts for those months. Check Budgets → View current budget. A draft doesn't count until it's published. See Edit, publish and archive drafts, and edit the live budget.

Income looks double-counted

Check that a deposit wasn't categorized to income on top of the owner payments it contains. See Link owner payments to deposits. If income went up or doubled after you linked payments to deposits, see My income went up (or doubled) after I linked payments to deposits.

A transfer shows as income or expense

It was recorded as a categorized transaction, not a transfer. See Record transfers between accounts.

Actual lands in the wrong month

On accrual, owner income is dated by the invoice; on cash, by the bank deposit. A payment made on the 30th and deposited on the 2nd counts in the next month on cash.

An actual doesn't match the bank

Run Profit vs Loss Detail for the same dates and check the category. See Profit and loss reports.

Actual is too high for an expense category, or voided bills seem to be counted

Click the category to open its Account Register and look for bills that shouldn't be there. On accrual basis a bill whose payment you voided is still a confirmed, unpaid bill, so its expense still counts in Actual until you delete the payable: on Payables → Unpaid, click ⋯ → Delete. A bill entered twice, or a payable plus the bank's copy of the same payment categorized as an expense, also counts twice. See Voids and deletes and Avoid counting the expense twice.

The variance sign looks backwards

It isn't: negative always means worse than budget. See "How to read the variance" above.

For other messages, see the troubleshooting table in Run, filter, export and favorite a report.

What's next

Did this answer your question?