What to Do When Your QuickBooks Are a Mess

In Episode 33 of QuickBooks Mastery for Small Business Success, Erica Northrup and Lee Davis tackle a challenge many business owners eventually face: What should you do when your QuickBooks are a mess?

Listen to Episode 33!

Whether you’ve fallen behind on bookkeeping, inherited disorganized records, or simply aren’t confident that your financial reports are accurate, you’re not alone. The good news is that messy books can be cleaned up with the right process—and the experience can become an opportunity to improve your financial systems moving forward.

When Do Business Owners Realize There’s a Problem?

For many entrepreneurs, bookkeeping isn’t top of mind until someone else needs their financial information.

A common trigger is applying for financing.

Banks typically request financial reports such as:

Profit & Loss Statement
Balance Sheet

An Excel spreadsheet or a rough estimate usually isn’t enough. Lenders want accurate, professional financial reports that reflect the true financial condition of the business.

For many owners, that’s the moment they discover their QuickBooks records need attention.

You’re Not Alone

One of the first points Erica and Lee emphasize is simple but reassuring:

Don’t panic.

Many successful business owners have experienced bookkeeping problems at some point.

Falling behind doesn’t mean your business is failing—it simply means it’s time to develop a plan for getting your financial records back on track.

Start at the Beginning

When cleaning up QuickBooks, it’s tempting to jump directly into fixing individual transactions.

Instead, Lee recommends starting with the foundation.

In some situations, rebuilding accurate beginning balances through journal entries may be necessary before moving forward.

Having a solid starting point makes every step that follows much easier.

Review Your Chart of Accounts

The first place to evaluate is your Chart of Accounts.

A poorly designed chart of accounts creates problems throughout QuickBooks because every transaction depends on the categories established there.

Signs of trouble often appear on your:

Balance Sheet
Profit & Loss Statement

If accounts are missing, duplicated, or categorized incorrectly, your reports will not provide reliable information.

Taking time to organize your chart of accounts creates a stronger foundation for accurate bookkeeping.

Use Forms and Lists Correctly

Once the Chart of Accounts has been reviewed, the next step is making sure transactions are being entered using the proper QuickBooks forms.

Using the correct forms helps ensure that invoices, bills, payments, expenses, and deposits all flow correctly through the accounting system.

Accurate workflows reduce duplicate entries and produce more reliable financial reports.

Work With Your Accountant

Cleaning up QuickBooks doesn’t have to be a solo project.

Your accountant can often provide valuable information that serves as a starting point for rebuilding your books.

Helpful documents may include:

Fixed asset schedules
Depreciation schedules
Trial balances
Prior-year financial statements

These records provide important reference points and help ensure your cleanup begins with accurate information.

Gather Your Financial Documents

Once you’ve established a starting point, gather the documents needed to rebuild your records.

Important documents include:

Bank statements
Credit card statements
Loan statements
Equipment purchase information
Accounts receivable records

Having complete documentation makes it much easier to verify transactions and identify missing information.

Understand How You Get Paid

Another important part of the cleanup process is understanding how owner compensation should be recorded.

For many LLCs and sole proprietorships, owner compensation is recorded through Owner Draw, not payroll.

Recording owner payments correctly helps ensure both your Profit & Loss Statement and Balance Sheet accurately reflect the financial position of the business.

Should You Start Over?

Many frustrated business owners wonder whether it would be easier to create a brand-new QuickBooks company file.

According to Lee, the answer depends on your situation.

For businesses using QuickBooks Payroll, starting over may not be practical because payroll records are integrated into your accounting system and often need to remain intact.

In many cases, cleaning up the existing file is the better long-term solution.

Turn Cleanup Into a Learning Opportunity

One of the most valuable insights from this episode is that cleaning up your books shouldn’t simply fix past mistakes—it should prevent future ones.

Many bookkeeping problems happen because business owners were never taught how to use QuickBooks correctly.

As you clean up your records, take time to understand:

Why mistakes occurred
Which workflows need improvement
How transactions should be entered moving forward

Treating the cleanup process as training helps build confidence and reduces the likelihood of repeating the same errors.

