Find Jobs
Hire Freelancers

Excel formula needed to post transactions to their GL category columns

$30-250 USD

Ολοκληρώθηκε
Αναρτήθηκε περίπου 5 χρόνια πριν

$30-250 USD

Πληρωμή κατά την παράδοση
Hello Freelancers, We need a formula inserted into our statements so that the debit transactions are posted to their corresponding cost category columns. We have 12 statements that need this formula added that will post the amount of the debit to its correct column based on the "Ledger for Reference" column cost category that has already been added for each transaction. it just needs to be copied to its matching column for that cost category. We have included the first statement to insert the formula to show us the transactions are coded accordingly. If you want to be hired, use this statement to show us you can do this. We will be hiring a freelancer fairly soon so this can be completed tomorrow morning. IMPORTANT: TO be considered we must have the first file completed so we know you can do this. Once hired we will give you the other 11 files to insert the formula and verify all totals are correct once the amounts are posted to the matching cost categories. you can message the completed file to me for review. IMPORTANT: There are two files included: JANUARY has been completed manually for reference of what we need. We need the FEBRUARY file completed by you using the formulas you will use so we know you can do the job. We expect this to be fairly simple based on past Freelancers work so post your bids accordingly.
Ταυτότητα εργασίας: 18996273

Σχετικά με την εργασία

