BUSINESS BACKGROUND
One Operating Account Across a Multi-Entity Rental Portfolio
The client is a residential rental and property asset management operator whose portfolio sits across a set of legal entities, kept on a dedicated property management platform. GATP keeps the books and runs the monthly bank reconciliation across those entities, closing each month against the bank statement.
A rental property bank account is the source document for almost everything downstream. Owner statements, lender packages, year-end schedules and the rental property financial reports an investor reads all sit on top of the reconciliation for that month. The review covered one operating account and the seven months closed so far that year.
Why the Client Ran His Own Property Management Audit
The client ran the review himself, month by month, across the year to date. He was not chasing a missing balance. He was testing whether the record behind the balances would survive a close read, which is the right question and the one most owners never ask.
On the surface the answer was reassuring. Across all seven months the reconciled balance on the operating account was correct, with no differences. The books agreed with the bank to the penny in every period.
KEY CHALLENGES
What the Bank Reconciliation Audit Found: Two Months Filed Under 30 April
Underneath the correct balances sat three findings. None of them would have moved a single total.
- Two reconciliations filed under a month that never happened. The January through July reconciliations all balanced. Two of them, February and March, had been saved under the wrong statement date, stamped 30 April rather than the months they actually covered. The math was right and the label was wrong.
- Three reconciliations wearing the same date, and only two of them wrong. Because of the mis-stamping, three separate reconciliations all showed 30 April. The real April reconciliation was correct and belonged there. The trap was obvious once seen: any instruction to fix everything dated April would have broken the one month that was accurate.
- A short list of cleanup items riding along. The review also flagged a handful of specific items on the matching statement sheet. Small, but worth clearing while the account was open.
This is the class of bank reconciliation problem that a totals check cannot catch. A reconciliation discrepancy shows up as a difference. A mis-dated reconciliation shows up as nothing at all.
IMPACT
Why a Mis-Dated Reconciliation Survives Every Balance Check
A defect like this stays invisible precisely because the totals look perfect. The balance is the number everyone checks, and when it ties out the record is treated as finished. A reconciliation filed under a month that never happened is then inherited by whoever reads it next: the owner reviewing performance, the lender pulling statements, the accountant preparing year-end. Each one trusts the record as filed.
Left alone, two months of this portfolio’s reconciliations would have pointed to the wrong period on every downstream report. The IRS asks rental owners to keep records that support the income and deductions reported on a return. Publication 527, Residential Rental Property, sets that expectation, and the records have to be kept as long as they are needed to prove the figures. A record that proves the right amount for the wrong month does neither job cleanly.
The risk also compounds in the wrong direction. A well meaning cleanup that corrected everything dated April would have damaged the one April reconciliation that was already right. That trades a hidden labelling error for a real one in the numbers.
REQUIREMENTS & EXPECTATIONS
What the Client Asked For Before Any Record Was Changed
The client’s expectations were precise, and they shaped the work.
- Answer the actual question. Confirm whether every month was balanced and filed under the correct period, as two separate answers.
- Change only what is wrong. Correct the mis-dated records without disturbing anything that was already right.
- Protect the correct April reconciliation. Do not let a tidy-up break the month that was accurate.
- Give specifics, not reassurance. Deliver which months, what was wrong, what is being changed, and what deliberately is not.
STRATEGIC APPROACH
How to Audit a Bank Reconciliation Without Breaking the Months That Are Right
GATP treated this as a precision job rather than a redo. The balances were sound, so the work was to correct the record without disturbing anything already correct. The approach broke into three tracks.
- Confirm what is wrong before touching anything
Each flagged reconciliation was opened and checked against the statement it was built from. That confirmed the specifics: on the operating account, the February and March reconciliations had been saved under the 30 April date by mistake, while the genuine April reconciliation was correct. Two records to change, one to protect.
- Correct the dates surgically and preserve the month that was right
The correction is to re-file only February and March under the months they belong to, leaving the April reconciliation exactly as it stands. When several records share a date, the discipline is to move only the ones that are wrong. Sweeping through every entry that looks related is how a clean month becomes a dirty one.
- Work the change through the platform’s controls, not around them
Re-dating a saved reconciliation on the property management platform sits behind permission controls, so the change is made through the proper rights rather than forced. That is the point of bank reconciliation internal controls. A closed reconciliation is meant to be hard to move. The correct response is to use the authority the system expects, even when it is slower than a quick undo.
COMPREHENSIVE SOLUTION
Bank Reconciliation Audit Procedures Used on This Correction
The full correction came together as a single controlled pass across four procedures.
- Verification first. All seven periods were re-checked so the balances could be confirmed correct before any record was altered.
- Surgical re-dating. Only the February and March reconciliations are re-filed under their real months. The correct April reconciliation is left untouched.
- Permission based amendment. The re-dating is worked through the platform’s permission controls, which is the right way to amend a locked record.
- Cleanup in the same pass. The remaining statement sheet items flagged in the review are cleared while the account is open, so nothing is left half done.
None of these are bank reconciliation adjustments in the accounting sense. No balance moved, no entry was reclassified, no journal was posted. The only thing that changed was which period two correct reconciliations are filed under. That distinction is worth stating plainly to a client, because it is the difference between a labelling fix and a restatement.
The same logic sits behind how auditors treat cash. AICPA AU-C Section 505, External Confirmations, was amended by SAS 150 in July 2026. It pushes auditors toward confirming cash held by third parties directly with the source, rather than accepting the client’s own record of it. The principle transfers. The statement is the authority, and the reconciliation has to point at the statement it came from.
MEASURABLE RESULTS
7 Months Verified, 2 Reconciliations Re-Filed, 1 Left Untouched
The account came out of the review exactly where it should be.
- Balances confirmed correct for all seven months of the year, with the account tying to the penny in every period and zero differences found.
- Two mis-dated reconciliations, February and March, identified precisely and slated for re-filing under their real months.
- The correct April reconciliation preserved untouched, so the correction tidied the record instead of trading one error for another.
- Statement sheet cleanup items cleared in the same pass, leaving no unreconciled transactions or loose ends on the account.
- The client’s own check answered with specifics, which months, what was wrong, what is being changed and what deliberately is not, rather than a blanket confirmation that everything was fixed.
KEY TAKEAWAY
Bank Reconciliation Best Practices This Engagement Confirms
A bank reconciliation can fail in two ways. The balance check catches one of them. The other is a reconciliation that ties to the penny and is still filed under a month that never happened. Because the total looks perfect, nothing flags it until someone reads the record closely.
- Reconcile monthly, on a fixed cadence, against the statement rather than the feed.
- Treat the statement date as part of the reconciliation, not as metadata.
- Check for duplicate and missing statement dates every time you review a year.
- Confirm exactly what is wrong before changing anything, and write the list down.
- Change only the records that are wrong, and protect the ones that are right.
- Make the change through the system’s controls rather than around them.
Do that and a reconciliation stops being a number that happens to match. It becomes a record you can stand on.
CLIENT IMPACT
The value here was not a recovered balance. The balances were never lost. It was confidence that the record behind the numbers is now as accurate as the numbers themselves.
File the reconciliations correctly, period by period, and any statement can go to an owner, a lender or a tax preparer knowing it will hold up to a close read. The client got precise answers instead of vague reassurance. The books were tidied without a single correct entry being put at risk.
CONCLUSION – LET’S TALK
Your reconciliations balance, but you are not certain they are filed where they belong. Or a tidy-up risks breaking the months that were already right. That careful correction is the work GATP does: bank reconciliation outsourcing for rental and property management portfolios, month by month, with specifics rather than reassurance.
