YouTube Videos

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% http://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

QuickBooks Desktop: Difference in Memos in paystub for Checks vs. Bill Payments Take my complete QuickBooks Desktop course: https://quickbooks.teachable.com/p/quickbooks-desktop-basics 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

Excerpt of my Advanced Webinar series for QuickBooks Online, to watch entire 2-hour webinar, plus bonus content, and to download the slides, subscribe as a Premium Paying Member for $500/y: http://www.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

QuickBooks Desktop: Tracking Vendor Rebates on Invoices Take my complete QuickBooks Desktop Course: https://quickbooks.teachable.com/p/quickbooks-desktop-basics 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://hectorgarcia.teachable.com/p/dataimport/?product_id=1296697&coupon_code=SEPT20 Part 1- Table of Contents: 00:01:07 Select Data Range & Filter 00:02:31 Autosum & Subtotal() 00:05:17 Relative & Absolute References 00:08:32 Named Ranges and Tables 00:12:22 AutoFill & FlashFill 00:15:16 Go To Special (Select Blanks) 00:17:18 Find and Replace Part 2 (Coming August 29th, 2019: https://youtu.be/nQ8j6_Er8Cg) #8 Trim(), Upper(), Lower() #9 Paste Special (Values) #10 Remove Duplicates #11 Text To Columns #12 Concatenate(), Textjoin(), and Ampersand (&) #13 Autofit Width and Height #14 Formula Operators Order (PEMDAS)

QuickBooks Desktop: Partial Purchase Order Item Receipts. Separate Bills from Item Receipts Take my full QuickBooks Desktop Course: https://hectorgarcia.teachable.com/p/quickbooks-desktop-basics 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

Itemize Sales Tax in an Invoice Column in QuickBooks Desktop (Pro/Premier/Enterprise) Take my complete QuickBooks Desktop Course: https://quickbooks.teachable.com/p/quickbooks-desktop-basics 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

QuickBooks Pro/Premier Workaround for Multiple Inventory locations Take my complete Desktop Course: https://quickbooks.teachable.com/p/quickbooks-desktop-basics 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

QuickBooks Enterprise manage inventory transfers and lot number changes Take my complete Desktop Course: https://quickbooks.teachable.com/p/quickbooks-desktop-basics 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

QuickBooks Enterprise Cycle Counts for Inventory Take my complete Desktop Course: https://quickbooks.teachable.com/p/quickbooks-desktop-basics Using mobile scanner to do Cycle Counts: https://youtu.be/N9WA2IxFfdc Call our office 954-414-1524 or email me: hector@garciacpa.com 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

Workaround for managing inventory expiration dates using lot numbers with QuickBooks Enterprise Take my complete Desktop Course: https://quickbooks.teachable.com/p/quickbooks-desktop-basics 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 full Advance Excel Clean-up course for Accountants for $100: https://hectorgarcia.teachable.com/p/dataimport/?product_id=1296697&coupon_code=SEPT20 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 advanced excel for accountants course for $100: https://hectorgarcia.teachable.com/p/dataimport/?product_id=1296697&coupon_code=SEPT20 Using FlashFill to extract Dates, Amounts, and Descriptions (Advanced Excel Tutorial) This is a "part 2" or follow up to this video for doing the same thing, but with a lot more work: https://www.youtube.com/watch?v=EYtfDKZzmN0&t=1s 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 advanced excel for accountants course: https://hectorgarcia.teachable.com/p/dataimport/?product_id=1296697&coupon_code=SEPT20 "Part 2" of this lesson using FlashFill: https://youtu.be/E1fyjaszyCM Formulas used: RIGHT() LEFT() SUBSTITUTE() FIND() TRIM() 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 take the full Advanced Webinars Course on QuickBooks Online, become a member: https://www.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

Download slides: http://bit.ly/outsourcedbookkeeping Read my article on this topic: http://www.quickbooks-training.net/what-is-an-outsourced-bookkeeping-service/ What is OUTSOURCED BOOKKEEPING 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 Slide Art Credits: Presentation template by http://www.slidescarnival.com/ Photographs by http://unsplash.com/

