client balances

SUGGESTED

I need a report to show each client balance, no transactions, just the balance, what I'm trying to do is see which clients have credit balances. So, I'd like a report to exclude clients with zero balances and only include those who owe us or those we owe a refund to.

Parents
  • 0

    thanks, Nancy. That report has too much info. All I want is clients and their balances. I figured out a way to do this with client history but it includes clients with zero balances. Would like to eliminate those. Any thoughts?

  • 0 in reply to keating

    Really depends what you mean by "too much info"...

    You 'could' create a custom report with just two columns: Client Name and Balance Due. But that is a custom report that has to be created. 

    You can also run the Aged A/R, and under Options elect to only see 1 Aging Period, which takes out some, but not all of the columns.

    Or you can print the Aged A/R to Excel (change the output) and take out the columns you don't want in Excel.

    Nancy Duhon, Esq.
    Duhon Technology Solutions, LLC
    Master Certified Consultant for Sage Timeslips
    Providing individual Consultations and Third Party Remote Desktop Support - including older/unsupported versions.
    404-325-9779
    [email protected]

Reply
  • 0 in reply to keating

    Really depends what you mean by "too much info"...

    You 'could' create a custom report with just two columns: Client Name and Balance Due. But that is a custom report that has to be created. 

    You can also run the Aged A/R, and under Options elect to only see 1 Aging Period, which takes out some, but not all of the columns.

    Or you can print the Aged A/R to Excel (change the output) and take out the columns you don't want in Excel.

    Nancy Duhon, Esq.
    Duhon Technology Solutions, LLC
    Master Certified Consultant for Sage Timeslips
    Providing individual Consultations and Third Party Remote Desktop Support - including older/unsupported versions.
    404-325-9779
    [email protected]

Children
No Data