Partner Leaving the Firm? Payments This Year on Fees Billed Last Year

QUESTION: I want to see payments or write-offs posted this year for statements run last year.

PROBLEM: Ledger Query for "Statement Date" or "Date" returns payment or write-off date.

SOLUTION: We cannot query by the original statement date to get payments, but we can select a range of statement numbers.

STEPS: 1) Run this query in Ledger: Statement and Date in December 2018

2) Note the highest statement number. (In this example, it is 11364.)

3) Run this query in Ledger: Cash Receipt and Date in 2019 and Statement Number < 11365

4) Run this query in Revenue Analysis Reports if you want to see fees received by Professional:

Statement Number < 11365 and Initials = 'CMW'

This will return cash receipts dated in 2019 on statements run in before 2019.

The same query can be modified to include write-offs.

5) Run this query in Ledger: (Cash Receipt or Write-off) and Date in 2019 and Statement Number < 11365