8:50
Start my morning with the usual EOD check. Typically around the month-end there are delays in retrieving data from the HO. In this case, first hit up one of the colleagues from IT&S team for Estimated Time of Arrival (ETA) since everybody in Finance be waiting for them manual journal submission. Then send out an email to the Finance team saying that there is a delay with some elaborate reason and give them ETA for them to calm down for now.
For the time being we may find some data in PeopleSoft that we may be able to ctrl+c ctrl+v into EOD excel sheet and run the macro.
9:40
I gotta send an email to global team regarding activated/deactivated project codes and request them to add to one of the “trees” in PeopleSoft. Quick and easy.
9:55
One of my colleagues from Finance team skypes me to run Trial Balance (TB) reports for her. This usually take ages, so while it's loading I minimise the tab and work on other tasks. When the reports are ready I download them in the folder and let her know it’s ready.
10:00
Need to do annual reconciliation for the year-end audit (yay a big task). To be as concise as possible this is the process of reconciling data from source file to our main system for each month in the financial year. So as you can see there are a lot of reconciliation going with this systems accounting role. Anyways, in order to do this, I would first need to extract lines from database using Microsoft Access, then reconcile all dem data.
11:00
It is time for WD+2 meeting. I like how we stand up in front of the whiteboard to do the meeting (since we sit for 8 hours or so). I nod along every few minute and listen to what people have to say. We were so busy doing our day-to-day and monthly tasks that we realise we really need to clean up that one legacy trade account.
11:20
Get some chamomile tea and Arnott's biscuits and go back to my reconciliation.
14:00
Every quarter, I send out stakeholder feedback survey to see if people in Finance is happy with what my team is doing, as we are kind of like the "auditor" of Finance that tries to mitigate any form of risk. But they don’t know that we can see who wrote what (lmao). So in order to be efficient, my manager asks me to book a meeting with all the people who were not satisfied with our service (lol).
15:00
My senior skypes me to say he got something new for me to do: a regression test.
Me: ???
I quickly google “regression test” and still not sure how to do it. So I ask my senior for help and it’s pretty much getting two data set and creating a pivot table to check whether there is any discrepancy. This is needed because there has been a software update just before I came and for a proper migration we need to check if the data in the original platform is same as the one in the new platform.
*Disclaimer: this may not be 100% accurate as it's been over half a year since I worked as an Assistant Systems Accountant.
Comentarios