Excelerator Modules

Excelerator Overview

Analyzer

Journals, accruals and pre-payments created in Excel update the Sage database with full control and validation that follow the Sage business rules.

Excelerator for Sage 500/1000


Bill of Materials

Allows mass updates of specified BOM records. Create and amend BOM records.

Excelerator for Sage 500/1000


Budget Master

Upload budgets from your spreadsheets into Sage. Download Sage budgets and actual figures into your spreadsheet. Specify ranges or individual posting codes.

Excelerator for Sage 500/1000


Cash Book Payments

Save single or multiple cash book payments to Sage. Multiple cash book payments can be saved against numerous nominal codes.

Excelerator for Sage 200

Excelerator for Sage 500/1000


Cash Book Receipts

Save single or multiple cash book receipts to Sage. Multiple cash book receipts can be saved against numerous nominal codes.

Excelerator for Sage 200

Excelerator for Sage 500/1000


Creditors Management

View and update credit control information (dispute notes) directly from the spreadsheet. Retrospective feature lets you see the creditors position as it was on a previous date. Data format allows easy pivot table analysis by aged periods, region, credit-controller etc.

Excelerator for Sage 500/1000


Customers

Add and amend records for numerous customers with all field options available in Sage. This can be done from one spreadsheet rather than having to do it on an individual basis.

Excelerator for Sage 200

Excelerator for Sage 500/1000


Debtors Management

View and update debtor control information (dispute notes) directly from the spreadsheet. Retrospective feature lets you see the aged debtors position as it was on a previous date. Reverse date feature allows aged debtors to be used for cash flow forecasting.

Excelerator for Sage 500/1000


Invoicing

Supports the new Sage 200cloud financials module for invoicing. The Invoicing module allows users to update Sage from a single or multiple invoicing Excel template. Just like other Excelerator modules, you can generate new invoices or update existing Invoices. This module is ideal for reviewing invoices raised in an external (3rd party) system, before posting them to Sage. (Supports Project Accounting).

Excelerator for Sage 200


Nominal Ledger Journals

Post nominal journals of varying journal types with different posting options to Sage. Multiple journals can be saved to Sage with the flexibility of the browse option in Excelerator, allowing for nominal codes to be browsed and added easily.

Excelerator for Sage 200

Excelerator for Sage 500/1000


Nominal Ledger Posting Codes

Prevent creation of redundant posting codes. Descriptions can be auto-generated using a flexible algorithm or entered manually.

Excelerator for Sage 500/1000


Price List Manager

Upload and download SOP and POP price lists. Create new price lists and amend existing price lists.

Excelerator for Sage 500/1000


Project Master

Upload and download projects. Create and amend project records. Allow mass updates of specified project records e.g. description, alpha code etc.

Excelerator for Sage 500/1000


Purchase Ledger Invoice

Add single or multiple purchase invoices and save to Sage. Supplier invoices can be marked as settled immediately leading to the values for the invoice, discount, and VAT to be calculated automatically. Invoices can also be marked for having a settlement discount expected as well.

Excelerator for Sage 200

Excelerator for Sage 500/1000

Purchase Ledger Pay Allocation

Allocate single or multiple payments to suppliers. Also has the option to auto-allocate, which provides speed and flexibility.

Excelerator for Sage 200


Purchase Order

Raise single or multiple purchase orders. Purchase orders for numerous suppliers can be added at the same time. Excelerator also allows for purchase orders to be downloaded from Sage (which can allow the data to be amended or utilised as desired by the user).

Excelerator for Sage 200

Excelerator for Sage 500/1000

Sales Ledger Cash Allocations

Generates a sales cash batch in Sage. Auto-allocate feature allows quick allocation of cash to multiple invoices.

Excelerator for Sage 500/1000


Sales Ledger Invoice

Add single or multiple sales invoices and save to Sage. Invoices can be marked as being settled immediately and the values for invoice, discount and VAT calculated automatically.

Excelerator for Sage 200

Excelerator for Sage 500/1000

Sales Ledger Receipt Allocation

