Menu

Save time updating

Sage 50

Stock/Product Creation
Customer/Supplier Prices
Bill of Material
Project Creation
Location Bins

Sage 200

Simply extract, edit and import

Import from Excel

50 Transactions

Nominal Journals
Quotes/Invoices/Orders
Remote Orders
Stock Adjustments
Sales Receipts
Quick OrderPad

200 Transactions

Single Transaction from Manual Input

Multiple Transactions - CSV file, or data source

Solve the Puzzle?

Sage 50

Help on every type of import
Demo Video of all functionality
Loads of Examples included
Online Training
We can help too…

Sage 200

Great Customer Satisfaction

Customer Comments

Full Trial with Demo Data
Low cost Subscription
Cancel anytime
From a £1 a day
Saving you hours

Power of Excel

Sage 50

Quick Template Creation
Customise with:
    Formula
    Macros
    VBA

Sage 200

To reach your goals quickly

Sage 200 Bins

Sage 200 Warehouse & Bins

Sage 200 Bins
Stock Take Bins
Move Stock between Bins

Fast, cost effective, easy to use…

Manufacturing

Sage 200 Manufacturing

Create BOM Stock Easily
Create Bill of Materials
Labour, Machine, Tools

Complex tasks quicker...

Sage 50 BOM's

Project Accounting

Sage 200 Project Accounting

Create Project Structure
Update Budgets
Simple Project Entry

Make life easier...

Sage 50 Projects
 

PostTrans for Sage and Excel

PostTrans for Sage 50/200 is an extremely powerful Excel Extract/Import utility to save time and money.  Using its power you can reduce the time taken entering Quotes, Invoice, Orders to create quick and easy to OrderPads (demo below).   PostTrans also helps maintain Stock/Products, Bill of Materials, Prices, Projects etc through manual input, CSV file, or bulk data edits easily by extracting the data from Sage 50/200, edit and import back into Sage 50/200 using the power of PostTrans.   

Use the power of Excel using Excel formula, VLookups, Data Queries, Marcos or VBA to build on the exceptional power of PostTrans to delivery cost effective solutions for your business to quickly recoup on your investment.  see customer comments.

 Sage Transaction Import

Sage 50: customised  sales/purchase order/invoice entry, product adjustmentnominal journalspurchase order with authorisation, inter-company transactionssales receiptsexpenses and quick order pads

Common Sage/Excel 50 Transactional Uses

 

Sage 200: sales/purchase order/invoice entry, stock adjustmentnominal journalspurchase order with authorisationsales receipts, inter-company transactions, expenses and quick order pads

Full quick order entry templates can be easily created utilising Printing and emailingLedger drill down and Postcode Address Lookup plus posting into Multiple Companies.

"In-cell code searching " helps the user lookup associated values, such as accounts codes, stock/product codes when entering data.  Many values are automatically filled in if not specified, using the Sage business logic you would expect.

Common Sage 200 and Excel Transactional Uses

 

Automatic Customer and Transactional data using PostTrans XML API for Sage 200 our un-attended XML importer

Extract, Amend or Import Sage Static Data

Sage 50: AssetCustomer / SuppliersProductsBOM's and Manunfacturing, Product CategoryPricesAlternative Stock CodesStock Analysis Search ValuesDepartmentsNominal Budgets, Projects, Nominals, Currency etc.

Common Sage 50 and Excel Uses

 

Sage 200: AssetCustomer / SuppliersStockWarehouse Bins (including Stock Take)BOM's and ManufacturingAlternate Stock CodesStock Analysis Search ValuesPrice MatrixPrice Price BandsSupplier PricesLocationsNominal AccountsProjects Structure inc Title, Budgets etc.

During import, new or amended data, PostTrans will report back any errors in the data, including text fields which are too long, allowing corrections to be made from within Excel, before re-imported into Sage 50/200.

Common Sage 200 and Excel Uses

 

 Resources

Examples: Many Excel examples are included for Sage 50 or Sage 200 with links to blog articles and videos which explain the functionality

Full Product Demo: PostTrans for Sage 50 Full Demo and PostTrans for Sage 200 Full Demo at the comfort of your desk.

Online Training: Two 30 minutes on-line training videos explain the basics of Excel to Sage template design, and numerous blog articles explain specific areas.

Trial: PostTrans can be easily evaluated with Sage Demonstration data.  Download for Sage 50 or Sage 200

Prices: Prices for Sage 50 and Prices for Sage 200

Any other questions?   Contact us with question or pickup the phone and dial 01945 464854.

Want to be a Reseller? or promote the software and get commission.   Sign up as a reseller

 

If its that good, show me... Quick Order Pad

 

 
 
   1/2 Quick Sales Order Pad using PostTrans in 30 seconds
  0:00 Video Introduction
  1:10 Taking an order in 30 seconds
  2:08 Rewind for a slower explanation of process
  4:00 Adding another product to Order Pad
  6:50 Posting the Sales Order into Sage 50
  8:00 How to find more information and Training
View the full article on this
 
 
 
 
 

Easy To Customize

  • Full Evaluation

    Full product available for instant evaluation in demonstration company.  A subscription can be purchased using a credit card to instantly enable the software on a LIVE company.

  • Online Training

    Online training videos cover how to design your own data entry templates from the many examples included.  Online Training

  • Easy Licensing

    Simple licensing, pay per month, per user. Basic and Pro version.  Subscription can be canceled in online account.  Price for Sage 50, Sage 200.

  • Easy of use

    Simple to use, with many Excel/Sage examples included, help and on-line training to help you get up and running fast.

  • Cost effective

    Utilising the power of Excel - Use formula, macros, or VBA code to create stunning Order entry templates, telesales entry, or sheets to give customers to place Sage orders for submission.  Not just another import utility!

 
 
 

 

Customer Comments

Our customers say great things about PostTrans

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