Small Business Bookkeeping Tutorials - DCP

How to Create an Invoice Template in Excel

info@dcpweb.co.uk — Tue, 05 Oct 2021 12:54:00 +0000

In this video tutorial, I will show you how to create a custom invoice template using Microsoft Excel.

What you will learn in this video tutorial:

00:00 Introduction
01:10 Create a blank Excel invoice template
02:50 Update Excel spreadsheet margins
06:00 Add company logo
09:20 Add company address
12:00 Add invoice number and invoice date
18:10 Add billing and delivery address
22:10 Add billing line item cells
30:20 Add Total cost, Total VAT and Total Charge cells
32:40 Add sample data
36:20 Change Unit and Net price cells to Currency Value
36:30 Add formulas for calculating Net cost
39:10 Add formulas for calculating Total Cost, Total VAT and Total Charge
44:20 Add content for payment bank account details
47:20 Add payment terms
49:30 Add additional notes
51:10 Add company registered office address, company number and VAT number
01:00:30 Convert Excel to PDF invoice
01:01:10 Fix Errors

Tutorial Goals

The goal of this tutorial is to show you how to create a custom invoice using Microsoft Excel. If you are a small start-up business and need to save money, then creating your own internal bookkeeping system can help save that vital cash.

In this tutorial, we focus on designing an invoice template, above you can find links to my free bookkeeping training course.

The goal of bookkeeping is to keep track of money coming into your business and going out. It does not matter if you are running an online WooCommerce shop or an offline consultancy business. Ultimately we need to have a good understanding of our business cash flow so we can budget for current and future expenditures.

You can find and download free invoice templates for Excel, but I think it is worth the investment to learn how to create the invoice yourself so you can adapt it easily for your business.

It may be worth looking at third-party software solutions for bookkeeping such as Xero or Quick Books if you have a growing or larger organisation. Quick Books or Xero and other accountancy software can be easily integrated into e-commerce solutions like wooCommerce or Shopify. In the long run, this should save you time so you can focus on your you’re my main goal which is to sell products.

Bookkeeping for Small Business – Excel Tutorial – Part 4 – VAT Calculations

info@dcpweb.co.uk — Sun, 09 May 2021 08:03:00 +0000

In the fourth part of this small business bookkeeping video tutorial, I will show you how to convert the current small business bookkeeping system into a VAT bookkeeping system.

Bookkeeping for Small Business – Excel Tutorial – Part 4 – VAT Calculations video tutorial

We will modify the previous spreadsheets we created in Parts 1, 2 and 3 to include VAT calculations.

You can view the other 3 Excel bookkeeping tutorials below:

Watch my free video tutorial for small business bookkeeping part 4 – VAT Calculations.

Video tutorial - Bookkeeping for Small Business - Excel Tutorial - Part 4

Bookkeeping for Small Business – Excel Tutorial – Part 4

Bookkeeping for Small Business FAQs

What is the correct formula for calculating VAT in Excel?

You can also manually calculate adding VAT by multiplying the ex-VAT cost by 1 + VAT Percentage.

Example:

Ex VAT Cost = £40.00
VAT Percentage = 20%
VAT Calculation: £20.00 x 1.2 = £48.00 inc VAT

Excel Formula VAT example: Cellx*1.2

Is there a free tool to check VAT calculations online?

Yes, you are in luck! I have created a free online VAT calculator which you can use to double-check your VAT calculations.

Add VAT Calculator Demo

What are the alternatives to this small business bookkeeping solution?

You can find many other paid subscription accounting software applications like QuickBooks or Xero that can be used for bookkeeping.

The goal of these tutorials is to try and help you keep your costs low so you can invest more into marketing your business.

If you are running an online shopping business then it is worth investing in Quick Books or Xero which can directly integrate into a WooCommerce Shop or Shopify websites.

Tip: Ensure your VAT formulas added to the bookkeeping spreadsheets are correct. You can use my free VAT calculator to verify your VAT calculations.

See how my company can build an amazing website for your business

Custom web design
Secure and fast website solution
Full management training
Take control of your website
SEO optimisation
Reliable web hosting and emails

Bookkeeping video tutorial by: DCP Web Designers in London

