I hope you enjoy reading our blog posts. If you want DCP to build you an awesome website, click here.
Bookkeeping for small business tutorial part 1 - open office calc spreadsheets
23-08-2014
Back(Click image above to watch 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 how 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.
In the next tutorial will focus on designing a custom invoice template. This will be designed using open office Calc application.
Subscribe to DCP YouTube for more free business bookkeeping video tutorials.
# bookkeeping for small business
# bookkeeping tutorial for beginners
# bookkeeping training YouTube
Business bookkeeping video tutorial by: DCP Website Design
Tell Us Your Thoughts
Thank you for contacting us.
We will reply to you in next 2 working days.
Pankaj has 16 years of website project management experience, working on a diverse range of web and creative design projects for clients based in the UK and overseas.
Releated Posts
26-09-2017
Libre Office conditional formatting tutorial
Libre Office contains some useful features and in this tutorial will look at conditional formatting. Conditional formatting simply allows you to change the content or style of a spreadsheet cell based on specific conditions you create. There are various types of conditional formatting which can be used and the type used depends on the content of your spreadsheet cells.
15-02-2022
6 tips for creating the perfect pitch deck for your startup business
If you want your startup to stand out, you will definitely need a pitch deck. When you are looking for more investment from a venture capital firm, you will have to pitch your company’s vision and mission to them.
18-02-2020
How to Remove Duplicates in Excel 2020
In this video tutorial, I will show you how to remove duplicates in excel 2020. I will be using the latest version of Microsoft Excel Office 365.
17-11-2021
How branded merchandise can grow your business
With current market trends focusing on the use of digital advertising, it can be a challenge to keep up with the pace. Updates roll out frequently, getting a strong foothold on platforms is a constant struggle and audience interest changes on a whim. Also, how is a business supposed to stay afloat while dealing with constant headaches caused by misinformation and cyber attacks?
