98 posts categorized "Customers, Jobs and Projects"

What is a Sales Receipt in QuickBooks and How Can It Help Me?

Ever notice the little icon on the QuickBooks desktop road map that says Create Sales Receipts and wonder what it's all about?

Sales Receipt Home Screen

Here's the scoop...

A sales receipt is designed to post the sale of your product/service AND the payment for it all in the same transaction.

In the traditional invoice process (where you sell now and (hopefully) get paid later), there are three steps:

  1. Create the invoice
  2. Post the customer payment when received to credit the open invoice(s)
  3. Deposit the money in the bank

With the QuickBooks sales receipt process, if you're getting paid at the same time you deliver, you've now just cut the process down to two steps:

  1. Create the sales receipt
  2. Deposit the money in the bank

This results in 33% less work for you - how cool is that?

In fact, it is so cool, a client to whom I showed the sales receipt functionality exclaimed - "this is freakin' cool and will be an amazing game changer for our business!"

Love to hear things like that!

On the sales receipt screen, you simply plug in the payment details right there too as shown in the screen shot below: 

Sales Receipt Header Shot

 

Create the sales receipt, save it, and you're on your way to getting more done in less time.

Please share your experiences with QuickBooks sales receipts with us! Look forward to hearing how they work/don't work for your business...

 

_________________________________________________________________________________________________________


Eliminate wire transfer fees and simplify global payments with Veem

While attending the Accountex accounting show in Boston a few weeks ago, I spied a session on the agenda that was focused on simplifying wire transfers and global payments.

This topic is quite relevant for my consulting practice and likely for many of my clients too, so I made sure to catch the session to see what it was all about.

The folks from Veem did not disappoint...

Veemlogodark

DISRUPTING THE INTERNATIONAL PAYMENTS MODEL

The presentation by the Veem team was centered on this simple premise - "rethinking wire transfers and making the process easy and affordable".

As anyone involved in business to business wire transfers knows, the existing process is certainly not easy, nor affordable. And, it is not even close to being transparent.

Take a look at how the Veem approach to international payments works - a lot simpler, and far less hands touching things (click to enlarge):

Veem Diagram

As you can see, their process is eliminating the middleman from the international payment process. A wonderful idea!

Veem is currently positioned to send business to business funds to over 60 different countries (and expanding that list regularly) with no wire transfer fees. In addition, you can also receive payments via the Veem platform.

DID YOU SAY NO WIRE TRANSFER FEES?

Yes, you read that correctly.

The Veem platform provides you the capability to send payments at no charge.

Veem gets paid by earning a small percentage on the foreign exchange rates that are involved in the transaction. I'll let them explain it to you via this example (click to enlarge the view):

Veem Payment Example

BACKED BY SOPHISTICATED INVESTORS + 40,000 CUSTOMERS STRONG

The Veem platform is backed by a number of prominent inventors from around the globe, including:

  • Silicon Valley Bank
  • Fenbushi Capital
  • SBI Holdings
  • Digital Currency Group
  • and others...

Veem indicates that they are currently servicing over 40,000 customers - many of them small and mid-size businesses like yours.

In addition, according to their web site, Veem was founded by a world class team of industry veterans with over 100 years of combined experience in payments, payment processing and banking IT infrastructure management, who aim to change the financial payment system through innovation.

Read more about Veem via TechCrunch and Forbes.


FAQ AND RESOURCES

Veem has set up comprehensive pages of FAQ and helpful resources to help you better understand how their service works as well as the reasons why you should consider moving your international payments to them, and ditching your bank ASAP.

EXTRA BONUS...

Veem also offers connectivity to the Xero and QuickBooks Online accounting platforms (sorry, it does not connect to the QuickBooks Desktop platform as far as I know).

SIGN UP IS FREE

Veem has provided me a special signup link to share with you to get you right into the flow of using their service. There are no signup fees of any type to use the Veem service!

CHEERS TO THEIR SUCCESS...

If there ever was something that needed disruption, it is the wire transfer process. I think back to my CFO days 20+ years ago, and all the hassles I had with that process. You never knew much about what was going on, other than that I was getting nicked by fees all along the way.

All I know is that if Veem existed back then, I'd have signed up in a flash!

I wish the Veem team great success as they tackle this challenge...

 

Are you using Veem today? I welcome your feedback on how their service has worked out for your business...

 

_________________________________________________________________________________________________________


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!

_________________________________________________________________________________________________________


Why Is My Customer Showing Overdue? I Set Up the Right Terms in QuickBooks

Let's say that you recently negotiated a sale (congratulations!), and your customer snagged some extended payment terms with you as part of the deal.

So, instead of paying you in your normal net 30 day terms, they are going to pay you with net 45 day terms (hopefully your profit margin covers this extra financing term!)

You go to create the invoice in QuickBooks, and quickly see there is no "net 45" day term in the list. So, you click the Add New option, and create the new terms that look like this:

Net 45 Day Terms

and blast through the OK button to get this invoice out the door.

All seems to be good at this point, right?

THE AGING REPORT TELLS YOU SOMETHING DIFFERENT

Next week, you do a quick rundown of your accounts receivable aging report, and you see the invoice to this customer showing as overdue. Say what?

