cash

Hi, Looking for guidance to create a Dashboard for quanties of stock, cashflow and other KPIs. I have table of data where: Column A = Date (ordered, earliest to latest) Column B = "In" or "Out" (if it's stock received or stock dispatched) Column C = Product code (e.g. 1, 2, 3, 4, 5) Column D =...

Hello and thank you in advance for the help. How can I accomplish this with a formula. Here's the situation. In my spreadsheet column A shows the cashier ID and column C is supposed to show the cash sales for the cashier. Over to the right on the same spreadsheet column J shows the different...

I need to review a list of data and return all of the matches based on 2 criteria and cannot figure out the entire formula. Below is what I have now but it only matches 1 criteria: "CASH IN IMPORT'!$R$5. How on earth do I add a second criteria, which would be column B of sheet '3.INT' matching...

I have an excel journal template that I want completed from a cashbook type source...I'll show a simple example: Say this is my cashbook <colgroup><col span="4"><col><col span="3"><col></colgroup><tbody> A B C D 1 DATE DETAIL AMOUNT CASH/CHECK 2 17-10-19 John 1000...

Hello, I have the code below to get the lookup amount of the selected client from sheet5, but I don't know what I did wrong since it's not showing the amount on the "txtTotal, can you please help me to get the amount of the selected client? Note: the Amounts on column "D" contains formulas...

Hi Everyone I am pretty good at excel until it comes to layout.. I’m a Treasurer with a local soccer club and we have a snack shack that I am responsible for. I need to create a sheet where I can enter the total number of notes for each denomination but here is the tricky part I need to do it...

Dear excel brothers and sisters, need your help please on something that perhaps is simple problem :) 1) I have a cash flow that runs on periods: ROW 1 - PERIODS: 1 / 2 / 3 / 4 / 5 / 6 / 7 / 8 / 9 / ROW 2 - CASH FL: 1 / 1 / 1 / 1 / 1/ 1 / 1 / 1 / 1/ ROW 3 - CELL: A3=5 2) My goal is to sum...

Hi, I have been given a task at work to allocate the revenue inflow from sales between a given start date and end date. The key known variables are: Start date End date Frequency of billing Total number of bills Amount per bill Total amount of cash flow during the period What would be the best...

Hey All, Quick question, I'm trying to calculate an ongoing IRR calc for a Private Equity Investment. For every period, I want to have an IRR calc up to that point. I need to somehow bring in the Fair Value of the fund on that date into the last cash flow of the IRR calc, otherwise the Cash...

I am working on a salary sheet and stuck on this situation. Sheet has a to z columns with these headings. What i need is, if employee name and employee code repeat several times, then i get sum of his duty, wages, pf, esi, pt, gross salary, advance, uniform, add money, take home, bank cheque...

Hi, I'm looking for a way to distribute left over cash flows to other loan repayments. At the moment I have a percentage input of the free cash flows to be distributed over 5 different loans. Those free cash flows are annual and the percentages are fixed. At some point in time, 1 of those...

Hi, Is there any way get NPV of uneven cash flows, without listing all cash flows? I'm hoping to replicate the Financial Calculators CF function, for instance BA II plus has CF function. You don't have to list all cash flows, you just point out how many time each cash flow should be paid out...

Hi I've got three groups of data over 9 rows. Each group has duplicates and I'd like to delete the duplicate rows based on data in column C, which has Cash Sales. In the table below, column A has Product IDs, column B has Product Names, column C has Cash Sales and column D has the Group...

Hello, I'm trying to make life a little more efficient for some of our accountants but have hit an excel brick wall. Background: We consolidate about 7 company's financials into one consolidated financial statement. For reasons unknown, these financials are not in a standardized format so I...

I am making a weekly summary file for my bar. End of each week I "move or copy" the 7 daily cash up sheets into the weekly sheet, named by the days of the week. In the weekly sheet, I have the cash summary page, which has a column of various headers (denomination, pdq, amex, discrepancies, etc)...

Hi All, I have inadvertently, through another piece of code, got a number of files that have 2 named ranges with the same name. I'd like to delete just one of these but not sure how i'd write the code to ensure I was deleting the correct one (the bottom of the 2 below): Name...

Hello guys, Please find attached an EXCEL I created for Daily Expenses / Outputs and Daily Sales/Inputs. (cant find attachment feature here) Unfortunately I can't use the FILTER properly. -If you try to filter BANK category to show only, it also includes Cash. -If you filter CASH category to...

Please refer to the attached spreadsheet, my property analyzer. You'll see all the columns on the left that show all the important metrics I look for when analyzing potential investment properties. After entering a minimum of data I look to the YEAR 1 COC ROI (COC) (Cash on Cash Return on...

Please refer to the attached spreadsheet, my property analyzer. You'll see all the columns on the left that show all the important metrics I look for when analyzing potential investment properties. After entering a minimum of data I look to the YEAR 1 COC ROI (COC) (Cash on Cash Return on...

2 workbooks. One called "Cash Flow"; the other called "Budget" In the workbook Cash Flow, there are different months on each worksheet (January, Feb etc). Within Budget, there are columns titled Jan, Feb, etc. I want to pull a specific cell or range of cells within January (Cash Flow) and...