Analysis codes within Access Financials are used to control where the transactions are posted to within the Nominal Ledger. The type of the Analysis code will also indicate where in the application that this Analysis code can be used.
When creating analysis codes, create one for each currency you use. This ensures currency transactions are posted to the correct currency accounts.
Create an analysis code on the sales ledger
Click Debtors, Settings, then click Analysis.
Click New.
Select the Type of Analysis Code (either Sales, Bank, Discount or Stock).
Enter the Code and Description.
Make any required changes to Currency, VAT Code, Sort Key and Default Cost Centre where applicable.
📌 Note: Check the Currency. By default the Currency is set to your Default Home Currency of the Database. If required, to use a different Currency, either type a valid currency code or click the Magnifying Glass icon and select a different currency from the trading currencies list.
📌 Note: When an Analysis Record is being edited/inserted, if the Nominal Code has a different currency to that of the Analysis Record a message will display warning you that transactions posted using this code will not update the currency balance or turnover for that Nominal Code with the different currency.
Amend the Nominal Update Accounts depending on the double entry for the Nominal Ledger required.
Click Save.
Create an analysis code on the purchase ledger
Click Creditors, Settings, then click Analysis.
Click New.
Select the Type of Analysis Code (either Purchase, Bank, Discount or Stock).
Enter the Code and Description.
Make any required changes to Currency, VAT Code, Sort Key and Cost Centre where applicable.
📌 Note: Check the Currency. By default the Currency is set to your Default Home Currency of the Database. If required, to use a different Currency, either type a valid currency code or click the Magnifying Glass icon and select a different currency from the trading currencies list.
📌 Note: When an Analysis Record is being edited/inserted, if the Nominal Code has a different currency to that of the Analysis Record a message will display warning you that transactions posted using this code will not update the currency balance or turnover for that Nominal Code with the different currency.
Select the Compulsory Costing and CIS Taxable options where applicable.
Amend the Nominal Update Accounts depending on the double entry for the Nominal Ledger required.
Click Save.
Create an analysis code from the nominal account record
Click Financials, then click Accounts.
Find the nominal account to be used in the Analysis and highlight it.
Click the Analysis button in the ribbon and select the records to create.
The options provided are based on the Major Heading and Account Type, so a Sales account will offer Sales Analysis, a Bank account Bank Analysis, a Balance Sheet account Sales and Purchase Analysis.
Select OK.
The records will now be created using the code, and system defaults for control accounts.
If Sub Ledgers are in use, the Sub Ledger in the new Analysis may need amending to match the selected Nominal account.
Create an analysis code from the Chart of Accounts
Click Financials, then click Chart of Accounts.
Expand the Chart until you reach the detail account for which the analysis is to be created.
Click Detail in the top of the Chart list.
Select Create Analysis and follow the steps as above.