Title:
QuickBooks Tutorial How to Save Time and Money Filing City Taxes
Video:
Description:For a better quality video and the full write up: nerdenterprises.com Download the Excercise Files Here: nerdenterprises.com City Taxes -- Total Sales By Customer with contact info: Why do we need to be able to do this? 1) To report for business tax purposes -- usually we need to know sales for the cities we do business in. 2) The methods shown here can be applied in many other useful contexts. What you will learn: You will learn which reports can include customer contact info and which one's can't and I will explain why. You will learn how to export the reports you need to combine into excel You will learn how to format the report in excel to make it much easier to read. You will see how a simple macro will speed up this process. You will learn how to write the vlookup formula in excel to grab information from one report and include it in the other. nerdenterprises.com http
Published:
29/Jun/2010
QuickBooks Tutorial How to Save Time and Money Filing City Taxes
Video:
Description:For a better quality video and the full write up: nerdenterprises.com Download the Excercise Files Here: nerdenterprises.com City Taxes -- Total Sales By Customer with contact info: Why do we need to be able to do this? 1) To report for business tax purposes -- usually we need to know sales for the cities we do business in. 2) The methods shown here can be applied in many other useful contexts. What you will learn: You will learn which reports can include customer contact info and which one's can't and I will explain why. You will learn how to export the reports you need to combine into excel You will learn how to format the report in excel to make it much easier to read. You will see how a simple macro will speed up this process. You will learn how to write the vlookup formula in excel to grab information from one report and include it in the other. nerdenterprises.com http
Published:
29/Jun/2010
No comments:
Post a Comment