Chart of Accounts Report - Customise Your Financial Data for Powerful Reporting

Chart of Accounts Report Overview

The SapphireOne Chart of Accounts lists the financial accounts that have been prepared for recording transactions in an organisations General Ledger. A company has the flexibility to tailor its Chart of Accounts to best suit its needs, including adding accounts as required. This allows companies to collate all the data into financial reports to be used within an organisation.

There are a number of useful reports available from the SapphireOne Chart of Accounts Reports function. These reports are selected using the Report Type and Report Sort Order drop-down menus as outlined below.

How to Create a Chart of Accounts Report

When the Chart of Accounts option is selected from the General Ledger menu, a General Ledger Reports dialog is displayed as seen below.

Print Destination

The user may choose to send the report directly to the Printer, or use a Custom Report or Quick Report.

Chart of Accounts Report Types

The selection of report types through the drop-down menu item displays a Chart of Accounts providing the desired information. 

Account ID	This prints a chart of accounts using the Standard Account ID.
UDF Fields	This prints a chart of accounts using the UDF Field.  These details are set in General Ledger Inquiry.
Alternate Codes	This prints a chart of accounts using the Alternative Code.  These details are set in General Ledger Inquiry.

Chart of Accounts Report Report Sort Order

This option allows the user to sort the chosen report in the order required for printing. The report may be sorted by the following methods.

Account	This prints using account names.
Account ID	This prints the chart using the standard account codes.
Alternate ID	This prints the chart using the Alternate ID (User Defined area). This area is on the More Details Page in a General Ledger Inquiry.
Class	This prints the chart using the Class ID as set in the first Page of a General Ledger Inquiry Details.
Department	This prints the chart using the Departments, as set in the first Page of a General Ledger Inquiry Details.

Report Selection

Selecting the Active Only option will display a report including all active records within SapphireOne. Selecting the All Records option will process the report on all records, including records that are no longer active.

Report Buttons

• Print – This print button will take the user to you operating platforms Print dialog screen.
• Cancel – This button will cancel the current procedure.
• Record List – When this button is selected SapphireOne will allow the user to view the current selection.
• Options – When this button is selected SapphireOne will display an additional page where more options are able to be selected for the report. This is documented immediately below in this article.
• Queue – This button places the report on a queue to the printer.
• Background – This tell SapphireOne to print this job as a separate task in the background as time permits. It lowers the printing priority for the operating platform.

Report Examples

Below is an example of a report that has been created using the default settings of a Report Type of ‘Account ID’. The Report Sort Order was also sorted by ‘Account ID’. 

For the second report, we used a Report Type of ‘Account ID’, however for the Report Sort Order we used ‘Class’. 

Options Menu

It is critical that the user selects the Report Type and any other selections on the print dialog first as seen above before the button is selected. Once the options have been selected, and the user is returned to the General Ledger Reports dialog, the only selection that the user may make is to select the button. The selection of anything else on returning to this General Ledger Reports dialog will immediately cancel any options that were previously selected.

When the button is selected this allows the user to select periods for this year and last year. The user may also include budget figures together with the formatting and entry of headings and sub-headings.

Up to 12 columns may be used to create the reports as seen in the screenshot above. The report will be scaled as necessary to fit onto a single A4 page.

Saving Chart of Accounts Reports

SapphireOne does not automatically save a report once it has been printed. To save reports before printing, go to the Design area and select the Saved Reports menu. When the list is displayed select the ‘Add…’ option. Enter a name for your report and save it. It will then be displayed in the Saved Reports list for retrieval and re-printing or modification later on.

Column Area

The upper area of the Options screen displays the columns as selected from the Design area.

• Radio Buttons – The number of columns is selected using the radio buttons that go from 1 column all the way through to 12 columns.
• Period Selection – The user is then able to select the period for each column that the data is to be drawn from.
• Column Data – Each column may be selected in turn and various options selected from the Design area below.

Design Area

The lower area of the Options screen enables the selection of how these reports are to be driven. There are various menus with options as follows.

• Presets – After the Pre-Set item, this menu has six other options. Once an option has been selected SapphireOne will display the correct number of columns with the correct data being displayed in each column. After selecting the periods required for the report, No further user intervention is required.
  • Documentation – Additional documentation is written later in this article as the options for it are extensive.
