Management Accounts Table Settings Dialog

This dialog is available to users of UK FRS 102, Sole Trade Standard and Partnership Standard templates.

This dialog enables you to control and configure your Management Accounts report. It is available by clicking the Management Accounts Table Settings link from the Report Options section on the Summary tab.

Period Covered Tab

Start date of period covered in these management accounts: This should be completed with the start date from which you want to include Journals in the fixed asset notes. For example, if you want the opening balance in the fixed asset note to be at 1 April 20X7, the start date would be 01/04/20X7.

End date of period covered in these management accounts: This should be completed with the last date to include Journals in the fixed asset notes. For example, if you want the closing balance in the fixed asset note to be at 31 May 20X7, the end date would be 31/05/20X7.

Profit and Loss Columns Tab

Reporting period

Use this section to select whether you want to prepare a Monthly, Quarterly, Six Monthly or Custom set of Management Accounts.

Selecting Monthly, Quarterly or Six Monthly will automatically complete the Date filter start and Date filter end columns in the Column settings grid with the appropriate dates, based on the financial period. Selecting Custom will leave these Date filter cells blank.

To change between reporting periods you need to select the new period, click OK to close the dialog, refresh the accounting period from within the Summary tab and then re-open the Profit and Loss Columns tab to ensure that the cells have been updated.

Column settings

Column no.: This column identifies the number of potential columns and cannot be edited.

Date filter start: Use this column to enter the start date from which you want to include Journals in the column. For example, if you want to create a Profit and Loss Account column for the period 1 April 20X7 to 31 May 20X7, the start date would be 1 April 20X7.

Date filter end: Use this column to enter the end date to include Journals in the column. For example, if you want to create a Profit and Loss Account column for the period 1 April 20X7 to 31 May 20X7, the end date would be 31 May 20X7.

Column header: This is automatically completed based on the dates entered into the Date filter start and Date filter end fields. However, it can be overridden by typing directly into the cell.

You can remove overridden text by right-clicking on a cell and selecting Remove Override.

Include in report?: You can turn the Profit and Loss column on and off in the Management Accounts report by selecting Yes or No respectively.

Include variance from previous column?: You can turn the Variance column on and off in the Management Accounts report by selecting Yes or No respectively. The Variance column will calculate the difference between that column and the previous column. As an example, if you have selected Yes for the Include variance from previous column on column 2, the Variance will be the difference between column 2 and column 1.

Balance Sheet Columns Tab

Reporting period

Use this section to select whether you want to prepare a Monthly, Quarterly, Six Monthly or Custom set of Management Accounts.

Selecting Monthly, Quarterly or Six Monthly will automatically complete the Date filter start and Date filter end columns in the Column settings grid with the appropriate dates, based on the financial period. Selecting Custom will leave these Date filter cells blank.

To change between reporting periods you need to select the new period, click OK to close the dialog, refresh the accounting period from within the Summary tab and then re-open the Balance Sheet Columns tab to ensure that the cells have been updated.

Column settings

Column no.: This column identifies the number of potential columns and cannot be edited.

Date filter start: Use this column to enter the start date from which you want to include Journals in the column. For example, if you want to create a Balance Sheet column for the period 1 April 20X7 to 31 May 20X7, the start date would be 1 April 20X7.

Date filter end: Use this column to enter the end date to include Journals in the column. For example, if you want to create a Balance Sheet column for the period 1 April 20X7 to 31 May 20X7, the end date would be 31 May 20X7.

Column header: This is automatically completed based on the dates entered into the Date filter start and Date filter end fields. However, it can be overridden by typing directly into the cell.

You can remove overridden text by right-clicking on a cell and selecting Remove Override.

Include in report?: You can turn the Balance Sheet column on and off in the Management Accounts report by selecting Yes or No respectively.