YouTube Videos

Purchase my shortcuts menu for $25: https://hectorgarcia.com/shortcuts Table of Contents: 00:01:50 Collapse Left Navigation Bar 00:02:57 The Gear Menu 00:03:43 Search Box and Advanced Search 00:12:20 +New Transactions Button (and Bookmarking New Transactions) 00:14:15 New Tab vs New Window in Google Chrome 00:16:30 Google Chrome Users to have multiple QuickBooks Online companies open 00:20:44 Creating a Custom Bookmarks Menu in Google Chrome 00:22:12 Zoom in and out (change font size) in Google Chrome 00:23:13 Using Esc key to close windows 00:23:59 Using Tab, Shift-Tab, and Enter to navigate transactions 00:27:03 Using keyboard shortcuts when entering manual data into the Register 00:30:54 Shortcuts for Entering Dates 00:33:05 All CTRL/ALT Keyboard Shortcuts for QuickBooks Online 00:36:33 Hector’s Ultimate QBO Bookmarks/Shortcuts - save hours of work! Call our office 954-414-1524 to setup a private training/consultation about QuickBooks, Excel, Accounting/Bookkeeping, Taxes, and/or General Business Consulting (rates vary fro $250 to $525) for first consultation depending on length and consultant required. E-mail Hector your questions hector@garciacpa.com To setup a 30-day free trial of QuickBooks Online and then a 50% http://www.quickbooksoffer.com/?cid=irp-4337#pricing

Become a QuickBooks ProAdvisor: http://ProAdvisor.Intuit.com QuickBooks Certifications: https://youtu.be/3QzXKSV-SXA Chart comparing features across all versions of QuickBooks: https://docs.google.com/spreadsheets/d/1qH3PTdaYB4eIdfYDeVjzJ3iAalOt5dCV_5QUAqQhIZ8/ What is an “Outsourced Bookkeeping Service”?: https://youtu.be/F0sPL84-khA How professional service providers create value: https://youtu.be/lE0IlpYtCkY How to learn bookkeeping using QuickBooks Online with Seth David: https://youtu.be/HwxSFTbpq10 In the real world, debits do not equal credits: https://youtu.be/TU3tBjPmUk4 Starting a bookkeeping business? Watch this: https://youtu.be/esNvp-RDKPU My personally story and journey to becoming an effective accounting consultant: https://youtu.be/4uj8DSSs7kQ Resources to getting started in the Accounting and Bookkeeping profession: https://youtu.be/v1CNQPtDKsU How to value price your accounting/Advisory Service: https://youtu.be/KiJz-veiCFc My email: hector@garciacpa.com

Except from my Advanced Webinars series, to sign up for the most advanced/premium content about QuickBooks out there, go to: https://hectorgarcia.com/advanced/ Call our office 954-414-1524 to setup a private training/consultation about QuickBooks, Excel, Accounting/Bookkeeping, Taxes, and/or General Business Consulting (rates vary fro $250 to $525) for first consultation depending on length and consultant required. E-mail Hector your questions hector@garciacpa.com To setup a 30-day free trial of QuickBooks Online and then a 50% http://www.quickbooksoffer.com/?cid=irp-4337#pricing

Hector's Bookmark Shortcuts: https://www.youtube.com/watch?v=pGB7bAr0Kws Access QuickBooks Online's Sample Company (Test Drive): https://quickbooks.intuit.com/learn-support/en-us/use-products-or-services/test-drive-quickbooks-online/00/186455 Call our office 954-414-1524 to setup a private training/consultation about QuickBooks, Excel, Accounting/Bookkeeping, Taxes, and/or General Business Consulting (rates vary fro $275 to $525) for first consultation depending on length and consultant required. E-mail Hector your questions hector@garciacpa.com To setup a 30-day free trial of QuickBooks Online and then a 50% http://www.quickbooksoffer.com/?cid=irp-4337#pricing

Full video tutorial for running Manual Payroll in QuickBooks Desktop: https://youtu.be/viTd6FNk2AM Call our office 954-414-1524 to purchase the latest version of QuickBooks Desktop, we are resellers! or email me: hector@garciacpa.com for a quote

