It s month end now comes the reconciliation crunch l.jpg
This presentation is the property of its rightful owner.
Sponsored Links
1 / 53

It’s month end, now comes the reconciliation crunch PowerPoint PPT Presentation


  • 106 Views
  • Uploaded on
  • Presentation posted in: General

It’s month end, now comes the reconciliation crunch. Richard Byrom Principal Consultant Atlanta Oracle Applications User Group (ATLOAUG) November 2004. Agenda. Presentation assumptions and objectives Why and how should we reconcile Setup issues

Download Presentation

It’s month end, now comes the reconciliation crunch

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


It s month end now comes the reconciliation crunch l.jpg

It’s month end, now comes the reconciliation crunch

Richard Byrom

Principal Consultant

Atlanta Oracle Applications User Group (ATLOAUG)

November 2004


Agenda l.jpg

Agenda

  • Presentation assumptions and objectives

  • Why and how should we reconcile

  • Setup issues

  • Close procedures for each module, reconciliation results & two way drill down

  • Additional Tips

  • Conclusion

  • Questions and Answers


Objectives l.jpg

Objectives

  • This presentation emphasizes the importance of on a regular basis so as to ensure improved control over financial information

  • To discuss different setup issues and that may impact your ability to reconcile.

  • To outline the month end close process for each module and give practical examples of expected reconciliation results.


Objectives4 l.jpg

Manufacturing subledgers

Financial subledgers

Objectives

Payroll &Human Resources

OracleGeneral Ledger


Objectives5 l.jpg

Objectives


What should be reconciled l.jpg

What should be reconciled?

  • Control Accounts

  • Inter Modular Movement

  • Intercompany Accounts


What happens if we don t reconcile properly l.jpg

What happens if we don’t reconcile properly?

  • Potential data corruption not detected

  • Sub modules may not be posted to the GL

  • Multiple months may remain open for a variety of modules

  • Repetitive errors may not be detected

  • Posting of non standard journals to control accounts

  • Open item system carries forward problems to next year.


Why the problem with reconciliations l.jpg

Why the problem with reconciliations

  • Inadequate training/inexperienced users

  • Lack of understanding of the system architecture

  • Trying to use old procedures for a new system

  • Bad Management


How should we reconcile l.jpg

How should we reconcile?

  • Establish your out of system procedures

  • Ensure that all the standard functionality provided by the system is understood and used

  • Make use of additional tools if necessary


Setup issues general ledger l.jpg

Setup Issues – General Ledger

  • Sequential numbering of documentation should be taken into consideration.

  • Chart of accounts should be appropriately designed and have an appropriate groupings and sub grouping by using parent and child relationships.

  • Document types and sub types need to be looked at


Setup issues sub ledgers l.jpg

Setup Issues – Sub Ledgers

  • Master Data

    • Should be separated according to the different groupings of debtors available per profile options

    • Customers should be given appropriate hierarchies

    • Customer numbering should done in such a way that facilitates understanding of the various listings


Setup issues sub ledgers12 l.jpg

Setup Issues – Sub Ledgers

  • Transactional Data

    • Ensure that appropriate transaction types are created

    • Control A/C’s should appropriate filter the information through to General Ledger

    • Autoaccounting

    • Need to look at document numbering


Month end close steps l.jpg

Month end close steps

  • Pre-posting activities

  • Posting to supporting systems

  • Run verification Reports

  • Reconcile against interfacing systems

  • Close periods

  • Problem Solution

  • Two way drill


Receivables steps pre posting l.jpg

Receivables Steps – Pre-posting

  • Pre-posting activities

  • Enter Receipts

  • Enter Invoices

  • Record NSF checks

  • Run Autoinvoice Interface

  • Print New Invoices

  • Run Incomplete Invoice Reports

  • Adjustment Approval Report


Receivables steps gl posting l.jpg

Receivables Steps – GL Posting

  • Posting to GL

  • (AR) Interfaces > General Ledger


Receivables steps reports period close l.jpg

Receivables Steps – Reports & Period Close

  • Verification Reports

    • Sales Journal by GL Account*

    • Receipt Journal Report*

    • Journal Entries Report*

    • Transaction Register*

    • Adjustment Register

    • Receipt Register Report*

    • Aged Trial Balance*

    • Invoice Exceptions Report

    • Applied Receipts Register

    • Unapplied Receipts Register

  • Close Periods


Receivables steps reconciliation results l.jpg

Receivables Steps – Reconciliation Results


Receivables steps reconciliation results18 l.jpg

Receivables Steps – Reconciliation Results


Reconciliation problems l.jpg

Reconciliation Problems

  • If AR does not reconcile to the general ledger

    • Check that the reports have been run for the correct date/period

    • Run GL Interface

    • Make sure all Journals are posted in the General Ledger

    • Re-Run both Trial Balance Reports

    • Check for journal entries in the AR Control accounts in GL, not generated by AR.

    • Check for Invoices raised against the AR Control account


Receivables two way drill invoices l.jpg

Receivables two way drill - Invoices


Receivables two way drill invoice status l.jpg

Receivables two way drill – Invoice Status


Receivables two way drill invoice accounting l.jpg

Receivables two way drill – Invoice Accounting


Receivables two way drill cash receipts l.jpg

Receivables two way drill – Cash Receipts


Receivables two way drill l.jpg

Receivables two way drill


Receivables two way drill receipt history l.jpg

Receivables two way drill – Receipt History


Receivables two way drill miscellaneous receipts l.jpg

Receivables two way drill-Miscellaneous Receipts


Receivables two way drill miscellaneous receipts27 l.jpg

Receivables two way drill-Miscellaneous Receipts


Receivables two way drill gl to invoice l.jpg

