• Sign In
  • Create Account
  • Sign Out
  • My Account
  • NEWS
  • PRODUCTS
  • CONTRACTORS
  • ENGINEERS
  • RADIANT & HYDRONICS
  • INSIGHTS
  • MEDIA
  • RESOURCES
  • EMAGAZINE
  • SIGN UP!
cart
facebook instagram twitter linkedin youtube
  • CONTRACTORS
  • BATH & KITCHEN PRO
  • BUSINESS MANAGEMENT
  • HIGH EFFICIENCY HOMES
  • TECHNOLOGY
  • WATER TREATMENT
  • PMC COLUMNS
  • PMC COLUMNS
  • Dave Yates: Contractor’s Corner
  • John Siegenthaler: Hydronics Workshop
  • Kenny Chapman: The Blue Collar Coach
  • Matt Michel: Service Plumbing Pros
  • Scott Secor: Heating Perceptions
  • ENGINEERS
  • CONTINUING EDUCATION
  • DECARBONIZATION | ELECTRIFICATION
  • FIRE PROTECTION
  • GEOTHERMAL | SOLAR THERMAL
  • PIPING | PLUMBING | PVF
  • PME COLUMNS
  • PME COLUMNS
  • Christoph Lohr: Strategic Plumbing Insights
  • David Dexter: Plumbing Talking Points
  • James Dipping: Engineer Viewpoints
  • John Seigenthaler: Renewable Heating Design
  • Lowell Manalo: Plumbing Essentials
  • Misty Guard: Guard on Compliance
  • RADIANT & HYDRONICS
  • RADIANT COMFORT REPORT
  • THE GLITCH & THE FIX
  • INSIGHTS
  • CODES
  • GREEN PLUMBING & MECHANICAL
  • PROJECT PROFILES
  • COLUMNS
  • SPONSOR INSIGHTS
  • COLUMNS
  • Codes Corner
  • Natalie Forster: Editorial Opinion
  • Guest Editorial
  • MEDIA
  • PODCASTS
  • VIDEOS
  • WEBINARS
  • RESOURCES
  • INDUSTRY CALENDAR
  • DIRECTORIES
  • EBOOKS
  • PM BOOKSTORE
  • CE CENTER
  • MARKET RESEARCH
  • CLASSIFIEDS
  • EMAGAZINE
  • EMAGAZINE
  • ARCHIVE ISSUES
  • CONTACT
  • ADVERTISE
  • PME EMAGAZINE ARCHIVES
search
cart
facebook instagram twitter linkedin youtube
  • Sign In
  • Create Account
  • Sign Out
  • My Account
  • NEWS
  • PRODUCTS
  • CONTRACTORS
    • BATH & KITCHEN PRO
    • BUSINESS MANAGEMENT
    • HIGH EFFICIENCY HOMES
    • TECHNOLOGY
    • WATER TREATMENT
    • PMC COLUMNS
      • Dave Yates: Contractor’s Corner
      • John Siegenthaler: Hydronics Workshop
      • Kenny Chapman: The Blue Collar Coach
      • Matt Michel: Service Plumbing Pros
      • Scott Secor: Heating Perceptions
  • ENGINEERS
    • CONTINUING EDUCATION
    • DECARBONIZATION | ELECTRIFICATION
    • FIRE PROTECTION
    • GEOTHERMAL | SOLAR THERMAL
    • PIPING | PLUMBING | PVF
    • PME COLUMNS
      • Christoph Lohr: Strategic Plumbing Insights
      • David Dexter: Plumbing Talking Points
      • James Dipping: Engineer Viewpoints
      • John Seigenthaler: Renewable Heating Design
      • Lowell Manalo: Plumbing Essentials
      • Misty Guard: Guard on Compliance
  • RADIANT & HYDRONICS
    • RADIANT COMFORT REPORT
    • THE GLITCH & THE FIX
  • INSIGHTS
    • CODES
    • GREEN PLUMBING & MECHANICAL
    • PROJECT PROFILES
    • COLUMNS
      • Codes Corner
      • Natalie Forster: Editorial Opinion
      • Guest Editorial
    • SPONSOR INSIGHTS
  • MEDIA
    • PODCASTS
    • VIDEOS
    • WEBINARS
  • RESOURCES
    • INDUSTRY CALENDAR
    • DIRECTORIES
    • EBOOKS
    • PM BOOKSTORE
    • CE CENTER
    • MARKET RESEARCH
    • CLASSIFIEDS
  • EMAGAZINE
    • EMAGAZINE
    • ARCHIVE ISSUES
    • CONTACT
    • ADVERTISE
    • PME EMAGAZINE ARCHIVES
  • SIGN UP!
