Follow these steps to set up a Nominal Accounts update template:
Select the Access Tab
Select Templates, Setup Update Template
Ensure your data connection shows the correct name
Select New Template
Select Next
Select Nominal Ledger, Nominal Accounts
Select Next
Begin laying out your columns, ensuring that you include the Account Code and Major Heading fields (these are required in order to write back).
Remember that for the first column you will need to set a range in the Excel Spreadsheet
Continue adding the fields until your have all that you need
Select Next
Set any filters that you require, ensuring you use the Add button to add these to the template
Select Next
Tick the box for Enable changes to be written back to Access accounts and set relevant colours (note that as a default a field with blue text indicates that the information can be written back to the accounts, while black text indicates information that cannot be updated with AOI
Tick the Save Template box and give the template a name
Select Insert
The spreadsheet will now be populated with your Nominal records. You can then review the information and change any year end codes that you need to, before using the Update button to write the information back to the accounts.