Excel-powered Exchequer integration

PostTrans XL Visual Importer for Exchequer

Import, export, validate and amend Exchequer data from the familiar environment of Microsoft Excel.

Download the demonstration View prices

Uses and benefits

A flexible way to work with Exchequer data

PostTrans XL works inside Microsoft Excel, giving you Excel's familiar data tools alongside specialist Exchequer import, export and validation functionality.

Teams use PostTrans in many different ways: from one-off data preparation to repeatable operational processes. We also provide PostTrans importers for Sage 50, Sage 200 and Xero.

Easier to use than traditional CSV importers

Includes example templates to help you get started

Highlights Exchequer coding errors before import

Use Excel formulas, macros and VBA to prepare data

Review transactions before they are imported

Amend stock, customer, discount and transaction data

Support remote entry of orders, timesheets and expenses

Save time, reduce rekeying and improve accuracy

PostTrans Training School

A free 25-minute course shows you how to build PostTrans templates, using the included examples as your starting point.

Start training

Practical applications

Typical uses of PostTrans with Exchequer

Build a repeatable spreadsheet process around the way your organisation already works.

Remote data entry

Gather timesheets, sales orders or purchase orders from remote users and import them into Exchequer.

Import transactions →

Buy from the cheapest supplier

Use alternate stock codes and discount matrix data to identify the best supplier for an order.

See the workflow →

Bulk transaction entry

Collate recurring or high-volume transactions in one spreadsheet before posting them to Exchequer.

Watch the training →

Set up a new system

Validate field lengths and import opening data with the 65-day PostTrans Start-up licence.

View Start-up pricing →

Import from legacy systems

Read legacy text files into Excel, transform the data with formulas or VBA, then import the prepared records.

Maintain bills of materials

Export, amend and import parent items, component stock codes and quantities.

Bill of materials →

Maintain discount matrices

Export, amend and import complex customer, supplier and stock discount information.

Discount matrices →

Update posted transactions

Update costs and user fields on transaction headers or lines after they have been posted.

Update transaction lines →

Run multi-location stock takes

Load stock levels from structured files, post adjustments and optionally create new stock records.

Stock take options →

Choose your version

Basic and Professional functionality

Start with the everyday import tools in Basic, or add advanced lookup, editing and automation options with Professional.

Core tools

Basic Version

Import, export and amend customers and suppliers
Import, export and amend stock records
Import, export and amend general ledger data
Import SQU, SIN, PIN, POR, SOR, ADJ and TSH transactions
Add general or date note lines and links to external documents
Import and amend bills of materials
Perform a basic stock take from a spreadsheet or file
Import automatic bank reconciliation records

Advanced tools

Professional Version

Use lookup tables for customer, supplier and stock codes
Import, export and amend discount matrices and multi-buy data
Maintain contacts and roles and alternate stock codes
Maintain jobs, employees and time rates
Update user fields and edit picked quantities after posting
Print or email transactions after posting
Handle serial, batch and multi-bin stock takes and transactions
Match payments from external systems
Create back-to-back orders and use live code searching

Customer comment

“Our pension contributions are prepared at external sites in Excel, and we use PostTrans to import the contributions directly into Exchequer Enterprise, saving valuable time and effort.”

Laurence Dobney, Caterpillar Pensions Trust Ltd.

Have a specific import in mind?

Talk it through with an experienced Exchequer specialist.

Book an expert