Consolidate Lynnbrook Group Fee columns in Line Item Pivot report

Status: Closed 0 Votes
Austin G
Mar 7, 2024 3:48 PM
Joined Feb, 2023 14 posts

Hello OwnerRez

I'm seeing these new columns pop up for Lynbrook Group Fee in my Line Item Pivot Report (https://app.ownerrez.com/reports/lineitempivot)

You can see there are 11 Lynbrook Group Fee's I'm showing in this screenshot, but the behavior seems to be that it adds a new column each time there's a new booking through VRBO/website when paid through Lynbrook.

This presents a data challenge when I export this into my revenue/tax reporting spreadsheet because I constantly need to update the columns to my sheet and it complicates everything. Is there a way I can consolidate all these columns into one, so that it's not all unique per transaction?

Thanks!

Alece
Mar 19, 2024 2:09 PM
Joined Jan, 2020 183 posts

Austin, does checking this box to Merge Similar Charges remedy that for you? 

 

Austin G
Mar 19, 2024 2:44 PM
Joined Feb, 2023 14 posts

Ohh...that's awesome! Yes I think that takes care of it. It consolidates all these unique charges into one column.

Thanks for the suggestion Alece!

 

-Austin