Calxa

Mick Devine

Shem Bogusz

All you need to know about using Calxa to build budgets and forecast your cashflow

FP&A - Budgeting and Forecasting

Build budgets and layer them with scenarios

Budgets & Scenarios

Enter budgets values by cell, total column, total row, copy and paste or build budgets with formulas.

Budgets & Scenarios: Edit

Calxa allows you to import budgets directly from an Excel or CSV file.

Budgets & Scenarios: Import

Export your budgets and scenarios to work with your data in external platforms. Easily change your budgets in a spreadsheet and import back to Calxa.

Budgets & Scenarios: Export

The budget factory is a bulk editor that will save you time.

Budget Factory

The Version Managers give an overview of your budgets and scenarios, providing  options for creating, copying and grouping different versions.

Budgets & Scenarios: Manage Versions

Sync your budgets through to Calxa to efficiently share the data across platforms.

Use your Accounting System Budget in Calxa

View and edit your budgets in different layouts displayed by accounts, business units or metrics as monthly, quarterly or annual amounts.

Budgets & Scenarios: Views & Layouts

Balance Sheet Budgeting

Configure the organisation budget to equal the consolidation of your projects or departments.

Organisation Budget (Consolidate Business Units)

Split a single line account budget into multiple parts.

Budgets & Scenarios: Sub-Accounts

Get started with budgets

Metrics Import

Metrics Export

What happens to Budget Comments when I Import or Export my Budget

Budget Comments on Import / Export

Quickly incorporate loans into your budgets

Loan Wizard

Create a point‑in‑time copy of your budget or scenario data that you can restore later if needed

Budgets & Scenarios: Snapshots

Work with your Team on the Budget preparation

Budget Collaboration

A guide to budget for perpetual inventory where your cost of sales and inventory balances are updated as you sell products.

Budget for Inventory (Perpetual Method)

A guide to budget for periodic inventory where your cost of sales is adjusted by a periodic journal based on stock movement.

Budget for Inventory (Periodic Method)

Create Budget Using YTD Actuals and Current Forecast

Build driver-based budgets using budget formulas and Metrics.

Budgets & Scenarios: Formulas

Add comments on budget cells to make notations about your assumptions or to collaborate during budget creation.

Budget Comments

Include the Budget Comments in your Report Bundle

Report on Budget Comments

A common practice when preparing new year's budgets is to compare these new budgets to prior year values.

Budgets Compared to Last Year

Budget for Overdraft Interest

How to Print your Budget

Budget for Government Assistance

Build on your budget with more advanced techniques

Improve your budgets

Import Budgets - File Formats & Options

Budget Tools

Why is the Budget Factory completing but giving Nil values?

Why is my Budget not Exporting?

Calxa's budget import feature requires that the spreadsheet to be imported, adheres to specific formatting.

Why is Budget Import stuck on Verifying Data?

Why are there values missing from my Budget when it says it has imported correctly?

What is the Loan Wizard doing in the Budget?

What does "Your Organisation is being consolidated, so all values are automatic and read-only" mean?

There is a Budget value in the report which is not in the Budget screen?

Import Budget Failed - error message: Business unit does not exist

How do I see all the columns for the year in the budget screen?

How do I make a Payroll Tax Budget Formula?

How do I Import Business Unit Budgets from Excel?

How do I import a second Xero Budget?

How do I export the Budget to Excel as a sheet for each Business Unit?

How do I export my budget to ApprovalMax or Xero

How do I export an Organisation Budget?

How do I edit the budget for one account across multiple business units?

How do I edit an account in the Budget screen that has a + icon

A new Account has been added, how do I add that into the Budget?

Budget is being consolidated, how do I edit it?

How can I change the name of a Budget?

How can I import Annual Amounts into the budget?

Tidy up the Budget Manager by Archiving your old Budget Versions

How can Budget Versions be Archived?

How can I investigate the distribution of amounts in a specific account?

Report the Budget only

If you would like to update your budget and include YTD Actuals

How can I update the Budget with Actuals?

How can I work with two budget versions?

Making Budget Comments and collaborating with your Team

How do I add Comments into my Budget?

How do I consolidate departments and projects to the organisation budget?

How do I copy from one Budget version to another?

How do I create a Budget that sums all the Business Unit Budgets?

Values for the nominated accounts in the Cashflow Forecast Settings are calculated by Calxa

How do I edit a Budget line that is blank and says it is nominated in Cashflow Forecast Settings?

Scenarios are layers you can add to a budget to review how changes may affect the Budget.

What is a Scenario?

A Scenario is an optional extra that can be added to a Budget

What is the difference between a Budget and a Scenario?

Cannot edit the budget screen as there are not any rows in the view. White or Blank screen.

How do I add the rows in a Budget Screen?

Toggle the settings on the P&L Comparison for Budget values for your Business Units, either with or without Actuals.

Can I get a Budget report like the P&L Comparison?

When you open the Budgets & Actuals screen, it opens where you were last working

Budget screen stuck in Metrics View

If you have used the Loan Wizard to create a repayment budget, but terms have changed

How can I make changes to my Loan Wizard Budget Entries?