Final Thoughts

Messy QuickBooks files can feel overwhelming, but they are fixable.

By starting with a solid foundation, organizing your Chart of Accounts, gathering the right financial documents, and working with trusted professionals when needed, you can rebuild confidence in your financial records.

Most importantly, don’t view bookkeeping cleanup as simply correcting the past. View it as an investment in the future of your business. The systems and knowledge you gain today will help you produce more accurate reports, make better business decisions, and avoid the same problems down the road.

As Erica Northrup and Lee Davis remind listeners throughout QuickBooks Mastery for Small Business Success, organized books aren’t just about compliance—they’re about creating clarity, confidence, and a stronger business.

Understanding QuickBooks Contractor Payments and Vendor Payments

In Episode 32 of QuickBooks Mastery for Small Business Success, Erica Northrup and Lee Davis explore one of the newer payment features in QuickBooks: Contractor Payments and Vendor Payments.

Listen to Episode 32

As more businesses move away from paper checks and manual payment processing, QuickBooks offers built-in tools that can simplify accounts payable while reducing the need to handle sensitive financial information.

However, understanding when to use each payment option—and how they differ—is essential for maintaining accurate records and protecting your business.

Why Consider QuickBooks Payments?

The conversation begins with a real-world example.

One of Lee’s clients had been experiencing ongoing problems printing paper checks. Rather than continuing to struggle with manual payments, Lee suggested using QuickBooks’ electronic payment tools.

After a vendor is invited through QuickBooks and completes the required information, payments can be made electronically, creating a faster and more efficient payment process.

For many businesses, this eliminates unnecessary paperwork while improving payment tracking.

Does QuickBooks File 1099s?

One question many business owners have is whether QuickBooks handles 1099 filing for eligible vendors.

According to Lee and Erica, QuickBooks can prepare and file federal 1099 forms for qualifying vendors and contractor payments when they meet IRS reporting requirements, such as payment thresholds and vendor eligibility.

However, some businesses still choose to work with an outside provider because certain state filing requirements may require additional processing.

Before year-end, it’s important to verify both your federal and state reporting obligations.

Protecting Sensitive Financial Information

One of the biggest advantages of using QuickBooks Vendor Payments is reducing the amount of sensitive financial information your business must collect and store.

Rather than requesting banking details directly from vendors, QuickBooks allows vendors to securely submit their own payment information.

This helps reduce the risk of:

Data entry errors
Mishandled banking information
Security concerns
Potential liability

For businesses handling multiple vendor payments each month, this added layer of security can provide valuable peace of mind.

Why Credit Card Security Matters

Erica and Lee also discuss the growing importance of payment security.

Many states have laws governing how businesses store sensitive payment information, and credit card fraud continues to be a significant concern.

The less sensitive payment information your business stores internally, the lower your overall risk.

Using secure payment platforms helps protect both your company and your vendors.

Contractor Payments vs. Vendor Payments

One of the most confusing topics covered in the episode is the distinction between Contractor Payments and Vendor Payments.

Although they appear similar, they serve different accounting purposes.

Contractor Payments

Contractor Payments are designed for independent contractors and payments that require tax reporting.

These payments are generally associated with contractor compensation and 1099 reporting.

Vendor Payments

Vendor Payments are intended for traditional accounts payable transactions.

These payments are connected to vendor bills and allow businesses to pay suppliers electronically without manually collecting banking information.

While there can be situations where the two payment methods overlap, understanding the purpose of each feature helps ensure transactions are recorded correctly.

Requesting Vendor Information

QuickBooks makes it easy to collect vendor payment information securely.

Within the Vendor profile, users can send a request asking the vendor to complete their payment details.

Allowing vendors to enter their own information reduces the likelihood of mistakes and improves data security.

Paying Vendors by ACH

If your business plans to pay vendors electronically through ACH, there are a few important steps to follow.

Be sure to:

Verify that the vendor’s payment information is current.
Enter the vendor bill in QuickBooks.
Process the payment through the appropriate QuickBooks payment option.
Monitor the payment status within QuickBooks.

Following a consistent workflow helps ensure payments are processed accurately and on time.

