101 posts categorized "QuickBooks Reports"

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.

 

_________________________________________________________________________________________________________


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!

_________________________________________________________________________________________________________


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!

_________________________________________________________________________________________________________


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

_________________________________________________________________________________________________________


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.

_________________________________________________________________________________________________________


Quick Tip for Reconciling Your Bank Account in QuickBooks

Reconciling bank accounts in QuickBooks can take some time.

It can take even more time if you accept credit cards, and your merchant service provider takes the credit card fees out of EACH transaction!

Spend less time on bank reconciliations with the following tip.

LET ME EXPLAIN...

Let's say that you ring up a sale for $100 today and the customer pays via credit card.

When this deposit shows up in your bank statement, does it show up for the full $100? Or does it show up for something like $97.54 because the processor has taken their fee out of it right then and there?

If it is the latter where they are taking out the fees for each transaction, stop what you are doing and call them right now.

Ask to have your merchant service account fees set up on the "gross fees" basis instead of the "net fees" basis.

Under the "gross fees" basis, in the example above, you would see the full $100 being deposited into your bank account (the full "gross amount" is deposited). Your merchant service provider would then just hit your bank account once per month for the total of all the credit card fees for the month, and NOT take them out on a transaction by transaction basis.

Naturally, the merchant service provider normally defaults to the "net fees" basis, since they get paid faster that way. All it usually takes is a phone call to get it switched around!

The big benefit to you? Your $100 deposit will now reconcile on the bank statement in a nano-second!!

 

_________________________________________________________________________________________________________


History of Items Purchased Report in QuickBooks

Many businesses that carry inventory need to run a purchase history of those items now and then for planning purposes.

If you are one of those businesses, QuickBooks delivers with the Purchases by Item Summary report.

Located by clicking Reports > Purchases > Purchases by Item Summary (there is a detail version too!), you'll unlock a report that looks like this sample (click the image for a larger view):

Purchase by Item Summary Report

Here you can easily pick the range of desired dates, and QuickBooks will then populate the report with the quantity of the item purchased and the total dollars spent on that item as well.

NOTE: This report works just as well for non-inventory parts too!


GETTING A MORE GRANULAR VIEW OF THE PURCHASE HISTORY

Here's a tip if you want to do a more detailed analysis of the purchase history of your items:

On the report above, look for the option at the top of the report that says "Show Columns" and change it to month. Here is how it would look once you do that:

Purchases by Item Summary by Month

In this view, you can see on a monthly basis exactly what is happening with the purchase history of each of your items!

Pair this with the ability to export this report to Excel, you have unlocked a simple yet powerful way to track the purchase history of your inventory and non-inventory items in QuickBooks!

RELATED TOPICS:

_________________________________________________________________________________________________________


Vertex SMB - A Sales and Use Tax Management Solution for QuickBooks

Do you find your business struggling to manage sales and use taxes?

Looking for a more automated sales and use tax solution that also integrates with QuickBooks?

If so, you may be interested in the Vertex SMB solution.

INSIDE THE VERTEX SMB (small and medium business) SALES AND USE TAX SOLUTION

Here are some of the features of their solution:

  • Calculations and returns in one one place - perform tax calculations and generate PDF ready returns all in one place
  • Use tax calculations - calculate and report use taxes
  • Exemption certificate management - store, update and manage your exemption certificates
  • Sales tax rate files - get the rate files you need for the specifics of your business
  • Works with QuickBooks!

PAY AS YOU GO

Vertex SMB is designed to be easy on the budget - you simply pay for what you use every month. No long term contracts involved - pay for the service monthly.

ABOUT VERTEX

Vertex SMB is the business division of Vertex Inc. dedicated to small and medium-sized businesses. Vertex calculates tax for over 10,000 taxing jurisdictions across the globe and tracks and maintains over 600,000 unique taxability rules across tax types.

LEARN MORE

See how the Vertex SMB sales and use tax solution that integrates with QuickBooks can benefit your business today!

_________________________________________________________________________________________________________