cancel
Showing results for 
Search instead for 
Did you mean: 
TimKeogh
Level 1

PPP loan documentation

John, could I get a copy of your spreadsheet. I work for Numerated who is releasing an automated PPP Loan platform.  Thanks  [email address removed]

SandyK
Level 1

PPP loan documentation

Yes I had the same issue. Remove the columns for hours and rate. That worked for me.

Fiat Lux - ASIA
Level 15

PPP loan documentation

additional resource

https://veem.grsm.io/sba-ppp

 

Hope it helps.

jedwarrior
Level 1

PPP loan documentation

Hi John-Pero,

Will you please send me a copy of the excel document mentioned in your earlier post about ppp documentation.

 

Thank you.

 

Jedwarrior

[email address removed]

pppfudt01
Level 1

PPP loan documentation

Hey John can you send me a copy excel doc.

[email address removed]

G5salon
Level 1

PPP loan documentation

Can you tell me the exact date Quickbook opens their application process so I can apply the PPP through quick book. Thank you 

norx1
Level 1

PPP loan documentation

Good Afternoon!

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. 

Tori B
QuickBooks Team

PPP loan documentation

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! 

 

Steve148
Level 1

PPP loan documentation

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. 

KRoehl
Level 1

PPP loan documentation

Could I also get a copy of your banks spreadsheet? Thanks!

shirap
Level 1

PPP loan documentation

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 ...

Vthunder
Level 2

PPP loan documentation

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

 

 

cklippen
Level 1

PPP loan documentation

Hi @john-pero , Could you please send me the excel file? Thanks! [email address removed]

 

AndieLBpse
Level 1

PPP loan documentation

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?

WP-Sig
Level 1

PPP loan documentation

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.

G5salon
Level 1

PPP loan documentation

Did QuickBooks ever started the PPP lending? We keep waiting and now the funds are gone!

MaulikH
QuickBooks Team

PPP loan documentation

Hi, G5Salon.

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.

WP-Sig
Level 1

PPP loan documentation

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.

rlj11
Level 1

PPP loan documentation

Hi. How can I get the excel sheet for payroll report. My bank did not send one to me.

MaulikH
QuickBooks Team

PPP loan documentation

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:

  1. Select the Excel on the toolbar. You can also select Print or Email to save the report as a PDF.
  2. To create a new Excel workbook, select Create New Worksheet. If you want to update an existing workbook with the data in the open report, select Update Existing Worksheet. Select Browse and then find the workbook on your computer. Keep in mind, this overwrites the existing workbook.
  3. When you’re ready to export, select OK. To open the report in Excel, you can also select Export.

For QuickBooks Online

  1. At the top of the report, select the Export icon. Then select Export to Excel.
  2. Save the file somewhere you can easily find, like your Downloads folder or your desktop.

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.

Mdiaz2387
Level 1

PPP loan documentation

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 

Steve_C
QuickBooks Team

PPP loan documentation

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:

  1. Go to the Employee's menu.
  2. Choose Employees.
  3. Select the Run Payroll button.
  4. If you're using different pay schedules, choose the specific pay schedule for the paper check.
  5. Click Continue
  6. Mark the name of the employee.
  7. Enter the employee paycheck, then click Preview Payroll.
  8. Hit Submit Payroll.
  9. Click Finish 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. 

  1. Click the Plus Icon (+).
  2. Choose Transfer.
  3. From the Transfer Funds From drop-down list, select the bank account that the funds are coming out of.
  4. From the Transfer Funds To drop-down list, select the bank account the funds are being deposited into.
  5. In the Transfer Amount field, enter the amount being transferred.
  6. Edit the Date.
  7. Add a memo on the Memo field to indicate the reason for the bank transfer.
  8. Click Save and Close.

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.

LizCPA
Level 2

PPP loan documentation

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. 

Antayala93
Level 1

PPP loan documentation

Hey can you send me a excel document to [email address removed] my bank does have one thanks sir 

Seasons1
Level 1

PPP loan documentation

I agree!  QB needs to come up with a way to generate this.  

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us