Skip to main content
T
Trix3
August 29, 2023
Solved

Report on employee advances outstanding

  • August 29, 2023
  • 3 replies
  • 0 views

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. 

Best answer by JamesM4

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.

 

3 replies

J
JamesM4Answer
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.

 

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

    T
    Trix3Author
    October 26, 2023

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

    L
    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!

    Terms & ConditionsAccessibility statement