The post Bookkeeping for Small Business – Excel Tutorial – Part 4 – VAT Calculations appeared first on DCP.

Bookkeeping for Small Business – Excel Tutorial – Part 3 – Expenditure Tracking

info@dcpweb.co.uk — Sat, 08 May 2021 08:48:00 +0000

In the third part of this small business bookkeeping video tutorial, I will show you how to keep track of your company’s expenditures.

We will create an Excel Spreadsheet which will simply allow us to keep track of all costs in our business – bookkeeping training.

Bookkeeping for Small Business – Excel Tutorial – Part 3 – Expenditure Tracking video tutorial

The Excel expenditure spreadsheet Will track the following information:

Invoice date
date paid
Company name
Payment Type
Cost
other Currencies
Notes

We will use colour codes and highlight rows in different colours to visually track different types of costs in our business.

Using the spreadsheet should also reduce your business accountant costs as you will be able to provide a comprehensive spreadsheet that is fully documented for your company’s yearly expenditure.

This should save your accountant time and result in lower accountancy fees.

Watch my free video tutorial for small business bookkeeping part 3 – Expenditure Tracking.

Video tutorial - Bookkeeping for Small Business - Excel Tutorial - Part 3

Bookkeeping for Small Business – Excel Tutorial – Part 3

Bookkeeping for Small Business FAQs

What type of costs can I track in Excel?

Using the expenditure tracking spreadsheet in this tutorial should allow you to track any type of expense in your business.

It is also possible to create different cost-tracking spreadsheets for types of expenditure.

For example:

Petty Cash
Staff Wages
Fuel Costs
General Business Costs

Personally, I prefer to track all business costs in a single spreadsheet.

How often should the expenditure tracking spreadsheet be updated?

I would recommend as often as possible, at a minimum, you should aim to keep track of business costs on a weekly basis.

Also, updating your bookkeeping on a regular basis will help if you need to complete VAT returns.

What are the alternatives to this small business bookkeeping solution?

There are many paid monthly subscription accounting software applications like Xero or Quick Books which you can use to track not only the costs in your business but also other aspects as well.

The goal of this tutorial is to try and help you to keep your costs as low as possible. This is important if you are a small start-up business.

The cost you save can then be used for other marketing solutions like building a professional website design or social media marketing.

It would be a good idea to speak to your accountant and find out if this bookkeeping solution will help you to save on account fees.

If you are running an eCommerce business then it is worth investing in Quick Books or Xero which can directly integrate into your WooCommerce Shop or Shopify websites.

Tip: Make sure you update the expenditure tracker as often as possible to ensure your bookkeeping data is accurate.

View the other Excel bookkeeping tutorials.

See how my company can build an amazing website for your business

Custom web design
Secure and fast website solution
Full management training
Take control of your website
SEO optimisation
Reliable web hosting and emails

Bookkeeping video tutorial by: DCP Web Designers in London

The post Bookkeeping for Small Business – Excel Tutorial – Part 3 – Expenditure Tracking appeared first on DCP.

Bookkeeping for Small Business – Excel Tutorial – Part 2 – Invoice Template – Bookkeeping Training

info@dcpweb.co.uk — Fri, 07 May 2021 08:53:00 +0000

In the second part of this small business bookkeeping video tutorial, I will show you how to create a custom invoice template using Microsoft Excel. I will also show you how to add formulas for automatic calculations.

We will replicate the invoice template to create new client invoices, I will also show you how to save the Excel invoice into PDF format so you can simply email invoices to your clients.

Bookkeeping for Small Business – Excel Tutorial – Part 2 – Invoice Template video tutorial

Our first goal in this bookkeeping tutorial is to create a blank spreadsheet and save the file as a template. We will then fix the margin to give us more space. Next, we will add our company address and logo to the header of the document spreadsheet invoice template.

Once the header is completed, we will start the processing of laying out content for the main invoice body. We will add our banking details so clients can easily make bank transfers for payments.

I will then show you how to add your company number and VAT number to the footer of the document. Now the template is completed, I will show you how to copy the template and enter data to create a new customer invoice.

