Quantcast
Jump to content


PPP Expense Tracking


bantar

Recommended Posts

Well, I put together a spreadsheet to track my payroll spending.   The payroll spending starts after funds have been dispersed.    I need to spend a minimum of 75% against payroll  After 2 pay periods, I'm in trouble!   Not spending enough.   I've recalled a furloughed worker and he's balking....   "I have a weakened immune system", "I'm not feeling good right now", etc.   Another isn't being recalled.   I've immediately boosted everyone's hours, and have hired a new guy, made an offer to another and will likely replace my furloughed worker.  The good news is that I'm spending all of this on my employees!  They are getting a boost and I'm using the PPP as it was intended.... for them.

I was surprised that I was running so far behind.  It's but a small 8 week tracking window, so I only have 6 weeks left to make adjustments.

All my advisors are stating that we need to track our expenses very closely, so I'm doing this.

  • Like 1
Link to comment
Share on other sites



  • 4 weeks later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Similar Topics

    • By carmcapriotto
      Charlie Marcotte is the owner of American Pride Automotive and Founder of Transportation Matters. After serving in the U.S. Army, Charlie and his wife Diane moved to Virginia in 1988 and started their family in 1992. Putting food on the table was the primary goal that started Charlie working on cars (illegally) from a 10′ by 20′ storage unit. A strong work ethic and love of cars allowed those humble beginnings to flourish into American Pride Automotive, with 4 locations serving the Virginia Peninsula. The family unit has always been Charlie’s driving force, with three successful children and a bouncing baby Grandson: Life is Good. Building a solid business is a point of pride for Charlie, but his true passion is Transportation Matters. The transportation Matters mission drives positive social change while delivering a competitive advantage to the independent automotive repair industry—the same industry which has provided Charlie with so much opportunity.
      Listen to Charlie's other episodes HERE
      Dustin Brown, Brown Auto Experts, 3 Locations in New Mexico, Albuquerque, Village of Los Ranchos and Rio Rancho. Dustin and Nolan Brown are brothers that are third-generation mechanics. Their father Donald started Browns Automotive in 1982.
      Key Talking Points
      Connect your brand to your community What has your contribution been during your entire career? Owning a business and supporting your community go hand in hand- hiring, retention, comebacks, customer relationships, word of mouth growth Transform your reputation in the  industry- break the negative stereotype Charlie Marcotte is 7 years into a 10-year goal of donating $320,000 to local non-profits, he is proud to say that we are ahead of schedule. Success came from the process. Charlie developed a program called State Inspections for our Community. In VA, they have an annual safety inspection, the cost to the customer is only $20. For each State Inspection they perform, they set aside $5 to be given to a local NPO, they call it “making the mundane, meaningful”.   American Pride is Facilitating the gift of a 2015 Ford Escape to the Williamsburg House of Mercy. One of their great fleet customers, Signature Stone, needed a transmission for their ’15 Escape. It’s an expensive transmission and in the end, it didn’t make sense to repair it but the rest of the car was in great shape. Charlie reached out to WHOM and asked if they had a family who could use reliable transportation, with the ability to maintain it - they did. Charlie reached out to a friend, Matt Lacy who owns Lacy Auto Parts, and suggested he donate a transmission, he did. He had their crew install the transmission at no charge. To make this donation a wise business strategy, Charlie will have a film crew coming to the shop to interview all 4 parties.  Video content- keep it simple with a cell phone, quick and natural. It is real and intimate content. Don’t overthink it.  Dustin’s primary charity is the Albuquerque Christian Children's Home. In the past, they were involved with many organizations such as Road Runner food bank, Coats for Kids, Toys for Tots, and Breast Cancer awareness foundation. 3 years ago they decided to stay focused on one local charity and provide support to them throughout the year. This has ensured the collections stay in the community. Consumable drive with customers started this month and will go to the end of the year (Paper/Plasticware, toilet paper, dishwashing, and laundry detergent, and so on, Things the home goes through all year long). Don’t just give back during the holidays, it needs to be done throughout the whole year. Dustin recently completed a training room: The goal is to get involved with local car clinics for new drivers and basic vehicle education such as tire pressure, changing a spare, and checking fluids. With a new training area, they hosted their first tech training event with the help of NAPA. It is also for technicians in the community to do more hands-on training. New driver clinic- changing tire, oil etc. Inspiration is followed by perspiration  Family Service Day- free automotive care and repair paired with the local church, helped over 1,000 families Connect with the show:
      Aftermarket Radio Network
      Subscribe on YouTube
      Visit us on the Web
      Follow on Facebook
      Become an Insider
      Buy me a coffee
      Important Books
      Check out today's partners:

      This episode is brought to you by Shop-Ware Shop Management. It’s time to run your business at its fullest potential with the industry’s leading technology. Shop-Ware Shop Management will increase your efficiency with lightning-fast workflows, help your staff capture more sales every day, and create very happy customers who promote your business. Shops running Shop-Ware have More Time and generate More Profit—join them! Schedule a free live demonstration and find out how 30 minutes can transform your shop at getshopware.com

      Are you seeing auto shops in your area get hundreds of 5-star Google reviews and are you feeling left behind because your shop only has a few?
      Hey look, Broadly is your answer to getting more online reviews. With more reviews, your business will rank higher in search results — and that means more customers coming into your shop every day. Broadly helps you automatically request reviews so that your customers can promote your business with just one click. When you immediately ask for a review after service, when the experience is still fresh in their mind, you’re more likely to get a 5-star positive review. Plus, asking for feedback makes your customer feel valued and more connected to your business. Isn’t that what you want a connected customer? See how Broadly can help grow your auto shop.  Visit www.getbroadly.com/chat to learn more.
      Click to go to the Podcast on Remarkable Results Radio
    • By carmcapriotto
      Bill Haas is the owner of Haas Performance Consulting LLC, with 40 years of experience in the automotive service and repair industry. Clients now have access to Bill’s solution based focus, expertise, unique perspectives and in-depth knowledge of the industry. Services available include business management seminar development and delivery, keynote presentations, business consulting, performance coaching, and strategic planning facilitation. His career includes time as a technician, shop owner, technical trainer and most recently on the staff of the automotive industry’s oldest and largest association representing automotive service and collision repair businesses. .Bill received the Accredited Automotive Manager (AAM) credential from the Automotive Management Institute in 1996 and has been a member of the Automotive Management Institute’s faculty since 2002
      Listen to Bill's other episodes HERE
      Key Talking Points
      Successor struggle- when every day is a struggle “Advanced Financial Strategies for Peace of Mind”- what is it that you need to pay attention to in business? KPI’s need to be reviewed every day, don’t wait until the end of the month. It needs to also be shared with employees. “If you don’t share, they don’t care.” Don’t make decisions without data- it lets you know what you need to work on and prioritize. Strategic thinking instead of working on many things at once.  How do you know what to fix? Pause and do analysis. Make cars count vs car count.  Coaches change clients- is this someone who is willing to put words into action? You need an investable business in order to retire- can’t wait until the end to start working on your business You have to want to change yourself and your business. If not don’t hire a coach or even join a networking group Focus on one particular area of concern, get it right, then move on to the next. Stop the smorgasbord of quick fixes. You can’t wait to fix the business when you want to sell or retire. It takes a few years depending on the depth of the struggle P & L statement- don’t ask your accountant how the business is doing, don’t rely on them to take the pulse of the business. Most accountants have clients in all different industries, they don’t know how to “fix” your automotive service business. Ask them to perform one job and that is to minimize your tax liabilities. Finances in your business is just a big math problem to solve Labor rate- gross profit percent on labor, labor parts split, hours per repair order Sales forecasting and budgeting- have goals, targets and expectations Connect with the show:
      Aftermarket Radio Network
      Subscribe on YouTube
      Visit us on the Web
      Follow on Facebook
      Become an Insider
      Buy me a coffee
      Important Books
      Check out today's partners:
           
      This episode is brought to you by AAPEX, the Automotive Aftermarket Products Expo. AAPEX represents the $740 billion global automotive aftermarket industry and has everything you need to stay ahead of the curve.  AAPEX 2021 is in the record books and lived up to presenting leading-technical and business management training from some of the industry’s best and brightest. Now set your sights on Las Vegas in 2022. Mark your calendar now … November 1-3, 2022, AAPEX - Now more than ever.

      This episode is brought to you by Shop-Ware Shop Management. It’s time to run your business at its fullest potential with the industry’s leading technology. Shop-Ware Shop Management will increase your efficiency with lightning-fast workflows, help your staff capture more sales every day, and create very happy customers who promote your business. Shops running Shop-Ware have More Time and generate More Profit—join them! Schedule a free live demonstration and find out how 30 minutes can transform your shop at getshopware.com/carm

      Click to go to the Podcast on Remarkable Results Radio
    • By Joe Marconi
      Exit Strategy-Step 2
      Have Clean and Accurate Financial Statements
      The value of your business will be determined by your net profit, cash flow and a strong balance sheet.  Having clean and accurate numbers will be more attractive to a potential buyer, especially if your business shows growth over time. While you may value your loyal customer list, and your tools and equipment, it's the profitability of your business that will be used to determine how much someone will pay for your business.  
      As an added benefit, having clean and accurate financials will also help you through tough economic times, and if you ever need a bank loan. 
      Get your books in order and work hard on your business to show a profit.  
    • By bantar
      Started a new thread based on a comment from:  Are you paying your employees what they deserve?
      Thanks to CTC who warned that we need to be Compliant in our pay plans, I called the Dallas Office of the Dept of Labor Wage and Hour Division to check on my compliance.   Very friendly and knowledgeable.  Didn't even ask who I was.  I encourage you to call.  However, what she said was super-complicated if it's the first time that you've heard it.  It still hurt my head on today's call.   The goal of this message is to explain OT calculations and then to explain the flat rate pay as related to OT.   I'm only presenting this to give you background before you call W&H yourself.    I'm not an expert on W&H.
      This focuses on non-salaried employees who are eligible for OT payments.  
      Background:
      In general, OT pay is more complicated if you have variable pay plans (bonuses or extra payments).   Regular hourly folks working OT get 1.5 times their "regular rate" (which is the same as their hourly rate).    If they don't get any extra pay, this is easily computed.  
      When variable pay is involved, we need to know how much the employee is really making this week.   That is, we must calculate their "Regular Rate" because the variable pay (bonuses) increases their normal hourly rate.   When we pay OT, we must pay 1.5 times their "Regular Rate".    This is a protection for the employees to ensure that they are being fairly paid even though their pay rate varies week to week.
      Regular Rate Computation:
      Figure out the employee's total compensation for this week (we are ignoring OT for this calculation).  Divide this by the total hours worked this week. This is their regular rate for THIS week. For example:   Joe makes $10/hr and earned $100 bonus this week while working 50 hours.   His total pay for the week is $10 * 50 hours + $100 bonus = $500 + $100 = $600.   His Regular Rate is $600/50 hours = $12/hr.   When you pay him OT, you will be paying him 10 hours * 12 Regular Rate/hr * 1.5 = $180.   This is added to his base rate of 40 hours * $10/hr, so this week, he makes $400 + 180 = $580 + $100 bonus = $680 total pay.
      There is a shortcut to computing regular rate that I find faster to compute.   Just take the variable pay (bonus) and divide it by the hours worked.   $100 bonus/50 hours = $2/hr   Joe's Regular Rate is $10+$2=$12/hr.   His overtime rate is $12 * 1.5 = $18 (instead of $15). 
      Using ADP (and other payroll systems):
      For employees that are getting OT with variable pay, I create a separate pay line in my payroll.   Line 1 is 40 hours at their normal hourly rate.  Line 2 is OT hours at Regular rate.   The payroll software multiplies the regular rate * 1.5 to calculate their OT pay.
      Regular Pay Line:  40 Hours @ $10/hr OT Pay Line: 10 Hours @ $12/hr Flat Rate:
      Per W&H, Flat Rate still requires OT pay if more than 40 hours are worked.  Therefore, we are required to compute a "Regular Rate" to pay OT.    This means we need time clock records.   W&H suggested a few different ways of computing it for Flat Rate employees (one was a weighted average, but I didn't dig into this).   Also, minimum wage must be adhered to as well.
      I threw a few examples of pay (flag bonuses, incentives, make-up hours, etc) at W&H and in the end, it didn't matter what the mix of payments were.   All payments are combined to compute a Regular Rate.  This can be bonuses for flagged hours or bonuses for sales or it could be 20 hours of flag and 20 hours of guaranteed pay (to equal 40 hours).   What mattered was how many hours did the non-salaried worker work?   What is their regular rate?   Pay OT using the Regular Rate.
       
       
       
    • By Joe Marconi
      I was attending a recent TECH NET council meeting a few weeks back and one of the topics discussed was Exit Strategies. One of the members spoke about finding a key person in your company, if there is no one in your family to consider.
       
      There are many shop owners out there that are near retirement. It would be a good idea to share a few ideas. I know many shop owners may not even have a plan. My lawyer approached me about a year ago and insisted that I sit down with him to plan out my future. I am 59, been in business for 34 years and been in the auto repair business since high school. If your story is similar to mine, it's something we need to start planning.
       
      Thoughts? Comments?
       
       


  • Our Sponsors



×
×
  • Create New...