Ongoing data-quality checks — new or untagged GL accounts that need a human to review.
Data quality: Expense tag reconciliation
RPM, Jul 2026Does the sum of individually-tagged expense buckets reconcile to the wildcard "Expense" total? A mismatch usually flags a new, not-yet-tagged GL account.
Sum of tagged bucketsLegacy: $0
Wildcard Expense totalLegacy: $0
Reconciles
Untagged GL accounts
All timeAccounts with dollar activity but no tags in either the P&L sheets or GL Tags Master — the working replacement for the source spreadsheet's always-empty "REVIEW - New GL Accounts" sheet.
| 4110 Management Fees | $4,613,842 |
| 6314 Property Management Wages | $1,219,681 |
| 4221 Commercial Management Fees | $894,140 |
| 4125.08 Resident Benefits Package | $883,999 |
| 4822 Other Brokerage Sales/Leasing | $880,844 |
| 5820 Brokerage Comm Paid COS - Other | $784,354 |
| 4811 PM Brokerage Listing Income | $693,679 |
| 4231 CA Management Fees | $670,186 |
| 4821 Other Brokerage Listing Income | $536,444 |
| 8400 Interest Expense | $535,717 |
| 6410 Owner 1 Wages | $487,823 |
| 6311 Admin & Accounting Wages | $454,728 |
| 6321.07 Reconcile Daily | $432,571 |
| 8100 Amortization | $417,533 |
| 4125.02 Late Fees | $385,563 |
| 6440 Operations Manager | $332,822 |
| 6420 Owner 2 Wages | $319,370 |
| 6316 CA PM Wages | $302,419 |
| 6323 Inspection Services | $293,838 |
| 6530 Payroll Taxes | $287,365 |
| 4122 Leasing Fees | $268,941 |
| 6616 Second Nature / Filter Easy | $267,336 |
| 4121 Application Fees | $260,687 |
| 4123 Renewal Fees | $245,927 |
| 6663 Coaching/Consulting | $210,128 |
| 7999.02 PPP Loan Non-Taxable | $209,284 |
| 7500 Bank Earnings Credit | $190,800 |
| 6431 Business Development Manager | $180,535 |
| 6124 Office Rent/Lease | $172,147 |
| 6142.06 Appfolio | $156,924 |
| 4829.02 Consulting | $147,519 |
| 6525 S-Corp Owners' Health Insurance | $141,970 |
| 6450 Other Management Contractors | $133,437 |
| 6632 Bank Service Charges | $124,252 |
| 4222.02 Commercial Leasing Fees | $118,175 |
| 6321.04 Maintenance Coordination | $116,559 |
| 6154 Phone | $114,564 |
| 6313 Maintenance Coordination Wages | $111,826 |
| 4125.50 Renewal Prep Fee | $107,505 |
| 7999.01 SBA Loan Forgiveness | $106,870 |
| 4812 PM Brokerage Sales Income | $101,401 |
| 6642 Commercial Package | $98,156 |
| 6325 Maint. Coordination RTMs | $96,769 |
| 6210.04 BESON 4 (#1) | $93,536 |
| 4125.34 Lease Prep Fee - Tenant | $92,900 |
| 6321.01 Tenant Application Processing | $90,791 |
| 6644 General Liability Insurance | $89,468 |
| 6613 Lockboxes/Self-Showing Services | $85,287 |
| 6650 Meals and Entertainment | $85,221 |
| 4125.07 Risk Mitigation Fee | $81,645 |
| 6611 Application Fees Expense | $81,617 |
| 6210.01 Rent Bridge | $80,757 |
| 4125.18 Pet Fee 3 Paws | $78,062 |
| 6299.03 The Players | $74,621 |
| 6635 Employee Recruiting | $71,722 |
| 6656 Office Supplies & Expenses | $69,754 |
| 6614 Owner & Tenant Concessions | $67,081 |
| 7100.02 Consulting Expenses | -$67,005 |
| 4232.02 Estoppel Letter Fee | $63,297 |
| 6899.02 Brokerage Analytics Expense | $61,935 |
| 6623 Vacancy Listings Expense | $61,761 |
| 6683 Airfare | $58,983 |
| 6142.04 RentBridge | $58,603 |
| 6441 Controller | $58,031 |
| 5810 Brok. Commissions Paid COS - PM | $57,890 |
| 6540 Retirement Benefits | $57,413 |
| 6658 Professional Dues | $52,443 |
| 6527 Workers' Comp Insurance | $52,073 |
| 6681 Lodging | $51,628 |
| 6641 Auto Insurance | $51,043 |
| 6291 Rent or Lease of Buildings | $51,000 |
| 7100 Consulting Income | $50,250 |
| 6649 Insurance - Other | $49,578 |
| 6142.13 Lead Simple | $48,665 |
| 6142.03 HubSpot | $48,419 |
| 4125.16 Pet Fee 5 Paws | $46,926 |
| 6621 Photography | $44,983 |
| 6312 Leasing Wages | $42,441 |
| 6310 Direct Labor Wages | $40,433 |
| 4125.20 Pet Fee 1 Paws | $40,137 |
| 6633 Charitable Donations | $39,852 |
| 4124.17 Landlord Protection Plus | $39,340 |
| 6321.03 Harbor View CFO | $39,025 |
| 4222.03 Project Oversight Fee | $38,241 |
| 6210.03 Google Adwords | $38,050 |
| 4125.25 Demand Notice Administrative Fee | $37,950 |
| 6615 Postage & Shipping | $37,286 |
| 4125.04 Admin Fee - Lease | $34,429 |
| 4232.05 Transfer Fee | $33,837 |
| 6112 Auto Repairs & Maintenance | $33,784 |
| 6153 Internet/Cable | $32,962 |
| 4125.17 Pet Fee 4 Paws | $31,462 |
| 6210.08 Upkeep Media Inc | $31,275 |
| 4125.03 NSF FEE | $28,981 |
| 4819.01 PM Brokerage Transaction Fees | $27,025 |
| 6131 Cleaning | $25,742 |
| 6326 Property Management RTMs | $24,872 |
| 6230 Referral Fees Expense | $24,692 |
| 6617 Surevestor | $24,365 |
| 6210.05 All Property Management | $24,000 |
| 6664 IT Services | $23,540 |
| 6142.08 Microsoft | $22,643 |
| 6240.04 Beson 4 (#2) | $21,860 |
| 4829.01 Other Brokerage Transaction Fee | $20,872 |
| 4125.35 Initial Pet Administrative Fee | $20,475 |
| 6524 Owner's Life Insurance | $20,237 |
| 4125.19 Pet Fee 2 Paws | $20,019 |
| 6114 Fuel | $19,185 |
| 6299.05 New Owner Advertising - Other | $17,836 |
| 4125.06 Month to Month Administrative Fee | $17,467 |
| 6654.01 Filing Fees | $17,033 |
| 4260 PM Referral Income | $16,274 |
| 6682 Ground Transportation/Parking | $16,269 |
| 4232.06 Postage | $15,763 |
| 7999 Other Income - Other | $15,681 |
| 6842 Brokerage Photography | $15,207 |
| 6661 Accounting | $15,000 |
| 6141 Hardware | $14,981 |
| 6657 Payroll Processing Fees | $14,920 |
| 4124.04 MA Termination Fee | $14,422 |
| 4124.19 Annual Accounting Administration Fee | $13,320 |
| 6142.17 Dotloop | $12,691 |
| 6634 Education & Training | $12,652 |
| 6142.14 Lob | $12,251 |
| 4124.16 Owner Set Up Fee | $11,975 |
| 4124.18 Utility Connection Administrative Fee | $11,741 |
| 6820 Brokerage Dues | $11,223 |
| 6240.03 GoDaddy | $10,865 |
| 6639 Fuel | $10,529 |
| 6299.02 Gifts | $10,363 |
| 4232.07 Late fees | $10,279 |
| 6665 Legal | $9,882 |
| 6133 Renovations & Repairs | $9,472 |
| 6240.02 Property Manager Website | $9,293 |
| 4125.01 Renters Insurance Admin Fees | $9,074 |
| 6324.01 Leasing - Commercial | $8,550 |
| 4125.40 Tenant Liability Insurance | $8,422 |
| 6523 Health Insurance | $8,349 |
| 4124.15 Owner Inspection Fee | $7,510 |
| 6142.15 Zinspector | $7,040 |
| 4823 Other Brokerage Referral Income | $6,784 |
| 6142.19 Showingtime | $6,588 |
| 6122 Office Equipment | $6,570 |
| 6899.01 Brokerage Software Expenses | $5,923 |
| 6899.03 Brokerage Lockboxes Expense | $5,763 |
| 4222 Commercial Ancillary Fees | $5,600 |
| 6660 Professional Fees & Services | $5,600 |
| 6299.01 Signs | $5,485 |
| 4232.03 Misc. Hourly Work By Principal | $5,459 |
| 6813 Brokerage Referral Fees Expense | $5,361 |
| 5840 Brokerage Transaction Fees COS | $5,279 |
| 6814 Brokerage Website | $5,274 |
| 6526 Owner's Disabilty Insurance | $5,255 |
| 4222.05 Accounting/CPA Fees | $5,250 |
| 4232.01 Condo Questionnaire Fee | $5,174 |
| 4124.13 Cancellation Fee - Management | $5,152 |
| 6142.18 Zapier | $4,898 |
| 6645 Property/Renters Insurance | $4,729 |
| 4124.03 Certified Mailings | $4,653 |
| 6124.01 Storage | $4,171 |
| 4222.04 Access/Keycard Management | $4,148 |
| 4124.11 Lease Preparation Fee | $4,075 |
| 6151 Electric | $3,921 |
| 6629 Vacancy Advertising - Other | $3,865 |
| 6669 Prof. Fees & Services - Other | $3,681 |
| 6129 Office - Other | $3,671 |
| 6324 Leasing Contractors | $3,609 |
| 4125.41 Risk Mitigation Setup Fee | $3,400 |
| 6142.24 Notion Labs Inc | $3,229 |
| 4125.23 Paper Payment Administrative Fee | $3,170 |
| 6142.26 Slack | $3,145 |
| 4125.55 Security Deposit Alternative Fee | $3,144 |
| 5720 Maint. Supplies & Materials COS | -$3,113 |
| 6321.02 APM Help | $3,007 |
| 6622 Signage | $2,984 |
| 6699.01 Miscellaneous | $2,888 |
| 6113 Gas & Mileage Reimbursement | $2,807 |
| 6142.05 Call Loop | $2,634 |
| 4125.37 Security Deposit Processing Disposition Fee | $2,411 |
| 6119 Auto - Other | $2,402 |
| 6142.28 Timedoctor | $2,397 |
| 8999.01 Advertising and Promotion | $2,338 |
| 6299.04 Beson 4 (#3) | $2,280 |
| 6142.22 MailChimp | $2,239 |
| 6121 Equipment Rental/Lease | $2,176 |
| 6240.05 Rent bridge | $2,068 |
| 6142.21 Calendly | $1,991 |
| 6714 Maintenance Parking & Tolls | $1,874 |
| 6210.06 Grade.us | $1,782 |
| 4299.02 Other PM Income - Other | $1,750 |
| 6689 Travel - Bills | $1,694 |
| 4125.53 Lease Modification Fee | $1,619 |
| 6150 Utilities | $1,570 |
| 4125.33 Holding Fee and Security Deposit | $1,541 |
| 6129.01 Security Alarm - Office | $1,515 |
| 4232.08 On Boarding Fee | $1,500 |
| 6142.07 Google Storage | $1,383 |
| 4299.01 Citizen Home Solutions | $1,350 |
| 6142.09 Sales Message | $1,345 |
| 6142.10 Adobe Acropro | $1,329 |
| 6142.12 Dropbox | $1,199 |
| 4222.01 Late Fee - Commercial | $1,190 |
| 6142.30 Claude | $1,120 |
| 6240.06 Zapier (deleted) | $1,105 |
| 4232.04 Hourly Management Fees | $1,000 |
| 4124.02 Owner Paid Advertising | $915 |
| 6843 Brokerage Signage | $886 |
| 6210.02 ProspectNow | $870 |
| 6139 Office Maintenance - Other | $869 |
| 6654 Licenses & Permits | $865 |
| 4125.51 Trip Charge | $801 |
| 6142.16 Chat GPT | $800 |
| 4220 Commercial PM Income | $771 |
| 8999 Other Expenses - Other | $770 |
| 6142.25 CodeTwo | $765 |
| 6142.11 RoboForms | $764 |
| 4223.01 Parking Lot Trash Pick-Up | $750 |
| 6670 Taxes | $706 |
| 6841 Brokerage Listings | $704 |
| 6680 Travel | -$701 |
| 4125.54 Security Deposit Alternative Set-Up Fee | $700 |
| 6600 Other Operating Expense | $665 |
| 6240.01 Network Solutions | $650 |
| 6123 Office Furniture | $639 |
| 6510 Employee Gifts | $632 |
| 6699 Other Operating Expense - Other | $620 |
| 4125.28 Unapproved Pet Administrative Fee | $600 |
| 6157 Water | $585 |
| 4129.02 Trip Charge | $581 |
| 6618.01 Utilities | $565 |
| 4125.15 Service Recovery-Trash | $500 |
| 6240.06 GravityForms | $477 |
| 4124.05 Owner Paid Bank Fees | $476 |
| 4125.39 Move-Out Cleaning Fee | $369 |
| 6679 Taxes - Other | $364 |
| 6142.23 RentRange | $359 |
| 4223 Commercial Maintenance Income | $299 |
| 4129.03 Keys | $288 |
| 4125.30 Lease Modification Fee (Other) | $256 |
| 6159 Utilities - Other | $253 |
| 4125.05 Keys | $252 |
| 6693 Uncategorized Expense | $238 |
| 6142.27 Lovable | $229 |
| 6849 Brok. Listing Advert. - Other | $224 |
| 6119.01 Registration/Tag | $223 |
| 4230 CA PM Income | $208 |
| 6799 Direct Maint. Expense - Other | $179 |
| 4125.21 Lease Modification Fee (Change Tenant) | $175 |
| 6640 Insurance | -$171 |
| 6142.31 One Hour Sit | $167 |
| 4125.09 Utility Recovery-Electric | $159 |
| 4129.04 Certified Mailings | $159 |
| 4829 Other Brokerage Income - Other | $151 |
| 4125.10 Utility Recovery-Water | $120 |
| 6130 Office Maintenance | $106 |
| 4125.38 Late Move-Out Fee | $100 |
| 4129.01 Lease Prep | $100 |
| 4125.11 Utility Recovery-Sewage | $89 |
| 4124.10 Marketing Expenses | $75 |
| 4124.20 Vacant Property Monthly Inspection | $75 |
| 4125.52 Lost Key - Tenant Charge | $75 |
| 4124 Other Owner Paid Fees | $68 |
| 4125.29 Missing Key or Access Device Fee | $65 |
| 6636 Fines & Penalties | $63 |
| 4124.01 MLS Advertising | -$60 |
| 4124.09 Lease Prep Fee - Owner | $50 |
| 4125 Other Tenant Paid Fees | $40 |
| 4124.12 Repair | $33 |
| 4120 Ancillary Fees | $25 |
| 4199 Residential PM Income - Other | $25 |
| 6240.07 WPBakery | $15 |
| 6210.07 biggerpockets | $9 |