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: 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, posting excel sheets web page, excel calculate work hours days, compare excel sheets

About the Employer:
( 0 reviews ) United States

Project ID: #15680899

79 freelancers are bidding on average $424 for this job

jaylancer43

Expert Excel Programmer on [url removed, login to view] and have been featured by the freelancer community [url removed, login to view]) Relevant Skills and Experience I am an En More

$660 USD in 5 days
(528 Reviews)
8.1
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
(624 Reviews)
7.7
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
(222 Reviews)
7.3
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
(359 Reviews)
7.2
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
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
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
(27 Reviews)
5.6
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
(35 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
(70 Reviews)
5.4
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
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
(20 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
(22 Reviews)
4.0
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
(26 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
(12 Reviews)
3.7
hunmin888

I have a good experience in opencart

$277 USD in 15 days
(7 Reviews)
3.6
AhmedHassan1122

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

$555 USD in 10 days
(5 Reviews)
3.2
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
vidaldelatorre

This bid will provide excel sheet wherein data will populate automatically from another sheet. Relevant Skills and Experience Hi there- I am Vidal a civil engineer and proficient in Microsoft excel. I can provide the More

$250 USD in 10 days
(2 Reviews)
3.1
richcavanagh9

A proposal has not yet been provided

$350 USD in 2 days
(1 Review)
2.8
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
(9 Reviews)
2.9