RRS — Receivables

Run the GL detail for acct 12000 from Intacct. Confirm the ending balance matches the workpaper total (illustrative: $7,607.34 as of the last update).

For the DE Gross Receipts penalty: check with Caitlin/legal for any response to the abatement letter and update the Comments column with current status.

Confirm with Caitlin whether a refund check or credit has been received for the Loop overpayment (illustrative: $6,696). If received, record DR Cash / CR 12000 and remove from the schedule.

Add any new AR items that arose during the period with date, store, description, and amount. The total must agree to the Intacct GL balance — any difference requires a JE or a correction to the workpaper.

Confirm the GL balance for acct 12100 is $0 in Intacct (the $8,299 write-off was recorded in P3 per Mike's direction).

If any new amounts arise (seller adjustments, additional credits), add a line to the schedule and confirm with Mike before recording.

If the balance remains $0, no update is required — note "Balance $0 — confirmed [Period]" in the Comments column.

In Intacct, run the Intercompany Tie Out Report for location group "RRS / RCY Entities" as of the period end date. Export to Excel.

Paste the report output into the workpaper, replacing prior period data. Confirm the As of Date cell is updated.

Verify acct 12505 for RRS and RCY net to zero (equal and opposite).

Confirm whether any payment was received from Coke or RSI during the period. The BOP receivable carries forward from the prior period ending balance for both accounts — verify these match the prior period EOP balance.

Pull total RRS net sales for the period from the sales journal or RTI. Multiply by 1.76% for Coke (80% portion) and 0.44% for RSI (20% portion). Enter as negative amounts — credit to income, debit to receivable, shown as negative per the workpaper convention.

Use IMPORT_P5_Rebate_Accrual.csv: GJ to acct 49000 by store location. Confirm the total matches your calculation.

If a payment is received during the period, enter it in the "Pmt Received" row and verify the EOP balance reduces accordingly.

Confirm the EOP balance for both accounts agrees to the Intacct GL dimension balance report.

Confirm the GL balance for acct 12800 equals the workpaper total (illustrative: $100 from a DD partial return).

For an open DD partial return, confirm with payroll (Jessie) whether the employee has repaid or been deducted. If collected, record DR Cash (or PR deduction) / CR 12800 and clear the line.

Add any new employee receivables (payroll advances, overpayments) with date, store, description, amount, and repayment plan.

Log in to Skylight.net (NetSpend portal) and navigate to Tools → Reports → Skyposit Reconciliation Report. Pull for the full period — this exports a CSV with settlement date, employee name, account number, and amount.

Paste the Skylight CSV data into the Skyposit_Reconciliation_Report tab, below any prior period rows.

Sum the total credits (positive amounts = credits loaded to employee cards) for the period. This is the paycard expense for the period.

In ProWork, determine the reference number sequence used for paycard "checks" — a separate sequence from regular payroll checks. Confirm with Jessie.

IMPORT_12850_Paycard_P5_2026.csv is pre-built: PYRJ journal type, DR/CR to acct 12850 by entity (E01 for RRS, RCY for Cayenne). Verify the amounts match the Skylight total before importing.

After import, confirm acct 12850 GL balance is cleared, or reflects only amounts loaded but not yet redeemed.

Use the Gift Card login in the permanent file. Navigate to Prepaid Business Center → Reporting.

There are 6 reporting groups. For each: select the group, click Go, select Date Range Downloads, then run two reports —

• Details for the period → paste into the GC1 tab
• Fee Invoice Summary Report for the month → save in the bank docs folder for the next period

After all 6 groups are done, go to the GC Sum By Store tab and refresh the pivot table. Copy the pivot and paste as values into columns K–Q of the same tab.

Update the GC Account Entry from SJ tab by pasting in gift card data from the sales journal.

Review column AA on the GC Sum by Store tab and compare variances to sales journal over/short variances:

Before posting any adjusting JE, review the GC Recon tab — confirm no other variances remain and that the GL will tie out after adjustments.