Common questions and errors with nominal integration
Description

We’ve compiled a list of the common questions and errors around setting up nominal integration or when you try and create your nominal file.

Cause
Resolution

Common reasons why the nominal report may be blank

  • You may not have processed End of Period (EOP).
    • End the period, and process the nominal once again.
  • If the nominal report is being ran over two nominal periods - this is not allowed.
    • You can check your nominal periods in your calendar.
    • To run the report for a previous period, you should revert your payroll using period archives to the final pay period in the nominal period and run the nominal report.
  • The nominal report is being ran for periods where the nominal integration was not setup. The nominal report will not work for these periods. 
  • The Nominal Code Format in Nominal > Set up is blank.
    • For more information about this section, please refer to our setup guide.
    • Note: for Sage 50/Instant Accounts, this field must read: aaaadddccc.
  • If there are empty rows on the nominal report, it indicates that the From period used to create the file is from a period before the nominal feature was set up. Use a shorter period range to correct this.

Common reasons why the nominal report may be incorrect

  • Changes were made to the nominal setup after processing End of Period (EOP). These changes will not be reflected in the nominal report until the next pay period.
    • If you need them to be reflected in the current period, you must rewind your payroll and make the necessary changes before doing End of Period again. 

The report shows incorrect information for the period range

  • Monthly or quarterly: The to/from fields may have been changed so the report generates several nominal periods information. This isn't possible, you can only generate a report for a single nominal period at any time. If you need a previous nominal periods information, you need to revert to the relevant period archive.
  • Weekly or fortnightly: The to/from range may have been amended to include pay periods that aren't within the same nominal period. Sage Payroll generates a nominal report for a single nominal period. Check your calendar settings to see which pay periods are included within the nominal period you need to report on.

Unable to import the file into Accounts

  • If a journal on the nominal export file does not have a nominal code, the import will fail. You should ensure all payments and deductions have a nominal codes entered. 
  • The nominal export file does not contain a file type.
    • For Sage 50/Instant Accounts the file extension must be .CSV. For example: Nominal.csv

Unable to save the file

  • If a nominal export file cannot be saved to a location, create a new folder on your C:\ drive and save the nominal export file to this location. Alternatively, save the file to your Desktop.

'Error in record X' errors

Depending on the rest of the error message, please refer to the following help guides:

  • ‘Error in record X: Nominal A/C Ref: Reference to non-existent Nominal Ledger account’ - Read more > 
  • ‘Error in record X: Account Reference: Illegal Nominal Ledger Account Reference’ - Read more > 
  • ‘Error in record X: Contributes to an unbalanced journal for date’ - Read more > 
  • ‘Error in record X: Date: Bad Value for Date’ - Read more > 

‘Nominal A/C Ref: Bank or Control account nominal code not permitted’

For more information on this error, please refer to this help guide. Read more > 

Steps to duplicate
Related Solutions