Validate Tax Number Dec2023
$10-30 CAD
Plačilo ob prevzemu
This project has 2 parts:
1. VALIDATION OF GST/HST REGISTRY NUMBER
2. VALIDATION OF A QST REGISTRATION NUMBER
VALIDATION OF GST/HST REGISTRY NUMBER:
I need a software which will take the Excel file as input with a list of code numbers, names and dates. The software will output the same file with an additional 4th column which would be populated based on the website search result.
Site: [login to view URL]
Click on “I AGREE” - This will forward to a new GST/HST REGISTRY SEARCH page
Here, you will take the input file and search one row at a time and populate the 4th column based on the search result. The options I have seen are:
• RESULT: GST/HST number registered on this transaction date.
• RESULT: Insufficient information entered.
Note: In control panel, under Region, my Short date format is: M/dd/yy - you must set the same.
Please refer to the sample files and results to make sure you understand before starting
VALIDATION OF A QST REGISTRATION NUMBER:
It’s similar to GST/HST Registry but different list and website. This second software will take an Excel file as Input with a list of code numbers and names. The software will output the same file with 5 additional columns which would be populated based on the website search result.
Site: [login to view URL]
(in the example link, the 1219432212TQ0001 number at the end is what you will get from the Excel file)
Here, you will input file and search one row at a time and populate result columns.
Column 3 (Heading FOUND): FOUND / NOT FOUND (whether it’s found or not)
Column 4 (Heading STATUS): VALID, INACTIVE OR NON-EXISTANT (based on the search result)
Column 5 (EFFECTIVE DATE) : Effective date of status (based on the search result)
Column 6 (Business Name): Business name (based on the search result) - This is labelled "Business's name" on the website
Column 7 (Firm Name): Firm name (This is labelled "Business name" on the website)
For example, number "1219432212" has "8241899 CANADA INC" as business name and "PRECIVAL" as Firm Name.
Please refer to the sample files and results to make sure you understand before starting.
GENERAL REQUIREMENTS AND DELIVERY:
• I need a standalone software that runs on it's own
• I need both the code and the application with documentation.
• While the program is running, I want the status displayed. For example, which row is currently being processed out of how many rows.
• You can create a separate program for QST or incorporate both in the same program. Whatever is easier for you.
• Any configuration that may need changed in future, I should be able to do that in the program.
• I want this program to work with both .xls and .xlsx
ID projekta: #37480785
Več o projektu
6 freelancerjev ponuja v povprečju za $45 na tem delu
Greetings Dear Client, Welcome to my profile, Home to Professional and Quality services with 100% customer satisfaction guarantee. I'm a Certified & Experienced Expert in the respective project requirements. Dear Clie Več
Good morning Validate Tax Number Dec2023 Thank you for considering us for your custom web and app development needs. We understand that you are looking for a solution that is tailored to your specific requirements and Več
Greetings, my name is Gamaliel Méndez, and I am enthusiastic about the opportunity to work on your project. I would love for you to get in touch with me so that we can share more details. This way, I can provide you wi Več