60 posts categorized "Tools and Tips for Small Businesses"

Reconcile ANY Asset, Liability or Equity Account in QuickBooks

Here's a tip to simplify your accounting even more...

Take advantage of the fact that QuickBooks will allow you to reconcile ANY asset, liability or equity account balance!

Many businesses are already taking advantage of the QuickBooks reconciliation feature for their bank and credit card accounts (if you're not doing that, you should be!). But it can offer even more to you.

Here's how...

When you get into the reconciliation window, you can choose ANY balance sheet account from the drop down list that appears, as shown in the sample below:

Reconcile Any Account

Where could this come in handy?

Pretty much any account where you are tracking activity in and out of the course of a month, including:

  • Reconciling prepayments of inventory or other prepaid assets
  • Employee advances
  • Reconciling accruals and payments of payroll taxes
  • Reconciling partner distributions and payments

Once you've completed the process, if you go to look at the account register for the account you just finished, you'll note the familiar "check box" to indicate the transaction has been properly reconciled and the account is up to date:

Reconcile Check Box

That's all there is to it!

Note that this trick works in both the desktop and online versions of QuickBooks.

 

_________________________________________________________________________________________________________


Reduce Check Fraud in Your Business with Positive Pay - The Treasury Software Solution for QuickBooks

Were you aware that a staggering average of 1.2 million fraudulent checks enter the banking system every day and losses are growing 2.5% annually (source: American Bankers Association)?

If your business is still issuing paper checks, you may easily become part of those statistics.

And what a pain that would be - trying to work your way through unraveling the implications of a scammed check.

I have some great news for you!

There is an easy way to help prevent your business from becoming a victim of check fraud.

The solution is called Positive Pay.

POSITIVE PAY TO THE RESCUE

According to Wikipedia, "Positive pay is a service whereby the company electronically shares its check register of all written checks with the bank. The bank therefore will only pay checks listed in that register, with exactly the same specifications as listed in the register (amount, payee, serial number, etc.). This system dramatically reduces check fraud."

This article on Positive Pay from Provident Bank also offers some insights into the benefits of using Positive Pay, which may include:

  • A reduction of disbursements risk
  • Simplifying your accounts payable process
  • Improved control

POSITIVE PAY AND QUICKBOOKS

In order for this process to work, your bank needs to receive details about the checks you have written so they can compare it to the checks presented for them to clear.

Naturally, the details about the checks you have written could be manually created and uploaded to your bank.

However, this process should be automated to keep it fast and simple.

Even though millions of businesses use QuickBooks accounting software to issue their checks, there is no direct way to easily create a file of the checks you have written to upload to your bank. Unfortunately, there is no magic button within QuickBooks to tackle that task.

Enter the Treasury Software Positive Pay solution...

EASILY CREATE A POSITIVE PAY FILE FROM YOUR QUICKBOOKS DESKTOP OR QB ONLINE

The folks at Treasury Software have created a solution for QuickBooks users that allows them an easy point and click solution to creating a Positive Pay check file directly out of their QuickBooks company file.

Their solution works with both the desktop versions of QuickBooks (Pro, Premier and Enterprise) and the Online versions.

Here's a quick visual of how it works:

Positive Pay Solution

 

With the Treasury Software Positive Pay for QuickBooks solution, QuickBooks users enjoy all of the features and benefits of Bank Positive Pay, such as:

  • Easily create positive pay files in your bank's format
  • Quick setup with Bank Express Codes for your bank
  • Full audit trail
  • Exception reporting and research tools

VERY SPECIAL DISCOUNT CODE FOR MY READERS

The folks at Treasury Software have been kind enough to create a special discount code for my loyal readers that applies to all of their products (big thanks to Treasury Software!!)

To snag your 30% discount code on their Positive Pay for QuickBooks (or any other of their products), just type in the code BBL27 and you will get a 30% discount! It's that easy...

WHAT'S YOUR EXPERIENCE WITH POSITIVE PAY?

Have you been using positive pay in your business to reduce check fraud?

Care to share your experience with it so everyone can learn more about it?

Just drop your comments in the box below (or click the "view in browser" if reading this via e-mail) to pass along your comments and insights. Greatly appreciate them!

_________________________________________________________________________________________________________


Simplify Sales Rep Tracking, Reporting, and Remote Access with Crik-IT for QuickBooks

Do you find yourself constantly working to provide reports, details, and snippets of other information to the sales reps for your business?

Have you considered moving toward more of a "self-serve" approach and letting your sales reps access this information themselves without you being stuck in the middle?

If so, consider the Crik-IT sales rep/CRM portal for QuickBooks.

Their solution will provide sales reps (and customers too!) with access to current sales reports, dashboards, inventory, order and invoice information. Reps can also enter orders themselves as well if you want them to!

THE CRIK-IT PORTAL/CRM FOR SALES REPS

CrikIt Logo
Here are some of the reports that your reps would have at their fingertips:

  • Year over year sales comparisons for a 3 year period
  • Monthly sales comparisons for the past 3 years
  • Reports by SKU, customer, rep or product line
  • And more...

The Crik-IT Portal/CRM can also help automate and streamline the administration of your sales reps in the following ways:

  • Complete remote access - no need for them to be inside QuickBooks itself
  • Lead and opportunity tracking
  • Order entry
  • Inventory availability

Here is a sample dashboard view from Crik-IT:

Dashboard Sample

And here are samples of a few of the reports available for instant access:

Report Sample

 

FREE TRIAL FOR QUICKBOOKS DESKTOP OR QUICKBOOKS ONLINE

Crik-IT is compatible with both the desktop versions of QuickBooks (Pro, Premier and Enterprise) in addition to QuickBooks Online. You can grab your 30 day free trial today.

Take it for a test drive so you can get a deeper look at how it can solve common headaches when working with a team of sales reps.


PRICING FOR CRIK-IT

Crik-IT is offered in several different packages, which include:

  • Customer Service Package
  • Order Desk Package
  • Sales Force Package
  • Full Circle Package

For example, the Customer Service Package starts at $29/month for 1 user, and then an additional $15/month for additional users.

Features and functionality scale up as you move across the various package offerings. Just follow the Pricing link on this page for more details.

WHAT'S YOUR APPROACH TO SALES REP MANAGEMENT?

I'm curious - do you currently use CRIK-IT? Have any thoughts to share on it?

Using something else for managing your reps?

Please let me know how you're handling this aspect of your business - others will be interested as well!

_________________________________________________________________________________________________________


Spreadsheet Type Calculations within QuickBooks?

Have you ever needed to make additional calculations within a QuickBooks form, but found it limiting?

For example, if you have tried to:

  • Total shipping weights on an invoice
  • Total or subtotal columns on a purchase order, sales order, or invoice
  • Add line numbers to a packing slip or invoice
  • Calculate a running total on a bill of lading

or any other type of calculation beyond quantity x rate, you've likely found QuickBooks to be rather frustrating!

ENTER FORMCALC SST

  FormCalc SST Logo

The FormCalc SST add-on for QuickBooks can help you extend the functionality of QuickBooks to handle the above scenarios (and many more too!).

The SST stands for Superior Spreadsheet Technology, and what it means for you is that you can literally add spreadsheet like calculations to the following QuickBooks forms:

  • Invoices
  • Sales Orders
  • Quotes/Estimates
  • Purchase Orders
  • Credit Memos
  • Sales Receipts

HOW FORMCALC SST WORKS

Setting up calculations involves taking a "snapshot" of the QuickBooks form (Invoice, etc.) you want to work with, then entering spreadsheet formulas in it. From there, you will save the FormCalcSST template.

When ready, you then simply use a series of "hot keys" that will then call up the template you have created and put to work on a form within QuickBooks.

FormCalc SST can also enhance your QuickBooks by offering:

  • Text handling and calculations
  • Column totals and subtotals
  • Date and time math
  • The use of custom field, headers and footers in calculations
  • Results and text formatting
  • "Mini-spreadsheet" features

WORKS WITH PRO, PREMIER OR ENTERPRISE VERSIONS

Regardless of which desktop version of QuickBooks you have (Pro, Premier or Enterprise), FormCalc SST can plug right in and get to work so you can get more done in less time every day.

A 30 day free trial of the software is available for you to try before you buy.

If you don't need as much horsepower as FormCalc SST offers, you can easily choose the core FormCalc product,

FormCalc Logo

This is the original application in the FormCalc series.

Are you already using FormCalc SST or FormCalc in your business? Would love to hear from you and learn more about what things it is handling for you!

_________________________________________________________________________________________________________


POOF! There went $100,000....

It was mid-afternoon, and the controller did a quick check of his e-mail to see if anything came in.

An e-mail from the CEO had arrived, so he opened it.

The e-mail contained instructions to send a wire transfer of $100,000 to cover a deposit for a deal the CEO was working on.

Knowing that the CEO was regularly involved in various transactions, the controller picked up the phone and called their bank to get the wire transfer underway to avoid any delays with the deal in progress.

The process with the bank was pretty simple, as wire transfers were sent regularly.

A couple hours later, the controller got a call from the CEO about another matter, and the controller confirmed with the CEO that he had sent the wire transfer he requested.

"What wire transfer?" said the CEO

"The wire transfer you e-mailed me about earlier this afternoon", said the controller

"I didn't send you any e-mails asking for a wire transfer to be made", said the CEO.

Silence followed.

Hauntingly dead silence.

The controller just realized he had been scammed by a well crafted and well executed e-mail.

Even worse, the funds had already left the bank.

Never to be seen again.

To repeat - never. to. be. seen. again.

Poof. There went $100,000!

Does this sound like some fiction to you?

Sadly, it is true. Very, very true!

View some additional real-life social engineering losses here.

BUILDING THE CASE FOR CYBER INSURANCE

The scenario above falls into what is being called "social engineering losses" by those in the insurance world.

In fact...

“We have seen social engineering losses for a number of our clients ranging from small business to publicly traded companies.   This is becoming common and businesses need to be sure to validate each transaction carefully.   Insurance is now available for this situation, however it is not automatically included on most policies and must be added by endorsement. Check with your insurance advisor to see if you have this coverage”  Lou Antonelli, Vice President, Practice Leader Risk Consulting, Oswald Companies

Whatever it is being called, it could mean a substantial loss to your business, just as the $100,000 was to the business above. That money is long gone, and isn't coming back any time soon.

Social engineering losses are just one form of cyber insurance coverage, as are system damage, system business interruption, cyber crime, multimedia liability and a host of other potential issues.

As businesses get ever more interconnected, it's essential to talk with your insurance agent to determine if this type of coverage is a good idea for your business. I've had that conversation with my agent recently, and I hope you take the time to do so as well...

ADDITIONAL REFERENCES ON CYBER INSURANCE

_________________________________________________________________________________________________________


Using the QuickBooks Cash Flow Projection Tool

Little known, but quite helpful, the desktop versions of QuickBooks (Pro, Premier and Enterprise) have a built-in cash flow projection tool.

Learn how to project your business cash flow in QuickBooks for a 6 week period with the video tutorial below:

WHAT ARE YOU USING FOR CASH FLOW PROJECTIONS?

If you're not using the QuickBooks cash flow projector, I'm curious as to what app or program you may be using to see how the upcoming cash flow looks for your business. Are you using Excel? PlanGuru? Something else?

INTERESTED IN TAKING A CLOSER LOOK AT YOUR BUSINESS FINANCES?

If so, you may be interested in learning more about my "Beyond QuickBooks: Making Sense of Your Numbers" program. Designed to help you feel a lot more confident and capable when it comes to managing the profitability of your business!

_________________________________________________________________________________________________________


The Jobber App for Your Mobile Service Business

If you visit your customers to provide your services, need to handle scheduling, keep track of customer information, invoicing, billing, and more, then Jobber is for you.

Jobber was designed and built specifically for mobile service companies - and it was built exceptionally well!

Jobber_flatgradients_72dpi_RGB_transparent

TAKING A CLOSER LOOK AT JOBBER FEATURES

Let's take a peek under the hood at the Jobber application, and review the features found there that can help simplify and streamline your service business...

Scheduling - Whiteboards and Google Calendar can only take you so far. Speed up your scheduling with Jobber’s map view by assigning jobs to employees using the smartest route. Our job scheduling wizard can easily create complicated recurring job schedules. Jobber's drag-and-drop calendar covers all scheduling scenarios such as month, week, and daily views. Includes:

  • Job scheduling wizard
  • Ability to view map routing
  • Drag and drop calendar
  • Route optimization and website integration are available as add-ons

CRM - All of your client’s past jobs, quotes, invoices, and payments are easily searchable. Access the information anywhere with iOS and Android Apps. Capabilities include:

  • E-mail client reminders
  • Client history and search
  • Quoting
  • Custom fields and tags
  • Texting client reminders (additional fee applies)

EVEN MORE JOBBER FEATURES...

Team Management - Assign tasks and jobs to your employees and keep up-to-date on their progress with the Jobber Field app. Employees can track their time, add notes and attachments to visits, and Jobber can automatically create GPS waypoints throughout their day Capabilities include:

  • Tasks and time-tracking
  • GPS tracking
  • Team assignments
  • Text message of arrival notifications (additional fee applies)

Easy invoicing and payments

  • Sync with QuickBooks Online or Xero (additional fees apply for accounting sync)
  • Batch invoicing
  • Expense tracking and E-Payments from customers (additional fees apply)

 

GET YOUR FREE TRIAL AND A $75 CREDIT

Jobber is rated at 4.5 starts out of 5 in the Intuit App Center - feel free to explore what others have said about it and how it has helped their business.

Jobber offers a completely free trial of their software, and no credit card is required. Use my link to sign up for your free trial, and you'll also receive a $75 credit toward your paid service.

Are you currently using Jobber for your service business? Feel free to add your comments to the conversation in the box below!

_________________________________________________________________________________________________________


A Simple Way to Sell Products or Services on Your Existing Web Site with Shopify

Trying to find a new revenue stream for your business?

Looking to sell products or services from your web site?

Does the thought of "adding e-commerce functionality" to your web site give you a headache and keep you from moving forward?

Shopify-Money-728x90

CONSIDER THE SHOPIFY BUY BUTTON

Here's the good news...

Selling products or services on your existing web site doesn't require an IT specialist or an expensive web designer.

In fact, all you need is a Shopify Buy Button.

HOW THE BUY BUTTON WORKS WITH SHOPIFY

As easy as 1-2-3...

Step 1 - Decide which products or services you want to sell on your web site

Step 2 - Grab the "embed code" that Shopify automatically creates for you to present them exactly as you want. Customize the colors to match your existing site

Step 3 - Copy and paste the code into your web site

This adds a mobile friendly and secure shopping experience to your site. All the power of Shopify in a single button.

BEYOND THE BUY BUTTON...

Adding the Buy button opens the door to a complete suite of tools that Shopify also offers their customers, including:

  • Integration with QuickBooks desktop (via Webgility) or directly into QuickBooks Online
  • Easy order tracking - notifications of orders received via e-mail or mobile
  • Shipping integration with all major carriers if desired
  • Analytics tools - assess sales and other metrics via the handy dashboard
  • Fully mobile - you can easily run the business from your phone or tablet

THE BUY BUTTON WON'T BREAK THE BANK

Adding the Shopify Buy Button to your existing web site runs just $9 per month. Other Shopify plans are also available to allow you to build your own online store and add even more features if desired - those start at $29 per month.

Shopify offers a free 14 day trial, with no credit card required so you can see for yourself how the Buy button and other features might work for you.

ADDITIONAL RESOURCES

_________________________________________________________________________________________________________


Tired of the Hassle in Using the Accountants' Copy Feature of QuickBooks?

This post was shared by Chris Wise from CoralTree, the makers of Qbox...thanks Chris!

QBox Logo

 

 

 


Trying to find a better way of getting QuickBooks information to your accountant (or if you're an accountant, to get information from your client)?

Many accountants and small businesses become exceptionally frustrated when trying to share QuickBooks files using the Accountants Copy.  To avoid the frustration related to the reduced functions of this type of file, you can use a resource like Qbox.  Qbox is one of the fastest growing QuickBooks desktop file sharing/collaboration resources available due to its security, simplicity, affordability, and high level of customer support. 

QBox Flowchart

If you are looking for a way to share a QuickBooks desktop file with a client or shared user in a remote location, Qbox provides an effective solution.  Unlike other traditional file sharing options, Qbox has unique controls that prevent the creation of conflicted copies and file corruption.

Accountants and small businesses appreciate that each Qbox user has their own local copy of the QuickBooks file and experience the performance of their local environment when entering transactions.

As an accountant or bookkeeper, you can access all of your clients from one simplified access point called the Qbox Explorer.  You work on your client’s files at any time regardless of whether or not your client’s computer is turned on. 

Screen shot of the Qbox Explorer:

QBox Console

Using Qbox, your files are always backed up in the cloud and available to download should anything happen to a user’s computer.  Additionally, Qbox keeps 20 copies (versions) of files in the cloud at all times so in the event of a corrupted file, a user can “roll back” to their preferred instance of the file. 

If you are frustrated with the limited capabilities of an Accountants Copy, using Qbox, you always have access to the working QuickBooks file. All of the Desktop functions are available to a Qbox user and you can print and/or back up locally if you so choose. 

Click here to learn more about Qbox and start your free 30-day trial today...

 

_________________________________________________________________________________________________________


Procurify: Online Purchasing Management for QuickBooks

Has your business outgrown the purchasing module found within QuickBooks desktop software?

Looking for ways to streamline the purchasing process?

Need to add an approval process to your purchasing management? (not found in QuickBooks!)

Have people in different locations and all they need is access to purchasing (and not the entire QuickBooks package)?

Procurify_Logo_V_Color

 

 

 

 

 

INTRODUCING PROCURIFY

Procurify is an add-on application to the desktop versions of QuickBooks (Pro, Premier and Enterprise). By "add-on", I mean it is a separate piece of software that connects to QuickBooks and syncs information between the two programs.

It can bring a lot of functionality to your business that is not found within the basic purchase order module of QuickBooks.

Here is the suggested Procurify workflow...

  1. Request - electronically submit new purchase requests using your web browser or mobile device (notice - this doesn't have any mention of the staff person needing access to QuickBooks?)

  2. Approve - create automated approval routing based on your business needs. Establish direct lines of communication between the right people.

  3. Create the PO - Procurify automatically tracks, manages and organizes your purchase orders in one place. Instantly deliver approved requests for PO creation.

  4. Receive the items - intuitive and easy to understand interface lets you accurately document received items through your web browser or mobile device. 

  5. Set up to pay your vendor - enable complete transparency throughout your purchase order workflow. Keep on top of payments and eliminate duplicate or unnecessary spending.


EMPOWERING YOUR STAFF

Procurify helps simplify operations across all the functional areas of your business:

  • Buyers - funnel all of your purchase requests from all locations into a single, easily managed bucket. We facilitate the internal back-and-forth communication, allowing requesters to check the status of their orders at any time. Improve supplier relationships and standardize the goods you buy.

  • Operations - get through purchase approvals faster. Reduce the amount of bottlenecks and improve efficiency for your operations. Define and structure each role within your organization’s purchasing process with complete clarity.

  • Finance - establish and easily ensure enforcement of controls and policies (IE. use purchase orders, ensure approvals, three way matches), while not increasing your headcount. Empower people to stay accountable to their budget, by giving them real time information instead of monthly reports. (Visibility into spending in real time)

  • IT - Gain full adoption organization wide by implementing tools which are easy to learn and fun to use. Procurify worries about the infrastructure and security and reduces the load on your team and it integrates with select tools, and seamlessly passes data between them.

ADDITIONAL RESOURCES

Be sure to tap into all of these additional resources that are available to learn more about Procurify and how it can benefit your business or organization.

NEED HELP TYING IT ALL TOGETHER?

My consulting practice specializes in helping businesses retain their investment in QuickBooks as their core accounting package, while extending the features and functionality through various add-on packages. Tap into my 30+ years of accounting, finance, inventory, and QuickBooks experience.

If you would like to discuss Procurify or other QuickBooks add-ons in more detail, please contact me.

_________________________________________________________________________________________________________