Skip to main content

STUDENT BLOG: Financial Tracking Made Easy

By Gabrianna Salvini, Student SBDC Consultant.

Gabrianna is a junior Finance major with an Analytics minor at Bucknell University. She serves as Vice President of Finance at Kappa Alpha Theta Fraternity, is an Online Intensive Program Scholar at Girls Who Invest, and and is an analyst at Bison Finance Society.


As a finance major and analytics minor, I spend much of my time working with data and using calculations and visuals to make more sense of the data. Even though they vary greatly in their business model, product mix, team structure, and more, there is one thing almost every business has in common – the desire to make money. There are many things small business owners can do to contribute to profitability, and a major one is accurate tracking. This very trivial concept can seem daunting as a new business owner, but it doesn’t have to be. There are metrics that can be easily tracked and still say a lot about the profitability of a business.

Sales

The first (which may seem obvious) is sales. Having a system for tracking sales is key to staying on top of financials and noticing trends within a business. This can be done in a simple Excel spreadsheet or, if it makes sense within the business model, a point-of-sale system. A popular POS system with small businesses is Square, but there are many options. These systems take the load off of business owners by automatically keeping track of inventory and sales in real time as transactions go through. But, as mentioned before, it is very feasible for many businesses to simply keep track of sales in an Excel spreadsheet, which is just as effective.

COGS

Sales is only the start of evaluating how profitable a business is. The next metric to keep an eye on is the cost of making products or services and getting them to customers, aka Cost of Goods Sold. With inflation and changing economic conditions, prices of product inputs can rise and affect gross profit. This is important to note and also easy to track on Excel. Tracking how much supplies for products are costing and even scaling it down per product rather than the overall bulk order price is helpful to compare with sales. It allows a business owner to see how much profit each product is making (aside from other miscellaneous expenses) and can even raise red flags if price is too low compared to cost of production. I have actually worked with a client on an Excel spreadsheet before to track costs of their inputs and calculate how much to charge for each product in order to make a profit. It made all the difference in taking their pricing from being backed by guesswork to real data.

Operating Expenses

The next natural step is recording operating expenses. This may seem like a complicated term, but it essentially refers to all expenses that go into running the business other than COGS and taxes. This can include rent, utilities, payroll, insurance, and more. These expenses can easily creep up on profitability if not kept in check and can also help inform pricing of products. Tracking all expenses helps business owners to be aware of how much usable cash they are actually generating from all of their sales.

Break Even

The last critical piece this information can and should be used for is calculating the break-even point. Break-even is the number of products a business needs to sell before they start making profit. This accounts for all of the overhead required to start operations and ongoing expenses. The break-even point is a great initial goal to set for sales and profit targets.

Budgeting

This method of tracking holds businesses accountable in real time, but a smart proactive measure to take is to set a budget. This can be monthly, yearly, quarterly, or any time period that makes sense within the business context. Being able to compare your initial budget to what you actually spent in each area helps to allocate funds better each time a new budget is created. In my role as VP of Finance in my sorority, a major focus is setting a budget each year, with funds allocated to many different officer positions and events, and then tracking how much of the budget is actually spent in each area. This helps the next VPF to make a budget for the next year that better aligns with the chapter’s financial needs. Keeping track of finances, especially as a new business owner, can be daunting. But with a simple Excel spreadsheet and these few metrics, it can be simple to record sales and expenses, analyze profitability, and set sales targets. Budgeting ahead of time is a smart planning strategy that can help increase confidence and organization going into each sales period. These simple efforts can make all the difference in how efficiently and effectively a business is run.

The Bucknell SBDC offers confidential, no-cost one-on-one consulting to help you make sense of your numbers and set up a data tracking process that works best for your unique small business. Sign up today to schedule one-on-one business consulting.

Comments are closed.