What This Screen Shows


  • The current and unprocessed balances of any bank account shown.
  • Buttons to check assorted bank records updated from various modules.
  • Information on the bank itself.


Best Practices


  • Balance - It is highly recommended that the cleared/updated balance be checked at the end of every month to reflect the balance shown on the last bank statement of that month.


Bank Account Information


  1. Finance → Bank Reconciliation → Bank Accounts
  2. Highlight a bank account and click Select.


FIELDSOpt.Rec.Req.Description
Bank Identification——♦The Bank ID of the banking institution
Active——♦Set to true to activate the bank account
Style——♦Select between 1 Fund / Bank and Multiple Funds / Bank; determines if one fund or multiple funds are affected when records are updating to a bank account
Cash Code——♦The cash code in Financial Management that is affected when a record is updated to a bank account
Account Number—♦—The account number associated with the bank
Checking/Money Market♦——Must be checked as true if this is an account where checks will be written and/or need to create a payroll direct deposit file
Using Positive Pay♦——Check as true if a monitoring service is used to deter check fraud
Bank Name♦——The name of the bank
Online Banking URL♦——The online website of the bank
Remarks♦——Any notes added about the bank
Balance (Cleared/Balanced)——♦This balance should reflect the balance shown on the last reconciled bank statement
Unprocessed Balance——♦This balance should reflect all checks/deposits/transfers that have not cleared the bank
Current Balance——♦This balance should reflect the sum of the cleared balance and the unprocessed balance
Last Check Number Assigned—♦—The last check number that was assigned either in Vendor Payments or Payroll as long as Default Check Number is TRUE in Payroll/Vendor Payments Generic Setup Variables
Last EFT Transfer Number Assigned—♦—The last EFT transfer number that was assigned either in Vendor Payments or Payroll as long as Default Electronic Transfer Number is TRUE in Payroll/Vendor Payments Generic Setup Variables
Deposits———Allows for querying deposits currently in the bank
Charges———Allows for querying charges currently in the bank
Add Bank Charges———Click this button to add a bank charge issued by your banking institution
Checks———Allows for querying checks currently in the bank
Returned Checks———Allows for querying returned checks currently in the bank
Electronic Transfers———Allows for querying electronic transfers currently in the bank
Opt. = Optional  Rec. = Recommended  Req. = Required


Add a Bank Account


  • On the Bank Account Browse Screen, click the Add button.
  • Fill in the appropriate fields using the table above as a guide.
  • Click Save.