Can You Trust Your Books? A Monthly QuickBooks Health Check

As a business owner, you rely on your financial information to make important decisions. But how do you know that information is reliable?

In Episode 41 of QuickBooks Mastery for Small Business Success, Erica Northrup and Lee Davis discuss what it really means to trust your books.

The goal isn’t necessarily to have perfect books. Perfection can be difficult, especially for a busy small business.

The goal is to have a process that gives you confidence that the major pieces are accurate.

Can you answer questions such as:

  • Are my bank accounts accurate?
  • Does my Profit and Loss reflect what actually happened in the business?
  • Do my customers really owe the amount shown in Accounts Receivable?
  • Do my vendor balances accurately show what I owe?
  • Do my payroll liabilities make sense?
  • Are there transactions or accounts nobody can explain?
  • Can I trust these numbers enough to make a business decision?

If you can’t answer these questions, it may be time for a bookkeeping health check.

Your Books Don’t Have to Be Perfect

One of the most important points from this episode is that your books don’t have to be perfect to be useful.

What matters is having a process for checking the areas that have the greatest impact on your financial statements.

For some businesses, that may mean cleaning up the books before they can truly understand what the numbers are saying.

Once the cleanup is done, the next step is maintaining the books through regular reviews.

monthly health check can help you catch problems before they become bigger problems.

1. Are All of My Bank Accounts Reconciled?

Start with your bank and credit card accounts.

Ask:

Are all of my accounts reconciled through the most recent statement?

A bank reconciliation compares what QuickBooks says you have with what the bank says you have.

If your bank statement shows one amount and QuickBooks shows another, you want to identify the difference.

Reconciliation can uncover:

  • Missing transactions
  • Duplicate transactions
  • Incorrect amounts
  • Transactions recorded in the wrong account
  • Other bookkeeping errors

Don’t simply assume the balance is correct because the bank account is connected to QuickBooks.

Reconcile it.

2. Is Anything Old or Unexplained Sitting in the Bank Feed?

Bank feeds can be helpful, but they shouldn’t become a place where transactions sit indefinitely.

Review transactions that are still waiting in the bank feed.

An old transaction may have been:

  • Categorized incorrectly
  • Duplicated
  • Entered previously but not matched
  • Left unresolved because nobody knew what to do with it

The longer unexplained transactions sit there, the harder it can become to understand what your books are telling you.

Make reviewing the bank feed part of your regular process.

3. Does Accounts Receivable Represent Money You Actually Expect to Collect?

Accounts Receivable represents money your customers owe you.

But the balance in QuickBooks isn’t automatically a guarantee that you’ll collect all of it.

Look at your Accounts Receivable Aging report.

Ask:

  • Who owes us money?
  • How long have they owed it?
  • Are these customers still active?
  • Are there old balances we don’t understand?
  • Are there amounts we realistically expect to collect?

An old balance can make your Accounts Receivable look larger than the amount you are actually likely to collect.

If your books say customers owe you $50,000, but a significant portion of that balance is several years old and unlikely to be collected, the report isn’t telling the full story.

Your books should help you understand reality, not just display numbers.

4. Does Accounts Payable Really Represent What We Owe?

The same principle applies to Accounts Payable.

Ask:

Does Accounts Payable accurately represent what the business currently owes?

Look for old balances.

If a bill has been sitting in Accounts Payable for months or years, determine why.

Is it still owed?

Was it already paid?

Was it entered twice?

Was there a mistake in how the payment was recorded?

Old Accounts Payable balances can distort your understanding of your obligations and cash needs.

5. Do My Payroll Liabilities Make Sense?

Payroll is another area that deserves regular attention.

Payroll doesn’t simply create an expense. It can also create liabilities that the business needs to pay.

Review your payroll liability balances at month-end.

Ask:

  • Are there old payroll liabilities sitting on the books?
  • Do the balances make sense?
  • Were payroll taxes and other liabilities actually paid?
  • Are there amounts that nobody can explain?

If old liabilities continue accumulating, don’t ignore them.

They may indicate that payroll was recorded incorrectly or that payments were not properly connected to the liabilities.

6. Is There Anything Unusual on the Balance Sheet?

