Accountants love Microsoft Excel, and many use this tool every day to format, plan, and manipulate information for a wide variety of business uses. Greentree’s Financial Reporting Engine in Excel, or FREE, allows you to use these skills to easily create dynamic financial reports, that reflect the current state of your business.

Key Benefits

Live Links to Greentree

In order to maintain a competitive edge, you need direct access to key information that can be formatted, reviewed, and acted on using tools most appropriate to the task. Historically, a big problem with using Excel for this has been obtaining timely and easy access to the financial information contained in your accounting system. Traditionally, this information has to be printed from the accounting system and manually re-entered, or perhaps stored as a text file and imported into Excel for further formatting and manipulation.

Greentree’s FREE provides just what it’s name implies, freedom to develop the reports that you really need, with live links to the information within Greentree. It’s the modern way to present financial information. FREE has been designed to allow users to effortlessly use Microsoft Excel to analyse and report on information easily and at the same time ensure the appropriate security is provided to protect sensitive information. As the links to Greentree are “live” you only need to set up each reporting spreadsheet once then enter the period and year to report each month and Greentree takes care of the rest. In addition, pivot table reports may be easily generated within Excel, using the information available from within Greentree.

Harness the Reporting Power of Trees

FREE allows you to report on General Ledger accounts specifically or grouped by tree branch, from within your many user defined trees. This allows you to analyse the same information from many different dimensions, even down to transactional analysis level.

Flexible Budgeting Tools

In addition to financial results, Greentree budgets may also be presented within Excel and used in reports. Once in Excel, all the modelling capabilities of Excel come into play, allowing budgets to be developed and then automatically updated back to Greentree.

Not Just Reporting - Updating Too

FREE offers a wide range of updating capabilities for Greentree Masterfiles as well as posting transactions. These capabilities are of great value if you need to load data from or integrate with legacy systems that are not able to communicate with Greentree directly, or if you have complex cost allocations or other information that needs to be tracked from within Excel, and saves operator time and the potential for human error. Naturally all data entered into Greentree from FREE can then be further updated within Greentree.

The FREE update functions available include: