ACCTG102 · Accounting Concepts
Accounting in Xero: Cloud Accounting
Week 11 of ACCTG 102 Accounting Concepts at the University of Auckland has no textbook chapter — instead it moves the whole manual accounting cycle into Xero, the cloud accounting platform: conversion balances (the opening trial balance), sales invoices and purchase bills (the journals), bank reconciliation and the closing reports. It drives Assignment 3, the hands-on “Get to Know Xero (NZ)” build worth 5% of the grade, and supplies a written cloud-accounting question on the comprehensive final exam — the practice final’s Q6 covered fixed assets in Xero.
What this chapter covers
- 01The Xero workflow: set up the organisation → conversion balances → invoices & bills → bank reconciliation → reports — the Chapters 1–5 accounting cycle re-enacted in cloud software
- 02Set-up phase: financial settings (NZ 31 March year-end; the course build runs with GST off), editing and adding chart-of-accounts codes, contacts with payment terms, a manual bank account
- 03Conversion date and conversion balances = the opening trial balance: total debits must equal total credits, and receivables must equal the unpaid customer invoices entered with pre-conversion dates
- 04What each screen posts: sales invoice (Dr Accounts receivable / Cr Sales revenue), purchase bill, credit notes allocated against specific invoices, Receive Money vs invoice payments, Spend Money
- 05Untracked service items vs tracked inventory items — tracked items keep a perpetual inventory and post the Chapter 4 pair (revenue entry + cost of sales entry) automatically
- 06Bank reconciliation tools: Match, Create (bank fees and other unrecorded lines), Find & Match across multiple invoices, Split for part-payments, minor adjustments for cent-level underpayments
- 07Fixed assets in Xero: the asset register (cost, purchase date, method, rate/useful life, book value), automatic depreciation runs, and rolling back to correct coding errors — the practice final’s written question
- 08The proving reports: Trial Balance, Journal, Account Transactions, invoice summaries and aged receivables/payables — each one a manual-cycle artefact
- 09Cloud-accounting themes: one ledger accessed anywhere, real-time Advisor access, automation on top of the ledger, bank data flowing in, and the internet/data trade-offs from the prescribed reading
- 10Assignment 3 tactics: the 0/50/100 rubric, instruction order, inviting the marker as an Advisor user, and date discipline on transactions and report ranges
Conversion balances for a Nelson kayak-hire business
- +1Classify each balance. Debits: bank, accounts receivable, equipment at cost. Credits: accumulated depreciation (a contra asset), accounts payable, the loan, and the owner’s funds.
- +1Receivables from the invoice detail. Accounts receivable = 2,900 + 1,800 = $4,700, entered as two invoices dated on their original, pre-conversion dates — dating them after the conversion date would double-count receivables and create phantom revenue.
- +1Total the debits. 9,300 + 4,700 + 21,000 = $35,000.
- +1Total the known credits. 5,500 + 3,900 + 12,000 = $21,400.
- +1Owner’s funds = the balancing figure. 35,000 − 21,400 = $13,600 — the residual interest, exactly the accounting equation (assets − liabilities = equity).
- +1Prove it. Run the Trial Balance report at the conversion date: debits 35,000 = credits 35,000, and the receivables line ties to the two open invoices (4,700). The bill of $3,900 likewise explains the payables balance.
Key terms
- Conversion date
- The date an existing business switches its books onto Xero — the cloud ledger takes over from this date, and every opening balance is stated as at this date.
- Conversion balances
- The balance of every account at the conversion date — the opening trial balance. Total debits must equal total credits, and the receivables/payables balances must equal the open pre-conversion invoices and bills entered.
- Receive Money / Spend Money
- Xero’s direct cash transactions for money in or out with no invoice or bill behind it (counter takings, salaries, bank fees). Cash that settles an existing invoice is an invoice payment instead — using Receive Money for it records the revenue twice.
- Find & Match
- The reconciliation tool for one bank-statement line that covers several invoices (or part of one, using Split) — it allocates a single bank amount across multiple invoices in one balanced entry.
- Minor adjustment
- A cent-level write-off applied during reconciliation when a payment is trivially short of the invoice, so the invoice can close — the tiny difference posts to an expense account and the entry still balances.
- Tracked inventory item
- An item with both a cost and a sell price for which Xero keeps a perpetual inventory: each sale automatically posts the revenue entry and the cost entry (Dr Cost of sales / Cr Inventory) — the Chapter 4 pair, posted by software.
- Fixed-asset register
- Xero’s in-system record of each fixed asset: identification, purchase date and cost, depreciation method and rate or useful life, accumulated depreciation and book value. Depreciation runs post the ledger entry automatically, and coding errors are fixed by rolling back and recalculating.
- Tracking category
- A reporting dimension (e.g. product line or location) tagged onto transactions so reports can be filtered by it — it changes no debits or credits, only how reports slice the same ledger.
Accounting in Xero: Cloud Accounting FAQ
Is Xero in the ACCTG 102 mid-semester test or the final exam?
The mid-semester test (20%, on Inspera, open book) covers Chapters 1–5 only, and Xero is Week 11 material — so it is examined on the comprehensive final exam, which covers Chapters 1–5 and 7–10 plus Xero. On the practice final it appeared as Q6, a short-written question based on the announced “Fixed Assets in Xero” video: how Xero tracks fixed assets and depreciation in one system, what the asset register stores, and how depreciation coding errors are corrected. Assignment 3 (5%) is the hands-on leg of the same material.
How is Assignment 3, the Xero assignment, marked?
You build a fictitious NZ business in a free Xero trial — settings, chart of accounts, contacts, conversion balances, invoices and bills, bank reconciliation from imported statements — then export a set of reports as PDFs and submit via Canvas, having invited the course marker into your organisation as an Advisor user. It is graded 0/50/100: broadly, at least ~70% correct and reasonable earns full marks and at least ~50% earns half, with attention to detail in following instructions itself a stated marking criterion. The submission window is about a week — confirm the dates on Canvas.
Can AI help me with Xero and cloud accounting in ACCTG 102?
Yes — used the right way. Sia explains the workflow step by step: you can ask why conversion balances must total, what double entry a sales invoice or a Receive Money transaction posts, or how Find & Match differs from Create in the reconciliation, and have your own reasoning checked against the logic. It is a study tool for understanding the method — it will not do your graded Xero build or assessment answers for you, and no tool can promise marks; note the course’s test rules prohibit AI use during assessments themselves.
Exam move
Treat Week 11 as revision in disguise: everything in Xero is a Chapters 1–5 idea wearing a screen. First, for every transaction type (invoice, bill, credit note, Receive Money, Spend Money, invoice payment) write down the balanced double entry it posts — that single decoder table carries both the assignment and the exam’s written question. Second, do Assignment 3 in strict instruction order and early in its window: conversion balances that total, opening invoices dated before the conversion date, a fully reconciled bank account and correctly dated reports are where the 0/50/100 rubric is won, and attention to detail is itself a marking criterion. Third, prepare the written question with mechanisms rather than marketing: one ledger keeps the fixed-asset register and the statements in sync; the register stores cost, dates, method and rate; errors are rolled back and recalculated. Finally, watch whichever Xero video is announced for your semester — the practice final’s question was built directly on it — and skim the prescribed cloud-accounting reading for written-answer vocabulary. Budget exam time at the practice paper’s pace of roughly 1.6 minutes per mark.
Working through Accounting in Xero: Cloud Accounting in ACCTG 102? Sia is AskSia’s AI Accounting tutor — ask any ACCTG 102 Accounting in Xero: Cloud Accounting question and get a clear, step-by-step explanation grounded in how ACCTG 102 is taught and assessed. Read this chapter free, then take your hardest questions to Sia.
