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 for all future cashbook imports.
Timing
This process is done daily
Access
- Cashbook | Edit/View Electronic Transactions |Edit/View Electronic Transaction Browse |
Dialog Details
Details Specific Fields
Some of the fields will be pre-filled when the dialog is accessed from the Electronic Transaction Browse
Field | Explanation |
Bank | Pre-filled from the Bank account selected in the Electronic Transaction browse Must not be changed |
| Expiry Date | A date which indicates when the Once the expiry date has been passed the |
Tran Type | Pre-filled Must not be changed |
Reference | Pre-filled Do not change unless a wildcard is required This is the usually the text in the ‘Reference’ field of a bank statement |
| Description (1) | Pre-filled Do not change unless a wildcard is required This is usually the text in the ‘Particulars’ field of a bank statement |
Description (2) | Pre-filled Do not change unless a wildcard is required This is usually the text in the ‘Code’ field of a bank statement |
Amount | Pre-filled Do not change A wildcard may be used with caution |
Transaction Type | [F2] to present the Transaction Type Browse The browse will be restricted to Cashbook Input transactions |
Module | Available once the Transaction Type is selected [F2] or key the account code, account internal number or GL Code |
Company | This field is only required for General Ledger transactions [F2] to select from the Company Browse |
Tax Code | This field populates after the selection of the Transaction Type based on the Tax Code set up on that record |
Description to Use | This will be the description that is shown on the account once the transaction is posted If left empty the text in the ‘Description1’ field will be used |
Additional Analysis | This is only required if the amount is to be divided between different Accounts or Transaction Types |
Note: Reference, Description (1) and Description (2) mapping to bank statement fields should be verified against your own bank statement
Related Articles
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 ...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 ...Transfer Non Cash
Purpose Allows an amount to be transferred from one account to another The most common uses of the functionality are: Transferring funds for accounts in different modules. Eg. Transfer of a Call Savings balance to a Term Deposit Refinanced Loans: ...Bailment Dealer Details - Accounts Tab - Cash Allocation
Purpose When a payment is received from a Bailment Dealer it will be entered in the Cashbook. Payments received must always be posted to the Suspense Account of the Bailment Dealer (unless it is a Curtailment payment). The payment will be available ...Day End Processing Checklist
Insurer Menu Explanation Check Post Insurance due to Insurer The posting date will default to today’s date This process will post insurance set up on loan accounts created since the last time this process was run creating a liability to the insurer ...