Small Business Tax Deductions 2020 - What is deductible? Download Slides here: http://bit.ly/businesstaxdeductions 475 Tax Deductions Book: https://amzn.to/2QUgTg4 In-Depth Top 10 Business Tax Deductions video: https://youtu.be/WmB16oZJrnc Personal (Non-Business Tax Deductions): https://quickbooks-training.net/itemized-vs-standard-deductions-for-individual-income-taxes/ Call our office 954-414-1524 to setup a private training/consultation about QuickBooks, Excel, Accounting/Bookkeeping, Taxes, and/or General Business Consulting (rates vary fro $250 to $525) for first consultation depending on length and consultant required. E-mail Hector your questions hector@garciacpa.com To setup a 30-day free trial of QuickBooks Online and then a 50% http://www.quickbooksoffer.com/?cid=irp-4337#pricing

Worker Classification: W-2 Employees or 1099 Independent Contractor Download Slides: http://bit.ly/employeecontractor 1-hour detailed Business Deductions Video: https://www.youtube.com/watch?v=WmB16oZJrnc Call our office 954-414-1524 to setup a private training/consultation about QuickBooks, Excel, Accounting/Bookkeeping, Taxes, and/or General Business Consulting (rates vary fro $250 to $525) for first consultation depending on length and consultant required. E-mail Hector your questions hector@garciacpa.com To setup a 30-day free trial of QuickBooks Online and then a 50% http://www.quickbooksoffer.com/?cid=irp-4337#pricing

My QBO Shortcuts: https://www.hectorgarcia.com/shortcuts Once purchased; Here, login into the portal: hectorgarcia.teachable.com to download the most updated bookmarks file any time. I will be updating it all year long (If you purchased the annual $20 subscription) as new shortcuts come along or are discovered. The file easier to access if you download it into your desktop (to make it easier to find) otherwise it probably would just be in your “Downloads” folder. Then you open Google Crome, go to the Bookmarks manager... click on the 3 little dots to open the menu dropdown and select “Import Bookmarks” - and select the file in your desktop or downloads folder called “HECTOR’S QBO SHORTCUTS” That should do it! We do not provide phone support for this, email me if you got questions and/or request a refund if it doesn’t work. Call our office 954-414-1524 to setup a private training/consultation about QuickBooks, Excel, Accounting/Bookkeeping, Taxes, and/or General Business Consulting (rates vary fro $250 to $525) for first consultation depending on length and consultant required. E-mail Hector your questions hector@garciacpa.com To setup a 30-day free trial of QuickBooks Online and then a 50% http://www.quickbooksoffer.com/?cid=irp-4337#pricing

Import updated costs of inventory items in QuickBooks Desktop (Pro, Premier, Accountant, or Enterprise) from Excel. If you have QuickBooks Online, this video is not for you... Call our office 954-414-1524 to setup a private training/consultation about QuickBooks, Excel, Accounting/Bookkeeping, Taxes, and/or General Business Consulting (rates vary fro $250 to $525) for first consultation depending on length and consultant required. E-mail Hector your questions hector@garciacpa.com To setup a 30-day free trial of QuickBooks Online and then a 50% http://www.quickbooksoffer.com/?cid=irp-4337#pricing

We are going to create two reports: Sales by Preferred Vendor Sales by Country/Region Both are going to require exporting at least two reports from QuickBooks to Excel. We are working on QuickBooks Desktop Pro, Premier, Accountant, or Enterprise. This tutorial is NOT for QuickBooks Online users. Call our office 954-414-1524 to setup a private training/consultation about QuickBooks, Excel, Accounting/Bookkeeping, Taxes, and/or General Business Consulting (rates vary fro $250 to $525) for first consultation depending on length and consultant required. E-mail Hector your questions hector@garciacpa.com To setup a 30-day free trial of QuickBooks Online and then a 50% http://www.quickbooksoffer.com/?cid=irp-4337#pricing

To see my desktop setup: https://hectorgarcia.com/podcast-webinar-recording-setup/ Microphones I mentioned: Sennheiser SC30: https://amzn.to/2PUFJfl Samson Q2U: https://amzn.to/2QcyAqD PowerDeWise Lavalier: https://amzn.to/2sNPfZL Fifine 669 Kit: https://amzn.to/34OX2DQ Rode PSA1 Boom Arm: https://amzn.to/2QaHYv1 Call our office 954-414-1524 to setup a private training/consultation about QuickBooks, Excel, Accounting/Bookkeeping, Taxes, and/or General Business Consulting (rates vary fro $250 to $525) for first consultation depending on length and consultant required. E-mail Hector your questions hector@garciacpa.com To setup a 30-day free trial of QuickBooks Online and then a 50% http://www.quickbooksoffer.com/?cid=irp-4337#pricing

