Audit Preparation Guide

Last modified by Megan Kahl on 2022/08/02 12:41

AUDIT PREPARATION GUIDE

Audit Preparation Guide_html_8cba33b1e8c9fa24.gif

TABLE OF CONTENTS

Introduction

Numerous reports are required for the Audit of a Fund. This document has been prepared to aid the User in generating the relevant Audit reports required from the Everest System.

The process of generating reports, documented under “Reporting” in the next section, has been illustrated by means of screen shots for the first report only. All subsequent reports follow the same process and duplication of the screen shots is not essential.

Prior to commencing with the Year End preparation, the following points must be considered: -

Audit reports generated will only be accurate should all accounting transactions be linked on the Everest System. The linking of transactions is performed via the Bank Reconciliation. Correct linking ensures that all Bank Statement items correlate to the Cashbook (database) entries generated via the system. Refer to the “Bank Reconciliation Process” document for instructions on how to link transactions.

In this regard, a “Parent Bank Statement Link Report – unmatched” report can be generated to reflect which entries have not yet been linked. Any unlinked items should be questioned prior to commencement of the Audit preparation.

Ensure that all contributions have been updated to the specific Audit date.

Ensure that the financial period is locked. Once locked, no further accounting transactions will be reflected in this period. The process of locking the financial period is as follows: -

Lock Financial Period

Ensure that the correct Parent has been selected in Everest. Go to the Client Menu and select “Details”.

Click on the “Edit” button. Under the Legislation component of the screen, take special note of the following:

Last Audit Click drop down to access calendar option and select the Financial Year End Date for which all accounting transactions will be locked.

Click the “Save” button to commit changes made to Last Audit date.

IMPORTANT NOTES

By locking the Last Audit Date, all Financial transactions processed for a period prior to this Last Audit date will be reflected in the Accounting System one day after this cut off date.

All reports must be generated whilst the system is locked. The system must be unlocked for year end journals and should be relocked immediately thereafter. Always ensure that NO accounting transactions are performed, that would have an impact on the year end, during the time the system is unlocked.

Reporting

Report Name: Parent Trial Balance - Ledgers

The first report generated is the Parent Trial Balance – Ledgers (General Ledger Report).

Ensure that the correct Parent has been selected in Everest. Go to the Batches Menu and select “Batch Management”.

Complete the following search criteria at the bottom of the screen:-

Batch Type Go to the drop down list and select “All”

Batch Go to the drop down list, search and select “Parent Trial Balance - Ledgers”

Click the “New Batch” button.

Double click on the edit hyperlink in the Batch Management Working Screen area.

Click on the “Edit” button under batch editor screen and complete the following variables:-

Date 1 Enter the First day of the Financial Year

Date 2 Enter the Last day of the Financial Year

Client Parent Select the Parent from the drop down list

Click the “Save” and “Execute” buttons to generate “Parent Trial Balance - Ledgers”.

The next few pages details an example of the report that is generated. You will see ledger contains the information of all transactions for the selected period.

ABC Consultants and Actuaries Administrators (Pty) Ltd

Audit Preparation Guide_html_ee9e335d03ac4cd0.png

FUND - Test (Pty) Ltd

PREPARED BY - Txxxxx (Date - 24/08/2007 10:31:18 AM)

TRIAL BALANCE FROM 01 January 2006 TO 31 December 2006

Dates	Entry	Reference	Description	Bank Reference	Debit	Credit
	3000/2-54		Risk Premiums/Risk Premiums-Funeral Cover		4,244.00
	3010/228		Expenses/Foreign Asset Allocation		4,229.40
	3010/3-2		Expenses/Expenses- Administration ABC Administrators		174,337.96
	3010/3-3160		Expenses/Expenses- Management Expense ABC C&A		96,736.85
	3010/94		Expenses/FSB Levies		3,380.60
	3030/29-1		Member Exits/Exit Payment-Withdrawal - Resignation		4,755.50
	3030/29-3		Member Exits/Exit Payment-Withdrawal - Transfer		1,183,766.40
	3030/29-Undefined		Member Exits/Exit Payment-Undefined			610,967.05
	3040/21		Bank Fees/Service Fees		890.00
	3070/117		Third Party Payments/Surplus Distribution		43,006.50
	3070/95		Third Party Payments/Fidelity Guarantee Insurance		12,090.00
	3210/107		Audit Fees/Audit Fees		42,978.00
	3400/30		Retirement Funds Tax/RFT		133,722.28
	4000/1		Contribution Income/Gross Contribution Income			6,080,703.16
	4010/112		Investment Income/Investment Management Fees		359,950.20
	4010/18		Investment Income/Investment Income			7,404,074.43
	4020/32		Transfer In/Gross Single Premiums - Capital Portion			206,471.34
	4020/35		Transfer In/Gross Single Premiums - Interest Portion			715,728.16
	4030/18		Interest Income/Investment Income			40,015.32
			Net Change in Accumulated Fund		12,993,871.77
					_______________	_______________
	Net Total				15,057,959.46	15,057,959.46
					_______________	_______________
			Net Change in Accumulated Fund			12,993,871.77
	4430/90		Accumulated Funds/Opening			86,196,787.38
	2000/107		Creditors/Audit Fees			45,604.00
	2000/30		Creditors/RFT			12,756.74
	2000/84		Creditors/Pay Creditor			82,909.62
	2000/93		Creditors/RSC Levies			135.44
	2000/94		Creditors/FSB Levies			1,173.32
	1020/5		Contributions Receivable			79,740.35
	2000/2-53		Creditors/Risk Premiums-PHI			0.10
	2000/2-54		Creditors/Risk Premiums-Funeral Cover		324.20
	2000/3-2		Creditors/Expenses- Administration ABC Administrators		99.00
	2000/3-3160		Creditors/Expenses- Management Expense ABC C&A			29,477.79
	2000/29		Benefits Due		488,874.26
	1010/85		Investments/Fund Bank Account		772,198.60
	1010/526		Investments/Policy 15		1,590,983.35
	1010/113		Investments/Policy 18			452,251.48
	1010/650		Investments/Policy 21		4,586,811.08
	1010/118		Investments/Policy 5		7,727,119.76
	1010/202		Investments/Policy 8		84,728,297.74
	Total				99,894,707.99	99,894,707.99

	Final		Closing Accumulated Funds			99,190,659.15
	Final		Closing Reserve Accounts		0.00	0.00

	4090/90		Reserve Accounts/Opening
01/01/2006	Opening Balance
	Account Total	4090/90	Reserve Accounts/Opening

	4430/90		Accumulated Funds/Opening
01/01/2006	Opening Balance					86,196,787.38
	Account Total	4430/90	Accumulated Funds/Opening			86,196,787.38

	3000/2-54		Risk Premiums/Risk Premiums-Funeral Cover

31/01/2006	Gen Jrnl	0000 0030 0722	Funeral Cover		382.59
28/02/2006	Gen Jrnl	0000 0041 4013	Funeral Cover		379.32
31/03/2006	Gen Jrnl	0000 0033 0471	Funeral Cover		379.32
30/04/2006	Gen Jrnl	0000 0047 2186	Funeral Cover		376.05
31/05/2006	Gen Jrnl	0000 0036 3295	Funeral Cover		376.05
30/06/2006	Gen Jrnl	0000 0037 7786	Funeral Cover		376.05
31/07/2006	Gen Jrnl	0000 0039 7293	Funeral Cover		382.59
31/08/2006	Gen Jrnl	0000 0041 9978	Funeral Cover		382.59
30/09/2006	Gen Jrnl	0000 0043 5533	Funeral Cover		376.05
31/10/2006	Gen Jrnl	0000 0045 8212	Funeral Cover		382.59
30/11/2006	Gen Jrnl	0000 0047 4726	Funeral Cover		450.80

	Account Total	3000/2-54	Risk Premiums/Risk Premiums-Funeral Cover		4,244.00



	3010/189		Expenses/Commission Payment

24/01/2006	Gen Jrnl	0000 0029 2930	Administration ABC Administrators		79,632.31
24/01/2006	Gen Jrnl	0000 0029 2956	Reverse			79,632.31

	Account Total	3010/189	Expenses/Commission Payment



	3010/228		Expenses/Foreign Asset Allocation

03/08/2006	Gen Jrnl	0000 0039 4516	IN116929		2,114.70
07/11/2006	Gen Jrnl	0000 0045 1330	IN117019		2,114.70

	Account Total	3010/228	Expenses/Foreign Asset Allocation		4,229.40



	3010/3-2		Expenses/Expenses- Administration ABC Administrators

31/01/2006	Gen Jrnl	0000 0030 0722	Administration ABC Administrators		15,880.59
28/02/2006	Gen Jrnl	0000 0041 4013	Administration ABC Administrators		15,741.19
31/03/2006	Gen Jrnl	0000 0033 0471	Administration ABC Administrators		15,741.19
30/04/2006	Gen Jrnl	0000 0047 2186	Administration ABC Administrators		15,741.19
31/05/2006	Gen Jrnl	0000 0036 3295	Administration ABC Administrators		15,741.19
30/06/2006	Gen Jrnl	0000 0037 7786	Administration ABC Administrators		15,741.19
31/07/2006	Gen Jrnl	0000 0039 7293	Administration ABC Administrators		15,969.66
31/08/2006	Gen Jrnl	0000 0041 9978	Administration ABC Administrators		16,043.56
30/09/2006	Gen Jrnl	0000 0043 5533	Administration ABC Administrators		15,866.45
31/10/2006	Gen Jrnl	0000 0045 8212	Administration ABC Administrators		15,956.21
30/11/2006	Gen Jrnl	0000 0047 4726	Administration ABC Administrators		15,915.54

	Account Total	3010/3-2	Expenses/Expenses- Administration ABC Administrators		174,337.96



	3010/3-3160		Expenses/Expenses- Management Expense ABC C&A

31/01/2006	Gen Jrnl	0000 0030 0722	Management Expense ABC C&A		8,811.16
28/02/2006	Gen Jrnl	0000 0041 4013	Management Expense ABC C&A		8,754.98
31/03/2006	Gen Jrnl	0000 0033 0471	Management Expense ABC C&A		8,754.98
30/04/2006	Gen Jrnl	0000 0047 2186	Management Expense ABC C&A		8,754.98
31/05/2006	Gen Jrnl	0000 0036 3295	Management Expense ABC C&A		8,754.98
30/06/2006	Gen Jrnl	0000 0037 7786	Management Expense ABC C&A		8,754.98
31/07/2006	Gen Jrnl	0000 0039 7293	Management Expense ABC C&A		8,838.70
31/08/2006	Gen Jrnl	0000 0041 9978	Management Expense ABC C&A		8,864.93
30/09/2006	Gen Jrnl	0000 0043 5533	Management Expense ABC C&A		8,800.36
31/10/2006	Gen Jrnl	0000 0045 8212	Management Expense ABC C&A		8,829.58
30/11/2006	Gen Jrnl	0000 0047 4726	Management Expense ABC C&A		8,817.22

	Account Total	3010/3-3160	Expenses/Expenses- Management Expense ABC C&A		96,736.85



	3010/94		Expenses/FSB Levies

01/01/2006	Gen Jrnl	0000 0024 5846	Administration ABC Administrators			1,435.00
03/04/2006	Gen Jrnl	0000 0032 5482	Administration ABC Administrators		1,435.00
29/06/2006	Gen Jrnl	0000 0037 1934	Registration fees		1,473.00
02/10/2006	Gen Jrnl	0000 0043 0066	IN000152557		1,622.60
03/10/2006	Gen Jrnl	0000 0043 0127	IN000152558		285.00

	Account Total	3010/94	Expenses/FSB Levies		3,380.60



	3030/29-1		Member Exits/Exit Payment-Withdrawal - Resignation

31/08/2006	Cash Book	40534	R K SXXXXXX	17467	4,755.50

	Account Total	3030/29-1	Member Exits/Exit Payment-Withdrawal - Resignation		4,755.50



	3030/29-3		Member Exits/Exit Payment-Withdrawal - Transfer

31/01/2006	Cash Book	30973	R Itxxxxx	12377	416,916.77
31/08/2006	Gen Jrnl	0000 0042 0797	Jwa Vxxxxxx		135,773.03
31/10/2006	Cash Book	45461	Axxxxxx Kxxxxx	19709	631,076.60

	Account Total	3030/29-3	Member Exits/Exit Payment-Withdrawal - Transfer		1,183,766.40



	3030/29-Undefined		Member Exits/Exit Payment-Undefined

01/01/2006	Gen Jrnl	0000 0018 4334	N Wxxxxxx			610,967.05

	Account Total	3030/29-Undefined	Member Exits/Exit Payment-Undefined			610,967.05



	3040/21		Bank Fees/Service Fees

21/01/2006	Cash Book	28400	Service Fees		40.00
21/02/2006	Cash Book	29689	Service Fees		40.00
20/03/2006	Cash Book	30977	Service Fees		40.00
21/04/2006	Cash Book	32625	Service Fees		40.00
20/05/2006	Cash Book	33849	Service Fees		40.00
21/06/2006	Cash Book	35599	Bank charges		40.00
21/07/2006	Cash Book	37144	Bank charges		40.00
21/08/2006	Cash Book	38838	Bank charges		40.00
21/09/2006	Cash Book	40533	Bank charges		40.00
29/09/2006	Cash Book	40537	Bank charges		450.00
21/10/2006	Cash Book	42314	Oct 06 Bank Charges		40.00
21/11/2006	Cash Book	44268	Nov 06 Bank Charges		40.00

	Account Total	3040/21	Bank Fees/Service Fees		890.00



	3070/117		Third Party Payments/Surplus Distribution

24/03/2006	Gen Jrnl	0000 0032 1595	Surplus Distribution		43,006.50

	Account Total	3070/117	Third Party Payments/Surplus Distribution		43,006.50



	3070/95		Third Party Payments/Fidelity Guarantee Insurance

12/10/2006	Gen Jrnl	0000 0043 4803	39036		12,090.00

	Account Total	3070/95	Third Party Payments/Fidelity Guarantee Insurance		12,090.00



	3210/107		Audit Fees/Audit Fees

05/12/2006	Gen Jrnl	0000 0046 9965	Audit fee for year ended 31/12/2005		42,978.00

	Account Total	3210/107	Audit Fees/Audit Fees		42,978.00



	3400/30		Retirement Funds Tax/RFT

23/03/2006	Gen Jrnl	0000 0032 0969	RFT		62,550.77
30/05/2006	Gen Jrnl	0000 0035 3769	RFT		6,631.89
30/05/2006	Gen Jrnl	0000 0035 3770	RFT		39,003.50
21/09/2006	Gen Jrnl	0000 0042 3773	RFT		4,022.91
29/11/2006	Gen Jrnl	0000 0046 6585	RFT		21,513.21

	Account Total	3400/30	Retirement Funds Tax/RFT		133,722.28



	4000/1		Contribution Income/Gross Contribution Income

31/01/2006	Gen Jrnl	0000 0030 0722	Employer Portion			554,311.84
28/02/2006	Gen Jrnl	0000 0041 4013	Employer Portion			549,192.96
31/03/2006	Gen Jrnl	0000 0033 0471	Employer Portion			549,192.96
30/04/2006	Gen Jrnl	0000 0047 2186	Employer Portion			549,189.69
31/05/2006	Gen Jrnl	0000 0036 3295	Employer Portion			549,189.79
30/06/2006	Gen Jrnl	0000 0037 7786	Employer Portion			549,189.79
31/07/2006	Gen Jrnl	0000 0039 7293	Employer Portion			556,850.93
31/08/2006	Gen Jrnl	0000 0041 9978	Employer Portion			559,254.69
30/09/2006	Gen Jrnl	0000 0043 5533	Employer Portion			553,338.72
31/10/2006	Gen Jrnl	0000 0045 8212	Employer Portion			556,030.79
30/11/2006	Gen Jrnl	0000 0047 4726	Employer Portion			554,961.00

	Account Total	4000/1	Contribution Income/Gross Contribution Income			6,080,703.16



	4010/112		Investment Income/Investment Management Fees

31/01/2006	Gen Jrnl	0000 0039 6936	Policy 8		50,553.41
28/02/2006	Gen Jrnl	0000 0039 6942	Policy 8		45,697.72
31/03/2006	Gen Jrnl	0000 0039 6947	Policy 8		51,686.44
30/04/2006	Gen Jrnl	0000 0039 6977	Policy 8		47,988.27
31/05/2006	Gen Jrnl	0000 0039 7388	Policy 15		209.33
31/05/2006	Gen Jrnl	0000 0039 7335	Policy 8		57,429.62
30/06/2006	Gen Jrnl	0000 0039 7480	Policy 15		285.81
30/06/2006	Gen Jrnl	0000 0039 7444	Policy 8		51,401.71
31/07/2006	Gen Jrnl	0000 0039 7465	Policy 8		54,397.99
31/07/2006	Gen Jrnl	0000 0039 7503	Policy 15		299.90

	Account Total	4010/112	Investment Income/Investment Management Fees		359,950.20


	4010/18		Investment Income/Investment Income

01/01/2006	Gen Jrnl	0000 0047 4681	Policy 5		820,537.38
31/01/2006	Gen Jrnl	0000 0039 6933	Policy 8			4,584,447.83
28/02/2006	Gen Jrnl	0000 0039 6940	Policy 8		394,778.82
31/03/2006	Gen Jrnl	0000 0039 6946	Policy 8			3,671,379.40
30/04/2006	Gen Jrnl	0000 0039 6973	Policy 8			1,345,884.08
31/05/2006	Gen Jrnl	0000 0039 7391	Policy 15			2.10
31/05/2006	Gen Jrnl	0000 0039 7393	Policy 15		7,254.58
31/05/2006	Gen Jrnl	0000 0039 7359	Policy 8		1,322,392.89
31/05/2006	Gen Jrnl	0000 0039 7368	Policy 8			256.44
30/06/2006	Gen Jrnl	0000 0039 7446	Policy 8			483,878.60
30/06/2006	Gen Jrnl	0000 0039 7486	Policy 15			12.21
31/07/2006	Gen Jrnl	0000 0039 7507	Policy 15		1,004.37
31/07/2006	Gen Jrnl	0000 0039 7454	Policy 8			1,656.99
31/07/2006	Gen Jrnl	0000 0039 7456	Policy 8		137,488.75
31/07/2006	Gen Jrnl	0000 0039 7502	Policy 15			13.57

	Account Total	4010/18	Investment Income/Investment Income			7,404,074.43



	4020/32		Transfer In/Gross Single Premiums - Capital Portion

