Credit Card Statement to Spreadsheet Conversion
Budget: $10 – $30 USD
I have several PDF credit card statement that I need converted into a neatly-organized spreadsheet. Here is what I am seeking:
Extraction of specific transaction information:
- Transaction Date
- Post Date
- Description
- Amount (PHP)
Optionally:
- If it is a foreign currency
- If it is an installment
- How many months for the installment
- How many months left
- Remaining amount
To ensure correctness, please include the following formulas:
1. Total amount - I will not share the actual total amount with you. It will need to match the spreadsheet's total amount. This will ensure that the encoded amounts are correct.
2. List of unique descriptions - I want to see a list of unique descriptions (+ count if possible) to help us identify typos during conversion. This will ensure that the encoded descriptions are at least consistent with each other.
3. Date range - I want to see the dates of the earliest and latest transactions for transaction and post. Subtly include the current date at the start of your bid if you reached this part. This will ensure that the encoded dates are correct.
4. Longest & shortest duration between each transaction and post dates. This will ensure that the encoded dates are not too far apart, and any actual outliers can be identified.
I might be able to help you out with the formulas. Please leave a comment if these formulas above are feasible. I have 94 of these PDFs that I may want to convert, so the project might not be a one-off thing.
Unfortunately, I also have to mention that I'm price sensitive. The quality & completeness may be put into consideration but it will generally boil down to the lowest reputable bidder. Please include how much you would charge me for each bill or page.
Extraction of specific transaction information:
- Transaction Date
- Post Date
- Description
- Amount (PHP)
Optionally:
- If it is a foreign currency
- If it is an installment
- How many months for the installment
- How many months left
- Remaining amount
To ensure correctness, please include the following formulas:
1. Total amount - I will not share the actual total amount with you. It will need to match the spreadsheet's total amount. This will ensure that the encoded amounts are correct.
2. List of unique descriptions - I want to see a list of unique descriptions (+ count if possible) to help us identify typos during conversion. This will ensure that the encoded descriptions are at least consistent with each other.
3. Date range - I want to see the dates of the earliest and latest transactions for transaction and post. Subtly include the current date at the start of your bid if you reached this part. This will ensure that the encoded dates are correct.
4. Longest & shortest duration between each transaction and post dates. This will ensure that the encoded dates are not too far apart, and any actual outliers can be identified.
I might be able to help you out with the formulas. Please leave a comment if these formulas above are feasible. I have 94 of these PDFs that I may want to convert, so the project might not be a one-off thing.
Unfortunately, I also have to mention that I'm price sensitive. The quality & completeness may be put into consideration but it will generally boil down to the lowest reputable bidder. Please include how much you would charge me for each bill or page.