670 likes | 842 Views
Saving Trees, Tempers, Time & Money The Impact Of Special Portfolios on Workflow Within Wilder Coe Stephen Landy & Colin Dicks Wilder Coe LLP. The Right Tool For The Job…. Make Sure You Know What Outcome You Want Before You Start!. In The Beginning….
E N D
Saving Trees, Tempers,Time & MoneyThe Impact Of Special Portfolioson Workflow Within Wilder CoeStephen Landy & Colin DicksWilder Coe LLP
The Right Tool For The Job… Make Sure You Know What Outcome You Want Before You Start!
In The Beginning… Paper Workflow reports were circulated and discussed in meetings.
Updating Workflows Was A Pain… To update a Workflow, you had to click on Portfolio, then Workflow, then find the Client and click on the Yellow arrow…
Scroll Down & Find The Tasks… Click on Edit To Access The Fields…
Edit The Task Fields… By Entering The Relevant Data…
And When Complete… Click on Update to Save Changes…
Find & Repeat For Any Other Tasks… Before going back and…
Laboriously Repeating… For Each Individual Client.
Then Along Came Practice Engine Version 8With Special Portfolios.
Where Are Special Portfolios Hiding? In the Portfolio Task Pad.
Special Portfolios Screen There are Two Dropdown Boxes…
Portfolio Type Select the Type Where Your Special Portfolio was Saved.
Portfolio Then Select Your Special Portfolio.
Click on Refresh… Find The Client We Want To Update…
Update The Relevant Fields… Directly Into The Relevant Box!
Then Scroll Down… And Repeat for any other clients. So Much Simpler!
Old School Exception Reporting… An old paper “Jobs over Budget” report discussed at meetings
Again, A Pain To Update Because… To update a Job budget, you had to go through Portfolio, Workflow…
Find The Client Job… Right click on the job and select View Job Details in order to…
Access The Job Details Screen… Change the Budget Cost figure and Click on Save
Repeating The Process For Each Job Again, Quite Slow & Clunky!
But With Our Special Portfolio… We can not only update all the Job budgets very quickly…
We Record Other Useful Information… Such as the estimated billing month and a variety of pitiful excuses in the boxes provided!
Special Portfolios Use SQL Script… Which Are Saved As Stored Procedures.
The Portfolio Table… Details of the Special Portfolio and its sources are stored here.
The Portfolio Columns Table… Each Column Has Its Own Customisable Entry.
Create An Update Script… Changes To Data Can Be Made Dependant On Which Field Is Updated.
Who Else Enjoys Spending Time Compiling Information For The ICAEW Annual Return?
Using Clunky Old Client Attributes… To update our Client classification attribute, we used to have to go Client, Searchand find the client…
Access The Client Details Page… Then, in the Client Details area, remember to select Client Attributes…
Find The Relevant Attribute… Update the appropriate Classification, Click on Apply &…
And Then Go Back … And Do It Again For EACH Client. One at a time!
Analysis Was Done Using Our CRM System Partners reviewed & marked up any changes on paper copies of reports for Annual Returns.Then sent back to Admin dept to update system.
Now, One Stop Classification Within PE… Info for Annual Institute Returns is easily reviewed & amended through a Special Portfolio.
Attribute Field Updating En Masse… Update a classification attribute field from options listed in a dropdown box.
Before – Status Field Updated Client by Client Using PE’s hard-coded Client Status values.
Now, Client Status Is A Special Portfolio And we created our own Client Status field & linked it to the main PE field. Client Status is now updated through a dropdown box, along with the Date Lost, when necessary.
What’s the Definition of a good Tax Accountant? • How do you improve the smooth running of your Tax department?
By Using Special Portfolio Workflows! Tax Job Special Portfolios have significantly increased efficiency within the Tax department.
Auto-Populating Job Workflows… Ticking the India box automatically populates a job with the relevant outsource tasks, and allows the outsource worker to access the job in their own workflow.
Outsourcer’s Tax Jobs Workflow Any Issues arising are flagged and normally dealt with by phone. Special Portfolio Workflows provide an easy & efficient way to keep the Job data up to date.
Minimising Write Offs… This Tax Exception report immediately flags Jobs where Outstanding WIP exceeds the budget. (nb. Interim WIP Budget = Job Budget less any Fees already billed).
Special Portfolios Also Helped Turn A Laborious 5 Week Tax Admin Job Done Every Year, Into A 5 Day Job…
Annual Tax Engagement Letters… Before Special Portfolios Budget and Engagement Letter informationused to have to be entered into spreadsheets.
Now, Quick Tax Job Budget Entry… New budget data is captured through a Special Portfolio