HomeSage 50/Sage 100SAP Business OneMacola SoftwareExcel Addin for MacolaOther Macola ToolsCrystal ReportsExcel VBA - Power QueryERP Software EvaluationAbout UsContact Us

Excel Add-in for Macola

We have developed an Excel add-in for Macola and Exact Globe.  The add-in works with all versions of excel from 2010 thru Excel 365.  The add-in is modular and consists of the following functionality, please add 20% for Annual Maintenance:

• MRP Data - Maintain all the fields in the Item Master and Item Location that affect Macola MRP quickly and easily directly from Excel - $2,000

• Excel to GL - NOW AVAILABLE FOR MACOLA ES and MACOLA 10 and EXACT GLOBE - Load your journal entries directly from Excel to your Macola ES/Macola 10 General Ledger - $1,500 

• Excel to GL for Macola Progression -
Load your journal entries directly from Excel to your Progression General Ledger  -  $1,500

Visit our YouTube Channel for videos of the Gain Focus Excel Add-in Action:


• Forecast Maintenance - Do your Sales Forecast modeling in Excel and when you are done, upload it into Macola's Master Scheduling or MRP modules with one menu click - $1,800

• AP Voucher Upload From Excel - Creates unposted AP vouchers, Updates PO Line info with Receiver, Quantity and Dollars invoiced, All from a simple Excel sheet.  Also now working with Landed Costs and Tax Schedules - $2,000

• Budget Builder - Do your budget modeling in Excel and when you are done, it into Macola's Budget table with one menu click.    NOW AVAILABLE FOR MACOLA ES and MACOLA 10 and EXACT GLOBE    $1,500 

• Cost Updater - Updates the standard cost of purchased items in Macola Progression, Macola ES, or Macola 10 from a simple, easy to use excel spreadsheet.     Optionally updates the Cost Masters in the Std Costing Module.  If you are using Progression, It even makes the journal entries needed for the changed inventory value $1,500

• 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!    Comes with complete data validation in line all Macola business logic (example: the quantity per of a serialized component must be a whole number). 

If you can get it into our excel template, we'll take it from there.    Cost - 


 Bom Builder Plus - All of the features of BOM Builder above, but the parent and component item numbers will be created if they do not already exist.   $2,500

• 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, Macola ES, or Macola 10.  Makes all related journal entries, writes to the inventory transaction history table, etc.  It is a snap to cycle count or take a full inventory with this tool.     $1,800


• Inventory Adjustments - Very similar to above, but mimics the effect of an Inventory Quantity Adjustment in Macola rather than using Inventory Tags.   Updates the quantity on hand, will not allow serial/lot or binned items to go negative, writes to the inventory transaction history table, etc.     $1,800

Note that the 
Inventory Adjustments tool only makes journal entries in Macola Progression.

Inventory Adjustments and Quick Inventory will, like Macola, require you to perform a Serial Qty Adjustment if you adjust the quantity of a serialized item.

• AP Check Reconciliation - Loads your cleared checks in Excel format directly to your Macola or Globe Bank Reconciliation Tables.    NOW AVAILABLE FOR Macola ES, Macola 10 or Exact Globe    $1,500 
• Inventory Transfers - Automatically transfers item from Excel using from and to locations.  Makes all journal entries (in the case of different standard costs between locations), updates the average cost and records the transactions in Inventory Transaction History as well - $1,800
Note that the Inventory Transfer tool only makes journal entries in Macola Progression.

• Update/Create Item Vendor Contracts.  Writing to the Macola POITMVND_SQL Table, this tool can optionally update open POs with the new vendor prices as well - $2,000
• GL Account Creation - Progression Only - Creates GL Accounts from Excel, very easy and straightforward process - $1,500 
• Bin Master Creation - Creates Bin Master records and marks the item as a binned item if it is not already flagged as a binned item - $2,000

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.

All Gain Focus excel add-in modules work with Macola Progression, Macola ES and Macola 10, except where noted.   We also offer these for Exact Globe where noted.

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

You don't see what you are looking for?  We can create it for you, to your specifications.