• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Thomas Fox

Random thoughts about business and IT

  • About
  • Contact Me
  • Archive
  • Privacy Policy

Thomas Fox

From the Wall Street Journal: Small Business Needed Federal Help. The Agency in Charge Fell Short

June 17, 2021 By Thomas Fox

Small Business Needed Federal Help. The Agency in Charge Fell Short.

The Small Business Administration, overwhelmed by demand from ailing entrepreneurs, has been slow to distribute aid needed to survive the pandemic
By Amara Omeokwe and Ruth Simon

June 17, 2021 12:06 pm ET

In the pandemic shutdown last year, three-quarters of the nation’s small employers turned to the Small Business Administration for help. The portfolio that includes loans issued or guaranteed by the federal agency swelled more than five times to nearly $900 billion.

The extraordinary demand has overwhelmed the SBA, best known for guaranteeing loans to small businesses, and left many entrepreneurs in limbo as they seek to recover. Business owners complain of unprocessed aid applications, waiting hours on the phone with questions that go unanswered and technological glitches. Its inspector general warned of signs of rampant fraud.

At the heart of many of the problems is the Office of Disaster Assistance, a little-known unit that issued nearly a quarter of the agency’s pandemic loan volume. In normal times, the office provides loans after floods and other natural disasters.

Since March 2020, the office has issued roughly $211 billion in pandemic-related Economic Injury Disaster Loans, three times as much aid as in the previous 68 years combined. In total, the office has provided roughly 9.8 million loans and grants totaling more than $230 billion, SBA data show. These pandemic responsibilities would have challenged even the best-run government agency. The office’s difficulties were compounded by the types of management and technological weaknesses identified over the years by government watchdog agencies.

“On the disaster side, we did a terrible job,” said Robert Scott, a former SBA Regional Administrator who spent several weeks in Washington early in the pandemic helping coordinate the agency’s response. “The existing systems in place, the existing leadership in place, just have not adjusted to what is necessary to meet the demand right now.”

Small firms accounted for 47% of the private sector workforce in 2017, the most recent data available, and after being disproportionately hit by the pandemic, they are lagging behind bigger companies as the economy reopens. Nearly one-third of small employers say it will take them more than six months to recover from the pandemic, according to a Census Bureau survey.

Business owner Samantha Harvey said glitches in an online application site in April made it impossible to submit documentation to request an increase in the amount of the disaster loan for her health-and-wellness company in Los Angeles. She said she called customer service three times and sent several emails but couldn’t learn what was causing the problem.

Roughly two weeks later, Ms. Harvey was able to submit the forms. She is still awaiting a decision.

Another request for a loan increase to support Ms. Harvey’s second business, a science communications and consulting firm, was denied because of a clerical error on her 2019 tax return, she said. Ms. Harvey tried explaining to customer service representatives that she had filed an amended return correcting the error. After trading several emails, she was finally told she had to begin a new, separate process to appeal the denial.

Dealing with the SBA “puts you in a state of confusion and doesn’t allow you to focus on what you should be doing, and that is to continue to rebuild your business after a pandemic,” Ms. Harvey said.

The SBA was responsible for administering the Paycheck Protection Program, which used private lenders to originate forgivable federal loans to pandemic-hit small businesses. The program, while hitting bumps, received bipartisan praise for issuing $800 billion in loans.

One problem was that the Trump administration gave priority to the PPP, to the detriment of the disaster office, said Sen. Ben Cardin (D., Md.), chairman of the Senate Committee on Small Business and Entrepreneurship. The disaster loan programs, he said, “suffered in the implementation speed, as well as the amount of resources small businesses should have been entitled to that they did not receive.”

SBA’s direct pandemic programs, including its new grant initiatives, are particularly important for minority-owned firms and businesses that may lack access to traditional financial institutions, he said.

The pandemic highlighted existing shortcomings in an office accustomed to dealing with natural disasters, usually in limited geographic areas. The Government Accountability Office had criticized the agency’s performance after Hurricane Sandy in 2012. It said the agency had made improvements by 2017 during Hurricanes Harvey, Irma and Maria, but still flagged problems with customer service.

The GAO in March added the SBA to its list of high-risk government programs, citing evidence of fraud, program integrity risks and a need for greater oversight. KPMG, SBA’s independent auditor, declined to express an opinion on the agency’s fiscal 2020 financial statements, noting that the SBA had “inadequate processes and controls.”

