Help Centre

End-of-period procedures > Month-end procedures > Task 1: Run the Company Data Auditor
The Company Data Auditor is a series of windows that guide 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, etc.
display bank and credit card account details, including the current balance and the date when they were last reconciled
To run the Company Data Auditor
1
Go to the Accounts command centre and click Company Data Auditor. The Company File Overview window appears.
Back up your company file
Click Backup and complete the backup procedure.
Check your company file for errors
Click Verify and complete the verification procedure.
Set the locked periods for your company file
Click Lock Periods and select the date before which data cannot be entered.
2
When you’ve completed your maintenance tasks, click Next. The Account Reconciliation Review window appears.
4
Click Next. The Transaction Review window appears.
6
Click Run Review to start the transaction review of the following:
Reconcile invoices with the linked receivables account
The total of all customer balances is compared to the current balance of the linked accounts receivable account.
If there is an out-of-balance amount, click Display to view the Receivables Reconciliation report and review, customise or print the details of the report.
Reconcile purchases with the linked payables account
The total of all supplier balances is compared to the current balance of the linked accounts payable account.
If there is an out-of-balance amount, click Display to view the Payables Reconciliation report and review, customise or print the details of the report.
Compare item values with the linked inventory account
The total value of inventory on‑hand is compared to the current balance of the linked inventory account.
If there is an out-of-balance amount, click Display to view the Inventory Value Reconciliation 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 of the current session (that is, the current date).
If there are transactions dated after the current session, 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.
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.
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 transaction, GST, accounts 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.
7
When you have finished viewing and, if necessary, printing the Transaction Review reports, click Next. The GST Exception Review window appears.
9
Click Run Review to do the following:
Check for GST amount variances [Sales]
The company file is checked for variances between the GST amount posted and the GST amount calculated for the GST codes assigned to sales transactions. If a variance is found, click Display to view the GST Amount Variance report and review, customise or print the details of the report.
Check for GST amount variances [Purchases]
The company file is checked for variances between the GST amount posted and the GST amount calculated for the GST codes assigned to purchase transactions. If a variance is found, click Display to view the GST Amount Variance report and review, customise or print the details of the report.
Check for GST exceptions [Invoice Transactions]
The company file is checked for sale and purchases transactions without a GST code assigned or where the entered GST code is different to the default GST code. If such a transaction is found, click Display to view the GST Code Exceptions Invoice Transactions report and analyse the details of the report.
Check for GST exceptions [Cash Transactions]
The company file is checked for Spend Money and Receive Money transactions without a GST code assigned or where the entered GST code is different to the default GST code. If such a transaction is found, click Display to view the GST Code Exceptions Cash Transactions report and analyse the details of the report.
Reconcile GST code details with linked accounts
The company file is checked for variances between the balance of the linked GST accounts and the amount of GST that has been collected and paid on transactions. If variances are found, click Display to view the GST Information Reconciliation Detail 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.

Click to show more information

Top of page