Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Bank Reconciliation & VAT on Excel
Rating: 4.0 out of 5(156 ratings)
607 students

Bank Reconciliation & VAT on Excel

How to use excel spreadsheets to do a bank reconciliation and complete a UK VAT Return
Created byLisa Newton
Last updated 7/2021
English

What you'll learn

  • Perform a bank reconciliation accurately using an Excel cashbook and real transaction data
  • Set up and maintain an Excel cashbook using the correct nominal codes and VAT codes
  • Learn the fundamentals of VAT - codes, rates and UK regulations — and how they apply to bookkeeping records
  • Calculate VAT figures from your cashbook and use them to complete a UK VAT return
  • Use a downloadable cashbook template to practise and apply your skills to real business transactions
  • Understand how Excel-based bookkeeping connects bank records, nominal accounts and VAT reporting

Course content

4 sections • 19 lectures • 1h 40m total length

  • Introduction2:20
  • Intro to the fictitious company example - Flower Power1:42
  • Background to VAT in the UK7:53
  • Skeleton template explained7:51

    Excel bookkeeping template - how to fill it in.

Requirements

  • An interest in accounting - whether you've studied it before or want to know more
  • Be familiar (basic level knowledge) of excel

Description

Bank reconciliations and VAT returns are two of the most essential - and most avoided - tasks in small business bookkeeping. In this course, I'll show you how to handle both confidently using Excel, with a downloadable cashbook template you can start using in your own business straight away.

I'm a bookkeeping entrepreneur with years of hands-on experience working with small businesses, and I designed this course to be practical from the first minute. No theory for its own sake - just the real process, walked through step by step.

You'll learn how to set up and use an Excel cashbook, how to carry out a bank reconciliation correctly, and how to use your cashbook figures to complete a UK VAT return. I cover nominal codes, VAT codes, VAT rates and the regulations you need to understand to get your return right - without needing specialist software.

A downloadable cashbook template is included so you can practise alongside the videos and then adapt it directly for your own bookkeeping.

All you need is a basic level of comfort with Excel - you don't need to be an expert, just familiar with navigating a spreadsheet.

If you're a small business owner doing your own books, a bookkeeper wanting to add Excel-based skills to your toolkit, or a student building practical finance knowledge, this course gives you exactly what you need in under two hours.

Enrol today and take bank reconciliations and VAT returns off your worry list for good.

Who this course is for:

  • Small business owners and sole traders who want to handle their own bank reconciliations and VAT returns in Excel
  • Bookkeepers and accounts assistants who want to add Excel-based bookkeeping to their practical skillset
  • Students of accountancy, finance and bookkeeping who want hands-on VAT and bank rec experience
  • Anyone currently using accounting software who wants to understand what's happening behind the figures

Report abuse