To Receive CPE Credit Participate in entire webinar Answer - PDF document

Planning for the Future with BI360 Charles Allen Senior Managing Consultant BKD Technologies August 10, 2017 callen@bkd.com To Receive CPE Credit • Participate in entire webinar • Answer attendance checks & polls when they are provided • If you are viewing this webinar in a group o Complete group attendance form with  Title & date of live webinar  Your company name  Your printed name, signature & email address o All group attendance sheets must be submitted to training@bkd.com within 24 hours of live webinar o Answer attendance checks & polls when they are provided • If all eligibility requirements are met, each participant will be emailed their CPE certificates within 15 business days of live webinar 1

Introduction Charles Allen • Senior managing consultant More than 27 years of experience • • Microsoft MVP Agenda • Introduction • What Is a Budget? • Introduction to Solver BI360 • Creating a Financial Budget • Entering Data into a Budget • Reporting Actual vs. Budget • Q&A 2

What Is a Budget?  Itemized summary of income & expenses for a given period? (1)  Way for organization to plan & manage its spending?  A real pain! (1) personalfinance.duke.edu/manage-your-finances/budget/overview 3

A Plan, Mechanism & Estimate • Plan for 1 to 10 years for all of company’s business units • Mechanism for coordinating production & sales • An estimate, when compared to actual results, as a way to evaluate performance MIT Sloan School of Management Budget Presentation Budget Approaches Top-Down • Upper-level management establishes general or specific budget guidelines or amounts Bottom-Up • Lower-level employees set their budget amounts. These budgets are prepared & submitted for approval by upper-level management Blended • Combines top-down & bottom-up processes Budgeting: Planning for Success (Christopher J. Skousen/Larry M. Walther) 4

Budget Types Line Item Budgets • Individual financial statement items are grouped by cost centers or departments (1) Lapsing Budget • Business units must return unspent funds (2) Flexible Budget • Adjusts or flexes for changes in volume of activity (3) Zero-Based Budgets • All expenses must be justified for period (4) Incremental Budgets • Uses previous period’s budget or actual results as a basis (5) (1) BusinessDictionary.com, (2) Chron.com – What is a Budget Lapsing Organization?, (3) AccountingCoach – What is a flexible budget? (4) Zero-Based Budgeting – Investopedia, (5) Budgeting Methods – Incremental Budgeting | tutor2u Business 5

Solver is an award-winning, global provider of self-service corporate performance management (CPM) software • Close to 2,000 customers in 40+ countries • Offices in U.S., Canada, EMEA, Asia, India & Latin America Fast company & channel growth • • GPUG member & sponsor WHAT IT DOES • Leverages your existing Excel knowledge in combination with modern web portal • Centralizes & streamlines your budgeting, reporting & analysis into a single solution • Eliminates need to ask IT for assistance to manage your BI solution SOLVES PAIN POINTS • Lack of insight into overall business performance • Manual processes that can lead to poor data integrity Difficulty integrating disparate data sources & • tools 6

CLOUD FACTS • A true multitenant cloud solution • HTML5 web interface • Powerful data integration (ETL) with prebuilt & user- definable connectors • Microsoft Azure public cloud platform OVERVIEW REPORTING REPORTING BUDGETING BUDGETING DASHBOARDS DASHBOARDS DATA DATA WAREHOUSE WAREHOUSE eoStar or eoStar or Payroll or Payroll or GP GP CRM CRM other data other data 7

MODULES SUMMARY • REPORTING: Design templates in Excel with real- time connections to ERP & CRM systems • BUDGETING: Automate budgeting & forecasting • DASHBOARD: Graphically visualize critical performance data • DATA WAREHOUSE: Aggregates disparate data & facilitates enterprise reporting & budgeting • WEB PORTAL: Single, easy-to-access end-user interface 8

Designing a Budget Template Design template using Report Designer Configure data settings in Admin Panel Configure interface settings in Admin Panel (optional) Input data into proper cells Save data back to data warehouse BI360 Planning Training Guide Data & Interface Settings • Data Settings – Determine what data from template will be stored & to where • Interface Settings – Adds additional elements such as line item details, charts & actual data for comparison 9

Designing a Template Designing a Template 10

Designing a Template Entering Data into a Budget 11

Entering Data into a Budget There are two options 1. Using Excel 2. Using BI360 Web Portal Entering Data into a Budget Options when entering data into budget  Enter amounts in input cells  Enter line item details  Use charts to view effects  Use spreading  See actual data for comparison 12

Entering Budget Data Using Excel Entering Budget Data in Excel What else can you do?  Highlight rows that have line item details  Publish worksheets to Word  Publish worksheets to PowerPoint 13

Entering Budget Data Using Portal Entering Budget Data Using Portal 14

Reporting Actual vs. Budget Reporting Actual vs. Budget Optional – Pull actual Optional – Publish report results into Design report Publish report Run report via email or to using BI360 data to web portal folder or warehouse for viewing (gasp!) printer 15

Questions BKD Technologies Support Center • Microsoft Dynamics GP – 877.253.7778 GPsupport@bkd.com • Monday through Friday, 8 a.m.–5 p.m. Call Support Center toll-free 16

Stay Connected Follow dynamicsGPinsights.com us on Twitter Join us on LinkedIn At Dynamics GP Insights , you can read articles, watch webinars & join View conversations videos on YouTube Continuing Professional Education (CPE) Credits BKD, LLP is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org The information contained in these slides is presented by professionals for your information only. Applying specific information to your situation requires careful consideration of facts & circumstances. Consult your BKD advisor before acting on any matters covered herein or in these seminars. 17

CPE Credit • CPE credit may be awarded upon verification of participant attendance • For questions, concerns or comments regarding CPE credit, please email the BKD Learning & Development Department at training@bkd.com Charles Allen | Senior Managing Consultant | 713.499.4629 | callen@bkd.com 18