Menu
Home ›Sage 50 ›Sage 50 Import Data

POSTTRANS FOR SAGE 50

Your data in Excel.
Ready for Sage 50.

Import transactions, update records and keep control of your data.
Work in the spreadsheet you know, connected to Sage 50.

Download PostTrans for Sage 50 Explore your import options

Microsoft Excel on Windows · Try with Sage 50 demonstration data

WHAT WOULD YOU LIKE TO IMPORT?

Two ways to get more done.

A FAMILIAR WORKFLOW

Prepare. Import.

  1. 01

    Prepare in Excel

    Enter data manually, copy and paste it or import a CSV file. Use Excel formulas, data queries, macros or VBA to prepare it for Sage 50.

    Import from a CSV file ↗
  2. 02

    Import into Sage 50

    Post your prepared records from your spreadsheet and reuse your templates for the next import. The PRO version also supports posting to multiple companies.

PostTrans Excel template for importing Sage 50 transactions
Prepare single or multiple transactions.
PostTrans Excel template for extracting and updating Sage 50 static data
Extract, amend and import your records.

SEE IT IN ACTION

A quicker way to take an order.

See how an Excel order pad works with PostTrans to take an order and post it into Sage 50.

Watch on YouTube ↗

Read the full order pad guide ↗

Automate your imports.

Need unattended imports? The separate PostTrans XML API brings customer and transaction data into Sage 50 from XML files.

Explore the XML API for Sage 50 ↗

CUSTOMER EXPERIENCES

How businesses use PostTrans.

Experiences from customers using PostTrans across its accounting integrations.

Customised Order Entry - We have used PostTrans as our primary data-entry system for over 5 years. It is reliable and fast; allowing our team to process orders through our own customised Excel interface straight into Sage, I developed with additional functionality not available within our core accounts system.

Alex - Krome Ltd

Price Updates - We use PostTrans to update our price matrix in Excel. We simply extract the existing customer special price data, amend using excel formula, and post back into our Sage system, saving many hours, and reducing mistakes.

Toni - Tri Star Packaging

Sales Order Pad with Back to Back Purchase Order - We have a whole order entry system written using the power of Excel and PostTrans. We simple pop the customer details in an order pad, then take credit card payment, and then press a button to import a sales order for our services, followed by a purchase order to a specific supplier, very quickly.

Ben - AMA Waste Management

Monthly Payments - We use PostTrans to post our monthly Pension Payments, to those on our Pension scheme. It makes life so easy, simply managing all payments in one spread sheet, then every month simply posting the payments into our accounts system for processing, as purchase invoices against suppliers.

Laurence - Caterpillar Pensions

Management of Bill Of Materials - We use PostTrans to manage our complex bill of materials in Excel and push changes to Sage. Being able to extract, amend and then re-import into our accounts system, saves us load of time.

John - PHL Manufacturing

Initial System Setup - PostTrans was invaluable when first setting up our accounts system. It was far easier to use than traditional CSV importers, as it warns of any data which is being truncated, and removes hidden characters, and highlights errors as it imports. They can quickly be edit and the process can carry on from where it left off… Top Marks…

Tim - Salvesens

⌃