Guide to Ledger Reports – Configuration and Standard Templates

Ledger reports in Navigator can be customised to suit your business needs, allowing you to create detailed financial reports. This guide explains how to configure custom ledger reports, modify existing ones, and use standard templates such as the Extended Trial Balance (TB).

Configuration

1. Access Ledger Report Setup

• Go to:
  Accounts > Nominal Ledger > Utilities > Setup > Ledger Reports.

2. Create or Modify Reports

• Create a New Report:

  • Click the "+" button to add a new report.
  • Enter a name for the report and click OK.
  • Add the required columns to the report.

• Amend an Existing Report:

  • Select a report from the list.
  • The current configuration for that report will populate in the setup window.

3. Add or Modify Columns

• Add a New Column:

  • Click Add to insert a new column.
  • Configure the column settings:
    1. Select the Column: Choose the data field you want to display.
    2. Field Positioning: Decide where the column will appear in the report.
    3. Column Width: Set the width of the column (default is 25).
  • Click OK to save the column.

• Edit Existing Columns:

  • Highlight the column you want to amend and adjust its settings.

Standard Templates

Extended Trial Balance

The Extended Trial Balance template provides a detailed breakdown of nominal ledger data. It includes the following columns:

1. Detailed Nominal Code: Displays the complete nominal code.
2. Location (Description): The location associated with the nominal entry.
3. Department (Description): Department details for the entry.
4. Nominal Type (Description): The type of nominal entry (e.g., Sale, Cost of Sale).
5. Nominal Description: Provides a brief description of the nominal code.
6. Analysis Description: A detailed description of the analysis field.
7. Year to Date Value (YTD Value): Cumulative value for the year.
8. YTD Quantity (YTD QTY): Cumulative quantity for the year.
9. Current Month Value: Value for the current accounting period.
10. Current Month Quantity (Current Month QTY): Quantity for the current accounting period.

Key Notes

• Customisation: Reports can be tailored to include only the columns relevant to your analysis.
• Default Column Width: Adjust column widths as necessary for better readability.
• Pre-Built Reports: Use the provided templates as a starting point for customisation.

Scenarios Where This Process is Useful

• Creating detailed financial reports for management review.
• Customising reports to match specific audit or analysis requirements.
• Streamlining reporting processes by using standard templates like the Extended Trial Balance.