Version 2.0 Updated: 08.25.2008
Customer Invoicing Through Payment FI-AR-002 08/27/08 – 08/28/08 Customer Invoicing Through Payment Customer Invoicing Through Payment FI FI-
- AR
AR-
- 002
002 08/27/08 08/27/08 – – 08/28/08 08/28/08
LaGOV LaGOV Version 2.0 Updated: 08.25.2008 Agenda Logistics, - - PowerPoint PPT Presentation
Customer Invoicing Through Payment Customer Invoicing Through Payment Customer Invoicing Through Payment FI- -AR AR- -002 002 FI FI-AR-002 08/27/08 08/28/08 08/28/08 08/27/08 08/27/08 08/28/08 LaGOV LaGOV Version 2.0
Version 2.0 Updated: 08.25.2008
Customer Invoicing Through Payment FI-AR-002 08/27/08 – 08/28/08 Customer Invoicing Through Payment Customer Invoicing Through Payment FI FI-
AR-
002 08/27/08 08/27/08 – – 08/28/08 08/28/08
2
Agenda
– Process overview – AS-IS process flow – Current system alignment – Process improvement opportunities – SAP terms glossary – SAP concepts & functionality – Business process flow – Leading practices – Enterprise readiness challenges
3
Before we get started ... Logistics
4
Ground Rules
spectator sport
close laptops
5
Introduction
facilitate the discussions and drive design decisions
meeting minutes to be sent by the Process Analyst to all participants for review and feedback
discussions, address key integration touch points
detailed business process and participate in the decisions required to design the future state business process
Round the Room Introductions Name Position Agency
6
Project Phases
Five Key Phases
Project Preparation Business Blueprint Realization Go Live and Support Final Preparation
7
Functionality Tentative Implementation Date Budget Prep October 2009 DOTD February 2010 Core Modules All Agencies July 2010 Additional Modules January 2011
Tentative Project Timeline
Project Start-Up
May – June 2008 July 2008 August – Dec 2008 January 2009
Blueprint
Phased deployment will be confirmed/updated before completion
8
Finance Leads Beverly Hodges – Finance Lead Drew Thigpen – Finance Lead Mary Ramsrud – Consulting Lead Logistics Leads Belinda Rogers – Logistics Lead Jack Ladhur – Logistics Lead Brad Denham – Consulting Lead Linear Assets Leads Mark Suarez – Agile Assets Lead Charles Pilson – Consulting Lead General Ledger Accts Payable Cost Accounting Grants Mgt Asset Accounting Real Estate Management
Pamela Suggs Kandy Daniel Mary Walker
Accounts Receivable Cash Management Funds Management Project Systems Budget Prep
Project Organization - Functional Teams
Grantor
9
Blueprint Objectives
Business requirements
integration points with other processes
conversion, enhancement, or workflow (FRICE-W)
Readiness challenges
requirements
10
Accounts Receivable Workshops
Session ID Date Business Process Goals FI-AR-000 08/11/08 Assessment
Receivable Functionality
FI-AR-001 09/09/08 Account Code Structure - Customers
FI-AR-002 08/27/08- 08/28/08 Customer Invoicing through Customer Payment
FI-AR-003 09/22/08 Customer Reporting and Analysis
11
Accounts Receivable Related Workshops
Session ID Date(s) Business Process
Integration Point with AR
FI-GM-005 08/25/08 Grants Billing/ Collection Design of Sales and Distribution (SD) billing functionality and how it will be used to support Grant Billing FI-CO-004 09/17/08 Interagency Transfers Design of interagency billing and payments (clearing) FI-CM-006 10/07/08 10/08/08 Cashiering and Offsite Cash Receipts Design of point of sale transactions/updating SAP with off site (non SAP collected) cash FI-AA-005 10/02/08 Retirement of Assets Design of sales of assets
12
Work Session Objectives
into SAP or interface
SAP with cash received and open AR (summary postings to GL)
– Manual direct entry into SAP AR module – Interface into SAP
– Manual check applications – Lockbox payment interfaces – EFT, ACH or Wire payment interfaces – Payment discrepancy processing
management
designs
13
High Level Process Overview Customer Invoice through Customer Payment
14
As-Is Process Flow Department of Natural Resources (DNR) Customer Invoice through Check & EFT Payments
Process: Accounts Receivable – Department of Natural Resources File: AR Accounts Receivable - Final.vsd Sub-Process: Accounts Receivable (Checks and EFT) Date: 8/26/2008 Prepared by: Salvaggio, Teal & Associates Page: 1/1
Customer AR Clerk Agency Liaison
SONRIS Bill Generated Mailed to customers Opens mail for checks at the agency Make copies15
As-Is Process Flow Department of Natural Resources (DNR) Customer Invoice through Check & EFT Payments
Process: Accounts Receivable – Department of Natural Resources File: AR Cash Receipts - Final.vsd Sub-Process: Cash Receipts Date: 8/26/2008 Prepared by: Salvaggio, Teal & Associates Page: 1/1
AP Clerk Agency Liasion AR Clerk Customer
Needs Service Request service at the agency Creates invoice in SONRIS Customer takes to AR and pays invoice Collects payment, stamps invoice paid and copies invoice Takes paid invoice to Liaison to receive service Routing of Deposits Service is rendered Deposit cash into Imprest fund Cut check from Imprest and gives to AR Print and give to customer16
As-Is Process Flow Department of Natural Resources (DNR) Customer Invoice through Cash Payments
17
As-Is Process Flow Department of Natural Resources (DNR) Customer Invoice through Cash Payments
AR Clerk AP Clerk Agency Liaison
18
As-Is Process Flow Department of Transportation & Development (DOTD) Customer Invoice through Payments
Process: DOTD Financial Services File: Accounts Receivable - PERBA - Final v03.vsd Sub-Process: Accounts Receivable - PERBA Date: 8/26/2008 Prepared by: Salvaggio, Teal & Associates Page: 1/3
Billing & Payment
Prepare JV to set up account receivable in DOTD GL for the days activity End of the Month Record funds into PERBA AR system Record Cash & Revenues in GL Prepare ISIS deposit slip A Mail to Vendors Produce Bills Receive Bill Provide Payment Receive Funds
Receive Funds
Record Funds into PERBA Transmit to A/R PERBA Accountant Receive transmittal Receive transmittal
19
As-Is Process Flow Department of Transportation & Development (DOTD) Customer Invoice through Payments
Process: DOTD Financial Services File: Accounts Receivable - PERBA - Final v03.vsd Sub-Process: Accounts Receivable - PERBA Date: 8/26/2008 Prepared by: Salvaggio, Teal & Associates Page: 2/3
A/R Accountant - PERBA State Treasury Cash Management Unit
A Record deposit in ISIS Send Deposit & Deposit Slip to State Treasury Monitor ISIS for deposit Receive Deposit & Slip Make Deposit Deposit Made? No Classify revenues in ISIS Yes Send deposit & deposit slip to Cash Mgt. Unit Receive deposit, deposit slip & classification document Record into excel & balance Balance? Yes Return documents for correction Make correction and send corrected documents No Receive corrected documents B20
As-Is Process Flow Department of Transportation & Development (DOTD) Customer Invoice through Payments
Process: DOTD Financial Services File: Accounts Receivable - PERBA - Final v03.vsd Sub-Process: Accounts Receivable - PERBA Date: 8/26/2008 Prepared by: Salvaggio, Teal & Associates Page: 3/3
B Receive & review cash receipt OK? Approve in ISIS End Yes Return for correction Make correction in ISIS No Send cash receipt to Approver
21
As-Is Process Flow Department of Transportation & Development (DOTD) Customer Invoice through Payments
22
As-Is Process Flow Department of Transportation & Development (DOTD) Customer Invoice through Payments
23
As-Is Process Flow Department of Public Safety Customer Invoice through Payments
24
As-Is Process Flow Department of Public Safety Customer Invoice through Payments
Process: ProBill – Department of Public Safety File: AR ProBill Final.vsd Sub-Process: Accounts Payable Date: 8/26/2008 Prepared by: Salvaggio, Teal & Associates Page: 2/2
Accounting Manager Accountant
A Send to account manager for approval Data correct? Send back to accountant for correction Approves document Make corrections Yes No
25
As-Is Process Flow Department of Public Safety Customer Invoice through Payments
Legal Accountant Technician
26
As-Is Process Flow Department of Public Safety Customer Invoice through Payments
27
As-Is Process Flow Department of Public Safety Customer Invoice through Payments
28
Review of As-Is Process Flows
payment?
methods?
– Current AR system used for invoicing – Current AR system used for debt management – Current AR system used for payment processing – Type of revenue stream used
Process Improvement Opportunities (Pain Points)
Accounts Receivable and Cash position
processing
during the invoicing and payment processing
Application Departments have equal access to the same information; cuts down on sending AR reports and other documents between the two groups
Leading Practices
– Correct invoicing errors at the source – Provide customer account information electronically
documents to customers
invoicing and credit data to customer’s Accounts Payable systems via
– EDI – XML – Electronic bill presentation
during invoicing and payment processing
discrepancy processing
31
Review of Invoicing in SAP: What is AR?
Receivable
– Expectation of monetary payment for good
– Payment is made sometime in future – Extension of AR credit is given to customer
– Exchange of goods
at the same time as payment – Payment is made in traditional monetary form (cash, check, credit card, etc) – No AR credit extended
Billing
– Payment is made in the form of transfer
accounting – No AR credit extended
32
SAP Glossary Accounts Receivable Invoicing
direct data entry, allows users to manually enter invoice and credit information into SAP via standard invoicing transactions.
automatically transfers invoice data to AR based on billing information formulated in Sales and Distribution (SD) module.
allows invoice data entry to be automated based on contractual agreements with the customer (billing amounts, start/end dates, etc)
information from external systems and uploading the data into SAP AR
entered in the system awaiting payment
entered in the system that has been
ways: through a payment, reversal or matching an invoice against a credit memo
and credit memo data to be suspended in system without accounting ledger update. Parked documents can be changed, deleted, or posted in the future. Parked documents can be viewed/maintained by users who have access to parking transactions.
invoice or credit memo to be suspended in the system without accounting ledger
viewed/updated/deleted/posted by the user who originally held the document.
additional review and approval for documents that are entered/changed in the system
Review of Invoicing in SAP
– An transaction between buyer and seller where money (check, wire, etc) is exchanged for goods or services. Goods or services are received by buyer and payment is given to seller at a future
for payment.
– Manual – Recurring – SD Billing – Credit Memos
– Manual data entry into AR Module – Recurring entry program – Standard integration with SD Module – Interfacing with legacy systems or Excel upload
34
Review of Invoicing in SAP: Manual AR Invoicing
via:
– Manual data entry by end user
with reference can be used to allow for quick data entry – Inbound interface that creates invoices using data files containing necessary invoicing information
invoice documents.
35
Review of Invoicing in SAP: Recurring Invoicing
according to fixed terms, line item amounts, start/end dates, etc.
system to define billing specifics
documents to automatically create postings in AR.
customized invoice documents.
36
Credit Control Area
controlling customer credit limits.
components Accounts Receivables (FI-AR) and Sale and Distribution (SD)
company codes and, to enable it to do this, you must assign the respective credit control area to the company codes.
37
Credit Control Area
In the following graphic, a central credit limit has been divided between the two credit control areas D1 and D2. The total limit at group level
credit control area level. The individual limits do not exceed the upper limit of 7,000 USD specified by the group.
38
Review of Invoicing in SAP: SD Billing
configuration in SD module to use functionality
information (entered on Good Issue document) provide the billing information for SD billing
information is used to calculate billing line items and overall customer total due. The billing information transferred to AR module automatically during the billing program execution
document should be send (billing partner versus payer partner)
documents.
39
Review of Invoicing in SAP: Credit Memos
invoice
memo data entry into SAP
documents
– Inbound interfaces from other systems – Excel spreadsheet as data input
40
Invoicing Design Guidelines
Discussion Points:
Centrally or de-centrally?
during invoicing & credits?
credit control areas?
range for customer invoicing?
transferred to customers?
forms
Points to Keep in Mind:
design and break ‘As Is’ traditions
41
To-Be Business Process Flow: Accounts Receivable Invoicing
42
To-Be Business Process Flow: Accounts Receivable Recurring Invoicing
43
To-Be Business Process Flow: Accounts Receivable Invoice Data Entry
44
AFS Coding Block to SAP Coding Block
45
SAP Glossary Customer Payment Processing
transaction that clears open invoices using customer payment information (check, cash, etc). Payment information is manually entered into system
transaction that clears open invoices using input file provided by bank. Payment information is automatically entered into system.
customized interface that clears open invoices using input file provided by bank. Payment information is automatically entered into system.
settlement of an outstanding invoice amount; when applied the original invoice and payment are cleared and a new ‘residual invoice’ is automatically created using the open balance of invoice
settlement of an outstanding invoice amount; when applied both payment and invoice remain open
down payments are payments received from customer prior to their receipt of any good or service
customer payments (checks, cash) to be deposited in bank
entered in the system awaiting payment
entered in the system that has been
ways: through a payment, reversal or matching an invoice against a credit memo
46
Review Customer Payment: Manual Payments
receipts
functionality (short payment scenarios)
functionality for small difference short pay scenarios
tied to invoice or on customer account
47
Review Customer Payment: Lockbox Payments
(SAP)
lockbox
lockbox payment file based on each days deposit
file and file is used as input to clearing open invoices
called BAI or BAI2. (SAP)
processing using both formats.
48
Customer Payment Design Guidelines
Points to Keep in Mind:
and break ‘As Is’ traditions
Discussion Points:
centrally?
payment application confirmation?
payment application?
processed?
49
To-Be Business Process Flow: Customer Payment Processing
50
To-Be Business Process Flow: NSF Check or other Returned Payments
51
To-Be Business Process Flow: Customer Cash Refunds
52
Review Customer Payment: Advance Payment
secure the production of a good or service
ledger and a credit to the customer’s account
good or service has been received
cleared and the down payment is a credit to the receivable general ledger
like credit memos and reduce the balance due on an invoice
53
Review Customer Account Management: Reporting
– Aging by customer available – Aging by business area available – Aging by dunning area available
reporting functionality (ABAP code, Queries) custom aging reports can be developed based on specific business needs
– Printed and mailed, faxed, etc – Viewed online – Downloaded and saved to external file
customer account management?
54
Disputed Customer Invoice Design Guidelines
Points to Keep in Mind:
design and break ‘As Is’ traditions
Discussion Points:
items currently?
dispute management?
correspondence in your system?
workflow within the business process?
dispute management?
correspondence transferred to customers?
55
To-Be Business Process Flow: Disputed Customer Invoice
Customer is notified of non payment for open item Customer disputes
Write-off or pursue payment? Write-off open item Billing Agency and Customer review cause of dispute Write-off Pursue Payment Customer agrees to pay? Clear open item from customer’s account End Yes Begin collection procedures End
56
Enterprise Readiness Challenges
and debt collection processes
57
invitees.
workshop.
special concern
Next Steps
Questions?
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?