(Click the image above to watch the video tutorial)
This is a free video tutorial for small business bookkeeping – part 1 – open office calc spreadsheets – invoice tracking – bookkeeping training.
In this video tutorial, I will show you how to keep track of invoices which you have sent to your clients. By the end of this tutorial, you will be able to keep track of all your invoices and know who has paid and more importantly who has NOT paid so you can chase up payments.
We will create a spreadsheet with various informative columns which will give you a quick overview of your invoices. We will use Open Office Calc to create the spreadsheet, but the same logic can easily be applied to Libre Office Calc or Microsoft Excel spreadsheet.
I will show you how to use colour codes so at a glance you can quickly see which invoices are paid and which are outstanding. I will also show you how to use auto filters which simply allows to you quickly analyse information in your invoice tracking spreadsheet.
Subscribe to access 500+ video tutorials: https://www.youtube.com/dcpwebdesigners
To complete this tutorial you will need to download Open Office.
The next tutorial will focus on designing a custom invoice template. This will be designed using the Open Office Calc application.
Subscribe to DCP YouTube for more free business bookkeeping video tutorials.
# bookkeeping for small business
Business bookkeeping video tutorial by: DCP Website Design
