Not-for-Profit entity opening balance work sheet
Information from the old system (or spreadsheet) will be required for the the last day of the prior year; the opening balance date.
Use any of the work sheets that are relevant. Each is related to a part of the opening balance control panel.
NOTE: The user may print a hard copy of this check list by clicking on the green PRINT button.
work sheet - tangible fixed assets(for use by the charity)
| Asset |
Fund |
Cost |
Cumulative depreciation |
Net Value |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
work sheet - tangible fixed asset investments
| Investment |
Fund |
Cost |
Cumulative depreciation |
Net Value |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
work sheet - customer invoices
| Customer |
Ref. No |
Date |
Payment due |
Amount |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
work sheet - supplier bills
| Supplier |
Ref. No |
Date |
Payment due |
Amount |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
For other asset and liability balances the opening balance control panel has data entry blocks of
- Asset balances
- Liability balances
If an account does not exist but is needed for data from the old system add from either the system accounts of set up a custom account.
For more information see Chart of Accounts
work sheet - asset balances
| Account |
Amount |
Fund |
| Long term investments |
|
|
| Asset disposals |
leave blank if the account exists |
|
| Gift aid pending |
|
|
| Loans to staff |
|
|
| Short term investments |
|
|
work sheet - liability balances
| Account |
Amount |
Fund |
| Asset additions |
leave blank if the account exists |
|
Payroll liabilities
- Attachments and other court orders
- Class 1A NIC
- Employee NI
- Employer NI
- Expense claims
- Misc payroll deductions
- PAYE
- Pensions
- Student loan repayments
- Wages and salaries
|
|
| Sales deposits received |
|
Funds
- Fund 1
- Fund 2
- Fund 3
- Fund 4
- Fund 5
- Fund 6
- Fund 7
|
|