How to Zero-out all the inventory in QuickBooks Pro, Premier, Accountant, or Enterprise in batch, plus using my magic spreadsheet: http://bit.ly/magicaldjustment Call our office 954-414-1524 to setup a private training/consultation about QuickBooks, Excel, Accounting/Bookkeeping, Taxes, and/or General Business Consulting (rates vary fro $250 to $525) for first consultation depending on length and consultant required. E-mail Hector your questions hector@garciacpa.com To setup a 30-day free trial of QuickBooks Online and then a 50% http://www.quickbooksoffer.com/?cid=irp-4337#pricing

Purchase it $25 one-time or $20/year with updates all year: https://hectorgarcia.com/shortcuts Once purchased, login into the portal: https://hectorgarcia.teachable.com to download the most updated bookmarks file any time. I will be updating it all year long (If you purchased the annual $20 subscription) as new shortcuts come along or are discovered. The file easier to access if you download it into your desktop (to make it easier to find) otherwise it probably would just be in your “Downloads” folder. Then you open Google Crome, go to the Bookmarks manager... click on the 3 little dots to open the menu dropdown and select “Import Bookmarks” - and select the file in your desktop or downloads folder called “HECTOR’S QBO SHORTCUTS.HTML” That should do it! Complete list of Shortcuts: Journal Entry (i.e.: https://qbo.intuit.com/app/journal) Amount Search QuickBooks Home Page Sales Receipt Invoice Receive Payment Estimate Customer Statements Credit Memo All Sales Refund Receipt Income Overview Sales Center Invoice Center Customers Projects Add customer Delayed Charge Delayed Credit Expense Transactions Vendors Create Expense Purchase Order (Plus or Advanced) Bill Pay bill Vendor Credit Pay credit card Add New Vendor Contractors Employees Payroll Create Paycheck Payroll Reporting Batch Prepare 1099's Weekly Time Sheet Single time activity Item List (Products and Services) Add product/service Price Rules Product Categories Inventory Qty Adjustment Bank Feeds Bank Rules Reconcile Create Expense Receipts Credit Card Credit Credit Card Charge (Expense) Print Checks Transfers Make Deposit Write Check Pay credit card Pay bill Search Mileage Recurring Transactions Attachments Import Data Sales tax Payroll Taxes Currencies Setup and Settings Chart of Accounts Account Register Settings Custom Form Styles Manage Users All Lists Apps Customer Types Hide Unbilled Expenses Reports Center Profit and Loss Balance Sheet Statement of Cashflows Audit Log Old Snapshot Voided/Deleted Transactions Create Budget (Plus or Advanced) Reconciliation Reports Reclassify transactions Write Off Invoices Accountant Tools Bookkeeping Overview (QBO ADVANCED ONLY) Workflows (QBO ADVANCED ONLY) Custom fields (QBO ADVANCED ONLY) Batch Transactions (QBO ADVANCED ONLY) QuickBooks Online Client Overview (QBO ADVANCED ONLY) Export Data to Excel (QBO ADVANCED ONLY)

Works with QuickBooks Pro, Premier, Accountant, or Enterprise... Only Desktop versions, If you have QuickBooks Online - this video is not for you Call our office 954-414-1524 to setup a private training/consultation about QuickBooks, Excel, Accounting/Bookkeeping, Taxes, and/or General Business Consulting (rates vary fro $250 to $525) for first consultation depending on length and consultant required. E-mail Hector your questions hector@garciacpa.com To setup a 30-day free trial of QuickBooks Online and then a 50% http://www.quickbooksoffer.com/?cid=irp-4337#pricing

How Professional Service Providers Create Value: “The 8 opportunities to create value for your customers” Call our office 954-414-1524 to setup a private training/consultation about QuickBooks, Excel, Accounting/Bookkeeping, Taxes, and/or General Business Consulting (rates vary fro $250 to $525) for first consultation depending on length and consultant required. E-mail Hector your questions hector@garciacpa.com To setup a 30-day free trial of QuickBooks Online and then a 50% http://www.quickbooksoffer.com/?cid=irp-4337#pricing

