Monthly profit and loss
Compare monthly income and expenses by account.
Xero reports
and dashboards
Build Xero reports and dashboards for monthly profit and loss, invoices and outstanding balances. Explore your accounting data with Filament.
Your Xero data, connected.
Xero holds your accounting, contacts, invoices, bank transactions and, for Australian organisations, payroll records.
Filament syncs those records into your warehouse and reconstructs a monthly profit-and-loss general ledger for reporting and dashboards.
Invoices and outstanding balances
See which invoices are paid and what is still outstanding.
Income and expenses by tracking category
Understand monthly income and expenses across your tracking categories.
Data we sync
Monthly general ledgerExample fields: Journal date, Account code
Monthly profit-and-loss totals by account, with account codes, types and tracking-category links where activity is assigned.
journal_dateaccount_codeaccount_typenet_amount
ContactsExample fields: Contact id, Name
Customers and suppliers with contact details, status, receivable and payable balances, and default account settings.
contact_idnameis_customeris_supplier
InvoicesExample fields: Invoice id, Type
Sales invoices and bills with dates, status, contact, currency, amounts due, paid and credited, and total tax.
invoice_idtypestatuscontact_idtotal
Bank transactionsExample fields: Bank transaction id, Type
Spend and receive-money transactions with reconciliation status, bank account, contact, currency and totals.
bank_transaction_idtypedateis_reconciledtotal
Accounts and trackingExample fields: Account id, Code
The chart of accounts, tracking categories and their options, plus organisation details used to interpret reports.
account_idcodetypetracking_category_id
Australian payrollExample fields: Employee id, Leave application id
Employees, leave applications and their pay-period breakdowns for Australian Xero organisations with payroll provisioned. The connecting user must have payroll access. Leave periods use zero-based positions within each application.
employee_idleave_application_idleave_period_status
See the
whole picture.
Filament brings your apps together in a managed warehouse. Build dashboards, share reports and ask questions in plain English.
Explore the demo dashboard
Beach Clean 2026 Key Metrics
Compared toPrevious year
Campaign HealthFundraisersAcquisitionWebsite Traffic
Funds raised$118,050Goal: $245,000
Sign-ups19482% activation rate
Donations399Median gift: $100
Avg. donation$295.86Across the campaign
Funds raised vs target
$118,050 of $245,000
Sign-ups vs target
194 of 250
Cumulative funds raised 2026 Previous year
Powered by 
Trusted by the best
“Filament has been a game-changer. Everyone can self-serve and get answers on demand. The integrations are plug-and-play, and we've even cancelled our data warehouse plans — Filly does it all.”
Kevin RassoolTech Lead, High Impact Athletes
“Filament has supercharged our efficiency and levelled up our outputs. Beyond time savings, the mental offload has been priceless, and I can focus on growth, not grind!”
Faith FuhrerMarketing & Communications, Pet Medical Crisis
Your questions, answered.
How should I interpret these reports?
- Monthly profit and loss
- Compare income and expense totals by account and month. The native general ledger is reconstructed from monthly Profit and Loss reports, so use complete calendar months rather than daily or mid-month journal comparisons. Signed ledger values are negative for revenue and other income, and positive for expenses.
- Invoices and outstanding balances
- Report on sales invoices and bills by contact, status and currency. Keep current amounts due separate from amounts paid, and distinguish an outstanding-balance snapshot from historical cash collection.
- Income and expenses by tracking category
- Explore monthly results by the tracking categories assigned in Xero. Show unassigned activity separately so category totals are not mistaken for the full business total.
How do I connect Xero?
The person connecting must be able to authorise the organisation and hold Xero’s reports role.
- Open Apps in Filament and add Xero.
- Select Connect to Xero and authorise your organisation.
- Choose one, two or five years of initial history.
- Add any useful account context and complete setup.
Each source uses the first tenant returned by Xero’s consent. Connect each additional organisation separately.
How often does Xero data refresh?
Every six hours. Contacts, accounts, tracking categories and organisation details are refreshed in full; transactions and Australian payroll use Xero's updated-since filters. The current and two prior ledger months are re-read to include late changes.
How far back can the first sync go?
Choose one, two or five years when you set up the connection. The general ledger is requested one calendar month at a time across that period.
Why is the general ledger monthly?
The native connection reconstructs profit-and-loss activity from monthly Profit and Loss reports, rather than Xero’s premium Journals endpoint. Journal dates are the first day of each month; daily, mid-month and balance-sheet journal analysis is unavailable.
What does the person connecting Xero need?
They must be able to authorise the Xero organisation and hold Xero's reports role so the Profit and Loss report can be read. Australian payroll also requires payroll to be provisioned and accessible to the connecting user.
Does Australian payroll sync for every organisation?
No. Employee and leave data is synced only when Xero reports the connected organisation's country as Australia.