Year End Payroll Accrual Reports

Thanks for dropping by here in the Community, @Sandi333. I'll walk you through the process to help you get the payroll data that you need in your QuickBooks Desktop (QBDT) company.

Know that you can customize the Payroll Summary report and choose a specific date to see the data for the last week of the year. This way, only significant detail appears in your payroll report. I'll gladly input the steps below to get you started. To begin, here's how:

1. Access your QuickBooks Desktop company.
2. Go to the Reports menu.
3. In the Search bar, type the Payroll Summary and then click it.
4. Press the Customize Report button above the Date section.
5. Input the specific date.
6. Once you're ready, click the OK button.

For more details about modifying a payroll report in QBDT, please see this article: Customize payroll and employee reports.

In addition, if you want to keep your current report settings and have them carry over the next time you run the report, feel free to visit this page: Create, access and modify memorized reports.

Also, if you got time to spare, I recommend checking this article to learn more about how to set up reports and scheduled them in QBDT: Set up and modify Scheduled Reports.

Thanks for choosing QuickBooks for your business, @Sandi333. Feel free to post here again if you need help performing specific tasks inside your company file. It'll be my pleasure to assist you once again. Take care, and have a good one! 

Thank you KurtKyle - 

I tried this - but unfortunately, it does not break down the last week of the year vs the 1st week.  It only gives me the total from the paydate.  It must have something to do with importing the IIF file from our timeclock.

Appreciate your help.

Thanks for getting back quickly and following the steps above, @Sandi333. I really appreciate it. 

Let me add additional customization steps to achieve your reporting task in QuickBooks as early as possible. 

Ensure that the reporting period is accurate and the Show columns field is filtered to Week. This way, you can see the employee week breakdown. See the sample screenshots below for more reference: 

If the issue persists, I advise you to review your IIF file data. This may be the reason why you can't see the employee payroll breakdown. For further help checking the data, please contact an IT professional, as Intuit doesn't offer assisted technical support for IIF. 

In addition, check out the following articles below to know how to review IIF errors and other tasks you can do to your data:

• Improved IIF Import in QuickBooks 2019 and later
• Tasks you can do with IIF files

You're always welcome to reply if you have other questions about managing your employee reports. I'm enthusiastic about helping you again. Keep safe!

We have a similar issue....This report will not show the hours-salaries that have not been paid.  We need the unpaid wages to be able to accrue the payroll.  In other words, consider this example

°Last payroll for the year falls on 12/27/2024 for pay period 12/72024 to 12/20/2024

°Need to accrue payroll from 12/21/2024 to 12/31/2024

Which QBDE report can I run to get this information

Thank you!

Thank you for staying engaged with this conversation, icllc. I'll provide a thorough explanation of how the data is presented in the report to ensure clarity.

The information on the report will be based on the data you've entered or recorded in QuickBooks Desktop (QBDT).

If you've entered unpaid wages as Timesheet or Expense, you can run the Time by Name report to get the information needed.

Here's how:

1. From the Reports menu, select Jobs, Time &Mileage.
2. Choose Time by Name.
3. Double-click the hours to show the Billed and Unbilled hours.

If not, can you please tell me how you’ve entered them into the system? Any additional details will help me provide a timely solution.

Additionally, I've attached these articles to expand your knowledge in discovering more about how to maximize your reports to extract the required information: 

• Customize reports in QuickBooks Desktop
• Create, access, and modify memorized reports.

I'll be on the lookout for your response if you have further questions about running reports and will address them as soon as possible.