Accounts Payable Reconciliation Form - DOC

Document Sample
Accounts Payable Reconciliation Form - DOC Powered By Docstoc
					                                            Delgado Community College
                                                      Training Agenda


Process Description: Receiving, Accounts Payable, Checks, and
Bank Reconciliation

Banner Modules: Banner Finance

1. Meeting Logistics
Item                                        Description
Date       December 14 – 16, 2004
Time       8:30 a.m. - 4:30 p.m.
Location   Delgado Community College, 501 City Park Blvd, New Orleans, LA

2. Attendees
Role                                            Name
Facilitator    Michael E. (Mickey) Hughes
Scribe
Other          Chart of Accounts Team Chairpersons and other persons
Participants   responsible for Accounts Payable entry, Check writing, and Bank
               Reconciliation

3. Pre-Work
       Review training materials previously provided on Accounts Payable, Check
        Writing and Bank Reconciliation.

4. Purpose
       Perform the “Receiving” function on previously issue Purchase Orders
       Enter Accounts Payable documents into Banner Finance for both Purchase
        Orders and for those times when no Purchase Order was issued
       Process 1099 vendors
       Query and review entered A/P documents
       Run an Accounts Payable Check Run on entered Accounts Payable documents
       Run and process Accounts Payable Bank Reconciliation

5. Desired Outcomes
       Be able to create and cancel Accounts Payable Invoices
       Establish and maintain Discount Codes
       Determine the amount of any pending check run
       Run a check run, comparing results to expected results
       Process Bank Reconciliation




                             SCT- Confidential & Proprietary               Page 1 of 4
                        d215c466-193c-417d-acdc-0d3107bd2c1d.doc
                                          Delgado Community College
                                                    Training Agenda

6. Agenda Topics

Day 1 December 14, 2004
                                        Topic
Introductions
Common understanding of the agenda, process of delivery and identification of all
individuals present at the meeting
     Receiving
       Review the following forms:
          o Receiving Goods Form FPARCVD
          o Returned Goods Form FPARTRN
          o Receipt Required Value Maintenance FPARRIM
          o Receiving Goods Query Form FPIRCVD
          o Receiving/Matching Status Query FAIIREC
          o Receiving/Matching Detail Query FPIIREC
          o Delivery Log Form FPADELV
          o System Control Form FOASYSC
          o User Profile Maintenance Form FOMPROF
       Review the following process:
          o Receiving/Matching Process Report FABMATC

Break (mid morning)
    Receiving – continued as needed
    Regular Invoice and Direct Pay Invoice Processing
Lunch
    Regular Invoice and Direct Pay Invoice Processing - continued
    Credit Memo Processing
    Multiple invoicing
          o   Invoice/Credit Memo Form FAAINVE
Break (mid afternoon)
    One Time Vendors
    Cancel an Invoice
    Recurring Invoices
              Review the following forms:
          o   Invoice/Credit Memo Cancel Form FAAINVD
          o   Recurring Payables Form FAARUIV

      Taxes (since DCC isn’t using ‘taxes’ this will be a cursory review only)
          o   System Control Maintenance Form FOASYSC
          o   Rebate Maintenance Form FTMREBT
          o   Tax Rate Code Maintenance Form FTMTRAT
          o   Sales/Use Tax Group Maintenance Form FTMTGRP




                            SCT- Confidential & Proprietary                Page 2 of 4
                       d215c466-193c-417d-acdc-0d3107bd2c1d.doc
                                           Delgado Community College
                                                     Training Agenda

Day 2 December 15, 2004
                                         Topic
       Accounts Payable Online Queries
           o   Invoice/Credit Memo Query Form FAIINVE
           o   Vendor Detail History Form FAIVNDH
           o   Vendor Invoice History Form FAIVINV
           o   Invoice/Credit Memo List Form FAIINVL
           o   Document History Form FOIDOCH
           o   Vendor History Query Form FAIVHIS
           o   Vendor Invoice Query Form FAIVINV
           o   Open Invoice by FOAPAL Form FAIOINF

       Check Processing
       Canceling a Check
       Online Check Queries
           Review the following forms:
           o Online Check Print Form FAAONLC
           o Batch Check Print Form FAABATC
           o Payment Control Form FAAPAYC
           o Check Cancellation Form FAACHKS
           o Check Payment History Form FAICHKH
           o Check Number Validation Form FTICHKS

Break (mid morning)
           Morning session continued
           Review Check Processes:
           o Batch Check Process FABCHKS
           o Check Print Process FABCHKP
           o Batch Disbursement Register FABCHKR
           o Batch Check Accounting Process FABCHKA

           Review Reports:
           o Invoice Selection Report FARINVS
           o Cash Requirements Report FARCSHR (Cash Requirement Report) see
              defect 740255
Lunch
                  Bank Reconciliation

       Bank Tape Reconciliation Form FAABREC
       Bank Reconciliation Report Process FARBREC

Break (mid afternoon)
       o


Day 3 December 16, 2004



                             SCT- Confidential & Proprietary           Page 3 of 4
                        d215c466-193c-417d-acdc-0d3107bd2c1d.doc
                                          Delgado Community College
                                                    Training Agenda

                                        Topic
      1099 Reporting
      Review the following forms:
      o BankCode Rule Form GXRBANK
      o Direct Deposit Recipient Form GXADIRD
      o Bank Routing Number Validation Form GXVDIRD
      o User Profile Maintenance Form FOMPROF
      o Invoice Selection Report FARINVS
      o Batch Check Print Form FAABATC
      o Online Check Print Form FAAONLC
      o 1099 Reporting Form FAA1099
      Review the following processes/reports:
      o Direct Deposit File Creation Process FAPDIRD
      o Direct Deposit Remittance Advice Report FARDIRD
      o Direct Deposit Transmittal Register Report FAPTREG

Break (mid morning)
      o   1099 Reporting - continued
Lunch
    Open time for any issues from Tuesday, Wednesday, or Thursday
Break (mid afternoon)
    Review any outstanding issues with Controller’s Office personnel from
       previous visits
    Review any outstanding issues with Controller’s Office personnel from this
       visit


7. Document History
Revision Record
Number     Date and Sections     Author          Notes
   1.0     December 7, 2004      Michael E.      Agenda Creation
                                 (Mickey) Hughes




                            SCT- Confidential & Proprietary            Page 4 of 4
                       d215c466-193c-417d-acdc-0d3107bd2c1d.doc

				
DOCUMENT INFO
Description: Accounts Payable Reconciliation Form document sample