IN THIS SECTION

• Overview
  • Joiin Budgets
  • External Budgets
• Viewing Budgets
  • Filtering
    • Clearing Filters
  • Column Sorting and Ordering
    • Sorting
    • Selecting Columns
    • Changing Column Order
    • Resetting to Default
  • Enabling/Disabling Budgets
    • Bulk Enable/Disable
  • FX Treatment
  • Other Budget Actions
• Reporting on Budget/Forecast vs Actual
  • Options
  • Seeing the underlying budget values
  • By Category Budgets
  • Year to Date

Overview

You can view Budgets in Joiin and compare them to Actual values and see Variance and Varance %.  Budgets are automatically imported from Xero or QuickBooks.  You can also create your own Budgets directly in Joiin using manual budget creation.

Budgets and forecasts are different. A budget is made up of figures you enter manually - pulled in from Xero or QuickBooks, or typed into Joiin yourself. A forecast generates its figures automatically from your recent actuals using rules, patterns and/or AI, and spans all three financial statements at once. Both live under Budgets & Forecasting and can be reported against actuals the same way. See the Forecasting article for more information on Forecasts.

Joiin Budgets

Joiin Budgets are budgets that have been manually created or imported into Joiin. Joiin budgets can be used for creating consolidated budgets. See Creating a Budget section for more information on this.  

External Budgets

External Budgets are budgets that have been automatically imported from your Xero or QuickBooks companies.  These budgets will be refreshed whenever your main company data is refreshed.  

Budgets are imported in 12-monthly chunks.  Each 12 month period will be aligned with the Start Date you have set on your Company config.  By default the Start Date is January but you can change this if your financial year starts in a different month. See our Managing Companies article for more information on how to change.

A QuickBooks Budget which is broken down by Class will be imported in Joiin as a separate Budget for each Class.

NOTE: A maximum of 100 budgets will be imported from Xero or QuickBooks.

More information on Xero Budgets.

More information on QuickBooks Budgets.

Viewing Budgets

You can view a list of budgets, either imported from Xero/QuickBooks or created by you, by selecting Budgets from the left menu.

The Budgets page shows all budgets from your source entities (Xero or QuickBooks) along with Joiin budgets you have created. You can search, filter, sort and perform actions on budgets from this page.

Filtering

The top section of the page contains a number of filters which allow you to narrow down the results.

Clearing Filters

Click on the Clear Filters icon at the top to reset all filters, columns and sort order to their default settings.

Column Sorting and Ordering

Sorting

You can click on the column heading to sort the results by that criteria. The initial click will sort ascending and an up arrow will be displayed in the column heading, e.g.

Click again to sort descending - the direction of the arrow will change:

Selecting Columns

You can choose which columns to display when viewing results. To do this

• Click on the cog icon at the top right
• Check/Uncheck the columns you wish to see/hide
• Click on Apply button to apply the changes

Changing Column Order

You can change the order in which columns are displayed when viewing results. To do this

• Click on the cog icon at the top right
• Click and hold the three-bar icon at the left of the column name and drag/drop it into the place required.
• Click on Apply button to apply the changes

Resetting to Default

You can reset the columns and sorting to the default values. To do this

• Click on the cog icon at the top right
• Click on Reset button

NOTE: Any changes you make to the filter, columns and sort order will be saved in your browser for the next time you visit the page.

Enabling/Disabling Budgets

You can control which budgets are used when running reports by enabling or disabling them. This can be helpful if you have numerous budgets covering different scenarios.

To enable or disable a budget simply click on the toggle to the left of the budget.

Bulk Enable/Disable

You can enable or disable multiple budgets in one go by clicking on the Status column heading and selecting Enable all or Disable all. This will act on only the budgets that are being displayed based on the selected filters - so this is helpful when used in tandem with the filtering capabilities

FX Treatment

You can modify the way FX is treated, using the Edit FX Treatment option, from the three-dot menu. 

By default, budget FX values are converted using the same FX rates and conversion method as actuals (based on your P&L and Balance Sheet conversion type settings). This is the Variable FX treatment. Alternatively, FX treatment can be set to Fixed, to fix the budget FX rates to a specific date.

Other Budget Actions

You can Download a budget by selecting Download from the three-dot menu to the right.

You can edit a budget by clicking on the budget name or selecting Edit from the three-dot menu.

You can remove a budget by selecting Remove from the three-dot menu.

Reporting on Budget/Forecast vs Actual

You can report on Budget/Forecast vs Actual when running a report by switching the Budget/Forecast toggle on - see this section for more information on running reports.  The Budget toggle is available on all financial reports apart from the Trial Balance report.

Options

Click on Apply changes and the budget information will be displayed.

If you have chosen to show variance columns, those columns highlight the difference between the budget amount and the actual amount. The arrow icons show whether the variance is an increase (up arrow) or decrease (down arrow), and whether it’s favourable (green) or unfavourable (red).

NOTE: You can control how the favourability is displayed by changing the Budget Favourability setting on Custom Layouts - for more information see this article.

Seeing the underlying budget values

Hovering over the value with your mouse will bring up more details of the individual budgets/months that the budget information came from.  

NOTE In Compact View budget info is shown in the same column as the Actual.

The budget information used is taken from all the budgets that were select to reported on and for the relevant period and companies that have been selected for this report run.  If there is more than one budget or the report period spans multiple months then the individual budget amounts for each budget/month will be displayed when you hover over the amount - the individual amounts will be summed up to get the total budget amount displayed on screen.

By Category Budgets

When running a report By Category, only Budgets with a Category option will be included. Non-category budgets will not be included as it is not possible to work out the split across the categories in this case. When not reporting by category both Category and non-category budgets will be included. The total across all the categories will be summed up to get the total budget value.

It is therefore recommended that, if you have budget figures at the Category level, then enter them at that level and Joiin will sum them up for you when running an overall (not-by-category) report.

Year to Date

NOTE If you are reporting on Year-to-date figures across multiple companies with differing year ends, the budgets figures are calculated as follows.

For Company-specific budgets, the Fiscal Year start month of each company will be taken as the Start month for the YTD budget figure.

For non-Company-specific budgets, the Fiscal Year start month will be taken as the Fiscal Year start of the first company in the list of companies being reported on. This is because, for an overall budget, there is no way to know which portion of a budget is allocated to which company.