Xero Advisor Certification — Questions and Answers
Question 1: How can you manage multiple bank accounts in Xero?
- Only one bank account can be added.
- Multiple accounts can be added by configuring them in settings. (Correct answer)
- Bank accounts must be connected through a third-party app.
- Accounts are automatically linked from your bank.
Correct answer: Multiple accounts can be added by configuring them in settings.
Xero is designed to handle the financial management of businesses with various banking needs. Users can add and manage multiple bank accounts, including savings, checking, and credit card accounts, by configuring them within the organization's settings, allowing for a comprehensive and organized view of all financial inflows and outflows.
Question 2: A Xero user accidentally reconciled a bank transaction to the wrong invoice. What is the correct way to fix this?
- Unreconcile the transaction by removing the match, then re-match it to the correct invoice (Correct answer)
- Delete the bank account and reimport the statement
- Create a manual journal to reverse the error
- Void the incorrect invoice and create a new one
Correct answer: Unreconcile the transaction by removing the match, then re-match it to the correct invoice
You can unreconcile a transaction in Xero by clicking on it and removing the match, then re-reconciling it to the correct invoice.
Question 3: When importing a chart of accounts into Xero via CSV, which field is required for each account?
- Account Name and Account Code only
- Account Name, Account Code, and Account Type (Correct answer)
- Account Name and Description only
- Account Code and Tax Rate only
Correct answer: Account Name, Account Code, and Account Type
A valid Xero chart of accounts CSV import requires at minimum the Account Name, Account Code, and Account Type for each row.
Question 4: How do you handle bank transfers during reconciliation in Xero?
- Ignore the bank transfer entries.
- Manually calculate the transfer amount.
- Match the bank transfer to the relevant accounts during reconciliation. (Correct answer)
- Let Xero automatically handle the transfer.
Correct answer: Match the bank transfer to the relevant accounts during reconciliation.
When handling bank transfers during reconciliation in Xero, you match the outgoing transfer from one bank account to the corresponding incoming transfer in another. This ensures that both sides of the internal transfer are correctly recorded and offset, preventing duplicate entries. It accurately reflects the movement of funds between your own accounts without creating false income or expenses.
Question 5: In Xero Certified Advisor, what role does regulatory compliance & legal framework play in ensuring client/stakeholder satisfaction?
- It builds trust through demonstrated competence and consistency (Correct answer)
- It has no direct impact on stakeholder satisfaction
- It only matters during initial certification
- It replaces the need for direct communication
Correct answer: It builds trust through demonstrated competence and consistency
Regulatory Compliance & Legal Framework builds trust through demonstrated competence and consistency, which directly contributes to stakeholder satisfaction and confidence in the Xero Certified Advisor professional.
Question 6: In Xero, what is the purpose of a 'branding theme'?
- Configure user interface preferences per user
- Apply a tracking category to all transactions
- Set the color scheme of the Xero dashboard
- Customize the layout and content of invoices, quotes, and statements sent to customers (Correct answer)
Correct answer: Customize the layout and content of invoices, quotes, and statements sent to customers
Branding themes in Xero control the design, logo, and layout of customer-facing documents like invoices and quotes.
Question 7: What is the function of the tracking categories in Xero?
- To monitor cash flow.
- To track and report specific areas of the business. (Correct answer)
- To categorize sales by customer group.
- To track employee timesheets.
Correct answer: To track and report specific areas of the business.
Tracking categories in Xero allow businesses to segment and analyze financial data beyond the standard chart of accounts. They enable reporting on specific dimensions such as departments, projects, or locations, providing more granular insights into different areas of the business's performance and profitability.
Question 8: Why is bank reconciliation important in Xero?
- To automate tax filing.
- To generate financial statements automatically.
- To increase the number of invoices generated.
- To ensure accurate financial records and avoid discrepancies. (Correct answer)
Correct answer: To ensure accurate financial records and avoid discrepancies.
Bank reconciliation is a critical accounting process that compares a company's bank statement with its cash ledger. Its importance lies in identifying and correcting any discrepancies, ensuring that the financial records accurately reflect the true cash position, which is vital for accurate financial reporting and informed decision-making.
Question 9: How should a Xero Certified Advisor professional handle a situation where quality assurance & continuous improvement protocols conflict with practical constraints?
- Avoid addressing the conflict entirely
- Always ignore the protocols in favor of practicality
- Document the conflict and seek guidance from appropriate authorities (Correct answer)
- Make a unilateral decision without consultation
Correct answer: Document the conflict and seek guidance from appropriate authorities
When protocols conflict with practical constraints, the professional approach is to document the conflict and seek guidance, ensuring transparency and compliance while working toward a resolution.
Question 10: Which of the following is a standard pay frequency option supported by Xero Payroll for US businesses?
- Annually
- Daily
- Bi-weekly (every two weeks) (Correct answer)
- Quarterly
Correct answer: Bi-weekly (every two weeks)
Xero Payroll supports weekly, bi-weekly, semi-monthly, and monthly pay frequencies; bi-weekly is the most widely used option for US employers.
Question 11: A business receives a foreign currency payment that appears in the Xero bank feed in USD, but the account is set to AUD. How does Xero handle the exchange difference?
- Xero calculates and posts an unrealized or realized gain/loss to the exchange gain/loss account (Correct answer)
- Foreign currency transactions cannot be reconciled in Xero
- Xero ignores the foreign currency transaction entirely
- The user must manually convert the amount before reconciling
Correct answer: Xero calculates and posts an unrealized or realized gain/loss to the exchange gain/loss account
Xero automatically calculates currency exchange gains or losses and posts them to the designated foreign currency gain/loss account at reconciliation.
Question 12: A Xero organization wants to use Projects to track profitability by client engagement. What must be done before time and expenses can be logged to a project?
- Enable Projects in the Xero subscription and create a project record (Correct answer)
- Set up a dedicated bank account for project expenses
- Configure a tracking category named 'Project'
- Create a separate Xero organization for each project
Correct answer: Enable Projects in the Xero subscription and create a project record
Xero Projects is a feature that must be enabled in the subscription, and then a specific project record must be created before logging time or costs.
Question 13: When emailing an invoice from Xero, which element is automatically included in the email body by default?
- The full invoice PDF inline in the email body
- A secure link to view and pay the invoice online, plus the invoice PDF as an attachment (Correct answer)
- Only a plain-text payment request with no attachment
- A CSV export of the invoice line items
Correct answer: A secure link to view and pay the invoice online, plus the invoice PDF as an attachment
Xero's default invoice email includes a link to the online invoice (where the customer can pay) and the invoice PDF as an attachment.
Question 14: What is FUTA, and who is solely responsible for paying it?
- A state unemployment insurance tax shared between employer and employee
- A federal unemployment tax paid entirely by the employer (Correct answer)
- A federal tax withheld equally from both employer and employee
- A Medicare surcharge for high-earning employees
Correct answer: A federal unemployment tax paid entirely by the employer
FUTA (Federal Unemployment Tax Act) is a federal unemployment tax paid entirely by the employer — it is never withheld from employee wages.
Question 15: What happens when you archive an account in Xero's chart of accounts?
- All transactions linked to it are deleted
- The account balance is transferred to a default account
- The account is hidden from new transaction entry but historical data is retained (Correct answer)
- The account is permanently removed from Xero
Correct answer: The account is hidden from new transaction entry but historical data is retained
Archiving an account hides it from future transaction entry while preserving all historical data associated with it.
Question 16: In Xero Payroll, what happens when you 'void' a previously approved payroll run?
- It reverses the payroll journal entries and marks the run as void so corrections can be made (Correct answer)
- It permanently deletes the employee records linked to that run
- It sends an automated notice to the IRS about the payroll correction
- It automatically re-runs payroll with updated tax tables applied
Correct answer: It reverses the payroll journal entries and marks the run as void so corrections can be made
Voiding a payroll run in Xero reverses the associated journal entries and changes the run's status to void, allowing you to correct errors and reprocess the payroll.
Question 17: In Xero, the 'Accounts Watchlist' on the dashboard helps with cash management by:
- Generating a daily cash flow forecast
- Sending payment reminders to customers
- Automatically paying bills when cash is available
- Displaying balances of key accounts so you can monitor cash positions at a glance (Correct answer)
Correct answer: Displaying balances of key accounts so you can monitor cash positions at a glance
The Accounts Watchlist widget shows live balances for selected accounts, giving users an instant overview of their cash position.
Question 18: Which Xero account type should petty cash typically be set up as?
- Bank account (other) (Correct answer)
- Fixed asset account
- Expense account
- Accounts Payable
Correct answer: Bank account (other)
Petty cash is set up as a 'Bank account (other)' in Xero so transactions can be reconciled and tracked like any other cash account.
Question 19: What ethical consideration is most relevant to professional standards & ethics in Xero Certified Advisor practice?
- Avoiding all professional development activities
- Following only those rules that are convenient
- Prioritizing personal advancement over professional duties
- Maintaining confidentiality and acting in the best interest of stakeholders (Correct answer)
Correct answer: Maintaining confidentiality and acting in the best interest of stakeholders
Maintaining confidentiality and acting in the best interest of stakeholders is the cornerstone ethical consideration for professional standards & ethics in professional practice.
Question 20: Which form must US employers file quarterly to report federal payroll taxes withheld and employer contributions?
- Form W-2
- Form 1099-NEC
- Form 940
- Form 941 (Correct answer)
Correct answer: Form 941
Form 941 (Employer's Quarterly Federal Tax Return) is filed each quarter to report federal income tax, Social Security, and Medicare taxes withheld from employee wages.
Question 21: In Xero, what does a 'Transfer' transaction in the bank reconciliation represent?
- A payroll disbursement to employees
- An automated direct debit from a customer
- A payment to a supplier that bypasses accounts payable
- A movement of funds between two bank accounts that are both tracked in Xero (Correct answer)
Correct answer: A movement of funds between two bank accounts that are both tracked in Xero
A Transfer records the movement of money between two Xero bank accounts, such as from a checking account to a savings account.
Question 22: What is a common challenge professionals face when applying quality assurance & continuous improvement principles in Xero Certified Advisor?
- Lack of any professional development opportunities
- Having too much support from colleagues
- Balancing theoretical knowledge with practical application (Correct answer)
- Excessive simplicity of industry regulations
Correct answer: Balancing theoretical knowledge with practical application
Balancing theoretical knowledge with practical application is a well-recognized challenge, as real-world scenarios often present complexities not covered in standard training.
Question 23: When setting up a bank rule in Xero, which condition type would you use to match transactions from a specific supplier by their reference number?
- Payee
- Description
- Amount
- Reference (Correct answer)
Correct answer: Reference
The 'Reference' condition in bank rules matches transactions based on text in the reference field of the bank feed.
Question 24: What should you do if an invoice payment is recorded in error?
- Contact the bank to fix the issue.
- Manually reverse or adjust the payment. (Correct answer)
- Re-create the invoice with the correct payment.
- Delete the invoice completely.
Correct answer: Manually reverse or adjust the payment.
If an invoice payment is recorded incorrectly in Xero, it's crucial to manually reverse or adjust the payment entry. This action corrects the error without deleting the entire invoice history, ensuring that the invoice status, customer balance, and bank reconciliation remain accurate. It maintains an audit trail and keeps your financial records reliable.
Question 25: Which of the following best describes 'overpayment' handling in Xero's bank reconciliation?
- The full payment is rejected and returned to the bank feed as unreconciled
- Xero flags the overpayment as fraud and blocks reconciliation
- The overpayment is recorded as a credit on the contact's account and can be applied to future invoices (Correct answer)
- The excess amount is automatically written off as a bad debt
Correct answer: The overpayment is recorded as a credit on the contact's account and can be applied to future invoices
When a payment exceeds the invoice amount, Xero records the overpayment as a credit on the contact's account for application to future invoices.
Question 26: By what date must US employers provide W-2 forms to employees for the previous tax year?
- January 31 (Correct answer)
- December 31
- March 15
- April 15
Correct answer: January 31
Employers are legally required to provide W-2 forms to employees and file copies with the Social Security Administration by January 31 of the following year.
Question 27: In Xero, how does a 'bank rule' differ from 'cash coding'?
- Bank rules auto-suggest coding for future matching transactions; cash coding is a one-time bulk coding interface (Correct answer)
- Bank rules apply only to credit card accounts; cash coding applies to checking accounts
- Cash coding is only available to Xero advisors, not business owners
- Bank rules require manual approval each time; cash coding is fully automated
Correct answer: Bank rules auto-suggest coding for future matching transactions; cash coding is a one-time bulk coding interface
Bank rules create standing automation that applies to new matching transactions, while cash coding is a manual batch tool for coding many transactions at once.
Question 28: In Xero, what is 'Cash Coding' primarily used for?
- Generating payroll reports
- Setting up a new bank account connection
- Importing a bank statement file
- Quickly coding multiple bank transactions at once without creating individual bills or invoices (Correct answer)
Correct answer: Quickly coding multiple bank transactions at once without creating individual bills or invoices
Cash Coding allows users to code multiple transactions in a spreadsheet-style view, speeding up the reconciliation process.
Question 29: What does 'Unreconciled Items' in a Xero bank reconciliation report indicate?
- Transactions that exist in Xero or the bank statement but have not yet been matched to each other (Correct answer)
- Bank accounts that are not connected to a live feed
- Invoices that are overdue but unpaid
- Transactions that have been deleted from Xero
Correct answer: Transactions that exist in Xero or the bank statement but have not yet been matched to each other
Unreconciled items are transactions present in Xero's ledger or the bank statement that haven't yet been matched and confirmed.
Question 30: A business owner notices that the 'Balance in Xero' is higher than the 'Statement Balance' during reconciliation. What is the most likely cause?
- The bank feed connection has expired
- Outstanding payments or checks have been issued but not yet cleared the bank (Correct answer)
- An invoice has been incorrectly voided
- Duplicate bank feed transactions have been imported
Correct answer: Outstanding payments or checks have been issued but not yet cleared the bank
Outstanding issued payments that haven't cleared the bank yet will cause the Xero balance to exceed the statement balance.
Question 31: Which of the following employee details is required when setting up a new employee in Xero Payroll (US)?
- Emergency contact information
- Employee's personal home address only
- Social Security Number (SSN) and filing status (Correct answer)
- Date of birth and personal email address
Correct answer: Social Security Number (SSN) and filing status
The Social Security Number (SSN) and filing status are required for accurate payroll tax calculations and year-end W-2 reporting.
Question 32: Which of the following best describes a key competency required for communication & stakeholder management in Xero Certified Advisor certification?
- Delegation of all complex tasks to supervisors
- Memorization of all relevant regulations verbatim
- Ability to work independently without any oversight
- Critical thinking and evidence-based decision making (Correct answer)
Correct answer: Critical thinking and evidence-based decision making
Critical thinking and evidence-based decision making is essential for communication & stakeholder management, as professionals must analyze situations and apply knowledge appropriately.
Question 33: Which of the following would cause a reconciling item on a Xero bank reconciliation?
- An invoice paid and cleared the bank on the same day
- A supplier bill coded to the correct expense account
- A bank transfer between two Xero accounts already recorded in both
- A check written in Xero but not yet presented to the bank (Correct answer)
Correct answer: A check written in Xero but not yet presented to the bank
Outstanding checks issued in Xero but not yet cleared the bank are classic reconciling items because they exist in the books but not the statement.
Question 34: When using Xero's 'Find & Recode' feature (available in some regions), what is its primary use in a reporting context?
- Merging duplicate contacts
- Exporting reports to Excel
- Batch-recoding transactions to correct account or tracking codes before reporting (Correct answer)
- Deleting duplicate transactions
Correct answer: Batch-recoding transactions to correct account or tracking codes before reporting
Find & Recode lets advisers search for transactions and bulk-update their account codes, tax rates, or tracking categories to fix reporting errors.
Question 35: A Xero advisor needs to attach a PDF of a supplier's original bill to the Xero bill record. Where is this done?
- In the contact's document library only
- Through the Files menu under the Accounts tab
- Via the bank reconciliation screen
- Using the 'Attach files' option on the bill (Correct answer)
Correct answer: Using the 'Attach files' option on the bill
Each bill in Xero has an 'Attach files' or paperclip icon that lets you upload supporting documents directly to that transaction.
Question 36: In Xero Payroll, what is the purpose of a 'deduction' on an employee's pay?
- To adjust the employee's assigned pay schedule
- To reduce the employee's gross pay for items like health insurance premiums or 401(k) contributions (Correct answer)
- To add additional compensation to the employee's gross earnings
- To record the employer's share of payroll tax expenses
Correct answer: To reduce the employee's gross pay for items like health insurance premiums or 401(k) contributions
Deductions reduce an employee's gross pay and can be pre-tax (such as 401k or health insurance premiums) or post-tax, directly affecting the employee's net take-home pay.
Question 37: What ethical consideration is most relevant to regulatory compliance & legal framework in Xero Certified Advisor practice?
- Prioritizing personal advancement over professional duties
- Avoiding all professional development activities
- Maintaining confidentiality and acting in the best interest of stakeholders (Correct answer)
- Following only those rules that are convenient
Correct answer: Maintaining confidentiality and acting in the best interest of stakeholders
Maintaining confidentiality and acting in the best interest of stakeholders is the cornerstone ethical consideration for regulatory compliance & legal framework in professional practice.
Question 38: Which technology trend is most likely to impact professional standards & ethics in the Xero Certified Advisor field in coming years?
- Complete elimination of human professionals
- Digital tools for enhanced data collection, analysis, and reporting (Correct answer)
- Return to exclusively paper-based systems
- Reduction in the need for professional certification
Correct answer: Digital tools for enhanced data collection, analysis, and reporting
Digital tools for enhanced data collection, analysis, and reporting represent the most significant and practical technology trend impacting professional standards & ethics, augmenting rather than replacing professional expertise.
Question 39: When a Xero Profit and Loss is run on a 'cash basis', which transactions are excluded?
- Paid invoices and bills
- Unpaid (outstanding) invoices and bills (Correct answer)
- Bank transactions coded directly
- Manual journals
Correct answer: Unpaid (outstanding) invoices and bills
On a cash basis P&L, only transactions where cash has moved are included; unpaid invoices and bills are excluded until payment is received or made.
Question 40: In Xero's bank reconciliation, what does 'Create' allow you to do when matching a bank statement line?
- Create a new transaction (invoice, bill, or spend/receive money) directly from the reconciliation screen (Correct answer)
- Create a new bank account
- Create a journal entry to clear the line
- Create a bank rule for future use
Correct answer: Create a new transaction (invoice, bill, or spend/receive money) directly from the reconciliation screen
The 'Create' option on the bank reconciliation screen allows you to generate a new transaction directly without leaving reconciliation.
Question 41: Which of the following correctly describes a 'lock date' in Xero?
- The date bank feeds stop importing automatically
- The date the chart of accounts was last modified
- The subscription renewal date for the organization
- A date that prevents editing of transactions on or before it (Correct answer)
Correct answer: A date that prevents editing of transactions on or before it
A lock date in Xero prevents users from creating, editing, or deleting transactions dated on or before that date.
Question 42: When processing payroll in Xero (US), which federal payroll tax is split equally between the employer and the employee?
- Federal income tax
- FICA (Federal Insurance Contributions Act) — Social Security and Medicare (Correct answer)
- FUTA (Federal Unemployment Tax Act)
- State income tax
Correct answer: FICA (Federal Insurance Contributions Act) — Social Security and Medicare
FICA taxes — Social Security (6.2%) and Medicare (1.45%) — are each paid half by the employer and half by the employee, totaling 15.3% combined.
Question 43: A Xero advisor wants to ensure that all purchase invoices over $5,000 require approval before payment. Which Xero feature supports this workflow?
- Tracking categories
- Repeating bills
- Bank rules
- Awaiting Approval status on bills (Correct answer)
Correct answer: Awaiting Approval status on bills
Bills can be saved in 'Awaiting Approval' status in Xero, requiring an authorized user to approve them before they can be paid.
Question 44: In Xero Payroll (US), which report provides a summary of all wages and taxes for employees during a selected period?
- Accounts Payable Aging Report
- Balance Sheet
- Profit and Loss Statement
- Payroll Activity Summary (Correct answer)
Correct answer: Payroll Activity Summary
The Payroll Activity Summary report displays wages, deductions, and taxes for all employees over a selected date range, giving an overview of payroll costs and liabilities.
Question 45: How can you customize reports in Xero?
- By manually adjusting each transaction.
- Reports are automatically customized based on user preferences.
- Customizing reports is not possible in Xero.
- By selecting date ranges and applying filters. (Correct answer)
Correct answer: By selecting date ranges and applying filters.
Xero offers robust customization options for its reports, primarily through selecting specific date ranges and applying various filters. Users can refine data by tracking categories, contacts, or account types, allowing for tailored insights relevant to specific business analysis needs. This flexibility helps users focus on the most pertinent financial information.
Question 46: What is the primary purpose of professional standards & ethics in the context of Xero Certified Advisor?
- To reduce organizational costs exclusively
- To eliminate the need for ongoing training
- To ensure consistent quality and professional accountability (Correct answer)
- To replace established industry guidelines
Correct answer: To ensure consistent quality and professional accountability
Professional Standards & Ethics in Xero Certified Advisor primarily ensures consistent quality and professional accountability, forming the foundation of competent practice in this field.
Question 47: In Xero, if you need to reconcile a single bank feed line against MULTIPLE invoices (e.g., one payment for several invoices), which approach should you use?
- Record a journal entry to split the payment across invoices
- Use 'Find & Match' and select multiple invoices to match against the single bank line (Correct answer)
- Manually adjust each invoice amount to zero separately
- Create a new credit note to split the amount
Correct answer: Use 'Find & Match' and select multiple invoices to match against the single bank line
'Find & Match' in Xero allows you to select multiple transactions or invoices to match against a single bank feed line.
Question 48: What is the significance of customizing invoices in Xero?
- To reduce the time spent on invoices.
- To make invoices more personal.
- To create more user-friendly invoices.
- To align invoices with company branding and standards. (Correct answer)
Correct answer: To align invoices with company branding and standards.
Customizing invoices in Xero allows businesses to incorporate their logo, brand colors, and specific layout preferences. This not only enhances professionalism and reinforces brand identity but also ensures consistency in all client communications, making invoices easily recognizable and trustworthy.
Question 49: A US-based business in Xero wants to record that a supplier invoice is subject to sales tax. Where is sales tax applied?
- Automatically based on the payment account
- In the contact's default settings only
- In the organization's tax settings, not on the bill
- On each line item via the Tax Rate field (Correct answer)
Correct answer: On each line item via the Tax Rate field
Tax rates are selected on each individual line item of a bill, giving flexibility for mixed-tax invoices.
Question 50: Which report in Xero shows you all unreconciled transactions and helps identify the difference between your book balance and bank balance?
- Aged Receivables
- Bank Reconciliation Summary (Correct answer)
- Balance Sheet
- Profit and Loss
Correct answer: Bank Reconciliation Summary
The Bank Reconciliation Summary report details unreconciled items and explains the difference between the statement and Xero balances.
Question 51: How do you set up payroll in Xero?
- Use an external software for payroll management.
- Contact your bank to set up payroll.
- Request payroll setup from Xero support.
- Enable payroll in the settings and enter employee information. (Correct answer)
Correct answer: Enable payroll in the settings and enter employee information.
Setting up payroll in Xero involves enabling the payroll feature within the software's settings and then populating it with all necessary employee details. This allows Xero to accurately calculate wages, deductions, and taxes, generate payslips, and manage payroll compliance, streamlining the entire process.
Question 52: Which of the following best describes a key competency required for professional standards & ethics in Xero Certified Advisor certification?
- Delegation of all complex tasks to supervisors
- Memorization of all relevant regulations verbatim
- Ability to work independently without any oversight
- Critical thinking and evidence-based decision making (Correct answer)
Correct answer: Critical thinking and evidence-based decision making
Critical thinking and evidence-based decision making is essential for professional standards & ethics, as professionals must analyze situations and apply knowledge appropriately.
Xero Advisor Certification
The Xero Advisor Certification validates proficiency in using Xero accounting software to manage client accounts, reconcile transactions, and generate reports.
Exam Rules
- You can skip questions and return to them later
- Flag questions for review before submitting
- No feedback shown until you submit the entire exam
- Unanswered questions count as wrong — answer everything
- 10 pretest questions are mixed in and don't affect your score
- Timer auto-submits when time runs out
- Your progress is auto-saved every 30 seconds