Price Rules in QuickBooks Online are here!. Price rules/Price levels are one of the few features that I’ve said I need in order to put all of my clients on QuickBooks Online and then never look back at QuickBooks desktop. (Unless it’s to convert to QuickBooks Online).
For the record, the other features are:
- Integrated direct labor costing. This one… I have nothing to say about it right now. It’s still the one thing that keeps my contractor clients from making the jump. Let’s just not talk about it and move on to the good stuff.
- Progress Invoicing. I’m actually doing beta testing for this. SQUEEEEE.
- Receive Partial Purchase Order. We now have that! Check out that article here.
This post, my friends, is about Price Rules in QuickBooks Online. Known in Desktop as Price Levels, so let’s dig into how we can set them up and use them.
First we want to click on the Gear Icon in the top right corner, then choose Account and Settings.
Once we have the preference turned on, we can (yay!) start using Price Rules in QuickBooks Online.
First, we’ll create a general price rule. This one is a just a blanket 10% discount that can be used for any customer on any product or service:
We’ll use it on a sales transaction:
We can also create a new rule when we edit an item from our Products and Services list. In this example, I’m setting up a 15% discount on installation services, that will only run through the weekend.
Here’s how it looks when used on a sales transaction:
One last example of price rules in QuickBooks Online that I want to show is when you have pricing per item, per customer.
We’ll go Gear Icon > Products and Services, then click that drop down on the More button to choose Price Rules. Once you see the list of your price rules in QuickBooks Online, click the green New price rule button.
Here I am setting this up, and instead of choosing to set the price or rate by percentage or fixed rate across all of the items, I chose Select Individually and then adjust each item, per the contract. Because I chose to have this price rule only apply to one customer, it won’t be available when I create sales transactions for other customers.
The last thing I want to show is that you can make any of the prices rules in QuickBooks Online inactive, so that they cannot be used when creating Sales Transactions.
If you go back to the same place we just were: our price rules list, we can click on the Edit button in the action column and make any of them inactive. PRO TIP: if you’re logged into your account, here’s a shortcut to the list of price rules in QuickBooks Online: https://qbo.intuit.com/app/pricerules.
So there you have it! A nice overview of how price rules in QuickBooks Online are created and used.
Looking for an easier way to manage accounts receivables? Then you need to check out InvoiceSherpa.com. This app first hit my radar a few years ago, when I met the founder, Shaun Clark, at the California Accounting Show. Hands down, I think InvoiceSherpa.com is the easiest way to manage accounts receivables, and I’ll give you 4 examples.
One great feature that I want to point out is the Customer Portal. This is a way for your customers to “view, pay and ask questions about all of their invoices”. One question I get often about QBO is whether customers are able to pay more than one invoice using the QBO Invoice Portal… and the answer is no. InvoiceSherpa.com’s Customer Portal DOES allow for this!
InvoiceSherpa.com’s customer portal
Here are 4 examples of industries that could benefit from using InvoiceSherpa.com to manage accounts receivables.
Consultant – We have a number of clients that do various types of consulting work, and the one thing they all have in common is having to chase down their money. Here’s how they’re using InvoiceSherpa.com to manage accounts receivables.
Before the invoice is due, you can let the client know they have an invoice, as well as schedule reminders a few days before it’s due (using email and/or text). You can also send them an automated thank you when they pay!
Use InvoiceSherpa.com to automate how invoices are sent and reminding your customers about upcoming due dates
With reminders, you can ALSO gently nudge them (as many times as they need it) if their invoice(s) becomes past due, and even schedule reminder phone calls!
Schedule email or text reminders to clients or internal team members, and schedule reminder phone calls too!
InvoiceSherpa.com makes it easy to manage accounts receivables.
Property Management – Automate late fees. As a former landlord, I could set up recurring sales receipts to charge their debit/credit card or draft their bank account, if my tenants agreed to that. If they didn’t, I could still have their invoice automatically sent. What I couldn’t do, however, was automate any late fees once they 10th of the month rolled around. When using InvoiceSherpa.com to manage accounts receivables, late fees are a snap!
The late fees are calculated based on your criteria (you can have multiple late fees, based on percentage or flat fee), and they’re added to the corresponding invoice:
InvoiceSherpa.com adds late fees to the appropriate invoice in QBO
Home Appraiser – I love the customer portal for this industry; whomever has ordered the appraiser (often an appraisal management company) has one central site in which to login, view and pay all of an appraiser’s invoices.
Customers get an invite, and have one central location to view & pay all of their invoices
Medical Provider – We have a couple of medical provider clients at Kildal Services that don’t accept insurance – they’re cash only, and they often get asked by patients for payment plans. While you can do it in QBO with recurring transactions, it’s SO MUCH EASIER with InvoiceSherpa.com.
InvoiceSherpa.com helps you manage accounts receivables with easy to create payment plans
So there you have it – 4 great reasons to use InvoiceSherpa.com to manage accounts receivables. To learn more, you can check out the QBOShow.com interview with founder, Shaun Clark here. Better yet, just go to apps.com and give it a try – free for 30 days!
My good friend and co-host of QBOShow.com has created a great video on how to designate your QuickBooks Online account as a non-profit entity:
My friend and co-host of The QBO Show, Woody Adams and I have been working out the best way to manage post QuickBooks Desktop to QuickBooks Online Conversion Sales Tax Clean Up.
Yay for you! You’ve made the move from QuickBooks Desktop to QuickBooks Online. All of your reports match, but you’ve noticed some goofy stuff in your Chart of Accounts and Products and Services list, and it all relates to your Sales Tax.
Don’t fret, I’m here to give you the step by step instructions on doing a little bit of Sales Tax clean up in QuickBooks Online after you’ve converted your QuickBooks Desktop file. I mentioned this briefly in my post called StacyK’s Step by Step: QuickBooks Desktop to QuickBooks Online: “After conversion you’ll most likely see multiple sales tax payable accounts on the Chart of Accounts in QuickBooks Online. There will be one account in QuickBooks Online for each Sales Tax Payable account you had in desktop. In addition, QuickBooks Online, by default, will create a Sales Tax Agency Payable account for each sales tax jurisdiction the desktop file had. To clean this up, you’ll need to make the accounts that came from desktop inactive (delete them) and use the new accounts in QuickBooks Online to track sales tax – make sure you make the proper adjustments to zero out the balances in these accounts.”
First thing you’ll notice are some new accounts in your Chart of Accounts. If you’ve recently signed up for a new account, you’ll head to your left nav bar and hit Accounting – this is the most likely situation if you’ve just converted. (For an older QBO account, you’ll want to go to left nav bar and choose Transactions > Chart of Accounts):
There will be one account in QuickBooks Online for each Sales Tax Payable account you had in desktop. In addition, QuickBooks Online, by default, will create a Sales Tax Agency Payable account for each sales tax jurisdiction the desktop file had.
The thing is, you can’t delete/inactivate these accounts just yet. If you try this, you’ll get this message:
Well, FINE. I didn’t really want to anyway. I have other things to do!
Unlike QuickBooks Online, QuickBooks Desktop uses Sales Tax SERVICE ITEMS, and since these new accounts in QBO are connected to those services in our QuickBooks Online account. This means we have to take care of those before we can clean up the chart of Accounts.
Unlike QuickBooks Online, QuickBooks Desktop uses Sales Tax SERVICE ITEMS.
To delete/inactivate these items, you’ll click the Sales tab in your left nav bar, and then the Products and Services tab (for older QBO accounts, hit the Gear Icon then under Lists, choose Products and Services).
I think the easiest way to find the QuickBooks Desktop sales tax service items is to click the Type to sort the list, then scroll until you find the service items you need:
Here are all of our Sales Tax Items, and all we have to do is click the drop down next to Edit and choose Make Inactive for each one:
Now that we have those deleted/inactive, we can go clean up our Chart of Accounts, so let’s head back there.
I generally make the account that came in from QuickBooks Desktop inactive first, but make note of the account number, so that I can add numbers to the accounts that QuickBooks Online created.
Remember, in QuickBooks Online: DELETE = INACTIVE.
Remember, in QuickBooks Online: DELETE = INACTIVE.
Now let’s get rid of those sub accounts with the zero balance. To do this, we have to click the drop down next to Register and choose Edit:
Then we change it from a sub account to a parent account:
Now we make THAT one inactive:
Since I have two of these sub accounts, I’ll do all of this to the other one, but spare you the screen shots.
To clean things up just a bit more, I’ll edit the two Sales Tax Payable accounts that QuickBooks Online needs to track my two sales tax rates and add the account numbers. Now I have a nice clean Chart of Accounts:
The last thing I want to do is make sure that all this clean hasn’t affected my balances, so I need to pull a Balance Sheet in both QuickBooks Desktop (here, I’ve used QuickBooks for Mac) and QuickBooks Online. I want to set the report to Accrual basis and the date range to All:
If the numbers don’t match, please note #5 and especially #6 below, in Woody’s checklist of Post QuickBooks Desktop to QuickBooks Online ConversionSales Tax Clean Up:
- Go to products & services list and delete all unwanted service items that are really the sales tax items from QBD.
- Make all sub Sales Tax Payable accounts as parent accounts
- Delete the sales tax payable accounts
- Merge the sales tax agency accounts into the Sales Tax Agency Payable account, if needed
- Sales tax center may still be jacked up, so make an adjustment.
- Draw line in sand, move on, stop over-analyzing.
Bottom line, the process isn’t too difficult – once you know what to do. However, it can be pretty frustrating if you’ve never done it before, or don’t have someone with whom you can obsess over all of it via email and text, like Woody and I did recently.
It’s busy season, and while I have at least 4000 ideas for blog ideas, the problem is finding time to get them all out of my head. Instead, I’m going this (somewhat lazy) route for a post: Greatest Hits from the Fundera.com Ledger. Trust me, these articles will be helpful! They all come from an amazing resource – the Fundera.com Ledger (I’m only slightly biased, since I write for them every month).
First up are some greatest hits from the Fundera.com Ledger, for small businesses:
Ben Rashkovich’s “7 Ways You Can Be Your Accountant’s Favorite Client”
I love this not just for the animated gifs, but because every single one of these 7 things? Will truly make you your accountant’s favorite client. Or at least put you in the top… 7.
MWood’s “19 of the Best Small Business Opportunities for 2016”
If you’re tired of working 40 hours a week for the man, why not take a look at this list and see if something strikes your fancy, so you can start working 80 hours a week for YOURSELF. Bonus – some of them may services that your existing business could start to offer. Yay!
Here are some of lending’s greatest hits from the Fundera.com Ledger:
Sarita Harbour’s How the Kind of Debt You Have Affects Your Loan Chances
We all know how important it is to be aware of our credit scores and to periodically check our credit reports for accuracy so that we’re not surprised when we seek out loans. However, when was the last time someone explained to you how the TYPE of credit might impact your ability to get a loan? Probably never, if you’re like many of our clients.
Ben Rashkovich‘s The Alternative Lending 25: Small Business Edition
So many small businesses think the only way to get funding is to go the local bank and apply for a traditional loan or line of credit. Ben points out “Fast, efficient, convenient, and flush with so many different options, the online alternative lending industry flourished as small business borrowers recognized its flexibility.” He then provides a great list of alternative lenders. A must read for any small business looking to get funding, or anyone working with a small business that might be looking.
Obviously, a list of greatest hits from the Fundera.com Ledger wouldn’t be complete without some of my own articles, about QuickBooks, of course!
My piece on The 12 Absolute Best Sources on How to Use QuickBooks Online
Here is where I list some fantastic resources for learning and using QuickBooks Online. From Intuit’s own sites, to conferences and Facebook groups, you’ll be on your way to power user in no time! One thing missing? My own QBO Show! We were on hiatus when the article was written, but we just made our return on March 3, 2016.
My work around for Job Costing in QuickBooks Online with Sub-Customers
This won’t work for every company, but it does work. You have to be diligent about tracking and keeping the transaction numbering consistent, but until QuickBooks Online gives us progress invoicing and the ability to receive a partial purchase order, it’s this or a third party app.
I hope my list of greatest hits from the Fundera.com Ledger were helpful! Like I said, I have a jillion ideas from blog posts, but probably won’t have time to get them all posted until after busy season. Which is fine, because if you’re an accounting professional, you probably won’t have time to read them until then either!
Our QuickReview™ service helped improve how our client manages sales tax in QuickBooks Online
Recently, at Kildal Services, we were contacted by a prospective client about our QuickReview™ service. We jumped on the project, and quickly identified some… weirdness.
They track Sales Tax in QuickBooks Online, with all of their sales local – no online storefront. As a Michigan based company, this, in and of itself isn’t the weirdness, or even normally an issue.
The weirdness was that they had this account in their chart of accounts called “Attachments” – that was a sub account under their Sales Tax payable account. It had a bunch of zero dollar journal entries in the register, each with an attachment. After looking at this, we realized that these JEs were all the same date as the Sales Tax Payment in the parent account, and the attachments were all the PDF confirmation of their online payment for their Sales Tax payment.
Aha! So not that weird, really. But still not an ideal process – it’s still a two step process and the payment confirmation is never attached to the actual payment in QuickBooks Online, which is really what the client wanted. Unfortunately, the Sales Tax module is very rigid in QBO and does not allow this.
So we came up with a solution for them.
Here’s what they’re doing now:
1. They open up the Sales Tax Center in QBO to see what they owe for Sales Tax. In the screen shot below, you can see they currently owe $1.20 in the balance column. Also note, there are 2 payments showing in the Payments column, but nothing showing in the section titled “Recent Sales Tax Payments”
Now that that they have their Gross Sales and Taxable Sales, they’ll be able go to Michigan.gov and submit their return and payment (if this company is a quarterly filer, technically they have nothing due just yet).
2. Now, in QBO, they’ll open the Sales Tax Payable register, and record the Journal Entry for the payment (yes, I know, I KNOW. We’re not following the proper workflow. I promise it will be okay.)
Why are they doing a JE, when everyone says to avoid them in QuickBooks if you can? In QuickBooks Online, you aren’t allowed to create a check or an expense transaction that posts to the Sales Tax Payable account – you can only use a JE. And you can’t attach anything to a normal sales tax payment, but you CAN attach a document to a JE. See where I’m going with this?
Right here you see the attachment. This is actually picture of Ted Nugget, my vision of Ted Nugent, in chicken nugget form, but you get the idea, right?
3. Despite the “Recent Sales Tax Payments” section showing no payments (see above), they can still click on the “View All” button and they’ll be taken to a report that does, indeed, show them the payments, recorded as Journal Entries:
Now the client has ONE step in QBO – entering the JE and attaching the payment confirmation, rather than recording the payment, then entering the zero dollar JE and attaching the payment confirmation. The Sales Tax Center still shows the correct balances, as well as previous payments, and they can still easily view a report with all of those payments from the Sales Tax Center.
Yet again, our QuickReview™ offering found an anomaly in the setup, but instead of it being something in need of fixing, it provided us with an opportunity to do what we do best: show our client how to work better, faster, smarter.
The best part? They were so impressed they hired us to do their books. Another one time engagement that turned into long term revenue. Yay!