how to record daily sales for hotel business in quickbooks

Hi There 

You can enter a single sales receipt to report the total daily sales in QuickBooks if you use a separate Point of Sale system. Or if you simply don't invoice customers. This saves you time, while still keeping your income reports accurate.

Here's a step-by-step guide to help you get you started.

Step 1: Create a customer for daily sales

You'll only use this customer account on your "end of day" sales receipt.

1. From the left menu, select Sales, then Customers.
2. Select New customer.
3. Enter "Daily Sales."
4. Select Save.

Step 2: Set up accounts for daily sales

Make sure your Daily Sales accounts are set upright. Doing so can help you a lot with accurate income reporting.

To set up daily sales accounts:

1. Select the Gear icon on the Toolbar.
2. Under Your Company, choose Chart of Accounts.
3. Select New at the top right.
4. Set up these accounts:

Step 3: Set up items for daily sales

Set up a "Daily Sales" category to keep your items organised:

1. Select the Gear icon on the Toolbar.
2. Under Lists, choose All Lists.
3. Select Product Categories.
4. Select New Category at the top right.
5. Name the new category "Daily Sales."
6. Select Save.

After setting up the Category, next are the items:

1. Select the Gear icon on the Toolbar.
2. Under Lists, choose Products and Services.
3. Select New at the top right.
4. Set up these items. Note: Make sure to select Daily Sales as Category for each item.

Step 4: Create a daily sales template

You'll use this template every time you need to record total daily sales.

1. Select the Gear icon on the Toolbar.
2. Under List, choose Recurring Transactions.
3. Select New at the top right.
4. From the Transaction Type drop-down, choose Sales Receipt.
5. Name your template "Daily Sales" and make sure the Type is Unscheduled.
6. Select Daily Sales as the Customer.
7. Select these items:
   1. Daily Sales: Daily Sales Income
   2. Daily Sales: Cash
   3. Daily Sales: Cheque
   4. Daily Sales: Visa/Mastercard
   5. Daily Sales: American Express
   6. Daily Sales: Overage/Underage
   7. Daily Sales: Discover
8. Select Save.

Remember

• Mark the "Daily Sales Income" item taxable if you collect sales tax.
• Make sure your sales tax rate is correct.

Step 5: Record your total daily sales

Done setting up your sales receipt template? You're now ready to record your "end of day" sales.

1. Select the Gear icon on the Toolbar.
2. Under Lists, choose Recurring Transactions.
3. Find your template, then select Use from the Action drop-down.
4. To better illustrate how your sales receipt should look like, check out a sample breakdown of total daily sales below.

@Roger001 

As another option, consider having a PMS to manage your operation better and integrate it with your QBO.

https:// mbsy.co/MH9dN

If you let the PMS deal with generating the Invoices, you can then use The Percentage Company APP to transfer the daily Revenues/Taxes and Payments to QBO.  https://www.thepercentageapp.co/

Hello,

I can't see the sample. On the deposit to account which account do I use, it won't let me leave it blank. Thank you!

How do you post your customers advanced deposits that are not technically income until their reservation date

Hi there, Darla33.

Thanks for bringing your question forward here in the Community. I'd be glad to provide some info regarding customer deposits in your QuickBooks account.

Just to make sure I'm on the same page, are you currently using QuickBooks Online or Desktop?

In this scenario you may consider setting up a retainer item for deposits made in advance. This is useful for businesses who receive retainers or deposits from customers before performing any services. Here's how to get this set up in QuickBooks Online:

1. Create a Liability account.

2. Create a retainer item.

3. Add a trust liability bank account if necessary.

4. Make a sales receipt or invoice for deposits or retainers.

The following article offers an in-depth explanation of the full process: Record a retainer or deposit

With this info you'll be able to record advanced deposits from your customers before their reservation date. I'll be here if you have any other questions. Take care!