Excel Add-in

Gain Focus Technologies

Excel Addin

Excel Add-in for Macola

We have developed an Excel add-in for Macola, which works for both Progression and ES (except where noted). The add-in works with all versions of excel from 2000 thru the most current version. The add-in is modular and consists of the following functionality:

• Excel to GL - Load your journal entries directly from Excel to your Progression or ES General Ledger. Does not work with Macola ES $600

• Forecast Maintenance - Do your Sales Forecast modeling in Excel and when you are done, upload it into Macola's Master Schedule with one menu click. $900

• Budget Builder - Do your budget modeling in Excel and when you are done, upload it into Macola's Budget table with one menu click. Does not work with Macola ES $600

• Cost Updater - Updates the standard cost of purchased items in Macola Progression or Macola ES, from a simple, easy to use excel spreadsheet. Makes all related journal entries too. $800

• Bom Builder - Export and Import your Bills of Material to and from Macola. A great way to query your CAD system and get your BOMs out of your CAD system and into Macola! If you can get it into excel, we'll take it from there. $1200

• Quick Inventory - Downloads your inventory tags to Excel for easy updating. Writes back the count qty and when posted, updates your quantity on hand in Macola Progression or Macola ES, makes all related jounal entries, writes to the inventory transaction history table, etc. It is a snap to cycle count or take a full inventory with this tool. $1000

• Customer Builder - Similar in design and approach to BOM Builder, but you are importing customers. Does not work with Macola ES. $800

• Vendor Builder - Similar in design and approach to BOM Builder, but you are importing vendors. Does not work with Macola ES. $800

• Item Builder - Similar in design and approach to BOM Builder, but you are importing Items. Automatically creates the default item location record as well, with costs and prices. $1200

• AP Check Reconciliation - Loads your cleared checks in Excel format directly to your Progression CHECKREC or Bank Book Open File. Does not work with Macola ES $800

All these features come with full data validations - you cannot import an item with an invalid product category, for example. All of these functions have been thoroughly tested using Macola's file validation reports.

The cost is modular, as seen above. Add 15% annual maintenance.

All Gain Focus excel add-in modules work with both Macola Progression and Macola ES, except where noted. We support SQL databases only, so please upgrade to SQL if you would like to use the Excel Add-in.

Please give us a call or an email for a free web demo of any of the Gain Focus Excel add-in modules.