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

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:

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:

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)


  1. Philip Baldwin says

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