for Sage 50 or 200

Want to simply import data from Excel into Sage?

Tired of retypeing data?

Our product works within Microsoft Excel to quickly import data into Sage 50 or 200. Indeed, it even extracts Sage data into a spreadsheet, the user can then edit the data, and push changes back into Sage. Both for Sage 50 and Sage 200.

In addition to Sage 50/200 Orders, Invoices, Inter-company Transactions, Sales Receipts, Nominal Journals and Stock Adjustments. This functionality can save valuable user time, enabling them to make bulk changes to data very easily within Excel, and update Sage 200 or 50, Stock Prices, BOM’s, Customer Lists and Projects, etc.

Sage 50 information Sage 200 information

Sage Security and Validation

The program is easily installed within MS Excel, in minutes. In the case of Sage 200, it then uses the Sage 200, user’s connection, and abides by the Sage 200 user’s security rights. Thus the user can only access, and update Sage 200 data, from within Excel, that the user is allowed.

In Sage 50 the software uses the Sage 50 user security settings.

The importer validates all data as it processes the data, highlighting an errors, allowing the user to simply correct the data in Excel, before reimporting the Sage data. Indeed any associated codes can easily be found using the in cell searching, which pops up in Excel to allow the user to select a sage code, such as nominal, customer code, etc.

Microsoft Excel Customistaion

Using the power of Excel, the import functionality can be easily enhanced using standard Excel formula, ODBC query, VLookups, Macros or VBA code to quickly implement solutions.

Prices from £29.95 + VAT per month