270 likes | 438 Views
TIS in the Finance Department. Finance Challenges. Cashflow management DSO v DPO Visibility of information Manage accruals Resource management Staff turnover Risk, training cost, consistency Vendor and Exception management Vendor education – PO reference Invoice duplication
E N D
Finance Challenges • Cashflow management • DSO v DPO • Visibility of information • Manage accruals • Resource management • Staff turnover • Risk, training cost, consistency • Vendor and Exception management • Vendor education – PO reference • Invoice duplication • Out-of-tolerance transactions • Invoice approval • No control, delays process • Compliance • Process audit, Management information
Accounts Payable Sub-Processes Source: BearingPoint 2007
Accounts Payable Sub-Processes 66% Where TIS can help Source: BearingPoint 2007
Vendor Analysis PO & Blanket Order EDI TRANSACTION TYPE PURCHASING METHOD EDI + Paper PO & Non PO Paper Mainly Non PO
How the process works – Step One Volume Report Audit Digital Mailroom Post Receipt Scanning Document ClassificationInvoices Cheques Remittance Rejection Letters Fax Receipt Email Receipt
How the process works – Step Two Volume Report Statistical Reporting Audit Audit Digital Mailroom Data Extraction Post Receipt Scanning Document ClassificationInvoices Cheques Remittance Rejection Letters Fax Receipt Email Receipt Invoice Reader Freeform OCR Engine Tuning PO / Non PO Header, Footer & Line item Data Correction Self Learning Multiple Languages ERP System
How the process works – Step Three Volume Report Statistical Reporting Financial Reporting Audit Audit Audit Digital Mailroom Data Extraction Customer Rules Validation Post Receipt Scanning Document ClassificationInvoices Cheques Remittance Rejection Letters Fax Receipt Email Receipt Invoice Reader Freeform OCR Engine Tuning PO / Non PO Header, Footer & Line item Data Correction Self Learning Multiple Languages Vendor Validation Units Pricing Multi Currency/VAT Duplicate Invoice Check 2/3/4 way match ERP System
How the process works - Step Four Volume Report Statistical Reporting Financial Reporting Work in Progress Reporting Audit Audit Audit Audit Digital Mailroom Data Extraction Customer Rules Validation Workflow Post Receipt Scanning Document ClassificationInvoices Cheques Remittance Rejection Letters Fax Receipt Email Receipt Invoice Reader Freeform OCR Engine Tuning PO / Non PO Header, Footer & Line item Data Correction Self Learning Multiple Languages Vendor Validation Units Pricing Multi Currency/VAT Duplicate Invoice Check 2/3/4 way match Exception Management Approval Processing Discrepancy Resolution Vendor Management Multi Currency/VAT Resource Analysis ERP System
Solution Summary Early visibility of transactional data • System will scale in volume • and applications • Accounts Receivable • Customer Services • HR • others… • a) Operational • Maximise AP resource • Creates efficient exception and rejection handling • Reduces training • b) Business • Assists vendor education • Capitalise on early payment discounts • Vendor rationalisation Full audit of process Identifies duplicate invoices and fraud
Solution Overview Management Information Paper Invoice Reader solution EDI Customer Rules Email Throughput System Tuning Financial Reports Processed Data and Images Fax Exception Management ERP Master Data Approval Management Information Work in Progress Financial Reports SLA Statistics SAP GUI Archive Link Provides “Fully Featured” Web based access for remote workers Secure Web Access
Solution Overview Management Information Paper Invoice Reader solution EDI Customer Rules Email Throughput System Tuning Financial Reports Processed Data and Images Fax Exception Management ERP Master Data Approval Management Information Work in Progress Financial Reports SLA Statistics ERP GUI Image Repository ERP Provides “Fully Featured” Web based access for remote workers Secure Web Access
Scanners and Image Quality Kodak i1420 Kodak i660
Read the Invoice • Optical Character Recognition • Engine Comparison Algorithms • Field Level Engine Definitions • Dates • Amounts • etc...
Find the Invoice Data – Generic Invoices Edit Masks @@######## or RegEx ^(43|45)\d{8}$ • Freeform (Logic) Rule Sets • Identifying Field Candidates • Keywords • Logical rules • Expressions • Masks • Validations • Graphical rules • Tables • Groups • Different languages Keyword(s) Field Groups Validations Net + VAT = Total Amount
Find the Invoice Data – Specific Supplier • Rule Sets for Top Suppliers • Validation against ERP data • Specific data formats 20% of all Invoices Edit Masks Keyword(s)
Find the Invoice Data – Learning • Learn Fields that are not accurately recognised • Production Learning • Data characteristics are learned during manual data entry Learning Db
Validation Against ERP ERP Db • ERP Database Search • Validation against ERP data • Supplier identification • Purchase Order identification • Line-Item validation against open orders
Exception Management • Validate Exceptions against master data and logical invoice rules • OCR “on the fly” for easy capture of text • Automatic Validations against business rules • Remote Exception Management
Management Information • Dynamic Controller • Real time process management • Prioritise specific vendors • Promote business data • Statistical Analyser • Helps identify and educate • non-compliant vendors
Invoice Reader Financial Reporting • Vendor, PO, Non-PO, Invoice Number, Date, Nett, Tax, Gross • Earlier visibility of invoice data • Centralised resource reference • Benefits • Early visibility – manage cashflow effectively • Vendor education (identify non-PO culprits) • Early payment discounts • Spend analysis and vendor rationalisation • Identify payment duplication • Highlight potentially fraudulent invoice attempts
Invoice Monitor for Process Control • Displays the status of invoices, incl. discounts, escalations • Transparency of the process during and after the invoice processing • Access to the workflow history, which can be archived after the process as PDF • Dynamic reporting via the selection of invoices in the invoice monitor (can be saved as templates) • Integrated SAP-rights for the user access
Factual Verification of Invoices • Automatic identification of Factual Verification (based on email address etc.) • Coding templates can be saved • Electronic accounting stamp for cost centre, GL account, notes etc. • Access to SAP documents
Invoice Approval via Web or SAP GUI • Automatic identification and routing to relevant approver(s) • Access via WEB or SAP GUI • Approval on line-item level • Automatic posting after all approvers have confirmed