Which tax spreadsheet

I will send you one as soon as I can. In through , I was forced to split the spreadsheet. This was due to the fact that earlier versions of Microsoft Excel limited the number of cell format changes. For example, Schedules D-1, Continuation Sheet for Schedule D, and E, Supplemental Income and Loss, were split out because they contain a lot of format changes and they are mostly "stand alone" schedules.

From through , a newer version of Excel was used to prepare the spreadsheet; however, an Excel Lite version was available for users who do not have Excel or later. Search this site. For and later , the Lite version is discontinued. Tax Year: Tax Year: Lite. Please use the file listed below to update your January-June spreadsheet in order for it to work for July-December Please use this template: Spreadsheet Template: July-December Templates for prior periods are listed above in the "Spreadsheet Templates" box.

If you cannot see the video above, click here to view it on YouTube. Download PDF Instructions. Sales Tax Spreadsheet E-Filing. Information for New Spreadsheet Filers. It helps to visually digest and make sense of the data when there are subtotals along the way. However, the typical addition formulas Excel provides can cause frustration.

Either the SUM formula double counts the intermediate sums or you risk missing a cell if added up one by one. Using this formula, you can create sums of specific rows without cluttering the surrounding cells with calculations and your grand total will not double count. To utilize this formula use the following steps. The subtotal formula also works great with grouping data. A lot of times you want to see the individual items that sum up to each line item in your Tax Tracker.

Instead of creating a whole new sheet for this, you can sort your data by category and group with subtotals. Under Column, select Category. Under Sort On, leave as Values. Also ensure the "My data has headers" check box is selected. Select OK. In the pop up window, select Category under "At each change in".

Under "Use function" select Sum, and under "Add subtotal to", select Transaction amount. Also make sure the check box "Summary below data" is checked. Click OK. The results of these steps add subtotal rows for each different category, and sum up on the transaction amounts, including a grand total at the bottom. Ultimately the key to managing any data is consistency - whatever methods you choose to compile your tax data, it must be done on a regular basis. Armed with the free Tax Tracker template and your Excel formula knowledge, preparing for tax season this year will be a breeze!

Brandon is a full time CPA specializing in all things tax. When he is not serving clients, he enjoys spending time with his wife and son, real estate investing, and sipping fine bourbon. Please login or sign up to comment. Learn about it here. Learn more here! Toggle navigation GoSkills. Search for courses or lessons Search. See resources. See certification. Resources Looking for help with Microsoft Office?

Resources Deepen your understanding of popular LSS tools and techniques, and simplify complex LSS concepts with our thorough how-to guides and resources. Certification Lean Six Sigma certification can fast track your career and boost your pay packet. Resources From accounting software tips, to taxes and financial modelling techniques, our resource center has free guides to help you gain the finance knowledge you are looking for. Resources Explore our resource center to find templates to help you get the job done, job interview tips, insights to tackle your biggest project management challenges, and so much more.

Certification It pays to be certified in project management. Resources Having difficulties adjusting to remote work? Resources We want to help you succeed!

Resources Check out our resource center to find answers to common coding questions, interview tips, and step-by-step guides that will help you in your development career. Resources Check out our resource guides to learn more about the graphic design tools that will help you to achieve your design dreams.

Resources From Python to Excel, or Power BI, Tableau and beyond, check out these free resources to help take your data analysis skills to the next level.

Get the free Tax Tracker Excel template Make your tax preparation a breeze with this free template Enter your email address.

Start learning essential finance skills today Get started for free with GoSkills courses Start free trial. Loved this? Subscribe, and join , others.