Bookkeeping for Small Business - Excel Tutorial - Part 1 - Invoice Tracking - Bookkeeping Training
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. We will create a spreadsheet that will document:
Video Chapters:
00:00 Introduction
00:55 Chapter 1 - Create a new blank Excel spreadsheet
02:24 Chapter 2 - Create column titles
04:42 Chapter 3 - Column cell formatting
06:45 Chapter 4 - Data entry examples
24:54 Chapter 5 - Adding colour tracking
34:30 Chapter 6 - Future payments
41:58 Chapter 7 - Filename convention
45:55 Chapter 8 - Auto filters / AutoSum
Excel Column Headers used in this tutorial:
Invoice Date
Invoice No
Date Paid
Payment Type
Reference
Description
Company Name
Location
Cost
Paid
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.
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.
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 the second part of this tutorial, I will show you how to create a custom invoice template using Microsoft Excel.
Ultimately the goal of this tutorial is to reduce your monthly outgoing fees for accountancy software.
Once you've mastered this bookkeeping software tutorial then you'll be less reliant on third-party applications.
If you're planning on building an online e-commerce 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.
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.
Bookkeeping for Small Business - Excel Tutorial - Part 1 - Invoice Tracking: https://youtu.be/XDnBV-Tlb2g
Bookkeeping for Small Business - Excel Tutorial - Part 2 - Invoice Template: https://youtu.be/Ap4QyvMPuV4
Bookkeeping for Small Business - Excel Tutorial - Part 3 - Expenditure Tracking: https://youtu.be/BS7hs4Isx5I
Bookkeeping for Small Business - Excel Tutorial - Part 4 - VAT Calculations - https://youtu.be/pBTXRNr3qaE
Subscribe to access 600+ video tutorials: https://www.youtube.com/dcpwebdesigners
******************************************************************************************************
Need an awesome website? - Contact DCP Web Designers for a free quote today - https://www.dcpweb.co.uk/business-website-design
******************************************************************************************************
Contact me on:
Instagram: https://www.instagram.com/dcp_web_designers/
Facebook: https://www.facebook.com/dcpwebdesigners/
Pinterest: https://www.pinterest.co.uk/dcpwebdesigners/
LinkedIn: https://www.linkedin.com/in/dcpwebdesigners/
#Bookkeeping #Tutorial #InvoiceTracking #dcpweb
Free tutorials, infographics, articles: https://www.dcpweb.co.uk/blog
bookkeeping for small business, small business accounting, bookkeeping business from home, excel bookkeeping for small business, excel bookkeeping tutorial, excel bookkeeping for business, small business bookkeeping, business bookkeeping, learn bookkeeping, bookkeeping tutorial, bookkeeping basics, bookkeeping training, book keeping & accountancy tutorial, how to do bookkeeping for small business, spreadsheet tutorial, invoice tracking system
Видео Bookkeeping for Small Business - Excel Tutorial - Part 1 - Invoice Tracking - Bookkeeping Training канала DCP Web Designers
Video Chapters:
00:00 Introduction
00:55 Chapter 1 - Create a new blank Excel spreadsheet
02:24 Chapter 2 - Create column titles
04:42 Chapter 3 - Column cell formatting
06:45 Chapter 4 - Data entry examples
24:54 Chapter 5 - Adding colour tracking
34:30 Chapter 6 - Future payments
41:58 Chapter 7 - Filename convention
45:55 Chapter 8 - Auto filters / AutoSum
Excel Column Headers used in this tutorial:
Invoice Date
Invoice No
Date Paid
Payment Type
Reference
Description
Company Name
Location
Cost
Paid
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.
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.
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 the second part of this tutorial, I will show you how to create a custom invoice template using Microsoft Excel.
Ultimately the goal of this tutorial is to reduce your monthly outgoing fees for accountancy software.
Once you've mastered this bookkeeping software tutorial then you'll be less reliant on third-party applications.
If you're planning on building an online e-commerce 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.
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.
Bookkeeping for Small Business - Excel Tutorial - Part 1 - Invoice Tracking: https://youtu.be/XDnBV-Tlb2g
Bookkeeping for Small Business - Excel Tutorial - Part 2 - Invoice Template: https://youtu.be/Ap4QyvMPuV4
Bookkeeping for Small Business - Excel Tutorial - Part 3 - Expenditure Tracking: https://youtu.be/BS7hs4Isx5I
Bookkeeping for Small Business - Excel Tutorial - Part 4 - VAT Calculations - https://youtu.be/pBTXRNr3qaE
Subscribe to access 600+ video tutorials: https://www.youtube.com/dcpwebdesigners
******************************************************************************************************
Need an awesome website? - Contact DCP Web Designers for a free quote today - https://www.dcpweb.co.uk/business-website-design
******************************************************************************************************
Contact me on:
Instagram: https://www.instagram.com/dcp_web_designers/
Facebook: https://www.facebook.com/dcpwebdesigners/
Pinterest: https://www.pinterest.co.uk/dcpwebdesigners/
LinkedIn: https://www.linkedin.com/in/dcpwebdesigners/
#Bookkeeping #Tutorial #InvoiceTracking #dcpweb
Free tutorials, infographics, articles: https://www.dcpweb.co.uk/blog
bookkeeping for small business, small business accounting, bookkeeping business from home, excel bookkeeping for small business, excel bookkeeping tutorial, excel bookkeeping for business, small business bookkeeping, business bookkeeping, learn bookkeeping, bookkeeping tutorial, bookkeeping basics, bookkeeping training, book keeping & accountancy tutorial, how to do bookkeeping for small business, spreadsheet tutorial, invoice tracking system
Видео Bookkeeping for Small Business - Excel Tutorial - Part 1 - Invoice Tracking - Bookkeeping Training канала DCP Web Designers
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Bookkeeping for Small Business - Excel Tutorial - Part 2 - Invoice Template - Bookkeeping TrainingBookkeeping 101: What is it? Why is it Important? How to Get StartedAccounting Spreadsheet [Excel Template] Create it in 15 minutesBasic Concept of Accounting By Saheb Academy - Class 11 / B.COM / CA FoundationMicrosoft Excel Tutorial: 3-Hour MS Excel 2019 Course for Beginners!How to Create a Data Entry Form in Excel With Add, Modify, Delete and Reset (Step-by-step Guide)How To Start Bookkeeping (FREE Template)Microsoft Excel 01 Payroll Part 1 - How to enter data and create formulasEXCEL FOR BEGINNERS, Auditors & AccountantsTop 10 Most Important Excel Formulas - Made Easy!How to keep Inventory using an Excel Spreadsheet - [create your own Template]Accounting Basics Explained Through a StorySimple bookkeeping para sa businessLearn Accounting in 1 HOUR First Lesson: Debits and CreditsBookkeeping 101 | Bookkeeping Basics and Tips for Business OwnersCreate a Bookkeeping Spreadsheet in Excel in 10 minutesIncome and Expenditure Spreadsheet [ Step by Step instructions ]How to Organize Small Business Finances Using Google Docs | Track Side Hustle Money Using Excel EasyFree Bookkeeping Course - Part 1 - Introduction to Double Entry Bookkeeping - #bookkeepingcourseMicrosoft Excel Tutorial - Beginners Level 1