• Skip to primary navigation
  • Skip to main content

QBGarage.com

The QuickBooks Specialists

  • Home
  • Blog
  • KnowledgeBase
  • Company
  • Show Search
Hide Search
You are here: Home / KnowledgeBase / What Is the Closing Date Exception Report and How Do I Create It?

What Is the Closing Date Exception Report and How Do I Create It?

Chief Mechanic · September 6, 2010 ·

The Closing Date Exception Report in QuickBooks shows all transactions sorted by transaction type (e. g., Bill, Check, Invoice) dated on or before the Closing Date that were first recorded or modified after that date was established.  To add to its utility as an audit tool, it also includes the User Name of the user that recorded the transaction in the Last modified by column.

To produce this report, click on the Reports->Accountant & Taxes->Closing Date Exception Report menu selection.  Here’s a sample of the report:

QuickBooks Premier 2009 Closing Date Exception Report

The report begins with the changes to the Closing Date itself, followed by a list of transactions sorted by transaction type.  To change the settings for the Closing Date Exception Report, click the Modify Report… button:

QuickBooks Premier 2009 Closing Date Exception Report Display Tab

The Report Date Range refers to the transaction date itself.  As shown above, the report will include all applicable transactions dated up to and on the Closing Date.  The From field is blank because this setting looks backward to include all transactions.

The Days Entered / Last Modified refers to the actual date on which you performed this accounting task.  The To field is blank because this setting looks forward to include all transactions added or modified after the Closing Date.

By default, Show Deleted Transactions is checked, but you can uncheck this setting to exclude deleted transactions from the report.

Because changes to prior periods after they’ve been closed must be done with extreme care, this report is primarily an audit trail to quickly identify what transactions were recorded and by whom.

Vote This Post DownVote This Post Up (No Ratings Yet)
Loading...

KnowledgeBase, Reports & Forms audit, bill/bill credit, check, closing date, invoice

Reader Interactions

Comments

  1. Philip Baldwin says

    October 17, 2012 at 2:22 pm

    Is this report only available in Premier? I am using 2012 pro and I seem to remember it it in my 2010 Pro version?

    • Chief Mechanic says

      October 18, 2012 at 10:55 am

      No, that specific report isn’t available with Pro. See our article on the Pro vs Premier feature differences. While we don’t specifically mention that report (or others), it’s covered under the bullet-point of industry-specific reports.

Accounting

  • Financial Accounting Standards Board

Developer

  • Intuit Developer Network Forums
  • qbXML Onscreen Reference

Intuit

  • Enterprise Solutions
  • Intuit
  • Intuit Marketplace
  • QuickBooks
  • QuickBooks Online Community

QBGarage.com

Copyright © 2008–2023 QBGarage.com · Privacy · Terms & Conditions · Site Help