Up to nine formulas can be entered. Each formula has several parameters.
•The name of the formula, to be printed in the chart.
•The formula itself. This can be a range of general ledger accounts, like 4000,7999.
| The formula can contain operators like + - / * () E.g.: -(8000,8999)+(5000,5999)/3200 |
•The years to be calculated range from 1 to 5 years, counting back from the year of the opened bookkeeping.
•The range of periods can start with 0 to include the opening balance.
•If the Incremental checkbox is ticked then the periodical totals will be incremented
After choosing the button Update Financial the data is extracted from Mill7 and Excel will open using the Financial template to show the data.
Graphs based on the data sheets are presented in the first nine tabs.