Isabel Guzman, the SBA administrator since March, said the agency’s staff, including those in the disaster office, faced the challenge of rolling out national programs to help millions of small-business owners.

“We’ve worked really hard to shift our focus and be as customer-centric as possible, and that’s a work in progress,” Ms. Guzman said. She cited the SBA’s partnership with financial technology companies to accept applications for a new $29 billion restaurant grant program. It launched smoothly May 3, coinciding with the easing of pandemic restrictions on public dining.

In less than two weeks, the restaurant program, run by the SBA unit that administered the Paycheck Protection Program, had distributed $2.7 billion in grants.

Live entertainment, including music and theater, has also begun to return. Yet a new $16 billion grant program for live venues, run by the disaster office, hasn’t kept pace. Roughly six months after Congress authorized the program, the SBA has awarded about $304 million in grants. On Wednesday, more than 200 members of Congress signed a letter asking the SBA to explain the delays and speed the flow of funds.

Ms. Guzman said the program’s rollout was delayed because of how it was designed by law.

The agency in the past week revamped its process to speed up reviews of venue grant applications, an SBA official said. Before the change, the process made it easy to shift responsibility for approvals from one person to another, delaying decisions, the official said. The SBA unit overseeing restaurant grants also recently began advising the venue program.

Call waiting

Customer service problems at the SBA, long an issue, have been particularly acute in the past year. Some callers last year waited more than four hours to reach a customer service representative, the inspector general said in an October report. The SBA said average wait time has dropped to less than 90 seconds.

The SBA’s customer service agents can answer basic questions about Covid-19 disaster aid, but early in the pandemic most representatives didn’t have access to applicant files. They can now provide status updates and insert notes into files, the SBA said. Yet many business owners continue to report that service agents can’t answer their questions about how to resolve issues that may be delaying their aid approvals.

Callers are sometimes referred to SBA’s 68 district offices, where local businesses usually go for help. District office workers can check the status of traditional SBA-backed loan applications, but for much of the pandemic they didn’t have access to applications submitted to the Office of Disaster Assistance.

“Every week, we would say, ‘Why can’t people in the field have access to the ODA system?’ ” said Michael Vallante, a former SBA associate administrator in charge of field operations who left the agency this year.

Ms. Guzman granted field offices access to loan files within days of taking office in March, the agency said. The SBA attributed the previous policy to the Trump administration.

The disaster office, which operates largely independently from the rest of the agency, has been led since 2009 by James Rivera, a career civil servant. He became a disaster loan specialist in 1989 and was put in charge of revamping the unit after criticism in the aftermath of Hurricane Katrina.

Mr. Vallante, Mr. Scott and other former SBA officials said Mr. Rivera and his leadership team were reluctant to share information or take suggestions. The SBA didn’t make Mr. Rivera available for comment but said he was committed “to strong and close coordination” with field offices and others.

Congress charged the disaster assistance office at the start of the pandemic with issuing grants to small businesses, something it had never done. The SBA distributed $20 billion in grants last year, but it has been slow to hand out the $35 billion in additional grants authorized by Congress more recently. As of June, the SBA had approved nearly $1.8 billion of that money.

ABC Airbrush in Dalton, Ga., which decorates helmets at youth baseball and softball events, was closed for six months last year. Owner Lisa Holmes applied for a grant on Feb. 7, the week the program opened.

The SBA is supposed to deliver the money within 21 days, but Ms. Holmes didn’t receive her grant until May, roughly three months after she applied. “Seems like they’re moving along, just very slowly,” said Ms. Holmes. Trying to get answers about the status of her application was a full-time job, she said.

Ms. Guzman said SBA was working to meet the 21-day goal.

False claim

Beyond problems getting aid money into the hands of those who need it is the problem of keeping it from thieves. In its October report, the SBA’s inspector general said the agency had “lowered the guardrails” to get aid out quickly. The SBA has disputed this characterization.

By February, the SBA had approved roughly $79 billion in potentially fraudulent disaster loans and advances, including multiple loans and advances made to applicants using the same IP addresses, email addresses, bank accounts or physical address, the inspector general’s office told Congress.

The SBA said it has since added safeguards. More than 160 SBA employees are working to address fraud, Ms. Guzman said, adding that Congress initially barred the agency from accessing tax documents, an important fraud prevention tool.

