STEPS IN GENERATING TASAKA PREMIUM LISTING 

 

  1. Generate ledger report for each Tasaka product.
  2. Sort or organize the data by the client’s name.
  3. Check the amounts or premium payment made.
  4. Filter transactions for manual and withdrawal (drop-out clients) in the transaction type. Remove clients where the debit and credit amounts are equal.
  5. Filter transactions for Initiate transfer and Approved transfer (clients moved to another cluster) in the transaction type. Delete clients where the debit and credit amounts match
  6. Filter transactions for deposit, transfer In and Out. Delete these clients.
  1. Client transferred to other Tasaka Product (sample deposit as Tasaka Special but should be Tasaka Top-up).
  • Click conditional formatting for client name and check transaction type then delete.
  1. Transaction Reverse due to erroneous client.
  • Click conditional formatting for client name and transaction ID then delete.
  1. Ensure the remaining list only displays amounts on the credit side.
  2. Sum up the total amount on the credit side and compare it to the DTB amount.
  3. If correct, forward the list to the MIS Coordinator (Ms. Cristina). If not, perform a double-checking and reconciliation.
  4. Record a journal entry to transfer the Tasaka premium to MIU, ensuring the running balance is consistently zero.

 

Note: To delete those with color, filter by color then click CTRL + (-).

 

Please see attached sample.