cancel
Showing results for 
Search instead for 
Did you mean: 
Blozada
Level 2

PTO PerPaycheck accrual

Hello! I want to run a report that comes back in list form with employee names and how much PTO they Accrue per paycheck. It would be great if the report also came with their date of Hire. 

 

The paid time off report only includes vacation available VS used. The employee sick and vacation history report has the accrual rate, but because of the formatting on the report, I'm not able to easily manipulate it  to form a  list.  

Solved
Best answer February 12, 2020

Best Answers
JessT
QuickBooks Team

PTO PerPaycheck accrual

It’s good to see you here in the Community, Blozada!

 

You're right. The report you mentioned will only show the summary, that's why we can't customize it more to show the per paycheck data. However, you'll be happy to know that QuickBooks can create an Excel report for this. Here's how:

  1. From the Reports menu, choose Employees & Payroll.
  2. Select More Payroll Reports in Excel.
  3. Choose Employee Sick & Vacation History.

The report will look like this screenshot:

 

 

Maybe you need other reports related to Time Offs in the future, please refer to this article: Report an employee's vacation and sick time used, available, accrued, and limits.

 

We're always right here if you have other questions in mind.

View solution in original post

Blozada
Level 2

PTO PerPaycheck accrual

This report has the information I need. But it's not easy to manipulate because the employee name is not aligned in the row with the rest of the data. If I audited every employee one by one, this report would work. 

View solution in original post

6 Comments
JessT
QuickBooks Team

PTO PerPaycheck accrual

It’s good to see you here in the Community, Blozada!

 

You're right. The report you mentioned will only show the summary, that's why we can't customize it more to show the per paycheck data. However, you'll be happy to know that QuickBooks can create an Excel report for this. Here's how:

  1. From the Reports menu, choose Employees & Payroll.
  2. Select More Payroll Reports in Excel.
  3. Choose Employee Sick & Vacation History.

The report will look like this screenshot:

 

 

Maybe you need other reports related to Time Offs in the future, please refer to this article: Report an employee's vacation and sick time used, available, accrued, and limits.

 

We're always right here if you have other questions in mind.

View solution in original post

Blozada
Level 2

PTO PerPaycheck accrual

This report has the information I need. But it's not easy to manipulate because the employee name is not aligned in the row with the rest of the data. If I audited every employee one by one, this report would work. 

View solution in original post

8612djj
Level 1

PTO PerPaycheck accrual

I am an employee and would like to see my PTO accrual and use.  How can I see that?

Jovychris_A
QuickBooks Team

PTO PerPaycheck accrual

Thanks for posting to the Community, @8612djj.

 

You can contact your employer to check and use your PTO accrual balance. I'm sure they'll give you the information you'll need.

 

Also, I'll add this article as your references on how your employer invites employees to view their pay stubs online: Invite employees to see pay stubs and W-2s online.

 

If you have more questions about how you can view your paycheck online, you can chat with us every 6:00 AM to 6:00 PM from Monday-Friday.

 

Please let me know if you have more questions. I'm always here to help. Take care!

Kimba71_123
Level 1

PTO PerPaycheck accrual

That data is not valid though.  When I reconciled the balances are wrong.

DivinaMercy_N
QuickBooks Team

PTO PerPaycheck accrual

Hi there, @Kimba71_123.

 

There are possible reasons that the Beginning Balance is zero or incorrect such as:

 

  • No balance or an incorrect balance was entered when the account was set up.
  • Previously cleared and reconciled transactions were voided, deleted, or modified.
  • The file was converted from a different version of QuickBooks.
  • Possible data damage.

 

Here's how to fix an incorrect balance: 

 

Run the Reconcile Discrepancy report

  1. Go to the Reports menu, then click Banking, then Reconciliation Discrepancy.
  2. Choose the appropriate Account, then hit OK
  3. If you find a discrepancy, note the transaction date and the Entered/Last Modified, which will tell you when the change occurred.

Run the Audit Trail report

  1. Go to the Reports menu, then choose Banking, then Previous Reconciliation.
  2. Select the appropriate account being reconciled.
  3. Pick the most recent statement date. Choose Transactions cleared at the time of reconciliation. (Report is displayed as a PDF file) then Display.
  4. Note the statement and the reconciliation creation date.
  5. Go to the Reports menu, then select Accountant & Taxes, then Audit Trail.
  6. Set the Account filter to the account being reconciled.
  7. Go to the Display tab. Set the Date filter with the From field blank and the To date set to the statement date.
  8. Hit OK.
  9. Set the Entered/Modified filter with the From date set to the previous reconciliation creation date from the PDF, and the To field as today's date.
  10. See if any of the transactions in the report can account for the discrepancy.

For more details, you may refer to this article link: Fix beginning balance issues in QuickBooks Desktop.

 

Also, I'd be adding a helpful article that may help you when you have QuickBooks Desktop concerns, such as managing your account, set up and process payments, etc. This will help to keep your business to run smoothly: QBDT Help articles.

 

Get back to us here if you have other questions. Take care always. 

Need to get in touch?

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