Create Cashbook Cross References
Purpose
Create a record that will result in the automatic matching of repeating transactions processed through the bank account. Examples will be automatic payments, recurring charges.
Timing
Whenever required following a bank statement 
Access
- Cashbook | Edit/View Electronic Transactions |
|
| Edit/View Electronic Transactions |
Process
Single Transaction Cross Reference
Used when the amount is to be allocated to a single account or General Ledger Code
Check the prepopulated details, and amend if required
Wildcards may be used
Multiple Transaction Cross Reference
It is possible that a single transaction on the bank account may need to be allocated over a number of different accounts. This can be achieved by setting up 'Additional Analysis' lines on the dialog.
When Additional Analysis lines are used, the analysis transaction becomes the balancing transaction becomes the balancing transaction, so it is exceptionally important that the different amounts are carefully entered.
E.g. A customer deposits a monthly automatic payment of $226.45 which is made up of a loan instalment ($106.23) and a lease payment ($120.22).
The would be set up as below:
Note: The Lease Instalment has no amount allocated, this means that the balance of the automatic payment ($226.45 - $106.23 = $120.22) will be applied to this account.
Wildcards
Wildcards can be used in the bank detail fields to match transactions where details change on each transaction
The below screen shot shows the values each field considers a wildcard:
E.g. A customer has an automatic payment for a loan instalment. The Description (Particulars) always reads 'Loan 123' but an incremental count of the instalment number is used by the customer in the Reference field. The code field is blank.
The below cross reference would be setup in order to apply the to these instalment payments:
It is strongly recommended that at least two of the fields have a defined value, as it is possible to make the so broad that all bank transactions could be considered a valid match and be incorrectly processed.
Wildcard Amount
If the Reference and Description fields always have the same information but the Amount changes, then enter 0.00 as the amount wildcard. As long as the other details don't change the transaction will always match correctly.
Note: Once a has been set up for the first time and has been selected into the Electronic Transaction Browse 
must be clicked to match the transaction.
Related Articles
Cashbook Cross Reference Details
Purpose Cross references are a tool used to automatically match repeating transactions processed through the bank account. Examples will be automatic payments, recurring charges. Creating a will result in the transaction being automatically matched ...Electronic Cross Reference Browse
Purpose To provide a list of all Electronic X References that match the specified search criteria Access Cashbook | Edit/View Electronic X References Cashbook | Edit/View Electronic Transactions | Search Criteria Browse Specific Search Criteria Field ...Importing Cashbook Bank Transactions
Purpose To import Statement Transaction amounts into Vault so they can be processed through the cashbook Processing will convert the Statement Transaction Amount to a Statement Transaction Batch. Timing These processes should be undertaken daily for ...Match: Cashbook Statement Browse
Purpose This function is used for the matching of a Statement Transaction Amount to an existing Statement Transaction Batch created in Vault. If a Statement Transaction Batch does not exist, a new batch may be created. Timing Whenever required ...Cashbook Statement Browse
Purpose To provide a list of all Cashbook Statement Transaction Batches that have been entered to Vault To provide the ability to track where Cashbook Transactions have posted to To process Statement Transaction Batches Access Cashbook | Edit/View ...