Manual Data Entry (Job 3)
Closed - This job posting has been filled and work has been completed.
I have a PDF file containing copies of account statements. There are 6 separate accounts contained in the PDF file. I need to have the transactions from each account entered into a separate worksheet within the Excel file. After each account has been entered into a separate worksheet, then each worksheet must be converted into a QIF file using an Excel Macro that will be provided.
For each account, all transactions including purchases, payments, and finance charges along with the exact dates of each, MUST be reflected in the worksheets according to the template provided. All dates must be in this format: mm/dd/yyyy.
Note that the exact date of the finance charges may not be explicitly shown on a particular account statement in the PDF. In those cases, the “closing date” or “billing date” of the statement should be used as the date of the finance charge.
The job files are located in the following dropbox location:
A very fast and accurate turnaround is required for this project. If you are not able to fully complete the project in 48-hours, then please do not apply.
There are 6 worksheets in the XLSX file, the budget for the entire project is as reflected.
Your final deliverables consists of TWO files for each account contained in the PDF file:
File #1) A separate .XLSX file for each account in the PDF file. The .XLSX file must contain 6 worksheets.
File #2) A separate .QIF file for each worksheet in the .XLSX file
To create file #1 of your deliverable, each worksheet within the Excel file must be of the same format as contained in “example_2008_0641_partial1.xlsx”. Notice that each payment / credit is shown in a single column as negative numbers. Each purchase / charge, is shown in the same column as a positive number.
To create file #2 of your deliverable, you must first install the macro, (see instructions on installing the macro further below). Launch the macro and specify an output file for the QIF file. Next define the “Input Data:”.
For instance in the example file, the Input Data is $A$2:$C$20. Next, select “Date”, “Payee”, and “Amount”, in that order. Be sure the content of “Column order in Input Data” reflects “<Date><Payee><Amount>”. Next, make sure “MM/DD/YYYY” is selected for the “Date Format:”. Finally, click on the Convert button.
To install the Excel Macro:
1) Double-click on xl2qif.xla
2) Click on 'Enable Macros'
3) Select English
The macro should appear in the 'Add-Ins' tab of Excel. Sample data has been provided so you can see the functionality of the macro.
Further description of the macro is described in:
You must check that you have entered the correct information in the spreadsheet by comparing the balance at the end of the closing date from each statement with the "opening" or "beginning" balance of each statement on the following statement.
To be considered for this job you must provide a sample of your work by completing and submitting the attached Sample. Complete your work according to the instructions provided above. Only samples that have been correctly submitted will be considered. Correctly completed samples do not guarantee employment because only one person can be hired for this particular opportunity.
Skills: pdf, finance, english