--- title: How to pull Detailed Transaction Report by GL Account in QBO description: qbo reporting fees --- [Skip to content](https://knowledgebase.centime.com/support/how-to-pull-detailed-transaction-report-by-gl-account-in-qbo#main-content) English - United States Show submenu for translations [![Centim App Logo-1](https://knowledgebase.centime.com/hubfs/Centim%20App%20Logo-1.svg)](https://knowledgebase.centime.com/support?hsLang=en-us) Open main navigation Close main navigation - English - United States Show submenu for translations - [Contact us](https://www.centime.com/company/contact-us) [Contact us](https://www.centime.com/company/contact-us) How can we help you? - There are no suggestions because the search field is empty. 1. [Centime Knowledge Base](https://knowledgebase.centime.com/support?hsLang=en-us) 2. [Manage Receivables](https://knowledgebase.centime.com/support/manage-receivables?hsLang=en-us) 3. [Merchant Services](https://knowledgebase.centime.com/support/manage-receivables?hsLang=en-us#merchant-services) June 9, 2026 # How to pull Detailed Transaction Report by GL Account in QBO ## This article explains how to access the Chart of Accounts in QuickBooks Online and run a detailed account report to analyze payment activity and associated processing fees. For Merchant Services transactions, each customer Payment is assigned a unique Payment ID (displayed in the Num column, e.g., CEN1778746089201). Any related Journal Entries created for card fees, ACH fees, surcharges, discounts, or deductions will share the same Payment ID. By filtering for Payment and Journal Entry transaction types and reviewing records with the same Num value, users can easily trace a payment and all corresponding fee-related entries. This report can also be exported for further analysis and reconciliation.   **Step 1: Open Settings** From the QuickBooks Online home page, click the **Settings (⚙️)** icon in the upper-right corner. ![](https://knowledgebase.centime.com/hs-fs/hubfs/undefined-Jun-09-2026-03-27-45-1928-PM.png?width=2048&height=1041&name=undefined-Jun-09-2026-03-27-45-1928-PM.png) --- **Step 2: Open the Chart of Accounts** From the Settings menu, under **Your Company**, select **Chart of Accounts**.![](https://knowledgebase.centime.com/hs-fs/hubfs/undefined-Jun-09-2026-03-27-45-6851-PM.png?width=2048&height=1077&name=undefined-Jun-09-2026-03-27-45-6851-PM.png) **Step 3: Locate the Account** On the Chart of Accounts page, find the account you want to analyze for any expenses Examples: - Card Processing Fees - Merchant Fees - Bank Charges - Accounts Receivable - Undeposited Funds - ![](https://knowledgebase.centime.com/hs-fs/hubfs/undefined-Jun-09-2026-03-27-43-4639-PM.png?width=2048&height=1143&name=undefined-Jun-09-2026-03-27-43-4639-PM.png) **Step 4: Run the Account Report![](https://knowledgebase.centime.com/hs-fs/hubfs/undefined-Jun-09-2026-03-27-42-7912-PM.png?width=2048&height=1145&name=undefined-Jun-09-2026-03-27-42-7912-PM.png)** - This opens an **Account QuickReport** containing all transactions posted to the selected account. - For each **Payment** transaction (representing one or more invoices paid together), QBO will display a unique Payment ID in the **Num** column, for example: | **Transaction Type** | **Num** | | --- | --- | | Payment | CEN1778746089201 | | Journal Entry | CEN1778746089201 | The Payment transaction represents the customer payment applied to one or more invoices. The corresponding Journal Entry with the same **Num** value records related payment adjustments such as: - Card Processing Fees - ACH Processing Fees - Surcharges - Early Payment Discounts - Deductions Because the Payment and Journal Entry share the same **Num** value, you can use this field to trace all entries related to a specific payment event. ### **Example** For Payment ID **CEN1778746089201**: | **Transaction Type** | **Description** | | --- | --- | | Payment | Customer payment for invoice(s) | | Journal Entry | Card processing fee | | Journal Entry | ACH fee (if applicable) | | Journal Entry | Surcharge (if applicable) | | Journal Entry | Discount/Deduction (if applicable) | ### **Tip** To review both the customer payment and all associated fee activity together: 1. Open the Account QuickReport. 2. Add a **Transaction Type** filter. 3. Select **Payment** and **Journal Entry**. 4. Sort by the **Num** column. This makes it easy to identify each payment and its corresponding fee, surcharge, discount, and deduction entries using the shared Payment ID. **Step 5: Open Report Customization** On the report page, click **Customize**. **Step 6: Filter by Distribution Account** Under **Filters**: - **Filter By:** Distribution Account i.e the GL account you want to review, Payment date or range - **Condition:** Equals - **Value:** Select the account you want to review Example: - Card Processing Fees ![](https://knowledgebase.centime.com/hs-fs/hubfs/undefined-Jun-09-2026-03-27-46-2092-PM.png?width=2048&height=1089&name=undefined-Jun-09-2026-03-27-46-2092-PM.png) ![](https://knowledgebase.centime.com/hs-fs/hubfs/undefined-Jun-09-2026-03-27-46-2092-PM.png?width=624&height=332&name=undefined-Jun-09-2026-03-27-46-2092-PM.png) ![](https://knowledgebase.centime.com/hs-fs/hubfs/undefined-Jun-09-2026-03-27-44-2073-PM.png?width=2048&height=1140&name=undefined-Jun-09-2026-03-27-44-2073-PM.png) **Example: Card Processing Fee Analysis** If your card fees are posted through Journal Entries: ### **Filters** | **Filter** | **Value** | | --- | --- | | Distribution Account | Card Processing Fees | | Transaction Type | Journal Entry | ### **Result** The report will display: - Fee Journal Entries - Fee Amounts - Transaction Dates - Customer References (if included) - Memo/Description fields You can then: - Export the report to Excel - Sum total fees paid - Calculate effective processing rates - Analyze fees by month This is the most reliable method for determining how much you have paid in card processing fees when fees are recorded through Journal Entries to the corresponding GL account. - [Getting started with Centime](https://knowledgebase.centime.com/support/getting-started-with-centime?hsLang=en-us#main-content) - [Post-integration Setup](https://knowledgebase.centime.com/support/getting-started-with-centime?hsLang=en-us#post-integration-setup) - [Centime basics](https://knowledgebase.centime.com/support/getting-started-with-centime?hsLang=en-us#centime-basics) - [Manage Payables](https://knowledgebase.centime.com/support/manage-payables?hsLang=en-us#main-content) - [Introduction and Configuration](https://knowledgebase.centime.com/support/manage-payables?hsLang=en-us#introduction-and-configuration) - [Invoice Automation](https://knowledgebase.centime.com/support/manage-payables?hsLang=en-us#invoice-automation) - [Document Splitter](https://knowledgebase.centime.com/support/manage-payables?hsLang=en-us#document-splitter) - [Advanced NetSuite workflow support](https://knowledgebase.centime.com/support/manage-payables?hsLang=en-us#advanced-netsuite-workflow-support) - [Payment Automation](https://knowledgebase.centime.com/support/manage-payables?hsLang=en-us#payment-automation) - [Payment Methods](https://knowledgebase.centime.com/support/manage-payables?hsLang=en-us#payment-methods) - [Manage Receivables](https://knowledgebase.centime.com/support/manage-receivables?hsLang=en-us#main-content) - [Create your Receivables Strategy](https://knowledgebase.centime.com/support/manage-receivables?hsLang=en-us#create-your-receivables-strategy) - [Introduction to the Receivables Module](https://knowledgebase.centime.com/support/manage-receivables?hsLang=en-us#introduction-to-the-receivables-module) - [Collections & Collaboration](https://knowledgebase.centime.com/support/manage-receivables?hsLang=en-us#collections-collaboration) - [CentimePay](https://knowledgebase.centime.com/support/manage-receivables?hsLang=en-us#centimepay) - [Merchant Services](https://knowledgebase.centime.com/support/manage-receivables?hsLang=en-us#merchant-services) - [Cash Application](https://knowledgebase.centime.com/support/manage-receivables?hsLang=en-us#cash-application) - [Cash Flow Workbench](https://knowledgebase.centime.com/support/cash-flow-workbench?hsLang=en-us#main-content) - [Overview](https://knowledgebase.centime.com/support/cash-flow-workbench?hsLang=en-us#overview) - [Using Cash Flow Workbench](https://knowledgebase.centime.com/support/cash-flow-workbench?hsLang=en-us#using-cash-flow-workbench) - [Cash Flow Settings](https://knowledgebase.centime.com/support/cash-flow-workbench?hsLang=en-us#cash-flow-settings) - [Monitor KPIs](https://knowledgebase.centime.com/support/monitor-kpis?hsLang=en-us#main-content) - [Overview](https://knowledgebase.centime.com/support/monitor-kpis?hsLang=en-us#overview) - [CentimeCredit](https://knowledgebase.centime.com/support/centimecredit?hsLang=en-us#main-content) - [Getting Started](https://knowledgebase.centime.com/support/centimecredit?hsLang=en-us#getting-started) - [Banking](https://knowledgebase.centime.com/support/banking?hsLang=en-us#main-content) - [Manage Banking](https://knowledgebase.centime.com/support/banking?hsLang=en-us#manage-banking) - [Product Release Notes](https://knowledgebase.centime.com/support/product-release-notes?hsLang=en-us#main-content) - [2026 Releases](https://knowledgebase.centime.com/support/product-release-notes?hsLang=en-us#2026-releases) - [2025 Release](https://knowledgebase.centime.com/support/product-release-notes?hsLang=en-us#2025-release) - [2024 Releases](https://knowledgebase.centime.com/support/product-release-notes?hsLang=en-us#2024-releases) - [2023 Releases](https://knowledgebase.centime.com/support/product-release-notes?hsLang=en-us#2023-releases) - [2022 Releases](https://knowledgebase.centime.com/support/product-release-notes?hsLang=en-us#2022-releases) - [Customer Portal](https://knowledgebase.centime.com/support/customer-portal?hsLang=en-us#main-content) - [Using the Customer Portal](https://knowledgebase.centime.com/support/customer-portal?hsLang=en-us#using-the-customer-portal) [![Centim App Logo](https://knowledgebase.centime.com/hubfs/Centim%20App%20Logo.svg "Centim App Logo")](https://knowledgebase.centime.com/support?hsLang=en-us) 123 Waverly Pl., Boston, MA 02135 Copyright © 2024, Centime, Inc.