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


The 10 best ways to keep your data secure

07-06-2021

The 10 best ways to keep your data secure

How much do you think your data is worth? No matter what is included in your data, it's worth enough to have corporations, governments, and cybercriminals track your online activity and intercept your data at any time. In other words, your data is worth hundreds to thousands of dollars.

How to write a 1000 word article without ever typing a word

26-07-2017

How to write a 1000 word article without ever typing a word

In this video tutorial, I will use Dragon Speaking Naturally to demonstrate how you can write content for your website without ever tying a single word. Wouldn't it be great if you could type up a 1000 word article without ever touching the keyboard? In this video tutorial, I will show you how I create articles using Dragon speaking naturally.

How to create charts using Libre Office Calc

03-07-2017

How to create charts using Libre Office Calc

In this video tutorial, I will show you how to create charts using Libre Office Calc. Libre Office Calc is a powerful spreadsheet application; best of all Libre Office Calc is free! Libre Office Calc can be used to create a wide range of charts which can be used to show different datasets for your business activities and accounts.

How to Remove Duplicates in Excel 2020 | Excel Spreadsheet Tutorial

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.

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