456 posts categorized "QuickBooks Software"

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!

_________________________________________________________________________________________________________


What's New in QuickBooks Enterprise 2017 - Part 2

Join me in taking a closer look at more features within QuickBooks Enterprise 2017, as well as some you may have missed in earlier versions:

Here is the link in case you missed the "What's New in QuickBooks Enterprise 2017 - Part 1" video

INTERESTED IN UPGRADING TO QUICKBOOKS ENTERPRISE 2017?

Be sure to review details on my web site, including a 20% lifetime discount on your QuickBooks Enterprise subscription, as well as other benefits too!

Help yourself to many other free resources and insights relating to QuickBooks Enterprise 2017.

_________________________________________________________________________________________________________

_________________________________________________________________________________________________________


Stop Inventory Balances from Going Negative with QuickBooks Enterprise

Have you been wishing that QuickBooks would add a feature that would stop your inventory on-hand balances from going negative?

Your wishes have been granted!

Learn more about how the Enterprise edition (2015 and newer!) stops this annoyance from occurring...

In case you didn't know it, by having inventory go negative in QuickBooks, it is known to cause all sorts of issues and concerns with the average cost of items getting totally whacked out as well. My friends over at the Intuitive Accountant have a great article that discusses the impact of negative on hand on QuickBooks average cost.

ADDTIONAL RESOURCES

_________________________________________________________________________________________________________


See What's New in QuickBooks Desktop Enterprise 2017 - Part 1

If you're interested in taking a quick peek at the new features and functionality that have been baked into the 2017 edition of QuickBooks Desktop Enterprise, the video below will get you started:

ADDITIONAL RESOURCES ON QUICKBOOKS ENTERPRISE:

_________________________________________________________________________________________________________


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...

 

_________________________________________________________________________________________________________


Automatically Create Purchase Orders in QuickBooks Enterprise

QuickBooks Enterprise provides the functionality to automatically create purchase orders to your vendors with just a couple mouse clicks.

My video will show you just how it works:

ADDITIONAL RESOURCES:

 

_________________________________________________________________________________________________________


Direct Store Delivery Software (DSD) - The LaceUp Solution

DIRECT STORE DELIVERY SOFTWARE

According to Wikipedia, Direct Store Delivery (DSD) is a business process that manufacturers use to both sell and distribute goods directly to point of sales (PoS) or point of consumption (PoC) including additional product and market related services such as merchandising, information gathering, or equipment service and bypassing any retailer or wholesaler logistics.

Within the DSD framework, small businesses find themselves needing to manage their truck inventories (multi-location tracking in the QuickBooks world) as well as track the sales and accounting that occur on those trucks on a daily basis.

I was recently introduced to the folks at LaceUp, a solution dedicated to the DSD business model, and wanted to share some insights about them with you as provided by Mickey Hernandez, the CEO of LaceUp...

LaceUp-Solutions-Logo

 

 

 

 

INTRODUCING LaceUp: Direct Store Delivery (DSD) Software & Route Accounting for QuickBooks

LaceUp Solutions is an affordable direct store delivery application for wholesale and distributors that ties into QuickBooks desktop versions (Pro, Premier and Enterprise), and QuickBooks Online.

With LaceUp you can automate your day to day deliveries and manage the inventory on your trucks. Never waste time again manually keying in data to QuickBooks, and eliminate expensive employee tasks that reduce productivity and create costly errors

Truck Inventory Tracking

On a daily basis the inventory levels on your trucks fluctuate. Inventory is sold, products get credited, and orders get returned. With LaceUp you can track each unit of product that goes on and off your truck to minimize theft and increase sales efficiency for each route. Truck inventory tracking offers many features to allow you to manage your route efficiently:

  • Inventory levels decrease when customers get invoiced
  • Inventory levels increase with voids and returns
  • Track credits from the customer all the way to the warehouse
  • Transfer inventory mid-day on to the truck or off the truck
  • Associate specific lot numbers to invoices and customers

Additional Features of LaceUp

  • Route Sales Interface

On each route there are opportunities to increase sales and minimize credits. LaceUp offers your route drivers a customizable invoice template based on previous sales history for each customer. This ensures that your driver always sells the right products and quantities while avoiding the sale of products that would otherwise become stale.

  • Order Entry

Before the first delivery is ever made, each distributor has a team of sales reps opening new accounts and capturing sales orders. With LaceUp, sales reps can use the sales interface to key in orders in seconds. From any Android or iOS device, sales reps can view real time pricing and inventory. Moreover, the company can set up special offers for sales reps to facilitate the sale of products during holidays or stagnant selling seasons.

  • Mobile Invoicing and Printing

Offers distribution companies of all sizes next generation technology on the iPhone and Android that enables your sales reps to create, print and send invoices to your customers on the go. Capture signatures at the point of delivery and use Bluetooth for mobile printing of proof of deliveries.

  • DEX EDI

LaceUp is the first DSD software that enables QuickBooks distributors to DEX with retailers. DEX is a method of EDI used by the direct store delivery industry to transmit invoices digitally into a retailer’s computer system. This enables the retailer’s receiver to accept an invoice without having to key in the invoice into their system, thus avoiding costly data entry and errors. Route drivers who use DEX EDI get in and out of stops an average of 30 minutes faster.

A free trial of LaceUp is available for a "try before you buy" approach to solving the route accounting and truck inventory management needs of your DSD business.

 

_________________________________________________________________________________________________________