Airbnb Bookkeeper and Accountant

We are a fast-growing Airbnb Company based in the USA renting our apartments and hotel rooms.

We're currently looking for an Airbnb bookkeeper and accountant to help us track and optimize the financial performance of our 50+ unit portfolio. We need everyday reconciliations, and weekly/monthly performance reports. You will be telling us where our costs our too high, where we can optimize, revenue trends, and more analysis. You will also be helping us to build an automated accounting sheet where we can track all the data for our short term rental portfolio such as occupancy, revenues, RevPAR, etc.

Requirements:
- An accounting degree is a must
- Must have previous AIRBNB experience
- Must have previous accounting experience specifically for short term rentals and airbnb hosts
- Previous knowledge working with Guesty, Airbnb, VRBO and Quickbooks.
- You have lots of experience creating pivot tables, Profit and Loss statements, excel automation and macros, tableau graphs, and know how to code to connect to an API and pull data automatically

- You can work in CST daytime
- You are native level speaker of English with no accent and stuttering
- You have a hard work ethic and respect the job first. no tardiness or absence.
- Your exceptional communication skills allow you to show up confidently on video and express yourself effectively through written & verbal communication.

***Please send your CV and references**

**Please complete this assessment and follow instructions within to be top of list for consideration:
- Create a beautiful excel analysis sheet [PnL and ROI] on an example Airbnb property of your choice if you were to buy the property and run it as an Airbnb (you can pick one from anywhere on Airbnb).
Break down what your conceptualization is of the costs and revenue of an Airbnb (you will need to do research on revenues in the area, and research on rents).
Provide a nice visualization of the performance and PnL report.
Then create a video walkthrough of your completed excel sheet explaining how you came to each assumption / analysis.