Return to flip book view

Process Note Library Disclosures

Vesta Software Group – Finance Process Note Contents Page   
 Last Amendment Date: 21/11/2022Disclosures Notes Contents Page
1.  AFDA and S&E Backout 2.  Analytical Review Comments 3.  Contract not yet recognised 4.  CSI Bonus Adjustments 5.  Deferred Revenue - Note 15B v2 6.  How to Run the Vacation Accrual Data 7.  Maint Rev Daily Amortisation 8.  Note 03 - Provision Roll 9.  Posting the Vacation Accrual 10. PS % Completion non policy reclass 11. PS % Completion 12. Quarterly Analytical Review 13. ST LT Deferred Revenue Reclass 14. Subsequent Event 15. VAT reclasses 16. WIP - Note 15A 17. WIP Aging Note 10 18. WIP Provision Aging by Customer 

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 AFDA and S&E Backout Version Number 1.0 Section Disclosures Date of implementation 21/11/2022 Date of Last Review 21/11/2022 Process Scope Completing the (Allowance For Doubtful Accounts) AFDA workbook at quarter end for the quarterly disclosures. Process Steps 1. Roll forward the workbook from last quarter- X:\Management Accounts\CSI Reporting\2021\Q3\1. Submissions\AFDA \Workbooks AFDA Roll Fwd Copy the Data from the green section to the blue section (as text, not as formulas) and update the periods in row 9/10 to the current quarter (in the green section). AR Rec 1. Copy the data from the prior quarter from column C (starting at row 3) into Column B, update current quarter date in cell B2. 2. Remove the nominal totals from prior in Columns F : H 3. Complete the remaining tabs with current AR reports and data Summary AR You may be able to get this report from the month end handover (SQL AR tab). If not: Get SQL report from the CSI gateway

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 Click on the business name and use “Sales RM Summary Historical Aged Trial Balance” report Enter the last day of the quarter as the “Print age as of” date and click VIEW REPORT Use the ‘save’; dropdown to export to excel Copy the report (excluding headings and totals) and paste to Summary AR tab. There is a formula in columns K-L to calculate which lines to review for AFDA AFDA Detail From the Summary AR tab, copy and paste any balance that has a total in the AFDA column. This is to list any debt that is 271 days or older to enable a calculation for the provision against bad debt. This is per CSI provision policy. Copy and paste and formulas down from column K to column U if required Credit balances From the Summary AR tab, copy and paste any credit balance in Column L (overall account balance). All credit balances need to be journaled, even if they are going to be corrected. Post as reversing; Dr 1200-19-0-000 Cr 2050-10-0-000 Ex Prov From the Summary AR tab, copy and paste;

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 Exclusions - any bad debts that should not be provided for (i.e. payment remitted after quarter end) Additions - any that have not been included on the AFDA detail tab (i.e. known write offs that have not yet reached 271 days) Sales & Enhancements (S&E) Backout Insert the new quarter into the report as shown highlighted in pink, copy the formula from the prior quarter to the new quarter, then paste as text the prior quarter’s figures. Run a smartlist from GP – Sales/Sales Line Items/*Jonas-S&E Backout +customer class From the top menu bar select search and change the dates to the current quarter period (e.g between 01/07/2022 and 30/09/2022 for your Q3 2022 workbook). Run for all invoice types, not just SUP. Copy the smart list to excel and ensure the columns match those that are on the S&E Backout tab (also check the number of lines on the smartlist will fit into the space above the totals at the bottom of the tab). You will need to add a calculation for the gross amount. The important information is period that the maintenance covers, so make sure you’ve got this in your description/comments on all lines. You may have to use GP to find out the deferral periods for any with missing details, or ask a member of the transactional team. Any invoice with maintenance that starts in the current period delete the values. The backout is any invoices that are for the future quarters as there have not yet started, so per CSI policy we need to reverse these out of the AR and Deferred maintenance on a reversing journal. S&E Already paid Run a smartlist from GP – Sales/Receivables Transactions/Jonas S&E Backout Change the dates to the current period (e.g between 01/07/2022 and 30/09/2022 for your Q3 2022 workbook).

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 Copy and paste to the tab, ensuring all columns are the same, as data will put through to S&E backout tab, where you can now get and post your journal from the pink section you created earlier. A sensibility check is to see if the figures are similar to those in a prior quarter/year. Post Journals needed From the S&E Backout tab check the totals to post look inline with prior quarters, once happy with figures post a reversing journal as required AR Rec Change the fields highlighted in yellow i.e. dates and new ledger balances Check that the formulae are pulling through correctly and there is no difference on the reconciliation

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 2. There shouldn’t be any intercompany outstanding at a quarter end, but if there is, paste the details onto the “interco remaining” sheet - X:\Management Accounts\CSI Reporting\2021\Q3\1. Submissions\AFDA incl Acquired 3. Fill in the AFDA checklist to confirm your workbook is complete - X:\Management Accounts\CSI Reporting\2021\Q3\1. Submissions\AFDA incl Acquired 4. Fill in the quarter end checklist to confirm your AFDA is complete and posted Tips, Tricks and Troubleshooting GP Smartlist reports may vary from company to company just find the one with matching column headings. If you have a company with lots of transactions, use Smart View instead of Smart List – it will be quicker; Sales/Sales Line Items/S&E Backout Sales/Receivables Transactions/S&E Already Paid Unrecognised Rev AFDA - If any relates to support splitting the AFDA, any rev that relates to unrecognised rev needs to be a reversing journal 1700-70 & 2600-30

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 Analytical Review Version Number 1.0 Section Disclosures Date of implementation 21/11/2022 Date of Last Review 21/11/2022 Process Description Quarter end task where figures are checked at high level and MAs may need to explain why certain figures haven’t followed a historical pattern i.e. large variance to prior year Process Steps 1. Receive spreadsheet Spreadsheet run by Finance Manager after the Quarter End. They will let you know when the spreadsheet is ready to be competed and will include a list of tasks and responsibilities – you do not need to look at every tab, just use the list to see which tabs/companies to respond to listed under your name

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 2. Complete the Spreadsheet In the spreadsheet, find the tab name per the responsibility list e.g. AR Find your company and see the quarter vs quarter figure comparison You need to briefly explain the reason for the variance – you may already know this from your toolkit meeting or you may have to speak to your business to provide an accurate explanation for the difference.

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 The files are saved down each quarter so you may find it useful to look at some of the past sheets to see what level of detail to use, but usually a sentence or 2 is enough – it is a high level check 3. Complete the tracker When you’ve finished inputting all your comments, save the file and fill in the tracker so the progress is known to the Finance Manager. (note this is an example file location, you will need to find the correct year and quarter for the current review period) Tips, Tricks and Troubleshooting

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 Contracted not yet recognised revenue (Note 14) Version Number 1.0 Section Disclosures Date of implementation 21/11/2022 Date of Last Review 21/11/2022 Process Scope Brief description / overview of the process (1 paragraph) How to input disclosure note 14 into BPC and how to find the figures Process Steps Example uses EPOS Group Q2 2021) In BPC to open the input form for note 14; • On the EPM tab, Open, Open server input form folder, Jonas, Note 14 Select Vesta then the company from the dropdown and refresh.

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 Request sales backlog from your company (example below from CEG) Information to be split between PS and all other revenue, also needs to be split for <12months and >12months, the maintenance should be split over the standard period covered, use the gross figures

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 In addtion to the Businesses sales backlog report figures you need to add in to the non-PS figure the value of contracted maintenance from the deferrred maintenance pivot over the periods covered <12months & > 12 months Complete the totals in BPC Save Data

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 Tips, Tricks and Troubleshooting

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 Quarterly CSI Bonus Adjustments Version Number 1.0 Section Disclosures Date of implementation 21/11/2022 Date of Last Review 21/11/2022 Process Scope Each quarter there is a review of the bonus accrued to date and a true up to actual performance from forecast is calculated. Process Steps Bonus adjustments calculated by Jonas CFO and sent out by Vesta Head of Finance to MAs after EBITA finalised. Adjustments are provided excluding NIC and by department. MAs to post any adjustments required for their BUs – coding indicated on email sent (6230-10 on toolkit, 6150-30 balance sheet) NI calculated on adjustment at current rate (21/22: 13.8%, 22/23: 15.05%) and posted to 6230-15, balance sheet 6150-31 Tips, Tricks and Troubleshooting Take note from email and spreadsheet the direction of adjustments. It will be stated whether a positive figure is a debit or credit and in which GL code. Deferred Revenue Roll (note 15B) Version Number 1 Section Disclosures Date of implementation Date of Last Review Process Scope How to input disclosure note 15B into BPC and how to check/confirm the figures Process Steps

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 1. Check opening balance In BPC open the input form for note 15B; On the EPM tab, Open, Open server input form folder Select M_JonasUK, M_VESTA and company from the dropdowns and refresh. Opening balance can be found on row 30 Note: On some companies the balance is further split by department (there will be more than one option for the company in the third dropdown) to get the total balance for the entity, go to the tab “Def Rev Completeness – LC” (or go through each dropdown option and add up the opening balacnes)

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 Note: If your company is split by departments, you still only need to enter the figures into one of the inputs because the checks are done on the company as a whole. The balance comes from several nominals: 2. Note 1: Revenue Recognized from Deferred in the Period Note 1 is revenue that was a sale brought forward from the opening balance that has been released in the current period e.g Note 1 in Q1 2022: The sales invoice was on the system in December 2021 and has started to, or continued to, release in Jan – Mar 2022 e.g Note 1 in Q2 2022: The sales invoice was on the system in December 2021 and has started to, or continued to, release in Apr – Jun 2022

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 Ensure Deferred maint pivot (always December from the prior year) is updated including S&E Backout (posting AND reversal in January) and therefore balances to GP Use the deferred maintence pivot from end of December to get the totals of Jan-Mar2022 releases. You use the December pivot because you don’t want to include anything new that has been raised and released in the current quarter, only ones that existed at the end of the previous year. Note 1 figure includes the S&E backout (because the backout was part of the opening balances, if we exclude in the releases, the releases will exceed the opening balance) Exceptions • Exclude any maintenance plus invoices 3. Note 2: Inc due to cash received, excl amt incl rev the period Note 2 should be your movement in the quarter less the releases from note 1. Total up your balances at the end of the quarter – use the same nominlas as are included in your opening balance and take the closing balnces from same Note 2 calculation Movement in the quarter (closing balance less opening balance) Less Note 1 figure = Note 2 figure Some balance sheet sheets have the calculation already at the bottom of the 2600 tab and just need input of the Note 1 figure to get the note 2 output

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 The figure is made up of; • New sales in the period • Releases for newly raised sales orders • Any new journals/adjustments 4. Completeness check Enter Note 1 and 2 figuers in BPC Save the data (EPM Tab, Save) Once data has uploaded, go to the “Completeness check” tab and refresh it – check that the differences to GP column balances to zero Tips, Tricks and Troubleshooting Your deferred revenue spreadsheet needs to be complete and correct (balances to zero) to ensure these figures are accurate. If your deferral pivots are listing all the documents, it may be easier to filter by document type as rows instead (you can clearly see if the pivot includes S&E backout in this view)

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 Exclude any maintenance plus invoices Check reasonability of value – i.e. is release approx. 1 quarter of the opening balances (except in seasonal companies) New acquisition companies will need to use notes 4 and maybe 3 so ensure the acquired revenue is split out notes 4 and 3. Be aware that note 3 is only used in the first calendar year of acquisition i.e. if acquired 2022, you must only use note 3 until Q4 2022

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 How to Run the Vacation Accrual Data Version Number 1.0 Section Disclosures Date of Implementation 21/11/2022 Date of Review 21/11/2022 Process Scope This will show you how to run the vacation accrual data in Workday, to provide what the closing vacation liability should be at the end of each quarter as per CSI policy. The purpose of this calculation is to work out what the liability is from each employee or to each employee, if they were to leave the Company at that date, as to what payment would need to be added or deducted Process Steps 1. Log into Workday 2. Type ‘[AS] Time Off liability Report – Non Accrual – UK’ into the search bar and click enter (this report is used for anyone who gets there full entitlement at the beginning of the year, so isn’t on a set accrual plan – Companies outside the US) 3. It will go to this screen 4. A popup box will then open, make sure it shows the last date of the quarter in both boxes

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 5. Then export to excel via the top right-hand corner 6. It will then bring up this pop-up box, where you select Download 7. Once downloaded, you will get this pop up in the bottom left corner 8. In Management folder (only certain people can access), open the vacation accrual spreadsheet for your year and quarter 9. Save the download into the below folder, as non-US

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 10. ‘Time Off Liability Report - VAC Accrual’ (this report is for any Companies on an accrual plan and don’t get there full years entitlement at the start of the year). Click on Menu in the top left corner 11. It will open this list and select Dashboard 12. This then opens this selection of boxes, where you select Financials

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 13. Select Time Off Liability Report – VAC Accrual 14. Pop up box below opens, ensure it is showing the start date as the beginning of the year and the end date as the last day of your quarter and then select ok

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 15. It will then give you this pop-up box 16. This should only bring up your Companies from your portfolio who are on the accrual plan 17. Then export to excel via the top right-hand corner 18. It will then bring up this pop-up box, where you select Download 19. Once downloaded, you will get this pop up in the bottom left corner 20. Save the download into the below folder, as non-US

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 21. Request from HR (hrsupport@vestasoftwaregroup.com) the employees on hourly contracts 22. Roll over the previous quarters file, to the current quarter 23. Roll over the previous quarters file, to the current quarter 24. In the Summary tab, copy date from C6 to I6 and paste values 25. In the Summary tab, copy values in Column E to Column J and paste values to give the prior quarters comparatives 26. Update the date in C6 to the last day of the current quarter 27. The NI column, needs to reflect the current government rate for NI 28. On the Time Off Liability – Details tab, you now copy in the non US accrual data from the new report. However, on the current quarters report you need to filter on Column D (Business Unit) the companies which aren’t ours and delete. You also need to delete WM Data as they are calculated by the external accountant.

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 29. Copy Columns A to O and paste over the data in the Time Off Liability – Details, update the formula in column P & S 30. Open US Accrual download report and copy the columns in – you need to realign the columns to match to the Time Off Liability – Details tab 31. Then copy down the formulas in column P&S again 32. Check the formula in column S is equal to column N – to ensure it pulls in the correct liability, this is before we adjust the currency 33. In the HC check tab, copy last quarters numbers into column C & D 34. Refresh the pivot, ensuring it is picking up the whole amount of data 35. This will then highlight the items to review in column E – this is because workday allocations are not all truly aligned with the businesses, e.g.; Zoran is in workday under Uniware 36. Check last months report to compare what numbers we had – this is something that only the person involved would know 37. You would need to amend column D in the Time Off Liability – Details tab to reflect their true Business Unit 38. Highlight any of the changes 39. Refresh the pivot after all the amendments 40. Filter column H for those who are on hours 41. Open the working pattern spreadsheet and pick up there FTE percentage 42. We amend the formula on column S, so that the value is then adjusted to reflect the true working hours liability 43. Filter on column O, to check that the currency reflects the Business Units local currency 44. We amend the formula on column S, so that the value is then adjusted to reflect the liability in the Business Units local currency 45. As a final check, ensure column S on Time Off Liability – Details tab agrees with the total in cell C38 on the summary tab 46. Snip the table on the Summary tab and email to the Management Accountants (vestamas@vestasoftwaregroup.com) for them to then post the accrual in GP

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 Tips, Tricks and Troubleshooting • Access Rights – this process note is only going to be used by the Head of Finance or higher • During step 5 – this can take a few moments to run, so may want to start step ??? whilst waiting • Step 20 you can do at any point within the process, or even ahead of the process • A floor to the report, is if someone moves internally to a different group company it will not be reflected as their true holiday days for that year of movement • We also know that the Liability Cost doesn’t calculate correctly for those on hourly plans, but their liable time should be correct. I’ve attached a spreadsheet that shows their working pattern, so you’ll need to do a manual calculation to get their correct hourly rate. • Any currency or liability that doesn’t look correct, we enter on an additional tab to escalate to HR for them to double check and amend Workday if required • Q1 and Q4 carry over balances should be 5 or below, and then Q2 and Q3 the carry over balances should be zero

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 Maintenance Revenue – Daily Amortisation Calculation Version Number 1.0 Section Disclosures Date of implementation 21/11/2022 Date of Last Review 21/11/2022 Process Scope At each year end it is necessary to calculate the effect of the Jonas practice of amortising maintenance revenue on a monthly basis rather than daily as per IFRS 15. This information is consolidated on a group level to ensure that the total variance is not significant. Process Steps Spreadsheet to complete with in-scope entities will be provided by Corporate and saved down in shared Vesta X drive, example location below: Run a GP Smartlist/Smartview report “Sales Line Items with Deferrals”, see below for locations: Smartlist Smartview Use “Document Date” as a search filter for documents raised within the year. Filter the report for product lines relating to maintenance only.

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 The aim is to extract data relating to any new maintenance revenue which started to be recognised in the year prior (Jan 1 – Dec 31). The criteria that identify this may differ by BU dependent on their invoice numbering conventions & product code designations for maintenance billing. Use this extracted data to complete blue section of spreadsheet from Corporate: Business Unit: name of company e.g. Uniware Legal entity: 3 letter designation of company e.g. UNI Customer name: “Customer Name” column on report New customer/new add-on: “New customer” means customer is new in the year to the BU. “New add-on” is new maintenance sold to an existing customer Order #/Contract #: “SOP Number” column on report Activation/Go-Live date: “Document Date” column on report (taken as proxy for go-live as this data is not recorded in GP) Maintenance contract value: “Extended Price” column on report Currency: currency BU billed customer in Maintenance period - # of months: number of months between columns “EndDate” & “StartDate” in report 1st of the Month Revenue Recognized per GP: Use 1st of the month in “StartDate” column of report. Formula to get this date where “CELL” contains “StartDate” =DATE(YEAR(CELL),MONTH(CELL),1) Tips, Tricks and Troubleshooting Smartview vs Smartlist – Smartview takes less time to run and export large reports which is useful for entities with higher sales volumes For many BUs, invoice numbers starting “SUPN” denote those with new maintenance If the maintenance lines are not immediately obvious from their descriptions, it may be possible to extract a list of product codes from the BU’s CRM system to lookup against

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 New customer/new add-on – can be identified using Smartlist report available “Customers Creation Date” which lists all customers with the date their record was created Maintenance contract value – where there are many maintenance item lines per invoice it can be beneficial to pivot the report data by SOP number to get single maintenance value per invoice Activation date/Maintenance period/1st of Month – it may be necessary to review these inputs where maintenance period is not as expected (e.g. not 12 months when BU typically raises annual invoices). It may be due to invoices with go-live date earlier than invoice date, i.e. customer was billed late. This would be evident where deferred maintenance pivot shows that multiple months’ revenue were taken in 1st month of invoice. In this case, to achieve the goal that the disclosure aims for it is necessary to amend the activation date, maintenance period & 1st of month for these invoices. Example given below: • Invoice raised (activation date) 23/11/2021 with start date 01/11/2021 & end date 01/09/2022 • Deferred maintenance pivot shows 2 months’ revenue taken in November 2021 with last month of revenue deferred to September 2022 • In order for daily amortisation calculations to be correct it is necessary to amend inputs on disclosure as below: o Activation date from 23/11/2021 to 23/10/2021 o Maintenance period from 11 months to 12 months o 1st of the month from 01/11/2021 to 01/10/2021

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 Provision Roll Version Number 1.0 Section Disclosures Date of implementation 21/11/2022 Date of Last Review 21/11/2022 Process Scope How to complete quarterly disclosure which bridges opening provision position to closing provisions figure. Process Steps 1. Open BPC: Open → Open Server Input Form Folder → Note 03. See below: 2. Notes on what constitutes a provision and how to complete each note provided underneath input section

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 3. In addition to examples provided, any severance paid during the period should be input into notes 2 and 3, as a credit and debit balance respectively, in order to record the provision being created and used within the same period Tips, Tricks and Troubleshooting

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 Posting the Vacation Accrual Version Number 1.0 Section Disclosures Date of Implementation 21/11/2022 Date of Review 21/11/2022 Process Scope How to post the vacation accrual liability in GP, from the data provided from Workday Process Steps 1. Receive the email from Head of Finance or higher with the quarterly vacation details 2. Open your current quarters balance sheet from the folder in the x drive 3. Go to tab 2100-30 4. Check the balances on the email for the prior quarter agree to the balance you have in account 2100-30 before making any adjustments 5. Enter the current quarters liability onto the balance sheet workbook in the 2100-30 tab

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 6. Calculate the movement between the balance you currently have and what you want in account 2100-30, check it agrees with the movement on the email. 7. Transfer to GP to process the journal, use Posting a Standard Journal Tips, Tricks and Troubleshooting • Ensure the NI rate calculating in your Balance Sheet is the current HMRC rate

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 PS % Completion non policy reclass Version Number 1.0 Section Disclosures Date of implementation 21/11/2022 Date of Last Review 21/11/2022 Process Scope Quarterly deliverable for PS Revenue completion non policy reclass Process Steps 1. Look at the relevant PS Revenue nominal code (5010-10-0-XXX) to calculate the quarterly total to reclass

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 2. Total up the three net change values from the months relevant to the quarter you are completing ie. Qtr 4 would be Oct/Nov/Dec 3. Then enter a Journal for the reclass CR 5010-46-0-??? & DR 5010-47-0-XXX Journal example below: Tips, Tricks and Troubleshooting This reclass applies to BUs which do not adhere to the CSI PS % completion policy, which requires PS to be accounted for monthly on a percentage of job completion (e.g. 10 man days completed of job which requires 40 man days total = 25% PS revenue recorded) BUs which do not follow this policy generally follow the “bill and book” process, in which PS is invoiced to customers on completion of work and therefore potentially recorded late.

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 PS % Completion Version Number 1 Section Disclosures Date of implementation Date of Last Review Process Scope How to complete the quarterly requirement to disclose each BU’s potential error in cut-off of PS income recorded Process Steps Check with business manager if, as at the quarter end, they have any PS • revenue recognised where the work has not yet been completed • work completed where the revenue has not yet been recognised Tips, Tricks and Troubleshooting

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 Typically, the businesses which accrue for revenue at month end will have nil to disclose, but a) still check with business b) sheet still needs to be filled in with nil figure • If PS revenue is recognized EARLY – the POC cut-off error should be NEGATIVE as there is over-recognition of revenue (i.e. there should have been deferred revenue set up under POC) • If PS revenue is recognized LATE - the amount in this column should be POSITIVE, as there is under-recognition of revenue (i.e. there should have been WIP set up under POC) Quarterly Analytical Review Process Version Number 1 Section Disclosures Date of implementation Date of Last Review Process Scope As part of the quarter-end close process Jonas Software (Corporate) require each portfolio to supply an analytical review of its balance sheet and profit and loss account, commenting on any variances over $500K USD for the current quarter compared with previous year’s quarters (detailed below). Process Steps 1.) Review the timetable for the current quarter and understand when the deliverable to Corporate is required. The timetable can be found at :- X:\Management Accounts\CSI Reporting\2022\Q2\Vesta - Tracker for note disclosures - Q2 2022 NEW.xlsx and is updated each quarter (so look in the relevant quarter-end file in the CSI reporting directory). Within this file, filter on Analytical review to identify the due date of the report :- The timetable is updated each quarter by the Divisional Finance Manager

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 2.) Log into BPC11 – Excel 2016 (see process note logging into BPC) In BPC, log onto EPM:- Once logged on , click on open, once:- In Open my Reports Folder :- Click on the F-Drive:-

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 Click on Jonas and the following menu will appear:- Click on F-Drive and the following menu will appear :- Click on 1. NA Corporate – Shared

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 From the following menu :- Click – YE Templates and the following menu will appear :- Click on disclosure templates :-

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 Pick up the latest prior quarter file (NOT offline, otherwise “account detail” cannot occur), for Q2, this was Q1 2022 – BPC11 V2 (V3 was created after the submission of the analytical report (18th of the month)and so can be ignored, and open the file. Going forwards, there should be one version of the template. If in doubt contact Danielle Wong and / or Michelle Fok, who will confirm the correct template to use. As there are multiple tabs, hide those tabs not required until the following are left :- Those tabs highlighted in green including UK-Vesta are the relevant tabs. Always refresh the UK-Vesta tab by clicking on EPM And click on the arrow below the Refresh :-

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 Select Refresh Worksheet :- This will provide the most up-to-date data. Copy the Vesta tab into a blank Excel workbook and save into the X Drive as an offline file. Each quarter, the location can be found at :- This will enable updates to the file to occur quicker than if working on the F drive. Two tabs in the workbook are required , USD (which is the default currency) and GBP. Set up additional tabs depending on whether analysis is required on each Balance Sheet and Profit and Loss account class. To change the Vesta tab to GBP, highlight the USD cell (A2) in the live template:- The currency is shown in the function box. Double click on cell A2. A selection window opens up :-

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 Highlight USD :- Press the X (Delete button) on the RHS :- Find GBP :-

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 And tick the box. Then press Add Members :- GBP will now show on the RHS as being selected and then press OK:- The tab will now refresh in GBP:-

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 In the offline template, review column J in the USD tab and note the conditional pink formated cells showing “yes”. These are the asset classes where the variances need to be explained and separate tabs need to be created. The variances are calculated from:- For the Balance Sheet, the current month quarter data is compared to the last quarter in the previous year with the same quarter in the previous year is used as an aide memoire. For the Profit and Loss Account , the current month quarter data is compared to the same quarter in the previous year. So, from the above, an Accounts Receivable and License Revenue tabs needs to created in the offline file. Detail is now required for each of the “yes” variances and saved down into the separate tabs that have been created. For Example for Accounts Receivable:- To assist the Management Accountants in completing the variances relating to their companies, the variances are shown in GBP and then converted to USD using the end of quarter exchange rate, which can be found at :-

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 The detail is created by running a report in the live BPC template in the Tool BU LE breakdown tab :- This tab needs to be amended:- From above, cell B24 needs to change from local currency to GBP. The easiest way is to copy the GBP cell A2 in the UK-Vesta tab in the live BPC template and paste it into cell B24 in the Tool BU LE breakdown tab (it will automatically change to United Kingdom Pound) The account to investigate copy the first account with “yes” in column J on the UK-Vesta tab which in this case is Accounts Receivable and paste into cell B26 in the Tool BU LE breakdown tab.

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 Return to the UK-Vesta tab in the live BPC template and copy cell A1 Vesta Consolidated (Vesta) :-

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 And paste it into cell B30 in the Tool BU LE breakdown tab. Which will update the data in cells C30,D30 and E30 Then double click on B30 and this will expand the data showing the detail by company :-

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 Then copy all the detail from row 29 in columns B,C,D,E to where the data finishes and paste in the offline Accounts Receivable tab:- The report is detailing by “buckets” but the data required is the total for each company but only those where the variance is over £50K.e.g row 58 for Fashion Master and highlight these in yellow and then filter by colour (yellow) :- Update the FX rate in column J with the quarter end rate and sum the USD amounts in K (which is the USD equivalent of the GBP variance). If the variance is close to the total AR variance to be analysed then no further action is required. However, if the total is materially different from the total variance then the selection criteria needs to be expanded to include amounts less than £50K.

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 The above process is repeated for each asset class that requires analysis (showing “yes” in column J on the UK-Vesta tab) except that only the account to investigate needs updating. The whole report itself will take at least half a day to compile and needs to be completed (with responses) and sent back to Corporate three days after the final quarterly toolkit. To give the Management Accountants enough time to respond to the request, an email requesting responses to the offline file needs to be sent between 24-36hrs before submission to Corporate:- This also provides enough time for the preparer of the file to review, respond to comments made and summarise the responses. The preparer will take the summarised responses and add them to the UK Vesta USD tab (offline) under the comments section in column K.

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 It is this tab that gets emailed to the Corporate Team (Corporate FR):- The Corporate Team send this data to KPMG for their review of the quarterly accounts which are published for the shareholders. Tips, Tricks and Troubleshooting ➢ Ensure that the EPM Context is set to version Actual – Actual from GL:- ➢ If the downloaded individual account details, using the tool -BU LE breakdown, are not coming back to the summary (in either GBP or USD) it could be that:-

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 ➢ When there has been a new acquisition in the current year there would be no comparable variance. Therefore, when commenting on the variance, note the new acquisitions as these will have a significant impact on the variance ➢ Any issues with the Analytical Report, contact Danielle Wong, in the first instance. END

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 ST/LT Deferred Revenue Reclass Version Number 1.0 Section Disclosures Date of implementation 21/11/2022 Date of Last Review 21/11/2022 Process Scope Each quarter end it is necessary to reclass any deferred revenue on the balance sheet due to be released greater than one year in the future to the long term deferred revenue GP code 3100-15-0-000 for reporting purposes. Process Steps 1. From GP, pick up amounts in deferred revenue codes (starting 2600) in all months greater than a year in the future from the quarter end e.g. in September 21 pick up balances from October 22 onwards 2. Reclass these amounts from above codes to long term deferred revenue code 3100-15-0-000 (maintenance) or 3100-17-0-xxx (Co-term LIC mandatory maintenance) 3. Post this reclass as a reversing journal on the last day of the quarter end Maintenance – use Deferred maintenance pivot and sum up relevant date column Co-Term Licence – Download 2602 account and create a pivot so you can do the same as above and pick up the >12 month sum Tips, Tricks and Troubleshooting • For BUs with different deferral profiles, such as Maintenance Plus schemes where hardware revenue is taken immediately (bar time value of money adjustments) and paid for by customers over a period of years, these deferral codes are excluded from the above process as the full balance of these are separately reclassed from their 2600 codes to WIP 1500-10-0-000 with a reversing journal • You may have already got the figures for the reclass ready for the BACKLOG tab in the toolkit (AKA contracted not yet recognised) so you might be able to grab the figures from there (and if not do the BACKLOG at the same time!)

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 Subsequent Events Disclosure Version Number 1.0 Section Disclosures Date of Implementation 21/11/2022 Date of Review 21/11/2022 Process Scope This process is a quarter end CSI disclosure that we must complete, this should be completed between finance and M&A. The purpose is to notify CSI of what acquisitions are signed off and closed between the end of the quarter and disclosure submission date and any acquisitions that are highly probable of closing within the next quarter. Process Steps 1. Between working days 7-8, the Head of Finance/Chief Operations Officer emails Head of M&A to ask what position the deals are at. 2. The Subsequent Events Disclosure template is available from the following folder on the F Drive

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 3. The Head of M&A will then respond including the details of any deals in the template provided 4. Head of Finance/Chief Operations Officer reviews the file to sense check that the details seem reasonable (example below) and checks it back to the expected tab in the Investment Detailed Model if available to them

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 5. Once satisfied, this is emailed to Corporate FR (corporatefr@jonassoftware.com) by the agreed corporate deadline 6. Enter the date completed into the Quarter End Tracker Tips, Tricks and Troubleshooting • Information on the spreadsheet - Deal = Acquisition Name - Date Closed = Actual date closed or Estimated Closure date if in future - Cash Consideration = This is the initial lump sum of cash we will pay at acquisition - Cash Acquired = This is the predicted cash extraction from the bank on the day of acquisition

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 - Holdbacks = This is the future payments we will make as per the share purchase agreement/investment model. The expected net tangible asset payment should also be included here - Expected Payout of Contingent Consideration (It is the obligation we must pay cash consideration if future events or conditions are met) = Expected earnout payments - Aggregate Cap on the Contingent Consideration = This is only applicable if there is a cap on the Earnout amounts - Type = This is the type of deal; be it Share or Asset purchase - NTA Threshold = This is the amount the NTA needs to be above for a payment to be applicable - Industry Vertical = Vertical market that the entity is in

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 VAT Reclass Version Number 1.0 Section Disclosures Date of implementation 21/11/2022 Date of Last Review 21/11/2022 Process Scope Each quarter end the quarter’s sales & purchase VAT is reclassed to the VAT liability code as part of the VAT reconciliation process. Process Steps 8. Take ending balances of 1400-10-0-000 & 1400-20-0-000 at quarter end from GP 9. Reclass these balances from above codes to 2710-00-0-000 10. After posting the journal in GP, make sure the ending balances of 1400-10-0-000 & 1400-20-0-000 are nil at the quarter end Tips, Tricks and Troubleshooting

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 WIP (note 15A) Version Number 1.0 Section Disclosures Date of implementation 21/11/2022 Date of Last Review 21/11/2022 Process Scope How to input disclosure note 15A into BPC, which shows the movement bridging prior period opening WIP balance and current closing balance, and how to find the figures Process Steps (Example uses EPOS Group Q2 2021) 1. Check opening balance In BPC open the input form for note 15A; On the EPM tab, Open, Open server input form folder Select company from the dropdown and refresh. Opening balance can be found on row titled “Opening WIP (Prior period)

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 Balances will match to balance sheet reconciliation 1500-10:

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 2. Note 2: WIP Transferred to A/R This is WIP that was brought forward from the opening balance which has been released in the current period e.g sales invoice has now been raised Use the breakdown on your balance sheet to determine which items of WIP existed at the end of the last quarter that have now been released Yellow = Brought forward WIP Q1 Green = Relased WIP Q2 3. Note 4: WIP other movements Should not be used unless in exceptional circumstances, anything put here will be queried 4. Note 4: Acquired WIP For newly acquired companies, WIP that was included in opening acquisition balances 5. Note 3: WIP Changes Ignore items that have been raised and released in the same quarter Include any items that have been put into WIP within the quarter but not released

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 Tips, Tricks and Troubleshooting

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 WIP Aging – Note 10 Version Number 1.0 Section Disclosures Date of implementation 21/11/2022 Date of Last Review 21/11/2022 Process Scope How to input the figures required for disclosure note 10 into BPC, which shows the aging of the WIP current closing balance for the quarter. Process Steps 1. Log into BPC 2. In BPC click on the ‘open server input form folder’, click on note 10 3. Choose your group and company from dropdown list, then refresh

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 4. The figures need to be completed (highlighted yellow) to balance with the BPC Balance figure(circled Red) 5. BPC Balance figure should match to the companies balance sheet reconciliation for 1500-10 and 1820-45 (WIP Long Term) 6. The total figure of the WIP detailed on the balance sheet then needs to be analyised into the aging buckets 0-90 days, 91-180, 181-365 and >365. 7. Complete those figures in BPC

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 WIP Aging by Customer Version Number 1.0 Section Disclosures Date of implementation 21/11/2022 Date of Last Review 21/11/2022 Process Scope How to complete ‘WIP Aging By Customer’ Excel spreadsheet Process Steps 1. WIP Aging spreadsheet saved down each quarter as below: 2. Instructions to complete spreadsheet are provided at top. Aim is to list by BU and customer all revenue amounts accrued at quarter end and any related provisions booked input by aging bucket. Example as below, green cells completed by MA.

Vesta Software Group – Finance Process Note Contents Page Last Amendment Date: 21/11/2022 3. CSI policy is to provide for any balances greater than 180 days old (50% 181-365 days, 100% >365 days) in account 1500-20. Any balances meeting these conditions not provided for must be identified and explained in the spreadsheet. 4. Total WIP listed should equal total as per BPC Note 10 WIP Aging. Tips, Tricks and Troubleshooting Any BUs that have Maintenance Plus contracts (hardware & installation completed at start of contract, invoiced over 3-5 years of deal) will be highlighted in the spreadsheet as requiring explanation as they will be input in the 365+ bucket and are not provided for. Below is an example of the explanation to provide under BU Comments:

Vesta Software Group Finance Process Note Manual Deferred Revenue Roll note 15B Version Number Section Date of implementation Date of Last Review 1 Disclosures Process Scope How to input disclosure note 15B into BPC and how to check confirm the figures Process Steps 1 Check opening balance In BPC open the input form for note 15B On the EPM tab Open Open server input form folder Select M_JonasUK M_VESTA and company from the dropdowns and refresh Opening balance can be found on row 30 Last Amendment Date 26 JULY 21

Vesta Software Group Finance Process Note Manual Note On some companies the balance is further split by department there will be more than one option for the company in the third dropdown to get the total balance for the entity go to the tab Def Rev Completeness LC or go through each dropdown option and add up the opening balacnes Note If your company is split by departments you still only need to enter the figures into one of the inputs because the checks are done on the company as a whole The balance comes from several nominals Last Amendment Date 26 JULY 21

Vesta Software Group Finance Process Note Manual 2 Note 1 Revenue Recognized from Deferred in the Period Note 1 is revenue that was a sale brought forward from the opening balance that has been released in the current period e g Note 1 in Q1 2022 The sales invoice was on the system in December 2021 and has started to or continued to release in Jan Mar 2022 e g Note 1 in Q2 2022 The sales invoice was on the system in December 2021 and has started to or continued to release in Apr Jun 2022 Ensure Deferred maint pivot always December from the prior year is updated including S E Backout posting AND reversal in January and therefore balances to GP Use the deferred maintence pivot from end of December to get the totals of Jan Mar2022 releases You use the December pivot because you don t want to include anything new that has been raised and released in the current quarter only ones that existed at the end of the previous year Note 1 figure includes the S E backout because the backout was part of the opening balances if we exclude in the releases the releases will exceed the opening balance Exceptions Exclude any maintenance plus invoices Last Amendment Date 26 JULY 21

Vesta Software Group Finance Process Note Manual 3 Note 2 Inc due to cash received excl amt incl rev the period Note 2 should be your movement in the quarter less the releases from note 1 Total up your balances at the end of the quarter use the same nominlas as are included in your opening balance and take the closing balnces from same Note 2 calculation Movement in the quarter closing balance less opening balance Less Note 1 figure Note 2 figure Some balance sheet sheets have the calculation already at the bottom of the 2600 tab and just need input of the Note 1 figure to get the note 2 output The figure is made up of New sales in the period Releases for newly raised sales orders Any new journals adjustments Last Amendment Date 26 JULY 21

Vesta Software Group Finance Process Note Manual 4 Completeness check Enter Note 1 and 2 figuers in BPC Save the data EPM Tab Save Once data has uploaded go to the Completeness check tab and refresh it check that the differences to GP column balances to zero Tips Tricks and Troubleshooting Your deferred revenue spreadsheet needs to be complete and correct balances to zero to ensure these figures are accurate If your deferral pivots are listing all the documents it may be easier to filter by document type as rows instead you can clearly see if the pivot includes S E backout in this view Last Amendment Date 26 JULY 21

Vesta Software Group Finance Process Note Manual Exclude any maintenance plus invoices Check reasonability of value i e is release approx 1 quarter of the opening balances except in seasonal companies New acquisition companies will need to use notes 4 and maybe 3 so ensure the acquired revenue is split out notes 4 and 3 Be aware that note 3 is only used in the first calendar year of acquisition i e if acquired 2022 you must only use note 3 until Q4 2022 Last Amendment Date 26 JULY 21

Vesta Software Group Finance Process Note Manual Note 03 Provision Roll Version Number Section Date of implementation Date of Last Review 1 0 Disclosures Process Scope How to complete quarterly disclosure which bridges opening provision position to closing provisions figure Process Steps 1 Open BPC Open Open Server Input Form Folder Note 03 See below 2 Notes on what constitutes a provision and how to complete each note provided underneath input section Last Amendment Date DD MMM YY

Vesta Software Group Finance Process Note Manual 3 In addition to examples provided any severance paid during the period should be input into notes 2 and 3 as a credit and debit balance respectively in order to record the provision being created and used within the same period Tips Tricks and Troubleshooting Last Amendment Date DD MMM YY

Vesta Software Group Quarterly Analytical Review Process Notes Quarterly Analytical Review Process Version Number Section Date of implementation Date of Last Review 1 Disclosures Process Scope As part of the quarter end close process Jonas Software Corporate require each portfolio to supply an analytical review of its balance sheet and profit and loss account commenting on any variances over 500K USD for the current quarter compared with previous year s quarters detailed below Process Steps 1 Review the timetable for the current quarter and understand when the deliverable to Corporate is required The timetable can be found at X Management Accounts CSI Reporting 2022 Q2 Vesta Tracker for note disclosures Q2 2022 NEW xlsx and is updated each quarter so look in the relevant quarter end file in the CSI reporting directory Within this file filter on Analytical review to identify the due date of the report The timetable is updated each quarter by the Divisional Finance Manager 2 Log into BPC11 Excel 2016 see process note logging into BPC In BPC log onto EPM Once logged on click on open once Last Amendment Date 16 Sep 22

Vesta Software Group Quarterly Analytical Review Process Notes In Open my Reports Folder Click on the F Drive Click on Jonas and the following menu will appear Click on F Drive and the following menu will appear Last Amendment Date 16 Sep 22

Vesta Software Group Quarterly Analytical Review Process Notes Click on 1 NA Corporate Shared From the following menu Last Amendment Date 16 Sep 22

Vesta Software Group Quarterly Analytical Review Process Notes Click YE Templates and the following menu will appear Click on disclosure templates Pick up the latest prior quarter file NOT offline otherwise account detail cannot occur for Q2 this was Q1 2022 BPC11 V2 V3 was created after the submission of the analytical report 18th of the month and so can be ignored and open the file Going forwards there should be one version of the template If in doubt contact Danielle Wong and or Michelle Fok who will confirm the correct template to use Last Amendment Date 16 Sep 22

Vesta Software Group Quarterly Analytical Review Process Notes As there are multiple tabs hide those tabs not required until the following are left Those tabs highlighted in green including UK Vesta are the relevant tabs Always refresh the UK Vesta tab by clicking on EPM And click on the arrow below the Refresh Select Refresh Worksheet This will provide the most up to date data Last Amendment Date 16 Sep 22

Vesta Software Group Quarterly Analytical Review Process Notes Copy the Vesta tab into a blank Excel workbook and save into the X Drive as an offline file Each quarter the location can be found at This will enable updates to the file to occur quicker than if working on the F drive Two tabs in the workbook are required USD which is the default currency and GBP Set up additional tabs depending on whether analysis is required on each Balance Sheet and Profit and Loss account class To change the Vesta tab to GBP highlight the USD cell A2 in the live template The currency is shown in the function box Double click on cell A2 A selection window opens up Highlight USD Last Amendment Date 16 Sep 22

Vesta Software Group Quarterly Analytical Review Process Notes Press the X Delete button on the RHS Find GBP And tick the box Then press Add Members Last Amendment Date 16 Sep 22

Vesta Software Group Quarterly Analytical Review Process Notes GBP will now show on the RHS as being selected and then press OK The tab will now refresh in GBP In the offline template review column J in the USD tab and note the conditional pink formated cells showing yes These are the asset classes where the variances need to be explained and separate tabs need to be created The variances are calculated from For the Balance Sheet the current month quarter data is compared to the last quarter in the previous year with the same quarter in the previous year is used as an aide memoire For the Profit and Loss Account the current month quarter data is compared to the same quarter in the previous year So from the above an Accounts Receivable and License Revenue tabs needs to created in the offline file Last Amendment Date 16 Sep 22

Vesta Software Group Quarterly Analytical Review Process Notes Detail is now required for each of the yes variances and saved down into the separate tabs that have been created For Example for Accounts Receivable To assist the Management Accountants in completing the variances relating to their companies the variances are shown in GBP and then converted to USD using the end of quarter exchange rate which can be found at The detail is created by running a report in the live BPC template in the Tool BU LE breakdown tab This tab needs to be amended From above cell B24 needs to change from local currency to GBP The easiest way is to copy the GBP cell A2 in the UK Vesta tab in the live BPC template and paste it into cell B24 in the Tool BU LE breakdown tab it will automatically change to United Kingdom Pound Last Amendment Date 16 Sep 22

Vesta Software Group Quarterly Analytical Review Process Notes The account to investigate copy the first account with yes in column J on the UK Vesta tab which in this case is Accounts Receivable and paste into cell B26 in the Tool BU LE breakdown tab Return to the UK Vesta tab in the live BPC template and copy cell A1 Vesta Consolidated Vesta Last Amendment Date 16 Sep 22

Vesta Software Group Quarterly Analytical Review Process Notes And paste it into cell B30 in the Tool BU LE breakdown tab Which will update the data in cells C30 D30 and E30 Then double click on B30 and this will expand the data showing the detail by company Last Amendment Date 16 Sep 22

Vesta Software Group Quarterly Analytical Review Process Notes Then copy all the detail from row 29 in columns B C D E to where the data finishes and paste in the offline Accounts Receivable tab The report is detailing by buckets but the data required is the total for each company but only those where the variance is over 50K e g row 58 for Fashion Master and highlight these in yellow and then filter by colour yellow Update the FX rate in column J with the quarter end rate and sum the USD amounts in K which is the USD equivalent of the GBP variance If the variance is close to the total AR variance to be analysed then no further action is required However if the total is materially different from the total variance then the selection criteria needs to be expanded to include amounts less than 50K The above process is repeated for each asset class that requires analysis showing yes in column J on the UK Vesta tab except that only the account to investigate needs updating Last Amendment Date 16 Sep 22

Vesta Software Group Quarterly Analytical Review Process Notes The whole report itself will take at least half a day to compile and needs to be completed with responses and sent back to Corporate three days after the final quarterly toolkit To give the Management Accountants enough time to respond to the request an email requesting responses to the offline file needs to be sent between 24 36hrs before submission to Corporate This also provides enough time for the preparer of the file to review respond to comments made and summarise the responses The preparer will take the summarised responses and add them to the UK Vesta USD tab offline under the comments section in column K Last Amendment Date 16 Sep 22

Vesta Software Group Quarterly Analytical Review Process Notes It is this tab that gets emailed to the Corporate Team Corporate FR The Corporate Team send this data to KPMG for their review of the quarterly accounts which are published for the shareholders Tips Tricks and Troubleshooting Ensure that the EPM Context is set to version Actual Actual from GL If the downloaded individual account details using the tool BU LE breakdown are not coming back to the summary in either GBP or USD it could be that When there has been a new acquisition in the current year there would be no comparable variance Therefore when commenting on the variance note the new acquisitions as these will have a significant impact on the variance Any issues with the Analytical Report contact Danielle Wong in the first instance END Last Amendment Date 16 Sep 22