Versions Compared

Key

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

Office Help Home

...

Table of Contents

Table of Contents
minLevel1
maxLevel7
excludeTable of Contents

...

Use Case(s)

  •  User needs to ensure that all entries on the Club Bank Statement exist in Office, as well as all entries in Office match the Bank statement.

Content

...


Accessing Bank Reconciliation Wizard

  1. To access the Bank Reconciliation Wizard, select General Ledger from the left hand menu.

...

  1.  

  2. Next, select Bank Reconciliation Wizard. This will populate a grid that shows all existing and saved Bank Reconciliations from the past.

...

Creating a New Reconciliation

  1. Select New on the top left.

...

  1. Next, set the date to the end of the month that is to be reconciled.

...

  1. Utilize the

...

  1. Include checks printed after As Of date option to include/exclude checks that were printed after the bank rec was completed.

...

  1. Set the Account Number to the corresponding General Ledger (G/L)  account by typing it in, or selecting the magnifying glass icon

...

  1. .

...

Image Removed

...

  1. Enter the ending bank balance from the bank statement that corresponds with the date chosen.

...

  1. The system will then pull in the balance on that G/L account, as of the date selected.

  2. On the left hand side, labeled Checks, all checks written from that G/L account, that have not been flagged as reconciled, will display. Now, mark each check that has cleared.

...

    • If a check is voided, it will show on this side with an asterisk, that denotes it was voided. There will be a corresponding entry on the other side that you will check to keep it in balance.

...

  1. As you mark off the checks, the outstanding checks balance will change and adjust the total on the Bank Balance section.

...

  1. On the right hand side, all the journal entries that would be part of this G/L account will show as a debit or credit as it was posted in the batch.

...

  1. The information that was posted to this account from any of the sales journals from the POS will show here, with CC types, Cash, etc. broken out to allow users to quickly reconcile the amounts. As batches are checked, the outstanding deposit amount will change in the bank balances box.

...

  1. Once everything is in balance, Save/Exit. The system will show that everything is in balance and will be ready for the next Reconciliation.

...

...

Best Practices

 

...

For an account to show in the list to be reconciled, it has to be set up in the G/L and set as Checking or other banking. General type will not trigger the system that it needs to be reconciled. Type is listed when viewing a G/L account from General Ledger across the top, then Accounts and you have opened the account window.

...

Image Added