Along the way, I’ll also demystify double-entry (or dual-entry) accounting. I’ll discuss the difference between cash basis and accrual accounting. These are the most basic forms of accounting, and you can perform any of them by using Excel. There’s even a world championship in Microsoft Office applications. You can perform near miracles using Excel spreadsheets. So take a deep breath, brace yourself, and let’s run the numbers. Whether you’re a full-time small-business owner or an employee with your own side business, you can find the tools you need in Excel. accrual-basis accounting and the double-entry method.But Excel accounting for small business doesn’t require you to be one either.Īll you need is a brief orientation and some useful templates and formulas. I won’t pretend that I’ve transformed into a number-loving accounting superstar. The mention of double-entry bookkeeping used to put me to sleep - and then give me stress nightmares. Megan Smith Last Modified: Novem18 min read