---
title: FAQ - How Do I Filter Accounting Reports with Blank Rows by Charge Code?
description: Filtering Accounting Reports by Charge Code When Blank Rows Are Present
---
[Skip to content](https://solutions.smartwebs.com/en-us/smartwebs-solutions/filtering-accounting-reports-by-charge-code-when-blank-rows-are-present#main-content)
English - United States
Show submenu for translations
- [Smartwebs Solutions Home](https://solutions.smartwebs.com/)
- [Contact Us](https://share.hsforms.com/2VBrljHAiSeCkcUy_-IEe_Aq0yoc)
- [Manage Tickets](https://support.smartwebs.com/tickets-view)
Open main navigation
Close main navigation
- [Smartwebs Solutions Home](https://solutions.smartwebs.com/)
- [Contact Us](https://share.hsforms.com/2VBrljHAiSeCkcUy_-IEe_Aq0yoc)
- [Manage Tickets](https://support.smartwebs.com/tickets-view)
- English - United States
Show submenu for translations
- [Contact Us](https://share.hsforms.com/2VBrljHAiSeCkcUy_-IEe_Aq0yoc)
[Contact Us](https://share.hsforms.com/2VBrljHAiSeCkcUy_-IEe_Aq0yoc)
How can we help you?
- There are no suggestions because the search field is empty.
1. [Smartwebs Solutions](https://solutions.smartwebs.com/en-us/smartwebs-solutions?hsLang=en-us)
2. [Accounting](https://solutions.smartwebs.com/en-us/smartwebs-solutions/accounting?hsLang=en-us)
3. [Reports](https://solutions.smartwebs.com/en-us/smartwebs-solutions/accounting?hsLang=en-us#reports)
October 26, 2026
# FAQ - How Do I Filter Accounting Reports with Blank Rows by Charge Code?
## This article will review how to filter accounting reports by Charge Code when blank rows exist.
When viewing reports that include Charge Codes, you will sometimes encounter instances were more than one Charge Code was used per owner. The owner information is only present on the first row of data, so filtering by Charge Code could produce blank columns. You can successfully view Charge Code data with the owner information by using Excel and formulas.
Accounting Reports where Charge Codes are used in conjunction with transaction details
1. Delinquent Summary by Charge Code Aging
2. Deposit Details Report
Why does filtering by Charge Code in the standard report produce incomplete results? The standard report filter returns only the rows where the Charge Code appears, but owner information is not repeated on every row. This means deposit details for a specific Charge Code (such as Administrative Fee-SW) may be missing when the standard filter is applied to the Deposit Details Report. The steps below resolve this using Excel.
#### **Steps to view Charge Code details via Excel**
1. Export your report to Excel by selecting the Excel Icon
2. Download the file
3. Open the Excel spreadsheet
4. Press `Ctrl+A` to select all.
5. Type Ctrl+Shift+L to add filters
6. Press `Ctrl+A` to select all again (this re-selects all cells after the filters are applied).
7. Select the F5 Key
8. Select “Special” or Alt+S
9. Select “Blanks” or Atl+K
10. Select OK This will select all blanks in the spreadsheet
11. Type `=⬆️Ctrl+Enter` (equal sign, up arrow, `Ctrl+Enter`). This copies the value from the cell directly above into each blank cell. Any blank header cells will display formula errors — delete those cells before proceeding.
12. You can now filter the Charge Code column (column H in the Deposit Details Report) to display only the charge code you want — for example, Administrative Fee-SW. Open the column H filter drop-down, clear the **Select all** checkbox to remove all selections, select the charge code you want to view, then select **OK**.
13. You will now only see the selected charge code and you will have visibility to the deposit details even when more than one charge code was paid.
- [Accounting](https://solutions.smartwebs.com/en-us/smartwebs-solutions/accounting?hsLang=en-us#main-content)
- [1099's](https://solutions.smartwebs.com/en-us/smartwebs-solutions/accounting?hsLang=en-us#1099s)
- [General](https://solutions.smartwebs.com/en-us/smartwebs-solutions/accounting?hsLang=en-us#general)
- [General Ledger](https://solutions.smartwebs.com/en-us/smartwebs-solutions/accounting?hsLang=en-us#general-ledger)
- [Receivables](https://solutions.smartwebs.com/en-us/smartwebs-solutions/accounting?hsLang=en-us#receivables)
- [Payables](https://solutions.smartwebs.com/en-us/smartwebs-solutions/accounting?hsLang=en-us#payables)
- [Banking & Reconciliation](https://solutions.smartwebs.com/en-us/smartwebs-solutions/accounting?hsLang=en-us#banking-reconciliation)
- [Configuration & Setup](https://solutions.smartwebs.com/en-us/smartwebs-solutions/accounting?hsLang=en-us#configuration-setup)
- [Merchant Services](https://solutions.smartwebs.com/en-us/smartwebs-solutions/accounting?hsLang=en-us#merchant-services)
- [Reports](https://solutions.smartwebs.com/en-us/smartwebs-solutions/accounting?hsLang=en-us#reports)
- [Billing](https://solutions.smartwebs.com/en-us/smartwebs-solutions/accounting?hsLang=en-us#billing)
- [Payments & Deposits](https://solutions.smartwebs.com/en-us/smartwebs-solutions/accounting?hsLang=en-us#payments-deposits)
- [Homeowner Charges](https://solutions.smartwebs.com/en-us/smartwebs-solutions/accounting?hsLang=en-us#homeowner-charges)
- [Statements](https://solutions.smartwebs.com/en-us/smartwebs-solutions/accounting?hsLang=en-us#statements)
- [Collections](https://solutions.smartwebs.com/en-us/smartwebs-solutions/accounting?hsLang=en-us#collections)
- [Security Deposits](https://solutions.smartwebs.com/en-us/smartwebs-solutions/accounting?hsLang=en-us#security-deposits)
- [Administration](https://solutions.smartwebs.com/en-us/smartwebs-solutions/accounting?hsLang=en-us#administration)
- [Administrative](https://solutions.smartwebs.com/en-us/smartwebs-solutions/administrative?hsLang=en-us#main-content)
- [Owner Unit Management](https://solutions.smartwebs.com/en-us/smartwebs-solutions/administrative?hsLang=en-us#owner-unit-management)
- [User Management](https://solutions.smartwebs.com/en-us/smartwebs-solutions/administrative?hsLang=en-us#user-management)
- [Roles and Rights](https://solutions.smartwebs.com/en-us/smartwebs-solutions/administrative?hsLang=en-us#roles-and-rights)
- [Email Notification Preferences](https://solutions.smartwebs.com/en-us/smartwebs-solutions/administrative?hsLang=en-us#email-notification-preferences)
- [Satellite Offices](https://solutions.smartwebs.com/en-us/smartwebs-solutions/administrative?hsLang=en-us#satellite-offices)
- [Reporting](https://solutions.smartwebs.com/en-us/smartwebs-solutions/administrative?hsLang=en-us#reporting)
- [Document Management](https://solutions.smartwebs.com/en-us/smartwebs-solutions/administrative?hsLang=en-us#document-management)
- [Security](https://solutions.smartwebs.com/en-us/smartwebs-solutions/administrative?hsLang=en-us#security)
- [Letter Parameters](https://solutions.smartwebs.com/en-us/smartwebs-solutions/administrative?hsLang=en-us#letter-parameters)
- [Zero Touch Mailing Service](https://solutions.smartwebs.com/en-us/smartwebs-solutions/administrative?hsLang=en-us#zero-touch-mailing-service)
- [Association Setup](https://solutions.smartwebs.com/en-us/smartwebs-solutions/administrative?hsLang=en-us#association-setup)
- [Vendor Management](https://solutions.smartwebs.com/en-us/smartwebs-solutions/administrative?hsLang=en-us#vendor-management)
- [Email and Custom Domains](https://solutions.smartwebs.com/en-us/smartwebs-solutions/administrative?hsLang=en-us#email-and-custom-domains)
- [Data Storage](https://solutions.smartwebs.com/en-us/smartwebs-solutions/administrative?hsLang=en-us#data-storage)
- [Support](https://solutions.smartwebs.com/en-us/smartwebs-solutions/administrative?hsLang=en-us#support)
- [Preferences](https://solutions.smartwebs.com/en-us/smartwebs-solutions/administrative?hsLang=en-us#preferences)
- [HOA and Data Transfers](https://solutions.smartwebs.com/en-us/smartwebs-solutions/administrative?hsLang=en-us#hoa-and-data-transfers)
- [Cancellations](https://solutions.smartwebs.com/en-us/smartwebs-solutions/administrative?hsLang=en-us#cancellations)
- [Architecturals](https://solutions.smartwebs.com/en-us/smartwebs-solutions/architecturals?hsLang=en-us#main-content)
- [Committee Member Guides](https://solutions.smartwebs.com/en-us/smartwebs-solutions/architecturals?hsLang=en-us#committee-member-guides)
- [Board Member Guides](https://solutions.smartwebs.com/en-us/smartwebs-solutions/architecturals?hsLang=en-us#board-member-guides)
- [Online Submit Forms](https://solutions.smartwebs.com/en-us/smartwebs-solutions/architecturals?hsLang=en-us#online-submit-forms)
- [Arc Project Notifications](https://solutions.smartwebs.com/en-us/smartwebs-solutions/architecturals?hsLang=en-us#arc-project-notifications)
- [Arc CCRs and Project Types](https://solutions.smartwebs.com/en-us/smartwebs-solutions/architecturals?hsLang=en-us#arc-ccrs-and-project-types)
- [Arc Project Statuses and Expirations](https://solutions.smartwebs.com/en-us/smartwebs-solutions/architecturals?hsLang=en-us#arc-project-statuses-and-expirations)
- [Arc Letters](https://solutions.smartwebs.com/en-us/smartwebs-solutions/architecturals?hsLang=en-us#arc-letters)
- [Arc Admin, Settings, and Reports](https://solutions.smartwebs.com/en-us/smartwebs-solutions/architecturals?hsLang=en-us#arc-admin-settings-and-reports)
- [Arc Projects](https://solutions.smartwebs.com/en-us/smartwebs-solutions/architecturals?hsLang=en-us#arc-projects)
- [Arc Project Applications](https://solutions.smartwebs.com/en-us/smartwebs-solutions/architecturals?hsLang=en-us#arc-project-applications)
- [Board and Committee Admin](https://solutions.smartwebs.com/en-us/smartwebs-solutions/board-and-committee-admin?hsLang=en-us#main-content)
- [Meeting Minutes](https://solutions.smartwebs.com/en-us/smartwebs-solutions/board-and-committee-admin?hsLang=en-us#meeting-minutes)
- [Communications](https://solutions.smartwebs.com/en-us/smartwebs-solutions/communications?hsLang=en-us#main-content)
- [Mass Communications](https://solutions.smartwebs.com/en-us/smartwebs-solutions/communications?hsLang=en-us#mass-communications)
- [Workflow](https://solutions.smartwebs.com/en-us/smartwebs-solutions/communications?hsLang=en-us#workflow)
- [Security](https://solutions.smartwebs.com/en-us/smartwebs-solutions/communications?hsLang=en-us#security)
- [General](https://solutions.smartwebs.com/en-us/smartwebs-solutions/general?hsLang=en-us#main-content)
- [Frequently Asked Questions](https://solutions.smartwebs.com/en-us/smartwebs-solutions/general?hsLang=en-us#frequently-asked-questions)
- [Lifestyle](https://solutions.smartwebs.com/en-us/smartwebs-solutions/lifestyle?hsLang=en-us)
- [Mobile Applications](https://solutions.smartwebs.com/en-us/smartwebs-solutions/mobile-applications?hsLang=en-us#main-content)
- [Offline App](https://solutions.smartwebs.com/en-us/smartwebs-solutions/mobile-applications?hsLang=en-us#offline-app)
- [Portal App](https://solutions.smartwebs.com/en-us/smartwebs-solutions/mobile-applications?hsLang=en-us#portal-app)
- [Mobile Online App](https://solutions.smartwebs.com/en-us/smartwebs-solutions/mobile-applications?hsLang=en-us#mobile-online-app)
- [iOS Devices](https://solutions.smartwebs.com/en-us/smartwebs-solutions/mobile-applications?hsLang=en-us#ios-devices)
- [Android devices](https://solutions.smartwebs.com/en-us/smartwebs-solutions/mobile-applications?hsLang=en-us#android-devices)
- [FAQ](https://solutions.smartwebs.com/en-us/smartwebs-solutions/mobile-applications?hsLang=en-us#faq)
- [Release Notes](https://solutions.smartwebs.com/en-us/smartwebs-solutions/release-notes?hsLang=en-us#main-content)
- [Office Site Releases](https://solutions.smartwebs.com/en-us/smartwebs-solutions/release-notes?hsLang=en-us#office-site-releases)
- [Application Releases](https://solutions.smartwebs.com/en-us/smartwebs-solutions/release-notes?hsLang=en-us#application-releases)
- [Resident Portal](https://solutions.smartwebs.com/en-us/smartwebs-solutions/resident-portal?hsLang=en-us#main-content)
- [Resident Guides](https://solutions.smartwebs.com/en-us/smartwebs-solutions/resident-portal?hsLang=en-us#resident-guides)
- [Admin Guides](https://solutions.smartwebs.com/en-us/smartwebs-solutions/resident-portal?hsLang=en-us#admin-guides)
- [Violations](https://solutions.smartwebs.com/en-us/smartwebs-solutions/violations?hsLang=en-us#main-content)
- [Frequently Asked Questions](https://solutions.smartwebs.com/en-us/smartwebs-solutions/violations?hsLang=en-us#frequently-asked-questions)
- [Violation Letters](https://solutions.smartwebs.com/en-us/smartwebs-solutions/violations?hsLang=en-us#violation-letters)
- [Violation CCRs](https://solutions.smartwebs.com/en-us/smartwebs-solutions/violations?hsLang=en-us#violation-ccrs)
- [Violation Policies](https://solutions.smartwebs.com/en-us/smartwebs-solutions/violations?hsLang=en-us#violation-policies)
- [Mapping Units in Smartwebs](https://solutions.smartwebs.com/en-us/smartwebs-solutions/violations?hsLang=en-us#mapping-units-in-smartwebs)
- [Setup and Configuration](https://solutions.smartwebs.com/en-us/smartwebs-solutions/violations?hsLang=en-us#setup-and-configuration)
- [Reporting](https://solutions.smartwebs.com/en-us/smartwebs-solutions/violations?hsLang=en-us#reporting)
- [Work Orders](https://solutions.smartwebs.com/en-us/smartwebs-solutions/work-orders?hsLang=en-us#main-content)
- [Work Order Management](https://solutions.smartwebs.com/en-us/smartwebs-solutions/work-orders?hsLang=en-us#work-order-management)
- [Vendor Management](https://solutions.smartwebs.com/en-us/smartwebs-solutions/work-orders?hsLang=en-us#vendor-management)
- [Flyers](https://solutions.smartwebs.com/en-us/smartwebs-solutions/flyers?hsLang=en-us#main-content)
- [Lifestyle](https://solutions.smartwebs.com/en-us/smartwebs-solutions/flyers?hsLang=en-us#lifestyle)
- [Resale](https://solutions.smartwebs.com/en-us/smartwebs-solutions/resale?hsLang=en-us)
# Smartwebs
1015 S Mays St, Round Rock, TX 78664
[512-218-9996](tel:512-218-9996)
[mailto:support@smartwebs.com](mailto:support@smartwebs.com)
Copyright © 2026, Smartwebs