Asset & Liability Statement Report
The Assets and Liability Statement Report in ExpensePlus enables organisations that create accounts on a receipts and payments basis to not only keep track of cash assets, but to also record other assets and liability balances.
Note: this report is only for organisations that create accounts on a receipts and payments basis. If you create accounts on an accruals basis, you will be able to view a balance sheet report instead.
Accessing this report
This report can be found within the financial reports screen of ExpensePlus, where the accounting basis for the organisation is set as 'receipts and payments' and the user that is viewing the reports menu has permission to view the report within their user role (find out more about user role permissions).
Cash Assets
ExpensePlus keeps track of the cash assets of each fund as you add and reconcile transactions.
Example: If the cash asset balance of a fund is £100 and a £50 income transaction is reconciled to that fund, the cash asset balance of that fund will increase to £150.
In order for the cash asset balance of your funds to display correctly, you simply need to:
- Ensure you've set your opening cash asset balances at the start of your first financial year using ExpensePlus
- Ensure you have uploaded and reconciled transactions correctly within the bank reconciliation module (and added any petty cash transactions if relevant as well).
IMPORTANT: In Fund Accounting, funds are not the same as bank accounts. If you are unsure what a fund is, check out this blog article or join us for our Essentials of Fund Accounting lunch & learn training session.
Other Asset & Liability Balances
The sections below the cash asset section within the report enable you to record other assets and liability balances. Typically, this would be done at the end of a financial year at the point you are closing your accounts for that year.
Example: If £2,300 of Gift Aid relating to your 2023 financial year doesn't get received into your bank until the next financial year (2024), then you would want to add this (as shown below).
IMPORTANT: Do ensure you have selected the correct financial year at the top of this report before entering amounts.
The notes fields in the report enable brief notes to be added where helpful (the notes field is optional).
Top Tip: when adding assets or liabilities balances, you only need to include amounts that are of 'material value'. Whilst there isn't a hard and fast rule for what constitutes an amount being of 'material value', for many charities, where an amount is over £500, then this would be included. You can, however, include amounts that are below 'material value', should you deem it appropriate to do so.
This report also displays the totals from the prior year as well.
Top Tip: within this screen, you can add opening balances which will then display in the 'prior year' column of the report (if you are viewing the first financial year).