We will enter data from the invoice tracker template we created in part 1 of this tutorial, I will also show you how to create some basic formulas to speed up data entry. Finally, we will save the document as a PDF file which we can email to the customer.

Watch my free video tutorial for small business bookkeeping part 2 – Invoice Template.

Video tutorial - Bookkeeping for Small Business - Excel Tutorial - Part 2

Bookkeeping for Small Business – Excel Tutorial – Part 2

Bookkeeping for Small Business FAQs

Can I reuse the invoice design?

Yes, in this tutorial we will create an invoice template that can be re-used many times to quickly generate new invoices.

What is the best file format for sending invoices?

I would recommend sending all invoices in PDF format. In this tutorial, I will show you how to export invoices into PDF files.

Should I create Excel invoices in Landscape or Portrait format?

I would recommend creating all invoices in portrait format, using this format will allow you to get more line items in your invoice.

What are the alternatives to this small business bookkeeping solution?

Note, there are monthly subscription accounting software applications like Xero or Quick Books. which also allows you to generate invoices that can be sent to customers via email.

The goal of this tutorial is to try and keep your costs as low as possible for a small start-up business.

In the long run, it is probably worth investing in accounting software when your business grows and you’re seeing substantial profits.

It would be a good idea to speak to your accountant and find out what software applications they recommend such as Xero or QuickBooks.

Xero or QuickBooks and other accountancy software can be easily integrated into WooCommerce or Shopify websites.

Tip: Make sure you update the invoice number and date to keep an accurate tracking system for invoices.

View the other Excel bookkeeping tutorials.

See how my company can build an amazing website for your business

Custom web design
Secure and fast website solution
Full management training
Take control of your website
SEO optimisation
Reliable web hosting and emails

Bookkeeping video tutorial by: DCP Web Designers in London

The post Bookkeeping for Small Business – Excel Tutorial – Part 2 – Invoice Template – Bookkeeping Training appeared first on DCP.

Bookkeeping for Small Business – Excel Tutorial – Part 1 – Invoice Tracking – Bookkeeping Training

info@dcpweb.co.uk — Thu, 06 May 2021 08:57:00 +0000

In the first part of this small business bookkeeping video tutorial, I will show you how to keep track of invoices that you have sent to your clients.

Bookkeeping for Small Business – Excel Tutorial – Part 1 – Invoice Tracking video tutorial

In this video tutorial, we will use colour codes and highlight rows in green which are paid invoices and rows in blue which are still outstanding. This helps us to quickly check outstanding invoices.

I will also show you how to use the auto sum function to calculate your total expected income, the total amount paid to date and the total amount which is outstanding.

Watch my free video tutorial for small business bookkeeping part 1 – Invoice Tracking.

Bookkeeping for Small Business – Excel Tutorial – Part 1

Bookkeeping for Small Business FAQs

What are the spreadsheet headers required for a bookkeeping spreadsheet?

In this tutorial we will use the following headers Excel Column Headers:

Invoice Date
Invoice No
Date Paid
Payment Type
Reference
Description
Company Name
Location
Cost
Paid

Can Excel help to reduce bookkeeping costs?

Using the spreadsheet should also reduce your business accountant costs as you will be able to provide a comprehensive spreadsheet that is fully documented for income into your business.

This should save your accountant time and result in lower accountancy fees. bookkeeping training.

Once you’ve mastered this bookkeeping software tutorial then you’ll be less reliant on third-party applications.

Can I track outstanding payments?

The most important is for you to understand what income is coming into your business and keep track of outstanding invoices which you need to follow up on. In this tutorial, we will cover both aspects.

What about tracking payment on an eCommerce shop?

If you’re planning on building an online e-commerce website store then it may be worth looking at third-party software solutions for bookkeeping such as Xero or Quick Books.

Xero or QuickBooks Books and other accountancy software can be easily integrated into e-commerce solutions like WooCommerce or Shopify.

In the long run, this should save you time so you can focus on your you’re my main goal which is to sell products.

Tip: Make sure you update bookkeeping spreadsheets on a weekly or monthly basis, trust me it will save you a lot of headaches later. Remember to file hard copies of your invoices and receipts in date order.

View the other Excel bookkeeping tutorials.

