Postcode Programming API  PostTrans XL Visual Importer: Import Excheuqer Payments and Match Reconcile


This is only available in the Professional version of PostTrans

This PostTrans spreadsheet allows the user to easily Import Sales receipts, and match off the original invoice in , using either Enterprise Transaction Ref or unique external reference posted in YourRef or AltRef.

Uses:

  • Bulk import of cheques for payments
  • Import of Credit card payments from external system

  Demonstration Video:


            Show me a demonstration video

The "Match Payments.xls" Example shows this in action. more information on PostTrans examples


Import Excheuqer Payments and Match Reconcile Features:


Importing new Bank Reconciliation data

Simply specify the reference to Match by and the amount: 

Import Payments

To Import Payments, the following Tags/Fields must be specified:

PaymentPosted

Cell A1 must equal

The Default GL code, and "Match By" field should be set in System setup.

Restrictions

SIN and SRC must be same Value.  Part allocations are not supported.   

PostTrans will import a matching SRC, but the difference must be resolved


Excheuqer Payment fields available for update:


The following Tags are used to identify the corresponding fields in Exchequer Enterprise.  Use the [Design] button (or Ctrl+Shift+D), on the PostTrans Toolbar, to access these tags. 

Tag Name

Data Type Length

Description

Required:

 

 

PaymentPosted

Yes/No

Returns 'POSTED' if Trans line has been posted and will be ignored if 'POSTED' (required)

ErrorDesc

Text

Description of error posted back if record unsuccessfully posted

THPayMatch

Text

"Match By" field should be set in System setup.

TLPaymentRef

Text

Payment Ref to put on SRC

TLChequeNo  Text Cheque No to put on SRC (Appears in Description in Banks Rec)

TLAmount

Double

Amount to settle

Optional:

 

THTransDate

Payment record Transaction Date

THYourRef

Your Ref on new Payment record

THAltRef

 

 Alt Ref on new Payment record

THCurrency

0-89,1=Sterling

TLUser1-4

Transaction Line User1-4

TLCostCentre

 

 

TLDepartment

THPayDetails1-5

Pay Details line 1-5

Post Back:

PBSINOurRef

Write back SIN ref found

PBVariance

Difference in SIN and Payment if any

PBAccountCode

 

Write back SIN Account found

PBTransDate

Write back SIN Transaction date found

PBDueDate

Write back SIN Due Date found

PBSRCOurRef

SRC ref created