April 15 is getting uncomfortably close.
QuickBooks, of course, can’t do your taxes for you. But it helps you lay some of the groundwork. Let’s take a look at QuickBooks’ tax-related reports and its powerful report-filtering options. But first, you’ll need to make sure that this output will be accurate.
Describe your company accurately
Your tax entity setting should have been established when you first set up QuickBooks, but verify that you’ve specified the correct one. Go to Company | Company Information. Your Report Information is in the lower left corner. Click the arrow next to Income Tax Form Used to see what’s active.
Here, QuickBooks shows you which tax lines have been pre-assigned to your accounts. You can specify a tax form line for unassigned accounts, but this is something you should not attempt on your own. This report, though, will give you an idea of how useful your report output will be and where you’ll need our assistance.
Other reports provide tax-related data. You can access them by going again to Reports | Accountant & Taxes and clicking:
- Income Tax Summary. This displays totals for each tax line that’s relevant to your particular tax entity. Double-click on any number, and the Tax Line By Account report appears, detailing every transaction related to every tax-related account (you could add a column for Tax Line in Display options and make this quite a useful report).
- Income Tax Detail. This lists all individual transactions by tax form/schedule line assignment.
Paring it down
Some tax reports can be very lengthy; you may want to filter them to look at various “slices.”
Click Customize Report | Filters:
The options listed under Choose Filter are available on other reports; they help you set up incredibly complex searches using multiple filters.
Let’s say you want a report that displays your installation labor costs on new residential construction from the last year (you could also throw other variables in). You’d simply choose the filters from the left pane and then select related options in the next pane (usually a list). You’d want to also click on the Display tab to make sure that the appropriate columns appear.
QuickBooks reports can shave time off of tax preparation, and filtered views help you scrutinize your data in quite creative – and very useful – ways. The program’s boilerplate reports have their place in simple examinations of your financial status, but filters are potent tools. And custom QuickBooks reports can be even more useful. They can facilitate the kind of deep analysis that helps you make critical business decisions.
If you have questions on this or any other QuickBooks feature, call us at (203) 227-9475 or submit a question via our Contact form. MISSION is your partner and we’re here to make your business better!