Excel formula needed to post transactions to their GL category columns

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.

Beceriler: Veri Girişi, Veri İşleme, Excel, Visual Basic

Daha fazlasını gör: accounts payable and receivable template excel, accounting in excel format free download, debit credit excel sheet download, how to create general ledger and trial balance with excel, create a general ledger in excel from general journal data, how to maintain accounts in excel sheet format, ledger account format in excel free download, excel accounting spreadsheet, excel vba xml post, call web service excel formula, excel formula sheet, microsoft excel formula sheet, check excel formula aspnet, excel formula convert utm latitude, excel work needed, excel macro needed, excel web query post, excel formula network address range, excel formula capture data time day, accounting excel formula

İşveren Hakkında:
( 133 değerlendirme ) Orange, United States

Proje NO: #18996273



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 Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 30%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(172 Değerlendirme)

Bu iş için 46 freelancer ortalamada $114 teklif veriyor


Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( Daha Fazla

$222 USD in 3 gün içinde
(677 Değerlendirme)

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. Daha Fazla

$220 USD in 3 gün içinde
(327 Değerlendirme)

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 in 3 gün içinde
(283 Değerlendirme)

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 m Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(174 Değerlendirme)

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 das Daha Fazla

$250 USD in 3 gün içinde
(76 Değerlendirme)

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 rega Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(222 Değerlendirme)

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(308 Değerlendirme)

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(190 Değerlendirme)

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 in 3 gün içinde
(81 Değerlendirme)

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 in 3 gün içinde
(103 Değerlendirme)

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 sho Daha Fazla

$150 USD in 3 gün içinde
(41 Değerlendirme)

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 optio Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(32 Değerlendirme)

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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(41 Değerlendirme)

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 ma Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(44 Değerlendirme)

Hi I am Chartered Accountant having more than 5 year experience in Bookkeeping. I am done work in your file but unable to attached as option is not showing. Please send me your mail id. . Familiar with MS Excel, Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(4 Değerlendirme)

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 tha Daha Fazla

$50 USD in 3 gün içinde
(5 Değerlendirme)

Hi, I'm a data analyst and have been working with Excel for over 13 years. Its an easy task and I can complete this today. I've already finished the February file, and happy to share it. I'm new here but have been act Daha Fazla

$35 USD in 0 gün içinde
(1 Yorum)

Greetings! I have gone through the job description clearly and I strongly believe that I would be a perfect fit for this project. I have a great experience in working on excel and I am well aware of formula and fun Daha Fazla

$35 USD in 2 gün içinde
(1 Yorum)

I'm graduated student from Accounting Information System. During my studied, I learn how to use the formula in Microsoft Excel by insert function and so on to make my work done correctly.

$166 USD in 5 gün içinde
(0 Değerlendirme)

Hi I have included the formula in your worksheet of february and successfully placed all your debit items in the respective column using a formula. You can also check this by looking at the totals to ensure that all Daha Fazla

$155 USD in 3 gün içinde
(0 Değerlendirme)