New Course Launched on Guiding Figures. Learn More There is a new blog post. Read Here There is a new blog post. Read Here There is a new blog post. Read Here There is a new blog post. Read Here There is a new blog post. Read Here There is a new blog post. Read Here There is a new blog post. Read Here There is a new blog post. Read Here New Course Launched on Guiding Figures. Learn More

Xero Bookkeeping Essentials Training

This practical Xero accounting course begins with teaching participants how to create a new company in Xero from scratch, ensuring a solid understanding of system setup and workflow. It then covers essential areas such as Sales and Purchases, including how to record and reconcile transactions, handle credit notes, refunds, and bad debts, and resolve bank reconciliation issues. Learners will also explore how to record and reconcile foreign currency transactions, manage Director’s Loan Accounts (including funds introduced and business expenses paid by directors), and handle Petty Cash — from creation to recording payments. The course also includes managing Fixed Assets and understanding their impact on the financial statements.

Usman Ali (Chartered Accountant and PTLLS -Teaching qualification -Level-3)

Category: Accounting

Course Image

PKR 6,000

Enroll Now

What You'll Learn

In this course, you will learn how to confidently perform real-world accounting tasks in Xero from start to finish, just like in a professional accounting firm. You’ll begin by learning how to create a new company in Xero, set up key financial settings, and customize chart of accounts to suit business needs. From there, you’ll move on to managing sales and purchase transactions, including how to record, reconcile, and correct entries to ensure accuracy across all ledgers. You’ll also master the process of handling credit notes, refunds, and bad debts, understanding how each impacts financial reports.

The course will help you develop strong skills in bank reconciliation, teaching you how to identify and fix common mismatches between bank statements and Xero records. You’ll also gain practical experience managing foreign currency transactions, learning how to record, reconcile, and account for exchange rate differences.

In addition, you’ll learn how to manage director loan accounts, including how to record funds introduced by directors and how to account for business expenses paid personally by them. The course also covers petty cash management—from creating a petty cash account and recording payments to reconciling balances accurately.

Finally, you’ll explore how to record and manage fixed assets, post depreciation, and understand how these adjustments affect the balance sheet and profit and loss account. By the end of this course, you’ll have the complete practical knowledge needed to set up, manage, and maintain accurate accounts in Xero with confidence.

Course Content

How to Create a Company in Xero - Part (1) (01:23 mins)
How to Create a Company in Xero - Part (2) (01:53 mins)

Recording a Purchase Invoice in Xero and Its Accounting Impact (05:19 mins)
How to Reconcile a Refund When the Payment Has Already Been Allocated to an Invoice (02:30 mins)
How to Raise a Credit Note and Delete a Credit Note Allocation (02:02 mins)
Reconciling Purchase Transactions and Record Overpayments in Xero (01:05 mins)
Import Bank Statement and Reconcile Transactions in Xero (01:46 mins)
How to Change the Account code and Tax rate when the Payment has already been allocated to an invoice (02:24 mins)

How to Record Sales in Xero with Double Entry Accounting (02:16 mins)
Reconciling Sales Transactions and Managing Customer Overpayments in Xero (02:44 mins)
How to Record a Customer Refund and Reconcile it in Xero (04:07 mins)
How to Raise a Credit Note in Xero and Apply Credit to Invoices (02:48 mins)
Impact of Sales invoices in Profit and Loss Account and Balance Sheet (03:14 mins)
How to deal with Bad debts in Xero (02:48 mins)
How to Create Bad Debt Expense Code in Xero (01:05 mins)
How Bad debt Expense impact Accounts (02:30 mins)

Issues in Bank Reconciliation After Locking Period in Xero (02:19 mins)
How to Record Cash-Coded Transactions in Xero (02:11 mins)
Splitting a Payment Across Multiple Invoices in Xero (01:52 mins)
Applying Bank Rules for Transfers Between Bank Accounts in Xero (01:35 mins)
Bank Feeds vs. Manual Statement Import in Xero (01:21 mins)
How to Reconcile a Transfer from a Euro Bank Account to a GBP Bank Account in Xero (01:48 mins)
How to Attach an Invoice in Bank reconciliation (01:27 mins)
How do we Search Specific Amount in Bank Reconciliation (0:51 mins)
How to Create a Euro Bank Account in Xero (01:36 mins)
How to use Uncoded Statement Lines Report in Bank Reconciliation (01:41 mins)

