Cashflow Administrator

The way to organise your consolidation process that just works

No more unreliable hot links between files!

Cashflow Administrator organises the systematic download and upload of data files, enabling you to set up a logical system of linking models together.

This is an Excel add-in designed for business planning and budgeting teams.It does not require, or depend on, Business Functions, although BF users will find the approach fits well with the way BF encourages you to work.

• System works using a special range-naming convention for you to identify cells and ranges that you want downloaded.
• The download facility ensures that each download is given a unique version number and downloaded to your download directory.
• The upload facility imports data from any number of files into the workbook. Each item of data is systematically named, ready for use.
• CashFlow Administrator's upload facility understands time. Time-specific cashflows, budget lines etc are linked to a timebase set in the download file.On upload the data is consolidated into the consolidating file's timebase.
• CF's Data Manager keeps track of who downloaded what, and who uploaded it.
• Comprehensive working example and help provided, plus our usual rapid support.
• Underlying method is simple and quite low-tech involving 3 key techniques:
  • Download based on a user-configurable convention of naming ranges. No hidden secrets.
  • Storage of data in plain editable text files in your download directory. You can even create CF date files from other programs such as MS Access.
  • Upload based on writing a simple script on a page within your workbook. Complete transparency of purpose.
• Purchase cost Price $119 USD $95 USD (20% Off Special!) ( + UK VAT if applicable)
• Similar to the methodology used inside leading UK property company.

Upgrade History

• Version 1.06 (June 2004): Maintenance Release.