01/01/2006	Gen Jrnl	0000 0047 4557	Gross Single Premiums - Capital Portion			87,332.68
01/01/2006	Gen Jrnl	0000 0047 4971	Gross Single Premiums - Capital Portion			103,127.71
01/01/2006	Gen Jrnl	0000 0047 5141	Gross Single Premiums - Capital Portion			16,010.95

	Account Total	4020/32	Transfer In/Gross Single Premiums - Capital Portion			206,471.34



	4020/35		Transfer In/Gross Single Premiums - Interest Portion

01/01/2006	Gen Jrnl	0000 0047 4557	Gross Single Premiums - Interest Portion			280,953.22
01/01/2006	Gen Jrnl	0000 0047 4971	Gross Single Premiums - Interest Portion			4,521.73
30/06/2006	Gen Jrnl	0000 0047 5058	Gross Single Premiums - Interest Portion			163,502.14
30/06/2006	Gen Jrnl	0000 0047 5186	Gross Single Premiums - Interest Portion			76,774.09
31/10/2006	Gen Jrnl	0000 0047 5079	Gross Single Premiums - Interest Portion			137,220.94
31/10/2006	Gen Jrnl	0000 0047 5203	Gross Single Premiums - Interest Portion			52,756.04

	Account Total	4020/35	Transfer In/Gross Single Premiums - Interest Portion			715,728.16



	4030/18		Interest Income/Investment Income

03/01/2006	Cash Book	27927	interest	3870000		9,579.35
11/01/2006	Cash Book	28395	Interest Adjustment		402.09
01/02/2006	Cash Book	29330	Interest	3870000		2,614.49
02/03/2006	Cash Book	30297	Interest	3870000		1,438.25
01/04/2006	Cash Book	31959	Investment Income	3870000		1,723.85
02/05/2006	Cash Book	33207	Interest	3870000		1,724.69
01/06/2006	Cash Book	34885	Investment Income	3870000		2,454.50
01/07/2006	Cash Book	36449	Interest received	3870000		2,920.55
01/08/2006	Cash Book	38057	Interest received	3870000		2,362.41
01/09/2006	Cash Book	39616	Interest received	3870000		2,701.11
02/10/2006	Cash Book	41627	Interest on credit balance	3870000		3,122.25
01/11/2006	Cash Book	43449	Nov 06 Interest	3870000		3,158.38
01/12/2006	Cash Book	45460	Dec 06 Bank Interest	3870000		6,617.58

	Account Total	4030/18	Interest Income/Investment Income			40,015.32



	1020/81		Debtors/Risk Lumpsum Recovery

01/01/2006	Opening Balance
	Account Total	1020/81	Debtors/Risk Lumpsum Recovery



	2000/107		Creditors/Audit Fees

01/01/2006	Opening Balance					70,000.00
27/03/2006	Cash Book	30980	Audit Fees	12880	24,396.00
05/12/2006	Gen Jrnl	0000 0046 9965	_Bank (Test (Pty) Ltd)			42,978.00
05/12/2006	Cash Book	45468	Audit Fees	19754	42,978.00
	Account Total	2000/107	Creditors/Audit Fees			45,604.00



	2000/117		Creditors/Surplus Distribution

01/01/2006	Opening Balance
24/03/2006	Gen Jrnl	0000 0032 1595	_Bank (Test (Pty) Ltd)			43,006.50
27/03/2006	Gen Jrnl	0000 0035 2908	Surplus Distribution		43,006.50
	Account Total	2000/117	Creditors/Surplus Distribution



	2000/189		Creditors/Commission Payment

01/01/2006	Opening Balance
24/01/2006	Gen Jrnl	0000 0029 2930	_Bank (Test (Pty) Ltd)			79,632.31
24/01/2006	Cash Book	28401	Commission Payment	11591	79,632.31
24/01/2006	Gen Jrnl	0000 0029 2959	realloaction of paym			79,632.31
24/01/2006	Gen Jrnl	0000 0029 2956	Reverse		79,632.31
	Account Total	2000/189	Creditors/Commission Payment



	2000/228		Creditors/Foreign Asset Allocation

01/01/2006	Opening Balance					6,344.10
27/03/2006	Cash Book	30979	Foreign Asset Allocation	12879	43,006.50
27/03/2006	Gen Jrnl	0000 0035 2908	Foreign Asset Allocation			43,006.50
05/05/2006	Cash Book	33844	Foreign Asset Allocation	13741	6,344.10
03/08/2006	Gen Jrnl	0000 0039 4516	_Bank (Test (Pty) Ltd)			2,114.70
03/08/2006	Cash Book	38058	Foreign Asset Allocation	16133	2,114.70
07/11/2006	Gen Jrnl	0000 0045 1330	_Bank (Test (Pty) Ltd)			2,114.70
07/11/2006	Cash Book	44260	Foreign Asset Allocation	18791	2,114.70
	Account Total	2000/228	Creditors/Foreign Asset Allocation



	2000/30		Creditors/RFT

01/01/2006	Opening Balance					12,756.74
23/03/2006	Gen Jrnl	0000 0032 0969	_Bank (Test (Pty) Ltd)			62,550.77
23/03/2006	Cash Book	30978	RFT	12737	62,550.77
30/05/2006	Gen Jrnl	0000 0035 3769	_Bank (Test (Pty) Ltd)			6,631.89
30/05/2006	Gen Jrnl	0000 0035 3770	_Bank (Test (Pty) Ltd)			39,003.50
30/05/2006	Cash Book	33852	RFT	14232	6,631.89
30/05/2006	Cash Book	33853	RFT	14313	39,003.50
21/09/2006	Gen Jrnl	0000 0042 3773	_Bank (Test (Pty) Ltd)			4,022.91
21/09/2006	Cash Book	40532	RFT	17349	4,022.91
29/11/2006	Gen Jrnl	0000 0046 6585	_Bank (Test (Pty) Ltd)			21,513.21
29/11/2006	Cash Book	44269	RFT	19594	21,513.21
	Account Total	2000/30	Creditors/RFT			12,756.74



	2000/84		Creditors/Pay Creditor

01/01/2006	Opening Balance					82,909.62
	Account Total	2000/84	Creditors/Pay Creditor			82,909.62



	2000/93		Creditors/RSC Levies

01/01/2006	Opening Balance					135.44
	Account Total	2000/93	Creditors/RSC Levies			135.44



	2000/94		Creditors/FSB Levies

01/01/2006	Opening Balance					1,173.32
01/01/2006	Gen Jrnl	-8672863	_Bank (Test (Pty) Ltd)		1,435.00
01/01/2006	Cash Book	32623	FSB Levies	13230		1,435.00
03/04/2006	Gen Jrnl	0000 0032 5482	_Bank (Test (Pty) Ltd)			1,435.00
03/04/2006	Cash Book	32621	FSB Levies	17	1,435.00
29/06/2006	Gen Jrnl	0000 0037 1934	_Bank (Test (Pty) Ltd)			1,473.00
29/06/2006	Cash Book	35606	FSB Levies	15108	1,473.00
02/10/2006	Gen Jrnl	0000 0043 0066	_Bank (Test (Pty) Ltd)			1,622.60
03/10/2006	Gen Jrnl	0000 0043 0127	_Bank (Test (Pty) Ltd)			285.00
03/10/2006	Cash Book	41629	FSB Levies	17761	1,622.60
03/10/2006	Cash Book	41630	FSB Levies	17762	285.00
	Account Total	2000/94	Creditors/FSB Levies			1,173.32



	2000/95		Creditors/Fidelity Guarantee Insurance

01/01/2006	Opening Balance
12/10/2006	Gen Jrnl	0000 0043 4803	_Bank (Test (Pty) Ltd)			12,090.00
12/10/2006	Cash Book	42309	Fidelity Guarantee Insurance	17850	12,090.00
	Account Total	2000/95	Creditors/Fidelity Guarantee Insurance



	1020/5		Contributions Receivable

01/01/2006	Opening Balance		Contributions		423,311.98
03/01/2006	Cash Book	27926	Contributions			26,242.60
07/01/2006	Cash Book	27928	Contributions			100,000.00
07/01/2006	Cash Book	27929	Contributions			100,000.00
07/01/2006	Cash Book	27930	Contributions			100,000.00
07/01/2006	Cash Book	27931	Contributions			99,084.01
09/01/2006	Cash Book	28394	Contributions			24,227.97
30/01/2006	Cash Book	28403	Contributions	9802263		77,091.35
30/01/2006	Cash Book	28404	Contributions	9802263		5,256.68
31/01/2006	Gen Jrnl	0000 0030 0722	Contributions		554,311.84
06/02/2006	Cash Book	29331	Contributions	2		25,981.08
07/02/2006	Cash Book	29332	Contributions			24,227.97
07/02/2006	Cash Book	29333	Contributions			100,000.00
07/02/2006	Cash Book	29334	Contributions			100,000.00
07/02/2006	Cash Book	29335	Contributions			100,000.00
07/02/2006	Cash Book	29336	Contributions			26,795.15
07/02/2006	Cash Book	29337	Contributions			100,000.00
28/02/2006	Cash Book	29690	Contributions	69802263		77,091.35
28/02/2006	Cash Book	29691	Contributions	69802263		5,256.68
28/02/2006	Gen Jrnl	0000 0041 4013	Contributions		549,192.96
07/03/2006	Cash Book	30298	Contributions			20,675.27
07/03/2006	Cash Book	30299	Contributions			24,227.97
07/03/2006	Cash Book	30300	Contributions			100,000.00
07/03/2006	Cash Book	30301	Contributions			100,000.00
07/03/2006	Cash Book	30302	Contributions			100,000.00
07/03/2006	Cash Book	30303	Contributions			24,534.24
07/03/2006	Cash Book	30304	Contributions			100,000.00
09/03/2006	Cash Book	30972	Contributions			2,214.00
30/03/2006	Cash Book	30981	Contributions	9802263		77,091.35
30/03/2006	Cash Book	30982	Contributions	9802263		5,256.68
31/03/2006	Gen Jrnl	0000 0033 0471	Contributions		549,192.96
04/04/2006	Cash Book	31960	Contributions			20,675.27
06/04/2006	Cash Book	31961	Contributions			100,000.00
06/04/2006	Cash Book	31962	Contributions			100,000.00
06/04/2006	Cash Book	31963	Contributions			100,000.00
06/04/2006	Cash Book	31964	Contributions			26,748.24
06/04/2006	Cash Book	31965	Contributions			100,000.00
07/04/2006	Cash Book	31966	Contributions			24,227.97
28/04/2006	Cash Book	32626	Contributions			5,256.68
28/04/2006	Cash Book	32627	Contributions	9802263		77,091.35
30/04/2006	Gen Jrnl	0000 0047 2186	Contributions		549,189.69
05/05/2006	Cash Book	33208	Contributions			20,675.27
06/05/2006	Cash Book	33209	Contributions			24,227.97
06/05/2006	Cash Book	33210	Contributions			100,000.00
06/05/2006	Cash Book	33211	Contributions			100,000.00
06/05/2006	Cash Book	33212	Contributions			100,000.00
06/05/2006	Cash Book	33213	Contributions			26,748.24
06/05/2006	Cash Book	33214	Contributions			100,000.00
30/05/2006	Cash Book	33850	Contributions			77,091.35
30/05/2006	Cash Book	33851	Contributions			5,256.68
31/05/2006	Gen Jrnl	0000 0036 3295	Contributions		549,189.79
06/06/2006	Cash Book	34886	Contributions			100,000.00
06/06/2006	Cash Book	34887	Contributions			100,000.00
06/06/2006	Cash Book	34888	Contributions			100,000.00
06/06/2006	Cash Book	34889	Contributions			22,888.24
06/06/2006	Cash Book	34890	Contributions			100,000.00
07/06/2006	Cash Book	34891	Contributions			20,675.27
07/06/2006	Cash Book	34892	Contributions			24,227.97
08/06/2006	Cash Book	35598	Contributions			3,860.00
29/06/2006	Cash Book	35604	Contributions			77,091.35
29/06/2006	Cash Book	35605	Contributions			5,256.68
30/06/2006	Gen Jrnl	0000 0037 7786	Contributions		549,189.79
06/07/2006	Cash Book	36450	Contributions	22		20,675.27
06/07/2006	Cash Book	36451	Contributions			100,000.00
06/07/2006	Cash Book	36452	Contributions			100,000.00
06/07/2006	Cash Book	36453	Contributions			100,000.00
06/07/2006	Cash Book	36454	Contributions			26,748.25
06/07/2006	Cash Book	36455	Contributions			100,000.00
07/07/2006	Cash Book	36456	Contributions			24,227.97
31/07/2006	Cash Book	37145	Contributions			77,091.35
31/07/2006	Cash Book	37146	Contributions			5,256.68
31/07/2006	Gen Jrnl	0000 0039 7293	Contributions		556,850.93
07/08/2006	Cash Book	38059	Contributions			21,079.01
07/08/2006	Cash Book	38060	Contributions			24,227.97
07/08/2006	Cash Book	38061	Contributions			100,000.00
07/08/2006	Cash Book	38062	Contributions			100,000.00
07/08/2006	Cash Book	38063	Contributions			100,000.00
07/08/2006	Cash Book	38064	Contributions			34,110.47
07/08/2006	Cash Book	38065	Contributions			100,000.00
31/08/2006	Cash Book	38839	Contributions			77,091.35
31/08/2006	Cash Book	38840	Contributions			5,256.68
31/08/2006	Gen Jrnl	0000 0041 9978	Contributions		559,254.69
06/09/2006	Cash Book	39617	Contributions			100,000.00
06/09/2006	Cash Book	39618	Contributions			100,000.00
06/09/2006	Cash Book	39619	Contributions			100,000.00
06/09/2006	Cash Book	39620	Contributions			34,110.47
06/09/2006	Cash Book	39621	Contributions			100,000.00
07/09/2006	Cash Book	39622	Contributions			22,213.21
07/09/2006	Cash Book	39623	Contributions			25,526.01
28/09/2006	Cash Book	40535	Contributions	9802263		5,256.68
28/09/2006	Cash Book	40536	Contributions	9812263		77,091.35
30/09/2006	Gen Jrnl	0000 0043 5533	Contributions		553,338.72
06/10/2006	Cash Book	41631	Contributions			22,213.21
06/10/2006	Cash Book	41632	Contributions			25,526.01
06/10/2006	Cash Book	41633	Contributions			100,000.00
06/10/2006	Cash Book	41634	Contributions			100,000.00
06/10/2006	Cash Book	41635	Contributions			100,000.00
06/10/2006	Cash Book	41636	Contributions			28,334.79
06/10/2006	Cash Book	41637	Contributions			100,000.00
30/10/2006	Cash Book	42315	Contributions	9802263		77,091.35
30/10/2006	Cash Book	42316	Contributions	9802263		5,256.68
31/10/2006	Gen Jrnl	0000 0045 8212	Contributions		556,030.79
06/11/2006	Cash Book	43451	Contributions			100,000.00
06/11/2006	Cash Book	43452	Contributions			100,000.00
06/11/2006	Cash Book	43453	Contributions			100,000.00
06/11/2006	Cash Book	43454	Contributions			27,397.47
06/11/2006	Cash Book	43455	Contributions			100,000.00
06/11/2006	Cash Book	43456	Contributions			3,227.10
07/11/2006	Cash Book	43457	Contributions			22,213.21
07/11/2006	Cash Book	43458	Contributions			25,526.01
30/11/2006	Cash Book	44270	Contributions			77,093.30
30/11/2006	Cash Book	44271	Contributions			5,257.33
30/11/2006	Gen Jrnl	0000 0047 4726	Contributions		554,961.00
06/12/2006	Cash Book	45462	Contributions			100,000.00
06/12/2006	Cash Book	45463	Contributions			100,000.00
06/12/2006	Cash Book	45464	Contributions			100,000.00
06/12/2006	Cash Book	45465	Contributions			26,253.82
06/12/2006	Cash Book	45466	Contributions			100,000.00
06/12/2006	Cash Book	45467	Contributions			3,227.75
07/12/2006	Cash Book	45469	Contributions			22,391.95
07/12/2006	Cash Book	45470	Contributions			25,529.91
	Account Total	1020/5	Contributions Receivable			79,740.35



	2000/2		Creditors/Risk Premiums

01/01/2006	Opening Balance
	Account Total	2000/2	Creditors/Risk Premiums



	2000/2-50		Creditors/Risk Premiums-Approved Group Life Scheme

01/01/2006	Opening Balance
	Account Total	2000/2-50	Creditors/Risk Premiums-Approved Group Life Scheme



	2000/2-51		Creditors/Risk Premiums-Capital Disability

01/01/2006	Opening Balance
	Account Total	2000/2-51	Creditors/Risk Premiums-Capital Disability



	2000/2-52		Creditors/Risk Premiums-Spouses Cover

01/01/2006	Opening Balance
	Account Total	2000/2-52	Creditors/Risk Premiums-Spouses Cover



	2000/2-53		Creditors/Risk Premiums-PHI

01/01/2006	Opening Balance					0.10
	Account Total	2000/2-53	Creditors/Risk Premiums-PHI			0.10



	2000/2-54		Creditors/Risk Premiums-Funeral Cover