http://www.altaccountant.com http://www.CovetedConsultant.com/free Call our office 954-414-1524 to setup a private training/consultation about QuickBooks, Excel, Accounting/Bookkeeping, Taxes, and/or General Business Consulting (rates vary fro $250 to $525) for first consultation depending on length and consultant required. E-mail Hector your questions hector@garciacpa.com To setup a 30-day free trial of QuickBooks Online and then a 50% http://www.quickbooksoffer.com/?cid=irp-4337#pricing

Join our AltAccountant Program to learn this in-depth, Next cohort is April/May 2020 http://www.altaccountant.com

Purchase TPI: https://transactionpro.grsm.io/quickbooks Call our office 954-414-1524 to setup a private training/consultation about QuickBooks, Excel, Accounting/Bookkeeping, Taxes, and/or General Business Consulting (rates vary from $250 to $525) for first consultation depending on length and consultant required. E-mail Hector your questions hector@garciacpa.com To setup a 30-day free trial of QuickBooks Online and then a 50% http://www.quickbooksoffer.com/?cid=irp-4337#pricing

Transaction Pro Importer for Desktop https://transactionpro.grsm.io/quickbooks

Rich Horwath https://www.StrategySkills.com Call our office 954-414-1524 to setup a private training/consultation about QuickBooks, Excel, Accounting/Bookkeeping, Taxes, and/or General Business Consulting (rates vary fro $250 to $525) for first consultation depending on length and consultant required. E-mail Hector your questions hector@garciacpa.com To setup a 30-day free trial of QuickBooks Online and then a 50% http://www.quickbooksoffer.com/?cid=irp-4337#pricing

Exceprt from my Advanced Webinars series. For full access to all recordings and future episodes, go to: https://hectorgarcia.com/advanced Call our office 954-414-1524 to setup a private training/consultation about QuickBooks, Excel, Accounting/Bookkeeping, Taxes, and/or General Business Consulting (rates vary fro $250 to $525) for first consultation depending on length and consultant required. E-mail Hector your questions hector@garciacpa.com To setup a 30-day free trial of QuickBooks Online and then a 50% http://www.quickbooksoffer.com/?cid=irp-4337#pricing

Sleeter.com Call our office 954-414-1524 to setup a private training/consultation about QuickBooks, Excel, Accounting/Bookkeeping, Taxes, and/or General Business Consulting (rates vary fro $250 to $525) for first consultation depending on length and consultant required. E-mail Hector your questions hector@garciacpa.com To setup a 30-day free trial of QuickBooks Online and then a 50% http://www.quickbooksoffer.com/?cid=irp-4337#pricing

Transaction Pro Importer: https://www.transactionpro.com Advanced Webinars: https://hectorgarcia.com/advanced Call our office 954-414-1524 to setup a private training/consultation about QuickBooks, Excel, Accounting/Bookkeeping, Taxes, and/or General Business Consulting (rates vary fro $250 to $525) for first consultation depending on length and consultant required. E-mail Hector your questions hector@garciacpa.com To setup a 30-day free trial of QuickBooks Online and then a 50% http://www.quickbooksoffer.com/?cid=irp-4337#pricing

Transaction Pro Importer: https://www.transactionpro.com Advanced Webinars: https://hectorgarcia.com/advanced Call our office 954-414-1524 to setup a private training/consultation about QuickBooks, Excel, Accounting/Bookkeeping, Taxes, and/or General Business Consulting (rates vary fro $250 to $525) for first consultation depending on length and consultant required. E-mail Hector your questions hector@garciacpa.com To setup a 30-day free trial of QuickBooks Online and then a 50% http://www.quickbooksoffer.com/?cid=irp-4337#pricing

#QBCONNECT Recap! Join us live Fridays at 11:30pm EST https://www.facebook.com/fnlaccountants/ Call our office 954-414-1524 to setup a private training/consultation about QuickBooks, Excel, Accounting/Bookkeeping, Taxes, and/or General Business Consulting (rates vary fro $250 to $525) for first consultation depending on length and consultant required. E-mail Hector your questions hector@garciacpa.com To setup a 30-day free trial of QuickBooks Online and then a 50% http://www.quickbooksoffer.com/?cid=irp-4337#pricing

