@Jenny-Oest not sure why the image would not upload 😞

But I have a long list of sources (most of which I could care less about - but I don’t know how to remove) I am trying to find VRBO and HomeAway - they are far down the list and I cannot access them from the source list filter in the reports.

@rajiv-de-costa-0 Make sure your dates are correct and your filters other than property are clear. For example - “Source”

Yep. We love it. Nothing like sitting down at the end of the day and seeing you have 11 checkouts to clean tomorrow…

I think that’s a great feature request to have a filter option for GROUP as well as PRoperty. 🙂

I’ve tried using both the Reservation and Financial Summary reports. I use Open Office to sort the data by Status and Check-in Date so the Cancellations appear at the top of the Data.

We just hustled through the review and processing of 121 Cancellations between February 1st and April 6th to get our owners paid this month.

The data integrity of the reporting is not quite 100%. I found one Reservation reported as cancelled on the Reservation report that was not.

Then again, I found at least five cancellations that were never entered into our Accounting Software as Reservations before they cancelled.

Hey Bob, The data export format is supported by excel. Just open excel first and then open the export file.

Hey @Marty-Rowland-0 ,

The channel fee reporting we have available is for Booking.com, Airbnb & MyVR’s commission fee. Unfortunately, our reports don’t include the Vrbo fees - which are delivered to you in an annual report.

Of those fees we are able to disclose, users have the ability to filter and download any of the various data / accounting exports at their discretion.

The Expense Transaction report will break out the channel fees per reservation. Similarly, you’ll find the MyVR fees in the Reservation Expenses report.

Head to Setup > API & Data Access > Manual Exports > Accounting to see all the reports available.

Hey,

I’m quite new to MyVR, but we have been working on an integration between Airbnb, Homeaway and Xero. We’ve just been accepted as a Xero partner and will be contributing to their integration ecosystem. We will possibly look to integration with MyVR, but currently we only support Homeaway and Airbnb.

How it works:

The user uploads the Airbnb/Homeaway CSV file to the web app The properties are mapped from the listing name / Xero ledger per property The transactions are created as either invoices / bills for commission or cleaning Payments are created for the manager / property owners as an ABA file to be uploaded to bank

My background is Accounting/ Software dev and Property management. We use this system weekly for 70+ properties with a substantial revenue. It has reduced the processing time of our land agents trust account from days to hours. I’ve also taught my assistant (with no accounting knowledge) to administer the accounts with my supervision once completed.

I’m unsure if this is the place for cross promotion, but if you are interested, drop me an email / message and we can chat further.

Thanks,
Darren

Hi Paige,

The Setup > API & Data Access > Manual Exports > Accounting section has several exports that would provide all of that data. This help center article explains more, but I recommend downloading at least the following based on what you asked.

Rental Income > Reservation Financial Summary
Cleaning Fee > Line Items
Tax Detail > Line Items

@sarah-peabody this is a great use case for our API & Data Access > Manual Export feature. You can download a number of reports, filtered by stay dates & sources. I would recommend starting with the Reservations report to understand occupancy.

Hi Heather,

MyVR has a new report available via Manual Export that can help: the Reservation Financial Summary Report.

You can export this from MyVR via Setup > API & Data Access > Manual Export > Financial Summary

0_1553903151897_8eefcecc-d54a-458d-9f1e-84e1743a1a8e-image.png

0_1553903197427_078555b9-c78a-47c4-9168-2d111bf65483-image.png

This new export gives you quick access to all your reservation financial information so you can easily analyze performance, do your accounting, and provide reports to your owners. To view all the financial data for your reservations in one report, filter and download your data from the Financial Summary tool in the Reservation section under Setup->API & Data Access->Manual Export in the left hand navigation menu. This report contains your reservation information - including property, source, and a full financial breakdown - on one line per reservation. You can open the CSV file in any spreadsheet program, including Excel and Google Sheets.

When it’s exported, here’s a snippet of some of the data you’ll see in a single line (note, there are additional fields when the actual report is exported, my screen was not large enough to show you each of the column headers):

0_1553903266600_054b66be-aada-45b3-97b4-e4aa6d85c4a9-image.png

You can read the full product update in MyVR from your name drop down in the top right corner > Product Updates.

0_1553903359715_0c24f70f-ddb8-4b7d-89a7-23d7da8d7a31-image.png

I hope this helps!

-Anne Kohn

Hi Julie,

I am sending you a direct message to follow-up. In short, although this is currently unavailable through MyVR’s Reporting feature there is a manual workaround available for accounts with API access.

-Anne

Hi Yadira,

I apologize for the inconvenience, but at this time MyVR does not offer phone support. We do have an email-based Support team and more help here: Help Center.

