Experience the difference of "Elite".

Line Item Pivot and Line Item Detail Reports

Status: Requested 1 Vote
Apr 5, 2023 5:01 PM
Joined Sep, 2020 85 posts

In order to compare apples to apples, I'd love to see the Line Item Pivot and Line Item Detail Reports be based on Payment Date. Currently, you can only base these reports on "any stay during period," "arrival date," "departure date" and "booked date."

When I use this report for reconciliation of payments, sometimes I have a refund or an additional night that was purchased later than the booking date. Because I use the cash accounting method, I typically reconcile all transactions within a period -- the booking date, stay date, arrival date and departure date are wholly irrelevant. But the payment date is critical. 

Please consider adding the ability to run these reports based on Payment Date! Doesn't seem like it would be complex to do?



Ken T
Apr 13, 2023 5:14 PM
OR Team Member Joined Aug, 2019 1399 posts

The Line Item Detail report(s) are not really about payments - if you use them for that, it would filter out any for bookings that weren't paid.  Also, what if the booking was partially paid?  What would the line items be - the regular full amounts or some pro-rated thing based on the payments?

Instead, we'd recommend using the Deposits feature (even if you have to manually curate deposits coming in).  That will help do reconciliation better and more consistently over time.