The Data Exception Review checks all your transactions, based on a variety of criteria, for the selected date range. The Start Date defaults to the first day of the current fiscal year and the End Date to the current session date. You may change the date range if you wish. Click the Run Review button to start the Data Exception Review.

A progress status bar appears next to each item in the review during the processing. When the process is complete, the results are displayed as follows:

• A check mark next to the item indicates that no exceptions were found.

• A question mark next to the item indicates there were exceptions. To its right is a Print Report button. Click this button to open a report that displays the details of each exception.

Reconcile invoices with linked receivables account

The total of all the balances from all your customer cards is compared to the current balance of the linked receivables account. (You specified the account that is your linked receivables account in the Sales Linked Accounts window.) A question mark appears if these two amounts are not identical.

Click the Print Report button to open the Receivables Reconciliation Exceptions report.

Reconcile purchases with linked payables account

The total of all the balances from all your vendors is compared to the current balance of the linked payables account. (You specified the account that is your linked payables account in the Purchases Linked Accounts window.) A question mark appears if these two amounts are not identical.

Click the Print Report button to open the Payables Reconciliation Exceptions report.

Compare item values with inventory account

The total of all the on hand inventory values is compared to the current balance of the linked inventory account. (You specified the account that is your Asset Account for Item Inventory in the Profile view of the Item Information window.) A question mark appears if these two amounts are not identical.

Click the Print Report button to open the Inventory Value Reconciliation Exceptions report.

Scan for future dated transactions

A question mark appears if there are any transactions dated after the current session date.

Click the Print Report button to open the Future Dated Transactions report.

Scan for prepaid transactions

A question mark appears if there are any customer or vendor payments dated before the invoice/purchase date and the payment date is within the date range specified for the exception review. This excludes deposit payments that have a date prior to the invoice or purchase date.

Click the Print Report button to open the Prepaid Transactions report.

Review audit trail changes

There can only be results for this type of exception if you activated the Audit Trail Tracking preference in the Security view of the Preferences window. The tracking system records specific transactional, tax, accounts and system changes. (Changes and entries recorded by Audit Trail Tracking)

A question mark appears if any of the changes that the audit trail tracks occurred.

Click the Print Report button to open the Audit Trail report.

Check for tax amount exceptions (Sales)

A question mark appears if there are any sales transactions in which the value of the tax is different from the calculated value.

Click the Print Report button to open the Tax Amount Variance report.

Check for tax amount exceptions (Purchases)

A question mark appears if there are any purchases transactions in which the value of the tax is different from the calculated value.

Click the Print Report button to open the Tax Amount Variance report.