Auditor Confirmation Letters Generator
Python-based Confirmation Letter Generator streamlines audits by automatically reading detailed listings of Trade receivables and payables from Excel, applying user-predetermined haphazard and target test sampling, and generating confirmation letters in a Word file.
Prophet Revenue Forecaster
This Python tool leverages Prophet to generate a revenue forecast from a simple Excel file, validating data, and providing visual and Excel outputs, while cautioning users about limitations related to model assumptions and data quality.
Automated AP Invoices Scanner
This blog post introduces the Automated AP Invoices Scanner which is a Python-based tool that extracts key invoice details—such as supplier, amounts, and dates—from a range of file types (images, PDFs, Word, Excel) using OCR and a natural-language model. Simply place invoices in the “Inputs” folder, provide your OpenAI API key, and the tool compiles an Excel report with invoice details and highlighted blanks, and a “Warnings & Info” tab for ambiguities.
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.