Using Late Fees in QuickBooks Online

Using Late Fees in QuickBooks Online

I’ve had quite a few clients ask about using late fees in QuickBooks Online lately, so I thought I’d write an article about how to set them up and use them.

To start using late fees in QuickBooks Online, we have to go our Gear Icon > Account and Settings and then choose the Sales tab and find the Late Fees section:

late fees 01

 

From here, you can set up late fees in QuickBooks Online – flat fee or percentage of remaining balance and the frequency (once per invoice, per month, or per day) as well as an optional one time fee.

In this situation, we’re going to set up a 2% per month fee, with a one time $25 fee:

late fees 02

 

We’re going to give the customers a 7 day grace period before applying late fees in QuickBooks Online. What this means is that if the due date is the 1st, late fees won’t begin accumulating until the 8th:

late fees 03

 

The last steps are deciding what to call these charges on invoices and choosing whether to apply sales tax. We’re going to leave the default “Late fee”, and not apply sales tax, then we’ll click the Save button:

late fees 04

 

When you click Save – QuickBooks Online will create a new account called “Late fee income”. This account is an Other Income type:late fees 05

 

If you’d like, you can edit this account:

 

Oh wait – did you mention that you want to be able to customize this, on a customer level? No worries there! We can choose to disable late fees for a customer, or override the default late fees. If we click on the Sales tab in the left nav, then chose the Customers tab (or Clients, or whatever your QBO calls customers) then click on the customer name to get to the Customer Detail page to customize late fees in QuickBooks Online for a specific customer.

For the customer below, we’re changing the 2% to 3% per month, and the one time fee from $25 to $50:

late fees 07

 

NOTE: Late fees in QuickBooks Online won’t be applied to invoices created before the feature was turned on

 

They only work for invoices created on or after the feature is turned on. This means that any existing past due invoices won’t have late fees enabled for them. You can tell if an invoice is eligible when you open it. In the header, under the due date, you’ll see this:

late fees 08

 

For invoices created AFTER late fees in QuickBooks Online was enabled, you’ll see this:

late fees 09

 

Once you have late fees enabled, when you DO encounter a customer with a past due invoice, you’ll see that invoice automatically updated with late fees added as a line item.

Below, we can see that this customer had the one time $50 fee applied, then 3% per month.

(Note the 3% is calculated on the total of the invoice – the original balance plus the $50 late fee – not just the original balance)

Late Fees 12

 

When we look at the Profit and Loss, we can see these in “Late Fee Income”, and they’re in the same period as the original invoice:

Late Fees 13

 

When you enable late fees in QuickBooks online, an item is automatically created and can be found in the Product and Services list.

late fees 10

 

The amount and description are both left blank, so that when late fees in QuickBooks Online are applied, QBO can add the description and total, according to preferences applied during setup:

late fees 11

 

If you’ve been using QuickBooks desktop and the late fee feature there, you’ll know that rather than add line items to the original invoice, QuickBooks desktop creates a NEW invoice with “FC” in the reference number to apply late fees. Historically, our clients have found it much more difficult to get these paid and have to be voided. Late fees in QuickBooks Online makes collections much more simple by adding the line items to the original invoice.

Good luck in your quest for speedy payment from customers; hopefully you won’t need to use this feature 🙂

Receipt Capture in QuickBooks Online

Receipt Capture in QuickBooks Online

Released in June 2019, Receipt Capture in QuickBooks Online allows users to directly upload receipts to the QuickBooks online banking center where QBO will read the receipt and either match to an existing transaction or allow users to add a new transaction.

There are two ways to add receipts: drag/drop to the Receipts center or email to a special Receipt Capture email.

The first thing we want to do is add senders, otherwise the only people that will be able to email are the Master Admin and of the QBO account and Accountant Firm users. We’ll need to go to Banking > Receipts > Manage senders.

 

Screen Shot 2019 06 13 at 12.49.19 PM

 