Your Balance Sheet can reveal problems that aren’t obvious when you’re only looking at your bank account.

Review it for unusual items such as:

  • Negative balances
  • Very old balances
  • Accounts you don’t recognize
  • Accounts nobody can explain
  • Unexpected asset or liability balances

A Balance Sheet should tell a logical story about what the business owns, what it owes, and the owner’s equity.

If something looks strange, investigate it.

7. Does My Profit and Loss Make Sense?

Next, look at the Profit and Loss.

Don’t just look at whether the business made money.

Ask whether the numbers make sense based on what actually happened during the period.

For example:

  • Does the income look reasonable?
  • Did sales increase or decrease as expected?
  • Are expenses consistent with business activity?
  • Are there unusual changes?
  • Did any expense category suddenly increase?

You know your business.

Your Profit and Loss should generally reflect what you experienced.

If something doesn’t make sense, that’s a reason to investigate—not simply accept the report.

8. What Expenses or Costs Have Increased?

Comparing your current numbers with historical information can reveal changes that aren’t obvious when looking at one month by itself.

Compare this year to last year.

Look for expenses and costs that have increased significantly.

A change may have a perfectly reasonable explanation. Perhaps you hired an employee, expanded, purchased equipment, or experienced higher material costs.

But you want to know why the number changed.

This is where accurate historical QuickBooks data becomes especially valuable.

9. Are There Mystery Accounts or Transactions?

Every business eventually encounters transactions that don’t immediately make sense.

But mystery transactions shouldn’t remain mysteries forever.

Look for items such as:

  • Unapplied income
  • Unapplied payments
  • Uncategorized transactions
  • Accounts nobody recognizes
  • Old balances without an explanation

If nobody can explain a transaction, don’t simply leave it sitting there.

Find out what happened.

A small unexplained item may not have a major impact. But a pattern of unexplained transactions can indicate a larger bookkeeping problem.

10. Do I Trust These Numbers Enough to Make a Business Decision?

This may be the most important question of all.

Do I trust these numbers enough to make a business decision?

Can you use your financial statements to determine:

  • Whether the business is profitable?
  • Whether sales are improving?
  • Whether expenses are increasing?
  • Whether you can afford to hire?
  • Whether you have enough cash?
  • Whether pricing needs to change?
  • How the business is performing compared with previous periods?

If you don’t trust your numbers, you’re forced to make decisions based on guesswork.

That defeats one of the biggest benefits of using QuickBooks.

Don’t Forget Personal Transactions

Another important part of reviewing your books is checking for personal transactions.

Personal and business expenses should not be mixed together.

Review transactions to make sure personal purchases aren’t being recorded as business expenses.

This is particularly important because incorrectly categorized personal expenses can distort your Profit and Loss and make the business appear more or less profitable than it really is.

Review Loan Payments

Loan payments also deserve attention.

A loan payment isn’t necessarily one expense.

Typically, part of a payment goes toward principal, while another portion goes toward interest.

The principal reduces the loan liability, while the interest is an expense.

If the entire payment is recorded incorrectly, both the Profit and Loss and Balance Sheet can be affected.

Review loan balances and payments regularly to make sure they make sense.

Don’t Ignore Cash Transactions

Cash transactions can be easy to overlook, especially when a business uses both bank and cash activity.

Make sure cash transactions are recorded appropriately and that the balances make sense.

If cash is being withdrawn, spent, or deposited without being properly recorded, your books can quickly become difficult to understand.

Build a Monthly Habit

Trusting your books isn’t about looking at QuickBooks once a year when your tax return is due.

It’s about developing a regular habit.

At the end of each month, take time to review the major pieces:

Bank accounts → Bank feed → Accounts Receivable → Accounts Payable → Payroll liabilities → Balance Sheet → Profit and Loss → Expense changes → Mystery transactions → Business decisions

This doesn’t have to take hours every month once the process is established.

The important thing is consistency.

What If Your Books Aren’t Reliable?

If you go through this health check and find problems, don’t panic.

You may need to clean up your books before you can rely on the financial statements.

Start with the biggest issues.

Reconcile the bank accounts. Investigate old receivables and payables. Review payroll liabilities. Look at unusual Balance Sheet accounts. Clean up unexplained transactions. Make sure personal expenses aren’t mixed with business expenses.

