• Home
  • About
  • Services
    • Services For Individuals
      • Personal Financial Planning
    • Business Services
      • Small Business Accounting
      • Payroll
      • Business Valuation
      • Succession Planning
      • New Business Formation
      • Internal Controls
    • Tax Services
      • Tax Preparation
      • Tax Planning
      • TAX PROBLEMS
        • IRS Audit Representation
        • Non-Filed Tax Returns
        • Back Taxes Owed
        • Payroll Tax Problems
        • IRS Liens
        • IRS Levies
        • IRS Wage Garnishment
        • IRS Seizures
        • Offer In Compromise
        • IRS Payment Plan
        • Innocent Spouse Relief
        • Get Your IRS File
    • QuickBooks Services
      • WHY QUICKBOOKS
      • QUICKBOOKS SETUP
      • QUICKBOOKS TRAINING
      • QUICKANSWERS
      • QuickBooks Tips
      • Buy QuickBooks and Save
  • Newsletter
    • Previous Newsletters
    • News & Weather
  • Financial Guides
    • Life Events
    • Business Strategies
    • Investment Strategies
    • Tax Strategies for Business Owners
    • Tax Strategies for Individuals
    • Frequently Asked Questions
  • Tax Center
    • Track Your Refund
    • Tax Due Dates
    • Tax Rates
    • IRS Tax Forms and Publications
    • Record Retention Guide
    • State Tax Forms
    • 1040 Tax Calculator
    • Marginal and Effective Tax Rates Calculator
  • Resources
    • Financial Calculators
    • News & Weather
    • SecureSend
    • Internet Links
    • Security Measures
    • Recommended Books
  • Client Portal
  • Contact

