Practical guides for accountants — Excel techniques, reconciliation workflows, custom functions, and how to get the most out of tech+bash.
Self-serve tools and AI assistants handle the standard cases. This guide explains what bespoke data processing covers — and why the non-standard cases are often the ones that matter most.
Excel's RANDBETWEEN recalculates every time the sheet changes, making it unreliable for any situation where you need to reproduce a result later. TB.STATICRANDBETWEEN calculates once and stays fixed.
Python is becoming a genuine professional edge in accounting and audit. This guide explains what it can do for you, where to start, and why structured coaching beats self-teaching for most professionals.
AI tools are changing how accounting and finance work gets done. tech+bash helps teams understand where AI genuinely helps, where it doesn't, and how to build the skills to use it well.
AI tools can write formulas and automate tasks, but the accountants who use them most effectively are the ones who understand Excel deeply. Here's why strong Excel skills matter more now, not less.
Much of the data accounting and finance teams need exists online or in external platforms — but pulling it by hand doesn't scale. This guide explains what programmatic data gathering makes possible.
When you have exports from multiple systems, entities, or clients in different formats, consolidating them manually doesn't scale. This guide explains what a data consolidation job looks like and when it makes sense to outsource it.
AI can extract structured data from invoices, bank statements, and PDFs at scale. This guide explains how it works, where it's reliable, and why the accounting context matters more than the technology.
Excel has no built-in way to aggregate cells based on their fill colour. The tech+bash Aggregate by Colour app fills that gap — pick a reference colour, choose a formula, get the result.
A practical walkthrough of the subset-sum reconciliation problem — what it is, why Excel can't solve it natively, and how the tech+bash Reconciler handles it in seconds.
Every accountant knows the calculation, but Excel has no dedicated formula for it. Here's how TB.GROSSUP and TB.GROSSDOWN work — and the common mistake that makes a gross-down wrong.
