Completed

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

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

Skills: Data Analytics, Data Processing, Excel, Excel Macros

See more: create access database using excel files, using macro export excel data, profit loss statement accounting example, create sales invoices using macro, accounting design profit loss statement, accounting profit loss statement view, create xml file using excel macro, accounting profit loss statement free, accounting profit loss statement, create registration form using mysql, psds files create website, create simple banner using css, create contact form using formailpl, create website voting using java mysql tomcat, java program parse log files create report, copying contents cell using macro, create dyanamic website using php, create online admission using php javascript html, create floor plan using autocad, create flyers trifolds using adobe photoshop

About the Employer:
( 13 reviews ) Victoria, Australia

Project ID: #15550911

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
(262 Reviews)
6.5

14 freelancers are bidding on average $75 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
(376 Reviews)
7.3
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
(110 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.3
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
(8 Reviews)
4.0
jamestavs

Hi MD, I see there are 8 fields you need to extract from 150 excel files. This can easily be done and I can do it in less the 72 hours as you request, no plug-in should be required. Relevant Skills and Experience +15 More

$75 AUD in 3 days
(3 Reviews)
4.0
maximwang8661

i just went through your job post. it's very interesting to me. If you hire me, I can start working for you right now. Relevant Skills and Experience EXCEL macro Proposed Milestones $64 AUD - All

$64 AUD in 10 days
(7 Reviews)
3.2
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
$63 AUD in 10 days
(0 Reviews)
0.0