> Financials / Financial Reports / Balance sheet reports

Read the full guide

The Financials window

Watch the video

Balance sheet reports

 

To help you make vital business decisions, you can see a summary of your current financial position using a balance sheet report.

A balance sheet shows what your organisation owns - your assets, and what it owes - your liabilities, and what form the money is in, for example, motor vehicles or property, bank accounts, debtors, creditors, cash accounts, and so on. The difference between the assets and the liabilities is often known as a company’s net assets, or net worth.The balance sheet also shows the company's sources of capital, such as capital introduced by the owner, directors’ loans, and funds retained from previous years' profit after tax.

The structure of the balance sheet is based on the Chart of Accounts that you choose when you run the report. You can customise the Chart of Accounts structure or create new ones to suit your business needs. Find out more

There are several balance sheet reports available, including:


To generate the Balance SheetOpen this section

  1. Company > Links pane > Financials > Balance Sheet.

  2. Select the required output as follows:

    Printer

    Sends the report to your printer.

    Preview

    Use this to see the report on-screen.

    Tip: From the report preview you can then run the report to printer, file or email.

    File

    Saves the report to file, for example, to print at a later date.

    Email

    Sends the report by email.

  3. To generate the report, click Run > enter any required criteriaOpen this section > OK.

    Period

    From the drop-down lists, choose the accounting range you want.

    A true balance sheet is a snapshot of the finances of an organisation at a particular time, and therefore the year-to-date values are the figures you should present as your true balance sheet at that point.

    The current month’s values or Period range values only show the net movement of assets and liabilities during the chosen period. They show how your company increased or decreased in net worth over that period, but do not show you what your company was actually worth at the end of that period.

    Chart of Accounts

    From the drop-down list, choose the Chart of Accounts you want to use for your report.

    A default Charts of Accounts is available or you can create as many of your own as you need. Find out more

Tip: When you preview the Balance Sheet you can drill-down on the values to see a breakdown. Find out more

To generate the Transactional Balance SheetOpen this section

  1. Company > Links pane > Financials > Reports > Balance sheet.

  2. Select Transactional Balance Sheet > click Preview, Print, Export, Excel or Email as required. Find out more

  3. Enter any required criteriaOpen this section > OK.

    Chart number

    From the drop-down list, choose the Chart of Accounts you want to use for your report.

    A default Charts of Accounts is available or you can create as many of your own as you need. Find out more

    Group by Tran Number

    To run your report for a transaction number range, select this check box.

    If you want to run the report for a date range, ensure that this check box is clear.

    Transaction date

    If you have not selected the Group by Tran Number check box, enter the transaction date range that you want to run the report for.

    Note: If you have selected the Group by Tran Number check box, any date range you enter does not affect the report and only the transaction numbers determine the report values.

    First Transaction of Year

    If you have selected the Group by Tran Number check box, enter the transaction number of the first transaction posted in your current financial year.

    The report uses this to identify any previous year adjustments.

    Transaction number

    If you have selected the Group by Tran Number check box, enter the transaction number range you want to run the report for.

    This is used to calculate the period and year to date values.

    Department number

    You can run this report for specific departments. If required, enter the department range you want to run the report for.

To generate the Balance Sheet by FundsOpen this section

  1. Company > Links pane > Financials > Reports > Balance sheet.

  2. Select Balance Sheet by Funds > click Preview, Print, Export, Excel or Email as required. Find out more

  3. Enter any required criteriaOpen this section > OK.

    Chart number

    From the drop-down list, choose the Chart of Accounts you want to use for your report.

    A default Charts of Accounts is available or you can create as many of your own as you need. Find out more

    Group by Tran Number

    Ensure that this check box is clear.

    Transaction date

    Enter the transaction date range that you want to run the report for.

    Fund

    You can run this report for specific funds. If required, enter the fund range you want to run the report for.


More information

Profit and loss reports

Trial balance reports


To review Ask Sage, Business Advice and Health and Safety advice, go here. All contact details for Sage are available from here.

Go to top