Here are the steps to create audited school financials for the PCSB

  1. Open the June'22 FRT22 for the school
  2. Update the Income Statement (IS1) and Balance Sheet (BS1) for the school
  3. Update the presentation, adding new custom accounts as necessary
  4. On the setup tab,
    1. Cell T67, please change from "FRT22" to"FRT23"
    2. Near cell Z3, press the "Upgrade Software" button
    3. Near cell AC3, press the "Run ExcelUpdates" button
    4. Near cell I55, click the "Create Authorizer Report" button
  5. When prompted, select Yes or No for owned facilities
  6. In the Audited FS Template Annual tab
    1. Select the school from cell C2
    2. On the Annual tab
      1. Rows12:18 | Reallocate occupancy expense between owned and leased 
      2. Rows 27:29 | Enter functional expense breakdown from the audit. This will clear the red flag