Preparing for 1099 Season

Even with QuickBooks handling much of the process, year-end preparation is still important.

Erica and Lee recommend:

Confirming vendor information is complete.
Verifying taxpayer identification information.
Ensuring payments are categorized correctly.
Reviewing your 1099 process well before filing deadlines.

Some businesses may also benefit from working with a third-party provider if additional state filing requirements apply.

Common Mistakes to Avoid

The episode highlights several common misunderstandings:

Assuming Contractor Payments and Vendor Payments are the same feature.
Choosing the wrong payment workflow for a transaction.
Failing to verify subscription features before implementation.
Waiting until year-end to collect vendor information.

Taking time to understand these tools upfront can prevent significant administrative work later.

Check Your QuickBooks Subscription

Not every QuickBooks subscription includes the same payment features.

If you’re unsure what capabilities are available in your account, navigate to the Gear icon and review your current subscription and available services.

Understanding what’s included in your plan helps you take full advantage of the tools available to your business.

Final Thoughts

Electronic payment tools continue to make bookkeeping more efficient, secure, and accurate.

Whether you’re paying vendors, managing contractors, or preparing for 1099 season, QuickBooks offers features that can simplify the process while reducing the need to handle sensitive financial information.

As Erica Northrup and Lee Davis emphasize throughout QuickBooks Mastery for Small Business Success, choosing the right payment workflow—and understanding how it works—can help your business save time, stay compliant, and build more efficient financial systems.

If you liked the podcast, you will like our training course. Click on the link below to join our upcoming course.

Join our Zoom Class

How QuickBooks Turns Everyday Transactions into Meaningful Financial Reports

In Episode 28 of QuickBooks Mastery for Small Business Success, Lee Davis and Erica Northrup explain how every transaction entered into QuickBooks ultimately becomes part of your financial reports.

For many business owners, reports like the Profit & Loss Statement and Balance Sheet seem to appear automatically. However, those reports are only as accurate as the transactions and categories behind them.

Understanding how QuickBooks builds your reports can help you identify mistakes before they become costly problems.

Quickbooks Mastery for Small Business Success

Listen

It All Begins with the Chart of Accounts

Every financial report in QuickBooks starts with your Chart of Accounts.

When you first create a QuickBooks company file, the software includes several standard accounts. From there, you should customize the chart of accounts to fit your business.

Erica and Lee recommend starting with the basics and then adding industry-specific accounts as needed. One helpful guide is your Schedule C, which can help organize income and expense categories appropriately.

The chart of accounts is the foundation of your bookkeeping. Every transaction you enter is assigned to one of these categories, and those categories determine where information appears on your financial statements.

Income Categories Matter

Income is more than just one number.

Many businesses have multiple sources of revenue, such as:

Product sales
Service income
Other revenue streams

Creating appropriate income categories allows you to understand exactly where your revenue is coming from and which parts of your business are the most profitable.

Cost of Goods Sold Helps You Price Correctly

Another critical category is Cost of Goods Sold (COGS).

This includes the direct costs associated with producing your products or delivering your services, such as materials and direct labor.

Tracking COGS accurately allows you to:

Calculate gross profit
Understand profit margins
Set profitable pricing

Without accurate Cost of Goods Sold, it’s difficult to know whether your business is truly making money.

What Appears on the Balance Sheet?

Unlike the Profit & Loss Statement, which measures performance over a period of time, the Balance Sheet provides a snapshot of your business at a specific moment.

The Balance Sheet includes:

Assets
Liabilities
Owner Equity

Together, these categories show what your business owns, what it owes, and what belongs to the owner.

Correct Amount, Wrong Category = Wrong Report

One of the most important lessons from this episode is that accuracy isn’t just about entering the correct dollar amount.

If a transaction is placed in the wrong category, your financial reports will still be wrong.

For example, a payment recorded as an expense instead of a liability may have the correct amount, but it produces misleading financial statements.

Proper categorization is just as important as entering the transaction itself.

Loan Payments Require Special Attention

Loan payments are a common source of bookkeeping mistakes.

Many business owners record the entire payment as an expense.

