Local Knowledge And Global Perspectives

TAKEAWAYS Having embarked on my professional journey with PwC China in 2004, my career has been a whirlwind of growth and dynamism. The first decade of my tenure was characterised by the restructuring of Chinese state-owned enterprises (SOEs), and facilitating their overseas initial public offerings (IPOs). Driven by the need of local SOEs to align […]

Green Views For Healthier Diets

TAKEAWAYS An image of a verdant forest glade or a tranquil pasture. Natural scenes typically conjure up positive emotions and a sense of wellbeing for most individuals, but could they also influence them to make healthier food choices? The answer, according to our article, just published in Nature’s new journal Communications Psychology, is “yes”. Our […]

AI-First Accounting: Hype Or Future?

The accounting world is brimming with anticipation about how artificial intelligence (AI) will revolutionize the industry. Is this just hype, or are we truly on the verge of a categorical shift in how accounting professionals work? This editorial discusses the current status quo of AI in accounting, the technologies available today, and the challenges ahead. […]

ArtificiaI Intelligence In Excel

TAKEAWAYS Excel is the go-to tool for most accountants. Whether it is crunching numbers, performing analysis or organising data, accountants rely heavily on Excel to complement tasks done in accounting software. But, what if artificial intelligence or AI – often touted as a game-changer for the accounting sector – were integrated into Excel? Can it […]

The Art Of Saying “No”

You have a pile of work to complete before you can call it a day. Your manager drops a thick file on your desk, with the instruction to “draft a project proposal by today”. Your colleague asks you for a “personal favour” to cover for him as he wants to leave early for a social […]

TECHNICAL HIGHLIGHTS

AUDITING AND ASSURANCE ISCA Issues Audit Bulletin (AB) 5 Reporting On Grants And Incentive Schemes – Considerations For Government Agencies To support government agencies in establishing reporting requirements for grants and incentive schemes, ISCA developed AB 5 to raise awareness of the different frameworks available for reporting on grants and incentive schemes. This audit bulletin […]

CA Lab Wins 2024 APEX Award For Publication Excellence

The Institute’s “CA Lab – a content hub for professional accountants in a dynamic business environment” has won the Publication Excellence Award at the 2024 APEX Awards. The CA Lab microsite achieved recognition for its overall quality in the “Websites (entire site, including content and design)” category. ISCA and the editorial team would like to […]

Streamline Consolidation With Power Query

TAKEAWAYS The visual below shows a typical consolidation worksheet. You have the list of accounts, and group entities in the columns. You will need to bring in the trial balance data of each group entity into this worksheet. This can be achieved using formulas or functions, or using Power Query. Power Query is an extract, […]