QBO Banking: Deep Dive with Valerie Heckman

In case you missed it, our show on 4/21/2015 was magical. Intuit Product Specialist Valerie Heckman was our guest and gave the audience a deep dive into QuickBooks Online bank feeds. You can catch the video here.

We asked her to do a guest post, and of course, she rocked it:


Banking in QuickBooks Online (QBO) is sometimes called “The Bank Feed”, sometimes called “Downloaded Transactions,” and sometimes “Online Banking”. Regardless of what you call it, this is essentially the connection between QBO and your various financial institutions to bring your transactions into QBO quickly and to match up your transactions already in the books to the bank’s data. The goal is to know that what is happening in QBO is reflecting what is happening in real life in real time (without the long wait for a bank statement to arrive!) and to automate as much as we can.
I stopped by The QB Show to help de-mystify some of the processes and options involved in QBO Banking. Please keep in mind that QBO updates often, so the information shared here may change over time. In my opinion, we’ve improved so much of this process over the past year or so. I’m excited to see how we make it even better!
Section 1: Connecting Accounts
When making the connection, you’ll be prompted to search for your bank. Using the URL for your bank sign-on webpage is going to yield the best results. Why? Some banks have more than one webpage for different types of accounts. If you’re connecting to the wrong site, your user ID and password may not be recognized.
Biggest decision during the connecting process is “How many days of data do I want to bring in?” The default is 90, but you can decide to bring 0, 7, 30, or 90 through the connection. My best suggestion is to base this choice on the last time you reconciled.

Section 2: File Upload
There are a handful of common reasons to use a file upload (.csv, .qfx, .qbo, .ofx) instead of/ in addition to a connection:
a. You want to bring in more than 90 days of transactions (most common)
b. You want to bring in a very specific date range
c. There’s an issue with the connection and you need to manually upload in the meantime (I hope this doesn’t happen, but just in case!)
d. You are interested in only bringing in “money spent” or only bringing in “money received” transactions (rare, but a reason)

Your bank might make it hard to find the file on their website. My advice is to look for anything section that mentions downloading activity for financial management software or accounting software. Some will call out QuickBooks or Quicken by name.
.QBO is the ideal file type to bring in and it’s usually listed as “QuickBooks Web Connect QBO”. CSV files will involve a little bit of mapping, but nothing too complex.

Section 3: Navigation and Setting Up
Once connected, you’ll have a box or “card” for each account along the top. The name of the account pulls directly from what it has been named in the chart of accounts and you’ll see the bank balance vs what is in QBO.
Even after we match/ add, these amounts may not match if there are transactions in your books that have not yet cleared the bank (i.e. I recorded a payment, but my vendor has not cashed the check yet).
Toggle between the cards or hide them to give yourself more space. Each card will show a time period that reflects the last time new transactions were found. You can perform a manual update if you’d like, but QBO will search for new transactions every night. Keep in mind we only bring in transactions that have posted, not pending.
The pencil icon allows me to edit the sign on info (if I change my user id or password for the bank website) or edit the account info for the chart of accounts.
“Go to Register” will open the register for the account. I like opening the register in a separate window or tab and using it as a reference. This is a personal preference, not required by any means. Just keep in mind that if you make changes in one window/tab, you’ll need to refresh your page to see them in the other window/tab.
The Gear Icon lets you make some customizations to the page. Compact will consolidate the rows to view more at a time. You can think of these views like “wide ruled” vs “college ruled” notebook paper.
Columns can be sorted as well by clicking the header. I like to sort to make my dates ascending (mostly to match the register), but your way of tackling this task may be totally different.
My primary tabs are New Transactions, In QuickBooks, and Excluded. When you accept bank transactions, they go from the New Transactions tab to the In QuickBooks tab so you have a record of the items you accepted. You can undo from here if needed.
Transactions that have been excluded do not post, but can also be reviewed from this menu in the future and undone. The most common use for exclusion is when you have a duplicate.
Section 4: Transactions
When QBO receives your bank data, it does a number of things:
• Cleans up the often cryptic/ coded bank text to give you descriptions.
• Looks for matches to the transactions you already entered into QBO.
• Checks for rules you’ve created (we’ll talk about those in a bit!).
• Remembers what you did in the past and suggests categories based on those previous behaviors.

You have the option for each transaction to add, match or transfer. Transfer includes both bank transfers and transactions that pay off a credit card, since they are a transfer of money from one account (usually checking) to a credit card liability account.
QBO will attempt to match with most transactions you’ve already entered into the books. This includes journal entries and open invoices/ bills. If you match against an open invoice/ bill, QBO creates the receive payment/ bill payment transaction in the background for you. Saves time!

