The Bookkeeping Channel
The Bookkeeping Channel
  • 271
  • 2 346 940
How to Do Your Bookkeeping in Excel | EASY to Use Template for SMALL BUSINESS
Grab a copy of our Easy Bookkeeping Template right here: bit.ly/3zdSPi6
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Doing your bookkeeping in Excel is easier than you think! Discover a streamlined approach to organising your finances with our easy to use template. Whether you're a small business owner, freelancer, or simply looking to manage personal expenses, our Excel template is for you.
In this video, we'll show you how to utilise our Excel template effectively. From setting up categories and entering data to generating insightful reports and summaries, you'll learn how to easily do your bookkeeping in Excel. Our template simplifies complex calculations and ensures accurate financial records without the need for expensive software.
Grab a copy now and transform your bookkeeping with our user-friendly Excel template.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Please note that the owners of this UA-cam channel and any associated media channels, websites, templates, courses and other products are not financial or tax advisers. Our videos are here to inform you and the information provided does not constitute financial, taxation, legal, business or other professional advice and should not be relied upon as such. The owners of this channel are not liable or responsible for any financial, tax, legal, business or other decisions you make. If you are looking for advice, you should seek a suitable and qualified adviser.
Переглядів: 624

Відео

How to SUM a Row or a Column in Excel QUICKLY
Переглядів 5492 місяці тому
Learn how to quickly add up numbers in rows or columns in your Microsoft Excel spreadsheets with the SUM function. Click here to download the Excel template: bit.ly/4ax882x ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Please note that Bullseyemoney is not a financial or tax adviser. Our videos are here to inform you and the information provided does not constitute financial, taxation, legal, business or other profess...
Excel SUMIFS Function with Multiple Criteria | Beginners Tutorial
Переглядів 4272 місяці тому
Learn how to add up data in Microsoft Excel based on multiple criteria with the SUMIFS function. Click here to download the Excel template: bit.ly/4cFE46L ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Please note that Bullseyemoney is not a financial or tax adviser. Our videos are here to inform you and the information provided does not constitute financial, taxation, legal, business or other professional advice and s...
How to Use The Excel SUMIF Function - Beginners Tutorial
Переглядів 2222 місяці тому
Find out how to use the SUMIF function in Microsoft Excel to add up values in your spreadsheet based on one criteria. Click here to download the Excel template: bit.ly/3PKCtmy ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Please note that Bullseyemoney is not a financial or tax adviser. Our videos are here to inform you and the information provided does not constitute financial, taxation, legal, business or other prof...
Excel SUM Function - Explained for BEGINNERS
Переглядів 1722 місяці тому
Find out how to use the SUM function in Microsoft Excel to add up the values in several different cells. Click here to download the Excel template: bit.ly/3IYwmXR ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Please note that Bullseyemoney is not a financial or tax adviser. Our videos are here to inform you and the information provided does not constitute financial, taxation, legal, business or other professional advi...
Excel - How to Merge and Unmerge Cells
Переглядів 1543 місяці тому
Learn how to merge cells and unmerge cells in Microsoft Excel across multiple rows and columns. Click here to download the Excel template: bit.ly/3w9Woo2 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Please note that Bullseyemoney is not a financial or tax adviser. Our videos are here to inform you and the information provided does not constitute financial, taxation, legal, business or other professional advice and sh...
How to Freeze Multiple Rows and Columns in Excel | Freeze Panes
Переглядів 1573 місяці тому
Find out how to freeze the top row or left column or multiple rows and columns in Excel with Freeze Panes. Click here to download the Excel template: bit.ly/3OEylnu ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Please note that Bullseyemoney is not a financial or tax adviser. Our videos are here to inform you and the information provided does not constitute financial, taxation, legal, business or other professional ad...
Excel - How to Change, Adjust or Resize Row Height & Column Width
Переглядів 1553 місяці тому
Find out several different ways to adjust, change, resize or equalise row height and column width in Excel. ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Please note that Bullseyemoney is not a financial or tax adviser. Our videos are here to inform you and the information provided does not constitute financial, taxation, legal, business or other professional advice and should not be relied upon as such. Bullseyemoney...
Learn Xero in 27 Minutes | Crash Course for Beginners
Переглядів 3,6 тис.3 місяці тому
👉 Master Xero without getting stuck with The Ultimate Xero Course for Australia: bit.ly/4e4MghD ►► Do you wish you could get step-by-step instructions for setting up and using Xero quickly and easily? ►► Do you want clear explanations in plain English with all the information in one place? ►► Do you want to feel confident that you’re doing it right? 🚀 Then check out the step-by-step program for...
Excel - How to Hide and Unhide Rows and Columns
Переглядів 1943 місяці тому
Find out how to hide and unhide columns and rows in Excel. You can hide or unhide one row or column or multiple rows and columns at the same time. Click here to download the Excel template: bit.ly/49OeGtB ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Please note that Bullseyemoney is not a financial or tax adviser. Our videos are here to inform you and the information provided does not constitute financial, taxation, ...
Excel - How to Insert a Row or Multiple Rows
Переглядів 1553 місяці тому
Find out how to insert one row or more than one row in Excel even if the rows are not next to each other. Click here to download the Excel template: bit.ly/489KyYj ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Please note that Bullseyemoney is not a financial or tax adviser. Our videos are here to inform you and the information provided does not constitute financial, taxation, legal, business or other professional adv...
Excel - How to Insert a Column or Multiple Columns
Переглядів 1493 місяці тому
Find out how to insert one column or more than one column in Excel even if the columns are not next to each other. Click here to download the Excel template: bit.ly/49qT6Lu ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Please note that Bullseyemoney is not a financial or tax adviser. Our videos are here to inform you and the information provided does not constitute financial, taxation, legal, business or other profess...
Excel - How to Delete a Row or Multiple Rows
Переглядів 1063 місяці тому
Find out how to select and delete one row or more than one row in Excel even if the rows are not next to each other. Click here to download the Excel template: bit.ly/3UpJXOW ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Please note that Bullseyemoney is not a financial or tax adviser. Our videos are here to inform you and the information provided does not constitute financial, taxation, legal, business or other profe...
Excel - How to AutoFit Columns & Rows & Tables | Auto Fit Cell Size to Text
Переглядів 5303 місяці тому
Find out how to AutoFit columns and rows to your data in Excel. Click here to download the Excel template: bit.ly/3UvyugF ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Please note that Bullseyemoney is not a financial or tax adviser. Our videos are here to inform you and the information provided does not constitute financial, taxation, legal, business or other professional advice and should not be relied upon as such....
Excel - How to Delete a Column or Multiple Columns
Переглядів 2513 місяці тому
Find out how to select and delete one column or more than one column in Excel even if the columns are not next to each other. Click here to download the Excel template: bit.ly/3wamTJV ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Please note that Bullseyemoney is not a financial or tax adviser. Our videos are here to inform you and the information provided does not constitute financial, taxation, legal, business or ot...
Excel - How to Copy and Paste Multiple Rows or Columns
Переглядів 9453 місяці тому
Excel - How to Copy and Paste Multiple Rows or Columns
What are Liabilities in Accounting?
Переглядів 3603 місяці тому
What are Liabilities in Accounting?
Excel - Select Different or Multiple Cells, Columns and Rows at the Same Time
Переглядів 1283 місяці тому
Excel - Select Different or Multiple Cells, Columns and Rows at the Same Time
Excel - Recover PREVIOUS VERSION of a SAVED OVER File in Excel 365
Переглядів 6423 місяці тому
Excel - Recover PREVIOUS VERSION of a SAVED OVER File in Excel 365
Excel - How to SPLIT a Cell into TWO PARTS Diagonally
Переглядів 4814 місяці тому
Excel - How to SPLIT a Cell into TWO PARTS Diagonally
How to Enable and Disable AutoSave in Excel
Переглядів 1,2 тис.4 місяці тому
How to Enable and Disable AutoSave in Excel
What are Assets in Accounting?
Переглядів 3644 місяці тому
What are Assets in Accounting?
How to Change Cell Size in Excel | Adjust to Increase or Decrease Size
Переглядів 1744 місяці тому
How to Change Cell Size in Excel | Adjust to Increase or Decrease Size
Excel - How to Recover an Unsaved File
Переглядів 1204 місяці тому
Excel - How to Recover an Unsaved File
T-Accounts Explained
Переглядів 5664 місяці тому
T-Accounts Explained
The Five Account Types in Accounting - How to Choose Debit or Credit
Переглядів 6834 місяці тому
The Five Account Types in Accounting - How to Choose Debit or Credit
Understanding Debits and Credits in Accounting
Переглядів 6154 місяці тому
Understanding Debits and Credits in Accounting
Excel - Disconnect, Remove or Unlink OneDrive | Save to Computer Instead
Переглядів 2844 місяці тому
Excel - Disconnect, Remove or Unlink OneDrive | Save to Computer Instead
How to Save an Excel File to OneDrive
Переглядів 3484 місяці тому
How to Save an Excel File to OneDrive
Double Entry Accounting System - an Introduction
Переглядів 6064 місяці тому
Double Entry Accounting System - an Introduction

