Transaction Review

The Transaction Review (Command Centers > Accounts > Company Data Auditor > Transaction 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. 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 view details of the exceptions, click Display, this opens a report detailing 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 and a Display button appear if these two amounts are not identical. Click Display 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 and a Display button appear if these two amounts are not identical. Click Display 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 and a Display button appear if these two amounts are not identical. Click Display to open the Inventory Value Reconciliation Exceptions report.
SCAN FOR FUTURE DATED TRANSACTIONS
A question mark and a Display button appear if there are any transactions dated after the current session date. Click Display to open the Future Dated Transactions report.
SCAN FOR PREPAID TRANSACTIONS
A question mark and a Display button appear 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, which are included in the Scan for deposits paid review. Click Display to open the Prepaid Transactions report.
SCAN FOR DEPOSITS PAID
A question mark and a Display button appear if there are any sales or purchases orders that have deposit payments attached to them and the payment date is within the date range specified for the exception review. Click Display to open the Deposit 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 and a Display button appear if any of the changes that the audit trail tracks occurred. Click Display to open the Audit Trail report.
CHECK FOR JOB EXCEPTIONS [CASH TRANSACTIONS]
Job exceptions exist only if you selected the preference Warn in Jobs Are Not Assigned to All Transactions in the System view of the Preferences window. A question mark and a Display button appear if there are any cash transactions that have a provision for a job number and no job number was entered. Click Display to open the Job Exceptions [Cash Transactions] report.
CHECK FOR JOB EXCEPTIONS [INVOICE TRANSACTIONS]
Job exceptions exist only if you selected the preference Warn in Jobs Are Not Assigned to All Transactions in the System view of the Preferences window. A question mark and a Display button appear if there are any invoice transactions that have a provision for a job number and no job number was entered. Click Display to open the Job Exceptions [Invoice Transactions] report.
RECONCILE PAYROLL LIABILITY PAYMENTS
The total of the accrual payroll transactions that are unpaid is compared with the current balance of each of the payroll payables linked account. (Your Default Withholding Payables Account is selected in the Payroll Linked Accounts window. You can select a different linked account for each payroll category in the Deduction Information window, Employer Expense Information window or Tax Table Information window. A question mark and a Display button appear if these two amounts are not identical. Click Display to open the Payroll Liabilities Reconciliation Exceptions report.