I recommend using the “Recognized” filter first to see everything that QBO has either matched, applied a rule to, or suggested a category for. Check matches for accuracy and then address the remaining items.
Section 5: Manual Matching
QBO will do it’s best to match, but sometimes you need to use “Find Match” to pair transactions. Here are reasons QBO may not have found a match:
a. The transaction has already been reconciled.
b. The transaction type is different in QBO than at the bank. Let’s say I record an expense as a check, but the bank has it as an ACH. QBO wants to match a check with a check and an expense with an ACH or debit/credit card swipe.
c. The amount doesn’t match. You can resolve the difference in the Find Match window by creating a new transaction for the amount of the difference, or go back and edit the original transaction and refresh your banking page to see the match.
d. The date is different. Usually if the recorded date is within a few days of the bank date, it will pull a match, but if there’s a several day discrepancy, you may need to search for the transaction.
e. If the bank account on the recorded transaction is wrong, it won’t match. Tip: Use your global search or audit log to quickly find that transaction in QBO if you are unsure which register it is in.

Section 6: Adding and Rules!
After matching, I may find there are transactions from the bank that are not in my QBO register. I could create them and then match, but why not save time and energy and add them from here?
I can add a payee (optional) and if I have class and/or location tracking turned on (QBO Plus), I can make those indications as well. I also have an option to perform a split. As mentioned, QBO will learn from past behavior and help you automate this process.
To fine tune how QBO automatically classifies transactions as they come in, I can create rules. Rules Rule! Rules allow me to set up conditions for transactions based on money in/money out, bank account, description, bank text, and/or dollar amount. I can assign to category, payee, and class/location (QBO Plus), and create splits if desired. You can add these on the fly while adding or through the manage rules window.
The Manage Rules menu allows for you to add new rules, edit existing, and reorganize them to prioritize which rules are to be applied first when more than one rule applies. You can save time when creating similar rules by copying existing rules and making tweaks. Rules will only apply to transactions that have yet to be added or matched.
You can export rules and import them into another file, which is especially useful if you are an accountant or a business owner with multiple QBO companies. When you import to the other file, you’ll have a chance to select the rules you want and map to the chart of accounts and payees.
Think outside the box! There are many, many ways to use rules to automate and streamline your common transactions. Do some brainstorming and try them out. You can always edit or delete rules if you decide they are not working for you.

Bonus: Basic Troubleshooting
I hope that you don’t run into errors much but if we are being realistic– errors happen sometimes when two services have to talk to each other. It’s good to be prepared. There’s a lot going on behind the scenes here at Intuit improve the processes of reporting and fixing errors. Please use the feedback link under the gear icon to share any ideas you have around any improvements you’d like to see in QBO (compliments are accepted, too ☺). Many errors will advise you on how to fix or report.

Here are a few things to try before speaking with support:
1. Run a manual update by clicking the update button.
2. See if you can sign in on your bank’s website. Sometimes there’s something going on in the account itself. Site maintenance, new terms and conditions, or security question updates are a few examples. Maybe you changed your user id and/or password on the bank website and need to update in QBO.
3. Make sure you are using the same URL for QBO as the bank webpage in your initial connection is coming up with errors.
4. Refrain from disconnecting and reconnecting, unless recommended by support (very uncommon), as that doing so may create duplicates or other issues.

Hope this was helpful! Thank you for reading and watching!

Valerie Heckman is a Product Specialist with Intuit’s Accountant and Advisor Group. She specializes in QuickBooks Online and best practices moving accounting firms and their clients to the cloud. Valerie lives just outside of Chicago in Schaumburg, IL when she’s not on the road with Intuit’s Business Development Managers. You can find her on twitter @vheckman.

Please welcome our latest sponsor, Qvinci

We’re so excited to introduce the latest member of TheQBShow.com family, an incredible app!!! Here’s our guest post from:

small-banner

What is Qvinci?

Qvinci is a cloud-based financial reporting tool for accountants & bookkeepers, franchises, and other multi-unit or multi-client organizations. On a daily basis we automatically sync all types of QuickBooks files (and others) into an account with single sign-on access, unlimited log-ins for clients, 6 types of standard reports, and email alerts. Automated file health checks keep files clean and errors to a minimum.

Why do Accountants & Bookkeepers use Qvinci?

With unlimited log-ins, accountants & bookkeepers save days of work each month by not having to create and email reports to clients. And with the ability to mix QuickBooks Online files and QuickBooks Desktop files in a single account, client reporting is standardized, even through transitions. Many customers and clients also like being able to continue to use QB Desktop with the convenience of cloud reporting.

For clients with multiple locations, Qvinci’s financial file consolidation and benchmarking features are unparalleled for hassle-free, low-overhead reporting. This allows accountants and bookkeepers to expand their role from one of collecting data and building reports to being able to provide business analysis and insight – creating opportunities for deepening engagements with clients and offering more services.

Qvinci features include:

  • access to all linked client files with a single sign-in
  • daily file “Health Check” monitoring to identify basic accounting errors (before clients see them)
  • up to 36 months of data: P&L, Balance Sheet, Cash Flow Statement, Sales by Customer, Expense by Vendor, AP/AR aging
  • peer benchmarking (industry benchmarking coming soon!)
  • dynamic mapping to a Standard Chart of Accounts with ability to view reports with native or standard account names
  • customizable non-financial properties for advanced report filtering

 

How much does Qvinci cost?

