990 WASHINGTON ST, SUITE 102, DEDHAM, MA

INFO@SIEGELSOLUTIONS.COM

Facebook icon linkedin icon X icon Instagram icon youtube icon

22 May Turn Your QuickBooks Data into Better Business Decisions

Posted at 21:39h in Blog by

In this edition of EdTalks, I’d like to review some of the ways that business owners can glean valuable business intelligence out of their QuickBooks financial data. If you use QuickBooks Online (QBO) to run your business, you already have powerful financial data at your fingertips. But reports alone don’t drive improvement—understanding what the numbers mean is what helps you make smarter decisions.

Want better visibility into the numbers driving your business? Connect with Siegel Solutions to learn how we can help you turn QuickBooks data into meaningful insights. 

By looking at a few simple financial metrics, you can spot cash flow issues, improve profitability, and run a more efficient operation. Below are some easy ways to turn your QuickBooks data into meaningful insights.

ACCOUNTS RECEIVABLE TURNOVER

I love turnover ratios; they tell a story.  By making a tweak to the turnover ratio you can see a Days Outstanding measure which can be very revealing.  This example measures how quickly your customers pay you:

Formula: Net Credit Sales ÷ Average Accounts Receivable

Example: If you generate $1,200,000 in sales and carry an average A/R balance of $180,000, your turnover is 6.67 times per year (1,200,000 ÷ 180,000 = 6.67).

That means it takes about 55 days to get paid (365 ÷ 6.67 = 54.7), called Days Sales Outstanding (DSO).

Why it matters: If your terms are Net 30 but you’re collecting in 55 days, your cash flow is slower than expected. Consider tightening payment terms or using online payment tools.

QuickBooks Tip: Use the Accounts Receivable Aging Summary to identify slow-paying customers and target collections efforts.

INVENTORY TURNOVER

This measures how quickly you sell your inventory.

Formula: Cost of Goods Sold ÷ Average Inventory

Example: With $800,000 in COGS and $150,000 in average inventory, your inventory turnover is 5.33 times per year (800,000 ÷ 150,000 = 5.33).

That means inventory sits on your shelves in your warehouse about 68 days before selling (365 ÷ 5.33 = 68.5), called Days Inventory Outstanding (DIO).

Why it matters: Slow turnover can tie up cash and indicate overstocking or obsolete products. 

QuickBooks Tip: Review the Inventory Valuation Report in QBO to identify slow-moving items.  Look at inventory turnover for specific products or product lines.

GROSS PROFIT MARGIN

This shows how much money you have available to cover overhead and yield a profit after covering product or service costs.

Formula: (Revenue – Cost of Goods Sold) ÷ Revenue

Example: If you earn $1,200,000 in revenue and $800,000 in costs, your margin is 33% ((1,200,000 – 800,000) ÷ 1,200,000 = 33%).

Why it matters: Declining margins may indicate rising costs or pricing issues.

CURRENT RATIO

This measures your short-term financial health.

Formula: Current Assets ÷ Current Liabilities

A ratio above 1.0 generally means you can cover your short-term obligations.

Why it matters: A ratio below 1.0 and/or downward trends indicate potential cash flow concerns.

HOW TO USE THESE INSIGHTS

Numbers alone don’t tell the story — interpretation does.  You need to look at not the raw numbers themselves, but in the context of annual or monthly trends, benchmarking to industry averages or competitors, internal targets, seasonal cycles, and other influencing factors impacting your business.

  • Compare results month-to-month to spot trends
  • Watch for early warning signs of cash flow problems
  • Focus on areas that can improve profitability
  • Use QuickBooks reports like A/R Aging and Inventory Valuation to dig deeper

FINAL THOUGHT

QuickBooks is more than a bookkeeping tool—it’s a decision-making tool. By reviewing these simple metrics regularly, you can better manage cash flow, control costs, and grow your business with confidence.  

Contact Siegel Solutions to help you with preparing a monthly KPI (key performance indicator) dashboard with the insights and timely analysis to:

  • Improve cash flow 
  • Optimize operations 
  • Make data-driven decisions


