Fixed Asset Reconciliation Report (older version)

The Fixed Asset Reconciliation report shows a summary of book value, credits and debits to fixed asset accounts, and accumulated depreciation, helping you to quickly reconcile the balance sheet and the fixed asset register.

Reports are available from Reports > All Reports. Your user role will determine whether you can see this report, and if so, whether you can save and publish it or just view it.
Reports and budget role comparison

What can you do with the Fixed Asset Reconciliation report?

Other things you can do with this report:

Fixed Asset Reconciliation

Generate the Fixed Asset Reconciliation Summary report

Generate report

Access the Fixed Asset Reconciliation report from the All Reports screen, in the 'Position Reports' section. The Fixed Asset Reconciliation is generated from the start of your financial year and runs until the date chosen.

Enter or edit

rep - button - update.png

If you are viewing a report produced by someone with the Adviser user role, you may see notes or a summary on the report. You may be able to export, archive or edit the report, depending on your user role.
Reports and budget role comparison

Choose or update the options by which to run the report:

Fields

Date

Select a month and year that you want to see the summary report for. The date will be the current month by default.

Update

When the details of the report you want to run are entered or updated, click Update to re-generate the report.

Filtering

Click the 'More options' link to unravel more options to allow you to filter the report by tracking categories (if your organisation has these set up).

More fields

Click the 'Fewer Options' link if you want to close this option.

Filter by

If you have set up tracking categories, you can filter the report by one or all of the options for each category.

Tracking options

  • Either one or both of the tracking categories you have set up will display.
  • By default, the report will not be filtered so all the transactions coded to each account listed for the dates of the report will be included.
  • For each tracking category displayed, you can choose to view the report with no filter (i.e. all the transactions in each account), one option or all options.

Set up tracking categories to monitor different areas of your business

View totals

Report totals

The report is broken up into sections for each fixed asset account that has at least one non-zero balance in the section. These sections are sorted alphabetically and the total row shows the total differences across all sections.

Total Differences
  • Opening Balance – Xero’s balance for this account as at the date of the report.
  • Book Value – shows the book value as at the report end or start date.
  • Accum Dep – Xero’s balance for this account as at the date of the report.
  • Closing Balance – Xero’s balance for this account as at the closing date of the report.

Select

From the Fixed Asset Reconciliation Report you can drill down into the figures for more information.

Depreciation Schedule

Asset row

Click on any figure in the Asset Register row to view the Depreciation Schedule showing actual depreciation for the report period.

Dep schedule

Account Transactions

Link to report

From the Debits, Credits or Accum Dep (at the report end date), in the Balance Sheet row, click on any figure to drill down to the account transaction for the report period.

Account transactions

The other columns (Book Value and Accum Dep at the start of the report) drill down to the Balance Sheet as at the report date.

Export your report

To export the report:

  1. Click Export, then select your preferred export option:

    • Excel
    • PDF (printable format)
    • Google Sheets
  2. Open, save or print the file as you need.

You might also be interested in

Run the Fixed Asset Reconciliation report (new version)