Allocate single or multiple receipts to customers. Also has the option of auto allocate, which provides speed and flexibility.

Excelerator for Sage 200


Sales Order Entry

Raise single or multiple sales orders. Sales orders for numerous suppliers can be added at the same time. This Excelerator also allows for sales orders to be downloaded from Sage, which can allow the data to be amended or utilised as desired by the user.

Excelerator for Sage 200

Sales Order Processing Services

Upload and download SOP services and browse service codes. Create new and amend existing services records and select services records based on a user defined selection criteria.

Excelerator for Sage 500/1000


Sales Quotation

The Excelerator provides greater flexibility with sales quotations. Multiple sales quotations for multiple customers can be raised and saved to Sage. There is also the option of downloading quotations from Sage.

Excelerator for Sage 200

Sales Returns

Allows users to update Sage from a single or multiple sales order return Excel template. Just like other Excelerator modules, you can create new or update existing sales returns. The sales returns module allows users to download existing returns to be updated, or download sales orders as a basis for generating new sales returns. (Supports Project Accounting)

Excelerator for Sage 200


Stock

Multiple stock items can be added to Sage with the stock Excelerator. This Excelerator allows for stock items to be downloaded from Sage to the template and multiple records amended at the same time.

Excelerator for Sage 200

Excelerator for Sage 500/1000

Stock Transfers

Allows for multiple stock items to be transferred between warehouse and bin locations.

Excelerator for Sage 200


Supplier Price List

Allows the user to enter and maintain supplier price lists. Multiple items can be added to the template to be saved to Sage at the same time.

Excelerator for Sage 200


Suppliers

Add and amend the record for numerous suppliers with greater flexibility and all of the field options available within Sage. This can all be done from one spreadsheet rather than having to do it on an individual basis. Excelerator allows for as many records to be created and amended as required.

Excelerator for Sage 200

Excelerator for Sage 500/1000


Suppliers Information

Upload and download SOP services and browse service codes. Create new and amend existing services records and select services records based on a user defined selection criteria.

Excelerator for Sage 500/1000

Validation and control

Flexibility with financial rigour.

With Sage 200 ERP Commercials you can manage every element of your supply chain, from quotations, price books and the delivery and receipt of goods to highly efficient stock management. Offering complete control, the system integrates fully into financial and trading modules and is highly configurable, so you can shape it to do business your way, day after day. Enabling you to respond fast and effectively to demands and with a tailored workspace putting everything important at a glance on your desktop, you can optimise customer loyalty and control the entire purchasing process. Whether your needs are relatively simple or really complex, this is a complete customer order and supply chain management solution for Sage 200 Accounts.

Excelerator Features

“Amazed at how easy it was to install and use. We achieved a time saving of ten days within the first month of implementation. Excelerator is a ‘must have’ for any organisation using Sage.”

— Keith Brown, Head of Technical Services, YHA

Over the internet

Excel to Sage from anywhere.

If your organisation requires it, Excelerator can be internet based. This feature gives users the capability to seamlessly save data to Sage from Excel while working anywhere in the world.

Excel

Harnessing familiarity.

Most of us use Excel without even thinking about it, which is precisely the point. It’s familiar, intuitive and supremely flexible: perfectly designed for autocomplete, calculations, formulas, highlighting fields, graphs and numerous other data entry tasks. Excelerator allows you to harness this familiar versatility to edit Sage accounts data without compromising Excel functionality in any way. You can edit and create new sales invoices, purchase orders, stock items and much more, using the elegant simplicity and user friendliness that is simply second nature.

Sage

Maintaining core strengths.

Sage accounts provides control, validation and financial rigour. It ensures that numerical calculations add up, that data has financial integrity and is correct, and that all data is contained within the right tables. Excelerator maintains all these benefits intact when you enter data into Sage from Excel and then goes further. Instead of logging errors in a file, Excelerator provides instant on screen error notifications, so you know straight away which Excel rows have caused the anomaly. This real time responsiveness saves time and increases accuracy. Excelerator is also 100% compliant with the accounting standards that Sage holds. The best way to appreciate this mutually beneficial process is to see it for real, so please book a webinar today.