In reality, a loan payment typically includes:

Principal
Interest

Only the interest portion is generally deductible as a business expense.

The principal reduces the loan balance, which appears on the Balance Sheet.

Failing to separate these amounts can affect both your financial reports and your tax deductions.

Owner Draw Is Not an Expense

For LLC owners, compensation is often taken through an Owner Draw.

An Owner Draw:

Reduces owner equity
Does not appear as a business expense
Is not tax deductible as an operating expense

Misclassifying Owner Draw as an expense can significantly distort your Profit & Loss Statement.

Equipment Belongs on the Balance Sheet

Large equipment purchases should generally be recorded as assets.

Rather than immediately becoming an expense, equipment appears on the Balance Sheet and is typically depreciated over time.

Recording equipment correctly provides a more accurate picture of both your assets and your long-term financial position.

What Builds the Profit & Loss Statement?

Your Profit & Loss Statement is built from the daily transactions you enter into QuickBooks.

These include:

Invoices
Sales Receipts
Bills
Expense forms
Payroll costs
Credit card transactions

Together, these transactions produce the information used to calculate:

Income
Cost of Goods Sold
Expenses
Net Profit

This is why accurate data entry is so important.

What Affects the Balance Sheet?

Several everyday transactions contribute directly to your Balance Sheet, including:

Bank account balances
Credit cards
Loans
Accounts Receivable
Owner Equity
Owner Draw

These accounts work together to provide a snapshot of your company’s financial health at a specific point in time.

Your Balance Sheet Can Reveal Hidden Problems

Many business owners focus primarily on the Profit & Loss Statement.

However, Erica and Lee point out that the Balance Sheet often reveals issues that aren’t immediately visible elsewhere.

Unexpected balances in loans, accounts receivable, owner equity, or bank accounts can indicate bookkeeping errors that need attention.

Reviewing both reports together provides a more complete picture of your business.

Watch Out for Bank Feed Errors

While the QuickBooks Bank Feed can save time, it isn’t perfect.

QuickBooks may recommend categories that are incorrect for your business.

Automatically accepting those recommendations without reviewing them can lead to inaccurate financial reports.

Automation should support your bookkeeping—not replace careful review.

How to Verify Your Reports

To ensure your reports are accurate, Erica and Lee recommend a few simple habits:

Reconcile your accounts regularly.
Review large or unusual transactions.
Verify that transactions are categorized correctly.
Compare your reports month over month to identify unexpected changes.

Regular review helps catch small mistakes before they become major accounting problems.

Final Thoughts

QuickBooks doesn’t create financial reports out of thin air. Every report is built from the transactions you enter and the categories you assign.

By maintaining a well-organized Chart of Accounts, categorizing transactions correctly, and reviewing your reports consistently, you’ll gain financial information you can trust.

As Lee Davis and Erica Northrup emphasize throughout QuickBooks Mastery for Small Business Success, understanding how QuickBooks transforms daily transactions into financial reports empowers business owners to make better decisions, avoid costly mistakes, and build stronger businesses.

How Your Daily QuickBooks Work Impacts Your Financial Reports

In Episode 27 of QuickBooks Mastery for Small Business Success, Lee Davis and Erica Northrup explain an important truth that every business owner should understand: your financial reports are only as accurate as the information you enter into QuickBooks.

Many business owners assume QuickBooks will automatically produce accurate reports. While the software is incredibly powerful, it can only organize the information it receives. If transactions are entered incorrectly—or the wrong forms are used—your reports won’t accurately reflect your business.

That’s why having consistent systems and workflows is so important.

Listen!

QuickBooks Is Only as Reliable as Your Data

QuickBooks doesn’t make accounting decisions for you. It simply records the information you provide.

To produce reliable financial reports, you need a system that ensures transactions are entered accurately every time.

Start by asking yourself a few important questions:

How are invoices being handled?
How are bills being entered and paid?
Are employees following the same process every time?

Consistency is the foundation of reliable bookkeeping.

It All Starts with the Right Form

Throughout this podcast series, Erica and Lee have emphasized one key principle:

Use the correct QuickBooks form.

Every form is designed for a specific type of transaction. When you choose the correct form, QuickBooks automatically posts the information to the proper accounts.

That process begins with a properly designed Chart of Accounts.

When the chart of accounts and forms work together, your financial reports become much more reliable.

The Questions QuickBooks Asks

Behind every transaction, QuickBooks is collecting information to determine where that transaction belongs. Erica and Lee explain six important questions the software answers.

1. Who Is the Transaction Connected To?

Every transaction should be connected to the appropriate record.

That could include:

A customer
A vendor
An employee

Maintaining complete records is essential.

For customers, a complete customer file helps track invoices, payments, and outstanding balances.

For vendors, complete records are especially important for year-end reporting, including collecting W-9 forms and preparing 1099s when required.

Employee records should also be complete and include all necessary payroll documentation.

2. What Type of Transaction Is It?

QuickBooks uses different forms for different business activities.

These include:

Invoices
Sales Receipts
Checks
Expense forms
Deposits
Journal Entries
Payroll transactions

Each serves a different purpose.

For example, invoices begin the sales cycle, while Sales Receipts work well when payment is received immediately.

Deposits typically work from Undeposited Funds, while Journal Entries are often reserved for year-end adjustments or more complex accounting transactions, such as recording vehicle purchases or loan balances.

Many businesses also use payroll services, such as Paychex, to simplify payroll processing.

3. What Account or Category Does It Belong To?

Correct categorization is one of the most important parts of bookkeeping.

Every transaction should be assigned to the proper account.

For example:

Cost of Goods Sold should accurately reflect direct costs.
Expenses should be categorized consistently.
Your Schedule C can be a helpful guide when organizing expense accounts.

Incorrect categorization leads to inaccurate reports and poor business decisions.

4. When Did the Transaction Occur?

Timing matters.

Invoices should be sent promptly and consistently.

Lee recommends invoicing on a regular schedule—such as twice each week—to improve cash flow and keep Accounts Receivable current.

5. Has Money Actually Changed Hands?

QuickBooks also needs to know whether payment has been received or made.

For example, if you create an invoice but never record the customer’s payment, your Accounts Receivable will remain inaccurate.

The same principle applies to vendor bills.

Understanding where money is in the process helps produce accurate financial reports.

6. Should the Transaction Be Matched?

Whenever possible, transactions should be matched instead of added again.

Matching bank feed transactions to existing records helps prevent duplicate entries and keeps your books accurate.

How Using the Wrong Form Creates Problems

Choosing the wrong QuickBooks form affects much more than a single transaction.

For example:

If you skip the Receive Payment form and create a deposit instead, the customer’s invoice remains unpaid, even though the money was received.
If you enter a bill and later write a check instead of using Pay Bills, you’ll likely duplicate the transaction.

Small mistakes like these can ripple throughout your bookkeeping and create inaccurate financial reports.

Why It Matters

Ultimately, your reports are only as good as the data behind them.

Using the correct forms, maintaining organized customer and vendor files, categorizing transactions correctly, and following consistent workflows all contribute to financial reports you can trust.

Reliable reports help business owners make better decisions about pricing, hiring, budgeting, taxes, and growth.

Final Thoughts

QuickBooks is a powerful accounting tool, but it isn’t automatic. It depends on good processes and accurate data.

By understanding how transactions flow through the software and consistently using the correct forms, you’ll build financial reports that truly reflect your business.

As Erica Northrup and Lee Davis emphasize throughout QuickBooks Mastery for Small Business Success, accurate bookkeeping isn’t just about staying organized—it’s about giving yourself the confidence to make informed business decisions and build a stronger, more successful company.

Basic Accounting for QuickBooks Part 2

Connecting Basic Accounting to QuickBooks: Put Your Accounting 101 to Use

In this episode of QuickBooks Mastery for Small Business Success, Lee Davis and Erica Northrup build on the accounting concepts discussed in the previous episode and explain how those concepts connect directly to QuickBooks.

Listen!

Many business owners understand some basic accounting terminology, but they struggle to apply that knowledge inside QuickBooks. According to Lee, part of the challenge is that QuickBooks uses its own terminology and workflows, which can make the software feel overwhelming.