41 προτάσεις
Απομακρυσμένη Εργασία
Ενεργός/ή 5 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα
Πληρώσου για τη δουλειά σου
Περίγραψε την πρόταση σου
Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν
Βραβεύτηκε στον/στην:
Avatar Χρήστη
Hi, I have good Microsoft Excel skills with years of experience as well as I have complete number of projects for Excel to manage data and sorting. You can check my profile feedback section and you will know what my client asking for my work. I am Alison certified for Microsoft Office and Microsoft Excel. So, you can Trust me for a Best output with complete satisfaction. Your work will be delivered well in advance with seamless communication & timely response until project is completed. As well as for any alternation and query we are available 24 x7. Looking forward for great business deal. "
$30 USD σε 0 ημέρα
4,9 (550 αξιολογήσεις)
8,1
8,1
41 freelancers δίνουν μια μέση προσφορά $114 USD για αυτή τη δουλειά
Avatar Χρήστη
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$220 USD σε 3 ημέρες
4,9 (451 αξιολογήσεις)
8,4
8,4
Avatar Χρήστη
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$150 USD σε 3 ημέρες
5,0 (487 αξιολογήσεις)
8,0
8,0
Avatar Χρήστη
Hi, I am ready to start right away. I'm an expert in Data Entry. I understood your all requirements. I have done many projects like this. Regards, Noor
$150 USD σε 1 ημέρα
4,9 (348 αξιολογήσεις)
7,3
7,3
Avatar Χρήστη
I am a financial expert and guru in Excel/VBA/Macro. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, spreadsheet manipulation, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts (script for charts). I come up with creative and sophisticated financial & statistical modules in a simplified and logical manner including business valuation & terminal valuation methodology & ratios. With these skills, I develop financial modules including depreciation schedule, long-term debt, business valuation methodology & ratios. The modules incorporate complex components of business in a simplified and logical manner.
$250 USD σε 3 ημέρες
4,9 (95 αξιολογήσεις)
7,5
7,5
Avatar Χρήστη
Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me. Roy
$100 USD σε 1 ημέρα
4,9 (480 αξιολογήσεις)
7,4
7,4
Avatar Χρήστη
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews, they speak for themselves. Best regards
$60 USD σε 1 ημέρα
5,0 (312 αξιολογήσεις)
7,4
7,4
Avatar Χρήστη
Hi, You won’t make the right candidate selection without knowing what your project on creating Excel formula that will allocate debits transactions to the proper category columns will look like. Fortunately, I can show you how your job will look like before you award the project. Before you award this project, I can complete a part of this project as a sample. This is so that you can be confident of the hands you will entrust this task. If you are satisfied with the result, you can go ahead and award the project. I’d love to discuss more about what would make this project a success for you. Can we have a quick chat? Thanks for your time.
$150 USD σε 3 ημέρες
4,9 (68 αξιολογήσεις)
6,9
6,9
Avatar Χρήστη
Greetings! I have the workbook for February updated with formulas - it is complete and ready. As a Freelancer, I cannot initiate a chat myself. I can share the workbook, if you can contact me. There is only one minor tweak that I noted that must be required. Can the "Revenue/Income" header in cell G7 be changed to "Revenue". Basically, the header information for each column (Row 7 of Classification Worksheet), should match the exact LEDGER FOR REFERENCE value for the category. Being a full time freelancer working exclusively on Excel based projects, I work on such Excel based tasks every single day. I can complete all the 12 Workbooks (I guess with 2 files already completed, it will be 10 more files) in few hours. I have 18 years experience in using Excel as part of my daily work life. Over the last 25 MONTHS , I have spent at least 250 HOURS on automation in Excel every month. Have a Great Day! Srinivasan Krishnamoorthi
$60 USD σε 1 ημέρα
5,0 (228 αξιολογήσεις)
7,1
7,1
Avatar Χρήστη
Hello, I am experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards Rina B.
$50 USD σε 3 ημέρες
5,0 (122 αξιολογήσεις)
6,6
6,6
Avatar Χρήστη
Hello there, I am an Excel freelancer with backgroud in Accounting. I open your Feb file and I see no data in here. When I open the Jan, I search the Revenue of Leapfrog then I see value in Bank statement is not match with Amount. I can do this by macro and formular for you. I think it's very fast and 2 hours is enough but I need more explaination from you. Please contact if you want my support Thank you.
$100 USD σε 1 ημέρα
5,0 (233 αξιολογήσεις)
6,6
6,6
Avatar Χρήστη
Hello. I have good skills in "Data Entry, Data Processing, Excel, Visual Basic". I have working for 7+ years in this field. I 'm very interest to your project. I have checked your project description carefully and i can do it. I 'll do my best till you satisfy if you want me. Contact me please. Thank you. Yang L.
$140 USD σε 1 ημέρα
4,8 (100 αξιολογήσεις)
6,0
6,0
Avatar Χρήστη
Hi I have filled in the February file with formulas for Payroll Liabilities, Auto Repairs, Life Insurance and Telephone columns. In order to send you the file, you will have to message me first, as there is no option to attach file when submitting a proposal. Formula for other columns are also similar but I will need some more time to relate each Ledger with the corresponding column, and in some cases I might need to confirm with you on this. Can we please discuss and take this ahead. Thanks Roni
$90 USD σε 1 ημέρα
5,0 (32 αξιολογήσεις)
6,0
6,0
Avatar Χρήστη
Sir, I am well versed in these kind of jobs and can do your project as per requirement. ***I am ready to start Waiting to hear from you. Regards Relevant Skills and Experience Data entry, excel
$98 USD σε 3 ημέρες
4,6 (104 αξιολογήσεις)
6,3
6,3
Avatar Χρήστη
Hey! Please contact me first before placing any order. I am a qualified chartered accountant and working in an Audit/Consultancy firm as an auditor from 7 years. I had done ACCA, ICAEW, ICAP.I have experienced more than 40 companies on behalf of my firm. I was also working for Pepsi-Cola International at snacks plant. It is an honour for me to assist you in this task. Hoping for a positive response from you. *Fee will be negotiable according to your expected budget. I will share my firm profile when you contact me. Thanks Regards Muhammad Zaman
$50 USD σε 3 ημέρες
5,0 (15 αξιολογήσεις)
4,3
4,3
Avatar Χρήστη
Yesss, you don't have any idea how to work with an excel spreadsheet. It's clear. I'm an excel expert and I can teach you how to do your job. I'll do what you are asking, but the most important thing is that you will be able to do the job by yourself. I don't know how to share my excel work, so contact me and we solve togheter your problem.
$100 USD σε 2 ημέρες
5,0 (2 αξιολογήσεις)
3,4
3,4
Avatar Χρήστη
Hello Hope this message finds you in good health, Sir/Madam i have 14 years experience in Accounts handling both buyer & supplier, data entry, please provide me a chance to serve you, i assure you will appreciate my work, Best Wishes. Regards Umar Ehtisham
$155 USD σε 3 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
Hi there, I am Danish Ali professional accountant. I went through your post and I am interested in your job. I have diversified experience in financial accounting and MS Excel and delivering quality services around the globe. Please message me so that we can discuss further. Thank you
$35 USD σε 1 ημέρα
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
I am very comfort in Excel & its formula oriented job. I liked this. I always care your Project as of my own project. Try any error free job. rely me to get the project
$122 USD σε 3 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
Hello , I am Aayush Raj Giri , I request you to offer this job to me , I will try to do best , You will definitely impressed by my skills . With best regards Relevant Skills and Experience Data entry , Excel , typing
$111 USD σε 3 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
I work at an accountancy firm in Dublin, Ireland and have recently passed my final admittance exam to chartered accountants Ireland. I work with excel daily and should have no problem creating this formula for you. I can send you the completed excel file for February in the chat function once bid accepted (unsure how to do it beforehand).
$30 USD σε 1 ημέρα
0,0 (0 αξιολογήσεις)
0,0
0,0

Σχετικά με τον πελάτη

Σημαία της UNITED STATES
Orange, United States
5,0
157
Επαληθευμένη μέθοδος πληρωμής
Μέλος από Ιαν 13, 2009

Επαλήθευση Πελάτη

Ευχαριστούμε! Σου έχουμε στείλει ένα email με ένα σύνδεσμο για να διεκδικήσεις τη δωρεάν πίστωση σου.
Κάτι πήγε στραβά κατά την προσπάθεια αποστολής του email σου. Παρακαλούμε δοκίμασε ξανά.
Εγγεγραμμένοι Χρήστες Συνολικές Αναρτημένες Δουλειές
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Φόρτωση προεπισκόπησης
Δόθηκε πρόσβαση για Geolocation.
Η σύνδεση σου έχει λήξει και τώρα έχεις αποσυνδεθεί. Παρακαλούμε συνδέσου ξανά.