There are lots of “packages” you can purchase to keep track of your revenues. It is something that all innkeepers have to do and it’s not one of the more fun parts of the job. It is important because you have to pay tax on these revenues AND it is vital to track how your business is performing.
Not many people like this task, but I have a method that is super EASY and FREE. I keep an excel spreadsheet which I’m happy to send to anyone who fills out the form at the end of this post. If you don’t have excel OR don’t know how to use it have no fear. I have pre-formatted the spreadsheet and highlighted the rows you need to complete for each guest.
I track 4 things for each guest: name, date of stay, rate and number of nights. I have the tax rate built into the spreadsheet and a formula that calculates the total room nights, total tax and the grand total for each guest. Every time I get a reservation I take a minute to open up my spreadsheet and add each guest.
Then at the end of the month I reconcile my total to my credit card statement. This is a pain, but really important because mistakes happen and this is when you catch them. You want to pay tax on the right amount.
I have a separate tab in the spreadsheet for each month to make it easy for taxes. At the end of the month I download my bank transactions directly into this spreadsheet and reconcile the difference between my room revues and the deposits. The difference is normally due to a 1-4 day lag between when cards are run and deposits are made.
If you would like a copy of my spreadsheet to try out please complete the form below.