1 |
Upgrade your system to the latest version and see
details of all upgrades by clicking
here. |
|
|
2 |
After you have upgraded your software to the latest
version and made a complete backup you will need to update your
SoFA and I&E Codes |
|
|
3 |
If you have retained the original code structure
supplied with the default system then ensure that you have downloaded
the code update files SOFAYEND.MRG
and CFYE2004.MRG
(April 2004)
For 2004 the only changes are to CTF06. New codes have been added
and subsequent codes on this page have their line numbers adjusted.
To comply with SORP 2005 you may need to
make some adjustments to your coding structure to account for
the changes in names on the SoFA and Balance Sheet, along with
adding a few new code.
|
|
If your browser opens the files above, rather than giving your the
option to save them to disk then please download
this zip file instead. |
|
If you have adjusted the coding structure then please
call us to discuss amendment of these files for automatic import
of data to your system. |
|
|
4. |
Income and Expenditure Codes |
|
|
a. |
From the main menu select the “Income and Expenditure
Codes” option. |
b. |
Run the option to “Import Year End Codes” from the
“Transfer Details” pull down menu |
c. |
Ensure that you import the file “CFYE2004.MRG” |
d. |
This routine will update the Income and Expenditure
Codes with the Notes pages and Row and Column details. |
|
|
5 |
SoFA Codes |
|
|
a |
From the main menu select the “S.o.F.A. Codes” option. |
b |
Run the option to “Enter SoFA Administration” from
the “Administration” pull down menu. |
c |
Run the option to “Import Year End Codes” from the
“Transfer Data” pull down menu. |
d |
Ensure that you import the file “SOFAYEND.MRG” |
e |
This routine will update the SoFA and Balance Sheet
Codes with the CTF pages and Row and Column details. |
|
|
|
|
|
|
|
|
|
|
|
YEAR END PROCEDURE |
|
|
|
W A R N I N G |
|
Before running automatic allocation routines (Dividends,
Administration etc.) and transfer to Excel routines please ensure
that all other programs running on you computer are closed down. |
|
|
|
Having updated your system with the appropriate Excel
Sheet and Row and Column details, either by the automatic import
procedure or by manually adjusting the details then the following
procedure will create your end of year spreadsheets. |
|
|
1 |
From the main menu select the “S.o.F.A. Codes” option. |
2 |
Transfer Date Pull down menu |
3 |
Transfer from Accounts to SoFA |
4 |
Select all records (Enter selections if you need to
adjust the data) |
5 |
Transfer Data |
6 |
Do you want to clear the brought forward balances
Yes No (Click no unless you are running the system for multiple
groups. |
|
|
7 |
If unbalanced transactions are reported then to correct
the data use the Funds and Accounts Screen |
|
|
8 |
Reports Pull down Menu |
9 |
Unbalanced Control Transaction Splits. |
|
|
|
To enter the brought forward
details for all SoFA accounts |
|
|
10 |
From the main menu select the “S.o.F.A. Codes” option. |
11 |
Administration |
12 |
Enter SoFA administration |
13 |
Enter brought forward values for all SoFA accounts
that do not already have brought forward values entered. |
14 |
Quit out of the Administration Screen to return to
the SOFA Codes Screen |
|
|
15 |
Excel SoFA/Balance Sheet button |
16 |
Load Excel |
17 |
Create Spreadsheet (confirm all Excel messages
by clicking on Yes)
You may need to re-run this option if you did not confirm the
Excel messages fast enough |
18 |
Quit |
|
|
19 |
Income and Expenditure Codes |
20 |
Transfer Details |
21 |
Transfer from CFunds to Notes |
22 |
Select all records (Enter selections if you need to
adjust the data) |
23 |
Transfer Data |
|
|
24 |
Load Excel (Unless already loaded) |
25 |
Create Spreadsheet (confirm all Excel messages by
clicking on Yes)
You may need to re-run this option if you did not confirm the Excel
messages fast enough |
26 |
Quit |