Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Ticking the Reconcile Box will:
    1. Link the journal or batch to the bank statement line.
    2. 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.
  2. Un-ticking the Reconcile Box will:
    1. Unlink the journal or batch from the bank statement line.
    2. 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.
  3. The Action menu includes an option to 'Reconcile all lines with matching amounts'.

Mass tick using Action Button > Reconcile all lines with matching amounts

Accepting proposed Journal templates

Ticking the reconcile box will create the journal

Right click to

  • ignore and create a different journal
  • open the proposed journal to edit then save (eg to create multi-line journal)

Mass create using Action Button >Create and reconcile Journals from Rules

Image Added

Manually finding lines to reconcile

...

Creating New Journal Templates

Note

Bank Rule Journal templates are limited to two line journalsJournal templates for bank rec rules must have a number of lines according to the journal type:

  1. 2 - general journal.
  2. 1 - creditor and debtor prompt payments.
  3. 0 - creditor and debtor payments.
  4. No other journal types are accepted

If a bank rec rule or a journal generated from a bank rec rule is saved then the bank rec will refresh

Right click on any matched line to use the journal that was used as a match to create a new Journal Template

The text on the bank line will be offered and can be reduced to be the text used to create the match

Image Removed

Image Removedfull Bank Description will be copied to the Rule Text. This can be edited and the Partial match check box ticked as required.

Image Added

Image Added

The result when the grid refreshes

Image Added

Changing from the non-statement centric (old method) Bank Reconciliation process

...