Xero Cloud and Excel Basic to Advance Combo Training Pack

Learn how to create a free one-month trial of Xero cloud accounting, set up a browser-based account without installation, and enter basic business details to start training.

Create a UK based company in zero cloud accounting, select computer services, auto generate the chart of accounts, and customize dashboards and reports for efficient bookkeeping.

Install a pdf viewer and set Fox Reader as the default to improve document visibility, then follow download and installation steps to prepare for configuring bargains and Zettl.

Navigate to financial settings in Xero, switch from accrual to cash where needed, set the tax exclusive option, and configure quarterly periods to add vat info and save your preferences.

Learn how to add multiple reports to the accounting tab by enabling important reports in settings, so they appear in the accounting menu. Verify changes by returning to the dashboard.

Explore moving from manual accounting to the zero accounting software for Global Computer Solutions in Edinburg areas, transferring closing balances and entering data to generate key reports.

Edit and add chart of accounts in Xero by searching, renaming assets like office equipment and furniture, and creating bank and petty cash accounts with proper account codes.

Enter opening balances in Xero by editing ledgers, recording debits, credits, and accumulated depreciation, then apply the June 2017 conversion date and export the trial balance as pdf.

Amend nominal ledgers by creating new sales ledger accounts in the chart of accounts, assign revenue and cost of sales, and adjust account codes and names in Xero.

Discover how to generate a chart of accounts report that lists ledger names, their location within the chart of accounts, and the nature of each account, including taxes applicable.

Enter new customers and suppliers in Xero by adding company names, account numbers, addresses, and primary contacts, then save records and add additional contacts as needed.

learn how to enter supplier and contact details in the Xero cloud and Excel training pack, including account numbers, addresses, financials, and review customer and supplier reports.

Learn to extract a customers and suppliers report from contacts, then customize the extracted report by selecting columns, auto-adjusting widths, deleting unnecessary fields, and saving the final report.

Learn to enter and manage sales invoices in Xero cloud, including creating items, coding to the correct ledgers, applying VAT and tax-inclusive totals, and approving, printing, and previewing June invoices.

Enter a new sales invoice in Xero for hardware items such as computer ink, cartridges and copier, with tax-inclusive pricing in British pounds, June 1, 2017 and invoice number 6574. Create a computer stationery item CS001, then save, approve, and add further items as shown.

Learn how to delete, void, or manage draft and permanent invoices in Xero Cloud and Excel, including correcting mistakes and navigating drafts and awaiting payment.

Create and manage invoices with careful entry of dates, unique invoice numbers, and item details. Learn to apply tax inclusive pricing and set automatic tax inclusive defaults for new invoices.

Set default tax inclusive settings in invoice options, save, then adjust customer financial settings to tax inclusive so invoices show as inclusive for selected customers.

Set default tax to inclusive for new contacts and invoices to enable global tracking, then adjust per customer overrides in options, settings, advanced, financial settings.

Enter sales invoices in xero, set the date and manual invoice numbers, keep items tax inclusive, and save for approval or move to awaiting payment.

Enter and approve multiple tax-inclusive sales invoices for June 2017, creating new items and categories as needed, and prepare for credit notes in the next video.

Learn how to enter credit notes in Xero after invoicing, including creating, approving, and allocating them to existing invoices with real examples.

Extract and export detailed customer activity reports in Xero, choosing invoice date ranges, sorting options, and export formats such as PDF, Excel, and Google Sheets to share professional statements.

Explore the ejecta analysis report that ages invoices by due dates, using 30, 60 days, and six months thresholds, and guides soft, frequent, and hard reminders to protect cash flow.

Configure inventory purchases in Xero by enabling items for purchase, applying 20 percent VAT, and linking supplier invoices to the supplier ledger; then enter bills to pay.

learn how to enter a purchase invoice in xero cloud, set default invoice settings, create a new bill for desktop computers, and configure the approval workflow.

Update item descriptions across all items from purchase to invoices by copying sales descriptions into each item's description in business and production services, and finalize inventory adjustments.

