Sage 200

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

Xero

Import from Excel

50 Trans

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

200 Trans

Transaction from Manual Input

Multiple Transactions from CSV file

Xero

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

Xero

Great Customer Satisfaction

Customer Comments

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

Simply extract, edit and import

Power of Excel

Sage 50

Quick Template Creation
Customise with:
    Formula
    Macros
    VBA

Sage 200

To reach your goals quickly

Sage 200

Sage 200 Bins

Sage 200 Warehouse & Bins

Create Sage 200 Bins
Stock Take Bins
Move Bin Stock

Fast, cost effective, easy…

Manufacturing

200 Manufact.

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

Complex tasks quicker...

50 BOM

Project Accounting

200 Projects

Create Project Structure
Update Budgets
Simple Project Entry

Make life easier...

50 Projects

PostTrans for Sage 200 Features

Sage 200 PostTrans is an extremely powerful Excel extraction and import tool. Using its power, you can reduce the time taken to enter Quotes, Invoices, Orders, Stock/Products, Prices, etc, manually or from CSV files. Using Excel formulas, VLookups, Data Queries, Marcos or VBA, you can use PostTrans' exceptional power to deliver cost-effective solutions to your business while achieving a quick return on your investment. See Customer Comments below.

Download PostTrans for Sage 200 and MS Excel for PC
Works 100%, not time limited, with Sage 200 demo companies.

Transaction Importation

Transactional Importation

New transactions can be posted, these include:
Features

This can include Printing and emailing, Ledger drill down and Postcode Address Lookup plus posting into Multiple Companies in the PRO version of the software.
Common Uses
Ideal for

Importing transactions from file, sending out order requests to customers, reducing retyping of data.

Extract, Amend or Import Static Data

Extract, Amend or Import Static Data

PostTrans for Sage 200 will allow the user Extract/Edit/Import:
Common Uses
Ideal for

Setting up system, general house keeping, price management for both customers and suppliers, creating new products and editing bill of materials and other time saving routines.

Data Flow

Sage 200 Accounts Software			PostTrans Excel Spreadsheet
Chart of Accounts			Extract/Import Chart of Accounts

Customer			Extract/Import Customers
Supplier			Extract/Import Suppliers
Customers Prices			Extract/Import Customers Prices
Supplier Prices			Extract/Import Supplier Prices

Stock Items			Extract/Import Stock Items
Stock Alternatives			Extract/Import Stock Alternatives
Stock Bins			Extract/Import Stock Bin's and Levels
BOM			Extract/Import BOM
Stock Levels			Extract/Import Stock Levels
Stock Adjust			Import Stock Adjustment
Stock Search Analysis			Extract/Import Stock Search Analysis Codes

Project			Extract/Import Project and Structure
Project Costing			Import Project Cost Adjustment & O/B
Expenses			Import Project Cost Adjustment & O/B

Invoices/Credits			Import Quotes, Invoices and Credits
Sales/Purchase Orders			Import Sales/Purchase Orders

Journals			Import Journals
Cashbook			Import Cashbook Payment/Receipt

Outstanding Invoices			Allocate Payments to Outstanding Invoices
Receipts			Allocate Payments to Outstanding Invoices

Invoice/Orders			Extract/Edit and Copy Invoice/Order
New Invoice/Order			Extract/Edit and Copy Invoice/Order

= Sales with Payments
= Post to Multiple Companies from one Spreadsheet

Unattended/Automatic Sage 200 Import

The PostTrans XML API for Sage 200 provides an easy-to-understand XML interface for the Sage 200 API, built on the PostTrans engine. It gives an XML interface to try and tested PostTrans for Excel. It is a standalone program that automatically imports customer and transaction data into Sage 200 or with a button. Each transaction is submitted in a single XML file to a designated folder, SFTP site, or an IMAPI e-mail account (in the body of a plain text e-mail or as multiple attachments).

More info on PostTrans XML API for sage 200 unattended import

Import

Import file from FTP/email to Sage 200.

Import Customer

Invoices/Credits with payments

Orders and Purchase Orders with payments

Journals

Stock Movement

Payment Allocation

PostTrans for Sage 200 Features

Full Evaluation

PostTrans can be easily evaluated with Sage 200 Demonstration data for free. Download for Sage 200
Online Training

For Sage 200 we have a series of comprehensive PostTrans Training Videos for Sage 200
In-Cell Searching

Look up associated Xero values such as Products, Customers, Nominal Accounts codes with in cells for easy data entry.
Data Entry

Data entry can be manual entry, utilising In-Cell Searching, for quick Order entry. Or by file import and using Excel formula, macro or VBA code to manipulate or enhance data entry.
Easy Licensing

Simple licensing, pay per month, per user. Basic and Pro version. Subscription can be cancelled in online account. Price for PostTrans for Sage 200 Price.
Any other questons?

Contact us with question

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

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

Sage 200

Save time updating

Import from Excel

Solve the Puzzle?

Great Customer Satisfaction

Power of Excel

Sage 200 Bins

Manufacturing

Project Accounting

PostTrans for Sage 200 Features

Transaction Importation

Transactional Importation

Features

Common Uses

Ideal for

Extract, Amend or Import Static Data

Extract, Amend or Import Static Data

Common Uses

Ideal for

Data Flow

Unattended/Automatic Sage 200 Import

Import

PostTrans for Sage 200 Features

Full Evaluation

Online Training

In-Cell Searching

Data Entry

Easy Licensing

Any other questons?

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

Customer Comments