You don’t have to fix everything at once.

Take small steps toward accurate books.

And if you find yourself in deeper waters, getting help can save time and prevent additional problems.

Trust Your Numbers Before You Act on Them

QuickBooks is a tool for understanding your business, but the software can’t tell you whether every number makes sense.

That requires a process.

A monthly health check helps you move beyond simply entering transactions and toward actually understanding your financial information.

Your books don’t have to be perfect.

They need to be reliable enough to tell you the truth about your business.

When your bank accounts reconcile, your receivables and payables make sense, your payroll liabilities are accurate, your Balance Sheet is logical, and your Profit and Loss reflects what actually happened, you can have greater confidence in your decisions.

And that’s ultimately what trustworthy books are about:

Knowing your numbers well enough to use them.


Set Up your Business with Quickbooks Detailed Start

If you are looking to set up your business with Quickbooks Detailed Start, this is the post for you. I love helping clients succeed with Quickbooks and that starts with a proper setup, so I’m glad you found this post.

Hopefully, I can give you the tips you need to set up your business with Quickbooks detailed start, so your Quickbooks run seamlessly. If you find yourself with a lot of errors, however, check out these post:

  1. How to fix errors in Quickbooks

OR

Sign up for our Free Mini-Course on How to Get Started in Quickbooks!

Choose between Express Start and Detailed Start

I have clients who are setting up Quickbooks for the first time who ask the question about the difference between setting up Quickbooks using Express Start (recommended for new users) compared to selecting the button called Detailed Start. This blog will outline the benefits of setting up Quickbooks using detailed start.

Quickbooks Detailed Start

When setting up Quickbooks if you click on detailed start you perform all the basic setup functions with some added benefits.  Those added benefits are:

A. Clearly Defines Your Business by Asking Questions About:

  1. What you sell
  2. How your customers pay you
  3. How you pay your bills.

Based on the answers Quickbooks sets preferences for the company file. The preferences enable certain features of the Quickbooks program.  

B. Questions About What You Sell

Answer the questions about what do you sell?

  1. Services only
  2. Products only
  3. Both services and products

C. Questions About How You Enter Sales

In the how you enter your sales in Quickbooks window, you choose the option that best fits your business needs.

My Tips for Entering Sales:

  1. Record each sale individually. You can use print sales receipts to give customers.
  2. Record only a summary of your daily weekly sales. If you use a cash register to ring up individual sales, you can enter the sales total for the days work in Quickbooks.
  3. Use Quickbooks point of sale. You can send the details of each individual sale into Quickbooks with just one click.

D. Entering Sales Tax information

In this part of the Easy Step interview the software asks you whether you charge sales tax. I want to caution you here, you should turn the sales tax setting off only if you never charge sales tax. Furthermore, sometimes it is beneficial to turn this feature on for tracking wholesale/retail sales, depending on the tax reporting regulations in your state.

E. Creating Estimates

If you provide any type of estimates or bid-even verbal quotes, there are many reason to use estimates in Quickbooks

  1. Prepare professional-looking itemized estimates, bids or proposals for your customers.
  2. Create an invoice from the estimate with just one click.  In fact, Quickbooks then creates an invoice using the information from your estimate.
  3. Create reports that compare your estimated costs and revenue against your actual costs and revenue.
  4. Compare your actual costs against what you estimated.
  5. Track which estimates are still active and easily update each estimate as you continue to negotiate with your customers.

F. Creating Sales Orders

Sales orders allow you to record an order for a sale before the sale actually is made. These forms are common in businesses that order products to fill orders or that pull orders from inventory before invoicing.

G. Choose remaining preferences

1. Billing statements  – Post statement charges independently of invoices & sales receipts.

   2.  Progress Invoicing – Create single estimates to invoices in phases.

   3. Bill tracking – Use the Accounts Payable module to track bills and bill payments.

     4. Inventory – Use inventory module to track inventory quantities and values.

     5. Track time – Use timecards to track employees and subcontractor time, and bill customers.

     6. Employee – Use payroll module to manage employee information and payroll.

You are not stuck with Detailed Start.