Columns

Financial Management 201, Part I
Ellen Rohr

By Ellen Rohr
November 1, 2007
A two-part series on accounting troubleshooting tips, and making ‘weird’ right.



When I was a college student, I got an “A” in my Accounting 101 and 201 classes. Then I entered the “real world” and almost sunk the family business because I had no idea what I was doing with “real” accounting.

You see, the examples in the college textbook used financials that were correct. That means, the dollar amounts in the accounts could be trusted, and were assumed current and accurate.

Well, when I took a swing at entering my accounting data, I made a big “Slinky knot” mess out of my Peachtree accounting file. Oops. I didn’t learn how to fix my accounting in college. That would have been useful! I learned what I know now from falling in holes and climbing out of them.

As a business consultant, I see lots of financial reports. Most of them have a few “Slinky knots” in them - accounts that are just wrong. The data in those accounts are the result of mistakes in data entry. In my consulting work, I start by helping my clients get to KFP - a known financial position. Let’s get the accounting correct. That’s the first step.

From there, we can see the impact of operational, marketing and sales behaviors. The good news is that you can always improve your financial situation once you know what it is. I am kind of like Super Nanny; I show up, we work together to clean up the accounting, and we put simple systems and routines in place to help you stay at a KFP.

Sometimes, we clean stuff up and then it gets messy again. Just like Super Nanny, I go away after my consulting visit. It is up to my clients to maintain the systems we put in place. I can always come back, and I often help over the phone. However, the key to staying at KFP is your willingness to learn enough about the accounting systems to enter data properly and to fix things when they get balled up.



Welcome To The Real World

If you are the owner of a very small shop, you might be the financial manager of your company (as well as the service manager and marketing manager and salesperson, etc.). That’s the way it goes. If you dream of being a bigger shop, take heart that every big company was once just your size.

The way out is through. Take responsibility and do a good job as the financial manager. Quit looking for a magical solution (accounting fairy?) that will handle the accounting for you. Learn how to do it yourself and document your basic procedures. This will help you hand off the accounting duties successfully.

