Ledger Analysis reads the general ledger you uploaded and suggests a classification rule for each group of transactions it recognises. You decide which suggestions become rules.
Upload your general ledger first. See Upload your general ledger.
Run a ledger analysis
In your assessment, select Ledger Analysis.
Under Countries, choose the countries the analysis covers.
Choose the factor set to apply.
Run the analysis.
Avarni reads the transactions in those countries and suggests a classification rule for each group it recognises. You then accept, edit or ignore each suggestion.
Why one analysis cannot cover every country
Each analysis applies one factor set. A factor set is regional, so a single analysis cannot apply Australian factors to Australian spend and United States factors to United States spend.
If your general ledger covers more than one country, run one analysis for each factor set you need, in the same assessment. The analysis reads only the rows in the countries you chose, and it suggests rules only for those rows.
Each row takes its country from the country column in your ledger file. If there is no country column, every row takes one country. See Upload your general ledger.
Can I accept several suggested rules at once?
No. You accept suggested rules one at a time. You can ignore several suggestions at once.
To review the suggestions from one analysis:
Go to Ledger Analysis.
Select View next to a completed analysis.
Select Review next to a suggestion.
To see the transactions that the rule would classify, select View in the review panel.
Select Accept or Ignore.
To ignore several suggestions, select their checkboxes. Then select Ignore in the toolbar.
You can also accept suggestions on the ledger itself. Go to General Ledger, select Preview run and choose an analysis. Each row shows the suggestion that would classify it. Select the accept icon on a row, then select Accept rule.
To undo a decision, open the suggestion and select Revert to Pending.
What do I do with suggestions that overlap or would match no transactions?
The Would match column shows how many transactions a suggestion would classify that no existing rule classifies. When you accept a suggestion, the Would match count of each overlapping suggestion goes down.
A suggestion with a Would match of 0 adds nothing. A higher-priority rule already classifies all its transactions. Ignore it.
To hide these suggestions, select Filters. Choose Would match, choose > and enter 0.
When several suggestions cover the same spend, keep one. Accept the suggestion that covers the most spend with the correct factor. If it is too narrow, select the edit icon and widen its conditions before you accept it. Then ignore the others.
How do I get fewer, more accurate suggestions?
The analysis groups your transactions by the fields you choose under Fields to include. You can choose up to 10 fields. Under Order of importance, drag the fields into order. The analysis uses the top field first. It uses the next field where the top field is empty or unclear.
A suggestion can use an unusual word from the description as a keyword. The Justification column tells you why the analysis chose each condition. If the word is not a reliable signal, edit the suggestion or ignore it.
To get fewer and better suggestions:
Choose fewer fields. Choose fields that describe what was bought, such as Account Name, Supplier or Description.
Do not choose two fields where one is a subset of the other. For example, choose only the more detailed of two category levels.
Run analyses in layers. First run an analysis on Supplier, and accept the rules for suppliers that sell one kind of product. Then run a second analysis on Description or Account Name.
For account-level suggestions, run an analysis without Description.
Start with the suggestions that have the highest Would match spend.
To reuse the settings of an earlier analysis, select the replay icon next to it.
Can I give the analysis context about my business and suppliers?
Yes. When you create an analysis, use Business context (optional). Describe your business, your main cost categories and your key suppliers. You can enter up to 8,000 characters.
You can also attach up to 5 files of up to 10 MB each. You can attach CSV, Excel, TSV, PDF, Markdown and image files. You cannot attach Word files.
A list of your suppliers and the products each one sells helps the analysis choose the correct factor for supplier rules.
Business context guides the suggestions. It does not add transactions. To add procurement data, upload it as a ledger file. See Upload your general ledger.
Does a new analysis read every transaction again?
No. A new analysis reads only the transactions that no rule classifies yet. It reads only included accounts, and only rows in the countries you choose.
This means:
You do not need to delete data to analyse the transactions that are left. Run a new analysis.
When you upload more data, your accepted rules apply to it. Run a new analysis to get suggestions for the transactions that your rules do not classify.
An analysis that you ran before does not make new suggestions for new data.
You cannot limit an analysis to one uploaded file.
Why did my analysis return no suggestions?
Open the analysis to see the reason.
Nothing left to suggest: the analysis found no unclassified transactions to suggest rules for.
This analysis did not cover your whole ledger: part of the ledger could not be analysed. Run the analysis again.
This analysis did not finish: the analysis stopped with an error. Start a new analysis.
If you see Nothing left to suggest but you expect unclassified transactions, check these points:
The countries in the analysis match the country of your rows. A row with no country takes the default country.
The rows belong to included accounts.
The fields you chose contain values in your file. The analysis skips a row when all the fields you chose are empty.
What happens next
Go to General Ledger to review the classified transactions. Rules you accept apply to every matching transaction in the assessment. To change or reorder rules, see Build classification rules and set their order.
Before you rely on the numbers, check that the ledger is complete against your trial balances. See Check your general ledger is complete against your trial balances.