Running General Ledger And Transaction Audits - Easily Identify Discrepancies and Errors

Running General Ledger and Transaction Audits Overview

Following is a comprehensive guide that outlines the steps to perform audits on the general ledger and transactions within SapphireOne. This procedure ensures the accuracy and integrity of financial data by identifying any discrepancies or errors. By following the provided instructions, users can easily run GL audits and Tran audits, generate CSV files with audit results, and forward them to SapphireOne Support for further analysis and assistance. These audits play a crucial role in maintaining the reliability and transparency of financial records, contributing to the overall efficiency and success of your organisation’s accounting processes.

Running General Ledger and Transaction Audits Procedure

How to run a GL Audit

To do this, go to: Utilities > Utilities > Custom Functions then select the Financials Tab.

  1. Select GL Audit. SapphireOne will prompt you with an alert asking if you want to run the audits on Accounts and/or Periods. You are not required to change anything here. All that is required is that you click on Select All and then OK.
  2. SapphireOne will the start your spreadsheet application and display the results as a CSV file.
  3. SapphireOne will ask you to enter a file name. Enter the file a name and save it to your desktop. 
  4. Finally, forward the files created via email to SapphireOne Support. 

How to run a Tran Audit

The Tran Audit will show up any discrepancies on transactions. For example if a transaction has a duplicated Audit line it will show up on the Tran audit. Most errors that appear on the Tran Audit will require you to contact SapphireOne support.

To do this, go to: Utilities > Utilities > Custom Functions then select the Financials Tab.

  1. Select the Tran Audit option. 
  2. SapphireOne will prompt you with an alert asking if you want to run the audits on Account and/or Periods. You are not required to change anything here all that is required is that you click on Select All and then OK.
  3. If there are any errors, SapphireOne will display an alert asking if it is to fix the errors automatically. Check with SapphireOne support staff if you see this alert.
  4. SapphireOne will the start your spreadsheet application and display the results as a CSV file.
  5. SapphireOne will ask you to enter a file name. Enter the file name and save it to your desktop. 
  6. Finally forward the files created via email to SapphireOne Support.

You can review our Blog and YouTube channel for additional information and resources on SapphireOne ERP, CRM and Business Accounting software.

Was this helpful?