Security

The seamless connection.

By using Excelerator, the powerful Microsoft Excel add-in created by Codis, Sage 200 ERP can integrate seamlessly with Excel. Data can easily be moved to and from Excel and Sage; fully controlled and validated at the click of a mouse.

Spreadsheet designer

A template for efficiency.

Excelerator includes the user-friendly Spreadsheet Designer. This elegant, powerful function allows you to take literally any spreadsheet and convert it effortlessly into an Excelerator Template. Now you can design spreadsheets as forms that are sent to and from customers. Where a third party application has been used, an Excelerator Template can be dropped as an overlay onto the spreadsheet, allowing data to be saved directly into Sage without the need for any custom software development. To see the Designer in action, book a webinar now.

“Codis has cut our Month end reporting time from seven days to five within the first month of implementation.”

— Brian May, Finance Director, Bunzl

Popularity

5000 licences and counting.

With thousands of licences issued across the world, Excelerator is trusted by small businesses to multinational corporations. From hospitality to pharmaceuticals and logistics, organisations from all manner of industries rely on Excelerator on a daily basis, often saving tens of thousands of lines to Sage at a time.

Centralised licensing

Simplicity, clarity and control.

With licences in one centralised location, you can control who uses which modules and avoid the process of licensing numerous different machines every year, because our ‘per-user’ approach means one licence for each person, covering their laptop, PC and other devices*. To explore it in more detail, simply book a webinar.

Audit Trail

Saving history in detail.

With Excelerator there is an integrated platform that maintains a detailed history of ‘saves’ from Excel to Sage*. This is a centralised control panel accessed via web browser that provides a clear audit trail, pinpointing who made saves, what data was involved and when the actions occurred. This time saving feature can also be used when importing from other files into Sage.

Audit Trail

Saving history in detail.

With Excelerator there is an integrated platform that maintains a detailed history of ‘saves’ from Excel to Sage*. This is a centralised control panel accessed via web browser that provides a clear audit trail, pinpointing who made saves, what data was involved and when the actions occurred. This time saving feature can also be used when importing from other files into Sage.

Contact us now!

*Available with Excelerator Enterprise Edition.

Excelerator Modules

See a complete list of Excelerator modules here.

Excelerator Downloads

Before you download

Here you can download Excelerator and find out for yourself why more than 4000 licences have been sold across the world. For installation instructions please see the the "Install, License & Configure" section of the Excelerator online help.

To explore seamless integration in your own time with a free 7 day demo licence, contact us.

Excelerator Enterprise Edition

If you have Excelerator Enterprise Edition, you only need to download and install the Enterprise Client below. This is just one of  the many benefits of Excelerator Enterprise Edition. To learn more, contact us.

Download Enterprise client

Sage 200 Excelerators

New users: To trial the software download, unzip and install. For a free demo licence of any of these modules, contact us.

Existing users : To upgrade your software, first uninstall your current version of Excelerator, then download, unzip and install the new setups.

Download Sage 200c 2020 R1 / 200c Spring 2019 Enhancements Onwards

Download Sage 200c Winter 2018 Enhancements

Download Sage 200 2016 / 200c Summer 2018 Enhancements or Earlier

Download Sage 200 2015

Download Sage 200 2013

Download Sage 200 2011 or Earlier

Download Sage 200 Extra Online SDBX Only

Sage 1000 Excelerators

Download Excelerator v3.1 (latest) - Sage 1000 and Sage 500

Excelerators available in this single installer v3.1 :-

  • Nominal Ledger Journals

  • Cash Book Receipts

  • Cash Book Payments

  • Sale Ledger Invoices

  • Purchase Ledger Invoices

  • Cost Of Sale Codes

  • Exchange Rates

  • Stock

  • Customers

  • Suppliers

  • Purchase Order Receipts

  • Aged Debtors

  • Aged Creditors

  • Account Codes

  • Cost Centres

  • Posting Codes

  • Price List

For a free demo, contact us.

Download Excelerator v1 - Sage 1000 and Sage 500

Central DB Config Setup