• 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 / Archives for audit

audit

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...

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