Slides: http://bit.ly/3773Mzx In this episode, talked about: - Google Sheets Integration (QBO Advanced) - Workflow Automation (QBO Advanced) - Batch Enter Invoices, Expenses, and Checks (QBO Advanced) - Business Performance Dashboard (QuickBooks Online Accountant)  - Preview of new features coming in next couple of months announced at QuickBooks Connect conference in San Jose, CA Nov. 2019 Call our office 954-414-1524 to setup a private training/consultation about QuickBooks, Excel, Accounting/Bookkeeping, Taxes, and/or General Business Consulting (rates vary fro $250 to $525) for first consultation depending on length and consultant required. E-mail Hector your questions hector@garciacpa.com To setup a 30-day free trial of QuickBooks Online and then a 50% http://www.quickbooksoffer.com/?cid=irp-4337#pricing

Starts at 00:02:38 Join: https://hectorgarcia.com/altaccountant Get Slides: http://bit.ly/2K60xyn

How to fix the beginning balance on a bank or credit card when doing a reconciliation Call our office 954-414-1524 to setup a private training/consultation about QuickBooks, Excel, Accounting/Bookkeeping, Taxes, and/or General Business Consulting (rates vary fro $250 to $525) for first consultation depending on length and consultant required. E-mail Hector your questions hector@garciacpa.com To setup a 30-day free trial of QuickBooks Online and then a 50% http://www.quickbooksoffer.com/?cid=irp-4337#pricing

The AltAccountant Workshop starts 11/18/19 and ends 12/20/19, details: https://hectorgarcia.com/altaccountant

Check out Seth's Bulletproof Bookkeeping course for: https://new.nerdenterprises.com/a/20210/J2ihs5FY How to learn bookkeeping, accounting, and QuickBooks Online from a practitioner to gain practical experience with Seth David for folks getting started with Bookkeeping/Accounting Services Call our office 954-414-1524 to setup a private training/consultation about QuickBooks, Excel, Accounting/Bookkeeping, Taxes, and/or General Business Consulting (rates vary fro $250 to $525) for first consultation depending on length and consultant required. E-mail Hector your questions hector@garciacpa.com To setup a 30-day free trial of QuickBooks Online and then a 50% http://www.quickbooksoffer.com/?cid=irp-4337#pricing

My Inventory Adjustment Template/Macro for QuickBooks Desktop: https://quickbooks-training.net/inventory-adjustment-iif-template-for-quickbooks-desktop/ *Note, this process does not work in QuickBooks Online - This is for QuickBooks Pro, Premier, and Enterprise only! Call our office 954-414-1524 to setup a private training/consultation about QuickBooks, Excel, Accounting/Bookkeeping, Taxes, and/or General Business Consulting (rates vary fro $250 to $525) for first consultation depending on length and consultant required. E-mail Hector your questions hector@garciacpa.com To setup a 30-day free trial of QuickBooks Online and then a 50% http://www.quickbooksoffer.com/?cid=irp-4337#pricing

More info https://www.raven.com/accountants Raven Pro Document Scanner for Accountants - 100% Cloud Based https://amzn.to/2N6vYcw

Total Tutorial Length: 80 Minutes Table of Contents: 00:01:45 Why QuickBooks Online “Global/International”? 00:05:48 Setting up a New Company 00:07:53 Settings, Language, and Home Currency 00:13:34 Basic Navigation 00:20:58 Chart of Accounts 00:27:39 Tracking Sales/Invoices & Customer Accounts receivables 00:42:05 Tracking Expenses/Bills & Supplier Accounts payables 00:52:39 Managing Inventory 00:52:39 Billable Time & Expenses 01:04:28 Project Profitability Tracking 01:08:25 Tracking Sales Tax & VAT 01:11:02 Budgets & Financial Reports 01:15:30 Banking and Reconciliations 01:19:27 Document Attachments Watch our QuickBooks webinar held by expert QBO accountant, Hector Garcia. Hector covers how to set up QuickBooks Online in the International edition of the product and provides great guidance on some of the product's useful features, such as creating invoices, categorizing expenses, setting up your tax and Chart of Accounts and more! To find out more about QuickBooks Online, visit: https://quickbooks.intuit.com/global/

10/02/2019 Pricing & Authority with Jonathan Stark http://www.valuepricingbootcamp.com

If you need to export open (unpaid) Invoices and Bills. And open Sales Orders and Purchase Orders, you can do that with a Transaction Detail Report in QuickBooks Desktop. This video will show you how. You can import transactions into QuickBooks Desktop, using SaasAnt Importer: http://bit.ly/SAASANT Call our office 954-414-1524 to setup a private training/consultation about QuickBooks, Excel, Accounting/Bookkeeping, Taxes, and/or General Business Consulting (rates vary fro $250 to $525) for first consultation depending on length and consultant required. E-mail Hector your questions hector@garciacpa.com To setup a 30-day free trial of QuickBooks Online and then a 50% https://www.quickbooksoffer.com/?cid=irp-4337#pricing

