Tracking your cash in and cash out is an important part of running your business. Learn how to calculate the flow.
Discover the essential skill of calculating cash flow for your small business. This comprehensive guide provides a simple, step-by-step process to help you understand and manage your business’s financial health effectively. Learn how to take control of your cash flow and strengthen the financial foundation of your small business.
Tracking your cash flow is a crucial step toward establishing a healthy small business. Unless you’re a former bookkeeper, the task might seem daunting, but the actual equation is relatively simple: Cash in minus cash out.
Richard Schwartz, a registered tax return preparer and owner of Schwartz Accounting & Tax in Denver, recommends using software such as QuickBooks to stay organized. However, if you’re looking for a straightforward approach to tracking your cash flow — and dont have experience with accounting or bookkeeping — a simple spreadsheet will get the job done.
If you’re using credit cards or cash-flow loans to help stretch your capital, it’s even more important to stay organized.
Table of Contents
How to calculate business cash flow
To start, list the months of the year side by side across the top of your spreadsheet. (We made the calculations below in Microsoft Excel.) Then use the left side for a running list of your cash assets and cash expenses.
Your cash assets will include the starting balance in your bank account and monthly income, such as sales and interest. For example, say you started the year with $10,000. In January, you made $3,000. Add the two together to get a total cash balance of $13,000.
Your most regular cash expenses will probably be rent a
Let’s say your rent is $2,000, and your monthly credit card payment is $400. You know you’ll be on the hook for $2,400 each month. But maybe you had to pay back a relative who loaned you $300 to fix your computer and you opted to pay your $250 utility bill in cash. (Right now youre only tracking your cash flow, so you dont need to include expenses youve financed with a credit card). Add them together, and you have total cash expenditures of $2,950 for the month.
Now, refer back to the original equation: cash in minus cash out. Subtract your expenses from your total cash balance, and youre left with your monthly income.
This is the balance youll roll over to the next month, and the number you’ll use to determine how much money to stash away for taxes.
As you repeat the process each month, youll generate a comprehensive overview of your cash flow.
The more complex your business, the more complex your spreadsheet will be. But if you’re using Excel, you can rely on some of its features — such as automatically summing your totals and rolling over the balance each month — to keep you on track.
You can also choose another spreadsheet program, or even rely on a pencil and a notebook, if that makes you feel more comfortable.
Remember, warns Schwartz, cash flow is only part of the picture. Youll need to consider your overall liabilities, including credit card and loan balances, when determining whether youre profitable.
The bottom line on calculating your cash flow
Cash flow is just one element of your business operations, but tracking it is an important step in ensuring your success.
You can use financing to help your cash stretch further, Schwartz says. If you pay for everything in cash, you may run out of cash before your business has really had a chance to take off,” he says.
Find and compare small-business loans
NerdWallet has come up with a list of the best small-business loans to meet your needs and goals. We gauged lender trustworthiness, market scope and user experience, among other factors, and arranged them by categories that include your revenue and how long youve been in business.
Compare business loans
Thanks to Source
business cash flow
