CashbookReconciliationPartII by wuyunyi

VIEWS: 4 PAGES: 67

									      Special WebEx Training
• Thank you for joining Mortgage Computer’s Special
  Cashbook Reconciliation WebEx Training.
• During the WebEx session, audio will be muted so
  as to not pick up distracting sounds.
• Following the presentation, audio will be available to
  respond to any questions.
• Make notes during the presentation of questions you
  may have.
• During the presentation, you have the capability of
  asking a question using the chat room.
                                              mcoffice.com
Change to Main Menu




                  mcoffice.com
  WebApp




     Coming in April
15 Major Changes to WebApp


                       mcoffice.com
Accounting Menu




                  mcoffice.com
mcoffice.com
               Currently
                       Interface (lspddagl)
                        (cupddagl)


         Transaction                 Checking            Core
Payments
           Register                  Account              GL



                                         Not
                                       Used by
                                     Any Company
                                     (Not available in
                                     Mortgage Office)




                                                 mcoffice.com
Accounting Enhancement


  Transactions are posted to
       GL accounts and
  checking account registers.



                               mcoffice.com
Cashbook Reconciliation Enhancement
                              Checks
                               Paid



           Tran    CA         Check
Payments
           Reg                Detail
                   CA                     Cashbook
                   CA                   Reconciliation
                              Deposit
                   CA          Detail
                                            Balance
                                           Statement
                   Check                       to
                  Registers                Cashbook
                                          Reconciliation


                                        mcoffice.com
Accounting Menu




                  mcoffice.com
Cashbook Reconciliation Menu




                      mcoffice.com
Borrower and Investor Funds
        Are Held in
Custodial Checking Accounts

 • Processing Funds
 • Undisbursed Construction Funds
 • Investor P&I Funds
 • All T&I Escrow Funds


                              mcoffice.com
         Set Up
Bank Codes and Accounts
    for All Packages


                   mcoffice.com
Bank Codes and Accounts




                    mcoffice.com
Bank Codes and Accounts




                    mcoffice.com
Add Bank Account




                   mcoffice.com
 Select Type of Account




• Select which type of an account this will be.



                                          mcoffice.com
Post Entries to Check Register




     Used When
     • Checks not written on MC system
     • Deposits not through MC system
     • Bank charges/fees
     • Miscellaneous items, etc.
      Items which are not automated.
                                         mcoffice.com
          Proof - Modify




• Proof and Update Checking Account Register




                                      mcoffice.com
 View Checking Accounts




• Account history is retained for 12 months.
• Enter the Starting Balance at the time of setup.
  Do not modify after that.
                                           mcoffice.com
mcoffice.com
Cashbook Reconciliation Enhancement
                              Checks
                               Paid



           Tran    CA         Check
Payments
           Reg                Detail
                   CA                     Cashbook
                   CA                   Reconciliation
                              Deposit
                   CA          Detail
                                            Balance
                                           Statement
                   Check                       to
                  Registers                  Check
                                            Register


                                        mcoffice.com
Monthly Reconciliation




                    mcoffice.com
           Account Information




• Account Number – Select the account number.
• Month – Select the current month.
• Statement Day – Modify if the Statement Day is different.



                                               mcoffice.com
       Statement Balance




• Enter the dollar balance shown on the statement.




                                           mcoffice.com
  Beginning Cashbook Balance




• The balance in the check register is entered automatically
  as of the statement date. This amount cannot be modified.



                                                mcoffice.com
Beginning Cashbook Balance




          • Updated




                      mcoffice.com
            Deposits to Account




•
• You manually enter any deposits that show on the statement.


                                                mcoffice.com
          Deposits to Account




• This amount is added automatically to the check register.




                                               mcoffice.com
Checks/Withdrawals from Account




•
• Enter any checks not listed on the register and automatic withdrawals
  from the account. There will always be a Fannie Mae withdrawal
  from the investor P&I accounts.
                                                       mcoffice.com
Checks/Withdrawals from Account




  • This amount is subtracted from the check register.



                                              mcoffice.com
Deposits Not Cleared Account




•
•   – Displays all deposits from the check register
      not yet cleared.

                                          mcoffice.com
              Deposits Detail




• Lists all deposits not cleared (shown) on the statement.
Places a checkmark in Clear for all amounts. If only a few
have not cleared, then remove the checkmark. If only a
few have cleared, place the cursor in the box and click.



Removes the checkmark in Clear for all amounts.



Returns to the previous screen and adds the amount of
non-Cleared transactions to the statement amount.
                                             mcoffice.com
              Deposits Detail




• Lists all deposits not cleared (shown) on the statement.
    Deposits Not Cleared Account




