Description Register on the AWS Certified Database Specialty Exam Preparation (DBS-C01) today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a certificate as proof of your course completion. The AWS Certified Database Specialty Exam Preparation (DBS-C01) course is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablets, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With This Course Receive a digital certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Certificate of Achievement After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for 9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for 15.99, which will reach your doorsteps by post. Method of Assessment You need to attend an assessment right after the completion of this course to evaluate your progression. For passing the assessment, you need to score at least 60%. After submitting your assessment, you will get feedback from our experts immediately. Who Is This Course For The course is ideal for those who already work in this sector or are aspiring professionals. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Course Content Section 01: Introducing Databases Introduction 00:03:00 AWS Database - Specialty Recommended Knowledge 00:04:00 Databases Defined 00:05:00 Relational Databases 00:08:00 Database Management System (DBMS) 00:09:00 Cloud-Based vs. Local Databases 00:07:00 Database Applications 00:07:00 Database Access Languages 00:05:00 Introducing SQL 00:09:00 Reading Data with SQL 00:09:00 Writing Data with SQL 00:06:00 Working with Database Objects 00:07:00 Section 02: Database Services AWS Database Services 00:05:00 Relational Databases (Aurora, Redshift, RDS) 00:10:00 Key-Value (NoSQL) Databases (DynamoDB) 00:07:00 In-Memory Databases (ElastiCache) 00:06:00 Document Databases (Document DB) 00:06:00 Graph Databases (Neptune) 00:04:00 Time Series Databases (Timestream) 00:03:00 Ledger Databases (QLDB) 00:03:00 Instance-Based Database Servers 00:06:00 Access Control and Authentication 00:07:00 Section 03: Database Design Designing Databases 00:07:00 Using an ERD Tool 00:09:00 Designing Database Solutions 00:07:00 Designing for Performance 00:08:00 Designing for Scalability 00:07:00 Designing for Compliance 00:06:00 Planning for Recovery 00:06:00 Planning for High Availability 00:07:00 Planning for Encryption 00:06:00 Section 04: Database Deployment Creating RDS Databases 00:11:00 Connecting to an RDS Database (MySQL Workbench) 00:06:00 Creating DynamoDB Databases 00:07:00 Creating RedShift Databases 00:07:00 Creating DocumentDB Databases 00:07:00 Creating Instance-Based Databases 00:04:00 Creating Databases from the CLI 00:07:00 Automation of Database Creation 00:09:00 Orchestration of Database Creation 00:09:00 Section 05: Database Migration Migration Strategies 00:09:00 Preparing Data for Migration 00:06:00 Preparing the Cloud to Receive Data 00:07:00 Executing Data Migration 00:08:00 Validating Data Migration 00:05:00 Migrating using DMS 00:11:00 Section 06: Managing Databases General Maintenance Processes 00:07:00 Specific Maintenance Tasks 00:08:00 Backup and Restore Strategies 00:06:00 Performing an Unmanaged Database Backup 00:07:00 Performing a Managed Database Backup 00:05:00 Performing a Restoration 00:05:00 Section 07: Managing Database Services Managing RDS 00:08:00 Managing DynamoDB 00:04:00 Managing Redshift 00:05:00 Managing Other Databases 00:06:00 General Operational Environment Management 00:07:00 Section 08: Monitoring Database Solutions Introduction to Monitoring 00:06:00 AWS Alert Services 00:07:00 Using CloudWatch 00:08:00 Using Third-Party Monitoring Tools 00:06:00 Auditing through Monitoring 00:03:00 Special Security Auditing Tools 00:08:00 Improving Database Performance 00:07:00 Section 09: Troubleshooting Database Solutions Data Access Issues 00:09:00 Database Availability Issues 00:08:00 Database Performance Issues 00:06:00 Data Corruption Issues 00:05:00 Database Size Issues 00:06:00 Security Issues 00:08:00 General Troubleshooting Best Practices 00:07:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.
Overview Quickbooks and Xero Accounting Course Course is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Quickbooks and Xero Accounting Course Course and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 05 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training After you have successfully completed your assignment, you will be qualified to apply for a CPD Certification from The Teachers Training. The PDF certificate can be downloaded after you have completed your course. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Quickbook Getting prepared - access the software and course materials The structure of the course - first things first! 00:00:00 Set up free trial 00:03:00 Getting started Starting A New Company File 00:11:00 Setting up the system Enter opening balances 00:02:00 Reverse opening balances - accruals and prepayments 00:06:00 Report Journal 00:05:00 Nominal ledger Amend The Nominal Ledger 00:07:00 Report listing the nominal ledgers 00:02:00 Customers Enter customers 00:09:00 Report on customer contact information 00:01:00 Suppliers Enter Suppliers 00:05:00 Supplier Contact List 00:02:00 Sales ledger Enter Invoices 00:09:00 Invoice Entering 00:03:00 Invoice batch 00:06:00 Post Sales Credit Notes 00:08:00 Report showing Customer Activity 00:03:00 Aged Debtors 00:02:00 Purchases ledger Post Supplier Invoices 00:03:00 Entering a Batch of Supplier Bills 00:09:00 Credit Notes Suppliers 00:05:00 Reclassify Supplier Bills - Flash Bulbs Purchased 00:04:00 Supplier Account Activity Report 00:04:00 Sundry payments Post Cheques 00:07:00 Report showing supplier payments 00:01:00 Sundry receipts Receipts from customers 00:07:00 Report showing customer receipts 00:02:00 Petty cash Post Petty Cash Transactions and Report 00:04:00 Post cash payments to ledgers 00:02:00 Enter petty cash items 00:14:00 Report on Petty Cash Payments Proper 00:05:00 Post Sundry Payments 00:05:00 Report Bank Payments 00:03:00 VAT - Value Added Tax VAT Return 00:03:00 Bank reconciliation Reconcile The Bank 00:10:00 Provide A Report Showing Any Unreconnciled Transaction 00:02:00 Payroll / Wages Post the Wages Journal 00:08:00 Posting Journal Adjustments 00:02:00 Reports Month end adjustments 00:03:00 Month end reports 00:06:00 Tasks Task- Crearing the accounts 00:06:00 Task - Customer report 00:01:00 Additional Resources Course Paper 00:00:00 Further Reading - QuickBooks Online 2014 The Handbook 00:00:00 Xero Accounting Getting Prepared - Access the software and course materials Introduction To The Course And Your Tutor 00:04:00 Activating Your Free Trial With Xero 00:02:00 Getting started Signing Up For The Free Trial 00:04:00 Instruction of updated Xero accounting software 00:00:00 Create The Organisation 00:08:00 The Ficticious Scenario 00:02:00 Setting up the system Add Bank Accounts To The System 00:14:00 Enter Opening Balances 00:07:00 Opening Trial Balance 00:01:00 Nominal ledger Amend The Nominal Ledger 00:06:00 Chart Of Accounts Report 00:01:00 Customers & Suppliers Enter customers 00:07:00 Reporting Customer And Supplier Information 00:02:00 Sales ledger Enter Invoices 00:07:00 Invoicing tips - adding logo, repeat billing 00:09:00 Entering Invoices 6574 to 6610 00:16:00 Post Credit Notes 00:03:00 Report Showing Customer Activity 00:08:00 Aged Debtors 00:02:00 Suppliers Post supplier invoices 00:09:00 Enter suppliers invoices 6028 onwards 00:14:00 Enter More Supplier Invoices No 4308 Onwards 00:06:00 Credit Notes Suppliers 00:02:00 Supplier Activity Report 00:04:00 Aged Creditors Info 00:01:00 Reciepts from Customers 00:10:00 Apply Customer Credit Notes 00:05:00 Purchases ledger Post Supplier Cheques 00:08:00 Apply Supplier Credit Notes 00:03:00 Print List Of Bank Receipts And Payments 00:01:00 Sundry payments Post Sundry Payments 00:07:00 Make a credit card payment 00:08:00 Petty Cash Add Petty Cash Transactions - Week 1 00:16:00 Add Petty Cash Transactions - Week 2 00:12:00 Add Petty Cash Transactions - Week 3 00:07:00 Add Petty Cash Transactions - Week 4 00:09:00 Imprest System on Petty Cash 00:04:00 Print a Copy of Petty Cash Receipts and Payments 00:01:00 Bad Debt Writing Off A Bad Debt - Print Customer Statement 00:02:00 Write Off A Bad Debt 00:09:00 Credit Card Reconcile The Credit Card Statement 00:09:00 Bank Reconciliation Bank Statement As A CSV File 00:27:00 Bank Statement Closing Balances 00:11:00 Reconcile The Petty Cash 00:05:00 Payroll / Wages Wages And Salaries 00:09:00 Post the Wages Journal 00:07:00 Report Wages Journal 00:02:00 Payday 00:11:00 Pay The Two Staff 00:05:00 VAT - Value Added Tax Depreciation 00:04:00 VAT Return 00:03:00 Reports Month End Reports PnL, BS, TB 00:05:00 Payroll unit Using Payroll 00:12:00 Setting Up Employees 00:10:00 Running Payroll - An Example 00:14:00 Conclude Recap And Next Steps 00:06:00 What happens next 00:02:00 Resources Resources - Xero Accounting 00:00:00 Assignment Assignment - Quickbooks and Xero Accounting Course 00:00:00
Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents, and interests with our special Accounts Clerk Training Course (Bookkeeping) - Level 1 Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides the professional training that employers are looking for in today's workplaces. The Accounts Clerk Training Course (Bookkeeping) - Level 1 Course is one of the most prestigious training offered at Skillwise and is highly valued by employers for good reason. This Accounts Clerk Training Course (Bookkeeping) - Level 1 Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Accounts Clerk Training Course (Bookkeeping) - Level 1 Course, like every one of Skillwise's courses, is meticulously developed and well-researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At Skillwise, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from Skillwise, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Accounts Clerk Training Course (Bookkeeping) - Level 1 ? Lifetime access to the course forever Digital Certificate, Transcript, and student ID are all included in the price Absolutely no hidden fees Directly receive CPD Quality Standard-accredited qualifications after course completion Receive one-to-one assistance every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Accounts Clerk Training Course (Bookkeeping) - Level 1 there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the PDF certificate for free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Accounts Clerk Training Course (Bookkeeping) - Level 1 course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already work in relevant fields and want to polish their knowledge and skills. Prerequisites This Accounts Clerk Training Course (Bookkeeping) - Level 1 does not require you to have any prior qualifications or experience. You can just enrol and start learning. This Accounts Clerk Training Course (Bookkeeping) - Level 1 was made by professionals and it is compatible with all PCs, Macs, tablets, and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as a bonus, you will be able to pursue multiple occupations. This Accounts Clerk Training Course (Bookkeeping) - Level 1 is a great way for you to gain multiple skills from the comfort of your home. Introduction to the course Introduction 00:02:00 Introduction to Bookkeeping Introduction to Bookkeeping 00:15:00 Bookkeeping systems Manual System 00:08:00 Computerised Systems 00:11:00 How it Fits Together 00:08:00 Basics of Bookkeeping Bookkeeping Basics 00:30:00 The functionality of bookkeeping Ledgers 00:10:00 Trial Balance and Coding 00:11:00 PNL Account and Balance Sheet 00:05:00 On a personal note AILE Personal 00:06:00 Assessment Assignment - Accounts Clerk Training Course (Bookkeeping) - Level 1
Overview With the ever-increasing demand for Sage in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in Sage may be. Learning about Sage or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in Sage . That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on Sage is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates. The self-paced online learning methodology by compete high in this Sage course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course! Instead of searching for hours, enrol right away on this Sage course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run. Who is this course for? While we refrain from discouraging anyone wanting to do this Sage course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of Sage , Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Sage , Anyone looking for a certificate of completion on doing an online training on this topic, Students of Sage , or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This Sage course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams. Course Curriculum Module 01 Setting Up The System Setting Up The System 00:00 Module 02 Nominal Ledger Nominal Ledger 00:00 Module 03 Customers Customers 00:00 Module 04 Suppliers Suppliers 00:00 Module 05 Sales Ledger Sales Ledger 00:00 Module 06 Sundry Payments Sundry Payments 00:00 Module 07 Sundry Receipts Sundry Receipts 00:00 Module 08 Petty Cash Petty Cash 00:00 Module 09 Bank Reconciliation Bank Reconciliation 00:00 Module 10 Payroll Wages Payroll Wages 00:00
Description Quickbooks Online Accounts course is about how to use Quickbooks Online based on the most popular functions which you as a Quickbooks Online operator needs to know how to use, in order to be proficient in using the online software. The learning is structured in a practical way. You are given a practical scenario assignment. There are various tasks to complete. You are given the task to do and have a go at, and then the video answer is available. It is suggested that you: Read the task Watch the video Have a go at it yourself on your own system Rewatch the video (if necessary) - to reinforce the learning You'll learn how to set up a QuickBooks system from scratch, how to enter opening balances, post customer invoices and credit notes, post supplier bills and credit notes, pay suppliers, petty cash, prepare a VAT return, reconcile the bank, post journals, run reports amongst over things. This is a useful course if: You are thinking of working with the online software, You are going for jobs which have a requirement for you to be able to use this software You want to put this skill on your CV, or You are a bookkeeper or accountant and will be using this for clients or even You run your own business and want to know how to use Quickbooks for yourself. You will need to have access to a Quickbooks Online. The instructor is usually online to answer student queries for 2 hours each day. The course materials include: the handout of the assignment task access to the QuickBooks Online software for FREE for 21 days A 384 page manual on QuickBooks online Successful completion of the course is the equivalent to being at the level of having a level 2 certificate in computerised accounts. The next step would then be to take our QuickBooks Online Level 3. Note - there is no level 1. The course will take about 3-4 hours to complete. What Will I Learn? By the end of this course, you will be able to complete various common functions using Quickbooks Online. In this course you will learn how to: Enter the opening balances Amend the nominal ledger Add new customer and supplier details Post customer invoices and credit notes to the sales ledger Post supplier invoices and credit notes to the purchase ledger Enter the supplier cheques and record the customer receipts Post-Petty Cash transactions Prepare the VAT return Reconcile the bank Post the wages journal Post adjustments to the accounts and produce month-end reports Requirements You will need access to Quickbooks Online (a free link will be provided in the course) - the software will be available (free) for 21 days Who is the target audience? Students who are going for jobs where the requirement is working knowledge of Quickbooks Online Those who have studied accounting, but want practical knowledge of how to use a popular accounting software which will help them find employment Previous knowledge of accounting is not presumed or required Getting prepared - access the software and course materials The structure of the course - first things first! FREE 00:05:00 Set up free trial FREE 00:03:00 Getting started Starting A New Company File 00:11:00 Setting up the system set up nominal accounts 00:11:00 Enter opening balances 00:02:00 Reverse opening balances - accruals and prepayments 00:05:00 report journal 00:05:00 Nominal ledger amend the nominal ledger 00:07:00 Report listing the nominal ledgers 00:02:00 Customers Enter customers 00:09:00 Report on customer contact information 00:01:00 Suppliers enter suppliers 00:05:00 supplier contact list 00:02:00 Sales ledger Enter invoices 00:09:00 Invoice entering 00:03:00 Invoice batch 00:06:00 Post Sales Credit Notes 00:08:00 Report showing Customer Activity 00:03:00 Aged Debtors 00:02:00 Purchases ledger Post Supplier Invoices 00:03:00 Entering a batch of supplier bills 00:09:00 Credit Notes Suppliers 00:05:00 Reclassify supplier bills - flash bulbs purchased 00:04:00 Supplier Account Activity Report 00:04:00 Sundry payments Post Cheques 00:07:00 Report showing supplier payments 00:01:00 Sundry receipts Receipts from customers 00:07:00 Report showing customer receipts 00:02:00 Petty cash Post Petty Cash Transactions and Report 00:04:00 Post cash payments to ledgers 00:02:00 Enter petty cash items 00:14:00 Report on Petty Cash Payments Proper 00:05:00 Post Sundry Payments 00:05:00 Report Bank Payments 00:03:00 VAT - Value Added Tax VAT Return 00:03:00 Bank reconciliation Reconcile The Bank 00:10:00 Provide A Report Showing Any Unreconciled Transaction 00:02:00 Payroll / Wages Post the Wages Journal 00:08:00 Posting Journal Adjustments 00:02:00 Reports Month end adjustments 00:03:00 Month end reports 00:06:00 Tasks Task- Crearing the accounts 00:06:00 Task - Customer report 00:01:00 Additional Resources Course Paper 00:00:00 Further Reading - QuickBooks Online 2014 The Handbook 00:00:00
Course Overview Learn the fundamentals of Bitcoin and the cryptocurrency market, in this best-selling course. The Blockchain & Cryptocurrency (Bitcoin, Ethereum) Essentials course is the ultimate introduction to cryptocurrencies, taking you through best practices for using them, as well as how they work on a technical level. This course covers key topics such as the difference between centralised, non centralised and distributed systems, standard ledgers and Blockchain ledgers, and the structure of a Blockchain, with tips every amateur trader should know. Whether you are a complete beginner or looking to upgrade your financial skills, this course provides up-to-date knowledge to help you make smarter investments and financial decisions. Enrol as a part-time or full-time student, and learn from the experts today. This best selling Blockchain & Cryptocurrency (Bitcoin, Ethereum) Essentials has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Blockchain & Cryptocurrency (Bitcoin, Ethereum) Essentials is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Blockchain & Cryptocurrency (Bitcoin, Ethereum) Essentials is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Blockchain & Cryptocurrency (Bitcoin, Ethereum) Essentials is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Blockchain & Cryptocurrency (Bitcoin, Ethereum) Essentials, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Blockchain & Cryptocurrency (Bitcoin, Ethereum) Essentials will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Blockchain & Cryptocurrency (Bitcoin, Ethereum) Essentials to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device. Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.
Overview Strengthen your expertise in Quickbooks and Xero accounting software by taking this Quickbooks and Xero Accounting Course. In this course, you'll learn how to utilise these programs to their full potential. The Quickbooks and Xero Accounting Course will explain the features of the two software in great detail. It will educate you about the system requirements for Quickbooks and Xero. You will learn how to use the software for creating invoices, charts, spreadsheets and business reports. You will be able to manage your expenses, purchases, and sales in one spot and make faster payroll calculations. Learning Outcomes Deepen your understanding of QuickBooks and Xero Understand what is a nominal ledger account Learn how to categorise customers in QuickBooks Be able to make your documents stand out in the crowd Have the skills to track your income and expenses Why You Should Choose Quickbooks and Xero Accounting Course Lifetime access to the course No hidden fees or exam charges CPD Qualification Standards certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment, and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential Who is this Course for? The Quickbooks and Xero Accounting Course is for anyone interested in increasing their QuickBooks and Xero proficiency. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Quickbooks and Xero Accounting Course is fully compatible with any kind of device. Whether you are using a Windows computer, Mac, smartphone or tablet, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any limitation. Career Path This course will provide you with the necessary knowledge and skills required to succeed in this sector. You will be ready to enter the relevant job market after completing this course. On top of that, the course will enhance your ability to earn an average salary of £52,500 annually. Quickbooks Getting prepared - access the software and course materials The structure of the course - first things first! FREE 00:05:00 Set up free trial FREE 00:03:00 Getting started Starting A New Company File 00:11:00 Setting up the system set up nominal accounts 00:11:00 Enter opening balances 00:02:00 Reverse opening balances - accruals and prepayments 00:05:00 report journal 00:05:00 Nominal ledger amend the nominal ledger 00:07:00 Report listing the nominal ledgers 00:02:00 Customers Enter customers 00:09:00 Report on customer contact information 00:01:00 Suppliers enter suppliers 00:05:00 supplier contact list 00:02:00 Sales ledger Enter invoices 00:09:00 Invoice entering 00:03:00 Invoice batch 00:06:00 Post Sales Credit Notes 00:08:00 Report showing Customer Activity 00:03:00 Aged Debtors 00:02:00 Purchases ledger Post Supplier Invoices 00:03:00 Entering a batch of supplier bills 00:09:00 Credit Notes Suppliers 00:05:00 Reclassify supplier bills - flash bulbs purchased 00:04:00 Supplier Account Activity Report 00:04:00 Sundry payments Post Cheques 00:07:00 Report showing supplier payments 00:01:00 Sundry receipts Receipts from customers 00:07:00 Report showing customer receipts 00:02:00 Petty cash Post Petty Cash Transactions and Report 00:04:00 Post cash payments to ledgers 00:02:00 Enter petty cash items 00:14:00 Report on Petty Cash Payments Proper 00:05:00 Post Sundry Payments 00:05:00 Report Bank Payments 00:03:00 VAT - Value Added Tax VAT Return 00:03:00 Bank reconciliation Reconcile The Bank 00:10:00 Provide A Report Showing Any Unreconciled Transaction 00:02:00 Payroll / Wages Post the Wages Journal 00:08:00 Posting Journal Adjustments 00:02:00 Reports Month end adjustments 00:03:00 Month end reports 00:06:00 Tasks Task- Crearing the accounts 00:06:00 Task - Customer report 00:01:00 Additional Resources Course Paper 00:00:00 Further Reading - QuickBooks Online 2014 The Handbook 00:00:00 Xero Accounting Introduction Introduction FREE 00:02:00 Getting Started Introduction - Getting Started FREE 00:01:00 Signing up to Xero 00:04:00 Quick Tour of Xero 00:12:00 Initial Xero Settings 00:13:00 Chart of Accounts 00:14:00 Adding a Bank Account 00:08:00 Demo Company 00:04:00 Tracking Categories 00:06:00 Contacts 00:12:00 Invoices and Sales Introduction - Invoices and Sales 00:01:00 Sales Screens 00:04:00 Invoice Settings 00:13:00 Creating an Invoice 00:18:00 Repeating Invoices 00:07:00 Credit Notes 00:06:00 Quotes Settings 00:03:00 Creating Quotes 00:07:00 Other Invoicing Tasks 00:03:00 Sending Statements 00:03:00 Sales Reporting 00:05:00 Bills and Purchases Introduction - Bills and Purchases 00:01:00 Purchases Screens 00:04:00 Bill Settings 00:02:00 Creating a Bill 00:13:00 Repeating Bills 00:05:00 Credit Notes 00:06:00 Purchase Order Settings 00:02:00 Purchase Orders 00:08:00 Batch Payments 00:13:00 Other Billing Tasks 00:02:00 Sending Remittances 00:03:00 Purchases Reporting 00:05:00 Bank Accounts Introduction - Bank Accounts 00:01:00 Bank Accounts Screens 00:07:00 Automatic Matching 00:04:00 Reconciling Invoices 00:06:00 Reconciling Bills 00:03:00 Reconciling Spend Money 00:05:00 Reconciling Receive Money 00:04:00 Find and Match 00:04:00 Bank Rules 00:09:00 Cash Coding 00:03:00 Remove and Redo vs Unreconcile 00:04:00 Uploading Bank Transactions 00:07:00 Automatic Bank Feeds 00:06:00 Products and Services Introduction - Products and Services 00:01:00 Products and Services Screen 00:02:00 Adding Services 00:03:00 Adding Untracked Products 00:03:00 Adding Tracked Products 00:07:00 Fixed Assets Introduction - Fixed Assets 00:01:00 Fixed Assets Settings 00:06:00 Adding Assets from Bank Transactions 00:06:00 Adding Assets from Spend Money 00:05:00 Adding Assets from Bills 00:02:00 Depreciation 00:04:00 Payroll Introduction - Payroll 00:01:00 Payroll Settings 00:15:00 Adding Employees 00:18:00 Paying Employees 00:10:00 Payroll Filing 00:04:00 VAT Returns Introduction - VAT Returns 00:01:00 VAT Settings 00:02:00 VAT Returns - Manual Filing 00:06:00 VAT Returns - Digital Filing 00:02:00
Bookkeeping is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Bookkeeping and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 01 hour studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Section 01: Introduction Introduction 00:01:00 Section 02: Basic Accounting Terms Difference between Bookkeeping and Accounting 00:01:00 Accounting Equation - Assets, Liabilities and Owners' Equity 00:04:00 Expanded Accounting Equation - Revenues and Expenses 00:02:00 Transactions 00:02:00 Accounts 00:03:00 Accrual Accounting System 00:03:00 Double-Entry Accounting System - General Journal and General Ledger 00:03:00 Recording Transactions 00:02:00 Section 03: Common Transactions Credit Purchases 00:02:00 Cash Purchases 00:01:00 Credit Sales 00:04:00 Cash Sales 00:02:00 Unearned Revenues 00:02:00 Prepaid Expenses 00:02:00 Unrecorded Expenses 00:04:00 Unrecorded Revenue 00:02:00 Depreciation 00:03:00 Types of Discounts 00:03:00 Discount Allowed 00:04:00 Discount Received 00:03:00 Section 04: Practice Exercise 1 00:03:00 Exercise 2 00:03:00 Exercise 3 00:03:00 Exercise 4 00:01:00 Exercise 5 00:01:00 Assignment Assignment - Bookkeeping 00:00:00
Learn to use Sage Line 50 Accounts in 3-4 hours and stay in control of your business and drive it forward! Sage Line 50 Accounts is the market-leading accounts software that's designed to help you manage your finances. In this course, you'll learn how to keep track of sales, expenses and profit, and analyse business performance with a range of reports by using Sage Line 50 Accounts The course covers a range of topics, from how to set up a Sage system from scratch; to how to create month-end reports using Sage Line 50 Accounts. Along the way you'll also learn how to enter opening balances, post customer invoices and credit notes, post supplier bills, pay suppliers, petty cash, prepare a VAT return, reconcile the bank, post journals and many more. If you're a bookkeeper or an accountant who'll be using Sage 50 for clients, or you're going for jobs that require working knowledge of Sage Accounts or if you just want practical knowledge of how to use the most popular accounting software then this is the perfect course for you. What you'll learn from this course You'll learn: How to do various common functions using Sage How to enter the opening balances How to amend the nominal ledger How to add new customer and supplier details How to post customer invoices and credit notes to the sales ledger How to post supplier invoices and credit notes to the purchase ledger How to enter the supplier cheques and record the customer receipts How to post petty cash transactions How to prepare the VAT return How to reconcile the bank How to post the wages journal How to do post adjustments to the accounts and produce month-end reports Who this course is for: Bookkeepers and Accountants who will be using this for their clients Students who are going for jobs where the requirement is working knowledge of Sage Accounts Those who have studied accounting, but want practical knowledge of how to use a popular accounting software which will help them find employment Previous knowledge of accounting is not presumed or required Requirements You will need access to Sage accounts in order to complete the assignment (any version) Sage Line 50 Accounts Sage online intro to the course FREE 00:06:00 QB of what can you do next after this course FREE 00:05:00 Free Trial 00:03:00 Sign Up 00:02:00 Set Up (1) 00:02:00 Set Up (2) 00:05:00 Upgrade The Version 00:04:00 Opening Journals 00:08:00 Reports Trial Balance 00:05:00 Enter Opening Journals - now that coa done 00:06:00 Opening TB 00:04:00 Reverse the Opening Accrual 00:05:00 Reverse The Opening Accrual - Report 00:03:00 Amend The Nominal Ledger 00:06:00 Nominal Ledger Report 00:02:00 Copy of The Coas 00:05:00 Customer Report 00:01:00 Customer Address List 00:05:00 Add New Suppliers 00:04:00 SUPPLIER Report 00:01:00 Supplier Address List 00:05:00 Customer Invoices 00:07:00 Customer Invoices - Batch 00:06:00 Post Credit Notes 00:05:00 REPORT Customer Account Activity 00:03:00 Customer Account Activity Details 00:05:00 Aged Debtors Breakdown 00:05:00 Post Supplier Invoices 00:10:00 Post Supplier Credit Notes 00:04:00 Aged Creditors Info 00:02:00 REPORT Supplier Account Activity 00:05:00 Supplier Cheques 00:07:00 Report Supplier Payments 00:01:00 Supplier Payments Details Report 00:05:00 Receipts From Customers 00:07:00 Report to Show Customer Receipts 00:01:00 Report of The Customer Receipts 00:05:00 Petty Cash Transactions 00:02:00 Report Chq in 00:03:00 Report PDF of Chq Transfers 00:00:00 Cash Payments 00:10:00 Cash Payments Now all Nominals are there 00:06:00 Report to Show Petty Cash Payments 00:01:00 Report of the Petty Cash Payments 00:05:00 Post Sundry Payments 00:03:00 Report Showing Bank Payments 00:01:00 Report of Bank Payments 00:05:00 Prepare a VAT Return 00:03:00 Vat Return Detail Report 00:05:00 Vat Return Summary 00:05:00 Reconcile The Bank 00:05:00 Unreconciled Bank Report 00:01:00 Post The Wages Journal 00:04:00 Wages Journal Report 00:01:00 Month End Adjustment Journals 00:04:00 Month End Reports 00:02:00 Report Trial Balance 00:05:00 PNL Report 00:05:00 BS Report 00:05:00 What can you do next after this course 00:05:00