Recording Fixed Assets Accurately in Xero Using the Right VAT Option (03:56 mins)
Impact of Recording Fixed Assets on Accounts (04:22 mins)

How to Record Foreign Currency Transaction in Xero (01:59 mins)
How to Reconcile Foreign Currency Invoices and Record Exchange Rate Differences in Xero (03:55 mins)

How to Create Petty Cash Account in Xero (01:16 mins)
How to Record Petty Cash Payment in Xero (01:41 mins)
How to Transfer Money from Bank Account to Petty Cash Account in Xero (01:06 mins)
How to Record Petty Cash Funds Received from the Director in Xero (01:19 mins)
How to Reconcile Petty Cash Transactions in Xero (0:57 mins)
Various Ways to Reconcile Petty Cash in Xero (01:02 mins)

Recording Funds Introduced by the Director (Director’s Loan Account – DLA) (02:45 mins)
Recording Business Expenses Paid Personally by the Director (04:44 mins)

How to Send an Invite in Xero (01:50 mins)
How to Use Find and Recode Feature in Xero (02:25 mins)
How to Check Transactions of any Account Code in Xero (1:25 mins)
How to Create a Manual Journal in Xero (0:42 mins)
How to Lock the Accounting Period in Xero (0:44 mins)
How to use Search feature in Xero (01:50 mins)
How to View Transaction History in Xero (01:11 mins)

Instructor

Usman Ali

Chartered Accountant and PTLLS -Teaching qualification -Level-3 | 6 years of experience

I am an ACCA-qualified professional with extensive experience working in accounting firms across the UK. Over the years, I have developed a strong skill set in core accounting functions, including bookkeeping, VAT returns, accounts preparation, and payroll processing. I am proficient in using a variety of accounting and business software such as CaseWare, Microsoft Dynamics, Xero, QuickBooks, KeyPrime, Sage, and Futrli, which has enabled me to work efficiently across different client needs and industries.

In addition to my technical expertise, I have a solid background in training and mentoring. I have successfully delivered tuition and practical training to AAT and ACCA students, recent graduates, trainee accountants, and apprentices. My approach emphasizes real-world application, helping learners build the confidence and skills required in professional accounting roles. I am also a strong team player, capable of working under pressure to meet tight deadlines, and consistently strive to maintain high standards of accuracy and professionalism in all aspects of my work.

Frequently Asked Questions (FAQ)

You will learn how to record sales and purchase invoices, manage overpayments, refunds, and credit notes, perform accurate bank reconciliations, apply rules, record fixed assets, handle petty cash, and account for funds introduced by directors.

No prior knowledge is required, but having a basic understanding of accounting principles will be helpful. The course is designed to guide both beginners and those with some background.

This is a hands-on practical training course. You will work through real-world examples using Xero, applying bookkeeping concepts in practice rather than only theory.

The course is ideal for accounting students (AAT, ACCA, university), trainee accountants, fresh graduates, entrepreneurs, small business owners, bookkeepers, and admin staff who want to strengthen their bookkeeping skills.

Yes. You will gain practical bookkeeping skills in Xero that are highly valued by employers, accounting practices, and businesses. These skills can help you secure roles in accounting, finance, or confidently manage your own business accounts.

This Course Includes

  • Hands-on Practical Training using Xero accounting software

  • Live Google Meet support sessions if needed.

  • Short, easy-to-follow video lessons (2–3 minutes each)

  • Real-life accounting tasks based on an IT services company scenario

    • Requirements

  • No prior experience required, but basic accounting knowledge is helpful.

  • Access to a computer or laptop with a stable internet connection.

  • A free or trial version of Xero Accounting Software (setup guidance provided).

  • Basic familiarity with Excel/Spreadsheets is useful but not essential.

  • Motivation to learn through Practical, hands-on exercises.

    • Add to Cart