---
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 15, 2025
# 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
In this example we would like to see which payments were received and applied to a specific Charge Code (Administrative Fee-SW). We will use the Deposit Details Report to see this information. When using the standard report filter you can filter by Charge Code, however not all rows produced the needed deposit details.
#### **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. Type Ctrl+Shift+A to Select All
5. Type Ctrl+Shift+L to add filters
6. Type Ctrl+Shift+A to Select All
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, Up Arrow, Ctrl+Enter). This will copy the data from the above cells into the blank cells below. Any blank headers will result in formula errors that you can just delete
12. You can now filter column H to only include the Administrative Fee-SW. Select the “Select All” filter to remove all selections, then select the Charge Code you want to view and 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)
- [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