I hope you enjoy reading our blog posts. If you want DCP to build you an awesome website, click here.
07-05-2021
BackIn 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.
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
In this tutorial we will use the following headers Excel Column Headers:
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.
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.
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
Thank you for contacting us.
We will reply to you in next 2 working days.
07-05-2021
Bookkeeping for Small Business - Excel Tutorial - Part 2 - Invoice Template - Bookkeeping Training
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.
12-08-2017
How to save RFT document as JPG file
In this video tutorial will show you how to save RFT documents as JPG files. In some cases, you may want to save a text-based document as an image file which can be e-mailed or uploaded to your website. The text-based file can be edited but the JPEG file will be an image so the content cannot be manipulated.
23-08-2014
Bookkeeping for small business tutorial part 3 - open office calc spreadsheet - expenditure tracking
In this final tutorial (I hope you made it this far) we will focus on creating an expenditure tracking spreadsheet. Wouldn't it be great if you could look at the spreadsheet and find out how much you have spent on fuel over a period of a month or year? Or how much you have spent on telephone bills or broadband costs?
Thank you for contacting us.
We will reply to you in next 2 working days.