How to Create Trend Statements in QuickBooks
By Ken Burnside
Business accounting practices use trend statements as a readily understood report of current financial information compared to past financial gains, losses and expenses. QuickBooks has several standard trend statement formats, the most common of which is the profit-and-loss report. These reports present vital business information to investors, stockholders and board members.
Start QuickBooks by double-clicking on your company file. If you only have one company file, QuickBooks loads that by default.
Select the "Reports" menu, and then select "Profit and Loss" from the submenu. You can also select "Balance Sheet" as another standard trend statement, and if needed, you can create your own custom reports. Selecting a report will launch a wizard to step you through the process.
Enter the date range for the report you need. Sort the transactions by date, amount or the type of transaction you need for the report you're generating.
Set the style for the format by clicking "Edit" followed by "Preferences" and "Reports and Graphs." Select a layout style from the options presented. This doesn't alter the data, but it does alter the font choices, borders of cells and background colors.
Select the output format – PDF, print, or emailing it to interested parties. You can also export the report data to XML for importing into other accounting systems or database applications.
Ken Burnside has been writing freelance since 1990, contributing to publications as diverse as "Pyramid" and "Training & Simulations Journal." A Microsoft MVP in Excel, he holds a Bachelor of Arts in English from the University of Alaska. He won the Origins Award for Attack Vector: Tactical, a board game about space combat.