For first use, you’ll be asked to register your email for Receipt Capture in QuickBooks Online. Because I was logged in as the Accountant Firm user, that email address became connected this client QBO account. It is possible to connect to multiple clients; in order to send to a different client, you need to toggle your Accountant user name to off in the active client account, switch to the another client QBO account, then toggle your Accountant user on, then send the email.

In the screenshot below, you see the Master Admin of the QBO account and myself, the Accountant User. To add additional users, just click the “Add new sender” link as needed, choose from the list of current QBO users (Note: At the time of this writing, only current QBO users with at least vendor only access may be added as sender) then “Done” when you’re all set:

 

Screen Shot 2019 06 13 at 12.55.59 PM

 

Before we start adding receipts, let’s take a look at the Receipts center. If you’re familiar with the QBO bank feeds, you’ll feel right at home. We have a “For review” tab and a “Reviewed” tab. Here we have two receipts that have already been uploaded and added. We can click on the “Expense” link in the Linked Record column, or if necessary, we can choose “Undo add” in the Action column:

 

Screen Shot 2019 06 13 at 12.59.22 PM

 

Clicking on the first receipt in the above screenshot, we can see the receipt attached:

 

Screen Shot 2019 06 13 at 1.03.06 PM

 

I want to show you a few things: both ways to add a receipt, as well as how you either manually add an expense and how cool it is when QBO Receipt Capture matches an existing transaction.

We’ll start by emailing a receipt and manually. You can see here that it shows up in the Receipts center immediately, but it does take a few minutes for QBO to read it:

 

email

 

While it’s processing, you can hover your mouse over it for a preview:

 

Screen Shot 2019 06 13 at 1.42.01 PM

 

Once this was processed, I was able to quickly add the expense to QBO:

Again, here’s the expense transaction, showing the receipt attached to it:

 

Screen Shot 2019 06 13 at 3.29.31 PM

 

Now, let’s do the drag/drop to match a transaction that I added specifically to for this fake receipt I created just to write this article!

 

drag and match

 

Here you can see it in the Reviewed tab in the Receipts center:

 

Screen Shot 2019 06 13 at 7.52.11 PM

 

And here’s the original expense, with the receipt attached:

 

Screen Shot 2019 06 13 at 7.53.32 PM

 

Don’t forget – you can even use Receipt Capture in QuickBooks Online with the mobile apps as well:

 

Screen Shot 2019 06 13 at 8.09.56 PM

 

You can check out the QBOShow interview about Receipt Capture in QuickBooks Online with Intuit Product Manager Rebecca Gilbert for more information.

 

 

 

Set up recurring reminder emails in Gmail

Set up recurring reminder emails in Gmail

My last post was about setting up an auto reply to email inquiries, and I thought I would share another tip on how we use Gmail and some cool add ons: setting up recurring reminder emails. I’ll be using Boomerang for Gmail – one of my favorite gmail/chrome extensions – to set up recurring reminder emails.

The use case here is that Kildal Services has a few payroll clients that have employees that get a quarterly commission payout, and we want to remind our clients to send us those totals. (For the record, the body of the email and the dates I use here are just to illustrate this task; they don’t necessarily represent the actual commission payroll cycle our clients use.)

Create a group for your reminder emails in Gmail

The first thing I want to do is head over to my Gmail Contacts to create a label and add it to the clients that will need to get this recurring reminder:

 

contact label

 

Now that I have the clients categorized in my contacts, it will be much easier to add them to the reminder email. I’m going to send this TO MYSELF, and BCC the client group in my contacts.

Creating your reminder email in Gmail

After I create the email, I want to click the Send Later button that Boomerang adds, click Schedule Recurring Message, and edit the start date and time, how often I want it to repeat (monthly, every 3 months), and if I want an end date (for now, no end date, because I’m expecting to have these clients forever ☺)

Once I have all of that set, I’ll click that red Schedule button, and now every three months, this email will go out. Because I’m sending to myself and bcc’ing the clients, no one will forget!

 

If I ever need to edit this, I can click on the Boomerang icon in Gmail to manage any recurring messages:

 

Screen Shot 2019 04 14 at 3.13.56 PM

 

There you go! Easy method for setting up reminder emails in Gmail!

