Excel/Sheets work

ปิด โพสต์แล้ว 6 ปีที่ผ่านมา ชำระเงินเมื่อจัดส่ง
ปิด ชำระเงินเมื่อจัดส่ง

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

การบัญชี คีย์ข้อมูล การประมวลผลข้อมูล Excel Visual Basic

หมายเลขโปรเจค: #15680899

เกี่ยวกับโปรเจกต์

70 ข้อเสนอ โปรเจกต์ระยะไกล ใช้งาน %project.latestActivity_relativeTime|แทนที่%

freelancer 70 คน กำลังเสนอราคาในงานนี้ โดยมีราคาเฉลี่ยอยู่ที่ $434

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 เพิ่มเติม

$660 USD ใน 5 วัน
(873 รีวิว)
9.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 เพิ่มเติม

$500 USD ใน 2 วัน
(1196 รีวิว)
8.4
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 เพิ่มเติม

$500 USD ใน 10 วัน
(563 รีวิว)
8.5
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 เพิ่มเติม

$555 USD ใน 10 วัน
(457 รีวิว)
7.8
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 เพิ่มเติม

$750 USD ใน 2 วัน
(109 รีวิว)
7.6
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 เพิ่มเติม

$400 USD ใน 3 วัน
(39 รีวิว)
6.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 เพิ่มเติม

$250 USD ใน 5 วัน
(39 รีวิว)
6.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 ใน 10 วัน
(182 รีวิว)
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 เพิ่มเติม

$555 USD ใน 10 วัน
(45 รีวิว)
6.1
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 เพิ่มเติม

$250 USD ใน 2 วัน
(83 รีวิว)
5.9
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 เพิ่มเติม

$250 USD ใน 3 วัน
(40 รีวิว)
5.5
arslanu2

I would like to offer you my services over this job due to relevancy with my skills.

$750 USD ใน 10 วัน
(14 รีวิว)
5.2
samjohnyb4u

Hi, i m interested in this project and would like to start the project. Relevant Skills and Experience I know the importance of data entry and the attention to detail exceptionally well.I have a good internet speed, t เพิ่มเติม

$555 USD ใน 10 วัน
(4 รีวิว)
5.3
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 เพิ่มเติม

$333 USD ใน 10 วัน
(32 รีวิว)
4.8
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 เพิ่มเติม

$250 USD ใน 3 วัน
(1 รีวิว)
5.0
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 เพิ่มเติม

$555 USD ใน 4 วัน
(15 รีวิว)
5.1
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 เพิ่มเติม

$250 USD ใน 1 วัน
(28 รีวิว)
4.4
HarleyJohnson

As a specialist in Data entry,Powerpoint, PDF Conversion, Excel Works, searching the web for emails, phone numbers, address, contact person ... Web Development, Internet research, domain name creation etc the multitud เพิ่มเติม

$250 USD ใน 5 วัน
(9 รีวิว)
4.2
ANimesh996

hi can i help you sir Relevant Skills and Experience thank you Proposed Milestones $277 USD - 1

$277 USD ใน 10 วัน
(21 รีวิว)
3.9
AhmedHassan1122

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

$555 USD ใน 10 วัน
(10 รีวิว)
4.1