Quickbooks - What features should an innkeeper be using?

Bed & Breakfast / Short Term Rental Host Forum

Help Support Bed & Breakfast / Short Term Rental Host Forum:

This site may earn a commission from merchant affiliate links, including eBay, Amazon, and others.

GoodScout

Well-known member
Joined
Sep 25, 2012
Messages
1,330
Reaction score
550
We use Quickbooks as our accounting software, but I suspect we could be using more of its features.
Right now all we do is:
  • Download our bank statement
  • Make sure deposits and expenses are coded to the right category
  • Print out P&Ls every month
We pay our bills either by handwriting checks and entering them manually, or using our banks Online Banking Bill Pay Service and waiting for the payment to be downloaded.
I'm sure there's more we could be doing to use this tool to help manage our business -- and most importantly manage our cash flow and improve our profitability. Does anyone use any of these other features, and if so, how?
  • Accounts Payable (Entering Bills/Bills To Pay/Checks To Print)
  • Accounts Receivable
  • Invoices
  • Inventory
  • Vendor Management
  • Mileage
  • Creating Estimates
  • Creating Invoices
  • Budgeting
It's worth mentioning I used Intuit's Payroll service tied into to Quickbooks to pay my staff, and I'm a big fan.
 
My hubby says he uses it mostly to record income and expenses and for tax purposes.
 
PhineasSwann said:
Does anyone use any of these other features, and if so, how?
  • Accounts Payable (Entering Bills/Bills To Pay/Checks To Print)
Yes, although we are still writing our checks out by hand rather than printing them (thinking about moving to printing checks), but we do keep track of some (but not all) of our accounts payable. For example, our Laundry Service comes a couple times a week, invoicing us for each delivery, and I record each invoice as a bill in QB, and then every two or three weeks pay the accumulated bills with one check..
  • Accounts Receivable
  • Invoices
Yes to both, our guests pay a deposit of 25% months and months in advance, and we invoice them for the balance due upon arrival, so we definitely do keep track of A/R.
  • Inventory
Not really applicable in our business....
  • Vendor Management
I am not sure what this means other than being able to look up what we have paid to different vendors at different times in the past, which can be quite useful.
  • Mileage
No, we don't use this
  • Creating Estimates
We have used this once or twice for a special project, but otherwise don't really use it. Thinking about it now, it might be good for our wedding business, though.....
  • Creating Invoices
Yes, see above regarding A/R and Invoices.
  • Budgeting
No, our business is so seasonal, that month-to-month budgeting would be very hard; rather we try to project everything out to an annual basis.
--
The usefulness of some of the features (A/P, A/R, Inventory) probably depends on whether you are using accrual-basis accounting rather than cash-basis.
For payroll, we roll our own. Since we only have employees for 4 to 6 months out of the year, I just can't get my head around continuing to pay a subscription to a payroll service for the the other 6 to 8 months of the year....
You didn't mention Customer Management -- our QB database goes back about 15 years, longer than any other records we have really, so the Customer List is often where we look for information about our returning guests....
We don't really look at monthly P&L statements so much as our annual projections, but we do find the current year to previous year YTD comparison report useful to see how revenues and expenses are running. Of course, the end-of-fiscal-year P&L is the basis for our tax return.... Our fiscal year ends about a month-and-a-half after our guest season ends, so we look carefully at the P&L during that last month to see how close we are to making a profit and whether there are any additional expenditures we want to make before the year's end in order to reduce the tax hit.
 
PhineasSwann said:
Does anyone use any of these other features, and if so, how?
  • Accounts Payable (Entering Bills/Bills To Pay/Checks To Print)
Yes, although we are still writing our checks out by hand rather than printing them (thinking about moving to printing checks), but we do keep track of some (but not all) of our accounts payable. For example, our Laundry Service comes a couple times a week, invoicing us for each delivery, and I record each invoice as a bill in QB, and then every two or three weeks pay the accumulated bills with one check..
  • Accounts Receivable
  • Invoices
Yes to both, our guests pay a deposit of 25% months and months in advance, and we invoice them for the balance due upon arrival, so we definitely do keep track of A/R.
  • Inventory
Not really applicable in our business....
  • Vendor Management
I am not sure what this means other than being able to look up what we have paid to different vendors at different times in the past, which can be quite useful.
  • Mileage
No, we don't use this
  • Creating Estimates