Auto Reply to Email Inquiries

Auto Reply to Email Inquiries

If you’re like most businesses, you have some sort of contact form on your website and one way to save time with them is to set up an auto reply to email inquiries. (If you’re a ProAdvisor, this comes in handy for leads from FindaProadvisor.com.)

Since we use GSuite/Google for Business/Gmail, I’ll show you how we do this – create an auto reply to email inquiries – with Gmail’s filter and canned response features. Added bonus – I’ll show you how to use another free tool to track whether your auto reply has been opened.

Enable canned response

Our first step is to create a canned response in gmail.

Click the Settings icon, choose Settings, then Advanced, click to Enable, then scroll down to Save Changes:

Compose your canned response

Now we want to create the response.

Compose a new email, leaving the subject and recipient blank, then click 3 dots/More Options next to the trash can, canned response and choose to save this as a new template and name it:

So now your canned response is ready to be used as an auto reply to email inquiries. You can use this any time you’d like when replying manually to an email, but we want to use this one with a filter for inquiries sent via our website.

Create a filter in Gmail

We just need to create the filter. For one of our landing pages, when a prospect uses our contact form, each email comes to us with a default subject line: “I’m Interested in a QuickReview!”, so we’ll use that as our filter criteria.

We want to again click the Settings icon, choose Settings, then Filters and Blocked Addresses, click Create a New filter, add the text subject to the filter criteria, click Create Filter, then choose our new canned response, then click the Create Filter button:

create filter

Here’s the end result of creating an auto reply to email inquiries, as seen from your end (in your sent folder):

Screen Shot 2019 04 14 at 11.22.03 AM

So there you have it! Without any extra apps (or cost!), you can create an auto reply to email inquiries about your business!

Automating Data Entry Using QuickBooks Online

Automating Data Entry Using QuickBooks Online

Back from a bit of a summer break, we’re diving right in with a guest blog post. My friend and co-host of QBOShow.com, Woody Adams, has written this piece about automating data entry in QuickBooks Online. there are a variety of options to choose from, and below are a few:

  • Bank Rules/Auto-add—google vendor upload show result
  • Invoice automatically for unbilled activity—invoice L1386
  • Recurring transactions/auto-email invoice/sales receipt
  • QuickBooks payments – recurring sales receipt/ACH
  • Send trial balance to ProConnect Tax Online

Let’s dig in to automating data entry using QuickBooks Online, and thanks so much to Woody for writing this!

First, we all know why we prefer QuickBooks Online Plus over Essentials, right? Need I remind you…

  • 5 Users included (can expand to 25) + 2 Bookkeeper/Accounting Firms + Unlimited Reports Only Users
  • Class/ Location Tracking
  • Purchase Orders
  • Inventory using FIFO valuation/ track profitability with two-sided items
  • Billable Time/ Expenses, Two-sided items
  • Budgeting
  • 100 + Reports

Yeah, two-sided items is my sleeper hit, but I just think Plus is most akin to QB Pro, minus a few features still: Labor burden tracking, finance charges, loan manager (LOL), Estimate v Actual reporting, single unit of measure, just thinking of some of the key gaps…still, Plus is the QuickBooks Online most similar in feature set. That being said, QuickBooks Online supports data entry automation in a better way than QB Desktop. While both platforms can Auto-send reports and enter Memorized (Recurring) transactions, this is where QuickBooks desktop ends re automating transaction or form entry. And this is the part of the story that QuickBooks Online continues…

“Automatically add to my books”

This feature lives inside of a bank rule. It is a tiny checkbox at the bottom of the rule window. The box is NOT default checked and probably for good reason. Imagine the havoc. However, if you are establishing a rule for how a bank feed transaction is to be categorized and the correct Payee is assigned, and you do not need to review the activity, but can just let it dive into the register once the rule is applied, then this feature is your new best friend.
image2

Literally, I kid you not, the downloaded transactions skips the For Review tab and just ends up in the books. You can see the Mode too the bank feed applied when click the blue link at top left of transaction that is NOW in the register…

image1