Last year, the SBA notified Neal Siegal, a commercial real-estate broker and property manager in Glen Cove, N.Y., that payments on his $9,400 SBA disaster loan were deferred with interest accruing, and the first payment was due on August 5, 2021. He had never taken out such a loan.

After filing a Freedom of Information request, Mr. Siegal received a loan document with his name listing a false phone number and email address. He contacted the SBA, the police, the Federal Bureau of Investigation and the Federal Trade Commission.

In late May, shortly after an inquiry from The Wall Street Journal about his situation, the SBA sent Mr. Siegal a letter that promised the government wouldn’t try to collect from him.

“Damage has been done,” Mr. Siegal said in an email, “including the great many hours (possibly hundreds) it cost me and the expense of trying to re-secure my identity.”

Tech trouble

As of January 31, the SBA has agreed to pay more than $890 million during the pandemic to outside contractors to assist the Office of Disaster Assistance with loan processing, customer service and other functions, according to a June GAO report. The disaster office increased its staff to about 10,000 full-time, temporary, and contract workers, the SBA said, up from roughly 1,000.

Loan processors were expected to review a dozen applications an hour, a task made more difficult because of shifting requirements and guidelines, said a former SBA official who helped process loans. The SBA said loan processors are now expected to review 22 applications a day and that the processing department provides written guidance to loan officers.

Technology snafus marred the launch of the Shuttered Venue Operators Grant initiative, designed to provide $16 billion to stricken theaters and other live venues. When the program opened in April, business owners struggled to register, received error messages and couldn’t upload required documents. SBA temporarily closed the application portal within hours.

A senior SBA official said the agency and Salesforce, its technology partner, had tested the portal for two weeks before the failed launch. At the time, a Salesforce spokeswoman said it worked with the SBA to resolve the initial technical issues, and that it was continuing to work with the agency.

One problem was the file upload function didn’t work because certain technology licenses hadn’t been registered, an oversight the SBA official called “a forgotten detail.” The SBA on Thursday said Salesforce had been responsible for registering the licenses. Salesforce didn’t immediately provide comment.

Elliott Cunningham, managing director of New London Barn Playhouse, said he spent about 50 hours preparing his grant application, gathering documents and studying a 57-page user guide. Income at the New Hampshire theater company had fallen 90% last year, he said. The technical glitches prevented Mr. Cunningham from submitting his application the day the program launched.

He successfully completed an application when the program reopened in late April but still hasn’t heard whether it has been approved. The theater is slated to reopen this summer, he said, and “Right now, I’m spending that money, even though I don’t know if it’s coming.”

Filed Under: Uncategorized

PPP Loan Forgiveness Calculator

April 23, 2020 By Thomas Fox

Hopefully, you’ve managed to have your PPP application approved and the funds have been disbursed. If not, don’t lose hope. Round two is coming!

I’ve put together an Excel spreadsheet to help in calculating the amount of a PPP loan that may be forgiven. I say “may” because the final rules on forgiveness aren’t published yet, so the spreadsheet is based on my current research and published guidance so far.

It’s a pretty basic sheet. The amounts you need to enter are shaded in green. Here are some tips:

  1. Enter the total amount of your PPP loan in the “PPP Loan Amount” field. This should be your total/net PPP disbursement.
  2. Enter the date the funds hit your account in the “Date funds disbursed” field. Current guidelines are that you have eight weeks to accumulate the amounts used to calculate the forgiveness component of your loan. This (hopefully) will change, but at the moment, you have 56 days from disbursement to allocate the funds.
  3. Enter your average number of full-time-equivalent employees (FTEs) for the period January 1, 2020 through February 29, 2020 in the “Avg FTEs 1/1 to 2/29” field. Calculate your average FTEs by averaging the number of FTE employees for each pay period in the look-back period. If you employ part time employees, it is possible this number could half a half FTE (i.e., 3.5). The spreadsheet will calculate your average number of FTEs during the eight week measurement period.
  4. Begin entering your eligible expenses! I’ve broken the categories into broad sub-categories based on the PPP guidelines published by Treasury, and included a line for each date in the eight week measurement period, since you most likely pay various expenses on different days of the month.

Some general thoughts on expense categories, based on my reading of the guidance from Treasury and a couple of accountant websites.

Allowed Payroll Costs

Salary and wages are pretty self explanatory. Use the gross wages paid to your team members (including yourself if you take a paycheck).