We have used this once or twice for a special project, but otherwise don't really use it. Thinking about it now, it might be good for our wedding business, though.....
  • Creating Invoices
Yes, see above regarding A/R and Invoices.
  • Budgeting
No, our business is so seasonal, that month-to-month budgeting would be very hard; rather we try to project everything out to an annual basis.
--
The usefulness of some of the features (A/P, A/R, Inventory) probably depends on whether you are using accrual-basis accounting rather than cash-basis.
For payroll, we roll our own. Since we only have employees for 4 to 6 months out of the year, I just can't get my head around continuing to pay a subscription to a payroll service for the the other 6 to 8 months of the year....
You didn't mention Customer Management -- our QB database goes back about 15 years, longer than any other records we have really, so the Customer List is often where we look for information about our returning guests....
We don't really look at monthly P&L statements so much as our annual projections, but we do find the current year to previous year YTD comparison report useful to see how revenues and expenses are running. Of course, the end-of-fiscal-year P&L is the basis for our tax return.... Our fiscal year ends about a month-and-a-half after our guest season ends, so we look carefully at the P&L during that last month to see how close we are to making a profit and whether there are any additional expenditures we want to make before the year's end in order to reduce the tax hit..
Harborfields said:
...we are still writing our checks out by hand...
I'm not sure which is more archaic... doing it by hand or writing cheques altogether :)
 
PhineasSwann said:
Does anyone use any of these other features, and if so, how?
  • Accounts Payable (Entering Bills/Bills To Pay/Checks To Print)
Yes, although we are still writing our checks out by hand rather than printing them (thinking about moving to printing checks), but we do keep track of some (but not all) of our accounts payable. For example, our Laundry Service comes a couple times a week, invoicing us for each delivery, and I record each invoice as a bill in QB, and then every two or three weeks pay the accumulated bills with one check..
  • Accounts Receivable
  • Invoices
Yes to both, our guests pay a deposit of 25% months and months in advance, and we invoice them for the balance due upon arrival, so we definitely do keep track of A/R.
  • Inventory
Not really applicable in our business....
  • Vendor Management
I am not sure what this means other than being able to look up what we have paid to different vendors at different times in the past, which can be quite useful.
  • Mileage
No, we don't use this
  • Creating Estimates
We have used this once or twice for a special project, but otherwise don't really use it. Thinking about it now, it might be good for our wedding business, though.....
  • Creating Invoices
Yes, see above regarding A/R and Invoices.
  • Budgeting
No, our business is so seasonal, that month-to-month budgeting would be very hard; rather we try to project everything out to an annual basis.
--
The usefulness of some of the features (A/P, A/R, Inventory) probably depends on whether you are using accrual-basis accounting rather than cash-basis.
For payroll, we roll our own. Since we only have employees for 4 to 6 months out of the year, I just can't get my head around continuing to pay a subscription to a payroll service for the the other 6 to 8 months of the year....
You didn't mention Customer Management -- our QB database goes back about 15 years, longer than any other records we have really, so the Customer List is often where we look for information about our returning guests....
We don't really look at monthly P&L statements so much as our annual projections, but we do find the current year to previous year YTD comparison report useful to see how revenues and expenses are running. Of course, the end-of-fiscal-year P&L is the basis for our tax return.... Our fiscal year ends about a month-and-a-half after our guest season ends, so we look carefully at the P&L during that last month to see how close we are to making a profit and whether there are any additional expenditures we want to make before the year's end in order to reduce the tax hit..
Harborfields said:
...we are still writing our checks out by hand...
I'm not sure which is more archaic... doing it by hand or writing cheques altogether :)
.
Hey, we still accept cash for payment!
wink_smile.gif

 
PhineasSwann said:
Does anyone use any of these other features, and if so, how?
  • Accounts Payable (Entering Bills/Bills To Pay/Checks To Print)
Yes, although we are still writing our checks out by hand rather than printing them (thinking about moving to printing checks), but we do keep track of some (but not all) of our accounts payable. For example, our Laundry Service comes a couple times a week, invoicing us for each delivery, and I record each invoice as a bill in QB, and then every two or three weeks pay the accumulated bills with one check..
  • Accounts Receivable
  • Invoices
Yes to both, our guests pay a deposit of 25% months and months in advance, and we invoice them for the balance due upon arrival, so we definitely do keep track of A/R.
  • Inventory
Not really applicable in our business....
  • Vendor Management
