417 posts categorized "QuickBooks Tips and Training"

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!

_________________________________________________________________________________________________________


New Webinar - Advanced Inventory Topics in QuickBooks

If you've been looking for the "straight scoop" on how QuickBooks does (or doesn't) handle activities such as:

  • Groups/kits
  • Assemblies/bills of material
  • Unit of measure conversions
  • The advanced inventory module features of QuickBooks Enterprise Platinum, including:
    • Multi-warehouse/location tracking
    • Lot or serial tracking
    • Barcoding

then my Advanced Inventory Topics in QuickBooks webinar is built just for you.

Register Button

Hope to see you there!

_________________________________________________________________________________________________________


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.

_________________________________________________________________________________________________________

_________________________________________________________________________________________________________


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!

_________________________________________________________________________________________________________


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:

 

_________________________________________________________________________________________________________


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!

_________________________________________________________________________________________________________


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.

_________________________________________________________________________________________________________


QuickBooks Inventory Webinars on: Advanced Inventory and Assemblies/Bills of Material/WIP

Please join me for the following webinars to help you get a better handle on tracking
inventory in QuickBooks:

 

 

Please note that each of these webinars have special early-bird discounts that will
enable you to save on the registration.

Hope to see you there!

_________________________________________________________________________________________________________