How to Reconcile Accounts Receivable and Transfers

Learn how to complete monthly bank reconciliations for accounts receivable and intercompany transfers using the Bank Rec Master file and Yardi Voyager.

July 21, 2026 By eduardo

This guide explains how to perform monthly bank reconciliations for accounts receivable and intercompany transfers. By following these steps, you will accurately filter banking transactions and cross-reference them against internal deposit reports to ensure financial records are correct.

This procedure is designed for finance and accounting team members responsible for property management bookkeeping. It should be used during the monthly close process when validating ledger balances against actual bank deposits.

Step #1: Open the Bank Rec Master Excel file. — Open the **Bank Rec Master** Excel file.

Step #2: Click the Dashboard tab to view the accounts requiring reconciliation for the month. — Click the **Dashboard** tab to view the accounts requiring reconciliation for the month.

Step #3: Open Windows File Explorer to locate your work paper. — Open Windows File Explorer to locate your work paper.

Step #4: Navigate to your Dropbox folder (e.g., Finance Dept - Team\02. Banking\5. Reconciliations\06 LLC's\2026) and double-click the previous month's transaction log. — Navigate to your Dropbox folder (e.g., `Finance Dept - Team\02. Banking\5. Reconciliations\06 LLC's\2026`) and double-click the previous month's transaction log.

Step #5: Return to the Bank Rec Master file and select the specific bank account you are working on. — Return to the **Bank Rec Master** file and select the specific bank account you are working on.

Step #6: Click the last four digits of the bank account to navigate to the sheet containing that month's transactions. — Click the last four digits of the bank account to navigate to the sheet containing that month's transactions.

Step #7: Right-click the active sheet tab and select Move or Copy.... — Right-click the active sheet tab and select **Move or Copy...**.

Step #8: Select a new workbook as the destination, check the Create a copy box, and click OK. — Select a new workbook as the destination, check the **Create a copy** box, and click OK.

Step #9: Sort the copied sheet alphabetically by transaction description. — Sort the copied sheet alphabetically by transaction description.

Delete all transaction rows unrelated to accounts receivable or intercompany transfers.

Delete items such as utilities (Baltimore Gas, Baltimore Water), rental licenses (Baltimore Gov), checks, counter credits, insurance, and mortgage payments.

You should only keep the following transaction types for your reconciliation:

Transaction Description	Purpose / Source
Flex	Tenant payments made through the Flex program.
GNR Prop	Tenant payments made via debit card, money order, or ACH transfer.
HA Baltimore City	Payments received from the HABC agency.
Online Banking transfer	Intercompany transfers, such as management fees or leasing commissions.
Credit Card	Standard credit card deposits.

Step #11: Log in to Yardi Voyager and search for the Cash Management Deposit Summary report. — Log in to Yardi Voyager and search for the **Cash Management Deposit Summary** report.

Type the bank account identifier (e.g., excel 04) into the bank search field.

Step #13: Set the date range to start at least 5 days prior to the reconciliation month and end on the last day of the reconciliation month. — Set the date range to start at least 5 days prior to the reconciliation month and end on the last day of the reconciliation month.

Step #14: Ensure all deposits are included in the filter and click Submit. — Ensure all deposits are included in the filter and click **Submit**.

Step #15: Export the generated report and open the downloaded Excel file. — Export the generated report and open the downloaded Excel file.

Step #16: this file is we're gonna insert a column, and we're gonna copy the information from the Amount — this file is we're gonna insert a column, and we're gonna copy the information from the Amount

Insert a new column next to the Amount column. Copy the values from the original Amount column into the new one, then delete the original column.

Filter the table by deposit number, then filter the Memo column to display only CC deposit entries.

Step #19: Check your previous month's work paper to identify the last reconciled deposit (e.g., CC - 738) and delete any already-reconciled rows from your current report. — Check your previous month's work paper to identify the last reconciled deposit (e.g., CC - 738) and delete any already-reconciled rows from your current report.

Step #20: Return to your filtered transactions workbook to calculate the total amount of credit card payments received during the month. — Return to your filtered transactions workbook to calculate the total amount of credit card payments received during the month.

sixty-nine. So these are the deposits I'm gonna

Select deposits in your summary report until their sum matches your calculated total, and delete any excess rows.

Step #23: In your new work paper, highlight the previous month's data and click Clear All. — In your new work paper, highlight the previous month's data and click **Clear All**.

Copy the four columns of your matched deposits and paste them into the work paper to complete this portion of the reconciliation.

Q: Should I include all deposits when pulling the Cash Management Deposit Summary report?

A: Yes, ensure that the filter is set to include all deposits before generating the report.

Q: How far back should the date range be set for the deposit summary report?

A: Set the start date to at least five days prior to the beginning of the month you are reconciling. This ensures all relevant deposits that cleared across month boundaries are effectively captured.

Term	Definition
Bank Rec Master	A live Excel dashboard used to track and manage bank accounts scheduled for monthly reconciliation.
Intercompany transfer	A transaction moving funds between different entities or subsidiaries operating under the same parent company.
Work paper	A foundational spreadsheet document used by accountants to prove, reconcile, and document account balances.
Yardi Voyager	A property management and accounting software platform used to track real estate financials and operations.
HABC	Housing Authority of Baltimore City, a government agency providing affordable housing assistance programs.

Transaction Description

Purpose / Source

Flex

Tenant payments made through the Flex program.

GNR Prop

Tenant payments made via debit card, money order, or ACH transfer.

HA Baltimore City

Payments received from the HABC agency.

Online Banking transfer

Intercompany transfers, such as management fees or leasing commissions.

Credit Card

Standard credit card deposits.

Term

Definition

Bank Rec Master

A live Excel dashboard used to track and manage bank accounts scheduled for monthly reconciliation.

Intercompany transfer

A transaction moving funds between different entities or subsidiaries operating under the same parent company.

Work paper

A foundational spreadsheet document used by accountants to prove, reconcile, and document account balances.

Yardi Voyager

A property management and accounting software platform used to track real estate financials and operations.

HABC

Housing Authority of Baltimore City, a government agency providing affordable housing assistance programs.