If you are ready to build a clearer KPI dashboard and make more informed decisions with your QuickBooks data, visit our contact page to get in touch!

Print page


Antonio Tony Martinez
Senior Partner Development Manager

Tony brings over 15 years of QuickBooks knowledge with him and has been recognized as a top performer year over year. Tony will play a critical role in helping our team grow your QB business by managing the relationship between Siegel Solutions and the QuickBooks Solution Provider Program. Tony is focused on optimizing results for strategic partners of all shapes and sizes.

This will close in 0 seconds

Noah

Noah Raney
Senior Account Payroll Manager

Noah is our dedicated Intuit Senior Account Payroll Manager who can help you find the right payroll solution for you and your business. He is well versed in all of the QuickBooks platforms being desktop/online/standalone and payroll has been his world since joining Intuit 13 years ago. Whether you are looking for ways to save on time, reduce inflated payroll costs or just get set up with the best discounts, he is here to help. Your success and satisfaction are of utmost importance!

This will close in 0 seconds

Sean

Sean McCaffery
Global Channel Sales Partnerships and Alliances Leader

Sean McCaffery has more than 15 years of experience leading channel sales and cloud solutions in the US and Internationally. Sean has held leadership positions with Avaya in Europe growing the channel business with resellers and distributors in key countries driving double-digit growth. He then joined Rackspace Technology and was instrumental in developing sales growth strategies in cloud adoption for customers and partners. Most recently, he ran channels at Dizzion responsible for dynamically growing and expanding the partner ecosystem through SaaS-based VDI solutions before joining Intuit. Currently, he runs the QuickBooks Solution Provider Program supporting the strong business that solution providers and ISV partners have established as well as finding new opportunities to drive emerging mid-market growth together!

This will close in 0 seconds

Gabor

Gabor Terebesi
Payments Account Manager

Gabor Terebesi is an Account Manager with the Payments Team of Intuit for over 15 years. He works in the partner division for Intuit payments to ensure Intuit partners along with any clients of theirs are in the most suitable and financially cost-effective solution accepting payments through eCommerce, QuickBooks, mobile payments, or any other options necessary for their business.

This will close in 0 seconds

Aimee Garneau
Manager of Accounting Services

Aimee joined Siegel in 2022 as the Accounting Manager overseeing the accounting and bookkeeping team. Aimee brings 18 years of experience with increased responsibility with privately and publicly held companies. Her experience lies with SaaS-based companies as well as in healthcare, consulting, education and nonprofits. Prior to joining Siegel, she held accounting leadership positions with Waban Projects, Elastic Path, Moltin, and Ned Davis Research. Aimee loves partnering with business owners to establish financial reporting and results that promote growth and expansion. When Aimee is not working, she loves spending time with her family and friends and exploring all New England has to offer. She is also an avid Red Sox fan and enjoys going to Fenway Park when she can.

This will close in 0 seconds

Jeffrey Siegel
CPA, CEO

Jeff has spent the last twenty years working providing solutions to emerging growth businesses. After graduating from Northeastern University, he spent five years working with two multinational CPA firms in an auditor capacity building a foundation for understanding how business work. He later went on to work in various controller and CFO roles before starting Siegel & Associates (previously Siegel Financial Group) in 2000. In those roles, he sold a company to ADP, raised funds for a major expansion of a large regional IVF clinic, and helped set up accounting and financial structures for dozens of companies. Since starting Siegel & Associates, Jeff has worked with hundreds of clients providing accounting system solutions. Those solutions include setting up QuickBooks in a single-user environment putting in QuickBooks Enterprise in a 30-user environment and integrating various add-ons including inventory, CRM, and e-commerce. He is a Certified Public Accountant, a QuickBooks Pro Advisor, a QuickBooks Advanced Pro Advisor, and an Intuit Solution Provider certified in Enterprise Solutions, Point of Sale & QuickBase. Jeff is also a Microsoft Certified Systems Engineer

This will close in 0 seconds

