billing

Current Scenarios: My office colleagues are recording account receivable and sales data in sheet4, however, some companies have started multiple payments during the month and it is now difficult to manage them in this format. Action: so I decided to make new sheet for recording payments, which...

I am needing help with creating a formula that calculates the total cost of the equipment rental for the estimated says on rent. It is based off a 28 day billing cycle. i.e. i have the equipment from 8/1/2021 - 8/30/2021, then the company would bill be a monthly rate plus two daily rates. The...

I need help setting up a macro for a billing form I use for work. I need when I click a button, it recreates a copy of that same excel sheet, but I need the numbers from a certain column(sheet 2; column e13:E21) to slide over a column(to D13:D21) and also be added to the value thats in that...

Hi, I use the same bit of opening code on just about everything I ever work on (I know there are a lot of different ways of doing this): 'Finds last row of data on the Altos billing Nov 18 calls Sheets("Altos billing Nov 18 calls").Select LastRowWithValueAltos = Columns("A").Find("*", ...

I have a table, Column A represents a billing period (11/30/18, 12/31/18, 1/31/19 etc.) and column B represents an amount received for the applicable billing period ($100, 115, 105, etc.). In a separate cell I want to return a date of the last invoice payment received. So, if the table above...

Hello, I am trying to create a spreadsheet that will calculate a prorated price based on an effective date. I had found this forum by searching the issue where someone proposed this formula: =A2*(DAY(EOMONTH(B2,0))-DAY(B2)+1)/DAY(EOMONTH(B2,0)) The problem is we use a billing cycle starting...

so I have a table and am trying to write a formula that essentially states "if these codes are are in this column, sum the values", but all three I've tried come back with (blank): A99:=CALCULATE(SUM(dn_BillingMonthly[Corrected Billing Amt]),dn_BillingMonthly[Correct Code]="A2" &&...

Happy Monday! Hoping this is a quick and easy one for you all. I have four fields: Column AE: Order Status Column AF: Order Status Date Column AG: Billing Status Column AH: Billing Status Date I need to write a formula that returns the days between the Status Date and today IF the Order...

Hi All, Sheet1 <tbody> Start End Billing Period 01/01/1900 15/05/2017 1 16/05/2017 15/06/2017 2 16/06/2017 14/07/2017 3 15/07/2017 15/08/2017 4 16/08/2017 15/09/2017 5 </tbody> Sheet2 <tbody> Event Details Start Date End Date Number of Nights Billing Period(s) Event A...

Hi all, Thanks in advance for anyone who looks and helps me on this one, that is driving me crazy. I am looking to create a page that looks up each of my separate areas, and then returns a Top 10 (1-10) for each area with account number and the value outstanding with that account. I am...

Hi I have the following conundrum: I am creating a sheet that collects billing and shipping information and I want to use a check box that will copy the billing information to the shipping information section if the box is checked and delete the shipping information if the box is unchecked...

Hello MrExcel members, I have a billing statement I'm working on, which is populated mainly from a pivot table. The columns I am struggling with are labeled "Previously Billed", "Total Earned", and "Quantity To-Date". The pivot table includes all twelve months as headers, and the billing...

I have a problem I cannot work out. I need to show billing numbers according to the following table but cannot get my IF statement right. It is beyond my comprehension and I need help! Thanks! <colgroup><col><col span="2"><col span="2"></colgroup><tbody> base rate 14.61 0-2ccf 3.76...

Hi All, I am a moderate level excel and VBA user, I want to create a billing system for one of my friends restaurant, I need suggestions from experienced excel users in the forum, how should I go about this. I mean what should be the approach for this system

I have a spreadsheet that included 3 scenarios that results in a different billing charge for each scenerio dependent on the budget. Medium Budget CPM IMP 20% buffer Fee DV DCM FT Grand Total D $1,000,000 $6.00 166,666,667 200,000,000 - $17,000 $6,000 $20,000 $43,000 V...

Hi I have a data column that shows a series of level 1 and level 2 tags. the data presents as L1 space and then the name of the level 1 tag then a comma space then L2 space and the name of the level 2 tag. See examples below I urgently need a formula that returns the L1 tag name and a second...

Hi guys, I have a billing sheet, looks roughly like the one below. At the bottom of the cost column is a total that tells me how much to bill a client for a particular job, based on the hours worked and the cost of those hours. However, if any individual does more than 80 units of work on a...

Hi, I'm really new to this spreadsheet stuff and I can't seem to find a simple answer to this question... How do I make a cell change to another cell's value based on the value of a third cell? That's a confusing way to ask, perhaps. I have quantities (1-12) and different dollar amounts for...