Reformat Visa statements that are in excel format so they can be uploaded to Quickbooks.
For each sheet (card ) of each workbook ( monthly statement)
1)Unmerge all cells in sheet.
2)Expand unmerged columns
3)Convert data to text so reference number is not lost as an exponential.
4)Expand data using text to column where necessary.
5)Move expanded data to like-columns to form only 7 columns: transaction date, post date, reference number, transaction description, exchange conversion, Amount, Account, Location
There are 10 workbooks. One for each month. Each workbook has 3-4 sheets. Each sheet has 2-120 transactions.
6)Add a new column. Strip off the location in the description(eg. VA, CA, WA ) and paste into the column:
There are 10 workbooks.
Here are examples of the initial- before and final - after. In this an average example. some have more merged cells some have less.
10 freelancere byder i gennemsnit $118 på dette job
it`s an easy project and can be finished in less than the determined time. I`m interested in your project pleas contact me to discuss the other details thank you
Hello there, I am very much interested in this job post. Please message me for more information. I am best fitted for this job since I am experienced and this is my line of job. Thank you!