Invoice Automatically for Unbilled Activity

Quite a mouthful, eh? Even if you are not from Canada…

Go to Gear icon, Account and Settings, Advanced tab. You will see this sub-section entitled “Automation”. It’s the 3rd option. See screenshot below. This will enter invoices for any unbilled activity from the following posting or non-posting events: Bills, checks, expenses, time, delayed charges and bank feed transaction (not yet supported at the rule level), assuming the Billable box is checked. QuickBooks Online, like QuickBooks desktop will assume you want to create invoices for the yet to be invoiced time, material, expense, but go one step further…regardless of client, create invoices for all unbilled activity based on the interval you choose. What about Journal Entry you say? There is no Billable box on a JE in QuickBooks Online Plus at this time. Why do I say Plus you ask? Cause Plus is required if you want to tag “TME” to a customer, sub-customer or project (sort a’ new) and is the only QuickBooks Online level that offers making this stuff billable. In QuickBooks desktop it is the Add Time/Costs window on route to the invoice. In QuickBooks Online Plus, it can be invoices automatically created. The below invoice was created while I had that automation feature active…Woody forgot he had all this unbilled activity for this customer once, turned on the feature, the next day an invoice was created that had 150 target lines on it. LOL. I saw the invoice. He emailed it to me because we find that kind of thing hilarious…

image3

image5

Qualification: This is a Global setting, no I don’t meant like overseas. I mean it will create invoices like Jack Bauer would; rogue and coming in heavy guns blazin’. If you require to select what customers get what invoices for what unbilled activity, do NOT turn this feature on. Instead, leverage the next feature that QuickBooks desktop also has but only in part…

Recurring Invoices

Yes, I know. I been using QuickBooks Online since 2003 and QuickBooks desktop from way before that. I know Desktop has memorized invoices capability. However, when we’re talking about automating data entry using QuickBooks Online, the same recurring invoice feature in QuickBooks Online offers the ability to include unbilled activity. This is great as while I like the more global setting, this feature can focus on a specific customer.

image4

The above recurring invoice template will be created and any unbilled activity tagged to the customer anywhere else in the QuickBooks Online file (bills, checks, expenses, delayed charges, time) will be included. Sweet!

Recurring Sales Receipt/QB Payments/Auto-Getting Paid

One of the coolest features for automating data entry using QuickBooks Online, period. We do this with most of our subscription billing based clients. In our QuickBooks Online file, we set up a recurring Sales receipt for each client. QB Payments is turned on in Settings. I check the box in the recurring Sales receipt template to auto send to client (input their email address) and I enter their banking/routing numbers in the Payment method field. There is a PCI compliance script you can read to them, a box to check, and then I just leave it alone. Every month the clients gets the emailed receipt, 5 days later I get paid. QB Payments is free and ACH is free so it costs me only the time to set up the recurring transactions for my clients. 5 day funding period might raise a few eyebrows. I have one question to bring them down to a reasonable level: How many days does it take to collect against an open invoice for one of your clients? It’s not 5 days. LOL Maybe you even have to send a drone over to their home or location. As far as you know, Shannon and I have never had to do that…

image8

image7

Lastly, automating data entry to the tax return in ProConnect Tax Online. We don’t have any tax clients but I have seen Woody do this in webinars. No, he does not have any tax clients either, but he is a QuickBooks Online nerd just like me and you. And not having to enter data into the data fields in ProConnect Tax Online does qualify as automating data entry.

In the Trial Balance tool under the Accountant Toolbox, when in a client QuickBooks Online file from QuickBooks Online Accountant, you will see Trial Balance. This is not the report but a Working trial balance that also is the launch pad for the native integration we know have with ProConnect Tax Online. Pictures worth 15 or 16 words…

image9

image6

image10

By the way, all the above functionality that automates data entry is in QuickBooks Online as it is, with no other apps required. Of course there are several great data fetching apps that help with Automating Data Entry Using QuickBooks Online. Ask me about them someday!

What are you comparing QuickBooks Online to?

What are you comparing QuickBooks Online to?

What are you comparing QuickBooks Online to?