There is no way it is overdue at this point!

Well, QuickBooks thinks something different about it than you do.

HOW TO SET UP THE PAYMENT TERMS PROPERLY

QuickBooks would indeed show you the correct aging of this invoice - if you had done one additional thing when you set up the terms above.

And here is the thing:

Net 45 Days with Days

In the original box above, the "net due in" was not changed from 0 to 45 days. So, QuickBooks would see this invoice overdue on the very first day you sent it, even though the terms "net 45" appeared on the invoice.

In the updated box below, the "net due in" is correctly set up to match the applicable terms.

Once you get in and reset the definition of the payment terms (quick shortcut to access them - click Lists > Customer and Vendor Profile Lists > Terms List). QuickBooks will then properly age the invoice on your reports!

_________________________________________________________________________________________________________


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

_________________________________________________________________________________________________________


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.

 

_________________________________________________________________________________________________________


Pending Credit Memos for Returned Materials (RMA) in QuickBooks

Since QuickBooks doesn't have any type of "returns module" to handle customer returns or RMAs (returned material authorizations), here is a way your business could track those pesky returns...

CONSIDER THE PENDING CREDIT MEMO

Let's say you get a call today from a customer that needs to return a defective product, but you don't want to issue the credit to them until the product is received and cleared for refund.

You'd click on Customers > Create Credit Memos/Refunds to open up the Credit Memo form. Complete the form as needed to reflect the customer, item(s) being returned, etc.

BEFORE you save this credit memo, click Edit > Mark Credit Memo as Pending, and you'll see something like this (note the Pending stamp that has been added):

Pending Credit Memo

Once this credit memo has been saved, it becomes a tracking document that sits open while you await the arrival of the returned products.

Since it has been tagged with the "Pending" status, this transaction does NOT post to the customer account or the ledger in QuickBooks (so that is why it also says "non-posting" in the example above.

Bonus - you could even send this document to your customer as their "authorization" to return the products!

VIEWING A PENDING CREDIT MEMO REPORT FOR TRACKING RETURNS

Now that you have the pending credit out there, you may want to see a report of all open/pending credits that have been issued.

Here's how to get one - click Reports > Sales > Pending Sales. You will see something like this:

Pending Sales Report

Now you can quickly and easily see all open/pending credits. Remember, you can hover over any listing in this report, and you can easily double-click directly on that listing to take you directly into the actual credit memo.

ONCE THE PRODUCTS ARE RECEIVED

After you have received the product from the customer and cleared it for credit, simply return to that particular pending credit memo, click Edit > Mark Credit Memo as Final.

This step will remove the pending stamp as shown above, and once you save it, there will be a live credit memo that has posted to the customers account and QuickBooks ledger!

HOW ARE YOU TRACKING RETURNS TODAY?

I'd love to know how your business is handling customer returns. Please drop me a line and let me know!

_________________________________________________________________________________________________________


Online Order Management System and Customer Portal for QuickBooks

Does your business focus on the Business-to-Business (B2B) marketplace?

Want to spend less time on data entry and related non-value added tasks and are looking for one or more of these solutions?

  • An easy way for your customers to enter their own orders, check order status and inventory levels?
  • A solution for your sales reps so that they can enter their own orders so you don't have to?
  • A link between your order system and your warehouse with full shipping integration?

AND have the ability to have all the above automatically sync with QuickBooks desktop software?

If so, you should take a closer look at Now Commerce.

 NowCommerce Logot

CUSTOMER PORTAL

The Now Commerce customer portal feature brings the following possibilities to life for your business and allows your customers to:

  • View real-time pricing and inventory levels
  • Check shipping status
  • View pending orders
  • View account history

This is all done with customized order forms that can be tailored to the specific needs of each customer. These order forms can range from super simple to complicated matrix pricing.

SALES REP PORTAL

The Now Commerce sales rep portal brings many time-saving features into the way sales reps take care of your customers, including:

  • View real-time pricing and inventory levels
  • Check shipping status
  • View pending orders
  • View account history

As well as:

  • Monitor customer activity
  • Set customizable alerts
  • Manage pricing and discounts
  • Only see their own accounts, and not those of other reps

NOW COMMERCE FULFILLMENT PLATFORM

This module provides you the ability to:

  • Share shipping information with your sales reps and customers
  • Electronically transmit shippers from QuickBooks to your third party warehouse
  • Automatically populate QuickBooks with critical shipping data

CHOOSE JUST WHAT YOU NEED

The Now Commerce products are set up in such a way that you can choose just the module(s) you want - if you only want the customer portal, that's all you'd pay for. If you want all three, they can do that as well.

Now Commerce offers a free trial so you can "kick the tires" before making any commitments. In addition, you can watch their video series to get a quick overview of just how these modules work, and the potential savings they can bring your business. You can also take a look at the wide variety of products they have helped their customers sell.

NEED HELP SORTING IT ALL OUT?

B2B businesses are at the core of my consulting practice, especially those in manufacturing and distribution. Feel free to contact me for more information on the Now Commerce set of tools as well as other QuickBooks and inventory concerns you may have.

_________________________________________________________________________________________________________