You also have $600 in accounts receivable (including the Johnsons’ payment, which is due today) and $200 in accounts payable (which includes the invoice for the flowers). Let’s work through the above wedding-planner example with some simplified accrual accounting. You record credits on the right-hand side of accounts and use them to increase values on the right of the equation.‌ You record debits on the left-hand side of individual accounts and use debits to increase values on the left side of the equation. Instead of attaching an imaginary +/- sign to the words, attach a location to them. You also want to avoid associating credits with increases and debits with decreases. Try not to think about credits as good and debits as bad but as value-neutral accounting terms. Similarly, I don’t understand any of the coding behind Excel accounting. You don’t really need to understand how it works that way, just that it works that way. Still confused? Honestly, I only kind of get it, myself. You would debit your account.īecause business accounting is viewed through the lens of banking institutions, and they calculate debits and credits differently than you’re used to doing. Liabilities, equity, and revenue are increased with credits and decreased with debits.īut why? If you receive a huge cash payment, shouldn’t that credit your cash account? No.Assets and expenses are increased with debits and decreased with credits.Here’s the number one rule to remember in accrual accounting: You don’t have leftover electricity at the end of the month that you carry on as an asset going forward.Īnd now for something even more counterintuitive. So why aren’t expenses simply assets? Because they’re consumed in the ordinary operation of your business during an accounting period. In return, you get something - electricity - which goes on the left, balancing the equation.

The electric bill you need to pay is a liability and goes on the right side of the equation. Why do expenses belong with assets? Remember that these are not accounts payable/money that is still owed to others. This last part - how you increase your accounts - is the most confusing aspect of Excel for small businesses, and I’ll return to it momentarily.Īssets and expenses belong on the left side of a balance sheet (or balance equation), while liabilities, equity, and revenue belong on the right.

Create a list of all your accounts including what type of accounts they are and how you increase them. The first page of your Excel accounting workbook should be a chart of accounts. In addition to your balance sheet, you need to keep worksheets for each of the accounts included on it. In accrual accounting, you need more than a single ledger. Every time you increase or decrease one side of the equation, you need to do the same to the other. Double-entry accounting helps you ensure that you keep this equation balanced. This is where double-entry bookkeeping comes in.

Assets = Liabilities + Shareholders’ (or Owner’s) Equity.

The core principle of accrual accounting is the equation:

Instead of simply recording cash flow, accrual accounting requires you to record all your assets and liabilities. While cash basis accounting is simpler, many businesses prefer accrual accounting because it gives them a fuller, more accurate picture of their company’s finances. Accrual accounting and the double-entry method You then record the check you received from the Johnsons, increasing the balance to $1100. You record your payment to Rosa’s Roses first and decrease your account balance by $150 to $600. For each transaction, the account balance is updated accordingly. This cash basis accounting example shows two transactions: one credit and one debit. Your Excel accounting might look something like this:

You also need to collect a payment from the Johnson family. On that day, you need to pay the florist for the upcoming Johnson wedding. On July 8, 2021, you begin the day with $750 in your account. Your spreadsheet should have at least the following columns: But your fundamental accounting tracks money only when it changes hands. You can - and should - keep additional records of accounts payable (money you owe) and accounts receivable (money owed to you). Many small businesses prefer to use this system because of its simplicity. That’s all there is to cash basis accounting. They would regularly look over these lists to ensure that they always knew how much money they had available. They’d record income and expenses to their account. Once upon a time, people used to balance their checkbooks by hand. 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.

Simple debit credit excel spreadsheet