GUEST BLOG BY WOODY ADAMS

Comparing QuickBooks Online Plus Feature Set: Parity with QuickBooks Pro

 

To what QuickBooks Desktop product are you really comparing QuickBooks Online? This is an important question to ask yourself if you really prefer QuickBooks Desktop for your clients over QuickBooks Online. Having presented QuickBooks Online and QuickBooks Desktop to thousands of firms since early 2009, I can say when it comes to QuickBooks Online distaste from an accountant’s point of view, it is mostly about lack of parity in report customization and click-thru workflow.

There are gaps in report customization in QuickBooks Online, for sure, as well, some workflow cumbersomeness; too many clicks to get to same result in QuickBooks Desktop , tabbed browsing vs open windows, etc. However, your clients, for the most part, do not care about that. Accountants are using QuickBooks Accountant Edition to work with their client QuickBooks Pro files, and QuickBooks Accountant Edition is a Premier level desktop program.

My contention is that many of your clients don’t need build assemblies, job costing, manufacture in process, sales order fulfillment as a critical feature set. Again, what QuickBooks Desktop product is your greener grass than QuickBooks Online? If most of your desktop clients are using Pro, then QuickBooks Online Plus already is on par with their current experience. That is right, apples to apples, outside of YOUR reporting and workflow preferences of QuickBooks Desktop , that your client DOES NOT consider as critical to QuickBooks Online adoption, QuickBooks Online Plus is already, save for 1 feature, on par with the QuickBooks pro feature set. Oh, I am sure there are a few other features I will not address below that is in Pro yet still not in QuickBooks Online, but again, only a few of your clients actually use Loan Manager, LOL…You see what I mean? What actual QuickBooks Desktop product are you clinging to in comparing to QuickBooks Online? If it is Premier or Enterprise Solutions, then we are asking the wrong question. Your client is using Pro. They can adopt QuickBooks Online. Even if you do not want them to, they can, and you can stop with the age old file transfer model that is just the very definition of cumbersome…

Let’s take a look at the key QuickBooks Pro features that your product and service based business clients are going to want in QuickBooks Online, and run thru a few of the key settings to turn them on in QuickBooks Online Plus.

My feature set parity is really about comparing QuickBooks Online Plus vs QuickBooks Pro, and while some features below will also be in Essentials, my apple to apple is Plus v Pro. And the two features I mention above still not in QuickBooks Online that I consider critical and awesome in QuickBooks Pro is Estimate vs Actual reporting and the Markup column on Estimate. Pro just does that getting out of bed in the morning, where you will see below, QuickBooks Online Plus requires a lot of extra steps to get to the same result. But even without a 3rd party app, it can be done. For me, the question of comparing  QuickBooks Online to QuickBooks Desktop is not about my wants and preferences/bias, and more about mobility and collaboration. Does your client want to be mobile more than the ability to use Loan manager? Don’t keep them on QuickBooks Desktop just cause it is your comfort zone. For whom are you really solving?

What are you comparing QuickBooks Online to? For whom are you really solving?

 

By the way, QuickBooks Pro does not support Build assemblies, customer price levels per item, multiple unit of measure conversion, WIP reporting, sale order workflow either. What QuickBooks Desktop product are you comparing QuickBooks Online to again? Ok, Ok, I will stop…

Gear icon/Account and Settings. From the screenshots below, there are two features that need to be turned on else you will think QuickBooks Online does not support these Pro features. Namely, Price Rules (Price levels and still in beta) and Inventory (FIFO, not average cost). Price Rules in Essentials and Plus are more akin to Premier level Price levels, in that I can create custom prices for items. One better, I can even set a date range for the rule to apply. Pro price levels support not date ranges and are only a Fixed %. Neither product supports price level reporting. QuickBooks Pro inventory items are 3 sided, so it is in QuickBooks Online Plus. Inventory asset, revenue and COGS are hit, and cogs is debited when the item is sold, just like in QuickBooks Desktop . QuickBooks Online Plus supports inventory adjustments, while the “starting” value adjustment is intended as a one-time adjustment, where in Pro you can make ongoing cost or value adjustments. I like that in Pro. Pro supports partial receiving against purchase orders, so does QuickBooks Online Plus. Pro does handle single units of measure, Plus does not. But multiple unit of measure conversion is a Premier/ES thing, as is assemblies and sales order fulfilment. Pro supports none of that. Keep in mind, there are plenty of good 3rd party apps that solve for the more Premier/QBES level features if a client really wants to stay on QuickBooks Online for mobility, but I will not address them in this article. You can find out more on apps.com…

