Xero Certified Advisor Xero Reporting and Financial Analysis 3 — Questions and Answers
Question 1: Which Xero report provides a point-in-time snapshot of all asset, liability, and equity balances?
- Profit and Loss
- Balance Sheet (Correct answer)
- Cash Flow Statement
- Trial Balance
Correct answer: Balance Sheet
The Balance Sheet (Statement of Financial Position) in Xero shows assets, liabilities, and equity at a specific date.
Question 2: In Xero, which statement shows the movement of cash from operating, investing, and financing activities?
- Bank Reconciliation Summary
- Cash Flow Statement (Correct answer)
- Cash Summary
- Receipts and Payments
Correct answer: Cash Flow Statement
Xero's Cash Flow Statement (indirect method) categorizes cash movements into operating, investing, and financing sections.
Question 3: When publishing a report in Xero, what does 'Publish' do that simply saving a report does not?
- Sends the report by email automatically
- Locks the report as a permanent record in the Files library (Correct answer)
- Converts the report to PDF for download
- Shares the report with all users in the organisation
Correct answer: Locks the report as a permanent record in the Files library
Publishing a report in Xero creates a locked, dated copy stored in the Files library, preserving the data as it was at that moment.
Question 4: Which Xero report is most useful for reconciling the total of all account balances before preparing financial statements?
- Account Transactions
- Trial Balance (Correct answer)
- Journal Report
- Balance Sheet
Correct answer: Trial Balance
The Trial Balance lists all accounts with their debit or credit balances, confirming debits equal credits before financials are prepared.
Question 5: A Xero adviser wants to review every manual journal entry posted in a period. Which report should they use?
- Account Transactions
- Aged Payables
- Journal Report (Correct answer)
- Reconciliation Summary
Correct answer: Journal Report
The Journal Report in Xero lists all manual journal entries, showing the date, reference, accounts debited and credited, and amounts.
Question 6: In Xero's Balance Sheet report, which comparison option lets you view balances for each month of the financial year side by side?
- Year to Date
- Monthly columns (Correct answer)
- Quarter comparison
- Period over Period
Correct answer: Monthly columns
Selecting monthly columns in the Balance Sheet comparison settings displays a column for each month of the selected financial year.
Question 7: What is the purpose of the 'Prepayments' section that appears on a Xero Balance Sheet?
- It shows income received in advance from customers
- It shows expenses paid in advance that have not yet been consumed (Correct answer)
- It lists all outstanding purchase orders
- It records depreciation charges for the period
Correct answer: It shows expenses paid in advance that have not yet been consumed
Prepayments on the Balance Sheet represent amounts paid for goods or services not yet received or used, classified as a current asset.
Xero Certified Advisor Xero Reporting and Financial Analysis 3
Which Xero report provides a point-in-time snapshot of all asset, liability, and equity balances?