Company Data Auditor

Transaction Review

The 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 financial 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 Transaction 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:

Reconcile invoices with linked debtors account

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

Click the Display button to open the Debtors Reconciliation Exceptions report.

Reconcile purchases with linked creditors account

The total of all the balances from all your suppliers is compared to the current balance of the linked creditors account. (You specified the account that is your linked creditors account in the Purchase Ledger Linked Accounts window.) A question mark if these two amounts are not identical. (Out of balance information -- Trade Creditors)

Click the Display button to open the Creditors Reconciliation Exceptions report.

Compare item values with stock account

The total of all the on hand stock values is compared to the current balance of the linked stock account. (You specified the account that is your Asset Account for StockStock Control in the Profile view of the Item Information window.) A question mark if these two amounts are not identical. (Adjusting item total values and unit costs)

Click the Display button to open the Stock Value Reconciliation Exceptions report.

Scan for future dated transactions

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

Click the Display button to open the Future Dated Transactions report.

Scan for prepaid transactions

A question mark if there are any customer or supplier 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 the Display button to open the Prepaid Transactions report.

Scan for deposits paid

A question mark 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 the Display button 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, VAT, accounts and system changes. (Changes and entries recorded by Audit Trail Tracking)

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

Click the Display button 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 if there are any cash transactions that have a provision for a job number and no job number was entered.

Click the Display button 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 if there are any invoice transactions that have a provision for a job number and no job number was entered.

Click the Display button 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 creditors linked account. (Your Default Withholding Creditors 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 if these two amounts are not identical. (Out of balance information -- Payroll Accruals)

Click the Display button to open the Payroll Liabilities Reconciliation Exceptions report.