Analyze Excel Files & Create an Excel Spreedsheet for Accounting using a Macro or a Plugin

Completed Posted 6 years ago Paid on delivery
Completed Paid on delivery

I am a small business owner trying to calculate my sales figures and tax amounts for taxation reporting purposes from a set of Excel files that I have used as Invoices for my clients.

This can be a rather straightforward Macro or a third party plugin that can be used to Analyze a set of Excel 2010 /2016 documents with a single worksheet in each. I have a standard Tax Invoice template in Excel which has details of my client , date of invoice , invoice number and the details of services and equipment supplied , pre tax amounts, GST amount and Total Invoice Amount. I have close to 150 separate files (invoices) generated using the same template baring a few changes in the logo .

The data that needs to be extracted is more or less in the same fields from each file. All I want to do is to have a brand new interactive Excel sheet to provide or feed in the file names ( location on a local hard drive ) or a directory containing all the Excel files. Your macro should be able to open each file, extract the specific data and spit it into a new combined document with the respective column headings. I would like to analyse the data in this final spreadsheet on the basis of Date/Month/Year/ Client.

I have attached a sample spreadsheet invoice here. The data that needs to be extracted is in RED.

Additionally I will pay a bonus if I could :-

1) Edit the main template to add a second worksheet called Costs going forward and put in the costs for any Hardware or Software invoiced and get that reported as well to arrive at a rough profit or loss statement

2) Extract additional Data from the same worksheet(s)which is not in the same cell under the sub headings - Hardware Supplied , Services Rendered , Software & Subscriptions , Travel etc. Ideally I should be able to specify the string of the sub heading to be able to extract the data.

I need this done in the next 72 hours. If you require me to install a plugin as part of your solution, please provide clear and concise instructions. You are more than welcome to use any freely available Excel plugins. If there is a license fee to be paid please include that in your fee.

Thanks and all the best. Please feel free to contact me for any further explanations.

Cheers

MD

Data Analytics Data Processing Excel Excel Macros

Project ID: #15550911

About the project

12 proposals Remote project Active 6 years ago

Awarded to:

TonmoyRoy111

Dear client, This is a pretty straight forward job which can be easily done using macro. A button will do all the stuffs mentioned. And yes i can write the code for the button. So please contact me. Relevant Skills a More

$50 AUD in 2 days
(356 Reviews)
6.9

12 freelancers are bidding on average $76 for this job

SBITServices

Hello , I have read your project description and understood your requirement. I have 5 years experience in Excel Macro can complete the task within time with 100% accuracy. Relevant Skills and Experience Skills : Exce More

$50 AUD in 1 day
(460 Reviews)
7.5
rohitpithisaria

Hello I am a certified accountant and an excel expert. Let's divide the project in 2 parts. Part 1 - this I will incorporate everything in the excel file as required - manually. Rgds Rohit Relevant Skills and Experi More

$75 AUD in 3 days
(117 Reviews)
6.6
abdolah2014

HI I am an excel-vba Expert and I can help you with your project using vba macro start the chat to discuss more ................................................................. Relevant Skills and Experience vba exce More

$166 AUD in 5 days
(37 Reviews)
5.3
whitehorsetechn

Greeting, I have understood your Analyze Excel Files & Create an Excel Spreed sheet for Accounting using a Macro or a Plugin task and can do it with your 100% satisfaction. Relevant Skills and Experience I have more More

$100 AUD in 2 days
(13 Reviews)
5.2
chintuag

Dear Hiring Manager, I have read the project description and understand that you would like to extract data from several excel files onto a single sheet for accounting purposes. I have experience in similar projects More

$77 AUD in 3 days
(9 Reviews)
4.0
jcrbahia

I can extract data using text Subtotal and Total , with Macro VBA , reading all documents in target, this data write into sheet , and list using filter , date, client, or you need. Please contact me. Habilidades y ex More

$111 AUD in 2 days
(4 Reviews)
2.0
parthapaul01

. Hello I am highly interested to do your project . I am able to refresh this with your full satisfaction . I am confident about the work . I believe that , I can do this work properly Relevant Skills and Experience D More

$63 AUD in 10 days
(0 Reviews)
0.0
lakshmidiluni

A proposal has not yet been provided

$63 AUD in 10 days
(0 Reviews)
0.0
mukeshrt786

Dear Next Employer I'm ready to show you sample of similar product I've completed Thanks' You can chat with me and let's get started Relevant Skills and Experience I am a Chartered Accountant and i do lots of sim More

$40 AUD in 2 days
(0 Reviews)
0.0
benjaminshi

A proposal has not yet been provided

$55 AUD in 2 days
(0 Reviews)
0.0