How do I check for potential audit issues?
Description

Run the Accounts audit

  1. Click Transactions then click Accounts audit.
  2. Select the check box for each query you want to run, then click OK.
  3. Enter the required date range then click OK.

Accounts audit checks available

Identify possible duplicate transactions

To find possible duplicate transactions, select this check box. Transactions appear if all of the following are the same:


  • Transaction Type
  • Details
  • Account
  • Nominal
  • Date
  • Reference
  • Net
  • Tax

Identify Invoices not updated and/or printed within 14 days

To list invoices and credits that have not been printed within 14 days of the invoice / credit date, select this check box. Sage Accounts counts back 14 days from the current program date. Any invoices dated prior to this that have not been printed or updated, appear in the Accounts audit window.


Identify Sales and Purchase Payments on Account not using non-vatable Tax Code

To list payments on account that do not use the default non-vatable tax code, select this check box.

TIP: You can check the current Non-Vatable Tax Code in Settings, Company Preferences on the VAT tab.

Any sales receipts on account (SA) or purchase payments on account (PA) that do not use this tax code appear in the Accounts audit window


Identify Sales and Purchase Transactions not using Standard Rated Tax Code

To list sales or purchase invoices or credits that do not use the standard rated tax code, select this check box and from the Tax Code drop-down list, choose the standard rated tax code.

Sage Accounts checks the tax code on the following transaction types:

  • Sales Invoice (SI)
  • Sales Credit (SC)
  • Purchase Invoice (PI)
  • Purchase Credit (PC)

Any of these transactions that do not use this tax code appear in the Accounts audit window.


Identify EC Sales Transactions posted to Customer Accounts with no VAT Registration Number

To list EC transactions where the relevant customer does not have a VAT Registration Number, select this check box. Sage Accounts checks the EC Code check box on each tax code to determine which are EC codes. Any customer transactions posted using an EC tax code, where the VAT Registration Number in the Customer Record is blank, appear in the Accounts audit window.


Identify EC Purchase transactions posted to Supplier Accounts with no VAT Registration Number

To list EC transactions where the relevant supplier does not have a VAT Registration Number, select this check box. Sage Accounts checks the EC Code check box on each tax code to determine which are EC codes. Any supplier transactions posted using an EC tax code, where the VAT Registration Number in the Supplier Record is blank, appear in the Accounts audit window window.


Identify Purchase Orders which have been delivered but not invoiced

To list the purchase orders that have been delivered but not updated, select this check box. This includes purchase orders that are not fully updated. For example, if five items have been delivered but only four have been invoiced.

NOTE: Sage 50 Accounts has a range of audit tools available to help you check your accounts are correct. Read more >