Qvinci’s pricing model allows accountants with single-location-only clients (no consolidation) to use the application for free. For clients with multiple locations requiring consolidation, the cost is $14.95/file/month, with discounts for annual subscriptions and organizations with more than 100 files to consolidate.

Where can I try Qvinci?

Create an account today at www.qvinci.com . Our great support team will help you get connected and make sure you and your clients are getting the most out of your Qvinci account.

Ask about our Reseller & Referral programs!

sales@qvinci.com

512-637-7337

 

Tap into Success at Empowered Northwest May 7-8, 2015

GUEST POST FROM TSHEETS.COM:

For small businesses and accounting professionals, the sky’s the limit, because the cloud is quickly becoming the next new frontier to ramp up productivity and success. So join us in Portland, Oregon May 7-8 for a premier event designed to introduce you to CEOs, thought leaders in the industry plus QuickBooks-compatible, cloud-based technology solutions.

Called Empowered Northwest, this two-day conference is the premier QuickBooks user conference for the entire region. Sponsored by companies you trust—because they sponsor The QB Show too—including TSheets Time Tracking, Fundera and Avalara, this event is a don’t miss. Experience the power of illuminating keynotes from Matt Rissell, Sabrina Parsons, Mike Michalowicz and Mary Scott. Get hands-on education and marketing sessions. Test drive best-of-breed, cloud-based accounting and business solutions that seamlessly sync with QuickBooks. Network with people you’ll really want to know. Even earn up to 12 CPE credits.

It’s geared to get you on the right track, fast. After the general sessions with leading entrepreneurial authorities, you have three different tracks to choose from—the accounting track, the QuickBooks business track or the cloud track—to custom design your experience to match your pursuit of business happiness. Accountants can learn exactly what apps to recommend and implement, even invite their clients along too. Entrepreneurs will find out how they can leverage the cloud to reach goals and rise far above the competition.

It pays to sign up early—30% off, in fact. Early bird registration ends March 15, with discounted tickets only $69. After that, the price goes up to $99. So sign up now at www.empowerednw.com, and we’ll see you in Portland soon.

Please Welcome Fundera to the QBShow.com Family!!!

Welcome to the QB Show’s newest sponsor, Fundera! The most recent addition to Apps.com (check out their App Card here), we’re happy their joining the ranks of our amazing sponsors.

So, what IS Fundera? Simply put, its the easiest and quickest way to get a small business loan.

Right now, 82% of small businesses are getting their loan applications denied by the banks. The days of heading to your local bank to get a loan (or recommending your clients go there) is long gone. Why is this happening?

  1. Increased Regulation — Post-Recession, banks are having to carry less risk in their portfolios. Unfortunately, small businesses are inherently riskier than larger businesses.
  2. Smaller Loans — Often, small businesses aren’t seeking incredibly large loan amounts. However, considering the work that goes into underwriting, it costs banks just as much to make a small loan as it does a large loan. These small loan amounts aren’t profitable for banks, causing them to shut their doors to small businesses.

 

Luckily, an industry of new, online lenders have popped up to fill the void left by banks. But, finding a loan online can be overwhelming and time-consuming. Since the industry is so new, no one knows where to start. Not to mention, when you Google “small business loan,” every results looks identical.

That’s where Fundera comes in. They vetted the entire “alternative” lending industry and created a network of the best lenders out there (including other Apps.com members Fundbox and BlueVine). Then, with one, singular application, business owners can apply to the lenders they like (and qualify for), ensuring they get the lowest cost loan in the fastest amount of time.

It’s a huge time-saver for the business owner, as they can shop for their loan options in one place. Not to mention, only having to complete one application (and prepare one set of paperwork) to apply to multiple lenders saves them hours if not days. Their integration with QuickBooks even expedites the process further, as the application can be pre-filled with your QuickBooks data.

Due to the competitive nature of their marketplace, Fundera is also able to make a lowest rate guarantee. That’s right. Borrowers will see a lower cost loan by shopping through Fundera than going directly to a lender. On average, businesses save $4,000 by acquiring a loan through Fundera.

Throughout the whole process, businesses are matched with their very own “success rep” whose sole job is to help them find the best product for their unique business. The only people you interact with throughout the process are a part of the Fundera team. You don’t have to worry about dozens of lenders calling you, trying to sell their product.

Best of all, Fundera is a completely free service.

For accountants, bookkeepers and ProAdvisors, Fundera has an Advisor program. If a client you refer to Fundera successfully secures a loan, you will receive 1% of the total loan size. They even have an “Advisor Portal” that lets you complete applications on your client’s behalf. You can sign up for their Advisor Program here.

In their first year in business, Fundera helped 300+ small businesses secure 12 million in funding — and they’re just getting started. Named one of the hottest startups in NYC, we’re glad Fundera has joined the QB Show family and excited to learn more about how they’re helping small businesses.

Questions? Let them know @Fundera or by emailing advisor@fundera.com.

End to end: QuickBooks Online (QBO) + QuickBooks Payments & Invoice Portal with Woody Adams & Stacy Kildal

Woody and Stacy had some fun with QuickBooks Online & Payments this morning!