Pankaj Shah

I hope you enjoy reading our blog posts. If you want DCP to build you an awesome website, click here.

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

08-05-2021

Back

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

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

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, update 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 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.



Bookkeeping video tutorial by: DCP Web Designers in London


Tell Us Your Thoughts

Thank you for contacting us.
We will reply to you in next 2 working days.


Releated Posts


Libre Office Calc - Array Formulas and Functions - Part 1

02-11-2018

Libre Office Calc - Array Formulas and Functions - Part 1

In this video tutorial, I will show you how to use Libre Office Calc Array Formulas and Functions. Array Formulas and Functions can speed up the tasks when using spreadsheets. When you have to analyse data in a spreadsheet, Array Formulas and Functions can help proceed data more efficiently.

How to change Google Chrome Background | How to Customise Chrome Browser

09-04-2021

How to change Google Chrome Background

In this video tutorial, I will show you how to change Google Chrome Background. Did you know that you can change your Google Chrome Background with a few simple mouse clicks? Why not add your business logo to an image or use a holiday photo for a nice custom chrome background?

Windows 10 Tip & Tricks Tutorial - Part 1

06-08-2018

Windows 10 Tip & Tricks Tutorial - Part 1

In this video tutorial, I will show you some useful windows Windows 10 Tip & Tricks Tutorial. These tips will help you work efficiently when using Window 10 in desktop mode. Speed up your workflow by simply watching the video above!

Windows 10 Creator - Application Folders Tutorial

08-05-2017

Windows 10 Creator - Application Folders Tutorial

This is a free video tutorial. In this video tutorial, I will show you how to organise your applications on Windows 10 Creator. I recently downloaded the latest version of Windows 10 Creator and found some great new features which I hope you will find useful as well. In this tutorial, I will cover the first feature and show you how to create application folders on your Windows 10 start menu.

GET YOUR FREE QUOTE


CLAIM YOUR 2 HOURS

FREE CONSULTANCY


  • AFFORDABLE PRICING
  • 15 YEAR KNOWLEDGE
  • LONDON BASED DESIGN AGENCY

NO OBLIGATION QUOTE

arrow
Please enter your name
Please enter correct email
Please enter your phone number
Please enter your message

Your data is encrypted and never shared.
View our privacy policy.

Thank you for contacting us.
We will reply to you in next 2 working days.

back