Suljettu

Improvements in an Excel file for financial controls

I have an excel file containing basically expenses and incomes and need this data to be consolidated (e.g. summed up; divided) in other tabs in particular ways.

For instance:

a1) if the "Paid by" cell is equal to the "Expense of" cell, account the value in the right category (e.g. Supermarket) of the payer's consolidation tab.

a2) if the "Paid by" cell is different from the "Expense of" cell, consult tab "Sharing of expenses" to see how that particular expense is shared. For instance, the tab "Sharing of expenses" indicates that "Supermarket" expenses should be distributed at the 60-20-20 proportion. So if I register that I expend USD100 in this category, a formula should distribute this value among 3 people: 60 should go to a balance sheet of person A, 20 should go to a balance sheet of person B, and 20 should go to a balance sheet of person C.

b) if a payment is done with a particular credit card, a formula should check the date of the expense and "decide" whether to allocate the expense in the current month or in the next month.

There are other similar rules that must be implemented. Please, estimate your bid based based on the 3 items above only. Values for additional developments can be arranged afterwards.

One challenge is to keep the file not too heavy and slow.

The project will certainly need some "back and forth" between me and the selected provider until we reach the desired results.

Taidot: Excel, Visual Basic

Näytä lisää: creation excel file, convert excel file address book, program sort excel file, search excel file vbscript, save datagrid excel file, form results excel file aspnet, submit thousands addresses excel file websitescase average results displayed denote unavailable averageduser click address direc, excel file credit debit, debit credit examples excel file, create debit credit excel file, i require some visual basic programming done on a team planning excel file we are using office 2010 or later, c# open and write to excel file, c program to write into excel file, export file explorer search results to excel, open a password protected excel file using vba

Tietoa työnantajasta:
( 4 arvostelua ) Coventry, Brazil

Projektin tunnus: #21410393

38 freelanceria on tarjonnut keskimäärin 113$ tähän työhön

jaylancer43

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 (g Lisää

$222 USD 3 päivässä
(722 arvostelua)
8.5
schoudhary1553

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. Pl Lisää

$220 USD 4 päivässä
(319 arvostelua)
7.9
KulfiSoftwares

Excel expert!! I have read the project details thoroughly, and believe to be a perfect fit, for the project.. I will provide unlimited revisions, until we reach the desired results. ZERO ERROR GUARANTEED!! Please read Lisää

$120 USD 1 päivässä
(280 arvostelua)
7.5
zekovicm

Hi there,I am Excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within the agree Lisää

$165 USD 3 päivässä
(108 arvostelua)
7.2
P0L

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.

$100 USD 2 päivässä
(308 arvostelua)
7.3
elqueabandona

Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the proje Lisää

$100 USD 2 päivässä
(229 arvostelua)
6.9
polarjin2017

Hello? How are you? I am excited to work with you on this project. This is what i have done in Excel/Word/PPT/Access/VBA/MACRO. Just Creating forms, query, Macro, custom formula, etc... [login to view URL] Lisää

$155 USD 3 päivässä
(92 arvostelua)
6.7
satishtl

- Have good expertise in Excel automation using macros. - Can get the "Paid by" value in the right category based on "Expense of" - Have the % distributed according to set proportion - Based on the transaction date in Lisää

$140 USD 5 päivässä
(50 arvostelua)
6.0
razvancotofana

Hello, I have built several similar personal budget tools to what you are looking for, and I would like to help you if I can. Please send me a message so that we can discuss in details your requirements. Looking forwar Lisää

$119 USD 10 päivässä
(16 arvostelua)
5.3
StormLion227

Hello. My name is Marko and I am an Engineering Graduate with an MBA degree. I am a full time freelancer and I will work hard on this till completion. An Expert VBA programmer on freelancer.com and I do not bid on Lisää

$90 USD 0 päivässä
(28 arvostelua)
5.2
vsprybhanu

Hi, My name is Virendra. I am experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of creating User Form, Command Button, Drop Down, Radi Lisää

$120 USD 3 päivässä
(77 arvostelua)
5.6
AkilaArun

Hi, I am interested in working on the task. I have experience working with excel formulas,excel VBA, Data Analysis(Statistically and Graphically) and in creating dashboards. Would like to discuss more about the task. P Lisää

$120 USD 4 päivässä
(40 arvostelua)
5.0
sonarkaushik

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

$98 USD 3 päivässä
(45 arvostelua)
5.6
ironstar20311

Hello, sir! I am happy to put my bid on your project. I have a full of experience with data processing using Excel formula and VBA. Everyone calls me "PRINCESS of Excel". (. ❛ ᴗ ❛.) Here are projects I have done recent Lisää

$50 USD 1 päivässä
(24 arvostelua)
4.7
alembaptista

Hello. My name is Alejandra Baptista I am an accountant, administrator and financial graduated. I am very fast typing and good in redaction or transcription. I have a lot experience with Excel, Power Point, Word, SPSS Lisää

$55 USD 1 päivässä
(11 arvostelua)
4.6
paulodayto08

Hi Good Day! A serious freelancer here. I can help you to complete this project. Can you share to me your file? I can make it automated using Excel Formulas and VBA Macro. Please consider my bid. I've done a lot of Lisää

$50 USD 2 päivässä
(32 arvostelua)
4.4
writingapp

Hi. I can write macro for 3 items above $60 in 2 days. Great app writer for your projects. I have writen scraping, excel, googlesheet, csv, database app, macro, vba for many years. I am ready to write your project. Tha Lisää

$60 USD 2 päivässä
(13 arvostelua)
4.3
Itblast

Providing Cost effective solution. Excel Group Member (Top 20%). Access Group Member (Top 30%). Proficient in Google Sheet 12 Years of experience working on Excel, Access, Word & Power Point. Excel: Worked on Exc Lisää

$155 USD 3 päivässä
(6 arvostelua)
3.9
IgeS

Hi, You need logical formula and best if done through VBA instead of nested formula in excel. I hope that you can discuss me more about this project.

$150 USD 4 päivässä
(2 arvostelua)
3.6
indrapandu

Hi, I've read your description. Those tasks can be done using VBA, and won't be difficult to achieve. I can share you a sample of how it works, if you are satisfied with it, we can go to the next step. Let's have a cha Lisää

$45 USD 1 päivässä
(13 arvostelua)
3.6