See how my company can build an amazing website for your business

Custom web design
Secure and fast website solution
Full management training
Take control of your website
SEO optimisation
Reliable web hosting and emails

Bookkeeping video tutorial by: DCP Web Designers in London

The post Bookkeeping for Small Business – Excel Tutorial – Part 1 – Invoice Tracking – Bookkeeping Training appeared first on DCP.

VAT Bookkeeping Tutorial – Small Business – Expenditure Tracker – Part 3

info@dcpweb.co.uk — Sat, 13 Jun 2015 12:00:00 +0000

(Click the image above to watch the video tutorial)

This is a free VAT Booking Keeping Tutorial for small businesses. In this 3rd tutorial, we will focus on creating an Expenditure Tracker spreadsheet.

Keeping track of business expenditures is essential for any small business. From years of experience, I have found that simply creating a well-documented spreadsheet should help you to understand your daily, weekly, monthly and yearly business expenditures.

This document is also very useful when you need to hand in your end-of-year accounts to your accountant.

This document will give your accountant a quick overview of your business expenditure and save time and cost as all your expenditures have already been documented.

If you would like to learn more about Open Office 4 then take a look at our other free Open Office 4 tutorials.

Subscribe to DCP YouTube for more free Bookkeeping video tutorials.

# Small Business VAT Bookkeeping Tutorial

# VAT bookkeeping spreadsheet tutorial

# VAT bookkeeping tutorial

VAT business bookkeeping video tutorial by: DCP Web Designers London

The post VAT Bookkeeping Tutorial – Small Business – Expenditure Tracker – Part 3 appeared first on DCP.

VAT Bookkeeping Tutorial – Small Business – Invoice Template – Part 2

info@dcpweb.co.uk — Mon, 08 Jun 2015 13:27:00 +0000

(Click the image above to watch the video tutorial)

This is a free VAT Booking Keeping Tutorial for small businesses. In this 2nd tutorial, we will focus on creating a VAT Invoice Template.

Designing an invoice template can be a little bit tricky when you’re not fully understanding all of the components required. In this tutorial, we will use OpenOffice Calc to design a custom VAT invoice template which you can reuse multiple times to send out invoices to your customers.

At DCP we use a simple invoice spreadsheet template and convert it into a PDF file before sending invoices to our customers.

Watch this video tutorial and create your very own VAT invoice template for your business today!

If you would like to learn more about Open Office 4 then take a look at our other free Open Office 4 tutorials.

Subscribe to DCP YouTube for more free Bookkeeping video tutorials.

# business invoice

# bookkeeping tutorial

# vat invoice template spreadsheet

VAT bookkeeping business video tutorial by: DCP London Web Designers

The post VAT Bookkeeping Tutorial – Small Business – Invoice Template – Part 2 appeared first on DCP.

VAT Bookkeeping Tutorial – Small Business – Invoice Tracker – Part 1

info@dcpweb.co.uk — Mon, 08 Jun 2015 12:02:00 +0000

(Click the image above to watch the video tutorial)

This is a free VAT Booking Keeping Tutorial for small businesses. In this 1st tutorial, we will focus on Invoice Tracking and calculating VAT.

Keeping track of which customers have paid you is essential for any small business. Understanding which customers you have to chase up for outstanding payments can be very difficult if you’re not keeping track of who has already paid and when.

This video tutorial will focus on creating an invoice tracking spreadsheet, and I will also show you how to calculate VAT automatically using a custom spreadsheet formula.

If you would like to learn more about Open Office 4 then take a look at our other free Open Office 4 tutorials.

Subscribe to DCP YouTube for more free Bookkeeping video tutorials.

# VAT Bookkeeping Tutorial

# business bookkeeping open office

# business bookkeeping invoice tracker

VAT bookkeeping video tutorial by: DCP Web Design London

The post VAT Bookkeeping Tutorial – Small Business – Invoice Tracker – Part 1 appeared first on DCP.

Bookkeeping for small business tutorial part 2 – open office calc spreadsheets – invoice template

info@dcpweb.co.uk — Sat, 23 Aug 2014 13:43:00 +0000

(Click the image above to watch the video tutorial)

