Reformat excel files in a format such that 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 10 columns: transaction date, post date, reference number, transaction description, exchange, currency, Amount, Account, Location
There are 5 workbooks. One for each month. Each workbook has 4-7 sheets. Each sheet has 2-50 transactions.
6)Add a new column. Strip off the location in the description(eg. VA, CA, WA ) and paste into the column:
7)Move the exchange rate to the corresponding column for the transaction of the row above.
There are 5 workbooks.
Here are examples of the initial- before and final - after files from one sheet of a workbook . In this an average example.
Hi, I have good data entry and excel skills with years of experience as well as I have completed a great number of projects for Excel and Data Entry. Your work will be delivered on time and will be responsible till you Plus
7 freelance font une offre moyenne de $98 pour ce travail
Hello. My name is Marko and I am an Engineering Graduate with an MBA degree. I am a full time freelancer and I will work hard on this till completion. An Expert Excel/VBA programmer on freelancer.com and I do not Plus
hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I understand the value of deadline and do not compromise on quality. I feel fit myse Plus
Hi, I am ready to start right away. I'm an expert in Data Entry. I have reviewed your job description as well and very confident to handle this project perfectly. I understood your all requirements. I have done many Plus
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
I'm very happy to bid on your project. I read your description carefully and am very interesting in your project. I can start right now and I can confirm high quality. If you hire me,I will do my best for your job and Plus
Hello, Sir. I read your opinion seriously. I have experience of 7 years and done similar projects before. As a man of trust, I can develop your website with full perfection. Let me go on, you can get the best project t Plus