Everything Starts With the Chart of Accounts

At the center of QuickBooks is the Chart of Accounts.

This is where all of your:

Assets
Liabilities
Income
Cost of Goods Sold
Expenses
Equity accounts

are organized and tracked.

The chart of accounts forms the foundation for your bookkeeping and reporting. If it’s not structured correctly, your financial reports will not be accurate.

Common Problems With the Chart of Accounts

Erica and Lee highlight several issues they frequently see when reviewing client books.

Too Many Accounts

One common mistake is creating far too many accounts.

This can make reports:

Difficult to read
Inconsistent
Harder to analyze

A practical solution is to use your Schedule C as a guide for categorizing transactions.

Duplicate Accounts

Duplicate accounts create confusion and inconsistent reporting.

For example:

Multiple office supply accounts
Several versions of the same expense category

Keeping a master list of accounts helps maintain consistency and avoid duplication.

Mixing Personal and Business Expenses

Another common problem is blending personal and business spending together.

This makes:

Tax preparation more difficult
Reporting less reliable
Financial analysis less accurate

Keeping personal expenses separate is essential for clean bookkeeping.

Misclassifying Owner’s Draw

Many business owners incorrectly categorize Owner’s Draw as a business expense.

However, an Owner’s Draw is part of equity—not an expense.

Misclassifying owner compensation can distort your Profit & Loss Statement and create confusion during tax preparation.

Payroll Setup Problems

Payroll is another area where errors frequently occur.

According to Erica and Lee, payroll is often handled incorrectly because users misunderstand how payroll-related liabilities and expenses should be tracked.

Improper payroll setup can affect:

Tax reporting
Payroll liabilities
Financial statements

Incorrect Loan Setup

Loans must also be structured correctly in QuickBooks.

If loan accounts are not properly configured:

Principal and interest may be combined incorrectly
Liabilities may not appear accurately
Businesses could miss valuable deductions

Proper setup ensures your reports accurately reflect both debt and expenses.

Categories Are the Backbone of Bookkeeping

One of the key themes of this episode is that categories drive everything in QuickBooks.

If transactions are categorized incorrectly:

Reports become unreliable
Profitability becomes harder to measure
Decision-making becomes more difficult

Clean categorization creates clearer financial visibility.

Where Expenses Show Up

Expenses appear primarily on the Profit & Loss Statement.

In QuickBooks, expenses are typically created through forms such as:

Bills
Expenses
Checks

Using the correct form helps ensure accurate reporting.

Where Income Shows Up

Income also appears on the Profit & Loss Statement.

Income is generally created through:

Invoices
Sales receipts
Customer payments

Businesses may separate income into categories such as:

Services
Products
Other revenue streams

Breaking income down properly provides better insight into profitability.

Where Liabilities Show Up

Liabilities appear on the Balance Sheet.

Common liabilities include:

Credit cards
Loans
Lines of credit
Accounts payable

These accounts represent money the business owes.

Understanding Equity

Equity accounts may include:

Owner’s Draw
Retained Earnings
Owner Contributions
Current Year Profit

Equity reflects the owner’s financial interest in the business after liabilities are considered.

What Appears on the Balance Sheet But Not the Profit & Loss?

Some financial information appears on the Balance Sheet but not on the Profit & Loss Statement.

Examples include:

Cash
Accounts receivable
Debt
Accounts payable

That’s because the Balance Sheet focuses on the overall financial position of the business—not just income and expenses.

Understanding the Balance Sheet

The Balance Sheet is a snapshot of the business at a specific moment in time.

It shows:

Assets
Liabilities
Owner Equity

Together, these numbers help business owners understand what the business owns, owes, and is worth.

Final Thoughts

With this episode, Erica and Lee connected what we learned in the last podcast on basic accounting to QuickBooks. This was a great way to review the “foreign language” of accounting. I look forward to the next episode, which will continue where they left off with this episode.

If you liked the podcast, you will like our training course. Click on the link below to join our upcoming course.

Join our Zoom Class

123 4