Task 1: Run the Company Data Auditor

The Company Data Auditor is a series of windows that guides you through the process of checking and ensuring the accuracy of the records in your company file. You can use the auditor to:

■	display basic information about the company file, such as the file name, release number, location, size, lock periods, last backup date, etc.

■	perform maintenance tasks, such as back up your company file and set lock periods

■	display bank and credit card account details, including the current balance and the date when they were last reconciled

■	reconcile your bank and credit card accounts

■	check your transactions for exceptions and audit trail changes.

1	Go to the Accounts command centre and click Company Data Auditor. The Company File Overview window appears.

This window shows you:

n	the company file name

n	the AccountEdge software release number

n	the location of the software you are currently using

n	the location of the company file

n	the size of the company file

n	the date on which the company file was last backed up

n	the date on which the company file was last verified

n	the end month and year of the current financial year

n	the date defining the locked period, if one has been specified

n	[ AccountEdge Plus only] the date of the payroll tax tables.

If necessary, you can perform the following maintenance tasks from this window:

Task	Action	See:
Back up your company file	Click Backup and complete the backup procedure.	page 315
Check your company file for errors	Click Verify and complete the verification procedure.	page 318
Set the locked periods for your company file	Click Lock Periods and select the date before which data cannot be entered.	page 255
Load payroll tax tables	[ AccountEdge Plus only] Click Load Tax Tables and then follow the on-screen instructions for loading tax tables.
Open the application or company file location	Click the icon next to the Application Location or File Location.

2	When you have completed the required maintenance tasks, click Next. The Account Reconciliation Review window appears.

This window shows you:

n	your bank and credit card accounts

n	the balance of each account

n	the date on which each account was last reconciled.

3	If you want to reconcile an account, select the account and click Reconcile Accounts. For more information on how to reconcile a bank account, see Review reports.

4	When you have finished viewing and, if necessary, reconciling your accounts, click Next. The Transaction Review window appears.

5	Enter the start date and end date of the period you want to review.

6	Click Run Review to start the transaction review of the following:

Reconcile invoices with the linked debtors account	The total of all customer balances is compared to the current balance of the linked accounts debtor account. If there is an out-of-balance amount, click Display to view the Debtors Reconciliation Exceptions report and review, customise or print the details of the report.
Reconcile purchases with the linked creditors account	The total of all supplier balances is compared to the current balance of the linked accounts creditor account. If there is an out-of-balance amount, click Display to view the Creditors Reconciliation Exceptions report and review, customise or print the details of the report.
Compare item values with the linked stock account	The total value of stock on hand is compared to the current balance of the linked stock account. If there is an out-of-balance amount, click Display to view the Stock Value Exceptions report and review, customise or print the details of the report.
Scan for future-dated transactions	The company file is checked for any transactions dated after the date shown in the End Date field of the Transaction Review window. If you did not change the date in this field, the current system date is the default end date. If there are transactions dated after the end date, click Display to view the Future Dated Transactions report and review, customise or print the details of the report.
Scan for prepaid transactions	The company file is checked for any prepaid transactions. These transactions include all customer and supplier payments (excluding deposit payments) that have a payment date prior to the date of the invoice or purchase. If there are payments made prior to the invoice or purchase date, click Display to view the Prepaid Transactions report and review, customise or print the details of the report.
Scan for deposits paid	The company file is checked for any deposits paid (within the date range specified) on sales orders or purchase orders. If any orders have a payment flagged as a deposit transaction, click Display to view the Deposit Transactions report and review, customise or print the details of the report.
Review audit trail changes	If you have selected the Use Audit Trail Tracking [System-wide] option in the Preferences window (Security tab), the company file is checked for any transactional, VAT, accounts, payroll [ AccountEdge Plus only] and system changes. If any changes occurred within the date range specified, click Display to view the Audit Trail report and review, customise or print the details of the report. For more information on audit trail tracking, see Audit trail tracking system.
Check for job exceptions [Cash Transactions]	If you have selected the Warn if Jobs Are Not Assigned to All Transactions [System-wide] option in the Preferences window (System tab), the company file is checked for cash transactions (within the date range specified) that have no job number. If any transactions are detected with no job number, click Display to view the Job Exceptions [Cash Transactions] report and review, customise or print the details of the report.
Check for job exceptions [Invoice Transactions]	If you have selected the Warn if Jobs Are Not Assigned to All Transactions [System-wide] option in the Preferences window (System tab), the company file is checked for sales and purchase transactions (within the date range specified) that have no job number. If any transactions are detected with no job number, click Display to view the Job Exceptions [Invoice Transactions] report and review, customise or print the details of the report.
Reconcile payroll liability payments [ AccountEdge Plus only]	If you use integrated payroll, the total of payroll liabilities transactions that are unpaid is checked against the balance of the linked accounts payable account Payroll Category. If there is an out-of-balance amount because a payroll liabilities transaction has a payroll paid date equal to or before the current session date, click Display to view the Payroll Liabilities Reconciliation Exceptions report and review, customise or print the details of the report.

7	When you have finished viewing and, if necessary, printing the Transaction Review reports, click Next. The VAT Exception Review window appears.

8	Enter the start date and end date of the period you want to review.

9	Click Run Review to do the following:

Check for VAT amount variances [Sales]	The company file is checked for variances between the VAT amount posted and the VAT amount calculated for the VAT codes assigned to sales transactions. If a variance is found, click Display to view the VAT Amount Variation report and review, customise or print the details of the report.
Check for VAT amount variances [Purchases]	The company file is checked for variances between the VAT amount posted and the VAT amount calculated for the VAT codes assigned to purchase transactions. If a variance is found, click Display to view the VAT Amount Variation report and review, customise or print the details of the report.
Check for VAT exceptions [Invoice Transactions]	The company file is checked for sale and purchases transactions without a VAT code assigned or where the entered VAT code is different to the default VAT code. If such a transaction is found, click Display to view the VAT Exemptions [Invoice Transactions] report and analyse the details of the report.
Check for VAT exceptions [Cash Transactions]	The company file is checked for Spend Money and Receive Money transactions without a VAT code assigned or where the entered VAT code is different to the default VAT code. If such a transaction is found, click Display to view the VAT Exemptions [Cash Transactions] report and analyse the details of the report.
Reconcile VAT code details with linked accounts	The company file is checked for variances between the balance of the linked VAT accounts and the amount of VAT that has been collected and paid on transactions. If variances are found, click Display to view the VAT Code Reconciliation Exceptions report and analyse the details of the report.

10	Click Finish. A message appears asking if you would like to print a summary report of the audit findings. Click Yes to print the report or click No to close the Company Data Auditor window without printing the report.