Cleanup Bookkeeping Case Study: 19-Property Rental Portfolio

Project Overview

A real estate investor and landlord came to Bookkeep Boss with a growing rental portfolio that needed more than categorized transactions. The portfolio had reached a level of complexity that required more detailed records, reconciliations, and reporting by property than they were receiving.

They needed rental property bookkeeping in QuickBooks Online that could show activity across the full portfolio, including rental income and expenses for each property, along with financial reports their tax professional could use for tax preparation, tax planning, and ongoing portfolio management.

The project involved cleaning up the 2025 QuickBooks Online records, bringing the QuickBooks Online file current through May 2026, reconciling one bank account and three credit card accounts, separating the principal and interest portions of monthly payments for five mortgage loans, reviewing and tying out security deposit activity to owner statements, and establishing a property-level reporting structure across 19 rental properties.

Client Profile

Introductory Call

The process began with an introductory phone call to discuss the client’s 19-property rental portfolio, their current QuickBooks Online setup, bookkeeping situation, and reporting needs for tax preparation, tax planning, and ongoing portfolio management.

The purpose of the call was to understand the situation at a high level and identify the next step. Based on the size of the portfolio, the property manager activity, and the reporting the owner needed, the client moved forward with a paid Bookkeeping Review.

Bookkeeping Review

The paid Bookkeeping Review established the starting condition of the QuickBooks Online file and defined the cleanup scope.

Before proposing cleanup work, Bookkeep Boss reviewed the QuickBooks Online file, property manager's owner statements, bank activity, credit card activity, loan activity, and supporting records already uploaded. Those records included receipts and purchase confirmations stored through the QuickBooks Online receipts feature.

Using a reconciliation-focused approach, the review compared QuickBooks Online activity with property manager's owner statements, bank statements, credit card statements, loan statements, security deposit activity, and supporting documentation.

This comparison identified transactions, account balances, and reporting gaps that needed reclassification, reconciliation, correction, or further review before the financial records could be used for tax preparation.

The review identified that:

• Net deposits received from the property manager had been recorded as rental income without showing the gross rental income, property management fees, property expenses, and security deposit activity reflected on the owner statements.
• One bank account and three credit card accounts needed reconciliation.
• Security deposit balances did not tie to the property manager's owner statements.
• Some security deposit balances related to tenants who had moved out were still showing in QuickBooks Online.
• Monthly payments for five mortgage loans needed to be separated between principal and interest.
• Income and expenses were not assigned by property.
• Property-specific expenses were blended with broader operating expense accounts.
• The owner did not have a Profit & Loss report for each of the 19 rental properties.

The review showed that the cleanup needed to address both account activity and the reporting structure. Detail from the property manager’s owner statements needed to be reflected in QuickBooks Online, account balances needed to be tied to source documents, and income and expenses needed to be assigned by property.

This made it necessary to establish a property-level reporting structure across all 19 rentals, correct the 2025 historical activity, and complete the January through May 2026 catch-up work using that structure.

The completed review provided the detail needed to define the cleanup scope and pricing that would be presented during the results call.

Results Call

Once the Bookkeeping Review was complete, the findings were discussed with the client during a results call.

The call covered the condition of the QuickBooks Online file, the source documents reviewed, the 2025 cleanup needed, the January through May 2026 catch-up work needed, the sequence of work, and the pricing for each part of the project.

The client could see why the project included recording the full activity shown on the property manager’s owner statements, reconciling bank and credit card accounts, correcting security deposit balances, separating mortgage principal and interest, and establishing property-level reporting. The January through May 2026 catch-up work was then completed before monthly bookkeeping began.

The findings, approved scope, and work sequence from the results call became the basis for the cleanup and catch-up work described below.

How the Client Moved Through the Process

Introductory Call → Paid Bookkeeping Review → Findings, Scope & Pricing → Results Call → Approved Cleanup Work

Cleanup and Catch-Up Work Performed

With the cleanup scope approved, work began with the 2025 historical activity and then continued through the January–May 2026 catch-up period.

Property manager's owner statements were recorded through journal entries so the QuickBooks Online file reflected the activity behind each net deposit. This included gross rental income, property management fees, property expenses, and security deposit activity shown on the owner statements.