01/01/2006	Opening Balance					51.85
18/01/2006	Cash Book	28399	Funeral Cover		376.05
31/01/2006	Gen Jrnl	0000 0030 0722	Funeral Cover			382.59
10/02/2006	Cash Book	29688	Funeral Cover		382.59
28/02/2006	Gen Jrnl	0000 0041 4013	Funeral Cover			379.32
10/03/2006	Cash Book	30976	Funeral Cover		379.32
31/03/2006	Gen Jrnl	0000 0033 0471	Funeral Cover			379.32
11/04/2006	Cash Book	32624	Funeral Cover		379.32
30/04/2006	Gen Jrnl	0000 0047 2186	Funeral Cover			376.05
19/05/2006	Cash Book	33848	Funeral Cover		376.05
31/05/2006	Gen Jrnl	0000 0036 3295	Funeral Cover			376.05
22/06/2006	Cash Book	35603	Funeral Cover		376.05
30/06/2006	Gen Jrnl	0000 0037 7786	Funeral Cover			376.05
11/07/2006	Cash Book	37140	Funeral Cover		376.05
31/07/2006	Gen Jrnl	0000 0039 7293	Funeral Cover			382.59
10/08/2006	Cash Book	38837	Funeral Cover		382.59
31/08/2006	Gen Jrnl	0000 0041 9978	Funeral Cover			382.59
18/09/2006	Cash Book	40531	Funeral Cover		382.59
30/09/2006	Gen Jrnl	0000 0043 5533	Funeral Cover			376.05
16/10/2006	Cash Book	42313	Funeral Cover		376.05
31/10/2006	Gen Jrnl	0000 0045 8212	Funeral Cover			382.59
16/11/2006	Cash Book	44267	Funeral Cover		382.59
30/11/2006	Gen Jrnl	0000 0047 4726	Funeral Cover			450.80
13/12/2006	Gen Jrnl	0000 0047 6016	Funeral Cover		450.80
	Account Total	2000/2-54	Creditors/Risk Premiums-Funeral Cover		324.20



	2000/3-2		Creditors/Expenses- Administration ABC Administrators

01/01/2006	Opening Balance					14,810.54
18/01/2006	Cash Book	28396	Administration ABC Administrators		14,972.10
31/01/2006	Gen Jrnl	0000 0030 0722	Administration ABC Administrators			15,880.59
10/02/2006	Cash Book	29686	Administration ABC Administrators		15,880.60
28/02/2006	Gen Jrnl	0000 0041 4013	Administration ABC Administrators			15,741.19
10/03/2006	Cash Book	30974	Administration ABC Administrators		15,678.50
31/03/2006	Gen Jrnl	0000 0033 0471	Administration ABC Administrators			15,741.19
11/04/2006	Cash Book	32622	Administration ABC Administrators		15,741.20
30/04/2006	Gen Jrnl	0000 0047 2186	Administration ABC Administrators			15,741.19
19/05/2006	Cash Book	33845	Administration ABC Administrators		15,741.20
31/05/2006	Gen Jrnl	0000 0036 3295	Administration ABC Administrators			15,741.19
22/06/2006	Cash Book	35600	Administration ABC Administrators		15,741.20
30/06/2006	Gen Jrnl	0000 0037 7786	Administration ABC Administrators			15,741.19
11/07/2006	Cash Book	37141	Administration ABC Administrators		15,741.20
31/07/2006	Gen Jrnl	0000 0039 7293	Administration ABC Administrators			15,969.66
10/08/2006	Cash Book	38834	Administration ABC Administrators		15,969.70
31/08/2006	Gen Jrnl	0000 0041 9978	Administration ABC Administrators			16,043.56
18/09/2006	Cash Book	40528	Administration ABC Administrators		16,043.60
30/09/2006	Gen Jrnl	0000 0043 5533	Administration ABC Administrators			15,866.45
16/10/2006	Cash Book	42310	Administration ABC Administrators		15,866.50
31/10/2006	Gen Jrnl	0000 0045 8212	Administration ABC Administrators			15,956.21
16/11/2006	Cash Book	44264	Administration ABC Administrators		15,956.20
30/11/2006	Gen Jrnl	0000 0047 4726	Administration ABC Administrators			15,915.54
13/12/2006	Gen Jrnl	0000 0047 6015	Administration ABC Administrators		15,915.50
	Account Total	2000/3-2	Creditors/Expenses- Administration ABC Administrators		99.00



	2000/3-3160		Creditors/Expenses- Management Expense ABC C&A

01/01/2006	Opening Balance					20,846.94
18/01/2006	Cash Book	28397	Management Expense ABC C&A		8,473.69
24/01/2006	Gen Jrnl	0000 0029 2959	Management Expense ABC C&A		79,632.31
31/01/2006	Gen Jrnl	0000 0030 0722	Management Expense ABC C&A			8,811.16
28/02/2006	Gen Jrnl	0000 0041 4013	Management Expense ABC C&A			8,754.98
31/03/2006	Gen Jrnl	0000 0033 0471	Management Expense ABC C&A			8,754.98
30/04/2006	Gen Jrnl	0000 0047 2186	Management Expense ABC C&A			8,754.98
31/05/2006	Gen Jrnl	0000 0036 3295	Management Expense ABC C&A			8,754.98
30/06/2006	Gen Jrnl	0000 0037 7786	Management Expense ABC C&A			8,754.98
31/07/2006	Gen Jrnl	0000 0039 7293	Management Expense ABC C&A			8,838.70
31/08/2006	Gen Jrnl	0000 0041 9978	Management Expense ABC C&A			8,864.93
30/09/2006	Gen Jrnl	0000 0043 5533	Management Expense ABC C&A			8,800.36
31/10/2006	Gen Jrnl	0000 0045 8212	Management Expense ABC C&A			8,829.58
30/11/2006	Gen Jrnl	0000 0047 4726	Management Expense ABC C&A			8,817.22
	Account Total	2000/3-3160	Creditors/Expenses- Management Expense ABC C&A			29,477.79



	2000/44		SA Revenue Services - PAYE
01/01/2006	Opening Balance				10.00
26/01/2006	Cash Book	28402	Rene Steyn	11644		90,133.39
06/02/2006	Cash Book	29338	_Bank (Test (Pty) Ltd)	11852	90,133.39
31/08/2006	Gen Jrnl	0000 1015 0021	Pay Tax to SARS			10.00
31/08/2006	Gen Jrnl	0000 1015 0021	Pay Tax to SARS - Pensioners		10.00
26/09/2006	Cash Book	40534	R K Sxxxxx	17467		839.36
03/10/2006	Cash Book	41628	_Bank (Test (Pty) Ltd)	17698	829.36
	Account Total	2000/44	SA Revenue Services - PAYE

	2000/29		Benefits Due
01/01/2006	Opening Balance					242,016.64
01/01/2006	Gen Jrnl	0000 0018 4334	N Wxxxx		610,967.05
26/01/2006	Cash Book	28402	R Sxxxxxx	11644	255,696.88
31/01/2006	Cash Book	30973	R Ixxxx	12377		416,916.77
08/03/2006	Cash Book	30973	R Ixxxx	12377	416,916.77
31/08/2006	Gen Jrnl	0000 0042 0797	Jwa Vxxx			135,773.03
31/08/2006	Cash Book	40534	R K Sxxxx	17467		4,755.50
26/09/2006	Cash Book	40534	R K Sxxx	17467	839.36
27/09/2006	Cash Book	40534	R K Sxxxx	17467	3,916.14
31/10/2006	Cash Book	45461	Axxx Kxxx	19709		631,076.60
05/12/2006	Cash Book	45461	Axxxx Kxxxxx	19709	631,076.60
	Account Total	2000/29	Benefits Due		488,874.26

	1020/34		Transfers/Single Premiums Receivable
01/01/2006	Opening Balance
01/01/2006	Cash Book	27927	Single Premiums Received	3870000		491,946.29
01/01/2006	Gen Jrnl	0000 0047 4557	Transfer In - Capital Portion		87,332.68
01/01/2006	Gen Jrnl	0000 0047 4971	Transfer In - Capital Portion		103,127.71
01/01/2006	Gen Jrnl	0000 0047 5141	Transfer In - Capital Portion		16,010.95
01/01/2006	Gen Jrnl	0000 0047 4557	Transfer In - Interest Portion		280,953.22
01/01/2006	Gen Jrnl	0000 0047 4971	Transfer In - Interest Portion		4,521.73
30/06/2006	Cash Book	34889	Single Premiums Received			76,774.09
30/06/2006	Cash Book	35598	Single Premiums Received			163,502.14
30/06/2006	Gen Jrnl	0000 0047 5058	Transfer In - Interest Portion		163,502.14
30/06/2006	Gen Jrnl	0000 0047 5186	Transfer In - Interest Portion		76,774.09
31/10/2006	Cash Book	42313	Single Premiums Received	17991		189,976.98
31/10/2006	Gen Jrnl	0000 0047 5079	Transfer In - Interest Portion		137,220.94
31/10/2006	Gen Jrnl	0000 0047 5203	Transfer In - Interest Portion		52,756.04
	Account Total	1020/34	Transfers/Single Premiums Receivable

	1010/85		Investments/Fund Bank Account
01/01/2006	Opening Balance				582,961.71
01/01/2006	Cash Book	27927	_Bank (Test (Pty) Ltd)	3870000		491,946.29
01/01/2006	Cash Book	32623	FSB Levies	13230	1,435.00
01/01/2006	Cash Book	27927	Single Premiums Received	3870000	491,946.29
03/01/2006	Cash Book	27926	Contributions Received		26,242.60
03/01/2006	Cash Book	27927	interest	3870000	9,579.35
07/01/2006	Cash Book	27928	Contributions Received		100,000.00
07/01/2006	Cash Book	27929	Contributions Received		100,000.00
07/01/2006	Cash Book	27930	Contributions Received		100,000.00
07/01/2006	Cash Book	27931	Contributions Received		99,084.01
09/01/2006	Cash Book	28394	Contributions Received		24,227.97
11/01/2006	Cash Book	28395	Interest Adjustment			402.09
18/01/2006	Cash Book	28396	Administration ABC Administrators	11438		14,972.10
18/01/2006	Cash Book	28397	Management Expense ABC C&A	11437		8,473.69
18/01/2006	Cash Book	28399	Funeral Cover	11436		376.05
18/01/2006	Cash Book	28398	Policy 3	11439		620,000.02
21/01/2006	Cash Book	28400	Service Fees			40.00
24/01/2006	Cash Book	28401	Commission Payment	11591		79,632.31
26/01/2006	Cash Book	28402	Rene Steyn	11644		165,563.49
30/01/2006	Cash Book	28403	Contributions Received	9802263	77,091.35
30/01/2006	Cash Book	28404	Contributions Received	9802263	5,256.68
31/01/2006	Cash Book	29332	_Bank (Test (Pty) Ltd)			529,237.50
31/01/2006	Cash Book	29332	Policy 3		529,237.50
01/02/2006	Cash Book	29330	Interest	3870000	2,614.49
06/02/2006	Cash Book	29338	_Bank (Test (Pty) Ltd)	11852		90,133.39
06/02/2006	Cash Book	29331	Contributions Received	2	25,981.08
07/02/2006	Cash Book	29332	Contributions Received		24,227.97
07/02/2006	Cash Book	29333	Contributions Received		100,000.00
07/02/2006	Cash Book	29334	Contributions Received		100,000.00
07/02/2006	Cash Book	29335	Contributions Received		100,000.00
07/02/2006	Cash Book	29336	Contributions Received		26,795.15
07/02/2006	Cash Book	29337	Contributions Received		100,000.00
10/02/2006	Cash Book	29686	Administration ABC Administrators	11951		15,880.60
10/02/2006	Cash Book	29688	Funeral Cover	11952		382.59
10/02/2006	Cash Book	29687	Policy 3	11953		250,000.01
21/02/2006	Cash Book	29689	Service Fees			40.00
28/02/2006	Cash Book	29689	_Bank (Test (Pty) Ltd)			2,214.00
28/02/2006	Cash Book	30976	_Bank (Test (Pty) Ltd)	12477		522,103.47
28/02/2006	Cash Book	29690	Contributions Received	69802263	77,091.35
28/02/2006	Cash Book	29691	Contributions Received	69802263	5,256.68
28/02/2006	Cash Book	29689	Policy 3		2,214.00
28/02/2006	Cash Book	30976	Policy 3	12477	522,103.47
02/03/2006	Cash Book	30297	Interest	3870000	1,438.25
07/03/2006	Cash Book	30298	Contributions Received		20,675.27
07/03/2006	Cash Book	30299	Contributions Received		24,227.97
07/03/2006	Cash Book	30300	Contributions Received		100,000.00
07/03/2006	Cash Book	30301	Contributions Received		100,000.00
07/03/2006	Cash Book	30302	Contributions Received		100,000.00
07/03/2006	Cash Book	30303	Contributions Received		24,534.24
07/03/2006	Cash Book	30304	Contributions Received		100,000.00
08/03/2006	Cash Book	30973	R Ixxxx	12377		416,916.77
09/03/2006	Cash Book	30972	Contributions Received		2,214.00
10/03/2006	Cash Book	30974	Administration ABC Administrators	12478		15,678.50
10/03/2006	Cash Book	30976	Funeral Cover	12477		379.32
10/03/2006	Cash Book	30975	Policy 3	12479		100,000.00
20/03/2006	Cash Book	30977	Service Fees			40.00
23/03/2006	Cash Book	30978	RFT	12737		62,550.77
27/03/2006	Cash Book	30980	Audit Fees	12880		24,396.00
27/03/2006	Cash Book	30979	Foreign Asset Allocation	12879		43,006.50
30/03/2006	Cash Book	30981	Contributions Received	9802263	77,091.35
30/03/2006	Cash Book	30982	Contributions Received	9802263	5,256.68
31/03/2006	Cash Book	30977	_Bank (Test (Pty) Ltd)			524,317.47
31/03/2006	Cash Book	30977	Policy 3		524,317.47
01/04/2006	Cash Book	31959	Investment Income	3870000	1,723.85
03/04/2006	Cash Book	32621	FSB Levies	17		1,435.00
04/04/2006	Cash Book	31960	Contributions Received		20,675.27
06/04/2006	Cash Book	31961	Contributions Received		100,000.00
06/04/2006	Cash Book	31962	Contributions Received		100,000.00
06/04/2006	Cash Book	31963	Contributions Received		100,000.00
06/04/2006	Cash Book	31964	Contributions Received		26,748.24
06/04/2006	Cash Book	31965	Contributions Received		100,000.00
07/04/2006	Cash Book	31966	Contributions Received		24,227.97
11/04/2006	Cash Book	32622	Administration ABC Administrators	13229		15,741.20
11/04/2006	Cash Book	32624	Funeral Cover	13228		379.32
12/04/2006	Cash Book	32623	Policy 3	13230		450,000.00
21/04/2006	Cash Book	32625	Service Fees			40.00
28/04/2006	Cash Book	32626	Contributions Received		5,256.68
28/04/2006	Cash Book	32627	Contributions Received	9802263	77,091.35
30/04/2006	Cash Book	32625	_Bank (Test (Pty) Ltd)			524,317.47
30/04/2006	Cash Book	32625	Policy 3		524,317.47
02/05/2006	Cash Book	33207	Interest	3870000	1,724.69
05/05/2006	Cash Book	33208	Contributions Received		20,675.27
05/05/2006	Cash Book	33844	Foreign Asset Allocation	13741		6,344.10
06/05/2006	Cash Book	33209	Contributions Received		24,227.97
06/05/2006	Cash Book	33210	Contributions Received		100,000.00
06/05/2006	Cash Book	33211	Contributions Received		100,000.00
06/05/2006	Cash Book	33212	Contributions Received		100,000.00
06/05/2006	Cash Book	33213	Contributions Received		26,748.24
06/05/2006	Cash Book	33214	Contributions Received		100,000.00
19/05/2006	Cash Book	33845	Administration ABC Administrators	14056		15,741.20
19/05/2006	Cash Book	33848	Funeral Cover	14057		376.05
19/05/2006	Cash Book	33846	Policy 3	14055		479,999.99
19/05/2006	Cash Book	33847	Policy 3	14054		3,932.25
20/05/2006	Cash Book	33849	Service Fees			40.00
30/05/2006	Cash Book	33850	Contributions Received		77,091.35
30/05/2006	Cash Book	33851	Contributions Received		5,256.68
30/05/2006	Cash Book	33852	RFT	14232		6,631.89
30/05/2006	Cash Book	33853	RFT	14313		39,003.50
31/05/2006	Cash Book	33853	_Bank (Test (Pty) Ltd)	14313		524,317.57
31/05/2006	Cash Book	33853	Policy 3	14313	524,317.57
01/06/2006	Cash Book	34885	Investment Income	3870000	2,454.50
06/06/2006	Cash Book	34886	Contributions Received		100,000.00
06/06/2006	Cash Book	34887	Contributions Received		100,000.00
06/06/2006	Cash Book	34888	Contributions Received		100,000.00
06/06/2006	Cash Book	34889	Contributions Received		22,888.24
06/06/2006	Cash Book	34890	Contributions Received		100,000.00
07/06/2006	Cash Book	34891	Contributions Received		20,675.27
07/06/2006	Cash Book	34892	Contributions Received		24,227.97
08/06/2006	Cash Book	35598	Contributions Received		3,860.00
21/06/2006	Cash Book	35599	Bank charges			40.00
22/06/2006	Cash Book	35600	Administration ABC Administrators	14959		15,741.20
22/06/2006	Cash Book	35603	Funeral Cover	14960		376.05
22/06/2006	Cash Book	35601	Policy 3	14962		480,000.00
22/06/2006	Cash Book	35602	Policy 3	14961		3,932.25
29/06/2006	Cash Book	35604	Contributions Received		77,091.35
29/06/2006	Cash Book	35605	Contributions Received		5,256.68
29/06/2006	Cash Book	35606	FSB Levies	15108		1,473.00
30/06/2006	Cash Book	34889	_Bank (Test (Pty) Ltd)			76,774.09
30/06/2006	Cash Book	35598	_Bank (Test (Pty) Ltd)			163,502.14
30/06/2006	Cash Book	35599	_Bank (Test (Pty) Ltd)			524,317.57
30/06/2006	Cash Book	35599	Policy 3		524,317.57
30/06/2006	Cash Book	34889	Single Premiums Received		76,774.09
30/06/2006	Cash Book	35598	Single Premiums Received		163,502.14
01/07/2006	Cash Book	36449	Interest received	3870000	2,920.55
06/07/2006	Cash Book	36450	Contributions Received	22	20,675.27
06/07/2006	Cash Book	36451	Contributions Received		100,000.00
06/07/2006	Cash Book	36452	Contributions Received		100,000.00
06/07/2006	Cash Book	36453	Contributions Received		100,000.00
06/07/2006	Cash Book	36454	Contributions Received		26,748.25
06/07/2006	Cash Book	36455	Contributions Received		100,000.00
07/07/2006	Cash Book	36456	Contributions Received		24,227.97
11/07/2006	Cash Book	37141	Administration ABC Administrators	15411		15,741.20
11/07/2006	Cash Book	37140	Funeral Cover	15412		376.05
12/07/2006	Cash Book	37142	Policy 3	15413		525,000.00
12/07/2006	Cash Book	37143	Policy 3	15414		3,932.25
21/07/2006	Cash Book	37144	Bank charges			40.00
31/07/2006	Cash Book	37144	_Bank (Test (Pty) Ltd)			531,659.98
31/07/2006	Cash Book	37145	Contributions Received		77,091.35
31/07/2006	Cash Book	37146	Contributions Received		5,256.68
31/07/2006	Cash Book	37144	Policy 3		531,659.98
01/08/2006	Cash Book	38057	Interest received	3870000	2,362.41
03/08/2006	Cash Book	38058	Foreign Asset Allocation	16133		2,114.70
07/08/2006	Cash Book	38059	Contributions Received		21,079.01
07/08/2006	Cash Book	38060	Contributions Received		24,227.97
07/08/2006	Cash Book	38061	Contributions Received		100,000.00
07/08/2006	Cash Book	38062	Contributions Received		100,000.00
07/08/2006	Cash Book	38063	Contributions Received		100,000.00
07/08/2006	Cash Book	38064	Contributions Received		34,110.47
07/08/2006	Cash Book	38065	Contributions Received		100,000.00
10/08/2006	Cash Book	38834	Administration ABC Administrators	16319		15,969.70
10/08/2006	Cash Book	38837	Funeral Cover	16320		382.59
11/08/2006	Cash Book	38835	Policy 3	16322		540,000.00
11/08/2006	Cash Book	38836	Policy 3	16321		4,018.50
21/08/2006	Cash Book	38838	Bank charges			40.00
31/08/2006	Cash Book	38838	_Bank (Test (Pty) Ltd)			533,963.61
31/08/2006	Cash Book	38839	Contributions Received		77,091.35
31/08/2006	Cash Book	38840	Contributions Received		5,256.68
31/08/2006	Cash Book	38838	Policy 3		533,963.61
01/09/2006	Cash Book	39616	Interest received	3870000	2,701.11
06/09/2006	Cash Book	39617	Contributions Received		100,000.00
06/09/2006	Cash Book	39618	Contributions Received		100,000.00
06/09/2006	Cash Book	39619	Contributions Received		100,000.00
06/09/2006	Cash Book	39620	Contributions Received		34,110.47
06/09/2006	Cash Book	39621	Contributions Received		100,000.00
07/09/2006	Cash Book	39622	Contributions Received		22,213.21
07/09/2006	Cash Book	39623	Contributions Received		25,526.01
18/09/2006	Cash Book	40528	Administration ABC Administrators	17226		16,043.60
18/09/2006	Cash Book	40531	Funeral Cover	17225		382.59
18/09/2006	Cash Book	40529	Policy 3	17228		539,999.99
18/09/2006	Cash Book	40530	Policy 3	17227		4,018.50
21/09/2006	Cash Book	40533	Bank charges			40.00
21/09/2006	Cash Book	40532	RFT	17349		4,022.91
27/09/2006	Cash Book	40534	R K Sxxxx	17467		3,916.14
28/09/2006	Cash Book	40535	Contributions Received	9802263	5,256.68
28/09/2006	Cash Book	40536	Contributions Received	9812263	77,091.35
29/09/2006	Cash Book	40537	Bank charges			450.00
30/09/2006	Cash Book	40535	_Bank (Test (Pty) Ltd)	9802263		528,295.86
30/09/2006	Cash Book	40535	Policy 3	9802263	528,295.86
02/10/2006	Cash Book	41627	Interest on credit balance	3870000	3,122.25
03/10/2006	Cash Book	41628	_Bank (Test (Pty) Ltd)	17698		829.36
03/10/2006	Cash Book	41629	FSB Levies	17761		1,622.60
03/10/2006	Cash Book	41630	FSB Levies	17762		285.00
06/10/2006	Cash Book	41631	Contributions Received		22,213.21
06/10/2006	Cash Book	41632	Contributions Received		25,526.01
06/10/2006	Cash Book	41633	Contributions Received		100,000.00
06/10/2006	Cash Book	41634	Contributions Received		100,000.00
06/10/2006	Cash Book	41635	Contributions Received		100,000.00
06/10/2006	Cash Book	41636	Contributions Received		28,334.79
06/10/2006	Cash Book	41637	Contributions Received		100,000.00
12/10/2006	Cash Book	42309	Fidelity Guarantee Insurance	17850		12,090.00
16/10/2006	Cash Book	42310	Administration ABC Administrators	17990		15,866.50
16/10/2006	Cash Book	42313	Funeral Cover	17991		376.05
17/10/2006	Cash Book	42311	Policy 3	17993		539,999.99
17/10/2006	Cash Book	42312	Policy 3	17992		4,018.50
21/10/2006	Cash Book	42314	Oct 06 Bank Charges			40.00
30/10/2006	Cash Book	42315	Contributions Received	9802263	77,091.35
30/10/2006	Cash Book	42316	Contributions Received	9802263	5,256.68
31/10/2006	Cash Book	42313	_Bank (Test (Pty) Ltd)	17991		189,976.98
31/10/2006	Cash Book	42314	_Bank (Test (Pty) Ltd)			530,862.41
31/10/2006	Cash Book	42314	Policy 3		530,862.41
31/10/2006	Cash Book	42313	Single Premiums Received	17991	189,976.98
01/11/2006	Cash Book	43449	Nov 06 Interest	3870000	3,158.38
02/11/2006	Cash Book	43450	_Bank (Test (Pty) Ltd)		1,736,409.37
06/11/2006	Cash Book	43451	Contributions Received		100,000.00
06/11/2006	Cash Book	43452	Contributions Received		100,000.00
06/11/2006	Cash Book	43453	Contributions Received		100,000.00
06/11/2006	Cash Book	43454	Contributions Received		27,397.47
06/11/2006	Cash Book	43455	Contributions Received		100,000.00
06/11/2006	Cash Book	43456	Contributions Received		3,227.10
07/11/2006	Cash Book	43457	Contributions Received		22,213.21
07/11/2006	Cash Book	43458	Contributions Received		25,526.01
07/11/2006	Cash Book	44260	Foreign Asset Allocation	18791		2,114.70
09/11/2006	Cash Book	44261	Policy 3	18890		1,736,409.37
15/11/2006	Cash Book	44262	_Bank (Test (Pty) Ltd)		552,841.93
16/11/2006	Cash Book	44264	Administration ABC Administrators	19124		15,956.20
16/11/2006	Cash Book	44267	Funeral Cover	19123		382.59
16/11/2006	Cash Book	44265	Policy 3	19125		7,963.50
16/11/2006	Cash Book	44266	Policy 3	19126		4,154.25
17/11/2006	Cash Book	44263	_Bank (Test (Pty) Ltd)	19113		552,841.93
21/11/2006	Cash Book	44268	Nov 06 Bank Charges			40.00
29/11/2006	Cash Book	44269	RFT	19594		21,513.21
30/11/2006	Cash Book	44268	_Bank (Test (Pty) Ltd)			521,654.31
30/11/2006	Cash Book	44270	Contributions Received		77,093.30
30/11/2006	Cash Book	44271	Contributions Received		5,257.33
30/11/2006	Cash Book	44268	Policy 3		521,654.31
01/12/2006	Cash Book	45460	Dec 06 Bank Interest	3870000	6,617.58
05/12/2006	Cash Book	45461	Axxx Kxxxx	19709		631,076.60
05/12/2006	Cash Book	45468	Audit Fees	19754		42,978.00
06/12/2006	Cash Book	45462	Contributions Received		100,000.00
06/12/2006	Cash Book	45463	Contributions Received		100,000.00
06/12/2006	Cash Book	45464	Contributions Received		100,000.00
06/12/2006	Cash Book	45465	Contributions Received		26,253.82
06/12/2006	Cash Book	45466	Contributions Received		100,000.00
06/12/2006	Cash Book	45467	Contributions Received		3,227.75
07/12/2006	Cash Book	45469	Contributions Received		22,391.95
07/12/2006	Cash Book	45470	Contributions Received		25,529.91
13/12/2006	Gen Jrnl	0000 0047 6015	Administration ABC Administrators			15,915.50
13/12/2006	Gen Jrnl	0000 0047 6016	Funeral Cover			450.80
13/12/2006	Gen Jrnl	0000 0047 6032	Policy 3			7,963.49
13/12/2006	Gen Jrnl	0000 0047 6035	Policy 3			4,154.25
	Account Total	1010/85	Investments/Fund Bank Account		772,198.60

	1010/526		Investments/Policy 15
