Versions Compared

Version Old Version 9 New Version 10
Changes made by

P Sawkins (Unlicensed)

P Sawkins (Unlicensed)

Saved on

Key

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

...

  1. Right click on a line with bank details only, will search the grid for lines with our details only and a matching amount and show actions to match the bank line with our journal or batch.
  2. Right click on a line with our details only, will search the grid for lines with bank details only and a matching amount and show actions to match the bank line with our journal or batch.
  3. Choosing to match will merge the lines and tick Reconcile.
  4. Unreconciling these lines will split them again.
  5. Handles bank descriptions ending in 'Tyro' or 'Amex' to match amounts to amount within a POS batch
    1. Bank lines ending in ' Amex' or 'Tyro' will match on date in bank description regardless if amount does not match
      1. if amount does not match a journal may be required to be added to the batch
  6. Improved matching of ZIPPAY lines using dates

Starting date choice.  Ending date choice

Starting Bank Balance....$                             Starting GL Balance on date $........ (Difference $121 )

...

Deposit$

(5) $129

...

Withdrawal$

(7) $ 2,456

...

  •  

...

Ending Bank Balance....$                                                                             Ending GL Balance on Date $                (Difference)

Process Flow

Gliffy
nameBank Reconciliation remembered upload
pagePin9

Step 1 = create starting balance for bank account

Journals exist in SaaSplications > create a single match for all past journals to get to the starting balance.

Statement-centric bank Account reconciliation upload

  1. Importing a statement file from the bank:
    1. The file must be an xlsx or csv format file.
    2. It must have column headings in row 1, containing (Column headings are not case sensitive) :
      1. narrative OR description
      2. date
      3. debit
      4. credit
      5. balance
    3. The balance on the first data row + debit - credit must match the balance on the last row of the previous import for the host/bank account, unless it is the first import.
    4. Drag the statement file over the Statement-centric bank rec form and drop it.
    5. Reply Yes to upload the file.
    6. Action menu
      1. 'Import bank statement'.
      2. 'List bank statement(s)'.

Reconciling statement lines

...

  1. If a line has been reconciled the Reconcile box will be ticked and the matching journal or batch details will be shown.
    1. Lines in the bank statement may reconcile with individual journals or with the total of a journal batch
  2. The journal or batch can be opened from the context menu.a right click on the line
  3. Likely matches are listed beside the bank statement line details.

How are matches made

Matches are assessed

...

in this sequencePre-requisitesTestResult

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'

...

  1. A POS batch with the same date as the Bank Date

...

  2. Not a Zippay batch

...

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'

...

  1. A POS batch with a date between 1 and 6 days before the Bank Date.
  2. Not a Zippay batch

...

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'

...

  1. A Zippay POS batch with a date between 1 and 6 days before the Bank Date.
  1. 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'

...

  1. A journal batch with a journal type of Creditor Payment and a subtype of Direct Deposit.
  2. The Batch Date matches the Bank Date.
  1. The total of the journal lines for the bank account in the batch matches the Bank Credit.
Matched
Otherwise

...


  1. A journal with a date that matches the Bank Date.
  2. The total of the journal lines for the bank account matches the Bank Credit.

  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'.

...