Download this file and cheat sheet: http://bit.ly/hectorexcelshortcuts Take my Excel Advanced Course: https://hectorgarcia.com/advancedexcel Shortcuts covered: Control+F1 Shows and Hides Ribbon Control+Alt+Plus Zooms in Control+Alt+Minus Zooms Out Control+S Saves Workbook ARROWS KEY Move selected cell in desired direction Tab Move Selected Cell to right Shift+Tab Move Selected Cell to left Enter Move Selected Cell up Shift+Enter Move Selected Cell down Control+ARROWS KEY Go to first or last cell with data based on the current row or column of selected cell Shift+ARROW KEY Expand selected cell area towards the direction of the arrow Shift+Spacebar Select entire row Control+Spacebar Select entire column Control+Shift+Plus Insert blank cell(s), column or row Control+Minus Delete selected cell(s), column or row Control+A Select entire dataset adjusted to current cell Control+A (twice) Select entire dataset inside worksheet Control+Home Go to first cell (typically A1) Control+End Go to last cell with data Control+Shift+Home Selects all the data from the current selected cell to first cell with data (typically A1) Control+Shift+End Selects all the data from the current selected cell to the last cell with data Page Down Scrolls down to next row belllow the last visible row Page Up Scrolls up to previous row above the first visible row Alt+Page Down Scrolls down to next column belllow the last visible column Alt+Page Up Scrolls up to previous column above the first visible column Shift+Page Down Selects the cells down to next column belllow the last visible column Shift+Page Up Selects the cells up to previous column above the first visible column Control+ . (Period) Make last cell from selection the active cell Control+Page Down Goes to the next workseet Control+Page Up Goes to the previous worksheet Control+C Copy Control+V Paste Control+Alt+V Paste Special F4 Repeat Last Action Control+Z Undo Last Action Control+Y Redo Last Undo Control+; Enter Today's Date F2 Edit contents of the Cell Alt+Enter Insert a line break inside a cell Control+Shift+L Add Filters to selected range/table Alt+= AutoSum Control+D Autofill down data under selected cell Control+R Autofill right data under selected cell Alt+Down Arrow Show Autocomplete List Control+Enter Enter data from selected cell into multiple selected cells Control+Shift+& Add Border to Selected Range Control+Shift+_ Removed Border from Selected Range Control+Shift+$ Currency Formatting Control+Shift+% Percentage Formatting Control+Shift+# Date Formatting Control+Shift+` General Formatting Control+0 Hide Columns Control+9 Hide Rows Control+Shift+0 Unhide Columns Control+Shift+9 Unhide Rows Alt+Shift+Right Arrow Groups columns or rows Alt+Shift+Left Arrow Ungroups columns or rows Control+F3 Opens Insert Function Dialog Control+` Toggles Formulas On/Off Call our office 954-414-1524 to setup a private training/consultation about QuickBooks, Excel, Accounting/Bookkeeping, Taxes, and/or General Business Consulting (rates vary fro $250 to $525) for first consultation depending on length and consultant required. E-mail Hector your questions hector@garciacpa.com To setup a 30-day free trial of QuickBooks Online and then a 50% http://www.quickbooksoffer.com/?cid=irp-4337#pricing

To setup a 30-day free trial of QuickBooks Online and then a 50% https://www.quickbooksoffer.com/?cid=irp-4337#pricing Call our office 954-414-1524 to setup a private training/consultation about QuickBooks, Excel, Accounting/Bookkeeping, Taxes, and/or General Business Consulting (rates vary fro $250 to $525) for first consultation depending on length and consultant required. E-mail Hector your questions hector@garciacpa.com To setup a 30-day free trial of QuickBooks Online and then a 50% http://www.quickbooksoffer.com/?cid=irp-4337#pricing

Call our office 954-414-1524 to purchase QuickBooks from us or to setup a private training/consultation about QuickBooks, Excel, Accounting/Bookkeeping, Taxes, and/or General Business Consulting (rates vary fro $250 to $525) for first consultation depending on length and consultant required. E-mail Hector your questions hector@garciacpa.com To setup a 30-day free trial of QuickBooks Online and then a 50% http://www.quickbooksoffer.com/?cid=irp-4337#pricing