Commissions are again self explanatory. Be careful to only include commissions you’re normally pay. There are restrictions on front-loading payroll costs to get them into the eight week measurement period, the specifics of which I’ll leave for you to research.

Tips should be included if you report your team member’s tips as part of payroll.

Number of FTEs should be the number of full-time-equivalent employees on that payroll run.

Healthcare costs should be the amount the company pays for your team member’s healthcare – be sure to not include an amount the employee contributes out of their check toward the healthcare costs. For example, if the company pays half of the cost of insurance, and the employee has an amount deducted from their check to cover the other half, you can only include the amount the company pays.

Retirement costs would be any amount the company contributes toward the employee’s retirement costs, such as a 401k or SIMPLE-IRA contribution. Again, only include the actual amount the company pays, and not any amounts deducted from your team member’s payroll.

State Taxes would be an amount levied against the company based on the amount of compensation. The best example of this would be state unemployment insurance contributions. This amount should not include any state withholding taxes deducted from your employee’s checks – only an amount the company is required to pay as a result of compensation.

Local Taxes follow the same guidelines as the state taxes.

The spreadsheet will calculate the the total payroll cost for the line, and accumulate payroll costs for the eight week measurement period.

Occupancy Costs

Mortgage Interest is pretty self explanatory – include the amount of mortgage interest you pay toward occupancy of your building. Do not include the principal portion. You also can’t front-load this expense by paying months ahead, in order to increase the forgiveness amount of your PPP loan. If you’d normally make two mortgage payments in eight weeks, only include two payments worth of mortgage interest in the spreadsheet.

Rent is obviously the amount of rent you pay for your business (or, the amount of your home office deduction if you regularly include home office deductions on your federal income tax return). Again, if you’d normally only pay two months of rent in the eight-week period, you can only include two months of rent here.

The spreadsheet will calculate the total occupancy costs for the eight week measurement period.

Utilities

There are multiple interpretations of what counts as a utility for purposes of PPP forgiveness, and I expect you’ll see this change over the next few months. In general, the consensus across the articles I read align with what I’ve included in the spreadsheet.

Electricity is the gross amount of your electric bill.

Gas is the gross amount of your natural gas bill.

Water is the gross amount of your water bill. There’s no specific guidance on this, but if your municipality bills quarterly for water (as mine does), and you don’t get a bill during the eight week measurement period, I think it would be a fair interpretation to use two-thirds of the water bill in your forgiveness calculation. I am NOT an accountant and I could be entirely wrong on this. Use your judgment or that of your accounting professional!

Transportation/fuel has been interpreted to mean fuel costs for business vehicles during the measurement period.

Telephone would be your landline, VoIP and cell phone costs during the eight week measurement period.

Internet is your gross Internet access costs incurred during the measurement period.

Forgiveness calculations (the good stuff!)

These are tough calculations to do in a spreadsheet, because there are a bunch of if/then requirements. I’ve done my best, and I think the calculations will work and be accurate in most cases except where you’ve had a reduction of more than 25% in the total payroll costs for your team. For example, you’ve maintained FTE head count, but everyone has gotten a 50% pay cut. If that’s the case, stop here because this spreadsheet doesn’t take that into account at all.

The spreadsheet calculates the total payroll cost by summing the totals of each payroll line during the eight week measurement period, and generates a percent of total PPP loan for informational purposes.

Likewise the spreadsheet sums all non-payroll costs and calculates the percent of total PPP loan. This calculation is important, because only 25% of the PPP loan may be forgiven for non-payroll costs.

The amount forgiven for payroll costs will be the total of your payroll costs, up to the amount of your PPP loan less allowable non-payroll costs.

The amount forgiven for non-payroll costs is calculated as the total of all non-payroll costs up to 25% of the PPP loan amount. Amounts above 25% of the PPP loan amount are discarded.

The total forgivable amount is calculated as the sum of your total payroll costs plus the allowable amount of your non-payroll costs, up to the amount of your PPP loan.

HOWEVER, the forgivable amount is reduced using the forgiveness calculation.

The forgiveness calculation is computed simply as the number of FTEs during the period of January 1, 2020 through February 29, 2020 divided by the average number of FTEs during the eight week measurement period. If your forgiveness calculation is above 75%, you’re in good shape! If the forgiveness calculation is below 75%, the amount calculated as potentially forgivable is computed as the forgivable amount times the forgiveness calculation. For example, if you had 10 full time equivalent employees before the pandemic, and during the eight week measurement period you had only 5 FTEs (meaning you only had 50% of your FTE staff during the eight week measurement period), the forgivable amount of your PPP loan is only 50% of the potential forgivable amount.

