Skip to main content

The Nominal Audit Trail Report

Track every transaction with ease using the Nominal Audit Trail Report

Written by Serena Santamaria
Updated over 2 weeks ago

Table of Contents


Introduction

Every transaction in your nominal ledger matters, but how do you keep track of them all? The Nominal Audit Trail Report is your go-to tool! It tracks every transaction posted to your nominal ledger, giving you a detailed timeline of credits, debits, and adjustments. Whether you’re reconciling accounts, investigating discrepancies, or preparing for an audit, this report ensures nothing slips through the cracks.


The Report

To run the report:

  1. Go to Nominal > Reporting > Audit Trail Report.

    • You can also go to Nominal > Audit Trail > Reports button > Audit Trail

  2. The Nominal Audit Trail Report page will open.

  3. In the Report Options:

    • Select a date range (Date from, Date to)

    • Tick:

      • Show Control Accounts: to display control accounts (e.g. Accounts Receivable or Payable) together with detailed transactions, so you can easily check that totals match the nominal ledger.

      • Z Entries Only: to show only transactions without VAT

    • Set up your sorting order using the Sort Order 1, Sort Order 2 dropdowns (sort by values).

    • Select Ascending or Descending in the Order direction dropdowns.

⚠️ Important: what you see in the report grid and when you run a report is highly influenced by user permissions and any active system record filters.

The Result


PDF

Columns

  • Tran. ID

  • Date

  • Tran. Ref.

  • Ext Ref

  • Account: Code, Name

  • Partner

  • Detail

  • D/C

  • Ledger

  • VAT

  • Amount (base currency)

  • VAT Amount (base currency)

  • Created On

  • Created By

Excel

Columns

  • CompanyCode

  • TransactionId

  • TransactionItemNo

  • TransactionType

  • Book (ledger)

  • BookSymbol (ledger symbol, e.g. N, P, S)

  • TransactionDate

  • TransactionReference

  • TransactionReferenceExtra1

  • NominalAccountCode

  • NominalAccountName

  • CurrencyCode

  • TransactionParticipantDescription

  • ItemDetail

  • DebitCredit

  • DebitCreditSymbol

  • VatCode

  • Amount

  • VatAmount

  • CreatedOn

  • CreatedBy


Related Articles

Did this answer your question?