The Run Transactions by Account Report in QuickBooks shows every money movement in one specific account. It works like a bank statement for expenses, revenue, loans, or any account you track. The list includes dates, amounts, and the names of those involved. Businesses rely on this account transaction report for clear visibility into financial activity. QuickBooks generates it quickly through standard menus in Desktop and Online versions.
This guide covers the exact steps to run the reports that QuickBooks users need daily. Accountants use it to match bank statements. Managers track spending patterns. Auditors verify transaction details. The report delivers line-by-line precision that summary views cannot match. Regular use strengthens financial control and supports accurate record-keeping across operations.
Table of Contents
- 1 Why You Should Run the Transactions by Account Report
- 2 How to Run Transactions by Account Report in QuickBooks Desktop
- 3 How to Run Transactions by Account Report in QuickBooks Online
- 4 How to Customize the Transactions by Account Report?
- 5 Comparing to Other QuickBooks Reports
- 6 Troubleshooting Common Report Issues
- 7 Tips for Accurate Reporting
- 8 Conclusion
- 9 Frequently Asked Questions
Why You Should Run the Transactions by Account Report
The Transactions by Account report shows every transaction affecting a chosen account. It lists dates, transaction types, payees, memos, and amounts for complete visibility into account activity. Users rely on this report to verify bank reconciliations, track vendor payments, or analyse expense patterns. Unlike summary reports, the account transaction report displays line-level details for precision.
Key elements include:
- Transaction date and number.
- Source documents like checks, invoices, or journal entries.
- Debit and credit amounts.
- Running balances where applicable.
Struggling With Accounting or Bookkeeping?
Talk to our experts in minutes — No wait time!
- Free Consultation
- Fast Response
- Trusted Experts
How to Run Transactions by Account Report in QuickBooks Desktop
QuickBooks Desktop places the Transactions by Account report in the Reports menu. Users select it directly or customise it through report centres.
Follow these steps:
- Click Reports from the top menu bar.
- Select Accountant & Taxes (or use the Reports search field), then choose Transaction Detail by Account.
- Choose the specific account from the Display dropdown.
- Set the date range using the From and To fields.
- Click OK to generate the report.
The report opens in a detailed view. QuickBooks displays all transactions chronologically.
How to Run Transactions by Account Report in QuickBooks Online
QuickBooks Online offers the account transaction report through the Accounting section or the report list. Navigation varies slightly by subscription level.
Execute these steps:
- Go to Accounting, then the Chart of Accounts.
- Find the target account and click the dropdown arrow next to View register.
- Select Run report.
- Use Customise to adjust date range, filters, or columns.
- Click Run report to display results.
Alternatively, navigate to Reports and search “Transaction Detail by Account”.
How to Customize the Transactions by Account Report?
Customisation enhances the report for specific needs. Users add columns, apply filters, and sort data through built-in tools.
Common modifications:
- Add Debit, Credit, or Balance columns.
- Filter by transaction type (invoices, bills, payments).
- Sort by date, amount, or name.
- Group by payee or class for segmented views.
In Desktop, use Memorise Report after changes. In Online, save customisations as templates.
Interpreting Report Data
Each line represents one side of a transaction affecting the account.
- Invoice: Debit Accounts Receivable, Credit Income
- Bill: Debit Expense, Credit Accounts Payable
- Bill Payment: Debit Accounts Payable, Credit Bank
Note: Transfers appear in both source and destination accounts.
Review these details:
- Date: Transaction posting date.
- Num: Check number, invoice number, or journal entry.
- Name: Customer, vendor, or employee.
- Memo: User-entered notes.
- Clr: Cleared status for reconciliation.
Cross-reference with bank statements or source documents.
Using the Report for Reconciliation
Accountants match the Transactions by Account report against bank or credit card statements. Unreconciled items show blank Clr columns. Deposits and withdrawals align with external records.
Steps for reconciliation:
- Run the report for the statement period.
- Mark cleared items in the QuickBooks registers.
- Identify discrepancies in amounts or dates.
- Resolve voids, duplicates, or missing entries.
This process confirms account accuracy monthly.
Filtering the Account Transaction Report
Filters narrow results for focused analysis. QuickBooks offers multiple criteria simultaneously.
Apply filters:
- Account: Single account or subaccounts.
- Date: Specific range or fiscal periods.
- Transaction Type: Narrow to payments, deposits, or journals.
- Payee: Vendor or customer subsets.
- Amount: Above or below thresholds.
Combine filters for precision. For example, filter vendor bills over $1,000 in Q4.
Exporting and Printing Options
Users export the run reports that QuickBooks generates to Excel for further analysis. The desktop offers an Excel button. Online provides Export to Sheet or Print.
Export preserves:
- Formatting and totals.
- Data structure and totals, but drill-down links remain functional only within QuickBooks and are not preserved in Excel exports.
- Custom column layouts.
Print physical copies for audits or client reviews. PDF export maintains a professional appearance.
Comparing to Other QuickBooks Reports
The Transactions by Account report differs from the General Ledger. Ledger shows all accounts chronologically. This report isolates one account with transaction sources. Summary reports aggregate totals without details.
| Report Type | Focus | Detail Level | Best Use |
| Transactions by Account | Single account activity | Line-level | Reconciliation, audits |
| General Ledger | All accounts | Account-level | Trial balance review |
| Transaction List by Date | Chronological transactions | Summary | Cash flow tracking |
Troubleshooting Common Report Issues
Users sometimes face display problems with the report. Blank reports usually result from incorrect date ranges, applied filters, or no activity during the selected period. Inactive accounts can still display historical transactions if activity exists.
If transactions are missing, uncleared items or overly strict filters often cause the issue, and resetting customisations typically fixes it. Reports also run slowly when pulling data from large date ranges or busy accounts. Narrowing the date range speeds things up immediately.
Resolve systematically:
- Refresh data with the Refresh button.
- Check account type filters.
- Run the Verify Data utility for file integrity.
Tips for Accurate Reporting
Businesses schedule monthly runs of the Transactions by Account report. Accountants review before reconciliations. Save custom templates for recurring needs, document filter settings for team consistency.
Integrate with:
- Budget variance analysis.
- Vendor payment tracking.
- Tax preparation audits.
Conclusion
The Transactions by Account report delivers essential visibility into account-level activity within QuickBooks. Users access it through the Reports menus or the Chart of Accounts in Desktop and Online editions. Customisation with filters, columns, and dates tailors output precisely. Regular use supports accurate reconciliations, audits, and financial oversight. Export options extend analysis capabilities. Businesses maintain reliable records by consistently applying this powerful tool.
Frequently Asked Questions
What’s the difference between Transactions by Account and General Ledger reports?
The Transactions by Account report focuses on one account with full transaction details. The General Ledger shows activity across all accounts at a higher level. Use Transactions by Account when you need to drill into a single account’s complete history.
Why don’t I see all my transactions in the report?
Check your date range first. Transactions outside those dates won’t appear. Also, verify filters aren’t excluding items. Inactive accounts or uncleared transactions sometimes hide from view. Reset filters and expand dates to find missing entries.
Can I run this report for multiple accounts at once?
Yes, in QuickBooks Desktop, select multiple accounts in the Display section. QuickBooks Online works better with single accounts through the Chart of Accounts. For multiple accounts across platforms, run separate reports or export to Excel for consolidation.
How often should I run the Transactions by Account report?
Run it monthly before bank reconciliations. Quarterly reviews help spot spending trends. Use it weekly if managing tight cash flow or vendor payments. Annual runs support tax prep and audits effectively.