01/01/2006	Opening Balance
19/05/2006	Gen Jrnl	0000 0034 9011	Policy 15		3,932.25
31/05/2006	Gen Jrnl	0000 0039 7388	Policy 15			209.33
31/05/2006	Gen Jrnl	0000 0039 7391	Policy 15		2.10
31/05/2006	Gen Jrnl	0000 0039 7393	Policy 15			7,254.58
31/05/2006	Gen Jrnl	0000 0039 7403	Policy 15		437,793.60
22/06/2006	Gen Jrnl	0000 0036 7099	Policy 15		3,932.25
30/06/2006	Gen Jrnl	0000 0039 7480	Policy 15			285.81
30/06/2006	Gen Jrnl	0000 0039 7486	Policy 15		12.21
12/07/2006	Gen Jrnl	0000 0037 8011	Policy 15		3,932.25
31/07/2006	Gen Jrnl	0000 0039 7502	Policy 15		13.57
31/07/2006	Gen Jrnl	0000 0039 7503	Policy 15			299.90
31/07/2006	Gen Jrnl	0000 0039 7507	Policy 15			1,004.37
11/08/2006	Gen Jrnl	0000 0039 8072	Policy 15		4,018.50
18/09/2006	Gen Jrnl	0000 0042 0814	Policy 15		4,018.50
17/10/2006	Gen Jrnl	0000 0043 6787	Policy 15		4,018.50
30/10/2006	Gen Jrnl	0000 0047 5759	Policy 15		1,122,436.62
16/11/2006	Gen Jrnl	0000 0045 8392	Policy 15		7,963.50
13/12/2006	Gen Jrnl	0000 0047 6032	Policy 15		7,963.49
	Account Total	1010/526	Investments/Policy 15		1,590,983.35

	1010/113		Investments/Policy 18
01/01/2006	Opening Balance
01/01/2006	Gen Jrnl	0000 0047 4621	Policy 18			452,251.48
	Account Total	1010/113	Investments/Policy 18			452,251.48

	1010/97		Investments/Policy 2
01/01/2006	Opening Balance
31/03/2006	Gen Jrnl	0000 0034 7668	Policy 2
	Account Total	1010/97	Investments/Policy 2

	1010/650		Investments/Policy 21
01/01/2006	Opening Balance
30/10/2006	Gen Jrnl	0000 0047 5732	Policy 21		1,736,409.36
30/10/2006	Gen Jrnl	0000 0047 5759	Policy 21		552,841.92
09/11/2006	Gen Jrnl	0000 0047 5288	Policy 21		1,736,409.37
16/11/2006	Gen Jrnl	0000 0045 8434	Policy 21		4,154.25
17/11/2006	Gen Jrnl	0000 0045 8975	Policy 21		552,841.93
13/12/2006	Gen Jrnl	0000 0047 6035	Policy 21		4,154.25
	Account Total	1010/650	Investments/Policy 21		4,586,811.08

	1010/118		Investments/Policy 5
01/01/2006	Opening Balance				7,173,206.16
01/01/2006	Gen Jrnl	0000 0047 4626	Policy 5		820,537.38
01/01/2006	Gen Jrnl	0000 0047 4681	Policy 5			820,537.38
01/01/2006	Gen Jrnl	0000 0047 4985	Policy 5		2,160,035.60
01/01/2006	Gen Jrnl	0000 0047 5123	Policy 5			1,930,161.08
01/01/2006	Gen Jrnl	0000 0047 5124	Policy 5			122,225.08
01/01/2006	Gen Jrnl	0000 0047 5146	Policy 5		16,010.95
31/03/2006	Gen Jrnl	0000 0034 7668	Policy 5
30/06/2006	Gen Jrnl	0000 0047 5062	Policy 5		163,502.14
30/06/2006	Gen Jrnl	0000 0047 5189	Policy 5		76,774.09
31/10/2006	Gen Jrnl	0000 0047 5083	Policy 5		137,220.94
31/10/2006	Gen Jrnl	0000 0047 5206	Policy 5		52,756.04
	Account Total	1010/118	Investments/Policy 5		7,727,119.76

	1010/202		Investments/Policy 8
01/01/2006	Opening Balance				78,468,342.82
18/01/2006	Gen Jrnl	0000 0029 0845	Policy 8		620,000.02
31/01/2006	Gen Jrnl	0000 0039 6933	Policy 8		4,584,447.83
31/01/2006	Gen Jrnl	0000 0039 6936	Policy 8			50,553.41
10/02/2006	Gen Jrnl	0000 0030 1137	Policy 8		250,000.01
28/02/2006	Gen Jrnl	0000 0039 6940	Policy 8			394,778.82
28/02/2006	Gen Jrnl	0000 0039 6942	Policy 8			45,697.72
10/03/2006	Gen Jrnl	0000 0031 3850	Policy 8		100,000.00
31/03/2006	Gen Jrnl	0000 0034 7668	Policy 8
31/03/2006	Gen Jrnl	0000 0039 6946	Policy 8		3,671,379.40
31/03/2006	Gen Jrnl	0000 0039 6947	Policy 8			51,686.44
12/04/2006	Gen Jrnl	0000 0033 0497	Policy 8		450,000.00
30/04/2006	Gen Jrnl	0000 0039 6973	Policy 8		1,345,884.08
30/04/2006	Gen Jrnl	0000 0039 6977	Policy 8			47,988.27
19/05/2006	Gen Jrnl	0000 0034 9014	Policy 8		479,999.99
31/05/2006	Gen Jrnl	0000 0039 7335	Policy 8			57,429.62
31/05/2006	Gen Jrnl	0000 0039 7359	Policy 8			1,322,392.89
31/05/2006	Gen Jrnl	0000 0039 7368	Policy 8		256.44
31/05/2006	Gen Jrnl	0000 0039 7403	Policy 8			437,793.60
22/06/2006	Gen Jrnl	0000 0036 7101	Policy 8		480,000.00
30/06/2006	Gen Jrnl	0000 0039 7444	Policy 8			51,401.71
30/06/2006	Gen Jrnl	0000 0039 7446	Policy 8		483,878.60
12/07/2006	Gen Jrnl	0000 0037 8007	Policy 8		525,000.00
31/07/2006	Gen Jrnl	0000 0039 7454	Policy 8		1,656.99
31/07/2006	Gen Jrnl	0000 0039 7456	Policy 8			137,488.75
31/07/2006	Gen Jrnl	0000 0039 7465	Policy 8			54,397.99
11/08/2006	Gen Jrnl	0000 0039 8074	Policy 8		540,000.00
18/09/2006	Gen Jrnl	0000 0042 0815	Policy 8		539,999.99
17/10/2006	Gen Jrnl	0000 0043 6788	Policy 8		539,999.99
30/10/2006	Gen Jrnl	0000 0047 5732	Policy 8			1,736,409.36
30/10/2006	Gen Jrnl	0000 0047 5759	Policy 8			1,675,278.54
02/11/2006	Gen Jrnl	0000 0046 2450	Policy 8			1,736,409.37
15/11/2006	Gen Jrnl	0000 0047 5328	Policy 8			552,841.93
	Account Total	1010/202	Investments/Policy 8		84,728,297.74

Report Notes

The first section of the report provides a summarised trial balance.

The second section of the report, which is the general ledger component, provides detailed ledger accounts. This report should be saved to the audit file created.

The initial preparation of the Audit is two fold. Firstly, the User is to verify that account 4430/90 Accumulated Funds / Opening balance, balances to the closing value of the prior year, which must also balance to the signed Annual Financial Statements for the prior year.

Secondly, the User is to analyse the various member related ledger accounts. (listed below). The System Administrator of the fund creates the ledger accounts and all transactions are system generated. There should be no additional journals to the various ledger accounts. Should a journal entry be required, the System Administrator must be consulted and authorise the journal entry.

The various member related ledger accounts are dealt with separately in the document below and are listed as follows:-

contribution accounts,
administration fee accounts,
risk premium accounts,
exit accounts,
PAYE accounts,
risk recovery accounts, and
transfer in accounts.

Contribution Accounts

Report Name: Accounts Contribution Report

The following steps must be completed when producing the report.

Parent Select the relevant Parent

Batches Select Batch Management

Batch Type Click on the Batch Type drop down and select “All”

Batch Search and select “Accounts Contribution Report”

New Batch Click on the “New Batch” button

Edit Double click on the edit hyperlink

Date 1 Enter the First day of the Financial Year

Date 2 Enter the Last day of the Financial Year

Client Parent Select Parent from the drop down

Save Press the “Save” button

Execute Press the “Execute” button

The following Income Statement and Balance Sheet Ledgers are used: -

Income Statement

Ledger Code and Account Description	Description
4000/0	Gross Contribution Income - Employee
4000/1	Gross Contribution Income - Employer

Balance Sheet

Ledger Code and Account Description	Description
1020/5	Debtors Ledger – Contributions Receivable

Report Notes

The report is split into three components. The first component relates to all Employee contribution details whilst the second component relates to Employer contribution details. Lastly, the third component of the Report is the combination of both employee and employer contribution details.

The total of the “Accrual” column in the first and second components of the report (detailing employee and employer contributions, if applicable) must equate to the total of the income accounts (4000/0 and 4000/1) reflected in the Trial Balance.

The “Accrual” column at the bottom of the report is the sum of the income accounts 4000/0 and 4000/1 (both employee and employer respectively).

All deposits received in respect of contributions are reflected in the “Payments” column.

The “(Over)/Under” column reflects the difference between the accrual and the actual payments received. The total of the “(Over)/Under” column must balance to the Contributions Receivable account (1020/5).

The “Annualised Salaries” header reflects the annualised salary for the specific month.

The “Percentage” header refers to the rate of contribution per the Rules of the fund. Please note: If there are various rates of contributions for different categories of members, the percentage reflected in this column is the apportioned percentage over the membership of the Fund.

