Hi All,
I run small Guest House in the Highlands of Scotland. I have put together a simple Excel spreadsheet showing "Guests" "Occupancy" "Total Cost" "Deposit" and "Final Balance". This all tots up and shows total income for that day then total income for the month.
We almost never take deposits now, due to credit cards, so the "Dep." column is now redundant. However, we have this year taken on Booking.com and they take 15% commission for their bookings.
What I'd like to do is use the "Dep." column to show their commission in the form of figures. Then do a final tally of their commission for the month. The colour is just to let me quickly see Booking.com bookings.
I have attached February this year showing what I've done, which is very cumbersome. I've spent ages trying to figure out what I could do to make it more efficient, but got nowhere.
Any help would be most appreciated.
Thanks in advance,
John.
Bookmarks