You can always change preferences setting later, after the detailed start has been completed. Changing the preferences later can be done by:

  1. accessing the Edit menu
  2. choosing preferences
  3. then selecting the preference type in the left panel

Tip: Choosing a Start Date

The start date is the date for which you give Quickbooks a financial snapshot of your company assets and liabilities before you start entering live transactions in Quickbooks. It is generally the last day of the previous fiscal period.

Why use Quickbooks Detailed Start?

The value of setting up Quickbooks with a detailed start means is that you spend less time adding information later. 

At Lee Davis & Company, we can assist you in setting up and training you in your new adventure called Quickbooks.

Lee Davis standing outside in the sunshine
Lee Davis

What can you expect from Lee Davis and Company? 

Lee Davis is the president of Lee Davis and Company. He prides himself in helping his clients make their dreams of running a successful business a reality. He has the tools and advice that will help you, the client, get to the next level. 

What services can you find at Lee Davis and Company? 

  1. Bookkeeping Services
  2. Small Business Advising 
  3. Quickbooks Training
  4. Management Services

Read more posts by Lee Davis 

  1. Main Street Relief Fund Application
  2. Getting your SBA Loan Approved
  3. Growth Mindset Development
  4. Adding Clients in Quickbooks


The Value of Doing a Good Job

What is the value of doing a good job? Attraction. There are a lot of bookkeepers in the world, but how many of them are doing a good job? I’m not sure. There are probably quite a few good bookkeepers, but from what we have seen at Lee Davis and Company, there are quite a few bookkeepers that are not doing a good job.

This is true of most fields. It is hard to find a good… (fill in the blank). How many times have you heard that? I’m guessing quite a few times. Thus, I hypothesize that there are a lot of people doing an average job, but few doing a good job.

There are a lot of reasons for this.

  1. They don’t know they can do better. (think they can’t)
  2. They don’t know how to do better. (don’t have the right mentors)
  3. They don’t know why they should do better. (need a stronger “why”)
  4. They are not doing a job that is in their zone of genius. (not suited for bookkeeping)
  5. They don’t spend the time necessary to do a good job. (too overwhelmed with work)

This week’s How I Rocked the Week pertains to this because this week Lee cleaned up a company’s bookkeeping mess. By reading this post, I hope you can see the importance of doing a good job. There are many benefits to doing a good job. Read about those benefits at the bottom of the post.

How I Rocked the Week – Week of July 13th

Lee Davis and Company received a referral from a CPA firm last week. The company the CPA firm referred needed immediate help with their bookkeeping and business operations. They had been without their bookkeeper and had had two bookkeepers since loosing their full-time person. Lee was so happy about getting this referral because we specialize in helping companies who need to have their messes cleaned up.

Lee is trained in Quickbooks both the desktop and the online products. Thus, he has the skills necessary to fix the problems that led to the bookkeeping mess. To fix the problems, Lee went right to work and made a few changes to Quickbooks. The changes brought order and efficiency to the clients books. Lee was so happy that he had the necessary skills to fix the client’s problems and save him time with future bookkeeping.

Here is what our client has to say after working with Lee Davis and Company for only two days: “Thank you for your assistance this morning; it was a huge help, and thank you for all you accomplished so far in straightening out the mess all the bookkeepers left.” 

It is our experience that often times businesses need help because their bookkeeping is a mess. That’s where we come in. Lee Davis and Company specializes in creating organization through automating transactions and balancing peoples books.

This helps our clients get a handle on their finances, which helps them make decisions that will support future growth. Thus, we move our clients from scattered to organized to accomplished.

Our success in cleaning up messes has lead to many referrals and continues to fuel our business.

Could this be you? Are you having trouble balancing your books? Are you frustrated because you’re spending too much time on your bookkeeping? 

We can help you work on your business while you work in your business. 

Benefits of Doing a Good Job:

Lee has always made it his goal to work as hard for his clients as possible. That means that he goes above and beyond for his clients. In fact, this week he helped one of his clients move furniture, which isn’t in his job description!

The benefits of doing a good job are abundant.

“I can look my clients square in the eyes and tell them that the job is done.”, says Lee.