The assumption made is that all receipts paid before the 26^th of the current month is in respect of contributions for the previous month. This method applies to contributions run in arrears.

This report does not reflect the dates of deposit of the contribution received, however, the next report provides this detail “Client Contribution Statement”.

ABC Consultants and Actuaries Administrators (Pty) Ltd

Fund Registration Number - 12xxxxxx
Fund PAYE Number - 7xxxxxxx
SARS Registration Number - 1820xxxxxx

ACCOUNTS CONTRIBUTIONS REPORT

Umbrella Fund- Test (Pty) Ltd

Report information from 01/01/2006 to 31/12/2006

Month End	Payee	Accrual	Payment	(Over)/Under	Annualised Salaries	Percentage
	Summary for - Employee
31/12/2005	_Opening Value		18931639.50	-18931639.50		0.000%

	Totals	0.00	18931639.50	-18931639.50

	Summary for - Employer (Excl Special)
31/12/2005	_Opening Value		-19354951.48	19354951.48		0.000%
31/01/2006	Test Management Provident Fund	554311.84		554311.84	44,839,481	14.83%
28/02/2006	Test Management Provident Fund	549192.96		549192.96	44,445,879	14.82%
31/03/2006	Test Management Provident Fund	549192.96		549192.96	44,445,879	14.82%
30/04/2006	Test Management Provident Fund	549189.69		549189.69	44,445,879	14.82%
31/05/2006	Test Management Provident Fund	549189.79		549189.79	44,445,887	14.82%
30/06/2006	Test Management Provident Fund	549189.79		549189.79	44,445,887	14.82%
31/07/2006	Test Management Provident Fund	556850.93		556850.93	45,090,952	14.81%
31/08/2006	Test Management Provident Fund	559254.69		559254.69	45,299,628	14.81%
30/09/2006	Test Management Provident Fund	553338.72		553338.72	44,799,528	14.82%
31/10/2006	Test Management Provident Fund	556030.79		556030.79	45,052,960	14.81%
30/11/2006	Test Management Provident Fund	554961.00		554961.00	44,938,112	14.81%

	Totals	6080703.16	-19354951.48	25435654.64

	Summary for - Total Contributions
31/12/2005	_Opening Value	0.00	26242.60	-26242.60	0	0.000%
31/01/2006	Test Management Provident Fund	554311.84	559352.23	-5040.39	0	0.000%
28/02/2006	Test Management Provident Fund	549192.96	553999.51	-4806.55	0	0.000%
31/03/2006	Test Management Provident Fund	549192.96	553999.51	-4806.55	0	0.000%
30/04/2006	Test Management Provident Fund	549189.69	553999.51	-4809.82	0	0.000%
31/05/2006	Test Management Provident Fund	549189.79	553999.51	-4809.72	0	0.000%
30/06/2006	Test Management Provident Fund	549189.79	553999.52	-4809.73	0	0.000%
31/07/2006	Test Management Provident Fund	556850.93	561765.48	-4914.55	0	0.000%
31/08/2006	Test Management Provident Fund	559254.69	564197.72	-4943.03	0	0.000%
30/09/2006	Test Management Provident Fund	553338.72	558422.04	-5083.32	0	0.000%
31/10/2006	Test Management Provident Fund	556030.79	560711.82	-4681.03	0	0.000%
30/11/2006	Test Management Provident Fund	554961.00	559754.06	-4793.06	0	0.000%

	Totals	6080703.16	6160443.51	-79740.35

	NOTE - Where a contribution has been paid before the 26th of a month - it is deemed to be for the previous month
	NOTE - Payments only reflected for combined contributions

Report Name: Client Contribution Statement

The following steps must be completed when producing the report.

Parent Select the relevant Parent

Batches Select “Batch Management”

Batch Type Click on the Batch Type drop down and select “All”

Batch Search and select “Client Contribution Statement”

New Batch Click on the “New Batch” button

Edit Double click on the edit hyperlink

Client Select Client from the drop down

Paypoint Select Paypoint from the drop down

Date 1 Enter the First day of the Financial Year

Date 2 Enter the last day of the Financial Year

Save Press the “Save” button

Execute Press the “Execute” button

Report Notes

This report ties in with the “Accounts - Contribution Report” above and reflects all contribution accruals and amounts received. In addition, the dates of the deposits are reflected.

ABC Consultants and Actuaries Administrators (Pty) Ltd

CLIENT CONTRIBUTION STATEMENT

UMBRELLA FUND - Test (Pty) Ltd

CLIENT NAME - Test Management Provident Fund (45)

STATEMENT FOR THE PERIOD FROM 01 January 2006 to 31 March 2006

Date of Contribution Receipt	Accounting Date	Narrative	Account Details	Amount	Balance
01/01/2006	01/01/2006	Opening Balance		3,323,311.98	3,323,311.98
03/01/2006	03/01/2006	Contributions Received	Payroll 14	-26,242.60	3,297,069.38
07/01/2006	07/01/2006	Contributions Received	Dxxxx Wire	-99,084.01	3,197,985.37
07/01/2006	07/01/2006	Contributions Received	Payroll 14	-100,000.00	3,097,985.37
07/01/2006	07/01/2006	Contributions Received	Payroll 6	-100,000.00	2,997,985.37
09/01/2006	09/01/2006	Contributions Received	Payroll 14	-24,227.97	2,973,757.40
30/01/2006	30/01/2006	Contributions Received	F&WW	-77,091.35	2,896,666.05
30/01/2006	30/01/2006	Contributions Received	F&WW	-5,256.68	2,891,409.37
31/01/2006	31/01/2006	Risk Premiums	F&WW	16.35	2,891,425.72
31/01/2006	31/01/2006	Expenses	F&WW	1,116.74	2,892,542.46
31/01/2006	31/01/2006	Net Investments	F&WW Test Provident Fund	24,826.09	2,917,368.55
31/01/2006	31/01/2006	Risk Premiums	Payroll 14	16.35	2,917,384.90
31/01/2006	31/01/2006	Expenses	Payroll 14	3,296.72	2,920,681.62
31/01/2006	31/01/2006	Net Investments	Payroll 14 Test Provident Fund	73,290.00	2,993,971.62
31/01/2006	31/01/2006	Risk Premiums	Payroll 15	3.27	2,993,974.89
31/01/2006	31/01/2006	Expenses	Payroll 15	224.69	2,994,199.58
31/01/2006	31/01/2006	Net Investments	Payroll 15 Test Provident Fund	4,995.00	2,999,194.58
31/01/2006	31/01/2006	Risk Premiums	Payroll 6	137.34	2,999,331.92
31/01/2006	31/01/2006	Expenses	Payroll 6	5,375.28	3,004,707.20
31/01/2006	31/01/2006	Net Investments	Payroll 6 Test Provident Fund	105,147.60	3,109,854.80
31/01/2006	31/01/2006	Risk Premiums	Payroll 7	170.04	3,110,024.84
31/01/2006	31/01/2006	Expenses	Payroll 7	10,554.96	3,120,579.80
31/01/2006	31/01/2006	Net Investments	Payroll 7 Test Provident Fund	232,893.35	3,353,473.15
31/01/2006	31/01/2006	Risk Premiums	Payroll 8	19.62	3,353,492.77
31/01/2006	31/01/2006	Expenses	Payroll 8	2,939.47	3,356,432.24
31/01/2006	31/01/2006	Net Investments	Payroll 8 Test Provident Fund	65,347.50	3,421,779.74
31/01/2006	31/01/2006	Risk Premiums	Uxxx Recycling	19.62	3,421,799.36
31/01/2006	31/01/2006	Expenses	Uxxxx Recycling	1,183.89	3,422,983.25
31/01/2006	31/01/2006	Net Investments	Uxxxx Recycling Test Provident Fund	22,737.96	3,445,721.21
06/02/2006	06/02/2006	Contributions Received	Payroll 15	-25,981.08	3,419,740.13
07/02/2006	07/02/2006	Contributions Received	Dxxxx Wire	-24,227.97	3,395,512.16
07/02/2006	07/02/2006	Contributions Received	Payroll 14	-26,795.15	3,368,717.01
07/02/2006	07/02/2006	Contributions Received	Payroll 15	-100,000.00	3,268,717.01
07/02/2006	07/02/2006	Contributions Received	Payroll 6	-100,000.00	3,168,717.01
07/02/2006	07/02/2006	Contributions Received	Payroll 7	-100,000.00	3,068,717.01
28/02/2006	28/02/2006	Contributions Received	Dxxxx Wire	-77,091.35	2,991,625.66
28/02/2006	28/02/2006	Contributions Received	Payroll 14	-5,256.68	2,986,368.98
28/02/2006	28/02/2006	Risk Premiums	F&WW	13.08	2,986,382.06
28/02/2006	28/02/2006	Expenses	F&WW	889.63	2,987,271.69
28/02/2006	28/02/2006	Net Investments	F&WW Test Provident Fund	19,756.06	3,007,027.75
28/02/2006	28/02/2006	Risk Premiums	Payroll 14	16.35	3,007,044.10
28/02/2006	28/02/2006	Expenses	Payroll 14	3,300.34	3,010,344.44
28/02/2006	28/02/2006	Net Investments	Payroll 14 Test Provident Fund	73,290.00	3,083,634.44
28/02/2006	28/02/2006	Risk Premiums	Payroll 15	3.27	3,083,637.71
28/02/2006	28/02/2006	Expenses	Payroll 15	224.92	3,083,862.63
28/02/2006	28/02/2006	Net Investments	Payroll 15 Test Provident Fund	4,995.00	3,088,857.63
28/02/2006	28/02/2006	Risk Premiums	Payroll 6	137.34	3,088,994.97
28/02/2006	28/02/2006	Expenses	Payroll 6	5,380.44	3,094,375.41
28/02/2006	28/02/2006	Net Investments	Payroll 6 Test Provident Fund	105,147.60	3,199,523.01
28/02/2006	28/02/2006	Risk Premiums	Payroll 7	170.04	3,199,693.05
28/02/2006	28/02/2006	Expenses	Payroll 7	10,573.16	3,210,266.21
28/02/2006	28/02/2006	Net Investments	Payroll 7 Test Provident Fund	233,043.35	3,443,309.56
28/02/2006	28/02/2006	Risk Premiums	Payroll 8	19.62	3,443,329.18
28/02/2006	28/02/2006	Expenses	Payroll 8	2,942.69	3,446,271.87
28/02/2006	28/02/2006	Net Investments	Payroll 8 Test Provident Fund	65,347.50	3,511,619.37
28/02/2006	28/02/2006	Risk Premiums	Uxxxx Recycling	19.62	3,511,638.99
28/02/2006	28/02/2006	Expenses	Uxxxx Recycling	1,184.99	3,512,823.98
28/02/2006	28/02/2006	Net Investments	Uxxxx Recycling Test Provident Fund	22,737.96	3,535,561.94
07/03/2006	07/03/2006	Contributions Received	Payroll 14	-100,000.00	3,435,561.94
07/03/2006	07/03/2006	Contributions Received	Payroll 14	-24,227.97	3,411,333.97
07/03/2006	07/03/2006	Contributions Received	Payroll 14	-20,675.27	3,390,658.70
07/03/2006	07/03/2006	Contributions Received	Payroll 15	-100,000.00	3,290,658.70
07/03/2006	07/03/2006	Contributions Received	Payroll 15	-24,534.24	3,266,124.46
09/03/2006	09/03/2006	Contributions Received	Payroll 14	-2,214.00	3,263,910.46
30/03/2006	30/03/2006	Contributions Received	Payroll 14	-77,091.35	3,186,819.11
30/03/2006	30/03/2006	Contributions Received	Payroll 14	-5,256.68	3,181,562.43
31/03/2006	31/03/2006	Risk Premiums	F&WW	13.08	3,181,575.51
31/03/2006	31/03/2006	Expenses	F&WW	889.63	3,182,465.14
31/03/2006	31/03/2006	Net Investments	F&WW Test Provident Fund	19,756.06	3,202,221.20
31/03/2006	31/03/2006	Risk Premiums	Payroll 14	16.35	3,202,237.55
31/03/2006	31/03/2006	Expenses	Payroll 14	3,300.34	3,205,537.89
31/03/2006	31/03/2006	Net Investments	Payroll 14 Test Provident Fund	73,290.00	3,278,827.89
31/03/2006	31/03/2006	Risk Premiums	Payroll 15	3.27	3,278,831.16
31/03/2006	31/03/2006	Expenses	Payroll 15	224.92	3,279,056.08
31/03/2006	31/03/2006	Net Investments	Payroll 15 Test Provident Fund	4,995.00	3,284,051.08
31/03/2006	31/03/2006	Risk Premiums	Payroll 6	137.34	3,284,188.42
31/03/2006	31/03/2006	Expenses	Payroll 6	5,380.44	3,289,568.86
31/03/2006	31/03/2006	Net Investments	Payroll 6 Test Provident Fund	105,147.60	3,394,716.46
31/03/2006	31/03/2006	Risk Premiums	Payroll 7	170.04	3,394,886.50
31/03/2006	31/03/2006	Expenses	Payroll 7	10,573.16	3,405,459.66
31/03/2006	31/03/2006	Net Investments	Payroll 7 Test Provident Fund	233,043.35	3,638,503.01
31/03/2006	31/03/2006	Risk Premiums	Payroll 8	19.62	3,638,522.63
31/03/2006	31/03/2006	Expenses	Payroll 8	2,942.69	3,641,465.32
31/03/2006	31/03/2006	Net Investments	Payroll 8 Test Provident Fund	65,347.50	3,706,812.82
31/03/2006	31/03/2006	Risk Premiums	Uxxxx Recycling	19.62	3,706,832.44
31/03/2006	31/03/2006	Expenses	Uxxxx Recycling	1,184.99	3,708,017.43
31/03/2006	31/03/2006	Net Investments	Uxxxx Recycling Test Provident Fund	22,737.96	3,730,755.39
		Closing Balance		3,730,755.39	3,730,755.39

Administration Fee Accounts

Report Name: Accounts Admin Report

The following steps must be completed when producing the report.

Parent Select the relevant Parent

Batches Select “Batch Management”

Batch Type Click on the Batch Type drop down and select “All”

Batch Search and select “Accounts Admin Report”

New Batch Click on the “New Batch” button

Edit Double click on the edit hyperlink

Client Select Client from the drop down

Date 1 Enter the First day of the Financial Year

Date 2 Enter the last day of the Financial Year

Save Press the “Save” button

Execute Press the “Execute” button

The following Income Statement and Balance Sheet Ledgers are used: -

Income Statement

Ledger Code and Account Description	Description
3010/3-2	Expenses / Expenses - Administration

Balance Sheet

Ledger Code and Account Description	Description
2000/3-2	Creditors Ledger / Expenses - Administration

Report Notes

The total of the “Accrual” column must balance to the expense ledger
3010/3-2. This amount is the total administration fee due for the relevant period.

The “Payment” column reflects all payments made during the relevant period.

The “Over/Under” column reflects the difference between the accrual and the actual payment made. The total of the “Over/Under” column must balance to the balance sheet ledger 2000/3-2.

The “Annualised Salaries” column refers to the annualised salaries for the specific month.

The “Percentage” column is the administration fee rate as per the signed service level agreement between the Fund and the Administrator.

The “No Members” column, reflects all active members at the relevant date.

The “Cost per Member” column reflects an apportioned cost per member and is merely for information purposes.

ABC Consultants and Actuaries Administrators (Pty) Ltd

ACCOUNTS ADMIN REPORT

Umbrella Fund- Test (Pty) Ltd

Report information from 01/01/2006 to 31/12/2007

Month End	Payee	Accrual	Payment	Over/ Under	Annualised Salaries	%	No Members	Cost Per Member
	Summary for - Administration Fees
31/12/2005	_Opening Value		0.00	0.00		0.000	0	0
31/01/2006	Fund Payment		0.00	0.00			0	0

	Totals	0.00	0.00	0.00

	Summary for - ABC Administrators
31/12/2005	_Opening Value		-14810.54	14810.54		0.000	0	0
31/01/2006	ABC Administrator	15880.59	14972.10	908.49	44,839,481	0.424	117	135.73
28/02/2006	ABC Administrator	15741.19	15880.60	-139.41	44,445,879	0.424	116	135.7
31/03/2006	ABC Administrator	15741.19	15678.50	62.69	44,445,879	0.424	116	135.7
30/04/2006	ABC Administrator	15741.19	15741.20	-0.01	44,445,879	0.424	116	135.7
31/05/2006	ABC Administrator	15741.19	15741.20	-0.01	44,445,887	0.424	116	135.7
30/06/2006	ABC Administrator	15741.19	15741.20	-0.01	44,445,887	0.424	116	135.7
31/07/2006	ABC Administrator	15969.66	15741.20	228.46	45,090,952	0.424	118	135.34
31/08/2006	ABC Administrator	16043.56	15969.70	73.86	45,299,628	0.424	118	135.96
30/09/2006	ABC Administrator	15866.45	16043.60	-177.15	44,799,528	0.424	116	136.78
31/10/2006	ABC Administrator	15956.21	15866.50	89.71	45,052,960	0.424	117	136.38
30/11/2006	ABC Administrator	15915.54	15956.20	-40.66	44,938,112	0.424	116	137.2
31/12/2006	Fund Payment		15915.50	-15915.50			0	0

	Totals	174337.96	174436.96	-99.00

	Summary for - ABC C&A
31/12/2005	_Opening Value		-20846.94	20846.94		0.000	0	0
31/01/2006	ABC C&A	8811.16	8473.69	337.47	44,839,481	0.235	117	75.31
28/02/2006	ABC C&A	8754.98		8754.98	44,445,879	0.236	116	75.47
31/03/2006	ABC C&A	8754.98		8754.98	44,445,879	0.236	116	75.47
30/04/2006	ABC C&A	8754.98		8754.98	44,445,879	0.236	116	75.47
31/05/2006	ABC C&A	8754.98		8754.98	44,445,887	0.236	116	75.47
30/06/2006	ABC C&A	8754.98		8754.98	44,445,887	0.236	116	75.47
31/07/2006	ABC C&A	8838.70		8838.70	45,090,952	0.235	118	74.9
31/08/2006	ABC C&A	8864.93		8864.93	45,299,628	0.234	118	75.13
30/09/2006	ABC C&A	8800.36		8800.36	44,799,528	0.235	116	75.87
31/10/2006	ABC C&A	8829.58		8829.58	45,052,960	0.235	117	75.47
30/11/2006	ABC C&A	8817.22		8817.22	44,938,112	0.235	116	76.01

	Totals	96736.85	-12373.25	109110.10

