RRS — Cash and bank

Pull the current-period statement for each account from the respective bank portal: TD Operating –5892, TD Payroll –8115, TD Depository –7534, TD Money Market –1590, and Chase –(BK stores).

On the Account Balances tab, enter the statement ending date and ending balance for each account in the designated yellow cells.

Confirm the balances agree to the CSV bank statement files (10105, 10305, 10340, 10500, 10700). The last transaction row in each CSV should match the ending balance entered here.

Columns are: Area Coach, State, BK store number, Sem (semester count), GL balance, Difference, and confirmation.

Run a dimension balances report from Intacct for acct 10800, location group RRS, as of the period end date. Paste the GL balances into the GL column alongside each store.

The Difference column auto-calculates (Sem minus GL). A zero difference means the count and the GL agree.

Contact the area coach for any store with a non-zero difference. Document the explanation in the Notes column and request a corrected count or a JE to adjust.

Once all area coaches have confirmed (marked with an X in the last column), the workpaper is complete. No recurring JE is required unless a difference exists.

In RTI, run the Deposit Recap Period-to-Date report and export to Excel. Remove all merged cells and subtotals (unmerge & center, remove subtotal rows). Verify the columns match the RTI Dep tab layout, then paste the data below the existing data — do not overwrite prior periods. Verify cell AA14 = 0.

Run the CA Cash Over/Short report and export to Excel. Add the period-end date in the column to the right of the report, then paste into the RTI CA Cash OverShort 1 tab below prior data.

Download bank detail from each applicable bank — TD Depository –7534, Bank of Princeton, Franklin Bank — for days not yet downloaded. Do not duplicate dates. Paste into the corresponding bank tabs.

The workbook compares POS deposits to ICL/Loomis bank credits by store and date. Review any non-zero differences in the summary columns.

Differences carry to the over/short posting. Use IMPORT_Safe_Over_and_Short_P5.csv and IMPORT_Safe_Fees_P5_1.csv as the Intacct import once the reconciliation is signed off. Post timing differences (deposits in transit) separately.

Obtain the RTI Credit Card Sheets Combined export for the period and paste into the RTI Raw Data tab, replacing prior period data.

Paste the First Data Settlement Report into Settlement Raw Data (ensure the date range covers the full period). Paste TD Bank statement data (AmEx ACH credits) into TD Bank Raw, and Chase statement data (Discover ACH credits) into Chase Raw.

Update the period number and date range in the yellow cells on the Recon Summary tab. All SUMIFS recalculate automatically.

Use the Detail by Store tab to isolate any store with a large variance.

Once clean, export or save the summary as the period workpaper. IMPORT_CC_Verification_P5_2026.csv is the reconciled output used for any adjusting entries.

Obtain receipts for any petty cash disbursements made during the period. Enter each in the Office Petty Cash Tracking tab: Coding (account-location), Period, Date, Amount (negative = expense), Vendor, and Reason. The Balance column updates automatically.

When the fund is replenished, enter the replenishment as a positive amount coded to 11000-90001.

At period end, run the GL detail for acct 11000 from Intacct and confirm the ending balance matches the workpaper balance column.

If a discrepancy exists, trace each line to its receipt. Post a correcting JE if a disbursement was not recorded.