Initially developed in-house for internal use to help our consultants with data conversions and setting up new Sage ERP Accpac sites, these MS Excel “smartsheets” have been carefully designed and developed over the years with more functionality without compromising simplicity.

We found a huge demand for these templates amongst all of our clients due to the familiarity and flexibility of Microsoft Excel and the simplicity of getting data into and out of Sage ERP Accpac quickly.

All integration with Sage ERP Accpac is done via the Sage ERP Accpac Software Development Kit – ensuring user level access security and data integrity.

Our suite of Sage ERP Accpac Excel Smartsheets Available:

Accounts Payable
A/P Invoice Entry
A/P Invoice Entry with Project and Job Costing
A/P Invoice Register
A/P Invoice Register with Project and Job Costing
A/P Miscellaneous Payment Entry
A/P Vendors Update

Accounts Receivable
A/R Customers Update
A/R Interest Charges
A/R Item Invoice Entry
A/R Receipt Entry
A/R Summary Invoice
A/R Summary Invoice with Project and Job Costing

Bank Services
B/K Bank Entry

General Ledger
G/L Account Creation
G/L Budget Import
G/L Journal – Multiple Entry
G/L Journal – Single Entry

Inventory Control
I/C Contract Pricing
I/C Kitting Items
I/C Vendor Details

Sales Order
O/E Sales Order Entry

Project and Job Costing
PJC Contract Creation
PJC Equipment Usage

Purchase Order
P/O Purchase Order Entry
P/O Purchase Order Entry with Project and Job Costing