YouTube Videos

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

I have been heavily influenced by Ron Baker (Author of Implementing Value Pricing) and I try to teach from his body of work combined by my life experiences. His book should be the starting point for all practitioners. I can only hope to add more personal context in my teachings, but most of what I learned on this topic comes from Ron’s 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

#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 $997: https://new.nerdenterprises.com/a/13985/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

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