I would also recommend copy/pasting those report steps into an app like Google Translate or similar for a rough translation.

Best,

Anne

Gureat idea, @Basil-Kezios and happy to hear about the newest export feature, @Anne-Kohn !

@jared-radtkey - If you’re looking for a report of upcoming reservations (without cancellations), you can filter your reservations list as shown below. Select “upcoming” reservations, and then when you choose Reservation Status, uncheck all of the cancelled reservation choices.

0_1534555815518_Screen Shot 2018-08-17 at 9.25.28 PM.png

But if you need the list in CVS format, you will need to export all, and then sort and delete the cancelled reservations from the list.

– Jenny

Hi @Basil-Kezios and @Carole,

Looking at the Payments.csv export, it appears that one off charges are exported in the same way as all other payments. Such payments include the guest name, the reservation ID, etc.

Are you simply looking for a way to identify payments in the Payments.csv export as one-off payments? Maybe a new column called “One-Off Charge” that would either be “True” or “False”?

If that’s what you’re looking for, you can submit a feature request and our product team will consider adding it.

As @Darrell-Looney112 mentioned, adding items to quotes is really the best way of going about things for reporting purposes even if it’s a bit more cumbersome than adding a one off charge. We do have a “Modify Terms” button that allows you to quickly make modifications to the existing terms and record renter agreement for the new, updated terms.

0_1521667516085_Screen Shot 2018-03-21 at 2.23.15 PM.png

After selecting that you want to modify the terms, you can choose to build new terms from an existing quote. The little book icon indicates which quote is your current terms.

0_1521667595082_Screen Shot 2018-03-21 at 2.23.48 PM.png

You do not need to send these new terms to the renter for them to be applied.

0_1521667658053_Screen Shot 2018-03-21 at 2.24.29 PM.png

After you save the new terms, you will be asked if you want to agree to them on behalf of the renter.

0_1521667684789_Screen Shot 2018-03-21 at 2.24.39 PM.png

I understand this this takes more steps than a one off charge, but it will make all of your reports work much more smoothly.

Best,
Danny

Hi @Marriott-Murdock,

When you mention realized / transferred revenue, are you referring to revenue that has been transferred to your bank account that hasn’t been tracked by MyVR as a reservation payment? If so, MyVR has no access to this information and cannot generate reports based on it. You would need to get data about those transfers from your bank and likely use a spreadsheet or other software to combine that bank data with data you’ve exported from MyVR.

Best,
Danny

Thanks Mike!

Not sure how I missed that while searching 😕 but thank you so much 🙂

Cheers,
Kirk

What I am looking for is the Revenue which was ‘earned’ by a particular property in a month (sum total of the amount collected by the bookings for that month)

The Revenue by Stay Dates report should get you that number. It is the total non-refundable value of all reservations within a date range (e.g. a month). You can view this total per-property in the report.

One caveat, however, is that the Revenue by Stay Dates report will round the monthly revenue numbers to the nearest dollar. Also, this report will include all non-refundable money in a reservation even if it hasn’t been collected yet. That means scheduled and overdue payments will be counted in this report.

Another thing to note is that if a reservation has stay dates across months (e.g. a June 29 to July 9), the Revenue by Stay Dates report will allocate money to each month by the percent of the stay in each month. For example

Reservation Dates: June 29 to July 9 Reservation Total Nonrefundable Value: $100 Nights in June: 2 Nights in July: 8 Percent of Nights in June: 20% Percent of Nights in July: 80% Revenue by Stay Dates in June: $20 Revenue by Stay Dates in July: $80

Cheers,
Danny

Hi Vivin,

If I understand you correctly, you are looking to create a report that will have the reservation information for all reservations with a check in date between an earliest and latest date. While you can’t select a latest check in date, you can select an earliest check in date and a latest check out date before exporting reservation data.

0_1481843880549_Screen Shot 2016-12-15 at 3.11.54 PM.png

This should narrow down the export to roughly the range you are looking for. Once you have the CSV file, you can sort the rows by the check in date and remove any rows at the end that have check in dates past the latest check in date that you desire in the report. This should leave you with only the reservations that have a check in date between an earliest and latest date.

If you simply desire the total number of reservations with a check in date between an earliest and a latest check in date, you can still follow the steps I described above to create the spreadsheet. Once you’ve done this, you can look at the row number of the last filled-in row of the sheet. Subtract one from that number (for the sheet’s header), and you should get the total number of reservations with a check in date between an earliest date and latest date.

Finally, you can also purchase a reservation data import service (we’re happy to do a custom export instead of an import) through us to generate the report you desire.

Cheers,
Danny