• The amount of deposits not cleared is entered automatically.
  Note: You might enter a deposit prior to the bank/credit union
  updating their balance.
                                                  mcoffice.com
Checks Not Paid/Cleared Account




 •
 •   – Displays all outstanding checks that have not
       cleared the account.
                                            mcoffice.com
              Check Listing




• Lists all checks that have not cleared (paid).
• Check Out – Indicates the check was not written
  through the MC system or the funds were transferred
  to another account.
Places a checkmark in Clear for all amounts. If only a few
have not cleared, then remove the checkmark. If only a
few have cleared, place the cursor in the box and click.



Removes the checkmark in Clear for all amounts.



Returns to the previous screen and subtracts the amount
of Cleared transactions from the statement amount.
                                             mcoffice.com
              Check Listing




• Lists all checks that have not cleared (paid).
• Check Out – Indicates the check was not written
  through the MC system or the funds were transferred
  to another account.
Checks Not Paid/Cleared Account




 • The total dollar amount of checks not cleared (paid) is
   entered automatically.
                                                mcoffice.com
                    Subtotal




• The register and statement are subtotaled at this time.

                                               mcoffice.com
                 Subtotal




• Example shows the updated register and statement
  balances do not agree.
                                          mcoffice.com
                  Difference




• The difference between the check register balance and
  statement balance is shown.
                                             mcoffice.com
Adjustments




              mcoffice.com
               Edit Adjustments




• Make adjustments in addition, subtraction, or other types
  of errors to bring the statement into balance with the check
  register.
                                                 mcoffice.com
         Balance the statement
         to the check register.

            Check
                               Statement
           Register



 The check register is the source of original entry.
        You balance to the check register.

  The check register total is automatically carried
forward to the next checking account reconciliation.

                                             mcoffice.com
           Enter any adjustments needed
              to balance this account.
• Description – Describe why the adjustment was made.
• Credit/Debit – Will it be a credit or debit to the reconciliation.
• Register/Statement – Indicate if the adjustment is to the
  check register or the statement.
• Amount – Enter the dollar amount of the adjustment.
•        – Add an adjustment.
•        – Remove an adjustment.
•        – Update the reconciliation ledger.
•        – Return to the previous screen.
                                                     mcoffice.com
  Adjustments




• The adjustments are made.
                              mcoffice.com
Ending Cashbook Balance




    • The account is in balance.
                                   mcoffice.com
Close Statement



                  • When in
                    balance,
                    the account
                    is closed.




                    mcoffice.com
              Close Statement




•        – The credit and debits will be posted to the check
  register with a new total for the next reconciliation. The
  Check Register Report prints.
• Adjustments on the statement side will have to be made
  by the bank/credit union.
                                                mcoffice.com
 Check Register Report




• Updated data posted to the check register.




                                        mcoffice.com
                       Deposit Detail




• A listing of all deposits made to the checking account according to the date
  entered.
• Account Number – Select the account to view.
• Start Date – Enter the date to begin the listing.
• Days – Enter the number of days from the Start Date to include in the list.
  If left blank, deposits made up to the system date will be displayed.
                                                            mcoffice.com
                       Check Listing




• A listing of all checks made to the checking account according to the date
  entered.
• Account Number – Select the account to view.
• Start Date – Enter the date to begin the listing.
• Days – Enter the number of days from the Start Date to include in the list.
  If left blank, checks written up to the system date will be displayed.
                                                             mcoffice.com
Reports




          mcoffice.com
Daily Activity




                 mcoffice.com
Daily Activity




                 mcoffice.com
 Missing Checks




• Select the account(s) to audit.


                                    mcoffice.com
                Missing Checks




• Provides a listing of missing, voided, and re-issued checks.


                                                 mcoffice.com
    Checks Not Paid




• Select the bank account or accounts.


                                     mcoffice.com
Checks Not Paid / Cleared




                      mcoffice.com
          Monthly Reconciliation




• The past 12 months of reconciliation programs can be viewed.
• Month – Select the month to view.
•       – Prints the Monthly Reconciliation report.
                                                mcoffice.com
Monthly Reconciliation




• Display of past Monthly Reconciliations.

                                      mcoffice.com
List of Bank Accounts




                   mcoffice.com
List of Bank Accounts




                   mcoffice.com
          Software Bugs

MC staff tests every SIR folder thoroughly.
However, the same as car manufacturers and
rockets to the moon, bugs seem to creep in.
Let MC know a bug exists.
MC appreciates knowing and will correct the
problem.

          Thank You
                                    mcoffice.com
~ END ~

          mcoffice.com

								
To top