Lori Swartz
Client Solutions Advisor & Professional Services

After graduating from Boston University, Lori spent eight years working in various managerial positions for two national companies. In those positions, Lori developed the skills necessary to manage multiple projects, clients, and resources. She later went on to work for a management company that handled over 25 real estate properties with multiple tenants. Lori joined Siegel Solutions in 2003 as a client services manager where she utilized her skills developed to manage multiple clients and multiple staff. She recently moved into the client support manager role where she is responsible for meeting with and onboarding new clients, managing and maintaining our technology stack along with QuickBooks setups, conversions, training, and consulting.

In her free time, Lori enjoys spending time with her family. She loves to travel, music, and theater.

This will close in 0 seconds

Janet Jodoin
Bookkeeping Associate

Janet joined Siegel Solutions in May of 2022 as an Associate Bookkeeper. In her younger years, while raising her family, she completed her degree in Business and she spent 20 years in the trades as a custom designer. Janet also has 16 years in corporate management. Her strong team support, training, and development led her to support and manage Human Resources. Janet's desire to change careers has led her to return back to bookkeeping at Siegel Solutions. In Janet's free time she enjoys spending time with her growing family. Her personal favorite is creative landscaping in her yard. She also enjoys working alongside her partner in construction and remodeling.

This will close in 0 seconds

Ed Jaworski
Professional Services

With over 21 years of corporate experience at PeopleSoft Consulting, Sun Life Financial, and KPMG, Ed brings a big business approach to small business solutions. Prior to joining Siegel Solutions in 2022, Ed helped small businesses get the most out of QuickBooks for 21 years as a co-founder of SMB Partners and the founder of Solutions for Office Software.

Ed is an Advanced Certified QuickBooks® ProAdvisor, a Certified QuickBooks® Point of Sale ProAdvisor, a Certified QuickBooks Enterprise Solutions ProAdvisor, and a Certified SOS Inventory Consultant. Ed holds an MS in Computer Information Systems from Bentley University and a BS in Business Administration from Northeastern University.

This will close in 0 seconds

Debby Mono
Firm Administrator

Prior to joining Siegel Solutions in March 2023, Debby had been working in administrative and executive assistant roles for many years in various fields. Her extensive background in these positions has provided her with a range of skills and knowledge that are valuable in her new role as a Firm Administrator. She graduated from Suffolk University with a Bachelor's Degree.

Outside of work, Debby can be found at football fields or dojos cheering for her sons. She also enjoys hikes with her dog, Sawyer, reading, sports, and live music. She and her husband also love to entertain family and friends.

This will close in 0 seconds

Letitia Cote
Senior Associate

Letitia has an accounting degree and has been working in the Accounting/Bookkeeping industry for over 25 years. Tish is also an Acumatica Business Consultant. Outside of work, Tish has 4 grown children and 5 grandchildren, she loves to ski, hike, bike, and be outdoors. Tish has worked with Jeff for over 10 years.

This will close in 0 seconds

Andrea Alencar
Associate

Andrea graduated from Bridgewater State with a Bachelor's degree in Accounting. Andrea joined Siegel Solutions in 2022. Andrea has gained accounting experience working in various industries including a CPA firm, legal, hospitality, and telecommunications. Before coming to Siegel Solutions Andrea previously worked as a bookkeeper and staff accountant.

Andrea has 4 kids which keep her busy. Outside of work, Andrea enjoys spending time with her kids, being outside, cooking, and going to softball/baseball games.

This will close in 0 seconds

Mike Derrico
IT

I started my career in 1983 when I designed and built a device to share a computer program, written by the president of a local bank and his son, running on an Apple Lisa computer. The device allowed the large and expensive Lisa's computer to be shared with bank employees. With this program, and with my device, we started a company to market this unique solution to banks. At this point, computer networks were just starting to be used in businesses. I transitioned my efforts to providing support for migrating banking terminal/mainframe functions to the emerging Personal Computer networking platform. For the next decade, I worked with, and beta tested, numerous technologies to integrate the banking functions from dumb terminals into the now smart desktop computers. After working with a few small consulting firms, I started my own company focusing on providing I.T. support to SMBs. More recently I am now doing the exact opposite by helping customers migrate their PC applications and data from their local computers to The Cloud. A few years ago, I joined Siegel Solutions to add my years of I.T. experience to their firm.

