cancel
Showing results for 
Search instead for 
Did you mean: 
Deadwood Al
Level 6

Another oddball report question ....

Is there a way to print the data from a list ... for example, the Payroll Item List ... that would show what GL account the list item (for example, the deductions or additions) will post to when that item is used in Payroll? I'd like to be able to have a quick and easy reference when creating a new GL structure. I know I can view the detail online one item at a time, but that takes to long. I'd like a printed report ... hopefully one I could choose what components to include ... that I could refer to very easily.  Hopefully waiting for a positive answer ....

 

And BTW, this is not only for the Payroll Item List ... it would apply to any list where they list items are referenced to a GL account to post transaction values.

 

Thanks for the input

5 Comments 5
Kurt_M
QuickBooks Team

Another oddball report question ....

Thanks for reaching out here in the Community space, @Deadwood Al. I'll share details about printing data or reports with specific details inside QuickBooks Desktop (QBDT).

 

When printing Payroll item list data from the Employees or List menu, know that the option to add a column or section to see what account the list item will post to when used in payroll is unavailable. It'll only show you what items you've added to the page. Thus, the same data will appear when you're ready to print them out.

 

As a workaround, we recommend running the Payroll Item listing report and customizing it to add columns needed. This way, you can use it for reference when creating a new GL structure inside your company file. We'll write down the steps to get you going:

  1. Access your QuickBooks Desktop company.
  2. Click the Reports menu and then select Report Center.
  3. In the Search bar, enter Payroll Item List and then click on it.
  4. Click the Customize Report button, and then choose what columns you want to include in your report.
  5. Once done, click the OK button.


If the columns you need don't show when modifying the report, you can export them outside the program and manually edit the Payroll Item Listing report to add the extra columns and data. Refer to this article for more details about exporting reports: 
Export reports as Excel workbooks in QuickBooks Desktop.

 

Moreover, here's an article to help you keep your current report settings after customizing it inside the program: Create, access and modify memorized reports.

 

Our team encourages you to post or comment below if you need further assistance printing data or reports inside QuickBooks or have additional questions about the program. We'll make sure to respond as soon as possible. Keep safe and have a good one.

BigRedConsulting
Community Champion

Another oddball report question ....

RE: Is there a way to print the data from a list ... for example, the Payroll Item List ... that would show what GL account the list item (for example, the deductions or additions) will post to when that item is used in Payroll?

 

Not from the list itself, but you can do it by starting at Reports | List | Payroll Item Listing. The report's default columns include the liability and expense account fields. You can modify the columns to show just what you want and print it from there.

 

RE: And BTW, this is not only for the Payroll Item List ... it would apply to any list where they list items are referenced to a GL account to post transaction values.

 

The other list I can think of that has records associated with accounts is the Items list, and there's a similar Items report at Reports | List.

BigRedConsulting
Community Champion

Another oddball report question ....

@Kurt_M

RE: Please know that when you print data from a Payroll Item list, it'll only show you what you've added to the Payroll Item list.

 

Do you realize that does not make any sense at all?

 

RE: Currently, the option to add a column or section to see what account the list item will post to when used in payroll is unavailable.

 

It absolutely is available. You can right-click the list and pick Customize columns and add the account columns. However, that's not a solution to the actual question, because it won't change the printout from the list itself, which is hard-coded.

 

RE: As a workaround, we recommend exporting the Payroll Item listing report and modifying the data outside the program. 

 

The OP's question is for QuickBooks Enterprise. Your answer is for QuickBooks Online, the weak and pathetic version of QuickBooks.  At the least, you could notice that before answering...

Teri
Level 9

Another oddball report question ....

Trial Balance is a standard report in any accounting system that lists all your account balances on one page.   

Deadwood Al
Level 6

Another oddball report question ....

to Teri ....

 

methinks you did not understand the question. The Trial Balance is not an answer to the question asked.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us