КОМЕНТАРІ

  • @undead-0075
    @undead-0075 16 годин тому

    If i buy, repair and sell cars, should projects be the right approach?

  • @lunamorris2091
    @lunamorris2091 День тому

    It is a great video thanks for the great information and well delivered. This is exactly what I was looking for.

  • @andrwwaugh
    @andrwwaugh 4 дні тому

    I wish this was better integrated with hubdoc, I'm giving projects a show, but this part of it is so slow... one at a time, categorising multiple recent expenses into projects...

  • @امیربلوچ-ر5ح
    @امیربلوچ-ر5ح 4 дні тому

    🎉jjj

  • @AbdussamadAhmadIbrahimArgungu
    @AbdussamadAhmadIbrahimArgungu 5 днів тому

    Direct to the point and viewer friendly explanation. Keep up the good work

  • @pinedajhames4355
    @pinedajhames4355 8 днів тому

    today there is no payroll settings, its just pay run settings and no tracking category to set in payrolls

  • @aampudia8
    @aampudia8 11 днів тому

    exactly what I was looking for!! now, is there a way to avoid someone from turning on all connected experiences again???

  • @luannemeyers8384
    @luannemeyers8384 13 днів тому

    thanks for the basics

  • @Writersexchange-ebooks
    @Writersexchange-ebooks 15 днів тому

    I am trying to decide between tracking categories and projects to see how different areas of our business are performing, so we can make proactive business decisions. We need to track a pretty large number of different options (home user, business customer, contract customer, computer repairs or new sales, phone repair viability, shop costs [to keep track that keeping a shopfront is still best] etc etc. Tracking categories makes sense, but is so limited in number, projects is unlimited but is it designed to work to track overall things like this? You did say you could make projects that are for different customers... Anyone have any experience in this kind of use?

    • @TheBookkeepingChannel
      @TheBookkeepingChannel 12 днів тому

      Tracking categories would be better than projects for that purpose. But yes, it is limited in Xero.

  • @Gener1KGaming
    @Gener1KGaming 15 днів тому

    This guy is a legend. Thank you for making this video

  • @TobiasTheWolf
    @TobiasTheWolf 15 днів тому

    Do you have a video that explains how we as an employer actually pay the withholding tax for our employees? I mean how do we do it? Do we go to the ato office and give them a bunch of cash?

    • @TheBookkeepingChannel
      @TheBookkeepingChannel 12 днів тому

      You pay it through your BAS and IAS returns. You can either process the returns through software like Xero or you can log into your business' ATO portal and manually process each return. After processing, you should be able to pay by BPAY, bank transfer or something else. If you call the ATO they'll be able to provide more info.

  • @aliceghlez6280
    @aliceghlez6280 16 днів тому

    Can I register as a sole trader from now and start to sell until November/ December? Do you know if I have to pay something before? Thanks a million

  • @workinghonlon
    @workinghonlon 18 днів тому

    Please excuse me if this is a silly question, but what is considered measurable?

  • @user-te1oi7pg6x
    @user-te1oi7pg6x 18 днів тому

    helpful videos! anymore coming soon?

    • @TheBookkeepingChannel
      @TheBookkeepingChannel 9 днів тому

      Lots and lots. Just had a little break for a while but I'm getting back into it now. Let me know if there's anything specific you want videos about.

  • @user-uv8tk3nj3i
    @user-uv8tk3nj3i 18 днів тому

    Excellent

  • @allumolujanardhan9203
    @allumolujanardhan9203 19 днів тому

    Good information in a simple way

  • @jamesperkins1699
    @jamesperkins1699 19 днів тому

    Hi, I added my bank accounts and started the automatic feeds. I made an error and started the transactions import starting from June 1 but i should have started from my tax year which is 5 April. Is there anyway I can get the feeds to import for April and May? Any help would be appreciated.

  • @fan2257
    @fan2257 19 днів тому

    Pls start videos on ACCA syllabus. Plsssssssssss

  • @SanjayaSilva-fr3oo
    @SanjayaSilva-fr3oo 20 днів тому

    Excellent material

  • @nannogray4412
    @nannogray4412 20 днів тому

    U save me, I was about to pay for Spreadsheet of this stuff but through this video I have learned that you can get it free thank U god bless

  • @leahgwenromo2975
    @leahgwenromo2975 20 днів тому

    Hi, can I have a copy of Microsoft excel template

  • @adenubiabdulafeez8455
    @adenubiabdulafeez8455 20 днів тому

    well done, very informative, really benefited from the ordinary time earnings set up, used the idea to set up weekend rates, etc

  • @jamesperkins1699
    @jamesperkins1699 21 день тому

    Hi, I am thinking in purchasing Xero but have a few questions. I have 2 companies which come under the same umbrella so would I be able to have 2 different bank accounts set up on xero and would the software separate the two different bank accounts when it produces the figures?

    • @TheBookkeepingChannel
      @TheBookkeepingChannel 12 днів тому

      Yes you can have two different bank account feeds in one Xero subscription.

  • @TobiasTheWolf
    @TobiasTheWolf 21 день тому

    Really good video. I would though like to see a sequel where you give us a a step by step walk through if someone starting a businesses and going through the process of making and paying their payg obligations. Like a short story

  • @Welshshedman
    @Welshshedman 21 день тому

    Great video Mark. Very helpful and much appreciated

  • @anmolwaraich2032
    @anmolwaraich2032 23 дні тому

    good

  • @ankeet1
    @ankeet1 23 дні тому

    Is there a way to edit the receipt template?

  • @ankeet1
    @ankeet1 23 дні тому

    Why wouldn't Xero have this easy 2-minute tip easily accessible and available in their Q&A! Thanks for this video, it helped.

  • @marcoramboyong4339
    @marcoramboyong4339 24 дні тому

    Thanks bro

  • @elisabethlasser9574
    @elisabethlasser9574 24 дні тому

    I have set up the payroll and checked the setup 10 times over. I don't get the default assign leave type box to click on. I get the assign leave box only, however, in the drop-down menu, I don't have the option for annual or sick/carers leave to apply. They are set up however simply don't appear to be applied. Why is that so?

  • @TheBookkeepingChannel
    @TheBookkeepingChannel 24 дні тому

    👉 Master Xero without getting stuck with The Ultimate Xero Course for Australia: bit.ly/4e4MghD ►► Do you wish you could get step-by-step instructions for setting up and using Xero quickly and easily? ►► Do you want clear explanations in plain English with all the information in one place? ►► Do you want to feel confident that you’re doing it right? 🚀 Then check out the step-by-step program for business owners to master Xero without getting stuck: bit.ly/4e4MghD

  • @loriwilliams8302
    @loriwilliams8302 24 дні тому

    This is the most straight-forward, easy to follow tutorial I have ever seen. Thank you!

  • @proc7768
    @proc7768 25 днів тому

    I like your accounting videos and was excited to watch your excel ones too, but why are you not going over shortcuts? Don’t really find value in an excel video without that.

  • @pw3858
    @pw3858 28 днів тому

    The whole idea ruined freelancing.

  • @Kelly-yy8ne
    @Kelly-yy8ne 28 днів тому

    Thanks

  • @skimmy90
    @skimmy90 Місяць тому

    What are examples of "Goodwill"?

  • @xihazem4233
    @xihazem4233 Місяць тому

    Thank you, really apreciate your content 👍

  • @Active-8-Wellness
    @Active-8-Wellness Місяць тому

    Very detailed. Thank you

  • @RamazanGurpnar-rt1bt
    @RamazanGurpnar-rt1bt Місяць тому

    is that usa or uk

  • @alinabutu2879
    @alinabutu2879 Місяць тому

    Excellent video and English speaking!!!Thank you very much!:)

  • @halleluyastudio
    @halleluyastudio Місяць тому

    why is the profit/loss always positive?

  • @nishaanitha526
    @nishaanitha526 Місяць тому

    Thank you so much

  • @Harleysypremecy
    @Harleysypremecy Місяць тому

    OMGGGG, THANK YOUUUU. I have an EMS exam tomorrow, and this helped A TON!

  • @kimmyyu2369
    @kimmyyu2369 Місяць тому

    Thank you for helping me to slove the problem!

  • @bonitabester2253
    @bonitabester2253 Місяць тому

    It just doesn't work

    • @andrwwaugh
      @andrwwaugh 4 дні тому

      I thought that at first, the UI is really slow and unintuitive. You have to tick the box, click the "Assign" button (to the right of the project name), and then click the "ok" button.

  • @bonitabester2253
    @bonitabester2253 Місяць тому

    How do you add an existing bill to a project?

  • @madartzgraphics2019
    @madartzgraphics2019 Місяць тому

    Crystal clear, direct to the point and viewer friendly explanation. Keep up the good work!

  • @MCLottotv
    @MCLottotv Місяць тому

    Interesting! I operate a freelance lottery messenger service. I'm currently home based but I want to scale to mobility and work remote.

  • @ammaralsatrawi6546
    @ammaralsatrawi6546 Місяць тому

    This Tutorial is Amazing and Full of Gems Thanks for that I'm more than half way through already

  • @tonia5364
    @tonia5364 Місяць тому

    The quality of your teaching and presentation is better than many paid classes. Thanks so much for all your great content.