Report on employee advances outstanding

Trix3 · ‎August 29, 2023

All payroll information is accurately recorded. If i go to an individual employee I can see his advance balance. Yet I cannot find a report that accurately shows me how my balance in the Chart of accounts 'employee advances' comes together. Shouldn't I be able to run a report that tells me of the say $1,000 $300 is owed by employee x and 700 is owed by employee y? That obviously is information I might be looking for, and I cannot figure out how to get it.

I would appreciate help with that.

JamesM4 · ‎August 29, 2023

Hi Trix3,

Welcome to the Community. I'm glad to learn you're using QuickBooks to help streamline your business. I'll be happy to steer you on the right path with achieving your QuickBooks goals.

QuickBooks is an easy-to-use program that simplifies the way you handle your accounting. The report you've described isn't available in QuickBooks. I can see the benefit of having access to this report and I encourage you to send feedback about this to our engineers. To do this, click on the Gear icon > Feedback. I recommend looking into third-party apps on our app store www.apps.com.

Let me know if this info helps. I'll be one message away in case you have additional questions.

View solution in original post

JamesM4 · ‎August 29, 2023

Hi Trix3,

Welcome to the Community. I'm glad to learn you're using QuickBooks to help streamline your business. I'll be happy to steer you on the right path with achieving your QuickBooks goals.

QuickBooks is an easy-to-use program that simplifies the way you handle your accounting. The report you've described isn't available in QuickBooks. I can see the benefit of having access to this report and I encourage you to send feedback about this to our engineers. To do this, click on the Gear icon > Feedback. I recommend looking into third-party apps on our app store www.apps.com.

Let me know if this info helps. I'll be one message away in case you have additional questions.

Locklearm · ‎October 26, 2023

This topic should not be posted as resolved. I am here for the same reason. There appears to be no report that shows this and there needs to be.

Trix3 · ‎October 26, 2023

no kidding. I just gave up. Got nowhere....

Locklearm · ‎October 27, 2023

Trix! Okay, you can run a report on the advance account from the COA, Select the advance account and on the right side, choose Run Report.

Customize

Next, I get rid of all the columns I do not use, such as Adj, Split, account

Then I also select to show negatives in red (red)

Then I group by employee (just make sure your employees are not listed as customers or vendors (tiny nightmares)

This should show you the activity for each employee!

Also, put the balance owed in the payroll for the annual amount....but make sure to update it at the end of the year or make everyone payoff advances by YE!

Clear as mud? I will be happy to help!

Topics

Training

Community

Resources

Report on employee advances outstanding