The Balance Sheet report provides a snapshot of your organization’s financial position as of a specific date.
It shows:
Assets
Liabilities
Equity
This report helps you understand what your organization owns, owes, and its overall net worth at a given point in time.
You can change the date using the date selector or use the predefined date ranges.
By default, the balance sheet will display values in your organization's base currency.
You can change the display currency of the balance sheet to other currencies that have been set up in your organization. For more information about setting up other currencies, refer to Accounting.
At the bottom of the page, click on See All Rates.
You will be shown a list of all exchange rates used to convert foreign currency transactions back to the organization's base currency.
Other information include the date of the exchange rate, as well as the rate type.
Yes, you can download the report in Excel or PDF formats.
See below for an example of the downloaded file.
Yes, enable Print Report Notes in Reports → Balance Sheet → Configuration Icon → Display Options to add and format notes below the report. These notes will be included in the exported report.
Yes. You can click the Chart icon to open a visual chart view of your Balance Sheet.
The chart allows you to view trends over multiple periods and switch between:
Assets
Liabilities
Equity
Cash and Cash Equivalents
Net Working Capital
Ratios, such as:
Current Ratio
Liabilities-to-Assets
Equity Ratio
Note: The chart categories and labels are based on your selected report template.
Yes. In the chart view, click the “Periods” link to open the Compare Periods settings.
You can:
Compare with previous months
Select the number of months to display
Adjust the display order
The chart will update automatically based on your selection.
Yes, enable Print Exchange Rates in Reports → Balance Sheet → Configuration Icon → Display Options to display them below the report. They will also appear in the exported report.
Yes, enable Print Rounded Values in Reports → Balance Sheet → Configuration Icon → Display Options to round all values to whole numbers. This also applies to the exported report.
At your financial year-end, the system dynamically calculates and rolls over the CYE amount to your Retained Earnings account. Any changes to transactions or your financial year-end will automatically update the rolled-over balances.
What-If runs a simulation of your Balance Sheet using assumptions you set, without changing any recorded transactions.
Go to Reports → Balance Sheet → Configuration Icon → What-If Options.
The simulation is preview only. Your actual account balances are never modified.
Financial Year: simulate custom financial year dates to view your financial position over an irregular reporting period.
Profitability Drivers: apply a percentage adjustment to revenue or expense variables to see how your position would respond.
Combined: apply a custom financial year and profitability drivers in the same simulation.
Each driver is built from three fields:
Scope: the level the adjustment applies to, either Account Type, Nature, or Account.
Target: the item being adjusted. Available targets depend on the scope selected. For Account Type, these are Direct Costs, Operating Expense, Operating Revenue, Other Expense, and Other Revenue.
Percentage: the adjustment applied to the target. Entering 20% multiplies the target by 1.20.
The Percentage field accepts values from -100 to 500:
Positive values increase the target. Entering 30% multiplies the target by 1.30.
Negative values decrease the target. Entering -25% multiplies the target by 0.75.
Entering -100% removes the target from the simulation entirely.
Values outside this range are rejected, and the simulation cannot be run until the entry is corrected.
Click + Add Driver to apply more than one adjustment in the same simulation.
Each scope and target combination can only be used once. Adding a second driver for the same combination returns a duplicate error, and the simulation cannot be run until one of the drivers is changed or removed.
When drivers overlap across different scopes, the more specific scope takes priority: Account overrides Nature, and Nature overrides Account Type.
The Effective Variables panel shows the final multiplier applied to each scope before you run the simulation. If a driver is invalid, the panel displays the error instead of the multiplier.
Here are some example cases where What-If is helpful:
Checking whether you would still meet a loan covenant: apply the cost or revenue change you expect, then review the Current Ratio, Liabilities-to-Assets, and Equity Ratio in the chart view to see whether your position still satisfies the terms of your loan.
Testing the effect on net worth before taking on new commitments: apply the expected increase to the operating costs a new commitment would add, then review how much equity remains once the result rolls into Retained Earnings.
Reviewing your working capital position under pressure: set Operating Revenue to a negative percentage to see how Net Working Capital holds up if collections fall short of expectations.
Modeling one account without disturbing the rest: set Scope to Account and select a specific account, such as rent or salaries, to see its effect on your position without inflating the rest of its account type.
Splitting earnings across a different year end: your Retained Earnings balance depends on where the financial year closes. Simulate an alternative year end to see how much profit would sit in Retained Earnings and how much would remain as current year earnings.
Presenting your position at a date other than your year end: if you are asked for a statement of financial position as of a different closing date, simulate that financial year to produce it without re-cutting your books.
Yes, you can export the simulated report in Excel and PDF formats.
The exported file includes a note identifying the figures as the result of a What-If simulation and the report title has “(Illustration)”, so they are not mistaken for actual reported figures.
