# Start here: companion files of The Accounting Method Change Handbook (Julian R. Sterling)

Nine Excel files, each with three tabs: Inputs (blue cells, type your own values), Calc (formulas only) and Checks (each line reads 0 when the check passes; Checks!B2 adds them up).

- `W1_Gross_Receipts_Test.xlsx`: Workbook 1: Gross Receipts Test. The Section 448(c) test of one corporation, alone and aggregated with a commonly owned corporation. Filled with Thistlegrove for 2025, aggregated with Corlaven.
- `W2_Bonus_Timing.xlsx`: Workbook 2: Bonuses and the 2 1/2 Month Period. Which year-end bonus pools are deductible in the year earned, and the Section 481(a) adjustment of the change. Filled with Corlaven's 2024 bonus pools.
- `W3_481a_Adjustment_and_Spread.xlsx`: Workbook 3: Section 481(a) Adjustment and Spread. The Section 481(a) adjustment of one change from its accounts, the adjustment period, the yearly inclusions, the taxable income and tax effects and their present value. Filled with Corlaven's bonus change.
- `W4_Advance_Payments.xlsx`: Workbook 4: Advance Payments and the Deferral Method. The AFS part of each advance payment, the part deferred to the next year, and the Section 481(a) adjustment of a change to the deferral method. Filled with Corlaven's five maintenance contracts received in 2025.
- `W5_Prepaid_12_Month_Rule.xlsx`: Workbook 5: Prepaid Expenses and the 12-Month Rule. Which prepaid items are deductible when paid, and the Section 481(a) adjustment. Filled with Corlaven's three prepaid items paid in 2024.
- `W6_De_Minimis_Safe_Harbor.xlsx`: Workbook 6: De Minimis Safe Harbor. Which invoices the de minimis safe harbor election covers. Filled with six of Corlaven's 2025 invoices.
- `W7_Tax_Effect_and_Present_Value.xlsx`: Workbook 7: Tax Effect and Present Value. The tax effect of each year at the tax rate on the taxable income effect of the year, and its present value. Filled with Corlaven, 2025 to 2028.
- `W8_Filing_Dates_and_Audit_Protection.xlsx`: Workbook 8: Filing Dates and Audit Protection. The filing date, the duplicate copy window, the examination status, the issue under consideration and the audit protection of one change. Filled with Corlaven's bonus change.
- `Section_481a_Calculator.xlsx`: Form 3115 Section 481(a) Adjustment and Spread Calculator, the free calculator, filled with example values that are not the case of the book.

The values typed in the files are the book's fictional case and scenarios: teaching assumptions, not market figures. Change one input at a time and read the result again. Rely on nothing while Checks!B2 is above zero.