By doing a job well done, Lee Davis and Company can expect:

  1. Trust
  2. More business
  3. Respect
  4. Confidence
  5. Expanded business

If you hire Lee Davis and Company to do bookkeeping and more, you can expect the same for your business. We aim to grow your business into a more trustworthy business that garners respect and more business.

Lee Davis from Lee Davis and Company on the Value of Doing a Good Job
Lee outside

What can you expect from Lee Davis and Company? 

Lee Davis is the president of Lee Davis and Company. He prides himself in helping his clients make their dreams of running a successful business a reality. He has the tools and advice that will help you, the client, get to the next level. 

What services can you find at Lee Davis and Company? 

  1. Bookkeeping Services
  2. Small Business Advising 
  3. Quickbooks Training
  4. Management Services

Read more posts by Lee Davis 

  1. Main Street Relief Fund Application
  2. Getting your SBA Loan Approved
  3. Growth Mindset Development
  4. Adding Clients in Quickbooks


Adding Customers in Quickbooks

Adding customers in Quickbooks is an essential tool that Quickbooks offers, but I fear that many of my clients either don’t use the tool or don’t use it to its full potential. Thus, because I want to help more people use Quickbooks to its full potential, I would like to share with you how to add customers in Quickbooks.

Your Customer List is the list that will display sale forms (sales orders, estimates, invoices, sales receipts) and accounts receivable. Here are some steps that will help you get this very important task completed in Quickbooks.

Adding Customers in Quickbooks

1. To add a Customer

There are multiple ways to do almost anything in Quickbooks. To access the Customer Center, you have four options:

How to:

   1. Click Customers from the left hand or top icon (depending) on your View settings)

   2. Choose Customer Center from the Customers drop down in the menu bar.

   3. From the Home Screen, click on the blue Customers tab in the Customers section.

   4. Press CTRL+J

2. New Customer & Job

How to: Click the New Customer & Job Menu button, and than choose New Customer.

3. Customer Name

Definition: In the Customer Name field enter the name of the customer as you’d like to see it appear on your Customer & Job List. 

Tip: – Instead of filling in the Customer Name field, fill in the Company Name field, and it will populate the Customer Name field for you.

4. Opening Balance

How to: Press Tab in the Opening Balance field to leave this field blank.

Definition: The Opening Balance field tells you how much each customer owes you on your start date.

Why: The reason you need to use this field is that when you enter the rest of your transactions from the day after your start date, all balances since your start date will be accurate.

Tip: You should enter individuals outstanding invoices one by one whenever possible, rather than entering the outstanding balance owned in the Opening Balance field. (This will allow you to enter payments and be able to apply those payments to the open invoices.)

5. Complete Customer contact information

Tip: Pay close attention to getting the correct email addresses from your customers.

Sending your Invoices  & Customer Statements by email, will ensure you are paid as quickly as possible and your customers will enjoy the convenience of receiving an electronic invoice.

Conclusion – Adding Customers to Quickbooks

I hope this helps you understand adding Customers to Quickbooks. My goal with this blog and my training company is to help entrepreneurs use Quickbooks to better understand their business, so that I can help entrepreneurs strengthen their businesses.

Lee Davis - President of Lee Davis and Company
Lee Davis – President of Lee Davis and Company

What can you expect from Lee Davis and Company? 

Lee Davis is the president of Lee Davis and Company. He prides himself in helping his clients make their dreams of running a successful business a reality. He has the tools and advice that will help you, the client, get to the next level. 

What services can you find at Lee Davis and Company? 

  1. Bookkeeping Services
  2. Small Business Advising 
  3. Quickbooks Training
  4. Management Services

Read more posts by Lee Davis 

  1. Main Street Relief Fund Application
  2. Getting your SBA Loan Approved
  3. Growth Mindset Development


Privacy Settings
We use cookies to enhance your experience while using our website. If you are using our Services via a browser you can restrict, block or remove cookies through your web browser settings. We also use content and scripts from third parties that may use tracking technologies. You can selectively provide your consent below to allow such third party embeds. For complete information about the cookies we use, data we collect and how we process them, please check our Privacy Policy
Youtube
Consent to display content from - Youtube
Vimeo
Consent to display content from - Vimeo
Google Maps
Consent to display content from - Google