Find Jobs
Hire Freelancers

App that creates an income statment from a google doc or excel spreadsheet

$250-750 USD

Completed
Posted over 10 years ago

$250-750 USD

Paid on delivery
I have a spreadsheet that has a number of columns with information about class rosters, payments and students. I need a macro that will take that spreadsheet and create payment rosters for each of the classes with the class name, date, total owed to the instructor and a detail of the class . The application can run on Google docs or excel--I'd like to discuss the options. The data is manually pulled from a third party event registration tool, the total tuition summed and the instructors portion (a simple %) calculated. The output is a document or email (again open to discussion) that contains the class date, name of the class, class instructor, total revenue, total due instructor, some boiler plate on terms, and a listing of the the student names the amount each paid.
Project ID: 5104330

About the project

8 proposals
Remote project
Active 11 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi..I haved looked at details and am looking forward to work with you...I am expert in developing macros for both Excel and Google Docs..So which suits you most, I am ready....The output I will provide is in Excel format...or PDF format if you prefer this or both.....I am available to discuss further in detail.
$252 USD in 3 days
4.9 (110 reviews)
5.8
5.8
8 freelancers are bidding on average $302 USD for this job
User Avatar
REVISED BID BASED ON ADDITIONAL INFO. Hi! The choice of the software (Google docs or excel) will depend on the use of the document. If the document is going to be used at only one location and multiple persons need not make changes into it simultaneously, we don't need to bother about Google Docs. Excel provides far greater functionality and formatting options than Google Docs. Hence I will recommend use of Excel for this project. Saw your revised file. Am I right to say that you will need one report for each of the following events ? 1. Advanced WordPress with Web Designer Pepper ONeal 2. Are You My Type with Author Mary OGara 3. Becoming a Professional Author with Bestselling Author Kayelle Allen etc. I think the format you have suggested can be improved a great deal. Also the report can be printed in PDF and emailed using either an inbuilt email client like Outlook or a web service like gmail with option to edit the mail before sending. Look forward to working with you.
$250 USD in 15 days
5.0 (36 reviews)
5.1
5.1
User Avatar
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at my feedback to know more about me and my work. Waiting for more details along with positive response. Thanks.
$444 USD in 10 days
5.0 (20 reviews)
4.8
4.8
User Avatar
hey lesliedow, we are interested. Please reply - we can discuss further. Our choice - Excel over Google DOC, Please do share the excel sheet that you are using right now. Please reply i will be back in 10 minutes. thanks !
$250 USD in 3 days
4.9 (44 reviews)
4.6
4.6
User Avatar
Hi, I am a chartered accountant and an advanced Excel expert. Consider me pls for a dianamic expert excel based system. Thank you
$250 USD in 3 days
4.8 (18 reviews)
4.3
4.3
User Avatar
***BID REVISED*** read the updated information. thanks ***I read both word report file and csv data file, and I really wish to do this job as I like automation work on excel personally.*** Respected Sir, It would be pleasure for me to render my services to you for making an automated excel sheet which take the data and manipulate according to your given conditions. I understand your requirement fully. I assure you the quality and timely work. Please message me here on freelancer IM so that we can have more detail discussion. It is more convenient if you provide me raw data so that I can make an accurate bid time completion. I have also accounting experience so it is easy for me to made the required excel sheet. If you have any query please ask. thanks, best regards, imran
$250 USD in 2 days
5.0 (21 reviews)
3.9
3.9
User Avatar
Working with VBA excel is my passion. there is 4 years i work with it. I have automate many process in my institution here.
$421 USD in 5 days
5.0 (2 reviews)
3.3
3.3

About the client

Flag of UNITED STATES
san francisco, United States
5.0
1
Payment method verified
Member since Nov 7, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.