Contact Us

Sage One Help

Financial reports

It’s important that you know how your business is performing at any given time. To help you with this, the following financial reports are available which you can run from the more tab > Reports:

If required, you can choose to run the report to PDF, which you can print or save to your PC, or export the values as a CSV file, which you can open with Microsoft Excel. You can also drill down on the reports for more information, for example: clicking a balance on the Trial Balance shows the nominal activity.

Profit and Loss

The Profit and Loss Report shows the performance of your business over a specified period of time. It shows the values for sales, purchases, expenses and overheads for the chosen period and also shows the resulting gross profit or loss and net profit or loss values.

To run the report
  • 1. Profit and Loss Report > enter the dates you want to run the report from and to.
  • 2. Download report > choose one of the following options:
  • Printable PDF – This option opens the report as a PDF. Open your browser File menu then choose to print or save the page.
  • Export to CSV file – Depending on your Internet browser, the file either downloads automatically to your Downloads folder or you may receive a prompt asking you to save the file to your PC.

Balance Sheet

The Balance Sheet Report shows a snapshot of the worth of your business from when your business first started up to a specified date. The reports shows the value of the business rather than the profitability. It details your company’s assets and liabilities and provides a summary of your current financial position. The Balance Sheet Report is often used by companies when applying for finance or credit to prove the business is capable of paying its creditors.

To run the report
  • 1. Balance Sheet Report > enter the date you want to run the report up to.
  • 2. Download report > choose one of the following options:
  • Printable PDF – This option opens the report as a PDF. Open your browser File menu then choose to print or save the page.
  • Export to CSV file – Depending on your Internet browser, the file either downloads automatically to your Downloads folder or you may receive a prompt asking you to save the file to your PC.

Trial Balance

The Trial Balance shows the total debit and credit value for each nominal account within the date range specified. It also shows a final total to prove the value of all debit balances equal the total of all credit balances.

If you use Sage Accounts Production or Sage Accounts Production accounts_extra, you can export the Trial Balance Report as a CSV file which you can then import into your software. For more information about how to do this, please see your software documentation.

To run the report
  • 1. Trial Balance > enter the dates you want to run the reports from and to.
  • 2. Select one of the following options:
  • Periodic – This option shows the overall balance on the balance sheet nominal accounts at the to date you chose to run the report up to.
  • Transactional – This option shows the value of the transactions for the date range specified.

For example, if you run a periodic report your Cash at Bank nominal account shows the value of your account at the end date. If you run a transactional report, it shows the value of transactions entered during the date range, not the actual current balance.

  • 3. Download report > choose one of the following options:
  • Export for SAP/SAPA – Depending on your Internet browser, the file either downloads automatically to your Downloads folder or you may receive a prompt asking you to save the file to your PC.
  • Printable PDF – This option opens the report as a PDF. Open your browser File menu then choose to print or save the page.

Aged Debtors Report

This reports shows how much you are owed at any point in time by each of your customers. The report is used to keep track of which customers owe you money, how long they’ve owed you the money and how much they owe you. The report shows a summary of these values, if required, you can click the link to view the detailed report which shows the individual invoices which make up the total value.

To run the report
  • 1. Aged Debtors Report > enter the date you want to run the report to.
  • 2. Download report > choose one of the following options:
  • Printable PDF – This option opens the report as a PDF. Open your browser File menu then choose to print or save the page.
  • Export to CSV file – Depending on your Internet browser, the file either downloads automatically to your Downloads folder or you may receive a prompt asking you to save the file to your PC.

Aged Creditors Report

This reports shows how much you owe your suppliers at any point in time. The report is used to keep track of how much you owe, how long you’ve owed the money for and how much you owe. The report shows a summary of how much you owe, of required, you can click the link to view the detailed report which shows the individual invoices which make up the total value.

To run the report
  • 1. Aged Creditors Report > enter the date you want to run the report to.
  • 2. Download report > choose one of the following options:
  • Printable PDF – This option opens the report as a PDF. Open your browser File menu then choose to print or save the page.
  • Export to CSV file – Depending on your Internet browser, the file either downloads automatically to your Downloads folder or you may receive a prompt asking you to save the file to your PC.

Nominal Account Activity – Accountants only

Use the Nominal Activity Report to view a breakdown of the transactions recorded against any single nominal account for a date range of your choice.

To run the report you need to make sure you’re logged in as the accountant not the client. If you don’t have the option for this report, return to your client list and log in to this client again making sure you choose Login to Accounts.

To run the report
  • 1. Nominal Account Activity > choose the chart of accounts category, for example Overheads.
  • 2. Choose the nominal account you want to report on > enter the dates you want to run the report from and to.
  • 3. Download report > choose one of the following options:
  • Printable PDF – This option opens the report as a PDF. Open your browser File menu then choose to print or save the page.
  • Export to CSV file – Depending on your Internet browser, the file either downloads automatically to your Downloads folder or you may receive a prompt asking you to save the file to your PC.

Let us know what you think...