Avalara + You = Hawaii? It could happen!

Guest post from Avalara.com’s Jamee Nunnelee:

Taking less taxing, more relaxing to a whole new level.

 

Congratulations to Marilyn Sudbeck, CPA and President of Nimbus Consulting, for winning a $5000 trip

to Hawaii by participating in Avalara’s 2014 Win a Trip to Hawaii contest. See Marilyn’s priceless

reaction here.

 

The contest was created to reward Avalara Partners who are helping their clients and prospects reduce

compliance risk and outsource the most complex and time-consuming sales tax management tasks to

Avalara. “What a great, unexpected surprise to win this trip – all because I helped my clients get their

sales tax compliance house in order!” said Sudbeck.

 

To enter Avalara’s NEW 2015 Hawaii contest:

1. Fill out the contest entry form.

2. Download Avalara’s new partner prospecting guide to help uncover customers that might be a good

fit for Avalara’s automated sales tax compliance solutions.

3. Start referring clients and prospects to Avalara. Each new referred lead counts as a separate entry

into the contest.

Visit: http://www.info.avalara.com/hawaiicontestentry

 

BONUS: If you help schedule the lead you referred for a demo with Avalara by June 30, 2015, we’ll send

you a margarita machine (limit one margarita machine per person). Email PPM@avalara.com to claim

your margarita machine by providing proof of assistance in scheduling the demo.

Learn how to become an Avalara Partner here.

Have You Signed Up for the Fundera Advisor Program?

GUEST POST by: Meredith Wood

Have you signed up for the Fundera Advisor Program? If not, you should do so. Immediately. All the cool kids are doing it. (Well, assuming you think Stacy and Dawn are the cool kids…but since you’re reading this, how could you not?!*)

Let’s face the facts. The number one reason small businesses change accountants is because the accountant wasn’t providing proactive advice.

Given how busy we all are, it is often way too easy to get caught up in what you have to do, and often too hard to find the time to take a step back and think big picture. But your clients want you to do just that. Instead of having them tell you what they need, you should start telling them what they need (and how you can help them with it).

The Fundera Advisor Program is here to help you do just that, and easily transition into the role of a proactive advisor.

The program is free to join. Ready to get started? You can sign up here.

Have questions before you start? Here are some program FAQs:

  1. Who is Fundera? Fundera is the easiest way to find and secure a small business loan. With one application, business owners can apply to multiple lenders, ensuring they get the lowest cost loan in the fastest amount of time.
  2. How much does Fundera cost? Fundera is free for both advisors and small businesses.
  3. How does the Advisor program work? After signing up, you will gain access to your Advisor portal, which allows you to work with clients in two different ways. The first is hands-off. You have a unique referral link you can send to clients, but you’re involvement isn’t necessary from there. The second is hands-on. Within the portal, you are able to start and complete applications on your clients behalf. They will only need to come in at the end to authorize a credit check. This allows you to add loan preparation services to your business, helping you grow your business and add revenues to your practice.
  4. Is there commission? Yes. Whenever one of your client referrals is successfully funded, you will get half of our revenue from the loan, which is usually equivalent to 1% of the loan amount. A $100,000 loan? That means $1,000 for you.
  5. What if I don’t want commission? If you do not want to receive commission for referring Fundera, we can pass it on to your customers. So, in the above example, they would receive a check for $1,000 to apply to their loan payment!
  6. How do I sign up? We thought you’d never ask. It’s easy, just head to fundera.com/advisors and click “Sign Up as An Advisor Now.”

Have questions? Give us a call at 1-800-Fundera or email advisor@fundera.com

*Editor’s Note: Neither Dawn nor Stacy coerced anyone from Fundera.com to say this. That being said, both of them happen to think everyone over at Fundera.com is pretty freaking cool too. 

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.