CSV collate and populate PDF forms

Closed Posted 2 years ago Paid on delivery
Closed Paid on delivery

I have a software system that does not include all available fields needed in a report.

I have a master file of tenants with addresses of units etc and a delinquency file that includes names and amounts due. I need a solution that cross-references delinquency file and import address information. The resulting records will be used to populate PDF forms for printing and mailing. Both record files are in CSV format. Solution can be batch, MS access, powershell etc. as long as input files can be updated each month and with each run of the programmed solution.

Master File - Fields

Property Unit Tenant Status Tenant Type Move-in Lease To Rent Deposit Tenant Tags Tenant Address Tenant Street Address 1 Tenant Street Address 2 Tenant City Tenant State Tenant Zip Lease From First Name Last Name

Delinquency File Fields - Unit, Name, Tenant Status, Tags, Move In, Move Out, Deposit Amount, Receivable, Delinquent Rent, Delinquent Subsidy Amount, 0-30, 30+, Last Payment, Payment Amount, Late Count

Records collated on Name with all information from both files combined into one report result.

Exportable or usable in a PDF form.

PDF form solution to import records and print preformatted PDF documents for snail mailing

Microsoft Access Excel Visual Basic Visual Basic for Apps Data Mining

Project ID: #32554368

About the project

24 proposals Remote project Active 2 years ago

24 freelancers are bidding on average $151 for this job

Logo199

Hi Rony here I can do this task as i am excel VAB and Macros expert here I will do my level best thank you

$200 USD in 3 days
(66 Reviews)
5.6
goodwork20k

Hello, i am a powershell, csv and pdf expert, i can help you to make powershell script based on your requirement Please ping me for further discussion thanks

$250 USD in 7 days
(5 Reviews)
5.5
youssefEngineer

hello sir, i'm software developper, i created many automated pdf reports before using csv, excel data, i can fully automate this task and build for you all the templates and fill all required fields, i can show you a More

$250 USD in 3 days
(11 Reviews)
5.0
AAGGMM

Hello sir I am Ahmed, a data analytic with very good skills in Excel, also in data cleansing, organization, and integrity. So, I can achieve this task perfectly. I can connect the two files in a master file (excel) t More

$50 USD in 1 day
(21 Reviews)
3.8
vw1514518vw

hello, I am Rageh, a software development pro and I am ready to develop the program to link records from tenant directory file with their records in delinquency file, (best choice will be MS Access), reports will be g More

$100 USD in 2 days
(2 Reviews)
1.8
KalamFL21

Hi there, Good day! Thanks in advance for considering my proposal. I am a full-time freelancer and able to provide fast & efficient data entry, web research, eCommerce, CRM, and real estate data entry, and all other ad More

$250 USD in 5 days
(3 Reviews)
1.2
usmanbashir12100

Hello, I’d really like to work with you on this one if possible! I’m Usman . I have lots of experience in data typing, data entry, web research, database administration, ad posting, data research, data mining, data ext More

$30 USD in 7 days
(3 Reviews)
0.7
Resourceful01

Hello, My name is salami. I am writing to you for the position of data entry expert that you are looking for on an urgent basis. Data entry job is my passion and I have 6+ years of experiences in this field that makes More

$140 USD in 7 days
(0 Reviews)
0.0
Scriptfabrik

Hello. I'm a web developer with 7 + years experience. I have PHP, MySQL and JavaScript skills. I hope to discuss more detail via chat. If you give me a chance, I'll give you good result. I hope to work with you.

$140 USD in 7 days
(0 Reviews)
0.0
hossamemam4060

Hi , I will analyze all the data and provide you with clear, concise notes. During my twenty five years of experience, first as senior business analyst then as IT G. Manager at Holding Co. (HCMLT), I participated i More

$140 USD in 7 days
(0 Reviews)
0.0