Employee Payroll Journal without Excel?

Forum|Forum|4 years ago
January 12, 2022
2 replies
16 views

When you Export Payroll Data to Excel you get an Employee Journal sheet. I use this heavily but have to modify it and format it. With older Quickbook versions I could "get Quickbooks data" and it would update this information. Now when I try to Update Report, it says this is a report Quickbooks cannot update. I would have to export it each week and then modify and reformat it each week.

Is there a way to get this report (Employee Journal) from within Quickbooks without exporting it to Excel? Then I could modify and save it. I am trying to avoid having to export, modify, and reformat it each week.

QuickBooks Desktop

BigRedConsulting

Level 15

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.

SunburstAuthor

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

Fiat Lux - ASIA

Level 14

@Sunburst

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

https://transactionpro.grsm.io/qbd

SunburstAuthor

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?

BigRedConsulting

Level 15

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

SunburstAuthor

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.

Sign up

Login with SSO

Let's get you signed in

Login with SSO