 |
 |
|
|
Information on using and creating expressions can be found in Expressions
In this Topic Hide
Groups with an asterisk * are available in all client types. Individual expressions that are unique to a client type are marked in bold in the Usage column.
*User Expressions - this will only appear if a User Expression has been added
Expression Name |
Usage |
Accountant - me/us |
Will display me or us based on selection to use singular or plural form, in the accountants 'Full Names' |
Accountant - Me/Us |
Will display Me or Us based on selection to use singular or plural form, in the accountants 'Full Names' |
Accountant - I/we |
Will display I or we based on selection to use singular or plural form, in the accountants 'Full Names' |
Accountant - I/We |
Will display I or We based on selection to use singular or plural form, in the accountants 'Full Names' |
Accountant - my/our |
Will display my or our based on selection to use singular or plural form, in the accountants 'Full Names' |
Accountant - My/Our |
Will display My or Our based on selection to use singular or plural form, in the accountants 'Full Names' |
Accountant address |
As entered in Client | View, Accountant |
Accountant name |
As entered in Client | View, Accountant |
accountant[s] |
Will display accountant OR accountants based on selection to use singular or plural form, in the accountants 'Full Names' |
accountant'[s] |
Will display accountant's OR accountants' based on selection to use singular or plural form, in the accountants 'Full Names' |
Accountant[s] |
Will display Accountant OR Accountants based on selection to use singular or plural form, in the accountants 'Full Names' |
Accountant'[s] |
Will display Accountant's OR Accountants' based on selection to use singular or plural form, in the accountants 'Full Names' |
actuary/actuaries |
Will display actuary OR actuaries based on the selection made within the data screen – Advisors | Actuary (Pensions schemes ONLY) |
Actuary/Actuaries |
Will display Actuary OR Actuaries based on the selection made within the data screen – Advisors | Actuary (Pensions schemes ONLY) |
actuary’s/actuaries’ |
Will display actuary’s OR actuaries’ based on the selection made within the data screen – Advisors | Actuary (Pensions schemes ONLY) |
Actuary’s/Actuaries’ |
Will display Actuary’s OR Actuaries’ based on the selection made within the data screen – Advisors | Actuary (Pensions schemes ONLY) |
Auditor - Are/Is |
Will display Are OR Is based on selection to use singular or plural form, in the auditors 'Full Names' |
Auditor address |
As entered in Client | View, Auditor |
Auditor full name |
As entered in Client | View, Auditor |
Auditor name |
As entered in Client | View, Auditor |
auditor['s/s'] |
Will display auditors' OR auditor's based on selection to use singular or plural form, in the auditors 'Full Names' |
Auditor['s/s'] |
Will display Auditors' OR Auditor's based on selection to use singular or plural form, in the auditors 'Full Names' |
auditor[s] |
Will display auditor OR auditors based on selection to use singular or plural form, in the auditors 'Full Names' |
Auditor[s] |
Will display Auditor OR Auditors based on selection to use singular or plural form, in the auditors 'Full Names' |
Auditors - are/is |
Will display are OR is based on selection to use singular or plural form, in the auditors 'Full Names' |
Auditors - I/we |
Will display I OR we based on selection to use singular or plural form, in the auditors 'Full Names' |
Auditors - I/We |
Will display I OR We based on selection to use singular or plural form, in the auditors 'Full Names' |
Auditors - me/us |
Will display me OR us based on selection to use singular or plural form, in the auditors 'Full Names' |
Auditors - Me/Us |
Will display Me OR Us based on selection to use singular or plural form, in the auditors 'Full Names' |
Auditors - our/my |
Will display our OR my based on selection to use singular or plural form, in the auditors 'Full Names' |
balance sheet |
Will vary based on the selection made within the data screen – UK (FRS 101) | FRS 101 – Options, UK (FRS 102) | FRS 102 – Options or International | IAS1 – Options (depending on the accounting standard being used). |
Business name |
Entered in Client | View, Business name |
Business name including trading as |
Entered in Client | View, Full names |
Business type |
Enter in Client | View, Business type (Note: a group is identified by client type) |
Business type category |
Will display as per business type except for ‘company’ (instead of limited company) and ‘charitable company’ (instead of charity) |
Ceased date |
Entered in Client | View, Ceased |
Currency symbol |
Will display the appropriate currency symbol |
Date - current end date - column heading |
dd.mm.yy, yyyy, 'yy OR dd/mm/yy see Setup | Report Options for Column heading formatting |
Date - current end date - textual - dd Month |
dd Month - see Setup | Report options for date formatting - textual |
Date - current end date - textual - dd Month yyyy |
dd Month yyyy - see Setup | Report options for textual formatting |
Date - current start date - textual - dd Month |
dd Month - see Setup | Report options for textual date formatting |
Date - current start date - textual - dd Month yyyy |
dd Month yyyy - see Setup | Report options for textual date formatting |
Date - last end date - column heading |
dd.mm.yy, yyyy, 'yy OR dd/mm/yy see Setup | Report Options for Column heading formatting |
Date - last end date - textual - dd Month |
dd month - Setup | Report options for textual date formatting |
Date - last start date - textual - dd Month |
dd month - Setup | Report options for textual date formatting |
Date - last start date - textual - dd Month yyyy |
dd Month yyyy - see Setup | Report options for textual date formatting |
Final dividends - current year |
Total of amounts posted to final dividends 471/1-25 |
Final dividends - last year |
Total of amounts posted to final dividends 471/1-25 |
FRS 102/FRSSE |
Will make reference to FRSSE or FRS 102 based on selection made within the data screen(s) |
Gross profit - current - wording - profit/loss |
Will display profit OR loss depending on the gross profit in the current year |
Gross profit - current year |
Will display gross profit figure for current year |
Gross profit - current/last - wording - profit/loss |
Will display profit/(loss), (loss)/profit, loss OR profit depending on the gross profit in current and last years |
Gross profit - last - wording - profit/loss |
Will display profit OR loss depending on the gross profit in last year |
Gross profit - last year |
Will display gross profit figure for last year |
Group 1 balance current year |
Group 1 Turnover codes 1 to 10/1-50 |
Group 1 balance last year |
Group 1 Turnover codes 1 to 10/1-50 |
Group 1 extended description |
|
Group 101 balance current year |
Group 101 Distribution cost codes 151 to 214 |
Group 101 extended description |
|
Group 151 balance current year |
Group 151 Distribution cost codes 220 to 396 |
Group 151 balance last year |
Group 151 Distribution cost codes 220 to 396 |
Group 151 extended description |
|
Group 21 balance current year |
Group 21 Cost of sales codes 17 to 82 |
Group 21 balance last year |
Group 21 Cost of sales codes 17 to 82 |
Group 21 extended description |
|
Group 271 balance current year |
Group 271 Exceptional items codes 400 to 404 |
Group 271 balance last year |
Group 271 Exceptional items codes 400 to 404 |
Group 271 extended description |
|
Group 281 balance current year |
Group 281 Amounts w/o investment codes 406 to 407 |
Group 281 balance last year |
Group 281 Amounts w/o investment codes 406 to 407 |
Group 281 extended description |
|
Group 291 balance current year |
Group 291 Interest payable and similar charges codes 413 to 416 |
Group 291 balance last year |
Group 291 Interest payable and similar charges codes 413 to 416 |
Group 291 extended description |
|
Group 301 balance current year |
Group 301 FRS-17 other fin income/costs codes 438 to 439 |
Group 301 balance last year |
Group 301 FRS-17 other fin income/costs codes 438 to 439 |
Group 301 extended description |
|
Group 311 balance current year |
Group 311 Taxation codes 442 to 455 |
Group 311 balance last year |
Group 311 Taxation codes 442 to 455 |
Group 311 balance last year |
|
Group 41 balance current year |
Group 41 Other operating income codes 88 to 103 |
Group 41 balance last year |
Group 41 Other operating income codes 88 to 103 |
Group 41 extended description |
|
Group 61 balance current year |
Group 61 Income from investments codes 109 to 127 |
Group 61 balance last year |
Group 61 Income from investments codes 109 to 127 |
Group 61 extended description |
|
Group 81 balance current year |
Group 81 Interest receivable codes 130 to 145 |
Group 81 balance last year |
Group 81 Interest receivable codes 130 to 145 |
Group 81 extended description |
|
Incorporated date |
Entered in Client | View, Incorporated |
Interim dividends - current year |
Total of amounts posted to interim dividends 471/1-25 |
Interim dividends - last year |
Total of amounts posted to interim dividends 471/1-25 |
Operating profit - current - wording - profit/loss |
Will display profit OR loss depending on the operating profit in current year |
Operating profit - current year |
Will display the operating profit figure for the current year |
Operating profit - current/last - wording - profit/loss |
Will display profit/(loss), (loss)/profit, loss OR profit depending on the profit for the year in current and last years |
Operating profit - last - wording - profit/loss |
Will display profit OR loss depending on the operating profit in the last year |
Operating profit - last year |
Operating profit figure for the last year |
Profit after tax - current - wording - profit/loss |
Will display profit OR loss depending on the profit after tax in current year |
Profit after tax - current year |
Will display profit after tax figure for current year |
Profit after tax - current/last - wording - profit/loss |
Will display profit/(loss), (loss)/profit, loss OR profit depending on the profit after tax in current and last years |
Profit after tax - last - wording - profit/loss |
Will display profit OR loss depending on the profit after tax in last year |
Profit after tax - last year |
Will display profit after tax figure for last year |
Profit and loss reserve - current year |
Total of postings to profit and loss reserve account codes 966/1-10 |
Profit before tax - current - wording - profit/loss |
Will display profit OR loss depending on the profit before tax in last year |
Profit before tax - current year |
Will display profit before tax figure for current year |
Profit before tax - current/last - wording - profit/loss |
Will display profit/(loss), (loss)/profit, loss OR profit depending on the profit before tax in current and last years |
Profit before tax - last - wording - profit/loss |
Will display profit OR loss depending on the profit before tax in current year |
Profit before tax - last year |
Will display profit before tax figure for last year |
Registered number |
entered in Client | View, registered number |
Report of the Trustees/Trustees’ Report |
Will display Report of the Trustees OR Trustees’ Report based on selection made within the data screen – Report of the Trustees | Options |
Retained profit - current - wording - profit/loss |
Will display profit OR loss depending on the retained profit in current year |
Retained profit - current year |
Total of postings to share capital account codes 966/1-20 |
Retained profit - current/last - wording - profit/loss |
Will display profit/(loss), (loss)/profit, loss OR profit depending on the retained profit in current and last years |
Retained profit - last - wording - profit/loss |
Will display profit OR loss depending on the retained profit in last year |
Retained profit - last year |
Will display retained profit figure for last year |
Share capital - current year |
Total of postings to share capital account codes 966/1-20 |
Trading commenced date |
Entered in Client | View, Commenced |
year/period for current year |
Returns year or period based on the length of the current year |
Year/Period for current year |
Returns Year or Period based on the length of the current year |
year/period for last year |
Returns year or period based on the length of the last year |
Year/Period for last year |
Returns Year or Period based on the length of the last year |
General |
|
Expression Name |
Usage |
balance sheet |
Will vary based on the selection made within the data screen – UK (FRS 101) | FRS 101 – Options, UK (FRS 102) | FRS 102 – Options or International | IAS1 – Options (depending on the accounting standard being used). |
Business name |
Entered in Client | View, Business name |
Business name including trading as |
Entered in Client | View, Full names |
Business type |
Enter in Client | View, Business type (Note: a group is identified by client type) |
Business type category |
Will display as per business type except for ‘company’ (instead of limited company) and ‘charitable company’ (instead of charity) |
Ceased date |
Entered in Client | View, Ceased |
Charity Number |
Charity number entered in Client | View, Tax tab (Charities Only) |
Currency symbol |
Will display the appropriate currency symbol |
FRS 102/FRSSE |
Will make reference to FRSSE or FRS 102 based on selection made within the data screen(s) |
Incorporated date |
Entered in Client | View, Incorporated |
Registered number |
entered in Client | View, registered number (Not in Charities) |
Trading commenced date |
Entered in Client | View, Commenced |
Trustees |
|
Expression Name |
Usage |
Report of the Trustees/Trustees’ Report |
Will display Report of the Trustees OR Trustees’ Report based on selection made within the data screen – Report of the Trustees | Options |
Actuaries |
|
Expression Name |
Usage |
actuary/actuaries |
Will display actuary OR actuaries based on the selection made within the data screen – Advisors | Actuary (Pensions schemes ONLY) |
Actuary/Actuaries |
Will display Actuary OR Actuaries based on the selection made within the data screen – Advisors | Actuary (Pensions schemes ONLY) |
actuary’s/actuaries’ |
Will display actuary’s OR actuaries’ based on the selection made within the data screen – Advisors | Actuary (Pensions schemes ONLY) |
Actuary’s/Actuaries’ |
Will display Actuary’s OR Actuaries’ based on the selection made within the data screen – Advisors | Actuary (Pensions schemes ONLY) |
Accountants |
|
Expression Name |
Usage |
Accountant - me/us |
Will display me or us based on selection to use singular or plural form, in the accountants 'Full Names' |
Accountant - Me/Us |
Will display Me or Us based on selection to use singular or plural form, in the accountants 'Full Names' |
Accountant - I/we |
Will display I or we based on selection to use singular or plural form, in the accountants 'Full Names' |
Accountant - I/We |
Will display I or We based on selection to use singular or plural form, in the accountants 'Full Names' |
Accountant - my/our |
Will display my or our based on selection to use singular or plural form, in the accountants 'Full Names' |
Accountant - My/Our |
Will display My or Our based on selection to use singular or plural form, in the accountants 'Full Names' |
Accountant address |
As entered in Client | View, Accountant |
Accountant name |
As entered in Client | View, Accountant |
accountant[s]
|
Will display accountant OR accountants based on selection to use singular or plural form, in the accountants 'Full Names' |
accountant'[s] |
Will display accountant's OR accountants' based on selection to use singular or plural form, in the accountants 'Full Names' |
Accountant[s]
|
Will display Accountant OR Accountants based on selection to use singular or plural form, in the accountants 'Full Names' |
Accountant'[s]
|
Will display Accountant's OR Accountants' based on selection to use singular or plural form, in the accountants 'Full Names' |
Auditors |
|
Expression Name |
Usage |
Auditor - Are/Is
|
Will display Are OR Is based on selection to use singular or plural form, in the auditors 'Full Names' |
Auditor address |
As entered in Client | View, Auditor |
Auditor full name |
As entered in Client | View, Auditor |
Auditor name |
As entered in Client | View, Auditor |
auditor['s/s']
|
Will display auditors' OR auditor's based on selection to use singular or plural form, in the auditors 'Full Names' |
Auditor['s/s'] |
Will display Auditors' OR Auditor's based on selection to use singular or plural form, in the auditors 'Full Names' |
auditor[s]
|
Will display auditor OR auditors based on selection to use singular or plural form, in the auditors 'Full Names' |
Auditor[s]
|
Will display Auditor OR Auditors based on selection to use singular or plural form, in the auditors 'Full Names' |
Auditors - are/is
|
Will display are OR is based on selection to use singular or plural form, in the auditors 'Full Names' |
Auditors - I/we |
Will display I OR we based on selection to use singular or plural form, in the auditors 'Full Names' |
Auditors - I/We |
Will display I OR We based on selection to use singular or plural form, in the auditors 'Full Names' |
Auditors - me/us
|
Will display me OR us based on selection to use singular or plural form, in the auditors 'Full Names' |
Auditors - Me/Us
|
Will display Me OR Us based on selection to use singular or plural form, in the auditors 'Full Names' |
Auditors - our/my
|
Will display our OR my based on selection to use singular or plural form, in the auditors 'Full Names' |
Date Formatting |
|
Expression Name |
Usage |
Date - current end date - column heading |
dd.mm.yy, yyyy, 'yy OR dd/mm/yy see Setup | Report Options for Column heading formatting |
Date - current end date - textual - dd Month |
dd Month - see Setup | Report options for textual formatting |
Date - current end date - textual - dd Month yyyy |
dd Month - see Setup | Report options for textual formatting |
Date - current start date - textual - dd Month |
dd Month - see Setup | Report options for textual formatting |
Date - current start date - textual - dd Month yyyy |
dd Month yyyy - see Setup | Report options for textual date formatting |
Date - last end date - column heading |
dd.mm.yy, yyyy, 'yy OR dd/mm/yy see Setup | Report Options for Column heading formatting |
Date - last end date - textual - dd Month |
dd month - Setup | Report options for textual formatting |
Date - last end date - textual - dd Month yyyy |
dd month - Setup | Report options for textual formatting |
Date - last start date - textual - dd Month |
dd month - Setup | Report options for textual formatting |
Date - last start date - textual - dd Month yyyy |
dd Month yyyy - see Setup | Report options for textual date formatting |
year/period for current year |
Returns year or period based on the length of the current year |
Year/Period for current year |
Returns Year or Period based on the length of the current year |
year/period for last year |
Returns year or period based on the length of the last year |
Year/Period for last year |
Returns year or period based on the length of the last year |
Account Groups |
|
Expression Name |
Usage |
Final dividends - current year |
Total of amounts posted to final dividends 471/1-25 |
Final dividends - last year |
Total of amounts posted to final dividends 471/1-25 |
Group 1 balance current year |
Group 1 Turnover codes 1 to 10/1-50 |
Group 1 balance last year |
Group 1 Turnover codes 1 to 10/1-50 |
Group 1 extended description |
|
Group 21 balance current year |
Group 21 Cost of sales codes 17 to 82 |
Group 21 balance last year |
Group 21 Cost of sales codes 17 to 82 |
Group 21 extended description |
|
Group 41 balance current year |
Group 41 Other operating income codes 88 to 103 |
Group 41 balance last year |
Group 41 Other operating income codes 88 to 103 |
Group 41 extended description |
|
Group 61 balance current year |
Group 61 Income from investments codes 109 to 127 |
Group 61 balance last year |
Group 61 Income from investments codes 109 to 127 |
Group 61 extended description |
|
Group 81 balance current year |
Group 81 Interest receivable codes 130 to 145 |
Group 81 balance last year |
Group 81 Interest receivable codes 130 to 145 |
Group 81 extended description |
|
Group 101 balance current year |
Group 101 Distribution cost codes 151 to 214 |
Group 101 extended description |
|
Group 151 balance current year |
Group 151 Administrative expenses codes 220 to 396 |
Group 151 balance last year |
Group 151 Administrative expenses codes 220 to 396 |
Group 151 extended description |
|
Group 271 balance current year |
Group 271 Exceptional items codes 400 to 404 |
Group 271 balance last year |
Group 271 Exceptional items codes 400 to 404 |
Group 271 extended description |
|
Group 281 balance current year |
Group 281 Amounts w/o investment codes 406 to 407 |
Group 281 balance last year |
Group 281 Amounts w/o investment codes 406 to 407 |
Group 281 extended description |
|
Group 291 balance current year |
Group 291 Interest payable and similar charges codes 413 to 416 |
Group 291 balance last year |
Group 291 Interest payable and similar charges codes 413 to 416 |
Group 291 extended description |
|
Group 301 balance current year |
Group 301 FRS-17 other fin income/costs codes 438 to 439 |
Group 301 balance last year |
Group 301 FRS-17 other fin income/costs codes 438 to 439 |
Group 301 extended description |
|
Group 311 balance current year |
Group 311 Taxation codes 442 to 455 |
Group 311 balance last year |
Group 311 Taxation codes 442 to 455 |
Group 311 extended description |
|
Interim dividends - current year |
Total of amounts posted to interim dividends 471/1-25 |
Interim dividends - last year |
Total of amounts posted to interim dividends 471/1-25 |
Profit and loss reserve - current year |
Total of postings to profit and loss reserve account codes 966/1-10 |
Share capital - current year |
Total of postings to share capital account codes 966/1-20 |
Gross Profit |
|
Expression Name |
Usage |
Gross profit - current - wording - profit/loss |
Will display profit OR loss depending on the gross profit in the current year |
Gross profit - current year |
Will display gross profit figure for current year |
Gross profit - current/last - wording - profit/loss |
Will display profit/(loss), (loss)/profit, loss OR profit depending on the gross profit in current and last years |
Gross profit - last - wording - profit/loss |
Will display profit OR loss depending on the gross profit in last year |
Gross profit - last year |
Will display gross profit figure for last year |
Operating Profit |
|
Expression Name |
Usage |
Operating profit - current - wording - profit/loss |
Will display profit OR loss depending on the operating profit in current year |
Operating profit - current year |
Will display the operating profit figure for the current year |
Operating profit - current/last - wording - profit/loss |
Will display profit/(loss), (loss)/profit, loss OR profit depending on the profit for the year in current and last years |
Operating profit - last - wording - profit/loss |
Will display profit OR loss depending on the operating profit in the last year |
Operating profit - last year |
Operating profit figure for the last year |
Profit After Tax |
|
Expression Name |
Usage |
Profit after tax - current - wording - profit/loss |
Will display profit OR loss depending on the profit after tax in current year |
Profit after tax - current year |
Will display profit after tax figure for current year |
Profit after tax - current/last - wording - profit/loss |
Will display profit/(loss), (loss)/profit, loss OR profit depending on the profit after tax in current and last years |
Profit after tax - last - wording - profit/loss |
Will display profit OR loss depending on the profit after tax in last year |
Profit after tax - last year |
Will display profit after tax figure for last year |
Profit Before Tax |
|
Expression Name |
Usage |
Profit before tax - current - wording - profit/loss |
Will display profit OR loss depending on the profit before tax in last year |
Profit before tax - current year |
Will display profit before tax figure for current year |
Profit before tax - current/last - wording - profit/loss |
Will display profit/(loss), (loss)/profit, loss OR profit depending on the profit before tax in current and last years |
Profit before tax - last - wording - profit/loss |
Will display profit OR loss depending on the profit before tax in current year |
Profit before tax - last year |
Will display profit before tax figure for last year |
Retained Profit |
|
Expression Name |
Usage |
Retained profit - current - wording - profit/loss |
Will display profit OR loss depending on the retained profit in current year |
Retained profit - current year |
Total of postings to share capital account codes 966/1-20 |
Retained profit - current/last - wording - profit/loss |
Will display profit/(loss), (loss)/profit, loss OR profit depending on the retained profit in current and last years |
Retained profit - last - wording - profit/loss |
Will display profit OR loss depending on the retained profit in last year |
Retained profit - last year |
Will display retained profit figure for last year |
|
|
User Expressions |
|
This folder contains a list of Expressions created by the client. Expressions are Created and amended in Account Chart Maintenance. Click here to view more information on creating Expressions. Master and Super users have permissions to access the Expressions. Access to Users is optional, permission is granted by Super or Master Users. Select Setup | Staff Maintenance select View or New. |
|