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

Releated Posts

22-07-2018

Save your business time with 16 different ways to get more work done

Hard at work entrepreneurs with short time have an easy way of getting more work done with simple productivity hacks. At DCP we plan our daily tasks first thing in the morning and set out a timescale for completing our business development and web design work.

20-04-2014

Windows 8.1 beginners tutorial

This tutorial is suitable for anyone who is just starting to use Windows 8 or Windows 8.1 and needs a quick beginners guide. As you may be aware there are some major differences between Windows 7 and Windows 8. The goal of this tutorial is to give your full overview of the new features available in Windows 8.1.

15-12-2023

Navigating the Path to Leadership - A Guide to Senior Roles

Embarking on the journey from a mid-level position to a senior leadership role is an exciting yet challenging endeavour. It's a transition that requires more than just a job title change—it demands a shift in mindset, an expansion of skills, and the cultivation of qualities that define effective leadership.

14-05-2020

Libre Office 6 Writer Beginners Tutorial

In the tutorial, I will go through some of the fundamentals of using Libre Office 6 Writer. We will build a letterhead document which you can use in your business using free Libre Office 6 Writer software. I will show you how to: Create a custom header and footer, Add your company logo, add your business address, add your website address, add URL links, create font styles, create bullet lists, add images, add and format tables, + much more