This is the Blog of Hector Garcia, QuickBooks ProAdvisor and Trainer in South Florida.  Content topics found here will be mostly QuickBooks functions, tips and tricks on how to learn QuickBooks and use it better, accounting related material, and Tax tips.
You may contact Hector at: if you have any other ideas or comments on postings to this blog.


Hector GarciaMore Posts Follow Me:

Posted in Blog Postings & Tips | Leave a comment

Transaction Pro Importer 6.0 for QuickBooks Desktop Data Dictionary & Sample Importing Templates

Transaction Pro Importer is one of my favorite programs to import excel/csv data into Quickbooks Desktop, I use this data table to know which fields I can import. Data Dictionary Notes:  If option, let QuickBooks auto assign transaction number is not selected  For internal TPI processing only  Used to determine which account that the discount […]

Posted in Blog Postings & Tips | Leave a comment

Tips for Creating Engaging videos (From Camtasia)

This is an excerpt from Techsmith’s (makers of Camtasia Video Editing Software) guide, I really like it and agree with most of these, so First, Be Prepared Know your audience. Will they be familiar with the terminology and concepts presented in the video? Do you need to make a separate introductory video? Are you motivating, […]

Posted in Blog Postings & Tips | Leave a comment

Bain & Co’s 30 Elements of Customer Value

I loved this the minute I stumbled upon it: is called “30 Elements of Value”, published by Bain & Co in October of 2016, here is the original website: So here is the graphic of the 30 elements from their website: Each elements is defined by them as: SELF-TRANSCENDENCE Definition: Helping other people or […]

Posted in Blog Postings & Tips | Leave a comment

Customizing QuickBooks Desktop Reports – For Power Users

This is a webinar we did for about “How to create custom reports in QuickBooks Desktop” for experienced users: Download the SLIDES/HANDOUT   These are the links we referred to on the video: Intuit Article on Source vs. Target Intuit Article on Customizing Reports in QuickBooks Desktop Hector’s Custom Reporting Field/Filter Matrix “Cheat Sheet” Other Custom […]

Posted in Blog Postings & Tips | Leave a comment

QuickBooks Online vs. QuickBooks Enterprise – Video & Resources

I did this presentation today via webinar to compare the two platforms (Online vs. Desktop):   I made reference to the following links: QuickBooks Online Test Drive with Sample File QuickBooks Online Free 30-day Trial (no credit card) plus 35% permanent discount QuickBooks Enterprise Hosted Test Drive QuickBooks Desktop: Pro/Premier/Accountant/Enterprise download 30 day trial  QuickBooks […]

Posted in Blog Postings & Tips | Leave a comment

IRS Late Filling and Late Payment explained

This is a complete video that explains how all penalties work for individuals and corporations:   Tax filing deadlines Forms 1040 (Individuals) and 1120 (Corporations) must file and pay entire tax liability by April 15th for calendar year tax payers.  Alternative for fiscal year tax payers, 105 days after closing of fiscal tax year. Forms […]

Posted in Blog Postings & Tips | Leave a comment

Tools to Import Data from Excel into QuickBooks

Last Update: 03/14/2017 by Hector Garcia, CPA First, the top 3rd party tool I use everyday to import BANK transactions into QuickBooks when I have them in Excel or CSV is called: CSV2QBO by MoneyThumb Price: $59 for CSV2QBO Price $149 for PDF2QBO Price $249 for 2bo Convert Pro (which includes PDF2QBO, CSV2QBO, QIF2QBO, and […]

Posted in Advanced Excel, Advanced QuickBooks, Blog Postings & Tips, Excel to QuickBooks, Import Excel Data into QuickBooks, QuickBooks Training | 19 Comments

2016 Tax Rates

2016 Income Tax Brackets The Federal income tax has 7 brackets: 10%, 15%, 25%, 28%, 33%, 35%, and 39.6%. The amount of tax you owe depends on your income level and filing status. Single Taxable Income Tax Rate $0—$9,275 10% $9,276—$37,650 $927.50 plus 15% of the amount over $9,275 $37,651—$91,150 $5,183.75 plus 25% of the […]

Posted in Blog Postings & Tips | Leave a comment

QBES – QB Desktop Pricing with Hosting

UPDATED 04/01/2017 Users Silver Annual Gold Annual Platinum Annual Accountant Annual FSP 1 $1,000 $1,300 $1,600 $1,349 $1,299 2 $1,600 $1,900 $2,200 $1,774 $1,599 3 $2,000 $2,300 $2,600 $2,299 $1,799 4 $2,400 $2,700 $3,000 $2,824 $1,999 5 $2,800 $3,100 $3,400 $3,349 $2,199 6 $3,100 $3,400 $3,700 $4,749 $3,299 7 $3,400 $3,700 $4,000 $5,174 $3,499 8 […]

Posted in Blog Postings & Tips | Leave a comment


This QuickBooks Blog is updated every other day!

For More Information

Call us to 954-633-2718 or email: