...
- If a line has been reconciled the Reconcile box will be ticked and the matching journal or batch details will be shown
- Lines in the bank statement may reconcile with individual journals or with the total of a journal batch
- The journal or batch can be opened from a right click on the line
- Likely matches are listed beside the bank statement line details
How are matches made
| Matches are assessed in this sequence | Pre-requisites | Test | Result |
|---|---|---|---|
The journal or batch has not been ticked as reconciled in another bank statement or reconciled or assessed as a match in this bank statement | |||
| the Bank Description contains 'Tyro Settlement' |
| The total of the journal lines for the bank account in the batch that do not have 'american' (not case sensitive) in the Transaction Summary matches the Bank Credit. | If the total does not match but the date does then it will be listed with the amounts highlighted. |
| If the Bank Description contains 'AMEX GR' |
| The total of the journal lines for the bank account in the batch that have 'american' (not case sensitive) in the Transaction Summary matches the Bank Credit. | Matched |
| If the Bank Description contains 'ZIPMONEY' |
| The total of the journal lines for the bank account in the batch is equal to or greater than the Bank Credit. | If more than 1 batch qualifies then the batch with the total closest to the Bank Credit. |
| If the Bank Description starts with 'Direct Credit' and ends with 'Payments' |
| The total of the journal lines for the bank account in the batch matches the Bank Credit. | Matched |
| Otherwise |
| The total of the journal lines for the bank account matches the Bank Credit. |
Ticking the Reconcile Box
- Ticking the Reconcile Box will:
- Link the journal or batch to the bank statement line.
- Write today's date as the cleared date for all journal lines to the bank account in the journal or batch, unless the line already has a cleared date.
- Un-ticking the Reconcile Box will:
- Unlink the journal or batch from the bank statement line.
- Remove the cleared date for all journal lines to the bank account in the journal or batch, unless the date is on or before the last original bank rec reconciled date for the host/bank account.
- The Action menu includes an option to 'Reconcile all lines with matching amounts'.
Changing from the non-statement centric (old method) Bank Reconciliation process
- If there is a locked original bank rec LOCKED old method bank reconciliation for a host/ bank account (ie one that is active)
- then no journal or batch can be reconciled for the same host/bank account.
- Close or delete the
...
- LOCKED old method bank reconciliation
| Note |
|---|
The Old Method bank reconciliation will no longer be available once the statement centric process starts to be used
|
...
|
...
|
...
|
...
|
...
Step 3 - attempt to match on batch transactions (Tyro non amex $ on date or 2 days prior). If date and tyro align but value is wrong - indicate as possible match
Step 4 - attempt match on tyro batch amex on date or dates prior
Step 5 - attempt match on date and amount
Step 6 - Attempt to match on debtor "Bank Transaction Identifier", search code, invoice number/s,
Step 6 - Show proposed matches in grid (Multiple ?) > person can accept or not accept. If accepted move to matched. if not accepted check for any other possible matches ?
Step 7 - user can create new transaction (right click > Create) > list as matched
Step 8 - user can attempt a search using pieces of the transaction description (exists)
Balance Sheet
...