Receivables two way drill- GL to Invoice


Receivables two way drill drilldown effect l.jpg

Receivables two way drill – Drilldown effect


Payables steps l.jpg

Payables Steps

  • Pre-posting activities

    • Enter Employee Expense Reports

    • Enter Invoices

    • Run Invoices on Hold Report

    • Run Payables Approval

    • Check for Unapproved Invoices


Payables steps transferring to gl l.jpg

Payables Steps – Transferring to GL

Payables Steps – Create mass additions


Payables steps reports period close l.jpg

Payables Steps – Reports & Period Close

  • Verification Reports

    • Accounts Payable Trial Balance*

    • Posted Invoice Register*

    • Posted Payment Register*

    • Expense Distribution Report

    • Invoice Aging Report*

    • Posting Hold Report

    • Invoice Register*

  • Close Periods


Payables steps reconciliation results l.jpg

Payables Steps – Reconciliation Results

  • Reconciliation can also be achieved using Tutor Business Form FOR0672


Reconciliation problems34 l.jpg

Reconciliation Problems

  • If AP does not reconcile to GL

    • Check that the reports have been run for the correct date/period.

    • Run GL Post in Accounts Payable.

    • Post all payables generated batches in the General Ledger

    • Re-Run both Trial Balance reports

    • Check for Journal Entries in the AP control account, not generated by Accounts Payable.

    • Check for Payments/Invoice Distributions made against the AP control account.


Payables two way drill query an invoice l.jpg

Payables two way drill – query an invoice


Payables two way drill view accounting l.jpg

Payables two way drill – view accounting


Fixed assets steps l.jpg

Fixed Assets Steps

  • Pre-posting activities

    • Prepare Mass Additions

    • Post Mass Additions

    • Delete Mass Additions

    • Prepare Manual Additions

    • Retire Assets

    • Adjust Assets

    • Capitalize CIP Assets

    • Run Depreciation


Fixed assets steps gl posting l.jpg

Fixed Assets Steps – GL Posting

  • Run Journal Entries


Fixed assets steps reports period close l.jpg

Fixed Assets Steps – Reports & Period Close

  • Verification Reports

    • Cost Detail Report*

    • CIP Detail Report

    • Asset Addition Report

    • Cost Adjustment Report

    • Asset Retirements Report

    • Asset Reclassification Reconciliation Report

    • Asset Transfer Reconciliation Report

    • CIP Capitalization Report

    • CIP Assets Report

    • Unposted Mass Additions Report

  • Close Periods


Fixed assets results l.jpg

Fixed Assets Results

  • Alternative reconciliation using FOR0674 Tutor Business Form

  • Printing of Reconciliation Report


Cash management steps l.jpg

Cash Management Steps

  • Pre-posting activities

    • Capture/Interface Bank Statements

    • Automatically reconcile statements

    • Manually reconcile amounts not cleared

    • Check all statements are fully reconciled

      • Bank Statement Detail Report

      • Online checks


Cash management steps42 l.jpg

Cash Management Steps

  • Post to GL

    • Ensure payables and receivables posting has taken place

  • Verification Reports

    • Cash In Transit Report

    • Cleared Transactions Report*

    • General Ledger Reconciliation

    • Transactions available for Reconciliation


Cash management results l.jpg

Cash Management Results

  • Check Receipts against Receivables Reports, Cash Account per GL and Cash Management Reports

  • Check Payments against Payables Reports, Cash Account in GL and Cash Management Reports


Cash management two way drill account inquiry l.jpg

Cash Management two way drill – Account Inquiry


Cash management two way drill drilldown effect l.jpg

Cash Management two way drill – Drilldown effect


General ledger steps l.jpg

General Ledger Steps

  • Pre-posting activities

    • Reconcile interfaces from feeder systems

    • Enter Manual Journal Entries

    • Reverse Entries

    • Run Journal Import

    • Generate Recurring Journal Entries

    • Generate Mass allocations

  • Post Journal Entries


General ledger results l.jpg

General Ledger Results

  • Verification Reports

    • Journal Entry Report

    • Account analysis Report*

    • Account Analysis – Sub Ledger Detail Report

    • Trial Balance – Detail Report*

    • Run Financial Statement Generator – FSG’s

  • Close Periods


Additional tips file export l.jpg

Additional Tips – File Export

  • To export the results of an online inquiry or onscreen view choose File > Export from the menu

  • Save the file generated to your desired location

  • Open the file from Microsoft Excel. Ensure that from the open dialogue box in Excel you specify files of type all *.*

  • When the text import utility appears choose finish, you can now sort the file according to your personal requirements


Additional tips cont d tools copy file l.jpg

Additional tips Cont.d – Tools>Copy File

  • Use Tools > Copy file from the menu when you are in a report

  • Save the file in web or text format to your desired location – preferably use text

  • Import the file into Excel using the text import wizard as displayed – use the report column headers as your fixed width delimiters.


Additional tips cont d tutor l.jpg

Additional tips cont.d - Tutor

  • Use Oracle Tutor Business forms to give you reconciliation templates.


Conclusion l.jpg

Conclusion

  • Reconciliations are important in order to identify problem areas and rectify them on a timely basis.

  • Procedures should be put in place to facilitate reconciliation as well as ensure that the organisation is making use of all possible tools.

  • Setups as well as inquiry and reporting tools have a significant impact on the ease of reconciliation.


Slide52 l.jpg

Q

&

A


Speaker information l.jpg

Speaker Information

  • Name: Richard Byrom

  • e-mail: [email protected]

  • [email protected]

  • Company: Thales Information Systems

  • Web Site: http://www.thales-is.com

  • http://www.richardbyrom.com

  • Mobile: +44-7976123106


  • Login