PLI Pay Recovery CSV Creator Tool

 

 Version: 2.1.0 Release Date: 06.05.2023  

 Last Update Released: 02.08.2023




 

This tool will help you to create the CSV file for uploading PLI/RPLI Pay Recovery data to McCamish. GST figures will get rounded to meet the new requirement.

Download Link

First update the Excel file named source with the Pay Recovery data received from the Accounts branch.


Please note that this tool currently supports monthly premium only and if there are more than one month’s premium, you will have to enter them in separate lines.

If there are more than one month's premium, you can now enter them in one row (Enter one month’s full premium. It will be duplicated as per the entered period).

Please refer to the tables given below while entering the data in the columns Pmt_Year and Pmt_Frequency

Pmt_Frequency

MONTHLY PREMIUM

M

QUATERLY PREMIUM

Q

HALF YEARLY PREMIUM

H

YEARLY PREMIUM

A






Pmt_Year

FIRST YEAR PREMIUM

F

SUBSEQUENT PREMIUM

S

 

After entering data in the source Excel file, save the file and close it.

Enter things like FY GST, RY GST, State Code, Office Code etc.

Then browse and select the prepared Excel file.

Click on “Process” to create the CSV file.

    Post Tools Android App
 

Comments

Post a Comment

Popular posts from this blog

Bulk GL Posting Tool

Image
Version: 3.5 .4           Last Update Released: 15-05-2024     This tool can be used for bulk GL posting in SAP using ZBF07. It can convert McCamish report in Excel format to a text file that can be used to bulk GL posting. Download Link Version History: Ver - 3.5.3.0 dated 09.05.2024 GLs for GST on DF have been changed. Option has been added to account for GST on DF only for the circles where GL integration is complete. Some minor bug fixes have been implemented. Ver - 3.5.0.0 dated 05.04.2024 Properly segregate the revival premium into FY premium and RY premium.  Properly segregate GST from the initial premium (McCamish report ignores GST on initial premium).  Option added for grouping records into a single document based on date, office, cash account, and document type (Will post documents similar to POSB GL integration figures).  Option for exporting records to an Excel file added (available in the bottom right corner of the table).  Column for profit center added in the summary re
Read more

PoS Bulk File Generator

Image
Version:  6.15.0.0  Release Date: 07.11 .2023     This tool can be used to process bulk articles and create Excel file to be uploaded in CSI POS. It is designed in such a way to make faster data entry with ease. With this tool COD, BNPL, Prepaid Bulk with PS or SS or FM bulk articles can be processed in batch by batch basis. Download Link Join WhatsApp group for support https://chat.whatsapp.com/HoJFA3juCYE1CpwMZxGuI7 Requirements   M.S Office Features   Generate invoice for bulk booking.   Fixed issue with booking franked Speed Post articles.   Separate file will be generated for Speed Post articles weighs more than 500g.   Checksum Validation Bug fixed.   Shortcuts added for faster field navigation.   Performance improved. Minor bugs fixed.   PIN Code directory updated.   Auto-populate Barcode Number without scanning (optional)   Generate Address Label with Barcode Number.   Process Excel file prepared by the Customer.   Process Excel file prepared by the Customer by Ref No/Barcode N
Read more

PLI Checker Lite

Image
Version:  3.24.3 Release Date:  03-02 -2024     Tool for comparing PLI/RPLI figures accounted in SAP with premium collected in Mccamish. This tool can generate detailed and consolidated comparison reports along with error extracts if any differences detected. So you can easily find out delinquent offices and ask them to make necessary corrections quickly.  Please run the installer extracted from the zip file downloaded, it will upgrade your current Application without losing your data or install fresh for new users. You do not have to uninstall the old version.  Download Link Register your email address in the link given below to receive update notifications.  https://docs.google.com/forms/d/1DPM0B6glHPT9ZlV5mFB42KgpX7qiK6sJN9hkH6p2zDo Join WhatsApp group for support https://chat.whatsapp.com/HoJFA3juCYE1CpwMZxGuI7 Version History Version 3.24.3 Optimized comparison DB queries and made it slightly faster than before. Version 3.24.2 Optimized comparison module and made it slightly faste
Read more