Risk Premiums Accounts

Report Name: Accounts Risk Report

The following steps must be completed when producing the report.

Parent Select the relevant Parent

Batches Select “Batch Management”

Batch Type Click on the Batch Type drop down and select “All”

Batch Search and select “Accounts Risk Report”

New Batch Click on the “New Batch” button

Edit Double click on the edit hyperlink

Client Select Client from the drop down

Date 1 Enter the First day of the Financial Year

Date 2 Enter the last day of the Financial Year

Client Parent Select Parent from the drop down

Save Press the “Save” button

Execute Press the “Execute” button

The following Income Statement and Balance Sheet Ledgers are used: -

Income Statement

Ledger Code and Account Description	Description
3000/2-***	Risk Premiums/***

Balance Sheet

Ledger Code and Account Description	Description
2000/2-***	Creditors Ledger – Risk/***

*** depends on the set up of the risk on the system as it could be GLA, PHI, Funeral and/or Spouses cover. The ledger accounts will be the same but the account description will differ per the risk type setup.

Report Notes

The total of the “Accrual” column must balance to the expense ledger 3000/2-***. This amount refers to the total risk premiums due for the period.

The “Payment” column reflects all payments made during the period.

The “Over/Under” column reflects the difference between the accrual and the actual risk payment made. The total of the “Over/Under” column must balance to the balance sheet ledger 2000/2-***.

The “Annualised Salaries” column reflects the annualised salaries for the specific month.

The “Percentage” column reflects the rate, as per the insurer, for the relevant period. Please note: If there are various risk rates for different categories of members, the percentage reflected in this column is the apportioned percentage over the risk categories of the Fund.

This report is not specific to one insurer only. All insurers used throughout the financial year will be listed separately.

ABC Administrators (Pty) Ltd

Fund Registration Number - 12xxxxxxx
Fund PAYE Number - 7xxxxxxx
SARS Registration Number - 1820xxxxxx

ACCOUNTS RECONCILIATION REPORT

Umbrella Fund- Tests Provident Fund

Report information from 01/01/2006 to 31/12/2006

Month End	Payee	Accrual	Payment	Over/Under	Annualised Salaries	%
	Summary for - Test- Capital Dis Lib
31/12/2005	_Opening Value		-18497.59	18497.59		0.000%
	_______________________
	Totals	0.00	-18497.59	18497.59

	Summary for - Test- Capital Dis NRA 45
01/01/2006	Prior Year Payment		0.00	0.00
31/08/2006	Metropolitan Life	262.74	260.81	1.93	350,396	0.899%
30/09/2006	Metropolitan Life	260.81		260.81	347,822	0.899%
31/10/2006	Metropolitan Life	390.70	390.70	0.00	520,942	0.899%
30/11/2006	Metropolitan Life	377.58	377.58	0.00	503,455	0.899%
	_______________________
	Totals	1291.83	1029.09	262.74

	Summary for - Test- Capital Dis NRA 55
01/01/2006	Prior Year Payment		0.00	0.00
31/08/2006	Metropolitan Life	5566.74	5659.84	-93.10	7,421,921	0.900%
30/09/2006	Metropolitan Life	5659.84		5659.84	7,546,047	0.900%
31/10/2006	Metropolitan Life	5697.48	5697.48	0.00	7,596,226	0.900%
30/11/2006	Metropolitan Life	5613.71	5613.71	0.00	7,484,541	0.900%
	______________________
	Totals	22537.77	16971.03	5566.74

	Summary for - Test- Capital Dis NRA 60
31/12/2005	_Opening Value		-4486.19	4486.19		0.000%
01/01/2006	Prior Year Payment		6314.08	-6314.08
31/01/2006	Metropolitan Life	5572.52	6322.97	-750.45	7,429,958	0.900%
28/02/2006	Metropolitan Life	5456.69		5456.69	7,275,522	0.900%
31/03/2006	Metropolitan Life	5527.99	11797.02	-6269.03	7,370,573	0.900%
30/04/2006	Metropolitan Life	5734.43	5734.43	0.00	7,645,793	0.900%
31/05/2006	Metropolitan Life	5687.79	5687.79	0.00	7,583,614	0.900%
30/06/2006	Metropolitan Life	5708.56		5708.56	7,611,297	0.900%
31/07/2006	Metropolitan Life	5658.14	5658.14	0.00	7,544,069	0.900%
31/08/2006	Metropolitan Life	191.15	214.68	-23.53	254,847	0.900%
30/09/2006	Metropolitan Life	214.68		214.68	286,227	0.900%
31/10/2006	Metropolitan Life	214.68	214.68	0.00	286,227	0.900%
30/11/2006	Metropolitan Life	217.56		217.56	290,067	0.900%
	_______________________
	Totals	40184.19	37457.60	2726.59
	Summary for - Test- GLA Lib
31/12/2005	_Opening Value		-67740.73	67740.73		0.000%
	_______________________
	Totals	0.00	-67740.73	67740.73
	Summary for - Test- GLA NRA 45
01/01/2006	Prior Year Payment		0.00	0.00
31/08/2006	Metropolitan Life	934.47	927.60	6.87	350,396	3.200%
30/09/2006	Metropolitan Life	927.60		927.60	347,822	3.200%
31/10/2006	Metropolitan Life	1389.22	1389.22	0.00	520,942	3.200%
30/11/2006	Metropolitan Life	1342.59	1342.59	0.00	503,455	3.200%
	_______________________
	Totals	4593.88	3659.41	934.47
	Summary for - Test- GLA NRA 55
01/01/2006	Prior Year Payment		0.00	0.00
31/08/2006	Metropolitan Life	19791.53	20122.52	-330.99	7,421,921	3.199%
30/09/2006	Metropolitan Life	20122.52		20122.52	7,546,047	3.199%
31/10/2006	Metropolitan Life	20256.32	20256.32	0.00	7,596,226	3.199%
30/11/2006	Metropolitan Life	19958.51	19958.51	0.00	7,484,541	3.199%
	_______________________
	Totals	80128.88	60337.35	19791.53

	Summary for - Test- GLA NRA 60
31/12/2005	_Opening Value		-16276.80	16276.80		0.000%
01/01/2006	Prior Year Payment		22916.74	-22916.74
31/01/2006	Metropolitan Life	20189.02	22907.85	-2718.83	7,570,676	3.200%
28/02/2006	Metropolitan Life	19777.17		19777.17	7,416,241	3.200%
31/03/2006	Metropolitan Life	20030.63	42751.70	-22721.07	7,511,291	3.200%
30/04/2006	Metropolitan Life	20825.27	20825.27	0.00	7,809,306	3.200%
31/05/2006	Metropolitan Life	20625.86	20625.86	0.00	7,734,530	3.200%
30/06/2006	Metropolitan Life	20699.67		20699.67	7,762,213	3.200%
31/07/2006	Metropolitan Life	20562.23	20562.23	0.00	7,710,685	3.200%
31/08/2006	Metropolitan Life	751.83	883.03	-131.20	281,947	3.199%
30/09/2006	Metropolitan Life	883.03		883.03	331,147	3.199%
31/10/2006	Metropolitan Life	883.03	883.03	0.00	331,147	3.199%
30/11/2006	Metropolitan Life	893.27	893.27	0.00	334,987	3.199%
	______________________
	Totals	146121.01	136972.18	9148.83

Exit Accounts

Report Name: Membership Reconciliation Report

There are two reports that can be generated to support the expense accounts. The first report is the “Membership Reconciliation Report”.

The following steps must be completed when producing the report.

Parent Select the relevant Parent

Batches Select “Batch Management”

Batch Type Click on the Batch Type drop down and select “All”

Batch Search and select “Membership Reconciliation Report”

New Batch Click on the “New Batch” button

Edit Double click on the edit hyperlink

Client Select Client from the drop down

Date 1 Enter the First day of the Financial Year

Date 2 Enter the last day of the Financial Year

Client Parent Select Parent from the drop down

Selection Type Select “Member Details”

Save Press the “Save” button

Execute Press the “Execute” button

The following Income Statement and Balance Sheet Ledgers are used: -

Income Statement

Ledger Code and Account Description	Description
3030/29-16	Member Exits/Exit Payment - Early Retirement
3030/29-6	Member Exits/Exit Payment - Retirement
3030/29-4	Member Exits/Exit Payment – Dismissal
3030/29-1	Member Exits/Exit Payment - Resignation
3030/29-5	Member Exits/Exit Payment - Retrenchment
3030/29-3	Member Exits/Exit Payment - Transfer
3030/29-10	Member Exits/Exit Payment - Death

The balance sheet entry is the Benefit due account 2000/29, which combines all exit types. Should there be company indebtedness, this will be reflected in a separate ledger account (2000/52 Creditors/Settlement of Company Indebtedness).

Should late payment interest on benefits be applicable, the following ledger accounts are used: -

Income Statement

Ledger Code and Account Description	Description
3090/29-16	Late Payment Interest / Early Retirement
3090/29-6	Late Payment Interest / Retirement
3090/29-4	Late Payment Interest / Dismissal
3090/29-1	Late Payment Interest / Resignation
3090/29-5	Late Payment Interest / Retrenchment
3090/29-3	Late Payment Interest / Transfer
3090/29-10	Late Payment Interest / Death

Report Notes

This report reflects the various exits as per the selected dates. Report provides a summary of the members, exit types and corresponding benefit values. The “Total Benefit in the Period” of this report, must balance to the total of all the benefit expense accounts.

ABC Consultants and Actuaries Administrators (Pty) Ltd

Fund Registration Number - 12xxxxxxx
Fund PAYE Number - 7xxxxxxxx
SARS Registration Number - 1820xxxxxx

MEMBERSHIP RECONCILIATION REPORT
FROM : 01 January 2006
TO : 31 December 2006

FOR CLIENT PARENT : Test (Pty) Ltd

NARRATIVE	DATES	Fund Name								MEMBERSHIP NUMBER
			Exit Ledger	Commuted Benefit	Inv Product	Inv Product	Inv Product	Inv Product	Inv Product
126522, SAROOP, R K		Withdrawal - Resignation - Aug 31 2006	4755.5	4755.5	4,755.50	0.00	0.00	0.00	0.00	Test Management Provident Fund
29190, Itzikovitz, R		Withdrawal - Transfer - Jan 31 2006	416916.77	416916.77	416,916.77	0.00	0.00	0.00	0.00	Test Management Provident Fund
29255, Koster, Andries Frederick		Withdrawal - Transfer - Oct 31 2006	631076.6	631076.6	631,076.60	0.00	0.00	0.00	0.00	Test Management Provident Fund
47333, Vermeulen, Jwa		Withdrawal - Transfer - Aug 31 2006	135773.03	135773.03	135,773.03	0.00	0.00	0.00	0.00	Test Management Provident Fund
		Total Benefit in Period	1188521.9	1188521.9	1,188,521.90	0.00	0.00	0.00	0.00

Categorisation of Members as at Closing Date
Grade 13 and 14										48
Grade 15 and above										66
Grade 15 and above Conservative										2
Grade 15 and above Money Market										1
Grade 15 and above No Funeral										1

NOTE - THIS REPORT WILL ONLY SHOW 5 INVESTMENT PRODUCTS, IF MORE EXIST FOR A MEMBER PLEASE CONTACT THE SYSTEM ADMINISTRATOR

Report Name: Parent Benefits Due – Build Up

The second report that can be generated is the “Parent Benefits Due - Build Up”. This report supports the expense accounts as well as the balance sheet (benefit due) account. This report is exported into excel.

This report should also be used to extract all unclaimed benefits. Exits six months and older must be reflected as “Unclaimed Benefits” in the Annual Financial Statements. As all information is populated into Excel, the User is to merely extract all unclaimed benefits for the six-month period.

The following steps must be completed when producing the report.

Parent Select the relevant Parent

Batches Select “Batch Management”

Batch Type Click on the Batch Type drop down and select “All”

Batch Search and select “Parent Benefits Due – Build Up”

New Batch Click on the “New Batch” button

Edit Double click on the edit hyperlink

File Name Create a file name for this export

Date 1 Enter the First day of the Financial Year

Date 2 Enter the last day of the Financial Year

Client Parent Select Parent from the drop down

Save Press the “Save” button

Execute Press the “Execute” button

Report Notes

The “Opening Balance” column is the closing balance of the benefits due from the prior year. The one exception to this amount would be for any late exits from the prior year. These exits would reflect as part of the opening balance. In this instance, the audit period would have been locked and any late exits would have raised the account entries on the first day of the new period.

The “Accruals in the Period” column reflects the exits in the period. The total of this column will be the total of all exit types in the various expense accounts.

The “Late Interest” column is the late payment interest allocated in the period to the applicable members. The total of this column is the total of the various late payment interest expense accounts.

The “Payment Made” column reflects the payments made in respect of benefits in the current period.

The “Tax Accrued” column reflects the tax deducted from the member’s gross benefit.

The “Closing Balance” column reflects the benefit that is still due to the member at the year end. The total of this column must balance to the benefits due account (2000/29) on the Trial Balance.

Parent Benefit Due Build-Up Report

Name	Open Balance	Accruals in Period	Late interest	Payment Made	Tax Accrued in Period	Close Balance	MemberID	Fore name	Surname	ER Ref	Exit Type	Date Exit	BirthDate
Members	6	0	0	0	0	0
Van Wxxxx,L F	-13680.24	0	0	0	0	-13680.24	29238	L F	Van Wxxxx	10212	Death	30/09/2003	24/12/1942
Sxxxx,Rene	255696.88	0	0	165563.49	90133.39	0	31601	Rene	Sxxxx	71207	Withdrawal Resignation	31/08/2005	07/01/1963
Ixxxx,R	0	416916.77	0	416916.77	0	0	29190	R	Ixxxx	20908	Withdrawal Transfer	31/01/2006	21/06/1965
Sxxxx,R K	0	4755.5	0	3916.14	839.36	0	126522	R K	Sxxxx	16516	Withdrawal Resignation	31/08/2006	27/07/1971
Vxxxx,Jwa	0	135773.03	0	0	0	135773.03	47333	Jwa	Vxxxx	71258	Withdrawal Transfer	31/08/2006	27/01/1971
Kxxxx,A.F.	0	631076.6	0	631076.6	0	0	29255	A. F.	Kxxxx	14470	Withdrawal Transfer	31/10/2006	16/06/1962
Total Benefits Due	242016.64	1188521.9	0	1217473	90972.75	122092.79

Parent Benefit Due Build-Up Report Continued

Name	IDNo	ClientName	Paypoint	Payments Made
Members				No
Van Wxxxx,L F	4212245052003	Test Management Provident Fund	Payroll 7	Yes
Sxxxx,Rene	6301070002080	Test Management Provident Fund	Payroll 8	Yes
Ixxxx,R	6506215691080	Test Management Provident Fund	F&WW	Yes
Sxxxx,R K	7107275035083	Test Management Provident Fund	Payroll 6	Yes
Vxxxx,Jwa	7101275325081	Test Management Provident Fund	Payroll 7	No
Kxxxx,A.F.	6206165152080	Test Management Provident Fund	Payroll 6	Yes
Total Benefits Due				No

Company Indebtedness or IT 88?

Report Name: Parent Benefits Due

Due to these accounts being reflected separately on the Trial Balance they would not appear on the “Parent Benefits Due - Build Up”. A “Parents Benefits Due” report can be generated reflecting the total outstanding benefits. This report will be exported into excel.

The following steps must be completed when producing the report.

Parent Select the relevant Parent

Batches Select “Batch Management”

Batch Type Click on the Batch Type drop down and select “All”

Batch Search and select “Parent Benefits Due”

New Batch Click on the “New Batch” button

Edit Double click on the edit hyperlink

Effective Date Enter the last day of the year end

File Name Create a file name for this export

Client Parent Select Parent from the drop down

Save Press the “Save” button

Execute Press the “Execute” button

The following Balance Sheet ledgers are used: -

Balance Sheet

Ledger Code and Account Description	Description
2000/29	Creditors Ledger – Benefits Due
2000/52	Creditors/Company Indebtedness
2000/109	Creditors/Tax on member – IT88

Report Notes

This report reflects the combination of the following accounts per member (including personal information), exit type and date of exit.

Parent Benefits Due

Name	Amount	MemberID	Forename	Surname	ER Ref	Exit Type	Date Exit	BirthDate	IDNo	ClientName	Paypoint
Members
Jwa,Vxxxx	135773.03	47333	Jwa	Vxxxx	71258	Withdrawal - Transfer	31/08/2006	27/01/1971	7xxxxxxxx	test	Payroll 7
L F,Van Wxxx	-13680.24	29238	L F	Van Wxxxx	10212	Death	30/09/2003	24/12/1942	4xxxxxxxx	test	Payroll 7

Creditors - Benefits Due
Company Indebtedness
Creditors - Indebtedness
Total Benefits Due	122092.79

Membership Reconciliation

Report Name: Membership Reconciliation Report

The following steps must be completed when producing the report.

Parent Select the relevant Parent

Batches Select “Batch Management”

Batch Type Click on the Batch Type drop down and select “All”

Batch Search and select “Membership Reconciliation Report”

New Batch Click on the “New Batch” button

Edit Double click on the edit hyperlink

Client Select Client from the drop down

Date 1 Enter the First day of the Financial Year

Date 2 Enter the Last day of the Financial Year

Client Parent Select Parent from the drop down

Report Option Select “Parent Details”

Save Press the “Save” button

Execute Press the “Execute” button

Report Notes

This report reflects the opening membership, all member movements throughout the period and provides a closing balance of all active members on the fund as at the year-end date.

ABC Consultants and Actuaries Administrators (Pty) Ltd

Fund Registration Number - 12xxxxxxx
Fund PAYE Number - 7xxxxxxxx
SARS Registration Number - 1820xxxxxx

MEMBERSHIP RECONCILIATION REPORT

FROM : 01 January 2006

TO : 31 December 2006

FOR CLIENT PARENT : Test (Pty) Ltd

NARRATIVE

DATES

Fund Name

MEMBERSHIP NUMBER

Exit Ledger

Commuted Benefit

Inv Product

Opening Membership as at

01 January 2006

Test

118

Withdrawal - Resignation

Test

-1

Withdrawal - Transfer

Test

-3

New Members

Test

Closing Membership as at

31 December 2006

Test

118

______________________

Categorisation of Members as at Closing Date

Grade 13 and 14

Grade 15 and above

Grade 15 and above Conservative

Grade 15 and above Money Market

Grade 15 and above No Funeral

NOTE - THIS REPORT WILL ONLY SHOW 5 INVESTMENT PRODUCTS, IF MORE EXIST FOR A MEMBER PLEASE CONTACT THE SYSTEM ADMINISTRATOR

Report Name: New Entrant Listing

A new entrant listing report can be generated to support the membership reconciliation report.

The following steps must be completed when producing the report.

Parent Select the relevant Parent

Batches Select “Batch Management”

Batch Type Click on the Batch Type drop down and select “All”

Batch Search and select “New Entrant Listing”

New Batch Click on the “New Batch” button

Edit Double click on the edit hyperlink

Client Leave blank. (This field should be left blank to include all clients

Date 1 Enter the First day of the Financial Year

Date 2 Enter the Last day of the Financial Year

Client Parent Select Parent from the drop down

Save Press the “Save” button

Execute Press the “Execute” button

Report Notes

This report provides a list of all the new entrants up to and including the selected dates.
Should the opening balance not correspond to the previous year’s closing balance, the following items must be investigated: -

- Late exits in respect of the previous year, that would not have reflected in the prior financial statements.
- New entrants that commenced membership on the first day of the current financial year.

ABC Consultants and Actuaries Administrators (Pty) Ltd

Fund Registration Number - 12xxxxxxx
Fund PAYE Number - 7xxxxxxxx
SARS Registration Number - 1820xxxxxxx

PARENT NEW MEMBER LISTING

UMBRELLA FUND - Test (Pty) Ltd

New Entrants for the Period from - 01/01/2006 to 31/12/2006

Employer Name	Member Name	Date Joined Fund	Date of Birth	Category	Paypoint	Identity Number
Test Management Provident Fund	Axxxx,E	01/01/2006	19/09/1966	Grade 13 and 14	Payroll 7
Test Management Provident Fund	Bxxxx,Bjm	01/01/2006	11/09/1963	Grade 13 and 14	Payroll 7
Test Management Provident Fund	Sxxxx,R K	01/07/2006	27/07/1971	Grade 13 and 14	Payroll 6	7xxxxxxxxxxx
Test Management Provident Fund	Sxxxx,PLB	01/07/2006	18/11/1973	Grade 13 and 14	Payroll 6
Test Management Provident Fund	Vxxxx,J G	01/10/2006	21/05/1972	Grade 13 and 14	Payroll 14
Test Management Provident Fund	Nxxxx,Sharon	01/11/2006		Grade 15 and above	Payroll 14

PAYE

The system accrues the gross amount of an exit benefit to the “Benefits Due Account” (2000/29), when the member is exited from the system and the exit workflow has been initiated. One of the steps in the workflow is to apply for tax in respect of the member’s gross benefit. When the tax amount has been received from SARS the system immediately accrues the PAYE to the PAYE account by crediting the PAYE account (2000/44) and debiting the benefits due account (2000/29). The PAYE remains in this account until it is paid across to SARS.

Report Name: Parent Benefit Tax - Build Up

A “Parent Benefit Tax – Build Up” report is generated to reflect all PAYE transactions. This report is exported into excel.

The following steps must be completed when producing the report.

Parent Select the relevant Parent

Batches Select “Batch Management”

Batch Type Click on the Batch Type drop down and select “All”

Batch Search and select “Parent Benefit Tax – Build Up”

New Batch Click on the “New Batch” button

Edit Double click on the edit hyperlink

File Name Create a file name for this export

Date 1 Enter the First day of the Financial Year

Date 2 Enter the Last day of the Financial Year

Client Parent Select Parent from the drop down

Save Press the “Save” button

Execute Press the “Execute” button

The following Balance Sheet Ledgers are used: -

Balance Sheet

Ledger Code and Account Description	Description
2000/29	Creditors Ledger – Benefits Due
2000/44	Creditors Ledger - Tax Payable

Report Notes

The “Open Balance” column is the closing balance of the PAYE Account (2000/44) from the prior year.

The “Accruals in Period” column reflects the PAYE deducted per member in the current financial period.

The “Tax Paid in Period” column reflects the actual payments made in respect of PAYE deducted in the specified period.

The “Close Balance” column is in respect of tax deducted from the member’s gross benefit, but not yet paid to SARS (2000/44) as at the end of the financial period.

The import also provides additional useful tax information such as Directive Numbers, Date tax paid and the relevant tax year per member etc.

Parent Benefit Tax – Build Up

Name	Open Balance	Accruals in Period	Tax Paid in Period	Close Balance	IRP5	Directive	Date Tax Paid	Tax Year	Member ID	Fore name	Surname	ER Ref	Exit Type
Members	3	0	0	0	0
Sxxxx,Rene	0	90133.39	-90133.39	0	4	4934653	06/02/2006	2006	31601	R	Steyn	71207	Withdrawal Resignation
Sxxxx,R K	0	839.36	-839.36	0	1	5642270	03/10/2006	2007	126522	R K	SAROOP	16516	Withdrawal Resignation
Total Benefits Tax Due	0	90972.75	-90972.75	0	0

Name	Date Exit	BirthDate	IDNo	ClientName	Paypoint
Members
Sxxxx,Rene	31/08/2005	07/01/1963	6xxxxxxxx	Test Management Provident Fund	Payroll 8
Sxxxx,R K	31/08/2006	27/07/1971	7xxxxxxxx	Test Management Provident Fund	Payroll 6
Total Benefits Tax Due

RISK RECOVERY ACCOUNTS

Report Name: Parent Death Benefits Schedule

A “Parent Death Benefits Schedule” report is generated to reflect all accruals, receipts, and outstanding risk recoveries for the selected period. This report is exported into excel. The Everest System accrues the recovery as a debtor, via the exit workflow process. This will create an Income Account, (Risk Recovery/Risk Lumpsum Recovery (4100/81)) and a Debtor Account, (Debtors/Risk Lumpsum Recovery (1020/81)). All receipts reflected in the Bank Reconciliation and linked accordingly will reduce the Debtor Account.

Please Note: It is imperative that the process of receiving the Reassurance has been performed via the Everest System: Parent/Cashflows/Reassurance Receivable. This report will only reflect correctly if the process is concluded.

The following steps must be completed when producing the report.

Parent Select the relevant Parent

Batches Select “Batch Management”

Batch Type Click on the Batch Type drop down and select “All”

Batch Search and select “Parent Death Benefits Schedule”

New Batch Click on the “New Batch” button

Edit Double click on the edit hyperlink

File Name Create a file name for this export

Date 1 Enter the First day of the Financial Year

Date 2 Enter the Last day of the Financial Year

Client Parent Select Parent from the drop down

Save Press the “Save” button

Execute Press the “Execute” button

The following Income Statement and Balance Sheet Ledgers are used: -

Income Statement

Ledger Code and Account Description	Description
4100/81	Risk Recovery/Risk Lumpsum Recovery

Balance Sheet

Ledger Code and Account Description	Description
1020/81	Debtors Ledger – Risk Lumpsum Recovery

Report Notes

The “Gross Benefit” column reflects the total of the member credit (SOF) together with the risk recovery amount.

The “SOF Amount” column reflects only the member credit at date of exit.

The “Opening Balance” column reflects the closing balance of the Risk Recovery – Receivable Account (1020/81) from the prior year.

The total of the “REINS Amount” column reflects the Income Account, Risk Recovery/Risk Lumpsum Recovery (4100/81). This amount is reflected on the Trial Balance.

The “RECOVER Amount” column reflects all amounts received from the insurer during the selected period.

The total of the “DEBTOR REINS Amount” column reflects the Debtor Account, Debtors/Risk Lumpsum Recovery (1020/81). This amount is made up of the accrual (REINS Amount) raised less the recovery (RECOVER Amount) received.

The “Last Recover Date” column reflects the date the recovery was received. If there were several deposits in respect of a member, the date of the last deposit will be used in this report.

This report also provides additional static data relating to membership i.e., member details, exit types, Client and Paypoint details etc.

Parent Death Benefits Schedule

Name

Member ID

Fore name

Surname

ER Ref

Exit Type

Date Exit

BirthDate

IDNo

Client Name

Paypoint

Gross Benefit

SOF Amount

Opening Balance

No Reference

R G,Wxxxx

61395

R G

Wxxxx

159

Death

31/05/2006

24/05/1958

5xxxxxxxx

Test

Executive

3280868.23

864818.23

Grand Total

3280868.23

864818.23

Name	REINS Amount	RECOVER Amount	DEBTOR REINS Amount	Last Recover Date
No Reference	0		0
R G,Wxxxx	2416050	2416050	0	28/06/2006
Grand Total	2416050	2416050	0

TRANSFERS IN ACCOUNTS

Report Name: Audit Parent Ledgers

The following steps must be completed when producing the report.

Parent Select the relevant Parent

Batches Select “Batch Management”

Batch Type Click on the Batch Type drop down and select “All”

Batch Search and select “Audit Parent Ledgers”

New Batch Click on the “New Batch” button

Edit Double click on the edit hyperlink

Client Select Client from the drop down

Effective Date Enter the last day of the Financial Year

Amount 1 Enter 4020 (Ledger code)

Amount 2 Enter 32 (Account Description)

Date 1 Enter the First day of the Financial Year

Date 2 Enter the Last day of the Financial Year

Client Parent Select Parent from the drop down

Ledger Leave blank

Description Leave blank

Report Option Select “Client details” from the drop down

Save Press the “Save” button

Execute Press the “Execute” button

The following Income Statement Ledgers are used: -

Income Statement

Ledger Code and Account Description	Description
4020/32	Transfer In/Gross Single Premiums – Capital Portion
4020/35	Transfer In/Gross Single Premiums – Interest Portion

Report Notes

The administrator performs an import of all Single Premiums per member. The Ledger Accounts are system generated from this process.

This report reflects the Accounting Date, Client Name, Single Premium Type, and amount of the transaction.

The same report must be generated to reflect the Interest Portion (4020/35) of the transaction. The User is to merely change amount 1 and amount 2 in the Batch Management Screen respectively.

NOTE

The Auditors require the following supporting documentation: -

Recognition of transfer in respect of individual transfers, and/or
Section 14 applications, approvals, and final transfer values.

ABC Consultants and Actuaries Administrators (Pty) Ltd

Fund Registration Number - 12xxxxxxx
Fund PAYE Number - 7xxxxxxx
SARS Registration Number - 1820xxxxxxx

PARENT LEDGER INFORMATION

Umbrella Fund- Test Retirement Fund
Processed for accounting period from 01/01/2006 to 31/12/2006 for Ledger - Transfer In and Description - Gross Single Premiums - Capital Portion

Accounting Date	Client Name	Amount Type	Amount
30/01/2006	Test Retirement Fund Mxxxxx,VB	Employee	77789.36
	Total Amount for Employee		77789.36

	Grand Total		77789.36

IMPORTANT NOTES

The remainder of this section relates to specific ledger accounts which are generated via journal entries, as these transactions are not system generated.

The various ledger accounts are dealt with separately in the document below and are listed as follows: -

investments,
ad hoc Expense/Income Accounts,
creditors, and
debtors.

ADDITIONAL LEDGER ACCOUNTS

Investments

Audit certificates must be requested from all investment managers together with a Regulation 28 Certificate.

The opening balance of the investment accounts on the Everest system must balance to the opening balance of the audit certificate and the investments reflected on the signed Annual Financial Statements from the prior year.

To replicate the audit certificates on the Everest System, the following process must be followed:

Managed Funds

The investment accounts must be updated with the management fees, interest, and dividends, via the Investment Screen. Refer to “Unit Pricing Module” pages 46 to 54 for further details.

Unitised Funds

The investment accounts must be updated with the management fees, interest and dividends. Refer to “Investment & Unit Pricing Manual” for further details.

The investment related accounts (i.e., The management fees, dividends, interest, profits/losses on investment, adjustment to fair value of investments) must correlate exactly to the audit certificates. Should this not be the case, journal entries must be processed on the Everest System, to reallocate the investment related accounts. The closing balance of all the investments will be reflected on the Annual Financial Statements.

Adhoc Expense/Income Accounts

All other expense accounts e.g. FSB Levies, Fidelity Guarantee Insurance, Reserve Bank Reporting Fees, etc, can be reported on by generating an “Audit Parent Ledgers Account”, per ledger account. A breakdown of these accounts is provided in the report.

If at year end, there needs to be an accrual of an expense/income, this can be done by processing a journal entry.

Parent Creditors

Report Name: Parent Creditors

The following steps must be completed when producing the report.

Parent Select the relevant Parent

Batches Select “Batch Management”

Batch Type Click on the Batch Type drop down and select “All”

Batch Search and select “Parent Creditors”

New Batch Click on the “New Batch” button

Edit Double click on the edit hyperlink

Effective Date Enter the actual date creditors balance should be generated

Client Parent Select Parent from the drop down

Save Press the “Save” button

Execute Press the “Execute” button

Report Notes

This report provides a list of all Creditors at the year end.

The creditors listed in this report must balance to the various Creditor Accounts.

The member exits reflected at the bottom of the report should be ignored.

ABC Consultants and Actuaries Administrators (Pty) Ltd

Fund Registration Number - 12xxxxxxx
Fund PAYE Number - 7xxxxxxxxx
SARS Registration Number - 1820xxxxxx

PARENT CREDITORS

UMBRELLA FUND - Test Provident

Opening Date - 01/01/2006

Closing Date - 31/12/2006

Processing Date - 24/08/2007

Transaction Type	Debit	Credit	Description
SARS Benefit Tax Payable		59,171.16

SARS RFT Tax Payable		23,049.92

Fund Creditors - excluding Exits
		372,807.57
Admin fee - Glenrand Admin fee - Glenrand		60,810.29
Test Pension Fund Test Pension Fund	42,409.92
Capital Alliance Life Capital Alliance Life	365,051.36
D & T D & T	53,170.00
Deloitte & Touche Deloitte & Touche AFR	34,884.00
Financial Services Board FSB Levies**	13,333.78
FSB FSB Levies		30.00
HOUSING LOANS HOUSING LOANS		38,297.53
M Hxxxx		331.94
Momentum Momentum Funds @ Work	12,150.00
ABC (Admin Services) ABC Administrators		0.08
ABC C&A ABC C&A		40,067.35
ABC Consultants & Actuaries Do Not Use - ABC (Consulting Fees)		83,439.00
Other Other		837.84
PENALTIES LATE PAYMENT SARS PENALTIES LATE PAYMENT SARS		1,734.63
RSC Billing Account RSC Levies **	1,340.42
SARS - PAYE SARS * (PAYE) EFT (12)		13,717.13
SARS Mxxx FS		559.80

Parent Debtors

Report Name: Parent Debtors

The following steps must be completed when producing the report.

Parent Select the relevant Parent

Batches Select “Batch Management”

Batch Type Click on the Batch Type drop down and select “All”

Batch Search and select “Parent Debtors”

New Batch Click on the “New Batch” button

Edit Double click on the edit hyperlink

Effective Date Enter the actual date creditors balance should be generated

Client Parent Select Parent from the drop down

Save Press the “Save” button

Execute Press the “Execute” button

Report Notes

This report provides a list of all Debtors at the year end.

The Debtors listed in this report must balance to the various Debtor Accounts.

PARENT DEBTORS

UMBRELLA FUND - Test Provident Fund
Opening Date - 01/01/2006
Closing Date - 31/12/2006
Processing Date - 31/12/2006
Transaction Type	Debit	Credit	Description
Analysis of Contributions
Unallocated Deposits		3,062.61	Unallocated Deposits
Test		143,809.15	Test Operations/Test
Test	4,980,471.04
Risk Recoveries
Insurance Recovery	491,119.00		(Capital Alliance Life Limited)
Other Debtors
		220,622.83	Single Premiums Received
Liberly Life	175,962.13		Sundry Debtors
Test	172,499.85		Single Premiums Received

Total	5,452,557.43

Parent Member Credits

At this point a comprehensive analysis of all Member related accounts and all Ledger Accounts would have been completed. A final “Parent Trial Balance – Ledgers” can be generated. (Refer to page 7 of this document).

Finally, a “Parent Member Credits” report must be generated.

Report Name: Parent Member Credits

The following steps must be completed when producing the report.

Parent Select the relevant Parent

Batches Select “Batch Management”

Batch Type Click on the Batch Type drop down and select “All”

Batch Search and select “Parent Member Credits”

New Batch Click on the “New Batch” button

Edit Double click on the edit hyperlink

Client Select from the drop down

Effective Date Enter the actual date creditors balance should be generated

Client Parent Select Parent from the drop down

Save Press the “Save” button

Execute Press the “Execute” button

Report Notes

This report provides a list of all active members together with their Fund Credits at the year end.

The information provided on this report must be used to conduct an Asset and Liability match together with the relevant information extracted from the Trial Balance. Should the difference between the assets and liabilities be greater than 1%, it must be further investigated.

ABC Consultants and Actuaries Administrators (Pty) Ltd

Umbrella Fund- Test Pension Fund
Report Date - 31/12/2006

PARENT FUND MEMBERSHIP REPORT

Emp Ref No.	System No		Client Name		Member Name	Category	Employee Portion			Employer Portion	Fund Credit
C774	125932		Test Pension Fund		Axxxx, Candice	All Female Members	2,190.67			1,404.98	3,595.65
C664	69785		Test Pension Fund		Axxxx, T	All Male Members	17,106.04			11,222.60	28,328.64
C788	146302		Test Pension Fund		Axxxx, Desigan	All Male Members	255.00			145.67	400.67
C684	69786		Test Pension Fund		Bxxxx, F W	All Male Members	11,356.64			7,665.84	19,022.48
C300	69787		Test Pension Fund		Bxxxx, Anthony	All Male Members	149,401.36			661,085.41	810,486.77
C787	146301		Test Pension Fund		Bxxxx, Michael	All Male Members	255.00			145.67	400.67
C192	69782		Test Pension Fund		Bxxxx, M	All Male Members	138,290.37			183,744.84	322,035.21
C418	69783		Test Pension Fund		Cxxxx, Razia	All Female Members	53,286.04			66,457.61	119,743.65
C261	69784		Test Pension Fund		Cxxxx, Anesh	All Male Members	87,320.54			70,704.88	158,025.42
C747	82728		Test Pension Fund		Cxxxx, Stephen	All Male Members	2,587.90			1,277.70	3,865.60
C211	69780		Test Pension Fund		Cxxxx, T	All Female Members	61,402.66			42,282.38	103,685.04
C243	69781		Test Pension Fund		Dxxxx, M	All Male Members	76,681.89			58,549.18	135,231.07
C553	69776		Test Pension Fund		Dxxxx, R J	All Male Members	19,830.75			37,831.66	57,662.41
C369	69777		Test Pension Fund		Dxxxx, Navnit	All Male Members	91,219.61			395,497.01	486,716.62
C778	135001		Test Pension Fund		Dxxxx, Shane	All Male Members	811.30			466.13	1,277.43
C005	69775		Test Pension Fund		Dxxxx, J	Paid-up members	0.00			0.00	0.00
C704	69845		Test Pension Fund		Dxxxx, R	All Male Members	8,450.83			5,729.62	14,180.45
C745	82729		Test Pension Fund		Dxxxx, Annemarie	All Female Members	8,425.86			5,671.41	14,097.27
C455	69846		Test Pension Fund		Exxxx, Nicholas	All Male Members	81,902.97			41,844.05	123,747.02
C023	69847		Test Pension Fund		Exxxx, G	All Male Members	159,677.23			349,402.82	509,080.05
C674	69842		Test Pension Fund		Exxxx, G C	All Male Members	9,914.97			6,285.42	16,200.39
C663	69843		Test Pension Fund		Exxxx, R S	All Male Members	10,677.05			6,637.86	17,314.91
C750	86287		Test Pension Fund		Fxxxx, Robert	All Male Members	4,013.28			2,385.36	6,398.64
C101	69839		Test Pension Fund		Gxxxx, C	All Female Members	110,822.11			896,820.57	1,007,642.68
C425	69840		Test Pension Fund		Gxxxx, Tennille	All Female Members	39,599.43			20,310.28	59,909.71
C461	69841		Test Pension Fund		Gxxxx, Vanessa	All Female Members	74,075.59			67,714.03	141,789.62
C777	135002		Test Pension Fund		Gxxxx, Jethro	All Male Members	811.30			466.13	1,277.43
C519	69836		Test Pension Fund		Gxxxx, Sihle	All Male Members	18,605.00			10,931.33	29,536.33
C764	105775		Test Pension Fund		Hxxxx, Francois	All Male Members	2,558.59			1,443.14	4,001.73
C759	105771		Test Pension Fund		Hxxxx, Ushma	All Female Members	4,952.12			3,245.84	8,197.96
C385	69834		Test Pension Fund		Hxxxx, Sibusiso	All Male Members	27,214.79			14,048.29	41,263.08
C721	69855		Test Pension Fund		Hxxxx, Martin	All Male Members	4,841.09			2,876.94	7,718.03
C631	69830		Test Pension Fund		Hxxxx, J	All Male Members	14,324.62			8,640.75	22,965.37
C011	69835		Test Pension Fund		Hxxxx, N	All Male Members	163,365.93			815,094.09	978,460.02
C507	69832		Test Pension Fund		Jxxxx, Nazia	All Female Members	26,114.29			13,202.58	39,316.87
C172	69828		Test Pension Fund		Kxxxx, Mxxxx	All Male Members	60,103.68			48,652.40	108,756.08
C731	77262		Test Pension Fund		Kxxxx, C	All Male Members	6,860.88			4,458.65	11,319.53
C608	69829		Test Pension Fund		Kxxxx, A	All Male Members	23,186.69			14,051.45	37,238.14
C350	69824		Test Pension Fund		Lxxxx, Lientjie	All Female Members	61,994.58			41,567.54	103,562.12
C327	69825		Test Pension Fund		Lxxxx, Ranay	All Male Members	74,381.89			41,853.68	116,235.57
C592	69826		Test Pension Fund		Lxxxx, Ravine	All Male Members	22,318.71			12,540.69	34,859.40
C565	69822		Test Pension Fund		Lxxxx, Janine	All Female Members	31,194.21			16,185.01	47,379.22
C715	69856		Test Pension Fund		Lxxxx, Trevor	All Male Members	11,618.62			8,218.40	19,837.02
C545	69823		Test Pension Fund		Lxxxx, Michael E	All Male Members	23,142.52			10,980.93	34,123.45
C760	105772		Test Pension Fund		Lxxxx, Pulane	All Female Members	4,539.44			2,935.09	7,474.53
C679	69818		Test Pension Fund		Lxxxx, N N	All Male Members	10,075.53			6,568.46	16,643.99
C567	69819		Test Pension Fund		Mxxxx, Carol	All Female Members	32,422.55			18,094.47	50,517.02
C622	69815		Test Pension Fund		Mxxxx, C	All Female Members	13,987.03			7,909.04	21,896.07
C042	69820		Test Pension Fund		Mxxxx, J	All Female Members	97,728.90			295,171.38	392,900.28
C598	69816		Test Pension Fund		Mxxxx, E	All Male Members	15,223.89			8,366.42	23,590.31
C670	69796		Test Pension Fund		Mxxxx, S	All Female Members	18,656.72			13,935.26	32,591.98
C746	82730		Test Pension Fund		Mxxxx, Peter	All Male Members	4,368.96			2,618.21	6,987.17
C729	77261		Test Pension Fund		Mxxxx, T	All Male Members	6,150.50			3,906.27	10,056.77
C093	69813		Test Pension Fund		Mc Dxxxx, P	All Male Members	410,872.27			671,273.18	1,082,145.45
C532	69814		Test Pension Fund		Mxxxx, Jaco	All Male Members	41,740.33			24,497.22	66,237.55
C537	69807		Test Pension Fund		Mxxxx, Masungi	All Male Members	16,655.26			8,990.03	25,645.29
C769	115601		Test Pension Fund		Mxxxx, T	All Male Members	1,902.35			1,093.16	2,995.51
C173	69808		Test Pension Fund		Mxxxx, Andrew	All Male Members	68,683.60			76,823.06	145,506.66
C371	69803		Test Pension Fund		Mxxxx, Rochelle	All Female Members	51,681.67			28,840.47	80,522.14
C561	69804		Test Pension Fund		Mxxxx, Teresa	All Female Members	21,094.79			11,391.29	32,486.08
C710	69805		Test Pension Fund		Mxxxx, Edward	All Male Members	6,894.26			4,464.10	11,358.36
C538	69800		Test Pension Fund		Mxxxx, Mduduza J	All Male Members	19,999.01			28,438.85	48,437.86
C159	69801		Test Pension Fund		Mxxxx, Alison	All Female Members	261,796.76			761,713.80	1,023,510.56
C004	69802		Test Pension Fund		Mxxxx, G	Paid-up members	0.00			0.00	0.00
C459	69797		Test Pension Fund		Mxxxx, Julia	All Female Members	52,967.71			189,585.16	242,552.87
C739	77271		Test Pension Fund		Nxxxx, C	All Male Members	5,529.35			3,427.60	8,956.95
C781	135003		Test Pension Fund		Nxxxx, Shaun	All Male Members	463.60			204.70	668.30
C478	69794		Test Pension Fund		Nxxxx, Deon	All Male Members	48,440.09			38,380.11	86,820.20
C783	140868		Test Pension Fund		Oxxxx, Bertus	All Male Members	456.03			248.48	704.51
C625	69793		Test Pension Fund		Pxxxx, C	All Male Members	49,088.63			27,638.49	76,727.12
C528	69789		Test Pension Fund		Pxxxx, Rikus	All Male Members	63,170.04			32,437.36	95,607.40
C185	69848		Test Pension Fund		Pxxxx, Paulo	All Male Members	138,309.10			166,990.12	305,299.22
C286	69770		Test Pension Fund		Qxxxx, Luyolo	All Male Members	54,901.42			41,913.60	96,815.02
C470	69771		Test Pension Fund		Rxxxx, Shaneel	All Male Members	41,871.32			22,483.91	64,355.23
C633	69772		Test Pension Fund		Rxxxx, R	All Female Members	21,698.40			13,326.26	35,024.66
C378	69767		Test Pension Fund		Rxxxx, Thomas	All Male Members	27,306.16			23,539.30	50,845.46
C047	69768		Test Pension Fund		Rxxxx, A	All Male Members	235,707.86			606,092.25	841,800.11
C785	146303		Test Pension Fund		Rxxxx, Virenda	All Male Members	150.00			66.71	216.71
C723	69853		Test Pension Fund		Rxxxx, Justin	All Male Members	6,777.53			4,402.96	11,180.49
C440	69761		Test Pension Fund		Sxxxx, Dale	All Male Members	105,125.10			52,311.23	157,436.33
C751	86288		Test Pension Fund		Sxxxx, Marc	All Male Members	4,013.28			2,385.36	6,398.64
C566	69762		Test Pension Fund		Sxxxx, Kishore	All Male Members	33,648.24			19,203.75	52,851.99
C072	69763		Test Pension Fund		Sxxxx, F	All Male Members	75,549.39			207,910.50	283,459.89
C380	69758		Test Pension Fund		Sxxxx, Saul	All Male Members	26,496.83			19,581.82	46,078.65
C676	69759		Test Pension Fund		Sxxxx, Y P	All Male Members	13,403.10			9,073.18	22,476.28
C771	119882		Test Pension Fund		Sxxxx, Eben	All Male Members	1,617.27			926.57	2,543.84
C194	69756		Test Pension Fund		Sxxxx, C	All Male Members	207,589.82			203,951.77	411,541.59
C768	115602		Test Pension Fund		Sxxxx, C	All Male Members	1,703.60			943.50	2,647.10
C452	69757		Test Pension Fund		Sxxxx, Jake	All Male Members	62,663.94			57,830.09	120,494.03
C024	69752		Test Pension Fund		Sxxxx, C	All Male Members	152,232.35			299,091.63	451,323.98
C433	69753		Test Pension Fund		Sxxxx, Eleanor	All Female Members	25,718.63			12,749.74	38,468.37
C765	105776		Test Pension Fund		Txxxx, Grant	All Male Members	2,764.93			1,598.59	4,363.52
C387	69754		Test Pension Fund		Txxxx, N	All Male Members	27,415.15			13,666.20	41,081.35
C786	146304		Test Pension Fund		Uxxxx, Evan	All Male Members	191.25			97.73	288.98
C012	69749		Test Pension Fund		Vxxxx, J	All Male Members	166,082.51			344,062.92	510,145.43
C458	69746		Test Pension Fund		Vxxxx, Cornelius	All Male Members	39,456.60			22,197.97	61,654.57
C748	86285		Test Pension Fund		Vxxxx, Eurika	All Female Members	7,045.61			4,668.02	11,713.63
C620	69747		Test Pension Fund		Wxxxx, J	All Male Members	22,347.54			13,198.51	35,546.05
C581	69748		Test Pension Fund		Wxxxx, David	All Male Members	24,213.52			24,655.67	48,869.19
C784	140869		Test Pension Fund		Wxxxx, Linee	All Male Members	516.83			294.21	811.04
C539	69745		Test Pension Fund		Zxxxx, Colin S	All Male Members	30,524.64			17,312.13	47,836.77

			Total for		All Female Members 23- member/(s)		1,083,395.77			2,535,182.21	3,618,577.98
			Total for		All Male Members 76- member/(s)		3,595,380.02			5,950,036.47	9,545,416.49
		Total for		Paid-up members 2- member/(s)		0.00		0.00	0.00
		Grand Total Salary		101 member/(s)		4,678,775.79		8,485,218.68	13,163,994.47

This report now includes the Special Account in the Member Account.

Annexures

ANNEXURE 1

AUDIT PREPARATION YEAR END CHECKLIST
PROCESS	DESCRIPTION	COMPLETED
Trial Balance & Ledger	A Trial Balance and a Ledger must be generated for the audit period.  Parent Trial Balance – Summary  Parent Trial Balance – Ledgers	Yes No
Bank	The system bank account must balance to the bank statement at year end.  Parent Bank Recon	Yes No
Contributions	The ledger accounts in respect of contributions must balance to the reports listed below.  Accounts Contribution Report Client Contribution Statement	Yes No
Administration & Consultants Fees	The ledger accounts in respect of Administration and Consultants fees must balance to the report below. Accounts Admin Report	Yes No
Risk Premiums	The ledger accounts in respect of risk premiums must balance to the report below.  Accounts Risk Report	Yes No
Benefits	Ensure that the ledger accounts relating to benefits and PAYE balance to the reports listed below:  Parent Member Reconciliation (Member Details) Parent Benefits Due – Build Up (Export into Excel)  Parent Benefits Due (Export into Excel) Parent Benefit Tax – Build Up (Export into Excel)	Yes No
Membership	The opening balance of membership must balance to the closing membership from the prior year. All differences must be reconciled and all movements in membership must correspond to the various membership reports. The “Parent Member Credits” report must be generated at the first day of the year end and must correspond to the prior year value. The “Parent Member Credits” report must again be generated at the last day of the year-end. An Asset and Liability match must be performed. Parent Member Reconciliation Report (Parent Details)  New Entrant Listing Report Parent Member Credits Report	Yes No
Risk Recoveries	The ledger accounts in respect of risk recoveries must balance to the report below. Parent Death Benefits Schedule Report.	Yes No
Transfers Received	The ledger accounts in respect of transfers received must balance to the report below. Audit Parent Ledgers Report (Client Details)	Yes No
Investments	The audit certificates received from the investment managers must balance to the various investment accounts.	Yes No
Adhoc Expenses/Income	Each ledger account is supported by the report below, by substituting the ledger and description codes in amount 1 and amount 2 respectively.  Audit Parent Ledgers Report (Parent summary)	Yes No
Debtors/Creditors	The ledger accounts in respect of debtors and creditors must balance to the reports listed below.  Parent Debtors Report  Parent Creditors Report	Yes No
Everest System	Ensure that the audit period is locked, once all journals have been processed. The fund is ready for audit.	Yes No

ANNEXURE 2

AUDIT FILE YEAR END CHECKLIST
PROCESS	DESCRIPTION	COMPLETED
Annual Financial Statements	 Prior year signed annual financial statements.  Draft set of annual financial statement for the current year.	Yes No
Trial Balance	 Trial Balance and General Ledger.  Opening and closing member credit listing.	Yes No
Investments	 Audit certificate from investment managers.  Regulation 28 Certificates from investment managers.  Investment working papers. SARB reports and application numbers for the year being audited.  Should the year end not fall at the SARB quarter dates, ie.31/03, 30/06, 30/09, 31/12 a SARB reconciliation must be prepared from the last quarter to the Fund year end.	Yes No
Bank	 Bank reconciliation at the year end date.  Copy of the bank statement corresponding to the Bank reconciliation at the year end date.  Copy of the bank statement a month after the year end.	Yes No
Debtors	 Debtors working paper.  Supporting documents for the debtors listed, and proof of receipt after the year end.	Yes No
Creditors	 Creditors working paper.  Supporting documents for the creditors listed, and proof of payment after the year end.	Yes No
Income/Expense Accounts	Income / Expense accounts working papers. Attach copies of invoices/ supporting documents.	Yes No
Benefits	 Working papers for benefits. Recognition of transfer in respect of individual transfers and/or Section 14 applications, approvals and final transfer values.	Yes No
Rules	 Registered rules of the Fund.  Rule amendments, and approval from the FSB.	Yes No

Disclaimer and Copyright

DISCLAIMER

Please note, whilst care is taken to illustrate numerous scenarios, it is impossible to detail all instances and therefore this document should merely serve as a guide for the purposes of demonstrating system functionality and conducting employee training.

In accordance with the above paragraph, this training manual is published and distributed on the basis that EBSphere (Pty) Ltd is not responsible/accountable for any actions taken by users of information contained in this training manual nor for any error in or omission from this manual.

EBSphere (Pty) Ltd does not accept any responsibility whatsoever for a misrepresentation performed by any person in respect of claims, losses or damage or any other matter, either direct or consequential arising out of or in relation to the use and reliance, whether wholly or partially, upon any information contained or products referred to in this manual.

Further, the contents of this training manual are subject to change without any notice and further highlight the need for this training manual to serve only as a guide.

COPYRIGHT

This documentation and the software described in it is the exclusive property of EBSphere (Pty) Ltd. This manual or the software may not be copied in whole or part, without the express written consent of EBSphere (Pty) Ltd. Under the law, copying includes translating into another language or format.

EBSphere (Pty) Limited

P.O. Box 785803

Sandton

2146

Audit Preparation Guide_html_8cba33b1e8c9fa24.gif

Tags:

Applications

More applications

Need help?

If you need help with XWiki you can contact:

XWiki 14.10.21

Audit Preparation Guide

Introduction

Lock Financial Period

Reporting

Report Name: Parent Trial Balance - Ledgers

Contribution Accounts

Report Name: Accounts Contribution Report

Report Name: Client Contribution Statement

Administration Fee Accounts

Report Name: Accounts Admin Report

Risk Premiums Accounts

Report Name: Accounts Risk Report

Exit Accounts

Report Name: Membership Reconciliation Report

Report Name: Parent Benefits Due – Build Up

Company Indebtedness or IT 88?

Report Name: Parent Benefits Due

Membership Reconciliation

Report Name: Membership Reconciliation Report

Report Name: New Entrant Listing

PAYE

Report Name: Parent Benefit Tax - Build Up

RISK RECOVERY ACCOUNTS

Report Name: Parent Death Benefits Schedule

TRANSFERS IN ACCOUNTS

Report Name: Audit Parent Ledgers

ADDITIONAL LEDGER ACCOUNTS

Investments

Adhoc Expense/Income Accounts

Parent Creditors

Report Name: Parent Creditors

Parent Debtors

Report Name: Parent Debtors

Parent Member Credits

Report Name: Parent Member Credits

Annexures

ANNEXURE 1

ANNEXURE 2

Disclaimer and Copyright

Applications

Navigation

Need help?