In my spare time, I like to travel, fly my drone and, most importantly, spend time with my family. I also still enjoy tinkering with technology.

This will close in 0 seconds

Pat Jaworski
Associate

After spending most of her corporate career in the insurance industry, Pat joined a QuickBooks consulting firm providing bookkeeping services to several small companies. Late in 2022, that firm merged with Siegel Solutions, Inc., bringing Pat and her clients to the group. She provides services to clients in a variety of industries: fitness, construction, beauty, equine care, and medical billing, to name a few. She enjoys supporting her clients by keeping their financial records in good shape and allowing them to focus on growing their respective businesses.

Pat resides in the 495/MetroWest area with her husband Ed, daughter Abby and Duffy, their lovable, energetic golden retriever.

This will close in 0 seconds

John Brakey Campos

Senior Account
Payroll Manager

John has been with Intuit for over 18 years, serving in a variety of roles across the organization. For the past 8+ years, he has focused on payroll and workforce management solutions, helping clients streamline operations and make informed decisions. John is passionate about working directly with customers to understand their unique needs and recommend the best solutions to support their teams.

This will close in 0 seconds

Janice Kats

Associate

Janice Kats graduated from Carl Sandburg College with an Associate Degree in Accounting in 1992 and has been working in the accounting field ever since in various jobs doing AR, AP, payroll, office management, and bookkeeping before joining Siegel Solutions in late 2023.

In 2022, she made the decision to branch out on her own and started her own bookkeeping business, working from home.

She is a mom to 3 grown children and a grandmother to 5 grandchildren and enjoys spending time with her husband and two dogs and following her grandchildren in all of their sports.

This will close in 0 seconds

Cynthia Moncayo-Mena
Associate

Cynthia joined Siegel Solutions in March 2025 as an Associate. She has a Bachelor's in Accounting from New Jersey City University and over 10 years of experience in accounting.
She is married with two children and enjoys reading and exploring new places to visit!

This will close in 0 seconds

 

Melissa Boyan
Senior Associate

Melissa is originally from Orrington, ME (outside of Bangor). She attended Husson College and graduated with her BS in Accounting and MS in Business. She currently lives in Levant, ME, with her husband, son, and their pets. She has 2 dogs and 2 cats! Melissa enjoys playing the Tenor and Alto saxophones in a local band, as well as crafting, particularly learning how to knit and crochet. Additionally, she teaches accounting classes.

She joined Siegel Solutions as a part-time Senior Associate in December 2025.

This will close in 0 seconds

 

Matthew Galligan
Associate

Matthew Galligan is from Pembroke MA. He received his Undergrad Degree from Stonehill University and is taking classes to become eligible for the CPA exam. He has 2 dogs, Sully and Finn. Matt enjoys any Boston sports as well as ATVs, snowmobiling and golf.

He joined Siegel Solutions as an Associate in December 2025.

This will close in 0 seconds

 

Crystal Joson
Associate

When Crystal Joson joined Siegel Solutions as an Associate, she brought a strong foundation in accounting and auditing. Originally from the Philippines, Crystal earned her Bachelor of Science in Accountancy in 2020 and is a Certified Public Accountant as well as a QuickBooks Online Certified ProAdvisor, Levels 1 & 2.

She began her career in auditing, where attention to detail, accuracy, and problem-solving quickly became second nature. Prior to joining Siegel, she gained experience working as both an Audit Associate and Accountant. In her role at Siegel Solutions, Crystal supports clients through transaction recording, schedule maintenance, and monthly financial reporting.

Outside of work, Crystal enjoys watching anime series, reading manga, taking daily walks, and expressing her creativity through sketching and watercolor painting.

This will close in 0 seconds