In this video, I show you how to customize the Transaction List by customer report. I like this report because you can display subtotals of each customer income and expenses. You will learn how to filter the report by dates and customers you want displayed in the report. Then learn how to export the report via email, pdf or Microsoft Excel.
The new Xlookup formula is a brand new formula that can replace the use of Vlookup. It searches down or across to find the value you want and then returns a value within the return range. Take a look at my video to see it in action.
I am reading through the complete works of Abraham Lincoln's writings, which include all his speeches and letters. It is a fascinating journey stepping into Lincoln's mind. I count it as a gift to receive this learning rich learning experience. Currently I'm on volume 5 of 12. I've been reading about 5-15 minutes a day in during my morning reading habits which I began on Jan 1, 2018. What follows below are 3 of my favorite passages from the lecture "Discoveries, Inventions, and Improvements" which Lincoln delivered in neighboring towns in 1859 and before the Springfield Library Association, on Feb 22, 1869. I've also scanned the text and made available here for anyone who wants [...]
I'm excited to show you the first views of a new feature ofcreating Slicers in Google Sheets. Compare this to a previous post I did on Excel slicers. Slicers allow you to filter you data in easy to manage buttons.
There often is a lot of work that goes with doing a QBO cleanup project. I've seen a lot and have learned a lot. Really it comes down to not being organized at the chart of accounts in the beginning. The good news is that you can do a cleanup but it takes a highly specialized skillset to do so. This video will share some of my secrets to doing QBO cleanups.
The undeposited funds is used as a holding account that can store checks you received from customers but have not yet deposited them to the bank. When you make a bank deposit of several customer payments by check or cash then it can be done in QBO in an organized way using the undeposited funds. This video will teach you how to troubleshoot the bank feeds in matching your bank deposits.