Statement of Financial Activities - Income and Expenditure

The SOFA is made up of income and expense accounts which shows the surplus or deficit over a particular time period for the entities funds.

Income accounts are used to record the all income for your entity. While expense accounts record costs of goods, services and other expenses incurred in the day to day running of the entity.

Income and Expenditure

This report produces an income and expenditure version of the SOFA. In essence this recognises incoming resources and resources expended on the basis of commitment or consumption rather then when cash actually flows. So for example when a utility bill has been received at the end of the accounting period this would be shown in an Income and Expenditure SOFA even though the cash settlement takes place in the following accounting period. This approach is known as the 'Accruals' basis.

The report will usually be produced with Funds summarised across Unrestricted, Restricted and Endowment. However if the user prefers to have each fund displayed in columns tick the 'All Funds by Column" box.

Charities with an annual income of below £250,000 may choose to report on the above accruals basis or an alternative cash basis known as Receipts and Payments. Charities that are companies may not use a receipts and payments basis. The user is strongly advised to discuss the choice with their advisor if uncertain.

Quick Date Selection

The Quick Date Selection drop-down allows the user to rapidly select relevant key date ranges for the report.

A comparative version is available by setting the date range for the comparison. The SET DATES FOR COMPARATIVE PERIOD BELOW button will also quickly populate a comparative period related to the date range set above.

Select the number format for the report, either: -

A pdf report subsequently created will use the same number format, but csv and xls downloads will be to the exact amount.

The report is prepared by clicking GENERATE button.

Level of Detail

The level of detail can be set by the user clicking on the top left of the screen the EXPAND All/COLLAPSE All buttons or use the + or - buttons.

The amount of further detail is determined by the user by clicking Down Arrow symbol

Note the level of line item detail displayed on the screen will be reflected in any subsequent output.

Report Output

The report is presented to screen and the user may drill-down on individual lines to see the underlying transactions. The report can also be downloaded in PDF, XLS, or CSV format. Alternatively you may save a copy of the report on Liberty to be viewed from the menu option:

Reports - Saved Reports

Where the report has columns not immediately displayed on the screen the user may scroll with a mouse.

Drill-down

Click on the account you want to view and the system will open a new window showing all the transactions that make up the total in the for that account. By default only the transactions for the year you are reporting on will be presented but the user may extend the date range.

Re-assign Selected Items

Single or multiple transactions may be re-assigned to another account by selecting from the drop-down box an account to which the transactions need to be moved.

Note this is a powerful feature and must be used with care and understanding.

Select those transactions required to be moved by ticking the selection box for each. Note all items in the screen date window may be selected by ticking 'Re-assign All'

When ready, click the RE-ASSIGN SELECTED ITEMS button to move those transactions.

Analyse

Click ANALYSE where available to modify existing transactions. In using this feature you need to think carefully about the impact of your change and whether it is acceptable based on the needs of your organisation, its accounting policies, and whether the change causes your accounts to differ from what you have already reported to statutory or tax bodies. Transactions can only be changed and saved if they are dated after the later of the last closed year end or any user configured "Transaction Lock Date" on the accounting options tab of the business profile.

Note that 'Re-assign Selected Items' function is also available from within the Analyse Screen. Please note the comments above.