Tracking payroll expenses by activity

Accountingnexleveltax · ‎June 17, 2022

Hey All,

I have a client that wants to track their best paying locations through the perspective of how much payroll paid out to employees at different locations. There's employees working at different sites so I'm running one Direct Deposit check for each respective site the employees work at. I wanted to use tags to differentiate between locations but I can't put a tag on a Direct Deposit expense transaction for review because then I would be double counting such transaction since the Direct Deposit was issued through QuickBooks Online (QBO) and the chart of accounts automatically reconciles those. Furthermore, if I try to match the "for review" expense transaction to the correct Direct Deposit in QBO, then I can't place a tag on the transaction to track it.

Anyone come across this or know a system that would help me track such activity. Much appreciated

Adrian_A · ‎June 20, 2022

Thanks for getting back to us, Accountingnexleveltax.

I appreciate you for sending feedback. Please know that any product suggestion helps us provide a more user-friendly interface.

As for running a location report, you can open the Profit and Loss report. Then, filter it to display columns to get this data. Here's how:

Go to Reports and open the Profit and Loss report.
Under the Report period drop-down list, select Custom.
Filter the dates by month by manually entering the reporting period.
Choose Locations under the Display columns by drop-down menu.
Click Run report.

To get the most out of your financial reports, you can refer to these articles:

Feel free to add a comment below if you have additional concerns or questions about opening reports or the location tracking option. I’ll be glad to answer them for you.

View solution in original post

Kevin_C · ‎June 17, 2022

It's nice to have you here today, @Accountingnexleveltax.

Adding tags to direct deposits in Payroll is a great functionality. However, this feature is unavailable.

You're correct that your transaction would be doubled if you assign classes through the For review window since it was automatically reconciled by QuickBooks.

Meanwhile, using QuickBooks Online Plus subscription, you can track important information in Locations and Classes.

Class tracking specifies a different class for each detail line of a transaction while Location tracking allows you to assign a location to an entire transaction. It's also used to group data from distinct firm locations, offices, regions, outlets, or departments.

Also, I'd suggest sending a feature request directly to our Product Development team. This helps us improve your experience with the program. Here's how:

Navigate to the Gear menu and then select Feedback.
Type in your feature request in the description box.
Once done, click on Next.

Additionally, you can look into these articles that will help you learn more about classes and location tracking in QuickBooks:

If you have any other questions using this feature, please feel free to visit us again. I’d be happy to further assist. Have a great day!

Accountingnexleveltax · ‎June 20, 2022

Hey Kevin_C,

Thank you for your speedy response and I've sent a feature request as instructed. So what I'm gathering is that I can use location tracking on a transaction and if I wanted to change the location of a direct deposit expense that's getting matched to internally ran payroll direct deposit then I can assign a location to the transaction when it goes through the "for review" section of banking? Furthermore, can I generate a report comparing the transactions tracked to different locations?

Adrian_A · ‎June 20, 2022

Thanks for getting back to us, Accountingnexleveltax.

I appreciate you for sending feedback. Please know that any product suggestion helps us provide a more user-friendly interface.

As for running a location report, you can open the Profit and Loss report. Then, filter it to display columns to get this data. Here's how:

Go to Reports and open the Profit and Loss report.
Under the Report period drop-down list, select Custom.
Filter the dates by month by manually entering the reporting period.
Choose Locations under the Display columns by drop-down menu.
Click Run report.

To get the most out of your financial reports, you can refer to these articles:

Feel free to add a comment below if you have additional concerns or questions about opening reports or the location tracking option. I’ll be glad to answer them for you.

Topics

Training

Community

Resources

Tracking payroll expenses by activity