expenses

James, Roy, Rich, Charles, Julie, Alice, Hector, Vinton, Kiera, and Corey are travelling. They are staying at a flat at 33 USD per day. They all have money but not equal and they are going to pay in sequence as mentioned in column. If someone don't have enough money the next person is going...

Hi guys! Need some help regarding this matter. I have something like this data in a table: <tbody> Column A Column B Column C Column D BP January Item A 56756 BP January Item B 4353 BP February Item A 235 BP February Item B 67457 BP March Item A 4577 Expenses January Item A 3452...

I have 12 spreadsheets one for each month of the year on which I track all our expenses. I want to tally a yearly total for all the expenses. The spreadsheets are titled Jan. 2017, Feb. 2017 etc. I want to have all totals on an additional spreadsheet following the same format as the other 12...

Hello Excel Gurus, I am having some difficulty and looking for some help. I am trying to pull together an expense report from several different locations. Unfortunately not all of the locations have the same accounts or are in the same order. I have compiled a list of the accounts on sheet 1...

I'm recording income and expenses in a spreadsheet and I filter the not all of the transactions always appear. I have a subtotal that I want to display what the filtered income and expenses are. Right now I can only do a sumif for the total amounts, and not when the amounts are filtered. Is...

Hello friends, The sheet which I have created has got following columns for data entry. column a date column b particulars column c amount column c category (5 categories in drop down menu are are income & commission, expenses, expenses reimbursed, loss, loss recovered) column d funds allocated...

Hi all! I start my first post in this board with a question involving a vlookup function with three different variables I'm not able to make it work, in a context involving the use of AdWords and its expenses reports. Here is the setup: TAB 1: Here is the input raw data to be processed TAB...

Hi everyone, i would like to enter the description "Occupancy" below NET PROFIT / LOSS using a vba code. Please note that the rows are not stable. The Schedule 1. shows the original data and schedule 2. is the expected result. Many thanks in advance Schedule 1. <tbody> A 1 Income 2...

I have a filtered list for expenses (LOA, Travel, Truck) each expense has a different value for a different employee, How can I come up with a subtotal in a separate cell? Total Expenses =$ ?? <colgroup><col><col></colgroup><tbody> Name Personnel Expenses Name 1 LOA Name 2 LOA, Travel...

I've had a search and found lots of threads on this but not one that answers my problem. This isn't how my spreadsheet is but the quickest way I can explain what I need: A1-A4 - Are staff wages C1-C6 - Are separate expenses D1-D6 - Are each the same drop down list of staff names who need the...

OK, this is a tricky one and I have NO idea where to begin to solve it but I'm fairly certain there is a way to do this. I have a workbook with two worksheets. One is named Expenses, the other Itemised Expenses. The Itemised Expenses worksheet has several columns but the salient ones are...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:RelyOnVML/> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> Hi all, I would like to SUM the below categories based on texts description criteria as my below extract using vba. OPERAT. EXPENSES + FINANCIAL EXPENSES +...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> Hi all, if is possible for anyone of you, I need your support so that to create a vba code, which should “SUM” rows based on text string criteria as my below extract. Should...

The question goes like this: Last year, the Tan household spent $11,000 on food, $5,900 on transportation, and $7,200 on other expenses. The cost increases per year by official estimates for food is 4.5%, transportation is 6.2%, and others are 8%. The family's total income in the previous year...

Hi all, i would like to write a vba command so to run through col. "A" and where find the account's description "Telephones & Postages" should convert it to "Telephones / Postages". In 1st schedule is an extracvt of original data and in 2nd is the expected result. Thanks in advance...

I have spent a lot of time making a great spreadsheet in Excel 2016. With relative ease and understanding for my business costs on one page. I would really appreciate it (my first time asking in this forum) if someone could help me create a formula that would give me totals for my Type of...

I need someone to produce a spreadsheet to manage the following problem for us through providing a spreadsheet. "We are 3 people with 3 different bank accounts, we have decided to share the expenses and profits between us 30%, 35% and 35%. So what we need is an excel where we can enter the...

Hello, ive been tryin to figure out how to do the next thing. I am creating a tool for my workers where there could be a single cell where they enter the amount they spend and in the next cell they select from a drop down list the type of expense (transport, food, hotel, airplane, etc...) click...

Hello, this is my first time posting to this site and could really use some help with the below, as I have already spent a long time trying to figure out an appropriate formula. I am creating a waterfall schedule based off monthly expenses, and need to allocate the total monthly expense for a...

Hello, I'm very new to excel so appreciate this problem may be very basic however i have a list of future expenditures in Column C with a running total at the bottom. In Column D I have whether it has been paid for or not with a simple yes or no. What i want is for when yes is entered into a...