4. Square - Configuring Items

2 years ago
5 min read

Items are what you're selling. You assign prices to these items. You can assign tax rates to these items too. These items and their associated tax rates are associated with the Square Location you assign them.

When creating an Invoice, you will pick Items defined for your Location to add to your Invoice. If you defined the Item as being eligible for one or more taxes, you will have the option of including or removing the taxes from the Item on your invoice. You will also be able to specify a quantity of that Item you are selling.

You can choose to sell "week", "days", "month" or classify your items because they have different prices and sell "peak season days", "peak season week", etc. Even though you most often sell "weeks, you may find it easier to invoice for multiples of "days" especially if you allow longer stays pro-rated at the weekly rate.

An Example Selling "Days"

For example, you advertise your weekly rate as $1,400. But someone wants to reserve 9 days. You're OK with that. You have an Item that you called "2019 Daily Rate" with a price of $200 and assigned with a tax you called "Lodging Tax" defined as 10%. The sale would be displayed as selling item "2019 Daily Rate" at a quantity of 9 for a total of $1,800. The 10% "Lodging Tax" would be shown as $180 and the grand total on the invoice would be $1,980. Regardless if your next reservation if for your 1-week minimum or longer, this "2019 Daily Rate" item can be used for all invoicing.

Did you notice how I sneaked in "2019" into the Item name in my example. You're bound to change your Item prices over time so you probably should start including the year in your Item name. If you change your rates mid-year, then perhaps your rates could include identifiers like "2019-2020 Daily Rate" and then "2020-2021 Daily Rate" for the next year.

How Does Invoicing Schedule Influence the Items You Sell?

Generally on an invoice you are selling whole quantities of the item. However, if you're billing for the whole stay but expecting payment over two invoices, each invoice is for half the item. Unfortunately, you can't choose a quantity of 50%. In order for the quantity to be at least one, the Item has to represent half of what you are selling in a 2-invoice billing system. In a 3-invoice billing system, each item has to represent one-third of what you are selling.

Back to my 9-day example above, but using a 2-invoice system where I require 50% payment at time of booking and the remainder due 30-days before arrival. I can still sell "days". But my item name should be clear that this is 50% the entire rate. I could call my Item "50% - 2019 Daily Rate" and indicate a quantity of 9 on my invoice. The Item price is defined as $100 and has "Lodging Tax" associated with it. The Item total would be $100 x 9 = $900. Lodging Tax would be $90 for a total of $990. When the second invoice goes out 37 days before the guests' arrival, it will show the same items, tax and total due. (I send out the invoice 7 days before it's due, hence the second invoice goes out 37 days before guests' arrival.)

Note: Because in a multiple invoice process, the invoices can look identical, I choose to use the Invoice Subject line and include a key phrase like "Inv 1 of 2" and "Inv 2 of 2".

What about an Item for the Deposit?

Square does not allow the collection of "Security Deposits". I'm guessing that's because there is 120-day period from the date an invoice is paid until you can issue a refund on that invoice. If you collect your final guest payment more than 120 days before you plan to issue the refund, you will not be able to issue a refund against their paid invoice. You will need to use another means to reimburse them. Whatever fees you paid Square to accept their deposit is also non-reimbursable to you.

I do choose to collect a Security Deposit from my guests using Square invoicing although I know I will not always be allowed to reimburse the deposit back to their credit card. But mailing a refund check is another opportunity for me to send a personal thank you note to my guest after they check-out.

To collect this fee, I have an Item called "Security/Damage Deposit" that I've defined as non-taxable. Again, this Item is Square Location-specific. I require different deposits for each of my properties and the price associated with this Item is different between the Locations. I did not assign any taxes to this Item in either of my Locations.

Keep Your Item List Simple

If you're selling selling lots of Items because you have lots of prices, your Item list is going to be daunting! I can only imagine it's a bear to update your pricing on all your advertising venues should you use others besides Houfy. And even if you only advertise on Houfy, your potential guests are reading through a long list of dates and prices -- it's overwhelming!

Perhaps you want to list just one set of Items per year. For example:

  • "2019 Daily Rate (<7 days)"
  • "2019 Daily Rate (pro-rated week)"
  • "2019 Daily Rate (pro-rated monthly)"

where each item is assigned a price associated with a single day in that period. This means that the quantity sold for your pro-rated week is always a minimum of 7 days and the minimum quantity is 30 for the pro-rated month. Taxes may be associated with all of these items or perhaps in your state, the monthly rate is not taxed so the last item in my list would not have an associated tax.

If you're using a multi-invoice system, include the percentage of the item included on each invoice along with the daily price adjusted by that percentage. Ex. Your daily rate for a week reservation is $200/day. Therefore your 2-invoice Item would be "50% - 2019 Date Rate (pro-rated week)" for a price of $100.

These names are long, but they are clear! Both you and your guests understand what is being billed.

What About Seasonal Pricing?

You could double up the Items as I suggested above, where one set is for peak pricing and one is for "normal" pricing. Or you could make use of the Discount feature in your invoice. Like Items and Taxes, Discounts need to be pre-defined in order to include them in your invoice. Your pre-defined Discount can be a percentage of your sale. I believe that if you include your security/damage deposit on the invoice along with the rental fee, the Discount also applies to the deposit. So perhaps, in that situation, issue the deposit invoice separately.

By using discounts, you can advertise one rate all year and offer discounts during the periods you normally offer off-peak pricing. Using this method in your Houfy listing will always ensure that your highest price is your default price so you won't ever have that embarrassing conversation with a potential guest who thought they were getting a great deal on your property only because you didn't update your peak period rates!

Creating the Square Objects In This Order

  • Create Categories -- one for each property. This will allow you to create Category reports on your properties
  • Create Taxes -- define all the taxes for each Location. I like to show the percentage as part of the tax name since it will show up on the invoice. ex. Vermont Rooms Tax (9%). Choose "Add Tax to Item Price" will show the tax as a separate line item on the invoice instead of rolling the tax into the total item price.
  • Create Items -- Taxes and Categories and prices will be assigned to your Items
  • Create Discounts

The next post will be about Square Email Invoicing

© Susan and Houfy Inc, 03/29/2019. Loading Views.... Unauthorized use and/or duplication of this material without express and written permission from this page's author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Susan and Houfy Inc. with appropriate and specific direction to the original content. For more information, please visit the Houfy's copyright and trademark policy
List your
  • Vacation home
  • Apartment
  • Condo
  • Property
for free on Houfy
Listing your property can take as little as a few minutes to complete – get started today