A free lightweight Windows desktop spreadsheet with formula support (=A1+B2, =A1*B2, =SUM), system tray integration, and one-click Excel export. No installation required.
Author Archives: DIYAccountant
Legal Email Discovery Tool — Search Your Email Archive, Export to PDF
A free Windows tool for searching MBOX email archives from Gmail Takeout, Thunderbird, and Apple Mail. Filter by keyword, sender, date range, or subject — and export results to Excel. No Python required.
Automate or Fix? Here’s How I Actually Decide
A CFO and CA CPA’s practical framework for deciding when to automate a business process vs. fix it first. Includes a real Power Automate and Business Central example that saved 80% of AP data entry time at zero cost.
PowerBI Data Gateway: Fixing Microsoft 365 Datasource Credential Errors
Fix Microsoft 365 domain authentication errors in the PowerBI Data Gateway. Use the azuread format for your username when standard credentials fail. Free fix, no plugins required.
How to Connect Power Automate to Business Central Web Services Using oAuth2.0
Connect Power Automate to Business Central Web Services using oAuth2.0. Full step-by-step guide including Azure AD app registration, bearer token authentication, and Parse JSON workaround.
How to Access Business Central Tables in Power Automate Using OData
How to read Business Central table data in Power Automate using the HTTP connector and OData API. Step-by-step walkthrough with real examples from a working implementation.
PowerBI Master Calendar Script: A Complete Date Table for Power Query
A complete PowerBI master calendar script for Power Query. Generates a full date table for time intelligence calculations — copy, paste, and adapt to your data model.
Foreign Exchange Rates in Business Central: Using the Built-In Currency API
How to set up and automate foreign exchange rate tables in Microsoft Dynamics 365 Business Central using the built-in currency exchange API. No third-party tools required.
Woodworking: Coffee Table Built from WW2-Era Reclaimed Wood
How I turned a century-old rotting piece of wood into a coffee table. A woodworking project that proves the best materials are the ones others would throw away.
How to Query Business Central Tables Using PowerShell
Query Business Central tables directly using PowerShell. A practical guide to accessing Business Central data programmatically — no UI required, no consultant needed.