From Error-Prone Spreadsheets to Financial Clarity for a Growing Art Collective

The Challenge

When Victoria Fry, owner of Visionary Art Collective, came to FM Bookkeeping, her finances were being managed the way many small creative businesses start out: a family member handling everything in Excel. For a while, it worked well enough. But as the business grew, the limitations of that approach became harder to ignore.

Manual spreadsheet entry brought with it a steady stream of human errors including fat-fingered numbers, mislabeled categories, and inaccurate totals. Over time, those small mistakes added up to a financial picture that could not be fully trusted. With a business structure that included multiple income streams, some taxable and some not, accuracy was not optional.

The challenges Victoria was facing included:

• Messy and incomplete records due to manual data entry errors
• Incorrect income figures and potential sales tax miscalculations
• No reliable visibility into what she was earning and spending across different areas of her business
• An Excel-based system that had simply outgrown her needs

‍

Why She Chose FM Bookkeeping

Victoria did not shop around. She trusted Mariel to make her books make sense and to build a system that reflected the real complexity of her business. With income spanning multiple categories and some revenue carrying different tax treatments, she needed more than basic bookkeeping. She needed someone who could track everything accurately and help her actually understand it.

The Solution

FM Bookkeeping transitioned Visionary Art Collective away from manual spreadsheets and into QuickBooks Online, creating a connected, accurate, and organized bookkeeping system. The ongoing monthly engagement included:

• Setting up QBO to connect directly to bank accounts for accurate, real-time transaction data
• Properly categorizing income across taxable and nontaxable revenue streams
• Reconciling accounts monthly to ensure clean, reliable data
• Producing monthly financial reports so Victoria can see exactly what she is earning and spending
• Coordinating with her accountant so quarterly sales tax filings are based on accurate numbers, not estimates

The Results

Before:

• Finances managed in Excel by a family member
• Human errors creating inaccurate income and sales tax figures
• No clear view of spending across different business categories
• Growing business with a financial system that could not keep up

After:

• Clean, accurate books maintained monthly in QuickBooks Online
• Reliable income and expense tracking across all business categories
• Accountant can file quarterly sales tax with confidence, no guesswork
• Victoria understands her finances well enough to make real decisions

Measurable Impact:

• Hours saved monthly by removing manual bookkeeping from Victoria's plate
• Sales tax accuracy restored, eliminating the risk of underpayment or overpayment
• Actionable financial data enabling decisions around cutting unnecessary expenses and increasing revenue