Some thoughts of what I continue to learn about the efficiency vs. effectiveness theory Ron Baker's Book: Implementing Value Pricing https://amzn.to/2LkSMFT First video; https://youtu.be/cyohVy3Bs7c Call our office 954-414-1524 to setup a private training/consultation about QuickBooks, Excel, Accounting/Bookkeeping, Taxes, and/or General Business Consulting (rates vary fro $250 to $525) for first consultation depending on length and consultant required. E-mail Hector your questions hector@garciacpa.com To setup a 30-day free trial of QuickBooks Online and then a 50% http://www.quickbooksoffer.com/?cid=irp-4337#pricing

The "Effing" Debate as Ron Baker calls it, is the difference between being Efficient vs Effective Call our office 954-414-1524 to setup a private training/consultation about QuickBooks, Excel, Accounting/Bookkeeping, Taxes, and/or General Business Consulting (rates vary fro $250 to $525) for first consultation depending on length and consultant required. E-mail Hector your questions hector@garciacpa.com To setup a 30-day free trial of QuickBooks Online and then a 50% http://www.quickbooksoffer.com/?cid=irp-4337#pricing

Based on newest version 30.0 or AKA "QuickBooks Desktop 2020", R1 - Released 09/03/2019 Presentation covers all new features in QuickBooks Desktop 2020, live DEMO of most features, and my full commentary of my thoughts (Pros/Cons) of all new features, specially the two biggest: Landed Cost and Alternate Vendors New Features in all Windows versions (QuickBooks Pro/Premier/Accountant/Enterprise 2020): • Add customer PO number to subject line in emails • Combine multiple emails for a single customer:job, vendors, or employees • Automated customer payment reminders • Company file search • Horizontally collapse columns in job or class reports • Payroll status for direct deposit New Features in QuickBooks Enterprise only: • Landed cost calculation • Alternate vendors • Inventory cycle count (mid-year update to 2019 as well) • Improved Express pick-pack QuickBooks for Mac 2020 New Features: • Modernized Reporting Screen • Improved Company Snapshot • Dark Mode • Invoice E-Payments (with QuickBooks Payments) • Bounced Check Process • iPhone Scanner and searchable PDF images support Call our office 954-414-1524 to setup a private training/consultation about QuickBooks, Excel, Accounting/Bookkeeping, Taxes, and/or General Business Consulting (rates vary fro $250 to $525) for first consultation depending on length and consultant required. E-mail Hector your questions hector@garciacpa.com To setup a 30-day free trial of QuickBooks Online and then a 50% http://www.quickbooksoffer.com/?cid=irp-4337#pricing

Most of these lessons and learnings come from Ron Baker's Book: Implementing Value Pricing - https://amzn.to/2LkSMFT Call our office 954-414-1524 to setup a private training/consultation about QuickBooks, Excel, Accounting/Bookkeeping, Taxes, and/or General Business Consulting (rates vary fro $250 to $525) for first consultation depending on length and consultant required. E-mail Hector your questions hector@garciacpa.com To setup a 30-day free trial of QuickBooks Online and then a 50% http://www.quickbooksoffer.com/?cid=irp-4337#pricing

The first video I did on this was about redefining the word "Expensive": https://www.youtube.com/watch?v=IAe9I1bejCw Most of these lessons and learnings come from Ron Baker's Book: Implementing Value Pricing - https://amzn.to/2LkSMFT Call our office 954-414-1524 to setup a private training/consultation about QuickBooks, Excel, Accounting/Bookkeeping, Taxes, and/or General Business Consulting (rates vary fro $250 to $525) for first consultation depending on length and consultant required. E-mail Hector your questions hector@garciacpa.com To setup a 30-day free trial of QuickBooks Online and then a 50% http://www.quickbooksoffer.com/?cid=irp-4337#pricing

