RRS — Inventory and prepaids

Copy / paste-special values from columns C & D into the prior period columns F & G on the BK Ending Inventory tab.

Go to RTI → Other/Utilities → Export RTIconnect data. Export Inventory Items for All Stores with a date range of 1/1/2023 to current — this captures every item that has ever been inventoried. Open the export, remove duplicates, and sort by Item ID. Paste into columns C onward on the Inventory Items tab.

Any item returning an error in column B needs to be added to the bottom of the table on the Inventory Consolidated $ tab, and assigned the correct GL code.

Back in RTI → Other/Utilities → Export RTIconnect data, export Inventory for All Stores for the period. Paste into columns A onward on the Pd End Inventory Export tab.

Refresh the table on the ConsolidatedInventory Unpivot tab, then scan the BK Ending Inventory tab for any large changes from the prior period.

Open the Prime Costs Report — this generates the estimated FCOS/GP for the period on the NOTES tab.

Post the inventory adjustment JE in Intacct: DR/CR accts 50100 and 50400 / 50450 by location, to true up the GL to the physical count. Confirm the total GL balance for inventory accounts ties back to the workpaper total after posting.

Run the YTD GL Detail for acct 14000 from Intacct for entity RRS. Remove the "Subtotal by Location" option. Export to CSV.

Copy columns A through K into the General Ledger Report worksheet. Do not overwrite the beginning balances highlighted in green.

Check column L for any "NA" values. If a line with NA is not a total row, go to the Cross Reference tab and add the vendor or service name for that item.

Confirm the period amortization (expense) has been posted. If a bill was paid this period, confirm it was coded to 14000 (prepaid) and not directly to expense.

Amortize based on the contract period — current period amortization = annual fee ÷ 13 periods.

The ending balance per the workpaper must tie to the Intacct GL balance for acct 14000.

When new RE tax bills are received, add them to the All Stores tab in the column for the billing month — not the due date. Highlight the amount appropriately.

At period end, populate the 14100 and 24200 tabs with current GL balances from Intacct's dimension balance report. Check for unexpected items.

RJEs are based on the annualized tax rate for each store: total annual bill ÷ 13 periods. This should not change unless a new bill is received or a rent increase takes effect.

At the start of each quarter (P1, P5, P8, P11), recalculate RJEs for all stores using the amounts in the All Stores tab column V (current annual total). Use the provided formula columns at the far right to update all stores at once.

Confirm the recurring RJE was posted this period. If a bill was paid (DR 24200 / CR Cash), confirm both the payment and the accrual reversal are recorded.

Recurring expense amounts are pre-calculated in the workpaper by policy. The primary lines are General Liability, Property, Umbrella, and Auto — on the 06/23/25–06/23/26 policy year.

When a premium payment is made, enter the amount in the Act Pymt row for the applicable column. The workpaper calculates the updated prepaid balance automatically.

If an endorsement or policy change is received (mid-year additions such as new DHC stores or fleet changes), enter the adjustment in the Adjust row for the month received and note the endorsement details.

Confirm the ending prepaid balance agrees to the Intacct GL for acct 14300. A non-zero DIFF TO RESOLVE column indicates a timing or coding difference to investigate.

For each store row, confirm whether a rent payment was made this period. If yes, enter the amount in the DEBIT (Payment) column for the current period.

The CREDIT (Expense – RJE) column should match the periodic base rent amount. Confirm the RJE was posted in Intacct as a recurring journal entry.

The running BALANCE column at each period is the prepaid asset balance on the balance sheet. Confirm it matches the Intacct GL for acct 14500 at period end.

If a store has a rent increase effective this period, update the RJE amount and note the new lease commencement or amendment. Cross-reference the 2026 Rent Schedule for current base rent by store.

For stores several months into an advance cycle, confirm a negative balance trend is expected given the payment and amortization pattern.

Review the 2026 POS Summary tab for any new invoices received this period. If a bill is received, add the cost, term start/end dates, and annual amount in the appropriate vendor section for the store.

Per-period expense = total contract cost ÷ number of periods in the term.

Confirm the GL balance for acct 14600 agrees to the sum of all unamortized balances in the workpaper.