I'm working with Intuit Online Payroll for Accounting Professionals, Paychex and SURE Payroll.
Paychex and SURE put out a wonderful report of 12 lines, one for each month and contains all the necessary payroll information for PPP.
IOP doesn't produce a report with multiple months totaled.
I have to pull 15 seperate payroll detail reports with summary by employee.
15 of these. I have over 50+ clients. Depending on the employee count this could be multiple pages per month. The size of 15 mons of PDF's is huge.
There should be more report customization. The excel file are not filter/sort anything. Even if you put an option to download as .csv would allow many to be able to filter/sort/pivot reports to their needs.
Good evening, @G5salon.
Thanks for following this thread.
We're working diligently to make this application and funding process available for our customers as quickly as possible. More information should be coming to you shortly. In the meantime, I recommend checking into What is the Paycheck Protection Program for more details.
Please let me know if there is anything else that I could assist you with. I'll be here to help you every step of the way. You can always reach back out to the Community or me anytime you need a helping hand. Take care and stay safe!
QB representatives continue to ignore the requests for the program to generate PPP loan numbers, as all of the other payroll services have offered to their users. Unbelievable. I would urge all small business owners to reconsider payroll service companies once we get on the other side of this.
Actually, some of us would really just like easily accessible, quality PPP reports. Sure, some of us more experienced folk can do it on our own, however, many out there do not know how to properly calculate and your payroll competition has excellent reporting on the topic and are being incredibly helpful WHILE ALSO offering their own lending services ... just saying ... Shout out to GUSTO, ADP, PAYCHEX, CAPS, et al ...
Our bank accepted this:
I went to employees-
Payroll tax forms and W2's-
Tax form work sheet in Xcel
the choice of reports box pops up...
choose annual W-2/W3s
and pick your date range for 2019
I ran a seperate one for 2020
When this report populates....at the top are all your summaries of the payroll costs they want.
I then divided that total by 12.
and to make sure...I included payroll summaries by month.
my banker said it was perfect.
Oh yeah and of course included our 940, and 941's 2019 and 1QTR 2020
Hope that helps
In regard to this loan, I wanted to know the best most accurate way of entering this into our QB system once the money is received?
Do we need to enter this as a Loan or differently?
That answer is BS. Yes, a sample PPP form exists on the SBA website, but not a single lender uses it. If you don't already have a banking account relationship with them, they won't talk to you. And if you do, they have their own forms. Nobody uses the rev 1.0 sample form that the SBA drafted in March.
I understand applying for the PPP can be complicated and were doing everything in our power to help with the process. We created a couple articles that go over how to apply for the PPP and what information you can find within the company file to help with the application.
These can help with the application process. If theres anything else I can do to help let me know by commenting below.
It's not very complicated at all. The challenge is finding a required and competent FDIC -nsured lender to carry your 2-page application to the SBA. and get your loan in line. Where Quickbooks get lost, was focusing on building FAQ's on extracting supporting payroll reports from your database, to enable a thrid-party lender to fulfill their obligation of verifying the information to the SBA. The more important element, was completing that evaluation process and submitting the packet to the SBA fast. Where we were all let down is the position of, "We're working as quickly as possible to launch a simple application and funding process for the [PPP] from within Quickbooks." There clearly wasn't enough time to factor in software development into the application process, before the all of the Federal funds dried up. That's exactly what happened today. It's not just Intuit - Many mainstream lenders, such as Bank of America, Bank of the West, and others let their customers miss out on getting the PPP applications into the SBA queue in a timely manner. Meanwhile, other late coming secondary financial firms, such as PayPal and Veem, were very aggressive, and provided 24-hour turns on applications processing. The bottom line is use your gut instincts to navigate the waters, to find the application partner who can come through, when time is critical.
Hi there, RLJ11.
When it comes to getting these reports into excel, I can help. After you get the correct payroll report to help you apply for a loan under the Paycheck Protection Program. You export it to excel by following these steps.
For QuickBooks Desktop:
For QuickBooks Online
Keep in mind if you’re missing data when you open the report in Excel, the file's in protected view. In Excel, you’ll need to select Enable Editing to view the full report. If you have any questions please let me know.
Good Morning If I run a. Business where my employees are getting paid in cash or bank check My LLC filing started in November 2019 by started making revenue starting 2020 How do I go about doing the payroll records is there a excell I can fill out I also have my entity filling and only carry 4 employees
Hi Mdiaz2387. If you've paid your employee using a physical check, you can just create a regular payroll. Just make sure you're using paper check for recording purposes.
First, let's run a regular payroll:
Once completed, let's create a bank transfer in QuickBooks to account for the movement of money from Cash on Hand or Petty Cash to your payroll bank account.
Alternatively, you can create a journal entry to record the entire transaction. For more detailed steps, you may check this article: Create a journal entry.
For additional reference, you can check these links:
Let me know if you need anything else. I'm always here to help.
QuickBooks does provide a payroll register report with its CPA version of payroll processing. We are considered the 3rd party processor who provides the report to the customer. One possible idea for you as a starting point is to run a Payroll Summary Report and double-click the number in the Total column for gross pay. You will then get a list of transactions you can subtotal and manipulate in Excel.