Sage 50 Sales Orders, Journals Import from Excel
Menu

Sage 50

Sage 50

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

Image Alt TextImage Alt Text

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

Image Alt Text

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…

Image Alt TextImage Alt Text

Manufacturing

200 Manufact.

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

Image Alt Text

Complex tasks quicker...

50 BOM

Project Accounting

200 Projects

Create Project Structure
Update Budgets
Simple Project Entry

Make life easier...

Image Alt Text50 Projects

PostTrans for Sage 50 Features

PostTrans for Sage 50 is an extremely powerful Excel Extract/Import tool.  By using its power, you can reduce the amount of time needed to enter Quotes, Invoices, Orders, Stock/Products, Prices, etc manually or from a CSV file. With the exceptional Power of PostTrans, you can deliver cost effective solutions for your business and obtain a quick return on your investment by using Excel formulas, VLookups, Data Queries, Marcos or VBA to build on the exceptional Power of PostTrans. Below are comments from customers.

 

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

  

 

 

Transaction Importation

 
 
 
 

Extract, Amend or Import Static Data

 
 
 

Unattended/Automatic Sage 50 Import

The PostTrans XML API for Sage 50 provides an easy-to-understand XML interface for the Sage 50 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 50 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 50 unattended import

Import

Import file from FTP/email to Sage 50.

Import Customer

Import Supplier

Import Stock Item

Project

Invoices,Quotes,Credits,Sales

Orders and Purchase Orders

Journals

Product Movement

Export

Export file automatically, to FTP to server.

Customer/Supplier List

Product List

Audit Tranactions

Orders

Invoices and Credits

Orders and Purchase Orders

Sundry Items, such as Tax rates, Currency, etc

 
 
 

PostTrans for Sage 50 Features

  • Full Evaluation

    PostTrans can be easily evaluated with Sage 50 Demonstration data for free. Download for Sage 50

  • 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.

  • Online Training

    For Sage 50 we have a series of comprehensive PostTrans Training Videos for Sage 50

  • 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 50 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