tax

sir, This is Income Tax calculation where for 1st 2,50,000 rupees no tax. For the next 2,50,000 rupees tax is 5%. Above 5 lakh but below 10 lakh tax, it is 20%. Above 10 lakh, tax is 30%. if taxable income is 450000(4.5 lakh) for 250000 nil tax upto 500000 5%...

I have a Wages worksheet. I have a Pay amount (manually entered, Currency format, no decimal places) and a Tax amount (manually entered, Currency format, two decimal places). An an example, the Pay cell contains "£1000" and the Tax cell contains "£100". Is it possible to make the Tax cell...

Hi I want to create a work sheet to calculate income tax a follows TAX RATE SLAB TAX YEAR 0% 0-300,000 2019 5% 300001-50000 20% 500001-1000000 30% 1000000- income 354000 Besides using if conditions is there...

Me being out of touch with Excel has me being lost at the moment. Can someone guide me on what I'm missing here? This is what I'm trying to obtain. If a "Y" is entered in cell "C5", it will use a multiplier for tax placed in the cell "D5". If a "N" is used it will use the default amount in the...

Hi all, I'm trying to refine this formula that calculates the total taxes off of a tiered table. Assume $10,000 income. Notice the 2nd row has to be blank for formula to work, which I don't like. E.g. <tbody> Bracket Min $ (cell A1) Bracket Max $ (cell B1) Tax % (cell C1) $0 $4,740...

I am in the middle of creating a financial worksheet for myself and my coworkers. I am having trouble figuring how much time we worked for free due to taxes. I have my tax rates calculated. I have my gross rates calculated. For example: I work 10 Hours, My pay is $50. So my gross rate is...

I have a spreadsheet with sales tax collection data for 2018's Q4. It includes which county specifically each order's sales tax was collected for. See below: I need to calculate the total sales tax collected per county in orders shipped to California in column M. To accomplish that, I’d need...

Hello everyone, My name is David and I've been following the forum for a while. I've learned a lot but never got to write a post, so here I go! I'm trying to calculate the California Sales Tax that I have to remit to the state by county (aargh!), and have 3 tables: 1. Zip code and tax...

Hi all i am trying to use the formula from the tax website in excel but i don't know how to remove the numbers behind the decimal i.e the cents. The formula is as follows Y = AX - B Y is the tax A and B are from the tax table X is the weekly amount earned. For example fortnighly pay =...

Hi All, i need to create an invoice for a new client although its proving to be a little difficult as he wants me to calculate things by the minute. So i have an hourly rate of $50 ex tax (tax is 10%) im looking to just input my hours & minutes and the formula automatically calculates the tax...

Hi Everyone I need help on "If" function I have multiple State codes, Tax rate, Amount and Tax applied i.e. IGST ,CGST,SGST,What i need if State code is not Equal to "DLH" Than tax should be IGST,if State code is equal to DLH than tax should be CGST AND SGST. <tbody> <tbody> State Code...

I have been trying to make a Monthly Alphalist of Payees depending on the Return period selected from the scrollable list on the MAP sheet especially the amount of tax and the tax withheld column. The INPUT sheet where the Tax base for wte and tax base for gov mpay will be listed in sequence...

I'm trying to figure out a way to allocate a sell transaction to tax lots where the order might change over time. For example: Say you have a table with four columns and the number of units of stock stored in a row across the four columns. So A1 has the number 10 A2 has the number 4 A3 has the...

Employee wages = x Social security tax rate = 6.2% Social security limit = $128,700(no tax payed after) FUTA tax rate = .6% FUTA limit = $7,000 Medicare tax rate = 1.45% No limit

Can someone help me format this expression correctly? If the state is NJ and the credit card is Amazon then No tax but if the state is NJ and the credit card is anything other than Amazon then tax. =IF(AND(oknshipstate="NJ",okncreditcard="Amazon"),"No Tax", if...

I am looking for the code working on change of value basis, which does the following: after I type number in col A, column B would show 5% tax calculation and column C total with tax, I know that I can use formula in Col B =A1*0.05 and =A1+B1 in Col C but I have to copy the formulas and drag it...

Hello, I have a sheet called "2017 OTP Comparison" which houses tax data. There are the following columns A. Tax Type - Tax Return, Provision, or RTP designation B. Adjustment - Several different kinds C. Total - The numeric total for each adjustment D. Entity - Several different kinds E...

Hi All, Does anyone know of an Excel Payslip Calculator available to download somewhere? Normally when I want to estimate my next months Payslip based on my Basic and my overtime being 1 month in arrears I use this website: https://www.uktaxcalculators.co.uk/payslip-calculator.php But ideally...

Hello. My boss give me a raw data and ask me to create a dashboard with function like: If I type the tax ID from a search box (for example) it will get the profile of that tax ID from Raw data and display it in a dashboard. Any idea how should I start and what typle of dashboard I should...

Hello, I making a finance tracking file, Tab 1 - Summary - An overview that will change based on the selection I make Tab 2 - Details - List of every invoices with Period name (October 2018) and Tax code like "xxx" and Invoice amount Tab 3 - Data - So far just a list of Periods that a...