How to change the number of Financial Years extracted into ExcelReportLink

ExcelReportLink can report up to 10 financial years into the past and future but is configured to 3 years by default for performance reasons. The years returns is relative to the current financial year in your accounting sofware

How to change the number of financial years available in BudgetLink

File:YearOptions.png

Year options in the Options dialogue

To change the number of financial years you can report on, follow these steps.

1. From the BudgetLink main menu, click on 30. Settings;
2. Click on Options;
3. Click on the Set User Options button;
4. From the options dialogue, select the Years item in the left-hand list;
5. Change the Number of Prior Years to get data to the desired value;
6. Change the Number of Future Years to get data to the desired value;
7. Click on the Save button;
8. Click on the Close button;
9. Run a Get Data.