Take my $100 live webinar/course on September 20th: Advanced Excel Tricks for Accounting: https://youtu.be/rdQr8NLu6CQ https://hectorgarcia.teachable.com/p/dataimport/?product_id=1296697&coupon_code=SEPT20 Topics: 00:02:51 #8 Trim(), Upper(), Lower() 00:07:30 #9 Paste Special (Values) 00:09:49 #10 Remove Duplicates 00:12:36 #11 Text To Columns 00:15:14 #12 Concatenante() and Ampersand (&) 00:21:06 #13 Autofit Width and Height 00:23:07 #14 Formula Operators Order (PEMDAS) 00:26:57 #15 Practice Data Part 1: https://youtu.be/rdQr8NLu6CQ Covers: #1 Select Data Range & Filter #2 Autosum & Subtotal() #3 Relative & Absolute References #4 Named Ranges and Tables #5 AutoFill & FlashFill #6 Go To Special (Select Blanks) #7 Find and Replace Call our office 954-414-1524 to setup a private training/consultation about QuickBooks, Excel, Accounting/Bookkeeping, Taxes, and/or General Business Consulting (rates vary fro $250 to $525) for first consultation depending on length and consultant required. E-mail Hector your questions hector@garciacpa.com To setup a 30-day free trial of QuickBooks Online and then a 50% http://www.quickbooksoffer.com/?cid=irp-4337#pricing

Next video in this series is: "Rival Assets vs. Non-Rival Assets; and the underrated value of Intellectual Capital" - https://youtu.be/IzOYulCdY5w Call our office 954-414-1524 to setup a private training/consultation about QuickBooks, Excel, Accounting/Bookkeeping, Taxes, and/or General Business Consulting (rates vary fro $250 to $525) for first consultation depending on length and consultant required. E-mail Hector your questions hector@garciacpa.com To setup a 30-day free trial of QuickBooks Online and then a 50% http://www.quickbooksoffer.com/?cid=irp-4337#pricing

... And why we need to think about values and outcomes, before judging any product or service by its price only Next video on this series is: "The Real Value of Relationships and Trust" https://youtu.be/SrwKHyDoQIo Most of these lessons and learnings come from Ron Baker's Book: Implementing Value Pricing - https://amzn.to/2LkSMFT Call our office 954-414-1524 to setup a private training/consultation about QuickBooks, Excel, Accounting/Bookkeeping, Taxes, and/or General Business Consulting (rates vary fro $250 to $525) for first consultation depending on length and consultant required. E-mail Hector your questions hector@garciacpa.com To setup a 30-day free trial of QuickBooks Online and then a 50% http://www.quickbooksoffer.com/?cid=irp-4337#pricing

Counting and Adjusting inventory with the Mobile Andrioid-based Scanning Solution built-into QuickBooks Enterprise Platinum: "Barcode support" and "Site Operations" Call our office 954-414-1524 to setup a private training/consultation about QuickBooks, Excel, Accounting/Bookkeeping, Taxes, and/or General Business Consulting (rates vary fro $250 to $525) for first consultation depending on length and consultant required. E-mail Hector your questions hector@garciacpa.com To setup a 30-day free trial of QuickBooks Online and then a 50% http://www.quickbooksoffer.com/?cid=irp-4337#pricing

Advanced Excel Tips and Tricks for Accountants Call our office 954-414-1524 to setup a private training/consultation about QuickBooks, Excel, Accounting/Bookkeeping, Taxes, and/or General Business Consulting (rates vary fro $250 to $525) for first consultation depending on length and consultant required. E-mail Hector your questions hector@garciacpa.com To setup a 30-day free trial of QuickBooks Online and then a 50% http://www.quickbooksoffer.com/?cid=irp-4337#pricing

Michael Palmer from The Successful Bookkeeper Podcast Interviewed me today... Check out the podcast and all the episodes at: https://www.thesuccessfulbookkeeper.com/episodes Call our office 954-414-1524 to setup a private training/consultation about QuickBooks, Excel, Accounting/Bookkeeping, Taxes, and/or General Business Consulting (rates vary fro $250 to $525) for first consultation depending on length and consultant required. E-mail Hector your questions hector@garciacpa.com To setup a 30-day free trial of QuickBooks Online and then a 50% http://www.quickbooksoffer.com/?cid=irp-4337#pricing

This video does an in-depth analysis of the changes in the balance sheet that cane explain the differences in net income or profits vs. the money in the bank. My clients often ask me "Where is the money?" when they see a high income in the Profit and Loss report but no so much money in the bank account. This is also a reversed analysis of the cashflow of the business Call our office 954-414-1524 to setup a private training/consultation about QuickBooks, Excel, Accounting/Bookkeeping, Taxes, and/or General Business Consulting (rates vary fro $250 to $525) for first consultation depending on length and consultant required. E-mail Hector your questions hector@garciacpa.com To setup a 30-day free trial of QuickBooks Online and then a 50% http://www.quickbooksoffer.com/?cid=irp-4337#pricing