tax

I have been working on a vba macro for a spreadsheet that i am setting up for accounting. What I need to do is to have the vba check the data in column F and if the criteria matches then I need it to clear the contents in column E of the same row as column F. I have it working to get an exact...

I use Google Calendar with a script that counts up the revenue. I use Wave accounts to import bank transactions. I does 3 lots of tax including US, tax credits and UK self assessment. Please let me know if there is anything suitable? Thanks

Hello, I am looking to create an Index/Match (open to other suggestions) that would based on a specific section of cells based on a conditional match. In example below, John Smith has pay/deductions designated to Department 200 and 201. If I'm looking for the Tax 2 amount for John Smith in...

Hello all, So this is probably a lot easier to solve than i am making it but i need a formula (or VBA) that will solve for the "Dealer Price" (in blue)...

I have two files that I need to compare against each other. My K4C file has 866 rows that consists of individual grant applications, My GO file has approximately 463 rows of consolidated grant requests. What happens in this process is individuals apply for grants to organizations based on tax...

I am trying to run VLookup to display the result in variable called Tax. Looking up examples, I cannot somehow get my code to do what I want. I also want to preset the searchkey in a variable called eno I have commented the code to show "code working" or "code not working" Please help, see...

I have a sheet called 2018, which tracks income, expenses by category, and taxes for that year. I have a hidden sheet called tax report. I have another hidden sheet called template, which is a template for the year sheet. When user closes out 2018, it will unhide the template, make a copy of...

I am looking for help to autofill cells based on VAT codes In column I are the tax codes which are either T1, T2, T9 or T13 in column J I would like to see against either T2 or T9 - 0 For T13 - no result For T1 - column H has the gross amount - in column J I require the VAT included (so if...

Hello, I have a question on trying to run a query. So I have a report that has all my information and I ran a query to pull up all duplicates. I created another query to add up those duplicates. Now I want to to bring those duplicate totals back to my original spreadsheet. Ive been stuck with...

Hello, Could you please help me with the file below: https://www.dropbox.com/s/22po50q2s9rl05g/Tax.xlsx?dl=0 Thank in advance

Hi I am struggling with a part of a project I am working on and have been unable to find a solution. Hoping someone here can assist. I need to be able to insert formulas into columns AA-AG, based on data (that is variable) in column H I am calculating capital gains based on tax lots and the...

In my worksheet I have to collect different tax number, In column T it states what type of tax number it is E.G. “This is a Foreign Tax Number” “I cannot issue a tax number” “This is a Social Security Number ” “This is an Individual Tax Identification Number ” “U.S. Employer...

Cumulative invoice value will be considered to calculated taxable amount basis of which to compute tax to be deducted against each invoice value. Kindly please please to come to cumulative taxable amount based on threshold limit. Inv No Inv Amount ALS999MAP 551799...

I am very new to the index match function. I am trying to pull a particular cell in a specific row of data that matches a certain criteria. I am pulling summarized data from an large excel for financial statements. The formula I have is: =INDEX(bs!$AF$3:$AF$300,MATCH('Irish...

Hi All, I'm trying to get a macro to work. The code I currently have is below. The code in bold does not work correctly Ideally, I would like the macro to copy use the input from the "First year of issue" (e.g. 2016/17), and then duplicate it x times below (depending on the value of D27). It...

Hi All, I'm trying to get a macro to work. The code I currently have is below. The code in bold does not work correctly Ideally, I would like the macro to copy use the input from the "First year of issue" (e.g. 2016/17), and then duplicate it x times below (depending on the value of D27). It...

Hi! I am starting a new job next week. I need to pay my owntaxes on my income. What is the best way to calculate tax deductions in excelspreadsheet? Thanks in advance.

Hi I’m trying to build a spreadsheet 1099 tax form for USA tax purposes, so I can complete the form for all the vendors via a marco/s. On Sheet1 (Customer Record) I have the customer details Tax Numbers to zip code. This will be done manually as they supply W9 forms. Zip Code...

I have my project working great except for one detail that I missed, I am shaking my head in disbelief that I did so. And now I don't know how to proceed. So long story short I have an Userform that totals 4 textboxs and and puts the total in the Total textbox. Then lastly I have a textbox that...

Hi all i have the following formula but i dont want to calculate anything if the amount is less than R6512.51 as 18% Tax is due only above of that amount. =SUM(Gross Pay-6512.51)*18%