View account transactions
This guide explains how to view all journal entry transactions posted to a specific account or set of accounts.
The Account Transactions report shows individual journal lines for the accounts and date range you select. Each row represents a debit or credit posted by an invoice, bill, expense, credit note, manual journal, or other transaction type. Use this report to investigate account activity, verify postings, or drill into the source transaction behind each entry.
Run the Account Transactions report
-
In the sidebar, click Reports, then select Account Transactions.
-
Set a Date range using the date picker at the top of the page. By default the report shows the current calendar month.
-
To filter by specific accounts, use the Accounts dropdown to select one or more chart of accounts. Use the search field inside the dropdown to find accounts by name.
-
Click Update to load the report with your selected filters.
The report displays a grid of journal lines with the following default columns:
- Date -- the date of the journal entry
- Source -- a clickable badge showing the transaction type (e.g. Invoice, Bill, Expense, Credit Note, Vendor Credit, Transaction, Manual, Payment). Clicking the badge navigates to the source transaction.
- Debit -- the debit amount in your base currency
- Credit -- the credit amount in your base currency
- Description -- the transaction details from the journal entry
- Reference -- the reference number or text
- Credit (Source) -- the credit amount in the original transaction currency
- Debit (Source) -- the debit amount in the original transaction currency
- Currency -- the original transaction currency code
Show or hide columns
The report supports additional columns that are hidden by default. You can toggle column visibility to customise the information displayed.
-
Click the Columns dropdown on the right side of the header.
-
Select or deselect columns to show or hide them. The dropdown displays the number of columns currently selected.
Available optional columns include:
- Account Code -- the chart of account code
- Account Type -- the account type (e.g. asset, liability, income, expense)
- Related Account Type -- the account name
- Customer -- the customer associated with the transaction
- Vendor -- the vendor associated with the transaction
- Invoice Number -- the invoice number (shown only for invoice transactions)
- Gross -- the gross amount (net + tax) in your base currency
- Net -- the net amount in your base currency
- Tax -- the tax amount in your base currency
- Tax Rate -- the applied tax rate percentage
- Tax Rate Name -- the name of the applied tax rule
Under the Foreign Exchange (FX) section:
- Gross (Source) -- the gross amount in the source currency
- Net (Source) -- the net amount in the source currency
- Tax (Source) -- the tax amount in the source currency
- Revalued -- the revalued amount in your base currency (shown only for foreign currency transactions)
- Revalued FX Rate -- the exchange rate used for revaluation (shown only for foreign currency transactions)
Export the report
-
Click the three-dot menu icon to the right of the Update button.
-
Select Excel to download the report as an XLSX file.
The exported file is named using the format
account-transactions_YYYY-MM-DD.xlsx.
Frequently asked questions
What date range does the report default to? The report defaults to the current calendar month (first day to last day of the current month).
Can I filter by multiple accounts at once? Yes. The Accounts dropdown supports multiple selections. You can search for and select as many accounts as you need.
What do the source type badges mean? Each transaction shows a badge indicating where the journal entry originated: Invoice, Bill, Expense, Credit Note, Vendor Credit, Transaction (bank/payment account transaction), Manual (manual journal), Payment, or Estimate.
Can I click through to the original transaction? Yes. Click the source type badge in the Source column to navigate directly to the original transaction (e.g. the invoice, bill, or expense that created the journal entry).
Why do some foreign exchange columns show a dash? The Revalued and Revalued FX Rate columns only display values for transactions recorded in a currency different from your base currency. Transactions in your base currency show a dash.