Please see several screenshots below re what I have been discussing re inventory and price rules, shots are all taken from my QuickBooks Online Plus file…

image10

Pro supports reorder points, so does Plus. As well, note the 3-sided items in both for inventory parts, as well as Quantity On Hand, Sku or Manufacturer Part No, and other important item detail fields. Pro does have custom fields which Plus will not, I miss that one too.

Comparing QuickBooks Online to QuickBooks Desktop

 

image7

image9

image3

I do like how the Price rule is shown at the item record level in QuickBooks Online Plus, whereas Pro I have to go to the actual Price level list to see. Also, see how lame Pro’s Price level function is vs Plus…Again, Plus supports price ruling customized by item, customer type and by date.

image4

image14

And on a sales form, in rate field, just like in Pro, QuickBooks Online will show the default sales rate and the price rule rate:

image1

Pro supports partial PO receiving, and so does Plus…

image17

As well as QOH adjustment, value adjustment (starting value remember, not to be done all the time), and even preferred vendor…Oh I also love the Stock status at top of P&S list in Plus now.

image16

If I prefer QuickBooks Pro at all, it is due to custom fields at the item and name level, as well as the Markup column on Estimates. In Pro, I can see my estimated cost and revenue on the form itself, without even running a report. Not so with Plus, though I can get really close and there are some key settings to turn on to get the Estimating feature set. We not turn our gaze to those, think key features for service based businesses…

image12

image15

Now, look at the QuickBooks Online Plus estimate above. I have already invoiced progressively against it. Progress invoicing is supported in Pro, and also in Beta in Plus right now, soon to be rolled out to all Plus subs. It behaves just like the same feature in Pro save for reporting. At this time in Beta, not a lot of good visibility outside of the actual estimate or invoice of what has been invoiced against etc…But that will be added soon. Pro gets the same pop as below re Progress Invoicing…

image2

QuickBooks Pro supports Estimate to Actual reporting, for me the last real gap in QuickBooks Online that matters. I hope we get it in Plus sometime soon…

image8

That being said, since I can do more than 1 budget per year in QuickBooks Online Plus, I can create a budget for the customer/sub-customer/project, like I can for a customer/job in Pro, and run the Budget vs Actual report filtered for that sub-customer/project to get the same info/result in Plus as in Pro…

image13

A few key settings to get the job costing going in QuickBooks Online Plus to be like QuickBooks Pro, see screenshots below. This allows me to pass thru time, expense and material to an invoice, or just tag jobs for profitability reporting.

image6

As well, I can tag a customer, sub-customer or project to time entry in QuickBooks Online like in Pro, but remember, time is non-posting till you add it to a posting transaction…and no, QuickBooks Online cannot track labor burden by job yet.

image5

The Projects tracking feature can be turned on too, as it gives a Project center for good transaction, report and progress visibility. Pro does not offer the below visually or even in a center…

image11

Net…net…QuickBooks Online Plus is super close to QuickBooks Pro feature set wise. Just a couple more enhancements and they will be literally interchangeable as options for your clients to track their businesses. There are advantages and disadvantages in both platforms, and I think a firm should support both for the most part, as our industry moves closer and closer to cloud only.

Side by side: comparing QuickBooks Online to QuickBooks Desktop

 

Last, I wanted to leave you with a thorough comp chart of QuickBooks Desktop and QuickBooks Online. Important to note, the stuff in red in the QuickBooks Desktop and Not in QuickBooks Online column is not in QuickBooks Pro ☺.

image18

Pin It on Pinterest