Closed

Excel/Sheets work

My business (restaurant) has been using two excel spreadsheets to essentially pay bills and then record them in a ledger for several years. I'm trying to simplify the process. Using our "transmittal" (the spreadsheet we pay invoices on), we enter the invoice date, payee, invoice number, g/l account number, and dollar amount, then they go to the ledger and enter just the date, payee, and amount in the appropriate area depending on the g/l account so we can tally how much total is spent in each account. If possible, I'd like to populate the expense ledger automatically when an invoice is entered on the transmittal. In other words, have the ledger look for the g/l account an invoice is charged to and copy that data to the next available cell. There is one file, but a separate sheet for each week's transmittal and then one expense ledger for the entire month. We used to use Excel, but are switching everything to Google Sheets this year if possible. Thanks, Rich

Skills: Accounting, Data Entry, Data Processing, Excel, Visual Basic

See more: excel worksheet templates, how to use microsoft excel 2013, how to create an excel spreadsheet with formulas, how to use microsoft excel youtube, how to use microsoft excel formulas, how to use excel sheet for calculation, how to use ms excel pdf, excel worksheet definition, macro compare excel sheets cell cell, work excel sheets, excel sheets work project, excel sheets work projects, call function excel sheets cell click, sample work progress excel sheets, code compare excel sheets, combining excel sheets access, customer service excel sheets, differences excel sheets, excel contract work, combine excel sheets

About the Employer:
( 0 reviews ) United States

Project ID: #15680899

76 freelancers are bidding on average $426 for this job

jaylancer43

Expert Excel Programmer on freelancer.com and have been featured by the freelancer community https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story) Relevant Skills and Experience I am an En More

$660 USD in 5 days
(594 Reviews)
8.2
cgullapalli

Hi Rich, I am good at Excel, vba, and Google sheet scripting work. I have worked on a good number of google sheet project to apply my experience on this. I have attachments. -Chandra Relevant Skills and Experience E More

$500 USD in 2 days
(746 Reviews)
7.8
schoudhary1553

Greetings sir, i can help you and your 100% satisfaction is assured if you allow me to serve. I can do this task as per your requirement Relevant Skills and Experience I have more than 5 years of experience with exce More

$500 USD in 10 days
(272 Reviews)
7.6
ponnarasiBabu

I am an excel expert and have completed many complicated excel related tasks. Can provide you sample if required of my past and current work. Read the project specs. Looks like this project is feasible. Just want to un More

$555 USD in 10 days
(399 Reviews)
7.3
dpune

create program so that it updates g/l excel automatically. Relevant Skills and Experience Excel/VBA Proposed Milestones $500 USD - Completed work

$500 USD in 10 days
(182 Reviews)
6.5
zu02

Hi, I advice you to solve it via Ms Access app with Excel and other automation. I'll provide a very friendly , smart interface. Relevant Skills and Experience ms Access/Excel/VB programmer since Ms Office 97 released More

$555 USD in 10 days
(31 Reviews)
5.8
helalru

I have read your project details and understand. I wanna show you sample work right now. Relevant Skills and Experience I have available experience to complete this project .To know details please check my profile Pr More

$250 USD in 3 days
(38 Reviews)
5.5
Bustercrab

G’day, I have an advanced business honed skill set with Microsoft Excel. Twenty years’ experience working in many different industries. I have carried out similar tasks for other businesses. Relevant Skills and Expe More

$250 USD in 3 days
(1 Review)
5.1
tiaratechies

Hello, if you have plans to hire a certified excel expert and Chartered Accountant. I can handle this so I can give you the best with in the given time frame. Relevant Skills and Experience excel Proposed Milestones More

$750 USD in 2 days
(37 Reviews)
5.2
renesontiongson

Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much. Relevant Skills and Experience Excel automation Proposed Milestones $25 More

$250 USD in 2 days
(76 Reviews)
5.5
kohencpa

Hi, I am a CPA with many years of experience working with individuals, corporations, partnerships and LLCs in many industries. I provide bookkeeping, accounting, tax and business advisory services. Please contact me to More

$555 USD in 4 days
(12 Reviews)
5.0
khudammunir

Hi I would like to bid for this project. I posses Data Analytics, Research, Accountancy, Administration, Banking and Content Writing experience with Advance MS Excel Dashboards, MS & Google Office, WordPress, Social Me More

$400 USD in 3 days
(22 Reviews)
4.9
arveeindigo

Hello, I'm very interested to complete this task for you. Viewing your attachment Transmittal and Ledger seems understandable enough. Each transmittal item will be reflected to a monthly ledger. Relevant Skills and Ex More

$333 USD in 10 days
(29 Reviews)
4.7
Rakibhasannur

Hi there, I read your project and I am ready with my team to start now. I think you will Give me a Chance to show my skill. Waiting For you respond. Thanks Rakib Hasan Relevant Skills and Experience High Performing More

$250 USD in 5 days
(28 Reviews)
4.3
insidenetsoft

Hi Rich, I would love to take to completion this task and to help you with more ideas gathered from my years of experience. We can implement automatons that will bring more value to your business. Relevant Skills an More

$250 USD in 1 day
(27 Reviews)
4.3
AhmedHassan1122

Google Sheet Expert Relevant Skills and Experience Google Sheet Expert Proposed Milestones $555 USD - Full Price

$555 USD in 10 days
(10 Reviews)
4.2
ketas

Dear, Thank for your detail requirement. I'm data analyst who have many years working experience using VBA on Excel. Could help you on this project. High quallity guarantee.

$500 USD in 10 days
(13 Reviews)
3.8
hunmin888

I have a good experience in opencart

$277 USD in 15 days
(9 Reviews)
3.9
mikhailkozalski

I am good at this part. Relevant Skills and Experience Accounting, Data Entry, Data Processing, Excel, Visual Basic Proposed Milestones $555 USD - all

$555 USD in 5 days
(5 Reviews)
3.5
cheungkc

We need to post account data from weekly Transmittal to monthly Ledger for record purpose Relevant Skills and Experience 15 years Excel VBA data processing Proposed Milestones $277 USD - Completion of work I am not More

$277 USD in 3 days
(7 Reviews)
3.2