Take my advanced excel for accountants course for $100: https://hectorgarcia.teachable.com/p/dataimport/?product_id=1296697&coupon_code=SEPT20 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

Excerpt from the 2-hour webinar I taught on July 18th, 2019 on QuickBooks Online Downloaded Transactions, Categorization, Bank Rules, and Matching. Become a member to access ALL my advanced training at: https://hectorgarcia.teachable.com/p/quickbooks-online-advanced-webinars-premium-archive for $500 for a year access to ALL my training. 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.facebook.com/altaccountant How to make boring topics interesting with Geni Whitehouse: https://www.amazon.com/How-Make-Boring-Subject-Interesting/dp/0692001514 Hector role plays with Geni on a new customer engagement, discusses the wine niche for accounting professionals and other niches, talks about public speaking, and the role of comedy to make boring topics seems interesting

How to do VLookups in Microsoft Excel for Accounting work TAKE MY ADVANCED EXCEL COURSE FOR ACCOUNTANTS: https://quickbooks.teachable.com/p/dataimport/?product_id=880801&coupon_code=AUG14WEBINAR&preview=logged_out 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

Resource guide to getting started in the accounting and/or bookkeeping industry Updated full list: http://hectorgarcia.com/list/ My favorite paid resource is Seth David's Bulletproof Bookkeeping with QuickBooks Online: https://new.nerdenterprises.com/a/13985/J2ihs5FY 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

Just for fun... almost 30 years later what has changed? thoughts? Doug/Seth's original video: https://www.youtube.com/watch?v=m-NpiFN7o0Q 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

Check out our live podcast via Facebook Fridays 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

Subscribe to all my advanced QuickBooks content for $500/y: http://hectorgarcia.com/advanced/ This video is specific to Real State Property for Investors/Flippers... If you are dealing with Rental Property, the process is different: https://www.youtube.com/watch?v=iR8RoHx3aVA 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 Garcia With Michael Ly and Andrew Wall, Guest: Matthew Fulton! Join us live on Fridays at 11:30pm ET: http://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

Signup for ADVANCED WEBINARS at: http://www.hectorgarcia.com/advanced For recording purchase of rental property (real estate) using the ALTA Settlement Statement (AKA: HUD 1 Statement) with all the proper Debits and Credits in QuickBooks Online 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

Quick video for Accountants to review client's books through the dashboard and/or the Overview tab in QuickBooks Online 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% http://www.quickbooksoffer.com/?cid=irp-4337#pricing Call our office 1-800-819-6307 for advice on Choosing QuickBooks for your business. This spreadsheet contains all the features compared: http://bit.ly/compareQB 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

Video about working with a new Chart of Accounts and/or importing it from excel: https://youtu.be/rC0ctxDofBY How to delete or purge all the data from your QuickBooks Online company file and start over? The technique will delete all accounts, transactions, Balances, customers, vendors, items, etc. 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

Download all Chart of Accounts with descriptions: http://www.quickbooks-training.net/quickbooks-online-categories-chart-of-accounts/ Another option is to PURGE or DELETE all the data from QuickBooks Online, this video explains it: https://youtu.be/89g_ifE3aig Table of Contents: -Working with the default categories or accounts in the chart of accounts -Delete or Inactivate unwanted accounts -Import chart of accounts from excel -Preview chart of accounts in Profit and Loss or Balance Sheet Reports 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

NEW Learn Accounting University channel: https://www.youtube.com/user/QuickBookkeeping/videos 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

Recording from Friday Night Live (a Facebook Live event for accountants) on June 6th, 2019. Dr. Lee's book: https://www.bdrco.org/product-page/strategic-cost-transformation 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 shows some inventory receiving basics with QuickBooks Desktop at Avg. Cost vs. the manual process of doing Landed Cost 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

RE-UPLOAD FROM 03/22/2018 QB POWER HOUR: Working with QuickBooks Desktop Remotely + Qbox QuickBooks Desktop vs. Online Feature comparison Matrix: http://bit.ly/QBOvsQBES 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

Excerpt from Friday Night Live (a Facebook Live Event every Friday at 11:30pm Eastern) where co-hosts: Michael Ly, Andrew Wall, and I casually discuss different things affecting our practices and our industry over some Friday night drinks... 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