Skip to main content

Receipts Report and Reconciliation receipts filters

Filter Reporting → Receipts Report and Reconciliation → Receipts by receipt date, with grid filters and filtered CSV/XLS export.

The Receipts Report and Reconciliation → Receipts list now filter on each receipt’s receipt date (inclusive), so a date range matches the same receipts in both places.


1. Receipts Report

  • Go to Reporting → Receipts Report

  • Set Receipt date from and Receipt date to (DD/MM/YYYY)

  • Optionally narrow by department, job status or your own departments

  • Run the report

Billable company on each row comes from the receipt. Unreadable dates show an error instead of downloading the full list.

The report still shows job info, receipt details, cost codes, purchase types, amounts and billable company.


2. Reconciliation → Receipts

  • Go to Reconciliation → Receipts [confirm path: Finance → Reconciliation → Receipts]

  • Open Filters to set receipt date range and other sheet filters (saved for your session)

  • Use column filters on the grid for Receipt ID, Job, Billable Company, Supplier (equals or contains), Amount and Xero status

Amount filters accept typed currency such as $1,234.50 or ($1.00). Text that is not an amount matches no rows.


3. Export the filtered list

  • Apply the Filters sheet and any column filters you need

  • Choose Export CSV or Export XLS

  • The file builds in Background Tasks using the current filters and sort

Exports honour Xero filters but omit the Xero link column. XLS includes a Filters worksheet.


Notes

  • Report amounts are ex-GST; the Reconciliation grid and export use the stored receipt amount, so totals can differ

  • The report can still narrow by department and job status; the Reconciliation grid does not use those same filters


Summary

  • Both screens filter by receipt date, not job start/end dates

  • Reconciliation adds a Filters sheet, richer grid filters, and filtered CSV/XLS via Background Tasks

Did this answer your question?