The final calculation is the amount you may owe – computed as the total of your PPP loan less the potential forgivable amount.

The important disclaimer

I am not an accountant or an attorney!

I put the spreadsheet together based on my reading about the PPP and WSJ articles about the forgiveness component, some accounting blogs, and the websites of some of the banks and fintech companies participating in the PPP program.

This spreadsheet is likely not 100% accurate, and may, in fact, be 100% wrong.

Please only use it as a guide for helping you and your financial professional to track expenses related to your PPP loan.

In our office, we are keeping track of the expenses in this spreadsheet, but I am also keeping copies of everything related to any expense I’m counting. So, paper copies of payroll journals, copies of payroll checks, copies of utility and health care bills along with the checks used to pay them (or if paid online, the credit card receipt). The goal for my company is to keep a super-clean journal of every expense, followed up with physical proof of the expense.

That way, when “they” come – and, we know they will – I can simply hand whomever is auditing the forgiveness component a copy of the spreadsheet and a folder/binder of every check, invoice and receipt as backup for the expense.

I hope you find the spreadsheet and information useful, and please let me know if you find any errors or updates!

Download the spreadsheet here: PPP_Loan_Forgiveness_Calculator

Filed Under: COVID19

The new paradigm

March 24, 2020 By Thomas Fox

There’s a lot I could write about the new reality in which we live, and I’ll get around to that eventually.

In the meantime, here’s the PDF and Word documents for the social distancing door sign we’re using.

Filed Under: COVID19

CSAT surveying alternative to paid services

May 15, 2019 By Thomas Fox

So here’s the info on how we set up CSAT using our WordPress website, Gravity Forms, and the ConnectWise surveys API.

Someone asked about BrightGauge reporting – that’s the cool thing about this! Because it is using the ConnectWise survey API to record the responses on the ticket, standard BrightGauge reporting works.

Here is the SQL to create the dataset in BrightGauge:

SELECT
AVG([dbo].[v_rpt_Surveys].[Score])*100 AS 'Average(Score)',
[dbo].[v_rpt_Surveys].[SurveyName] AS 'Survey Name',
NEWID() as id
FROM [dbo].[v_rpt_Surveys] WITH(NOLOCK)
WHERE  ([dbo].[v_rpt_Surveys].[SurveyName] = 'CSAT Survey')
GROUP BY [dbo].[v_rpt_Surveys].[SurveyName]

 

BrightGauge CSAT gauge

To get started, you’ll need to create your CSAT survey in ConnectWise. Most of this stuff won’t matter:

[Read more…] about CSAT surveying alternative to paid services

Filed Under: ConnectWise Tagged With: connectwise, csat, gravity forms

Creating Daily Admin Time Wrap Entry

May 9, 2019 By Thomas Fox

At the beginning of each day, each service team member creates an admin time entry that is used to record all of the unassigned time between other tickets.

This time entry should be 15 minutes or less each day. If it is longer, make sure there is an explanation written in the admin entry notes. Small tasks such as “Restarted ConnectWise to apply updates” would be recorded here.

  1. After saving all other time entries for the day, note the Total Hours number at the bottom of your time sheet
  2. Click the + icon to create a new time entry
  3. Type Admin in the Charge To field, press TAB, click Admin
  4. Type 8 in the Start Time field then press TAB
  5. Type 5 in the End Time field then press TAB
  6. Enter your Total Hours number in the Deduct field
  7. Set Work Type to Admin
  8. Set Billable to Do Not Bill
  9. Save and Close this time entry
  10. Check your Total Hours at the bottom of your time sheet again, it should now be 9.00
  11. If it is not 9 hours, modify the deduction time on the admin entry until it is

Filed Under: ConnectWise

  • Page 1
  • Page 2
  • Page 3
  • Go to Next Page »

Primary Sidebar

Recent Posts

  • From the Wall Street Journal: Small Business Needed Federal Help. The Agency in Charge Fell Short
  • PPP Loan Forgiveness Calculator
  • The new paradigm
  • CSAT surveying alternative to paid services
  • Creating Daily Admin Time Wrap Entry

Social

  • Facebook
  • LinkedIn
  • Twitter

© Thomas Fox. All Rights Reserved. Privacy policy