In larger shops, sometimes the accounting duties get handed to:

  • The financial manager
  • The office manager
  • The owner’s wife, mom, daughter (other relative)
  • The bookkeeper
  • The secretary
  • The “girl in the office”

    Whatever your title, if you are the one who is responsible for the financial information at your company, I am here to help you. The following are a few tips and tricks for finding and fixing the “Slinky knot” messes in your accounting program. The rest will be presented in next month’s column.



  • 1. It's probably you.

    I often hear something along these lines, “That number wasn’t there yesterday. It must be a QuickBooks problem.” That weird dollar amount in your financial reports probably has a very simple explanation. Somebody, maybe you, entered that information.

    In every accounting software program, there are debits and credits. Sometimes the debits and credits are not visible from the data entry screen. You will have to do some digging.

    Follow the flow of information from the entry point to the income statement (a.k.a. profit and loss or P&L) and/or balance sheet. (In my lengthy career, there have been only two cases where the accounting program was corrupt. Chances are you are the problem. Start troubleshooting from that assumption.)



    2. Stay current with your financial reporting.

    I recommend a weekly review of the balance sheet and income statement. Some contractors I know get daily reports. That’s great! Once a year at tax time is just not going to cut it. Get to KFP and run the financial reports at least once a week. It is so much easier to find and fix a mistake that happened in the last few days than trying to track down something goofy from six months ago.

    Also, you can fix the mistake in the current month. That is better than having to re-open a previous month and adjust it. Once I “close” a month, I don’t like to open it again.



    3. Go line by line down the balance sheet and income statement.

    Look for “weird” things. If you are just getting started with this process, I can help. Or your accountant may help you learn what’s “weird” and what’s right. What a great opportunity for him or her to add value to your relationship.

    KFP means that every account is right. It reflects what you have in assets, what you owe in liabilities and what you own in equity. The sales account should equal what you have sold for that period of time. The expenses should reflect what you have expensed for that period of time. The financial reports should be current and true.

    Here’s a list of “weird” things that may need some fixing:

  • A dollar amount that is positive when it was negative last time (or vice versa).
  • A negative asset. (Unless it is “accumulated depreciation” or “amortization.” Those numbers are “contra” accounts and serve to reduce the value of the associated assets.)
  • A negative liability. Pay particular attention to your payroll liabilities. I recommend using a payroll service like ADP or Paychex. The No.1 reason: The service handles the liability so you don’t have to. The service will tell you what the cash requirements are to pay your team and Uncle Sam. They will do the tax payments for you.
    The journal entry to enter payroll is much easier if you don’t have to keep track of the appropriate liabilities and payments. Follow the flow of debits and credits. You could create a sample transaction for your payroll procedure and reference it every time you enter payroll.
  • A negative sales account (unless it is the customer refunds or discounts - contra accounts.)
  • A negative expense account. Now, an account may look weird but be right. For instance, if you enter a rebate for your insurance, it will show up as a negative expense for that month. Drill down and make sure.

     

  • An account that is very different from last week or last month. If all of a sudden your advertising expense went from about $2,500 per month to $300,000 this month, drill down. Something may have been miscoded.

    Have your accountant help you make the weird things right with an appropriate journal entry or reversing entry.

    Find out how it got weird, if you can, and update the data entry procedure. Written procedures are key to staying at KFP.

    If you don’t know how it got weird, at least get it to right. If it is a small dollar amount, create an adjusting entry and watch to make sure it doesn’t get weird again. If it does, look through the previous week’s transactions for that account to find the entry. This is forensic accounting!

    If you do this once a week, you will get intimately familiar with the accounts and the dollar amounts. You will become an expert in what looks right and what looks “weird” and how to fix the weird stuff.



  • 4. Run a transaction register report and look for the debits and credits.

    Different accounting programs call this report by different names. Look for the detail trial balance or the general ledger journal to find the “guts” of every transaction.

    Double-entry accounting is based on the universal law of “what goes around comes around.” If something goes up, something else goes up or goes down by that amount. Debits and credits are the mechanics in the accounting system that cause the dollar amounts to go up and down - and the balance sheet to stay in balance.

    There are debits and credits behind every data entry screen. You can also affect accounts directly by creating a journal entry. I’ve attached a “cheat sheet” of debit and credit rules below; I reference this several times a week.

    That’s plenty for now. Tune in next month for street-smart ways to uncover “weird” numbers, and a mother’s perspective.

    Share This Story

    Looking for a reprint of this article?
    From high-res PDFs to custom plaques, order your copy today!

    Ellen Rohr is the president of Bare Bones Biz, a training and consulting company.

    Recommended Content

    JOIN TODAY
    to unlock your recommendations.

    Already have an account? Sign In

    • Worker using the Milwaukee Tool SWITCH PACK drain cleaner

      Pipeline profits: Drain cleaning, pipe inspection create opportunities

      Drain cleaning and inspection services offer lucrative...
      Green Plumbing and Mechanical
      By: Nicole Krawcke
    • Uponor employee, Arturo Moreno

      The reinvestment in American manufacturing and training

      Plumbing & Mechanical Chief Editor Nicole Krawcke and...
      Plumbing News
      By: Nicole Krawcke and Natalie Forster
    • March 2024 Women in Plumbing hero image of woman engineer overlayed by circle of hexagon shapes with numbers from 1 to 10

      Celebrating 10 Influential Women in the Plumbing Industry

      Celebrating Women's History Month and Women in...
      Plumbing News
      By: Nicole Krawcke
    close

    1 COMPLIMENTARY ARTICLE(S) LEFT

    Loader

    Already a Registered User? Sign in now.

    Subscribe For Free!
    • eNewsletters
    • Online Registration
    • Subscription Customer Service
    • eMagazine
    • Manage My Preferences

    AI can boost efficiency and profitability for plumbing, HVAC contractors

    AI can boost efficiency and profitability for plumbing, HVAC contractors

    NIBCO Press Solutions

    NIBCO Press Solutions

    IPEX celebrates grand opening of new Florida distribution center

    IPEX celebrates grand opening of new Florida distribution center

    Bell & Gossett Illustrates Path to Net-zero at AHR Expo

    Bell & Gossett Illustrates Path to Net-zero at AHR Expo

    More Videos

    Sponsored Content

    Sponsored Content is a special paid section where industry companies provide high quality, objective, non-commercial content around topics of interest to the Plumbing & Mechanical audience. All Sponsored Content is supplied by the advertising company and any opinions expressed in this article are those of the author and not necessarily reflect the views of Plumbing & Mechanical or its parent company, BNP Media. Interested in participating in our Sponsored Content section? Contact your local rep!

    close
    • J.J. Keller CMV vehicles on road
      Sponsored byJ. J. Keller & Associates, Inc.

      The dash cam game-changer for small business safety

    Popular Stories

    The interior of a government building.

    President Trump signs executive order promoting skilled trades and apprenticeships

    Figure 1 is a sketch of the flow problems of the current plumbing system.

    Hydronic heating glitch solved: Why adding a circulator won't fix primary loop flow issue

    Underfloor heating installation with drain sewer hole in bathroom close up on water floor heating.

    Using hydronics to leverage time-of-use electrical rates

    PM BEMIS June 25 Free Webinar: Optimizing Plumbing Solutions for Single-Family, Multi-Family & Public Spaces

    Events

    November 13, 2024

    Future Proofing MEP: Navigating the 2026 High Efficiency Water Heating Standards

    Join our deep dive into DOE’s new standards so you can future-proof your MEP practice.

    EARN: 0.1 ASPE CEU; 1 AIA LU/HSW; 0.1 IACET CEU*; 1 PDH

    View All Submit An Event

    Poll

    Will business be up or down in 2025?

    Do you anticipate business in 2025 to be up or down in comparison to 2024?
    View Results Poll Archive

    Products

    The Water Came To A Stop

    The Water Came To A Stop

    See More Products

    Download the FREE Water Conservation, Quality & Safety eBook: Plumbing Trends Increasing Safe Water Availability

    Related Articles

    • Training 101: Meaningful Meetings

      See More
    ×

    Keep your content unclogged with our newsletters!

    Stay in the know on the latest plumbing & piping industry trends.

    JOIN TODAY!
    • RESOURCES
      • Advertise
      • Contact Us
      • Directories
      • Store
      • Want More
      • Supply House Times
    • SIGN UP TODAY
      • Create Account
      • eMagazine
      • eNewsletter
      • Customer Service
      • Manage Preferences
    • SERVICES
      • Marketing Services
      • Reprints
      • Market Research
      • List Rental
      • Survey/Respondent Access
    • STAY CONNECTED
      • LinkedIn
      • Facebook
      • Instagram
      • YouTube
      • X (Twitter)
    • PRIVACY
      • PRIVACY POLICY
      • TERMS & CONDITIONS
      • DO NOT SELL MY PERSONAL INFORMATION
      • PRIVACY REQUEST
      • ACCESSIBILITY

    Copyright ©2025. All Rights Reserved BNP Media.

    Design, CMS, Hosting & Web Development :: ePublishing

    search
    cart
    facebook instagram twitter linkedin youtube
    • Sign In
    • Create Account
    • Sign Out
    • My Account
    • NEWS
    • PRODUCTS
    • CONTRACTORS
      • BATH & KITCHEN PRO
      • BUSINESS MANAGEMENT
      • HIGH EFFICIENCY HOMES
      • TECHNOLOGY
      • WATER TREATMENT
      • PMC COLUMNS
        • Dave Yates: Contractor’s Corner
        • John Siegenthaler: Hydronics Workshop
        • Kenny Chapman: The Blue Collar Coach
        • Matt Michel: Service Plumbing Pros
        • Scott Secor: Heating Perceptions
    • ENGINEERS
      • CONTINUING EDUCATION
      • DECARBONIZATION | ELECTRIFICATION
      • FIRE PROTECTION
      • GEOTHERMAL | SOLAR THERMAL
      • PIPING | PLUMBING | PVF
      • PME COLUMNS
        • Christoph Lohr: Strategic Plumbing Insights
        • David Dexter: Plumbing Talking Points
        • James Dipping: Engineer Viewpoints
        • John Seigenthaler: Renewable Heating Design
        • Lowell Manalo: Plumbing Essentials
        • Misty Guard: Guard on Compliance
    • RADIANT & HYDRONICS
      • RADIANT COMFORT REPORT
      • THE GLITCH & THE FIX
    • INSIGHTS
      • CODES
      • GREEN PLUMBING & MECHANICAL
      • PROJECT PROFILES
      • COLUMNS
        • Codes Corner
        • Natalie Forster: Editorial Opinion
        • Guest Editorial
      • SPONSOR INSIGHTS
    • MEDIA
      • PODCASTS
      • VIDEOS
      • WEBINARS
    • RESOURCES
      • INDUSTRY CALENDAR
      • DIRECTORIES
      • EBOOKS
      • PM BOOKSTORE
      • CE CENTER
      • MARKET RESEARCH
      • CLASSIFIEDS
    • EMAGAZINE
      • EMAGAZINE
      • ARCHIVE ISSUES
      • CONTACT
      • ADVERTISE
      • PME EMAGAZINE ARCHIVES
    • SIGN UP!