On the face of it, processing timesheets with Power Query ought to be fairly straightforward. By “processing timesheets” I am primarily thinking about records of hours worked that feed into payroll or job costing calculations.
Continue reading “Processing timesheets with Power Query – what about the human factor?”Why purchase order systems suck
Purchase order systems suck for most users within the average organisation and also their suppliers.
Continue reading “Why purchase order systems suck”Five things I learned from auditing
Like many finance professionals, I began my career in audit. Here are five things that I learned from auditing and still use many years later.
Continue reading “Five things I learned from auditing”Useless Controls
Because I was once an auditor, I have an obsession with useless controls. This is where an organisation makes you do something which they think is providing some kind of internal control. However, when you think about it in more depth, you realise it isn’t providing any control at all.
Some examples of useless controls
I had locked myself out of the online portal for an old pension scheme. I rang up and gave my account number. They asked for my full address as a security measure before they reset my account.
Continue reading “Useless Controls”Balance Sheet Reconciliations
Balance sheet reconciliations are a key component of regular accounting to ensure that your transactions are correct. They help you detect issues such as missing transactions or failure of controls or process. This article sets out what they are, what they’re for and how to do them.
Continue reading “Balance Sheet Reconciliations”