Exchequer Software Plug-ins

Typical use of PostTrans Importer with Exchequer Accounting Software:

---

PostTrans works within MS Excel you have the power of Excel to manipulate and add extra functionality to data importation. Thus many of our users use PostTrans to:

Remote Entry

Gathering Timesheets, Sales/Purchase Orders from remote users, then import into Exchequer Accounting Software.  more information on Importing Transactions

Buy from the cheapest supplier

Use PostTrans to select the cheapest supplier, from the data held within Exchequer's Enterprises alternate code database and discount matrix, to save you money.  more information on Ordering from Cheapest Supplier

Bulk Transaction Entry

Collate multiple Transactions on one spreadsheet to post into Exchequer Accounting Software. Such as monthly rent, etc.   This is covered towards the end of our second training video

Setting up initial system

Great for setting up systems. As PostTrans imports data, it checks the length of any fields and warns if they are over the length in Exchequer Accounting Software. We offer a "PostTrans Start-up" license, which allows use for 65 days.  See posttrans prices

Importing Transactions from legacy systems

Simply read text files from legacy systems into spreadsheet. Optionally manipulate data, in Excel, before importing either manually, using functions such as VLookup, using macros or VB Code. Such as adding Exchequer Cost Centre/Department analysis code

Maintain Stock Bill of materials

Bill of materials for stock items can easily be Exported/Amended/Imported by simply specifying the parent code, subcomponent stock code and the quantity.  more information on Import/Amend Bill of Materials

Maintain Customer/Supplier Discount Matrix

Complex discount matrix, for customer and supply records, can be Exported/Amended/Imported into Exchequer Accounting Software very easily.   more information on Import/Amend Customer/Supplier Discount Matrix

Update Posted/Daybook transaction lines

Used for importing updated costs, even though transactions have been posted in Exchequer Accounting Software. 
more information on Amend Posted/Daybook Transactions

Quickly perform a Exchequer stock take every morning from spreadsheet

This feature is used by a company who has multiple locations. Each morning, their distributors (setup as a location) submit a current stock levels in a structured text file. This text is read into a spreadsheet, and PostTrans amends the stock levels in Exchequer Accounting Software by simply posting a stock adjustment transaction. more information on Stock Take in Exchequer

If new stock codes are contained in the file, PostTrans can optionally automatically create new stock records with the details contained within the file.

PostTrans XL Visual Importer: Versions

---

Basic Version

Allows you to:

• Import/Export/Amend Customer/Suppliers
  
• Import/Export/Amend Stock
  
• Import/Export/Amend GL
  
• Import Transactions SQU,SIN,PIN,POR,SOR,ADJ, and TSH etc.
       with General/Date note lines and Links to external documents
• Bill of Materials
  
• Quickly perform a basic stock take from file every morning from spreadsheet
  
• Import Automatic Bank Reconciliation Records from Excel

Professional Version

Allows you to:

• Ability to use Lookup Tables for Customer/Supplier/Stock, etc. codes, for easy data entry
  
• Import/Export/Amend Customer/Supplier/Stock Discount Matrix
  
• Import/Export/Amend Customer/Supplier/Multi-Buy
  
• Import/Export/Amend Contacts & Roles
  
• Import/Export/Amend Alternate Stock Code Database
  
• Import/Export/Amend Job, Employees, Time Rates.
• Update user fields on transaction header/lines after being posted
  
• Edit Picked Qty and other Fields on Transaction Line
  
• Printing/Faxing/e-mail transactions after posting
  
• Stock Take Serial/Batch and Multi-bins
• Match payments from external system, such as e-commerce systems
• Back to Back Order
  
• Include Serial/Batch and Multi-bins on PIN,SIN,ADJ, etc.
• Live Lookup code Searching

 

Sign-Up for Newsletter

---

Sign up for our newsletter for the latest information on our products, offers and new Exchequer plug-ins.

Email Address: * required

Company Name:

First Name:

Last Name:

	Follow us on Facebook
	Follow us on Twitter for latest news.

Customer Comment:

---

“Our Pension contributions are prepared at external sites in Excel and we use PostTrans to import the contributions straight in to Exchequer Enterprise saving valuable time and effort." says Laurence Dobney of Caterpillar Pensions Trust Ltd.