Skip to content

x Want to ask a question or reply? Click here to join the group.
Options
  • State Verified Answer
  • +1 person also asked this people also asked this
  • Replies 1 reply
  • Subscribers 58 subscribers
  • Views 335 views
  • Users 0 members are here
Browse Forums
Sage Timeslips Anywhere Announcements
27
topics
5
replies
Sage Timeslips Anywhere General Discussion
83
topics
179
replies
Sage Timeslips Premium Announcements
94
topics
21
replies
Sage Timeslips Premium General Discussion
2k
topics
9k
replies

Profitability Report

Natalie Teixeira
Solved
Posted By

I'm looking to build out a report for the realization/utilization percentages for total hours vs billable hours and total billed for the year per user and how much we have collected for the year per user. 

I have my realization reports for the billable hours but I'm running into issues with finding the proper report filters for contributions vs collectibles. The report template under contributions/collectibles doesn't match when i spot check a user. 

For example on the collections report for Jan-Dec 2024 user A has X amount of billed fees which matches my invoices (write offs, discount bill arrangements etc..) however the Contributions and Collections for Jan - Dec 2024 user A has a different amount for what was collected and billed. I'm selecting the AR Transaction Dates as 1/1/24 - 12/31/24 for both reports. I'm at a loss. Other than manually opening each and every single invoice sent by all the users and matching the incoming payments, i cannot figure out why my report doesn't match. I will say the Collections report is more accurate as far as the billed fees for each user. Now i need to find a report with the correct payments for each user. I have one user showing they collected funds for 2024 but they didn't bill anything in 2024 due to working on contingency fee matters that were not billed until 2025. 

  • +1
    verified answer

    As a general statement, one should not expect Collections and Contributions to match in any given time period.

    In a perfect scenario, you might do the work (time/expense entries) in January, you would bill those entries in February (invoice) and get paid (Payments/Credits, etc.) on those billings in March.  And then there are the slow payers, the payments for multiple bills, etc.

    All of the data is calculated on what and when it was invoiced.  Using the perfect scenario January to December would have collections data pertaining to invoices (Contributions) billed in December of the prior year.  

    Using the reports consistently, you will get the rollover from year to year.  Expecting any given month to match exactly is a fairly unlikely scenario.

*Community Hub is the new name for Sage City