I am not sure what this means other than being able to look up what we have paid to different vendors at different times in the past, which can be quite useful.
  • Mileage
No, we don't use this
  • Creating Estimates
We have used this once or twice for a special project, but otherwise don't really use it. Thinking about it now, it might be good for our wedding business, though.....
  • Creating Invoices
Yes, see above regarding A/R and Invoices.
  • Budgeting
No, our business is so seasonal, that month-to-month budgeting would be very hard; rather we try to project everything out to an annual basis.
--
The usefulness of some of the features (A/P, A/R, Inventory) probably depends on whether you are using accrual-basis accounting rather than cash-basis.
For payroll, we roll our own. Since we only have employees for 4 to 6 months out of the year, I just can't get my head around continuing to pay a subscription to a payroll service for the the other 6 to 8 months of the year....
You didn't mention Customer Management -- our QB database goes back about 15 years, longer than any other records we have really, so the Customer List is often where we look for information about our returning guests....
We don't really look at monthly P&L statements so much as our annual projections, but we do find the current year to previous year YTD comparison report useful to see how revenues and expenses are running. Of course, the end-of-fiscal-year P&L is the basis for our tax return.... Our fiscal year ends about a month-and-a-half after our guest season ends, so we look carefully at the P&L during that last month to see how close we are to making a profit and whether there are any additional expenditures we want to make before the year's end in order to reduce the tax hit..
Harborfields said:
...we are still writing our checks out by hand...
I'm not sure which is more archaic... doing it by hand or writing cheques altogether :)
.
Charlie said:
Harborfields said:
...we are still writing our checks out by hand...
I'm not sure which is more archaic... doing it by hand or writing cheques altogether :)
Our post office loves us.
 
PhineasSwann said:
Does anyone use any of these other features, and if so, how?
  • Accounts Payable (Entering Bills/Bills To Pay/Checks To Print)
Yes, although we are still writing our checks out by hand rather than printing them (thinking about moving to printing checks), but we do keep track of some (but not all) of our accounts payable. For example, our Laundry Service comes a couple times a week, invoicing us for each delivery, and I record each invoice as a bill in QB, and then every two or three weeks pay the accumulated bills with one check..
  • Accounts Receivable
  • Invoices
Yes to both, our guests pay a deposit of 25% months and months in advance, and we invoice them for the balance due upon arrival, so we definitely do keep track of A/R.
  • Inventory
Not really applicable in our business....
  • Vendor Management
I am not sure what this means other than being able to look up what we have paid to different vendors at different times in the past, which can be quite useful.
  • Mileage
No, we don't use this
  • Creating Estimates
We have used this once or twice for a special project, but otherwise don't really use it. Thinking about it now, it might be good for our wedding business, though.....
  • Creating Invoices
Yes, see above regarding A/R and Invoices.
  • Budgeting
No, our business is so seasonal, that month-to-month budgeting would be very hard; rather we try to project everything out to an annual basis.
--
The usefulness of some of the features (A/P, A/R, Inventory) probably depends on whether you are using accrual-basis accounting rather than cash-basis.
For payroll, we roll our own. Since we only have employees for 4 to 6 months out of the year, I just can't get my head around continuing to pay a subscription to a payroll service for the the other 6 to 8 months of the year....
You didn't mention Customer Management -- our QB database goes back about 15 years, longer than any other records we have really, so the Customer List is often where we look for information about our returning guests....
We don't really look at monthly P&L statements so much as our annual projections, but we do find the current year to previous year YTD comparison report useful to see how revenues and expenses are running. Of course, the end-of-fiscal-year P&L is the basis for our tax return.... Our fiscal year ends about a month-and-a-half after our guest season ends, so we look carefully at the P&L during that last month to see how close we are to making a profit and whether there are any additional expenditures we want to make before the year's end in order to reduce the tax hit..
Harborfields said:
...we are still writing our checks out by hand...
I'm not sure which is more archaic... doing it by hand or writing cheques altogether :)
.
Hey, we still accept cash for payment!
wink_smile.gif

.
I do too. But you won't believe how I deposit it.... debit card.
 
I havn't written a cheque in 3 years - everyone is paid online - most in the UK won't take cheques anyway, take 6 days to clear - online is less than an hour, even pay the handyman that way.
Advantage is also is you can see an exact trail of who has been paid what and how much with your online banking - don't have to look up a cheque number and what it was for. Also the inland revenue like it for the same reasons.
 
Back
Top