How to remove duplicates in Google Sheets and Excel
There's a new feature release from Google Sheets and that includes remove duplicates. Here's my video that shows you the differences between the two programs. Which spreadsheet tool do you prefer?
Track expenses by department in QuickBooks Online
This video will teach you how to setup up tracking expenses in Quickbooks Online by departments. To turn on this feature you will need a QBO Plus or Advanced subscription. Gear Icon> Account and Settings > Advanced > Turn on location tracking and then select Departments label.
How to run the Invoices and Received Payments report in QBO
The new Invoices and Received Payments report in QBO is really helpful when reviewing your accounts receivables. This video will teach you how to run and customize it.
Create Sales Commissions Reports in Excel
This video tutorial will teach you how to use the Sumifs and Vlookup formulas to create sales commissions report after exporting QBO to Excel.
Create Sales Commissions Reports in QuickBooks Online
This video will teach you how I like to setup sales commissions reports in QBO. It will require the use of class tracking (QBO Plus or Advanced) as well as Excel to do the actual commission.