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 .5           Last Update Released: 24-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.5.0 dated 24.05.2024 Bug in calculation of GST on DF after GL integration is fixed. 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...
Read more

PLI Checker Lite

Image
Version:  3.24.7 Release Date:  29-06 -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.7 Added new column in comparison report for displaying advance adjustments. Updated GL numbers after GL integr...
Read more

PO Register Tool

Image
   Version: 3.14. 0           Last Update Released Date: 20-12-2024      The PO Register Tool is a versatile platform designed to streamline your record-keeping process. With its user-friendly interface, you can effortlessly generate and tailor a variety of registers to suit your specific requirements. One of its standout features is the automatic backup function, ensuring the security of your valuable data at all times.       Flexibility is key with this tool, allowing you to export your custom register templates for easy sharing and import templates created by others, fostering collaboration and efficiency.  To upgrade, simply run the installer without uninstalling the old version. This will seamlessly update your application while preserving all your data.   Download PO Register Tool (Standalone) Download PO Register Tool Pro (Server-Client Model) Watch demo videos on YouTube Version History Version ...
Read more