Recent Change:  
6.50 - set the header of the Bank Reconciliation report to go further than the first page if takes up more space than that.

Accounts Payable Prep

  • Find a cash account that has not been used or add a new account
    • Accounts > Enter/Edit new accounts
    • Fund Ledger > Reports > Detail Account Inquiry
    • Include accounts with no activity; Select Print summary account inquiry ( This will find an existing account)

Add this account to Bank Rec

  • Bank Reconciliation > Parameters > Bank Account Groups

    • Create a testing group

  • Parameters > Enter/Edit Bank Accounts- Add the test Cash Account

Run an AP check run using your cash account and post to ledger

  • Parameters > accounts payable settings > page 1
    • Change the AP cash field to the cash account just added
  • Process > Print Check Proof > limit your selection
  • Process > Print/Update AP Checks > select your new cash account
  • Process > Post AP to Ledger

Cash Receipts Prep

  • Enter a couple of cash receipts for your cash account and post to ledger
    • Fund Ledger > Cash Receipts > New
    • Cash Receipts > Post Receipts to Ledger

Fund Ledger > Reports > Detail Account Inquiry

  • Print a detail inquiry for your cash account

Bank Rec > Process > Create Bank Rec

  • Select the bank group added above
  • Select your checks and deposits that have “cleared” the bank. If you select all that you just entered in the previous AP and CR steps, your ending balance will be the same as the ending account balance in Detail Acct Inquiry from ledger
  • Click on Reconcile at the bottom of the screen and the system should automatically display a report
  • Print a cleared check report for your cash account and check number range, make sure checks from recon show on report
    • Reports > Check Report
  • Print a cleared deposit report for your cash account and deposit number range, make sure deposits just processed show on report.
    • Reports > Deposit Report
  • Reports > Print reconciliation report and ensure all info just processed shows up and is correct
  • Reverse a check
    • Maintenance > Reverse Check Clearing > Select a check from AP > OK
  • Reverse a deposit
    • Maintenance > Reverse Deposit Clearing > Select a deposit from CR > OK
  • Process > Edit Bank rec
    • Select bank account group from earlier reconciliation and search for reconciliation date
    • click continue bank rec
    • verify check and deposit that were reversed are now showing unchecked
    • Ending balance should also be changed by the amount of the reversals ( Net of check and deposit)
    • Click reconcile and ensure ending balance changes on edit recon window ( May have to click search again to refresh balance)