alliance 2017 - finance webapps best practices
TRANSCRIPT
1
Best Practice – Finance WebApps
# A L L I A N C E 2 0 1 7
2
YOUR PRESENTERRhett WilliamsMaster ConsultantJOINED SPARKROCK IN 2009
3
Horses for Courses
4
Basic Principle – Use the Right Tool for the Job
Primarily for non-financial users
WebApps is for many users with low volume of transactions per user
Back Office interface is for few users with high volumes per user
5
Ach iev ing WebApp Secur i ty and Ease
o f Ma intenance
6
Managing Profiles vs Users
Profiles – Oriented to Horizontal Employee Groups
Users – Oriented to Vertical Employee Groups
Hybrid model
Tips
7
Requis i t ions , Requests and
Expenses
8
Purchase Requisitions
Synchronize Purchase Order numbers with Requisition numbers
Consider using Auto create PO and Auto send PO e-mails using thresholds
9
Expense Types
The more effort that goes into expense types, the better WebApps works:
Make effective use of expense type categories
Use the prevent edit fields
Add links to intranet sites or other web sites
Use the ‘Details’ field to minimize the need to edit or overwrite
Use of Expense Types to capture the catalogue and price list of major suppliers
10
WebApps Receiving
Consider if entity has many sites, also useful for services
Not necessarily optimal for centralized receiving
Reduces paper and e-mail traffic and puts receiving responsibility where it belongs
11
Expenses
Make sure tax area descriptions are expense claim friendly
Set-up tax override if users can use this
Use of attachment required
Guidelines and hyperlinks
12
F inanc ia l Report ing
13
Basic Principles
Not a BI tool
Provides basic reports
Drill downs and Excel exports
Designed for non-financial users
Need more? Betta get Jet
14
Some Tips
Maintain just two versions of each report
Use of prevent drill down to protect confidential data
Spend the time to edit the captions
Minimize the number of data sets by relying on user filters and ‘ignore filter’
Only supports the first 6 dimensions
15
EVALUATIONSP L E A S E TA K E 5 M I N S T O C O M P L E T E A S E S S I O N E VA L U AT I O N .
WIN ME!One lucky survey will take home a
Ecobee Smart Wi-Fi Thermostat
16
THANK YOU FOR LISTENING
@ S PA R K R O C K I N CW W W. S PA R K R O C K . C O
M