Employee Payroll Journal without Excel?

It should work the same way as before. Make sure you're not using the "QuickBooks" tab in Excel as that's not designed to update the payroll reports. Instead, use the interface each payroll report creates, I think on the Add-ins tab.

I have nothing under my add-ins tab. I don't know how to get to the "interface" you are referring to?

@Sunburst 

Utilize an exporter tool to get a Payroll Detail Report in XLS.

https://transactionpro.grsm.io/qbd

So there is no way to get an employee journal report from within Quickbooks without having to export to excel?  And no way to update a payroll report in excel without additional software?

A payroll detail report is not in a format I can use.  I need the Employee Journal page that is created when you Summarize Payroll Data in Excel.  Attaching screenshots. 

Thanks for sharing a screenshot, @Sunburst.

The option to create an employee journal page without summarizing payroll data in excel is unavailable. Thus, you have to view it outside QuickBooks. 

To generate the Summarize Payroll Data in Excel report, follow these steps:

1. Under Reports from the QuickBooks menu, choose Employees & Payroll and select Summarize Payroll Data in Excel.
2. If prompted by the Excel security warning, follow the directions to enable macros in Excel.
3. From the QuickBooks Payroll Workbook - Welcome screen, click OK.
4. Enter a date range, then select Get QuickBooks Data.
5. Click the State Wage Listing tab at the bottom.

Moreover, you can check out our other Excel-based payroll reports in this article: Excel reports available in QuickBooks and how to generate them. 

The Community always has your back, so please let me know if you have any other questions. I'll be more than happy to help. Keep safe.

Correct Image

Why am i not able to update any payroll reports in excel?  Even if I do not modify the report at all, it does not update.  I get a message that it may be from an older Quickbooks version (it's not) or it is not a report QB is able to update.

Hi Sunburst,

Thanks for the screenshot. Let me route you to a team that can check this further.

I recommend contacting our Support team about this issue. That way, they can check why your QuickBooks will no longer update your existing report.

1. Go to Help, then select QuickBooks Desktop Help.
2. Select Contact Us.
3. Enter your concern, then select Continue.
4. Choose a way to connect with us:
   • Start messaging with a support expert.
   • Get a callback from an expert (availability may be limited).

You can also check for more references about payroll on the main support page. Just select the QuickBooks Desktop Payroll product and click More topics.

If you have other questions in mind, feel free to go back to this thread.

---

@Sunburst wrote:

I have nothing under my add-ins tab. I don't know how to get to the "interface" you are referring to?

---

When launching the Summarize Payroll In Excel template from the QuickBooks Reports menu or payroll center, a window should appear with options for the date range and the reports to run. After you run them, a custom "toolbar" should appear in Excel under the Add-ins tab.

---

@Sunburst wrote:

So there is no way to get an employee journal report from within Quickbooks without having to export to excel?  And no way to update a payroll report in excel without additional software?

---

There isn't a report like your screenshots within QuickBooks. You don't need any additional software. Just Excel.

When launching the Summarize Payroll In Excel template from the QuickBooks Reports menu or payroll center, a window should appear with options for the date range and the reports to run. After you run them, a custom "toolbar" should appear in Excel under the Add-ins tab.

The add-ins tab is there the first time I create the document.  After I save the document and go back to it, it is gone.  I do have "add ins" checked in my ribbon bar to show.