This is a free video tutorial for small business bookkeeping – part 2 – open office calc spreadsheets – invoice template design.

In this 2nd bookkeeping, the tutorial will focus on designing a custom invoice template. We will create the invoice template from a blank spreadsheet document, the goal is not only to develop a custom invoice but also to give you a better understanding of how to layout documents using Open Office Calc.

We will also add a business logo, business address, business phone number, unique invoice number, invoice date, customer billing details, customer delivery details, line items (the work you did for a customer), invoice total amount, payment terms and your business registration details. This invoice template will work in tandem with your invoice tracker which we created in the first tutorial.

In the final tutorial, you will create a spreadsheet to track your business expenditure.

Subscribe to DCP YouTube for more free business bookkeeping video tutorials.

# Invoice template

# OpenOffice invoice template

Business bookkeeping video tutorial by: DCP Web Designers London

The post Bookkeeping for small business tutorial part 2 – open office calc spreadsheets – invoice template appeared first on DCP.

Bookkeeping for small business tutorial part 1 – open office calc spreadsheets

info@dcpweb.co.uk — Sat, 23 Aug 2014 13:35:00 +0000

(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

# bookkeeping tutorial for beginners

# bookkeeping training YouTube

Business bookkeeping video tutorial by: DCP Website Design

The post Bookkeeping for small business tutorial part 1 – open office calc spreadsheets appeared first on DCP.

Small Business Bookkeeping Tutorials - DCP

How to Create an Invoice Template in Excel

What you will learn in this video tutorial:

Tutorial Goals

Other useful Excel tutorials:

Bookkeeping for Small Business – Excel Tutorial – Part 4 – VAT Calculations

Bookkeeping for Small Business – Excel Tutorial – Part 4 – VAT Calculations video tutorial

Video Tutorial Content

Video tutorial - Bookkeeping for Small Business - Excel Tutorial - Part 4

Bookkeeping for Small Business FAQs

What is the correct formula for calculating VAT in Excel?

Is there a free tool to check VAT calculations online?

Add VAT Calculator Demo

What are the alternatives to this small business bookkeeping solution?

Bookkeeping for Small Business – Excel Tutorial – Part 3 – Expenditure Tracking

Bookkeeping for Small Business – Excel Tutorial – Part 3 – Expenditure Tracking video tutorial

Video Tutorial Content

Video tutorial - Bookkeeping for Small Business - Excel Tutorial - Part 3

Bookkeeping for Small Business FAQs

What type of costs can I track in Excel?

How often should the expenditure tracking spreadsheet be updated?

What are the alternatives to this small business bookkeeping solution?

Bookkeeping for Small Business – Excel Tutorial – Part 2 – Invoice Template – Bookkeeping Training

Bookkeeping for Small Business – Excel Tutorial – Part 2 – Invoice Template video tutorial

Video Tutorial Content

Video tutorial - Bookkeeping for Small Business - Excel Tutorial - Part 2

Bookkeeping for Small Business FAQs

Can I reuse the invoice design?

What is the best file format for sending invoices?

Should I create Excel invoices in Landscape or Portrait format?

What are the alternatives to this small business bookkeeping solution?

Bookkeeping for Small Business – Excel Tutorial – Part 1 – Invoice Tracking – Bookkeeping Training

Bookkeeping for Small Business – Excel Tutorial – Part 1 – Invoice Tracking video tutorial

Video Tutorial Content

Video tutorial - Bookkeeping for Small Business - Excel Tutorial - Part 1

Bookkeeping for Small Business FAQs

What are the spreadsheet headers required for a bookkeeping spreadsheet?

Can Excel help to reduce bookkeeping costs?

Can I track outstanding payments?

What about tracking payment on an eCommerce shop?

VAT Bookkeeping Tutorial – Small Business – Expenditure Tracker – Part 3

VAT Bookkeeping Tutorial – Small Business – Invoice Template – Part 2

VAT Bookkeeping Tutorial – Small Business – Invoice Tracker – Part 1

Bookkeeping for small business tutorial part 2 – open office calc spreadsheets – invoice template

Bookkeeping for small business tutorial part 1 – open office calc spreadsheets