Contact Us

    Your Name (required)

    Your Email (required)

    Subject

    Your Message

    GLOBAL TAX & ACCOUNTING SERVICE INC.

    GLOBAL TAX & ACCOUNTING SERVICES INC.

    GLOBAL TAX & ACCOUNTING SERVICE INC.

    Click here for the client portal

    OFFICE -516-558-0065

    Email:omaida@globaltax.info

    • Fb
    • linkedin
    Your Personal Accountant Wherever You Are. Se Habla Español

    Contact Person

    Name: Omaida Fishman

    200 Broad Hollow Road, suite 203,
    Melville, NY 11747

    Cell: 516-784-7227

    Fax: 516-679-1964

    Email:omaida@globaltax.info

    Get Directions

    Creating Reports in QuickBooks, Part 2

    QuickBooks is a faster, safer, and more accurate method of doing your bookkeeping than using a manual system is. Still, you may occasionally tire of your daily tasks and wonder what all of these forms and records mean in terms of your overall financial health–and how to create the reports that go along with them.

    The actual mechanics of creating reports in QuickBooks are fairly straightforward. You can go to the Report Center, make a selection, maybe change the date range, and voila! Your company’s related data appears in neat rows and columns.


    Figure 1: You may be able to get some of the information you need by simply changing the date range on a QuickBooks report. 

    But perhaps you to see different columns than what QuickBooks’ report templates include. Furthermore, you might want to filter your output for more meaningful, targeted analysis. Some of QuickBooks’ reports–particularly those included in the categories Company & Financial and Accountant & Taxes—can be a little advanced for the average small businessperson with little bookkeeping experience. Yes, they’re easy to run, but they are also difficult to understand so you may need the assistance of a professonal.

    We strongly encourage you to let us run these more complex reports, such as the Balance Sheet, for you on a regular (monthly or quarterly) basis. Balance sheets provide valuable insight when making critical business decisions.

    But we don’t want to discourage you from working with QuickBooks’ reports on your own either. Some of the easier reports are A/R Aging Detail (to keep an eye on past-due payments) and Unpaid Bills Detail (to see where you stand with your own financial obligations).

    Make Reports Yours

    Sometimes, QuickBooks’ own report output is a bit too broad for your needs. So the program provides sophisticated customization options. You can work with these to narrow down and shape the data that appears in your reports.

    First, columns. Building reports from scratch would be too time-consuming and frustrating for you to do all of the time. And it’s unnecessary, since QuickBooks provides templates for its reports, sets of columns and data filters that would serve some businesses well, but which can be modified by each user.

    Try this. Open the Profit & Loss Detail report and click on the Customize Report button in the upper left corner. You will see that the Modify Report window opens.


    Figure 2: QuickBooks lets you modify the columns that appear in reports. 

    The Display tab should be highlighted. Change the Report Date Range if necessary by clicking on the down arrow to the right of the Dates field. You can also create your own custom date range by deleting the dates in the From and To fields and entering new ones, or by clicking on the small calendar icons and clicking on the desired dates.

    Warning: Do you understand the difference between running reports as either Accrual or Cash? This is important. If you don’t, let’s get together to go over some basic report concepts.

    It’s easy to change the default columns that appear in reports. You can either enter a column label in the Search Columns box or scroll down the list of all possible labels. Click in the space in front of the ones you want to include, and click on existing check marks if you want to remove those labels. You can also designate a sort order, either Ascending or Descending.

    If you want to work with the Advanced options, or if you come across a Display screen that puzzles you (depending on the report, you may have some complex choices), let us know.


    Figure 3: QuickBooks report Filters screen 

    When you’re done here, click on the Filters tab. This is a powerful element of QuickBooks report customization. You can limit your report output to data that meet certain criteria. In the image above, for example, you can tell QuickBooks which subset of Accounts should be included. Click on the Billing Status filter, and you can limit the results to Any, Not Billable, Unbilled, or Billed. You get the idea.

    You can apply multiple filters to a report. Every one you select will appear in the list under Current Filter Choices.

    The Header/Footer and Fonts & Numbers tabs are primarily cosmetic options you can explore on your own, but as you can see from this brief overview there are many ways to use QuickBooks reports as is or customized for your particular situation. We recommend that you work with reports regularly, both on your own and with us. The insight they provide can help your company grow and flourish instead of just getting by.

    Creating Reports in QuickBooks, Part 2
    • ← Creating Reports in QuickBooks, Part 1
    • Anatomy of a QuickBooks Inventory Item →

    Leave a Reply Cancel reply

    Your email address will not be published. Required fields are marked *

    Client portal
    Subscribe to newsletter


    Our Services

    We provide Business Services, Tax Services, QuickBooks Services and Services For Individuals.

    Read More

    • Long Island Location
      65 East John St.
      Hicksville, NY, 11801
      sal@salalbanese.com
      Phone: (516)417-8504
      Fax: (516)213-4895
      Cell: (516)987-9850
    • NYC Location
      2200 Broad Hollow Road, suite 203
      Melville, NY 11747
      sal@salalbanese.com
      Phone: (212)714-0064
      Fax: (212)629-9553
      Cell: (516)987-9850

    Client Portal

    Click Here

    Contact Info

    Address: 200 Broad Hollow Road, suite 203
    Melville, NY 11747

    516-679-1964

    516-784-7227

    516-558-0065

    omaida@www.globaltax.info

    Copyright © 2016. All Right Reserved. Powered by: WEB DESIGN YOU

    • Fb
    • linkedin
    MENU
    • Home
    • About
    • Services
      • Services For Individuals
        • Personal Financial Planning
      • Business Services
        • Small Business Accounting
        • Payroll
        • Business Valuation
        • Succession Planning
        • New Business Formation
        • Internal Controls
      • Tax Services
        • Tax Preparation
        • Tax Planning
        • TAX PROBLEMS
          • IRS Audit Representation
          • Non-Filed Tax Returns
          • Back Taxes Owed
          • Payroll Tax Problems
          • IRS Liens
          • IRS Levies
          • IRS Wage Garnishment
          • IRS Seizures
          • Offer In Compromise
          • IRS Payment Plan
          • Innocent Spouse Relief
          • Get Your IRS File
      • QuickBooks Services
        • WHY QUICKBOOKS
        • QUICKBOOKS SETUP
        • QUICKBOOKS TRAINING
        • QUICKANSWERS
        • QuickBooks Tips
        • Buy QuickBooks and Save
    • Newsletter
      • Previous Newsletters
      • News & Weather
    • Financial Guides
      • Life Events
      • Business Strategies
      • Investment Strategies
      • Tax Strategies for Business Owners
      • Tax Strategies for Individuals
      • Frequently Asked Questions
    • Tax Center
      • Track Your Refund
      • Tax Due Dates
      • Tax Rates
      • IRS Tax Forms and Publications
      • Record Retention Guide
      • State Tax Forms
      • 1040 Tax Calculator
      • Marginal and Effective Tax Rates Calculator
    • Resources
      • Financial Calculators
      • News & Weather
      • SecureSend
      • Internet Links
      • Security Measures
      • Recommended Books
    • Client Portal
    • Contact