Bank Reconciliation

Go to Accounting > Banking > Reconciliation
1) Click "Down Arrow" to show Accounts.
2) Select a Bank Account.

3) Start New Reconciliation
click on "Start New Reconciliation"
page will redirect you to add reconciliation details.

​4) Enter Bank Statement Details

1. ​Select Statement Start Date
2. Select Statement End date
   
3. Enter Beginning Balance.
4. Enter Ending Balance.
5. Click Start Reconciliation

5) Reconcile the statement by using the checkboxes to match transaction lines from statement to What has been recorded in the system.
Check the box to the right of each transaction line to reconcile.

6) If needed: Edit Statement date / Starting Balance / Ending Balance.

1.  Click on Edit icon to Open the dialog box.
   
2. Gives option to Edit Statement Start / End Date. Can also change Starting / Ending Balance.
   
3. Once after changes are made, please click Update Details.

7) View Deposit / Payment

8) Add Lines to Reconciliation

1. Click Add Line to add Other Charges.
   
2. Select any charge
   
3. or Select Payment from System.

8b) For Interest Income

1. Select Account
   
2. Enter Amount
   
3. Click to save

9) Complete Reconciliation

1. Once Reconciled, you can complete Reconciliation.
   
2. Reconciled statement can be Printed, Exported as Excel.
   
3. If want to delete can also be deleted.

​
Reconciliation History
Go to Accounting > Banking > Reconciliation
1) Click "Down Arrow" to show Accounts.
2) Select a Bank Account.

​Once selected you will see a list of previous bank reconciliations and an option to start a new one

​This report list features the following:

• Statement Dates with calculated Days/Months
  
• Bank Statement
  
  • Beginning Balance from Bank Statement.
    
  • Reconciled amount showing separately for Deposits and Payment with count.
    
  • Difference highlighted in RED.
    
  • Ending Balance from Bank Statement.
    
• Bank Statement vs SPS Books
  
  • Ending Balance from Bank Statement
    
  • Uncleared amount showing separately for Deposits/Payments with count.
    
  • Difference
    
    • If difference exists then highlighted in RED.
      
    • If no difference then $0.0 highlighted in GREEN.
      
  • Special Ending Balance showing as per SPS Books.

​
Bank Reconciliations can be reopened if needed

1. Go back to the reconciliation page that you would like to reopen
2. ​Click on the reopen button in the top right. Check Boxes will be disabled until you click to reopen.

A log is kept of any changes or if lines are added. 
It will show who made the change and when.

​
Credit Card statements can also be reconciled with this tool.