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!
That’s right. I said it.
For years I’ve had standard bookkeeping packages and offered them to clients… In reality? I just couldn’t get them work. I even tried given them names: “Bronze, Silver, Gold” and assigning set services in each level. Didn’t really make a difference. But MAN, I really did to make these a part of my practice, especially after I hired people to work with me.
When I got to the point of quoting services, I would present the packages. One of two things would happen. Either the client would say: “Well, those are nice, but what I really need is…” and then describe exactly the services they were looking to have us provide. This was good! It would leave me an opening to give them a price for what they were asking. Or, the client would say: “Thanks, but no thanks, I”ve decided to see other options”. This was not good. It meant the client had had moved on and I’d missed out.
If the client hadn’t already completely written us off, when pressed, they could never quite pinpoint why they decided to go another route. I eventually figured out after some discussions something that I’ve always known, but in these situations, was missing it completely. First: the client didn’t know what they needed; didn’t know what they didn’t know. Second, they wanted choices, and felt these packages didn’t offer that.
Early on in 2014, I took a different approach with prospective clients. Rather than offering packages that included set services, I started offering a more a la carte system. The result? Out of all the prospects that approached Kildal Services LLC in the first quarter, we’ve closed all but two. For the record, those 2, we never got to the point where we could even quote services, because the clients were non-responsive after the initial contact.
What this evolved into was a system that we call “Base Plus” billing. Once we’ve done our initial client interview, data review and needs analysis, we offer different levels of service, starting at the base:
Basic services that include services such as account reconciliation, after the fact bookkeeping via bank feeds and a few other simple services.
The client has the option of including “Add On” services, resulting in Basic +1, Basic +2, and so on. Add ons include payroll, Accounts Payable management, Accounts Receivable management, etc.
Each of these has limitations. For instance, the payroll option covers up to 5 employees, with additional fees for any employees over that initial 5. If the client requires something above and beyond these limitations, we provide them a custom quote.
Two things I want to mention. I understand that there are some firms that have made the standard packages work and I commend them. I’ve just found that for the types of small businesses that my practice (and the ProAdvisors for which I’ve done consulting) services, they’re not the best option. Also, for all of those people that I’ve presented to and taught to build packages – at the time, I truly believed that these would work, and up until recently, I regularly offered them to clients.
This method makes it so that the client is able to choose a level of service that they’re comfortable with (for instance, some clients that have been doing everything themselves since they started their business just aren’t ready to turn over paying bills right away), and that their current budget allows. They can see that services can be customized to their needs, and that they’re scalable as their company grows.
Often, clients come to us because often they come to us feeling just beat because they’re struggling with their bookkeeping. They could be doing other things – working on growing their business, or spending more time with their family. The two most surprising – and important – side effects that I’ve noticed since implementing the “BasePlus” billing method is that the client feels great sense of empowerment over this and they understand you’re creating a truly collaborative relationship.