This can be done by setting up an AOI template for Nominal Accounts (the Nominal Accounts template is provided by default with AOI). Note that we recommend taking a backup before using AOI to update information, especially if you are unfamiliar with the use of AOI.
You can set this up using the following process in Microsoft Excel
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.