Data entry - Data extraction and change year for bank transactions
Budget: $30 – $250 USD
I am in need of a freelancer who can assist me to complete the finalization of a .CSV file for submission to various tax software platforms. The bank wasn't able to provide the digital records for the months of January through April, so I had to manually extract the data from bank statements and compile it in an Excel format.
The project details are as follows:
1. I need the freelancer to change the year of the transactions.
The date information lacks the year component, and I require all dates to be standardized to the year 2022. Although I know the process, I'm currently unable to recall the exact method.
2 The transactions that need to be updated are from Jan 2022 – April 2022 There are about 150 Entries total that will need to be handled.
3. Change the withdrawal values to a negative.
The bank statements are typically organized into two columns for deposits and withdrawals, but the .CSV file I'm working with represents all transactions in a single column, combining positive and negative values. My task is to apply the necessary formulae to convert all withdrawal amounts to negative values and keep the positive values the same. I do have a quick method for the negative conversion If help is needed.
4. The data from separate Excel sheets that I've copied needs to be meticulously organized to match the precise structure of the original .CSV file. This includes the notation of a check to be placed as the other examples.
**Deadline:** I'm seeking assistance with this task as soon as possible, given the urgency of the project.
If you have the requisite skills and experience and can begin work on this project immediately, I invite you to submit your proposal for our consideration
The project details are as follows:
1. I need the freelancer to change the year of the transactions.
The date information lacks the year component, and I require all dates to be standardized to the year 2022. Although I know the process, I'm currently unable to recall the exact method.
2 The transactions that need to be updated are from Jan 2022 – April 2022 There are about 150 Entries total that will need to be handled.
3. Change the withdrawal values to a negative.
The bank statements are typically organized into two columns for deposits and withdrawals, but the .CSV file I'm working with represents all transactions in a single column, combining positive and negative values. My task is to apply the necessary formulae to convert all withdrawal amounts to negative values and keep the positive values the same. I do have a quick method for the negative conversion If help is needed.
4. The data from separate Excel sheets that I've copied needs to be meticulously organized to match the precise structure of the original .CSV file. This includes the notation of a check to be placed as the other examples.
**Deadline:** I'm seeking assistance with this task as soon as possible, given the urgency of the project.
If you have the requisite skills and experience and can begin work on this project immediately, I invite you to submit your proposal for our consideration