• Select – This is the manual version of the preset option above. Each column has to be selected in turn, and the following selections made from the three drop down menus as follows.
  • Number of Columns – First use the radio button to select the number of columns for the report.
  • Column Selection – Next use the mouse to select the column from the upper area, or select it directly from the list of columns from the Select drop down list.
  • Column Year – For the selected column choose to display data from Last Year through to 8 Years ago.
  • Actual Budget – For the selected column, the user has the following options for the data to display. Actual, Budget or Revised Budget.
• Save Reports – On initial opening of this function there should be no saved reports, there will only be the ‘Add..’ report item in the list. To save a new report select the ‘Add..’ report option. Any saved reports will be in the drop down list.
• Mode – By default the initial report is set up on a period based structure. The user may select a single Period or multiple periods for each column in the report. This menu allows the user to structure reports based on additional criteria as follows. This additional criteria below may also be selected one at a time or in groups as required.
  • Periods – Default Setting on entry to this report editor.
  • Projects –Enables reports to be based on a period for a selected Project or Projects.
  • Task – Enables reports to be based on a period for a select Task or Tasks.
  • Department – Enables reports to be based on a period for a select Department or Departments
  • Project Class – Enables reports to be based on a period for a select Project Class or Project Classes.
  • All Items – There are four items at the bottom of the list. All Projects, All Tasks, All Departments and All Project Classes.
    • Radio Buttons – The Column Radio buttons are disabled and just the single column will be displayed in the upper area.This will allow you set up 1 column and repeat the selection for all of the selected item on the drop-down menu as seen to the right. For example, if you have 100 active projects it will give you income statements with 100 projects in 100 columns.
    • Options – Provision is also made to select if the report is to be simply period driven or a combination of period with a number of other options.
• Format – When this button is selected SapphireOne displays a pop up which allows for the selection of a number of formatting options which is documented later in this section of the manual.
• Columns – From the radio buttons select the number of columns that you want in the report.
• Net Balances – Select his checkbox if net balances are to be printed.
• Column Header – Select each column in turn and enter a column heading. Select the column first, then enter the required Heading. Go through them all one at a time entering the headings as you go.

Mode Menu

The mode menu is the main driving force for these reports. By default this is set as seen Periods. From Periods and then from All Projects through to the All Project Class items, the only requirement is for the user to make a selection for the period for the report. For this reason only periods are displayed in the column area when these items are selected.

When a Project, Task, Department or Project Class item is selected, the column will be split vertically. The upper part of the column will still display periods, but the lower part will display the item as selected from the mode menu as seen to the right.

The user must then select the Periods for the report, as well as the Project, Task, Department or Project Class from the lower section of the column. They have to tell SapphireOne what period and what Project, Task, Department or Project Class is to be included in the report.

Mode Menu Set as Period

By default the options screen opens with the Pre-Set menu displaying Pre-set and a single column. The mouse is then used to select the periods form the columns in the upper area for the the report. This report may then be immediately printed.

• Columns – Defaults to one column only.
• Pre-sets – SapphireOne opens with this menu item set at Pre-Sets.
• Select – These three menus are set on General, Current and Actual.
• Mode – This menu is set at Period.
• Period Selection – The user must select the Periods for the report.
• Printing – The user may immediately then print the default report.

There are six additional Presets as seen to the right. When any of these are selected SapphireOne will set the report up as follows.

• Pre-set – Select as required fro MTD-TTD through to MTD-YTD + Last.
• Columns – The number as initially required will be displayed. The user can alter these as required.
• Mode menu – Select as required. For some items the columns will be split. (See above).
• Column Data – The periods will always be displayed for selection.
  • Periods – Select periods as required.
  • Mode items – If the column is split select the mode items as required.
• Saving – Before printing save the report as once printed it will not be saved.
• Printing – The user may print the report.

By selecting one of the additional six Pre-sets SapphireOne will automatically set up a report as follows.

• Select Menu – The options from the three drop down menus will be selected.
• Columns – The columns required for the report will automatically be displayed in the upper area.
• Periods – Input from the user is required to select the periods for the report.
• Printing – Select OK then select Print from the main screen.

If the default setup above is not to the users requirements, from here they can make alterations as desired. The basis for the report should be there, with alterations or additions their own custom report can be setup.

---

You can review our Blog and YouTube channel for additional information and resources on SapphireOne ERP, CRM and Business Accounting software.