The final deposits sent by the property manager were then matched to the related bank-feed activity. This connected the cash received by the owner to the underlying rental activity without recording rental income twice.

The cleanup and catch-up work also included:

• Reconciling one bank account and three credit card accounts against the related statements and transaction activity.
• Reviewing security deposit activity against property manager's owner statements and correcting the related QuickBooks Online balances.
• Separating the principal and interest portions of monthly payments for five mortgage loans.
• Using receipts, purchase confirmations, and other available records to assign property expenses to the correct rental.
• Establishing class tracking in QuickBooks Online Plus for all 19 rental properties.
• Completing the January through May 2026 activity using the new property-level reporting setup.

By completing the cleanup and catch-up work in that order, the 2026 activity could be entered and reported using the same property-level structure created during the 2025 cleanup.

Outcome and Deliverables

After the cleanup and catch-up work was completed, the client received updated QuickBooks Online records through May 2026, reconciled bank and credit card accounts, reporting by property for all 19 rentals, and financial reports for review with their tax professional.

The completed QuickBooks Online file showed more than the final net deposits received from the property manager. It separately recorded the gross rental income, property management fees, property expenses, and security deposit activity shown on the property manager’s owner statements, while mortgage payments were separated between principal and interest.

With the cleanup, catch-up work, and property reporting structure in place, the client received the following financial reports.

Financial Reports Delivered

2025 Reporting Package

The completed 2025 reporting package included:

• Balance Sheet comparison to the prior year
• Profit & Loss comparison to the prior year
• Profit & Loss by Class, with each class representing a rental property
• Detailed General Ledger for tax-preparation review 

January Through May 2026 Reporting Package

The January through May 2026 reporting package included:

• Monthly Balance Sheets
• Year-to-Date Balance Sheet
• Monthly Profit & Loss reports
• Year-to-Date Profit & Loss report
• Monthly Profit & Loss by Class reports
• Year-to-Date Profit & Loss by Class report

The 2025 QuickBooks Online records were completed for tax preparation, and the January through May 2026 records were brought current.

The owner received reconciled account activity, class-based reporting for all 19 rental properties, and portfolio-level reporting for both periods. Security deposit liability balances were updated using the available supporting records, and relevant receipts and purchase confirmations were attached to related QuickBooks Online activity when available.

The project also established a property-level reporting process that could continue into monthly bookkeeping.

Monthly Bookkeeping After Cleanup

After the cleanup and catch-up work, the client moved into monthly bookkeeping using the property-level setup created during the project.

Each monthly cycle includes recording activity from the property manager’s owner statements, matching net deposits to bank activity, reconciling accounts, separating mortgage principal and interest, reviewing security deposit balances, assigning transactions by property, and preparing portfolio-level and property-level financial reports.

This process maintains the connection between the source activity on the owner statements, the account activity in QuickBooks Online, and the reports used by the owner and tax professional.

About This Case Study

This case study documents professional bookkeeping work completed from the QuickBooks Online file and records provided or accessible during the project.

The client process moved from an introductory phone call to a paid Bookkeeping Review, results call, cleanup and catch-up bookkeeping, and monthly bookkeeping.

The work followed a reconciliation-focused approach. QuickBooks Online account activity and Balance Sheet balances were compared with available source records, including owner statements from the property manager, bank statements, credit card statements, loan statements, security deposit activity, receipts, purchase confirmations, and other supporting documentation available during the project.

This case study reflects actual bookkeeping work completed by Bookkeep Boss. Client-identifying information, property addresses, account details, and financial amounts have been removed to protect confidentiality.

The work described included bookkeeping, account reconciliations, property-level reporting, and financial report preparation. It did not include tax return preparation, tax advice, legal advice, audit services, or assurance services. Tax treatment and filing decisions remained with the client’s tax professional.

Related Resource: See a sample CPA-ready monthly bookkeeping close summary

Prepared by Laura Parker
Co-Owner, Founder, and Bookkeeping Lead, Bookkeep Boss LLC
Certified QuickBooks Online Expert (Level 2)
Learn More About Laura