How do I delete a Formula?

How are budget changes saved and managed in Calxa?

Extending your Budget for the new Financial Year ahead

Budget across multiple Financial Years

Apply a Budget formula across multiple Business Units

Display your Budget to match your Reports using an Account Tree

Using an Account Tree in the Budget Screen

How can I manage formulas in Calxa when copying forecasts, importing spreadsheets, or updating budgets?

How do I mark a comment as resolved?

Including Budget Comments in your Reports

How do I include Budget Comments on Reports

How to review a comment once it has been marked as Resolved

How do I find a Resolved Budget Comment

Reviewing the range of cells that are linked to a Budget Comment

How to identify all cells a Budget Comment references!

Budget FAQs

A quick overview on using budgets and scenarios in Calxa.

Scenarios: Overview

Use preview mode on the scenarios editor to see the result of one or more scenarios combined with a base budget.

Scenarios: Preview Mode

The beginners guide to adding layers to your budgets

Get started with scenarios

Merge Scenario

Build on your existing knowledge to work with scenarios

Improve your scenarios

A guide to help find 'ghost' amounts in the Budgets & Actuals area, if your reports are not balancing with the Budget Screen.

Troubleshooting - Budget Values

Balance your Budget with the Budget Discrepancy Analysis Report

When you get an Error response on attempting to upload your Budgets or Scenarios

Import Budgets & Scenarios - Errors and Troubleshooting

If you need to go back in time and restore an earlier version of your Budget or Scenario

How do I restore a Snapshot

Accounting file sync isn't working

Troubleshoot budgets and scenarios

All you need to know about forecasting cashflow

Forecast cashflow

Prepare your Cashflow Forecast by following this guide

Step-by-Step Guide to Cashflow Forecasting

Create a 3-Way Forecast

Set the default timing in your Cashflow Forecast for receipts and payments on Receivables and Payables.

Cashflow Forecast (Basic Settings)

Configure GST as Cash or Accrual and choose your payment schedule.

GST / VAT

Configure your wages expense and a percentage to withhold for later payment.

Wages & PAYG (PAYE)

Configure your main bank accounts for the opening balance in your cashflow forecast plus other key equity accounts.

Bank & Equity

Configure superannuation accounts to forecast your scheduled liability payments.

Superannuation (Pension Plan)

Get started with cashflow forecasts

Configure cashflow forecast timing with advanced settings applied to individual accounts.

Cashflow Forecast (Advanced Settings)

Create a Custom Schedule for specific timing of receipts or payments in your Cashflow Forecast

Create and Edit a Custom Schedule for Cashflow Forecasting

Where can I access Debtor / Creditor Day Profiles?

Set the calculation method and schedule for forecasting provisional payments of company tax.

Company Tax

Many not-for-profit organisations receive grants for particular projects on a regular basis. These grants may be received in advance of the actual period to which they apply.

Handling Income Received in Advance (such as Grants)

Configure key inventory accounts to ensure the correct cashflow timing is applied to your budgets.

Inventory

How do I manage an account that has taxable and non-taxable transactions?

Settings to assist you with the Cashflow Forecast for Monthly PAYG, when the last month of a Quarter is paid with your Quarterly BAS.

How do I set up the Cashflow Forecast for PAYG Monthly / BAS Quarterly?

Cashflow Forecast settings for Weekly PAYG Withholding payments

Is there a way to do Weekly PAYGW in the Cashflow Forecast settings?

For those who need to manage complex cashflow situations

Improve your cashflow forecast

Help to ensure your Cashflow Forecast is as accurate as possible.

Understanding and Troubleshooting Cashflow Forecast

Creditor and Debtor Calculations

How do I correct the Opening Bank Balance?

Cashflow Forecast timing settings for deferred payment arrangements

How do I fine tune Cashflow forecast for a Deferred Payment arrangement?

Why does Opening Bank Balance report as Nil?

In the General Settings you can record an Overdraft arrangement

What does the Overdraft setting do?

Settings to manage the Cashflow Forecast of Annual Expense payments

How do I manage Annual expenses for Cashflow Forecast in Calxa?

Exclude depreciation expense from your cashflow and automate a corresponding balance sheet budget.

Depreciation

Bringing the sale of an Asset into your Cashflow forecast.

Why is my Asset realisation not being reflected in the Cashflow Forecast?

How to identify which GL accounts are coded as Accounts Receivable / Trade Debtors for Cashflow forecasting purposes

Which GL Codes are included in the Debtors calculation?

Troubleshoot cashflow reports

Why is the Retained Earnings figure not correct?

In the UK, NI can be managed simply with a few steps

How to budget for Employer's National Insurance (NI)

Manage prepayments and accruals to keep your cashflow forecast accurate

How to budget for Prepayments and Accruals

Understanding Equity Discrepancies in Calxa's Balance Sheets

Cashflow Settings FAQs

To prepare a Cashflow Statement, categorise accounts as Operating, Investing, Financing or Non-Cash.

Cashflow Statement

Present a Direct or Indirect Cashflow Statement and use an Account Tree to summarise.

Present Cashflow Statement Report

For those who need a traditional accounting report on cashflow

Collections