Show images
Transaction reports help you track, analyse, and download transaction data in real time. It’s a powerful tool for finance teams who need clarity on spend and full control over reporting.
They provide:
- Real-time data to track activity as it happens
- Custom filters to isolate the exact transactions you care about
- Download formats that fit your workflows and tools
How to view Transaction reports in the web app
To access reports in the web app, from the left-side menu, select Reports > Transactions. By default, you'll see all transactions from the last 30 days, shown in a table view with a quick financial summary at the bottom.
Financial summary
The financial summary gives you a quick overview of:
- Amount out – Total outgoing transactions
- Amount in – Total incoming funds
- Taxable – Total amount subject to tax
- VAT – Total VAT amount
Note: The financial summary updates as you apply filters. The figures are based on the filters that are currently applied. By default, when you first view the Transaction report section, the applied filter will be transactions in the last 30 days.
What's the difference between Taxable and VAT?
The Taxable amount is the total amount calculated from all transactions where a VAT rate has been assigned. Only transactions that have been assigned a VAT rate are included in the calculation.
The VAT amount is the calculated portion of VAT based on the percentage set in the assigned VAT rate (e.g. 20%).
Note: If a transaction is assigned a VAT rate with a value of 0%, it will still be included in the Taxable amount but will not be calculated in the VAT amount.
Customising your view
You may need a quick top-line summary one day and a detailed dataset the next. You can toggle column visibility to add or remove data from the table to show the exact data you need. This flexibility helps you build the exact dataset you need without cluttering your view.
Note: The column visibility settings only reflect your view in the web app. It doesn't control the arrangement or visibility of columns in downloaded reports. If you need to customise the format of downloaded reports, consider using the Custom Template Export feature.
Essential columns (always shown)
These columns are always visible and can't be toggled off:
- Amount
- Authorisation date
- Description
Default columns
These columns are visible by default. You can toggle their visibility freely:
- Attachment
- Card
- Card name
- Wallet name
- Expense category
- Lists
- Mandatory details
- Transaction owner
- Transaction status
- Transaction type
- VAT rate
Note: If you make any changes to the column visibility settings, you can reset the view by selecting Reset to default. This will make the essential and default columns visible again.
Optional columns
These columns are not visible by default. You can toggle their visibility freely:
- Approval status
- Authorisation string
- Card type
- Exchange rate
- Expense policy
- Expense report No.
- Expense type
- Fee
- Flagged
- Foreign currency amount
- Group
- Merchant categories
- Notes
- Payment method
- Reviewed by
- Settlement date
- Transfer from
- Transfer to
- VAT amount
Filtering your data
Filters let you refine your dataset to zero in on what matters. You can combine and apply multiple filters at once to refine the dataset in real-time.
You'll find 5 main filters:
- Date
- Currency
- Wallets
- Cards
- Users
1. Date filter
By default, transactions are displayed by their Authorisation date. If you'd prefer to view by Settlement date, you can make this change by selecting the date filter dropdown.
What’s the difference between Authorisation and Settlement dates?
- Authorisation date is the date when the payment was made and the available balance is updated. Authorisation date is useful for tracking spend as it happens.
- Settlement date is when the payment was completed, the ledger balance updated, and the money was actually moved from the account. This can happen a few days after the authorisation date, depending on the merchant. Settlement date is useful for reconciliation.
Note: When you view your data in the mobile app or web app, the transaction dates are shown in your local time zone e.g. the time zone of the device you're using to access Soldo. When you export data from Soldo, the transaction dates appear in the time zone of the market where your account is registered regardless of where you are located when you generate and export the report.
You can also choose the date range for your report.
Choose from:
Filter by:
- Authorisation date
- Settlement date
Date range:
- Last 30 days (default)
- This month
- Last month
- This year
- Last year
- Custom range (via calendar selector)
2. Currency filter
If you have multiple currencies activated, you can select the currency for your report from the currency dropdown.
Note: You can only view one currency at a time (e.g. GBP, EUR, USD).
3. Wallets filter
If you want to quickly find transactions funded from particular wallets, you can apply the wallets filter. By default, all wallets are listed even if they've been deleted, but you can refine this further to only show active wallets or deleted wallets. To do this, simply select the wallets filter and choose your preferred option from the "Show" dropdown.
Tip: Any deleted wallets will be clearly marked with a "Deleted" badge.
With the wallets filter, you're not limited to single wallet type. You can filter by any combination of:
- User wallets
- Company wallets
- Main wallets
Note: The wallets available will be dependent on the currency you have selected in the currency filter. For example, if you've selected GBP, you'll only be able to filter by GBP wallets.
4. Cards filter
If you want to quickly find transactions made using specific cards, you can apply the cards filter. By default, all cards are listed even if they've been deleted, but you can refine this further to only show active cards or deleted cards. To do this, simply select the cards filter and choose your preferred option from the "Show" dropdown. Remember, you can also combine filters to zero in on the data you need. For example, if you've already filtered by specific wallets, you can further refine the dataset by applying the cards filters.
Tip: Any deleted cards will be clearly marked with a "Deleted" badge.
With the cards filter, you can select any combination from:
- User cards
- Company cards
5. Users filter
If you want to quickly find transactions made by specific users, you can apply the users filter. By default, all users are listed even if they've been deleted, but you can refine this further to only show active users or deleted users. To do this, simply select the users filter and choose your preferred option from the "Show" dropdown. Remember, you can also combine filters to zero in on the data you need. For example, if you've already filtered by specific wallets, you can further refine the dataset by filtering by specific users.
Tip: Any deleted users will be clearly marked with a "Deleted" badge.
Clearing filters
If you’ve applied multiple filters to narrow down your results but now want to start fresh, you don’t need to remove each filter manually. Just select “Clear all filters” to reset them all at once.
Note: This option only resets filters. If you’ve customised the column view, this won’t be affected. To reset your column view, go to the column settings menu and select the relevant option.
Using ‘More filters’
In addition to the 5 main filters (date, currency, wallets, cards, and users) you can also apply More filters to dive deeper into your data and pinpoint the exact transactions that you need. Just like with the main filters, you're not limited to applying a single filter, you can combine and apply multiple filters at once. Suggested reading: For detailed information on transaction filters, see this related article: How are transactions filtered within Soldo?.
More filters are grouped by:
General filters
- Transaction type (e.g. Payment, Cash withdrawal, Mileage reimbursement)
- Transaction status (e.g. Settled, Declined)
- Attachment (e.g. Missing attachment, Has attachment)
- Payment method (e.g. User card, Company card, Personal payment method)
- Expense category
- VAT rate
Advanced filters
- Approval status (e.g. Approved, Denied)
- Expense policy (e.g. Out of policy, Within policy)
- Expense type (e.g. Travel & entertainment, Company, Personal)
- Flagged transactions
- Lists
- Reviewed by
How to apply 'More filters'
- Select the More filters option.
- You'll find 2 tabs:
-
All filters - Select, combine and apply multiple filters from the General and Advanced section.
-
Selected filters - Get a quick view of filters currently selected and make changes.
- Select Apply filters to update your dataset with your selected filters.
How to refine using sub-filters
When you tick the box next to a filter, you'll automatically select all sub-filters too. If you want to refine the filters even further, you can select the dropdown next to each filter to toggle on or off specific sub-filters.
Tip: You can refine the sub-filters from the All filters tab and the Selected filters tab.
FAQs
Can I download the reports?
Yes, once you have applied your filters and prepared your report you can download the data in various formats for further review or manipulation. For detailed information on downloading reports, see this article: Download transaction reports.
Can I save my filters?
Saving filters is not something that is currently supported.