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 1 - Invoice Tracking - Bookkeeping Training

07-05-2021

Back

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 - Bookkeeping Training

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.

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

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?

Most important is for you to understand what income is coming into your business and keep track of outstanding invoices which you need to chase up. 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 Quick 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.



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


How to email large files using We Transfer

20-07-2017

How to email large files using We Transfer

In this video tutorial, I will show you how to email large files using we transfer. Has anyone ever sent you an e-mail with crazy large attachments which take absolutely ages to download? This can be very frustrating when you turn your computer on in the morning and have to wait for all your e-mails to download which contain large files as attachments. To get around this problem you can send large files using We Transfer.

How to convert Mac pages document to Microsoft Word document

17-03-2018

How to convert Mac pages document to Microsoft Word document

In this video tutorial, I will show you how to convert Mac Pages document to Microsoft Word document. Sometimes a client will send you a formatted document which you can simply not open, in most cases this is a compatibility issue between Windows and Apple Mac software.

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

08-05-2021

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

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.

How to create a CSV file using LibreOffice Calc

02-11-2018

How to create a CSV file using Libre Office Calc

In this video tutorial, I will show you how to create a CSV file using Libre Office Calc CSY stands for "Comma Separated Values". I often use CSV files when uploading data to third-party websites. CSV files can be opened in LibreOffice Calc, Open Office Calc, and Microsoft Excel.

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