Understanding the Transaction List Report
If you’re trying to get a clear view of what’s happened in your business over a certain period, the Transaction List report is a great place to start.
It gives you a simple, line-by-line breakdown of all transactions for your business within the timeframe you choose. The report brings together activity from your bank and ledger so you can easily see what’s been happening.
How to find the Transaction List report
You can access the report directly from the Reports section in Solo:
More → Reports → Transaction List
Before the report opens, you’ll be asked to choose a few options:
- Select your date range (for example this month, this financial year, etc.)
- Choose the export format - either Excel (CSV) or PDF
From here you have two options:
- Select Share to send the report straight away, or
- Select the three dots to Preview and Share, which lets you preview the report first before sharing it.
How the Transaction List report works
Cash-based reporting
The Transaction List uses cash accounting, which means it shows transactions based on when money actually moves in or out.
So instead of using the invoice date, it records transactions for the time/date when the payment was received or paid.
Cash vs Accrual :
- Cash accounting: Records money when it actually comes in or goes out.
- Accrual accounting: Records income and expenses when the invoice is generated, even if the money hasn’t been paid yet.
It’s built from Solo’s ledger transactions, so it can include things like income, expenses, refunds, assets, purchases and other money movements that affect your balances.
Date ranges
You can run the report for:
- This month (default)
- This financial quarter
- Last financial quarter
- This financial year
- Last financial year
What the report shows
Each line in the Transaction List represents a single ledger transaction. The report includes details like:
- Account/category code
- Transaction date
- Transaction type (for example: invoice, expense, refund)
- Reference number
- Transaction description
- Amounts
If you’re not registered for GST, the Transaction List is one of the core reports available in Solo, alongside the Profit and Loss report.
Filtering and analysing the data
If you export the report as Excel (CSV), you can use spreadsheet tools to dig into the data further. This allows you to:
- Apply filters (for example viewing only asset accounts or certain categories)
- Sort by date, amount, contact, or account
- Focus on specific transactions, like amounts over a certain value
This can be helpful if you’re reviewing a particular part of your business activity or preparing information for your accountant.
If you have any questions about the Transaction List report or need help interpreting the data, feel free to ask below, and the team will be happy to help.