Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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.
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?
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?
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:
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.
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.
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here