Nominal Journals and Import Verification

The Import Nominal function in Navigator allows users to efficiently upload bulk manual journal entries using a CSV spreadsheet. This feature is ideal for finance teams and accountants looking to:

• Reduce repetitive manual data entry

• Ensure consistency in journal formatting

• Improve accuracy when processing large volumes of journal entries

Whether you're importing monthly accruals, reclassifications, or year-end adjustments, this function helps streamline the process while ensuring control and auditability.

Accessing the Import Nominal Function

To locate the import feature:

1. Go to the Accounts module.

2. Navigate to Nominal Ledger.

3. Select Post Journal.

4. Click on Import File.

This will open the interface where you can upload your prepared CSV file for processing.

Formatting Your CSV File

For the import to succeed, your CSV file must meet the following criteria:

✅ Column Headers

• The headers in your file must exactly match those required by Navigator.

• Ensure there are no extra spaces, spelling variations, or hidden characters.

✅ Nominal Codes

• Nominal codes must include the full company number, including the leading zero (e.g., 01).

✅ Other Considerations

• Debits and credits should be clearly defined and not left blank.

• Avoid using formulas or special characters in cells.

New Feature: Line-by-Line Error Checking

To help users quickly identify formatting or data issues, the system now verifies nominal codes during the import process. If an error is detected, the system will:

• Prevent the import from completing

• Display a clear error message showing which specific line in the CSV file contains the invalid code or issue

• 
  

This validation allows for faster troubleshooting and reduces the risk of incorrect postings, especially when dealing with large journals.

To see how to resolve this error see the following guide. How to Assign an Account Type to a Nominal Code