Automating ECB FX downloads and calculations
This Python script pulls ECB data, converts to your base currency, and delivers auto‑refreshed spot, YTD-average, and period‑average FX tables in an Excel workbook.
IFRS 16 Lease Contract Reader
The blog post introduces a Python-based tool called "IFRS 16 Lease Contract Reader" that uses OpenAI's ChatGPT to automate the extraction of essential lease data from contracts, streamlining the IFRS 16 calculation process by generating a structured dataset and summary in Excel.
IFRS 16 Lease Liability and RoU Asset Schedules
This blog post introduces a Python-based tool that helps accountants quickly generate IFRS 16 lease liability and Right of Use (RoU) asset schedules by inputting key lease details, producing detailed amortization tables in Excel for straightforward lease scenarios.
Journal Entry Pattern Detector
This blog post introduces a beta tool for detecting anomalies in journal entries using an Isolation Forest algorithm, which analyzes general ledger data to identify and flag unusual transactions based on patterns in dates, accounts, amounts, and descriptions.
Spreadsheet Translator
This blog post introduces a Google Spreadsheet add-in for translating spreadsheet content into a selected language, providing a quick setup guide for easy implementation.