...
- Action menu option, 'Re-import bank statement days':
- Must have uploaded a spreadsheet or .csv file of bank statement lines.
- The balance on the first import line, if any, plus the Bank Out-DR or minus the Bank In-CR of the line must match the balance on the last bank line dated before the Bank Date of the line, if any.
- The balance on the last import line, if any, must match the balance on the first bank line dated after the Bank Date of the line, if any, plus the Bank Out-DR or minus the Bank In-CR of the line.
- All existing bank lines between and including the date of the first import line and the date of the last import line will be deleted before re-importing the uploaded bank statement lines.
When re-importing day(s) for a bank rec, the system checks for grouped bank lines that include lines within the date range.
If found, check if the groups include lines outside the date range.
If found then the re-import cannot proceed.
The system will Show a text box listing the group(s) and bank line(s) outside the date range.
Batches of Journals
Journal batches are common - example credit card batches where an aggregator deposits the result into the bank at the end of the day from a POS. In this case all the journals as they are created are linked to the batch.
Reconciling the batch will reconcile all the journals in that batch.
A rounding journal will be added only if a 1c difference exists in order to match a bank line and the batch value will show that it now matches the bank line.
Tyro Batches
Tyro payment settlements are made in two amounts for a single day
...
| Matches are assessed as below | Pre-requisites | Test | Result | Action Required | |
|---|---|---|---|---|---|
| 1 | 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 | ||||
| 2 | the Bank Description contains 'Tyro Settlement' or ends in "Tyro" |
| 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 totals do not match then Right click to create a fee journal within the batch |
| 3 | 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 | |
| 4 | If the Bank Description ends with or ends in " AMEX" and has a date in the description | All Journals in a batch must have "amex" in the Misc Comment | will match on date in bank description regardless of amount | Right click to open the batch and add journals to it so amounts match | |
| 5 | 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. | Right click to open the batch and add journals to it so amounts match |
| 6 | 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 | |
| 7 | Otherwise |
| The total of the journal lines for the bank account matches the Bank Credit. | ||
| 8 | A journal template | Text rule Checked in Sequence order (small to large) | Offers Journal template as possible match | Tick match to create journal from the template or right click to find alternative | |
| 9 | Right click to review possible other matches or create a journal from scratch |
...