Sage 50 Audit Trail Report

The Sage 50 Audit Trail summary documents the changes and transactions in the accounting data. It helps users validate uploaded journals, check voided entries, and support audit reviews. This helps to boost internal controls.

In this guide, you will find a complete explanation of the Sage 50 Audit Trail Report. The following section includes the steps to open, filter, and print/export the Audit Trail report. Perform the steps shared below to access the report for compliance during yearly audits.

What is the Sage 50 Audit Trail?

The Audit Trail summary includes uploaded entries and accounting operations in date order. The report comprises the following:

• Document types
• References
• Net amounts
• Transaction numbers
• Dates
• Accounts
• Usernames
• Tax amounts
• Timestamps

The Sage 50 Audit Trail Report assists users in validating invoices, reversal adjustments, dates, supplier credits, etc. In addition, it helps to verify account codes and user activity. Furthermore, it aids regular accounting processes, monthly financial checks, and external reviews.

Note: Sage 50 versions access separate report fields and names. UK users use audit details via the Transaction area and related reports. US users access the Audit Report and General Ledger reports.

How to Open the Sage 50 Audit Trail Report?

Sage 50 Accounts offers multiple Audit Trail reports for monitoring transaction records. Users can choose a report, select the needed parameters, and review the outcome.

Follow these steps to access the Sage 50 Audit Trail Summary:

• Click the “Transactions” tab.
• Choose the “Audit Trail Reports” option.
• Choose the needed report from the following:
  • Detailed- Includes entries with appropriate invoices and payments.
  • Brief- Includes entries in condensed audit history.
  • Revaluations- Includes foreign currency valuation adjustment entries. This specific report is accessible in Sage 50 Accounts Professional.
  • Summary- Includes all entries in the audit trail.
  • Deleted Transactions- Includes all erased entries summarized in the audit trail.
  • Opayo- Includes audit trail entries for receipts from Opayo.
• Click the “Preview” button.
• Finish the criteria requirements. The criteria options help to shorten the report by date and other filters. This helps to emphasize the Sage 50 Audit Trail entries needed for accounting, checks, and audits.
• Click the “OK” tab to open the report.

How to Filter the Sage 50 Audit Trail?

The Sage 50 Audit Trail summary includes accounting updates, business activity, and transaction issues. Users can access the filter option to select the report by date and check the activity for a certain period.

Follow the steps shared below to filter the Audit Trail:

• In the “Reports and Forms” menu, choose the “Company” option.
• The “Select a Report or Form” screen appears in Sage 50.
• Choose the “Audit Trail” option.
• To check the report, click the “Preview” option.
• Alternatively, click the “Print” tab to print it.
• Click the “OK” tab to show or print the Audit Trail Report.

How to Print or Export the Audit Trail?

The Audit Trail report in Sage offers Summary and Detailed views. Users can select transactions and send the report as a PDF or CSV file for evaluation or documentation. For information related to user actions, the Sage 50 user activity report helps to monitor user activity. However, it differs from the Audit Trail.

Follow these steps to print or export the Audit Trail:

1. Generate the Audit Trail Report

• Navigate to the “Reports” option.
• Choose the “Audit Trail” tab.
• Choose the needed time period.
• Add the “To” and “From” dates when needed.
• Click the “Calculate” option after modifying any filter.
• Choose the “Detailed” or “Summary” option.
  • Detailed- Displays debits and credits and ledger accounts.
  • Summary- Displays transaction amount summary

2. Sort Transactions by Type

• Choose the “More” option.
• Access the “Transaction Type” list.
• Choose the needed transaction type.
• Click the “Calculate” option.

3. Remove Deleted Entries

Deleted entries are displayed in the Audit Trail with a line through them. Follow the steps to remove deleted transactions:

• Click the “More” option.
• Navigate to the “Status” list.
• Choose the “Deleted Only” option or the “Exclude Deleted Transactions” option.
• Click the “Calculate” option.

4. Upload the Audit Trail Report

• Start the Audit Trail Report with the needed filters.
• Choose the “Export” option.
• Select the “CSV” or “PDF” tab.
• Access the uploaded report from the notification displayed on the top bar.

How to Find Changes Made by a Specific User?

The Sage 50 Audit Trail report helps to detect entries and bookkeeping activities for a certain user. Follow these steps to locate changes made by a specific user:

• Sign in as an admin or an approved user.
• Log in to the Sage 50 company.
• Navigate to the “Reports” option.
• Now, select the “Audit Trail Report” or the “Audit Trail” option.
• Choose the date range for the period.
• Sort the report by “User”.
• Check the user, time, date, and impacted transaction.
• Print or export the report when a permanent record is required.

Conclusion

The Sage 50 Audit Trail report includes the accounting tasks and aids with transaction changes. In this guide, complete information on the Audit Trail has been shared.

Still, if there are additional queries or doubts, feel free to reach out to our Sage professionals.

Frequently Asked Questions