Annuity payments
Create the following accounting transactions for each annuitant:
Gross payee amount
ANNUITY PAYMENT |
PENSIONPAYBL |
MEMBER |
DR |
PENSIONPAID |
|
|
|
CR |
PENSIONPAYBL |
|
|
|
DR |
MEMDEPOSIT |
|
|
|
CR |
TRF TO/F FND |
Tax amount
PAYE
ANNUITY PAYMENT |
TAXPAYABLE |
MEMBER |
DR |
PENSIONPAYBL |
|
|
|
CR |
MEM DEPOSIT |
|
|
SCHEME |
DR |
PENSIONPAYBL |
|
|
|
CR |
PENTAXPAYBL |
PAYE arrears
ANNUITY PAYMENT |
ARRTAXPAYABL |
MEMBER |
DR |
PENSIONPAYBL |
|
|
|
CR |
MEM DEPOSIT |
|
|
SCHEME |
DR |
PENSIONPAYBL |
|
|
|
CR |
PENTAXPAYBL |
SITE
ANNUITY PAYMENT |
BASETAXPAYBL |
MEMBER |
DR |
PENSIONPAYBL |
|
|
|
CR |
MEM DEPOSIT |
|
|
SCHEME |
DR |
PENSIONPAYBL |
|
|
|
CR |
PENTAXPAYBL |
SITE arrears
ANNUITY PAYMENT |
ARBASETAXPBL |
MEMBER |
DR |
PENSIONPAYBL |
|
|
|
CR |
MEM DEPOSIT |
|
|
SCHEME |
DR |
PENSIONPAYBL |
|
|
|
CR |
PENTAXPAYBL |
Voluntary tax
ANNUITY PAYMENT |
ADDTAXPAYBL |
MEMBER |
DR |
PENSIONPAYBL |
|
|
|
CR |
MEM DEPOSIT |
|
|
SCHEME |
DR |
PENSIONPAYBL |
|
|
|
CR |
PENTAXPAYBL |
Third party payment
ANNUITY PAYMENT |
PENSIONDED * |
MEMBER |
DR |
PENSIONPAYBL |
|
|
|
CR |
MEM DEPOSIT |
Recovery of deductions overpaid
ANNUITY PAYMENT |
PENSIONDEDRV * |
MEMBER |
DR |
MEM DEPOSIT |
|
|
|
CR |
PENSIONPAYBL |
Recovery of annuities overpaid
Create the following reversal accounting activities for annuities overpaid:
Negative Annuity:
ANNUITY PAYMENT |
PENPAYBLREV |
MEMBER |
DR |
PENSIONPAYBL |
|
|
|
CR |
PENSIONPAID |
Negative Deduction:
ANNUITY PAYMENT |
PENSIONDEDRV |
MEMBER |
DR |
MEM DEPOSIT |
|
|
|
CR |
PENSIONPAYBL |
Negative Tax
ANNUITY PAYMENT |
PENSIONDEDRV |
MEMBER |
DR |
MEM DEPOSIT |
|
|
|
CR |
PENSIONPAYBL |
|
|
|
DR |
PAYEPAYABLE |
|
|
|
CR |
PENSIONPAYBL |
* For each annuity run, sum all of the PENSIONDED accounting activities for all of the payments per payment schedule, i.e. per scheme, for which the payee name is the same.
Create the following accounting activity for the total:
ANNUITY PAYMENT |
FNDPENDED |
FUND |
DR |
PENCONTROL |
|
|
|
CR |
BANK |
Net payee amount
EFT’s / Cheques
ANNUITY PAYMENT |
MEMPENPAID * |
MEMBER |
DR |
PENSIONPAYBL |
|
|
|
CR |
MEM DEPOSIT |
|
|
SCHEME |
DR |
PENSIONPAYBL |
|
|
|
CR |
BANK |
*These accounting activities must be set-up with the money movement indicator set, which will result in each transaction being written automatically to the EFT file or the cheque file, depending on the payment method on the payee details.
Foreign drafts
If the payment method on the membership payment detail is FOREIGN DRAFT, create the following accounting activity in place of the MEMPENPAID accounting activity:
ANNUITY PAYMENT |
MEMPENPAIDFD |
MEMBER |
DR |
PENSIONPAYBL |
|
|
|
CR |
MEM DEPOSIT |
|
|
FUND |
DR |
PENCONTROL |
|
|
|
CR |
BANK |
When the annuity payment run is processed, if the payment method is FOREIGN DRAFT and the base currency on the membership payment detail record is not equal to the currency for the scheme to which the membership is linked, the following accounting activities will be created for the scheme currency amount:
- MEMPENPAYBL
- MEMPENPAIDFD
For these type of payments, the fund accounting rule linked to the MEMPENPAIDFD Accounting Activity is the following:
- DR PENSIONPAYBL
- CR PENCONTROL
The existing rule is DR PENSIONPAYBL / CR BANK but the payments will be made out of global payments bank account and will only be paid out of the scheme's bank account when the amount is paid to global payments.
When the confirmation list is received from global payments, the scheme currency amount will be reconciled to the scheme currency (GBP) on the foreign draft report. If there are any differences, a manual accounting activity journal must be processed for the difference with one of the following accounting activities, depending on whether the amount on the global payments list is less than or greater than the scheme currency amount on the foreign draft report:
Global payment list greater than foreign draft schedule:
MANUAL INITIATE |
CURRCONVINCR |
FUND |
DR |
PENSIONPAID |
|
|
|
CR |
PENSIONPAYBL |
Global payment list less than foreign draft schedule:
MANUAL INITIATE |
CURRCONVDECR |
FUND |
DR |
PENSIONPAYBL |
|
|
|
CR |
PENSIONPAID |
When the schedules have been balanced, the total amount paid out of the global payments bank account must be paid into the global payments bank account using the following accounting activity per bank and with the deal number and exchange rate captured in the deal number and exchange rates fields respectively:
MANUAL INITIATE |
FCURRPENPMTS |
FUND |
DR |
PENCONTROL |
|
|
|
CR |
BANK |
Bureau Focus payments
For each annuity payment for which the payment method is BANK TRANSFER, create the following accounting activity:
ANNUITY PAYMENT |
MEMPENBNKTRF |
MEMBER |
DR |
PENSIONPAYBL |
|
|
|
CR |
MEM DEPOSIT |
For each annuity run sum all of the MEMPENBNKTRF accounting activities for all of the payments per payment schedule, i.e. per scheme.
Create the following accounting activity for the total:
ANNUITY PAYMENT |
FNDPENPAID |
FUND |
DR |
PENCONTROL |
|
|
|
CR |
BANK |
The money movement indicator must be set to N.
Total of all annuitants
Create the following accounting transactions for the total of all annuitants:
Gross payee amount
ANNUITY PAYMENT |
FNDPENPAYBL |
SCHEME |
DR |
PENSIONPAID |
|
|
|
CR |
PENSIONPAYBL |
Tax amount
ANNUITY PAYMENT |
FNDPAYEPAYBL |
SCHEME |
DR |
PENSIONPAYBL |
|
|
|
CR |
PAYEPAYABLE |
Gross suspended annuity amount
ANNUITY PAYMENT |
SUSPPENPAYBL |
MEMBER |
DR |
PENSIONPAID |
|
|
|
CR |
SUSPPENPAYBL |
Total of suspended annuities
ANNUITY PAYMENT |
FSUSPPENPBL |
SCHEME |
DR |
PENSIONPAID |
|
|
|
CR |
SUSPPENPAYBL |
Gross amount of the arrears
ANNUITY PAYMENT |
SUSPPENPAID |
MEMBER |
DR |
SUSPPENPAYBL |
|
|
|
CR |
PENSIONPAYBL |
Total of arrears
ANNUITY PAYMENT |
FSUSPPENPAID |
SCHEME |
DR |
SUSPPENPAYBL |
|
|
|
CR |
PENSIONPAYBL |
Where a cheque payment is made to a pensioner who was not paid in the monthly annuity process (e.g. because he had not returned the certificate of existence in time), the following manually initiated accounting activity must be used:
MANUAL INITIATE |
PENADVANCE |
MEMBER |
DR |
PENSIONPAID |
|
|
|
CR |
MEM DEPOSIT |
|
|
SCHEME |
DR |
PENSIONPAID |
|
|
|
CR |
BANK |
The amount advanced must be captured on the annuitant's record as an ad-hoc deduction.
When the following month's annuity run is processed, the following accounting activities must be produced for the ad-hoc deduction:
ANNUITY PAYMENT |
PENREFUNDDED |
MEMBER |
DR |
PENSIONPAYBL |
|
|
|
CR |
PENSIONPAID |
|
FNDPENREFDED |
SCHEME |
DR |
PENSIONPAYBL |
|
|
|
CR |
PENSIONPAID |
ANNUITY PAYMENT |
MEMPENPAIDRV |
MEMBER |
DR |
MEM DEPOSIT |
|
|
|
CR |
PENSIONPAYBL |
|
|
SCHEME |
DR |
BANK |
|
|
|
CR |
PENSIONPAYBL |
|
PENSIONDEDRV |
MEMBER |
DR |
MEM DEPOSIT |
|
|
|
CR |
PENSIONPAYBL |
|
|
SCHEME |
DR |
BANK |
|
|
|
CR |
PENSIONPAYBL |
For more information on the accounting activities generated by the payment run, refer to
Supplements
Accounting Activities Generated by the Payment Run