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 2007 thru Excel 365. The add-in
is modular and consists of the following functionality:
• Excel to GL - NOW AVAILABLE FOR
MACOLA ES and MACOLA 10 amd EXACT GLOBE - Load your journal entries directly from
Excel to your Macola ES/Macola 10 General Ledger - $1,200
Excel to GL for Macola Progression - Load
your journal entries directly from Excel to your Progression General Ledger - $1,000
Visit our YouTube
Channel for videos of the Gain Focus Excel Add-in Action:
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,200
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 - $1,500
• 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 amd EXACT GLOBE
• 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.
• 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.
• NEW! 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,000
• 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.
• AP Check Reconciliation - Loads your cleared checks in Excel format directly to your Macola or Globe Bank Reconciliation Tables.
NOW AVAILABLR FOR Macola ES, Macola 10 or Exact Globe $1,000
Time Upload - Interfaced with your time system/time clock. Can save you HOURS of work each week - $1,500 estimate
(can vary due each time system being a little different)
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 both Macola Progression,
Macola ES and Macola 10, 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.
Don't see what you are looking for? We can create it for you, to