Continue entering purchase invoices in Xero, detailing dates, invoice numbers, items, unit prices, tax, and totals for suppliers like Time Computers and Tiny Computers, then save and submit for approval.

Enter and categorize purchase invoices, create items, and apply unit prices and totals, then approve multiple invoices in one action to move them from awaiting approval to awaiting payment.

Create two credit notes in Xero for purchase returns, post to bills to pay, then allocate the negative balances to invoices and confirm both credits are entered.

Navigate to accounting > reports, select the supplier invoices report, set the date range from 1 june 2017 to 30 june 2017, update, and export as a pdf.

Navigate to accounting reports, open the People’s Report, set the period to June 2017, update to view monthly balances, then print or export to Excel.

Process customer receipts in Xero by posting payments to customer ledgers, sorting by invoice number, and recording full payments to bank accounts, including tax exclusive corrections and sending receipts.

Open the invoice, apply the full credit note, and offset it against the due amount until the total is zero. Settle the invoice and update its status accordingly.

Learn to manage supplier payments in Xero by filtering awaiting payments, selecting invoices, and creating payments from a bank current account with narratives and check numbers.

Learn to settle credit notes against purchase invoices by selecting invoices, allocating partial or full credits, and updating pending balances across suppliers.

Learn to print a bank receipts and payments list using Xero's account transactions report, selecting a bank current account and the June 1–30, 2017 period, then export the report.

Learn to record post sundry payments in Xero using direct debits and standing orders, including creating suppliers, items, accounts, and tax-exempt classifications.

Learn how to record credit card payments in Xero by entering credit card details, creating a credit card bank account, and paying pending invoices through the system.

Learn to clear a credit card balance by transferring 542.29 from the bank to the card, aligning the standing direct debit on the due date and reflecting a zero balance.

Master petty cash management by recording weekly spending against a 150 pounds balance, processing bank transfers to reimburse the fund, and reconciling diverse expenses from postage to office supplies.

Enter and classify week 2 petty cash transactions, including postage, tickets, stationery, and cleaning, using spend money and transfer money to petty cash.

Record and reconcile petty cash transactions across week 3, including window cleaner, postage, office cleaner, petrol, and florist, with tax settings and a bank current account transfer.

Enter and classify weekly petty cash transactions (24–27 June), create new contacts, set tax status, and reimburse 109.56 by transferring from bank to petty cash.

Print petty cash accounts and receipts report in Xero, select the petty cash ledger for June 1–30, 2017, verify opening and closing balances, and export as pdf for reference.

learn to print the statement of the account showing the outstanding balance and record journal entries to write off bad debt, tracing the audit trail and customer activity in Zettl.

Record a bad debt write-off in Xero by creating a Baghdad expense account, posting a settlement against the outstanding balance, and verifying the zero net balance in the general report.

Learn to reconcile credit card statements in Xero by matching transactions, marking them as reconciled, and generating reconciliation reports for a given period.

Learn to reconcile a bank statement in Xero using the import technique, manually mapping fields, and matching by reference, date, and amount for accurate balances, including automatic reconciliation options.

Learn to generate and review bank reconciliation reports in Xero for closing balances as of 30 June 2017, view bank statements, handle timing differences, and export or print the result.

Learn to reconcile the petty cash account weekly, keeping the balance at 150 by marking each transaction as reconciled in accounting transactions and generating the reconciliation report if needed.

Set up and enter a wages and salaries journal in Xero, create and adjust liability and donation accounts (MS Society, NSPCC, pensions), and verify via the chart of accounts.

Enter a payroll journal in Xero by creating a new journal, entering salaries, tax deductions, employee contributions, and employer costs with debit and credit lines, then post.

learn how to extract the british journal report from accounting, locate payroll and manual journal entries, and print a pdf to download the journal entry.

Navigate paying wages and liabilities in xero, including HMRC, pension providers, and charities, using trial balance and bank transfers to settle June 2017 payroll and charitable contributions.