Pro Forma Financial Statements

If L1 is greater than N1, the value calculated is the maximum value for the factor. If L1 is lower than N1, the value calculated is the minimum value for the factor. On the ‘Validation’ worksheet the ‘NOR & phase’ check will fail for a school if its phase and NOR don’t align in the ‘Adjusted Factors’ worksheet. All the checks on the ‘Validation’ worksheet must be passed before you can submit your APT. The ‘Validation’ worksheet contains comments providing detailed information to help clear any failures. These comments explain why the check has failed and how to resolve it.

• In cell U6 enter the number of key stage 4 high needs places in the 2022 to 2023 academic year, excluding those pupils who are not registered in that school.
• The ‘Proposed Free Schools’ worksheet contains details of any free schools proposed to open after the October 2022 census date, but before the end of the 2023 to 2024 academic year.
• When an invoice has been paid up, the business will need to offer a sales receipt.
• The pupil numbers used are based on those entered on the 2022 to 2023 APT and are the same as the total used in the MFG baseline.
• In cell BP6, enter the academic year secondary NOR where apportioned financial year pupil numbers have been entered for the school (columns R to AC).
• Deprecation reduces the carrying amount of the PPE without being a cash flow.

In cell E22, enter the primary IDACI Band D amount per-pupil value. In cell E21, enter the primary IDACI Band E amount per-pupil value. In cell E20, enter the primary IDACI Band F amount per-pupil value. In cell E16, enter the key stage 4 (years 10 to 11) AWPU amount per-pupil value.

Submitting the APT to ESFA

In cell P6, enter the 2022 to 2023 NOR (excluding the reception uplift figure) and with any adjustment for part-year funding taken into account. You must also enter any 2022 to 2023 minimum funding guarantee (MFG) exclusions and adjustments to be used for the MFG calculations in the ‘New ISB’ worksheet. If entries are not made a failure will be noted on the ‘Validation sheet’ and you will be required to resubmit the APT with the values entered.

• This is not applicable for the ‘change in pupil numbers/factors’ and ‘other’ options, where only changes should be recorded.
• The APT is pre-populated with the primary, key stage 3 and key stage 4 rates.
• Follow this step-by-step guide to create a proforma invoice for your own business.
• The purpose of a proforma invoice is to show how much goods or services will cost to help the customer decide if they want to go ahead with the purchase.
• 9) Column AT will show whether the number of sites entered in column E matches the number of sites for which details have been entered.
• In cells Z6 to AB6, enter any additional exemptions to be excluded from the MFG calculations.

Commercial invoices are used to calculate the financial value of goods being traded and any applicable taxes that may apply to the shipment. But we’re going to explore a different type of proforma document; the proforma invoices. The pro forma invoice is distinguished from the commercial invoice by its name and function. On a recipient’s pro forma invoice, you clearly state that the invoice was created for formal reasons only and therefore does not contain a payment request. Unlike in the commercial invoice, you do not specify a payment amount in the pro forma invoice. Pro forma invoices are also used for transactions processed by letters of credit or as a prerequisite for issuing import licenses.

Proforma Invoice

Now you know all about proforma invoices, you hopefully have one less detail to worry about in your sales process. The date on this invoice is the tax point and is used for your VAT return. A commercial invoice is bookkeeping for startups used in international shipments to declare to the customer and customs officials what is being shipped, who is selling and buying, the date and sale terms, the quantity and weight of goods, and other details.

In cells E17 to E23, state ‘Yes’ if the entry made in the adjacent cell of column C relates to one-off funding. In cells C17 to C23, provide a detailed narrative if you have used any of the approved exceptional circumstances 1 to 7. In cells E7 to E13, state ‘Yes’ if the entry made in the adjacent cells of column C relate to one-off funding.

Why use pro forma invoices?

The article will explain how to calculate cash flows and where those cash flows are presented in the statement of cash flows. You should enter here the total of any entries in exceptional circumstances 3 to 7 (columns AD to AH) which do not relate to premises costs or which have been agreed should not be included in the MPPL calculation. Enter here any necessary adjustments to account for any difference between previously submitted 2022 to 2023 SBS and now known actual values. This could be calculated by using last year’s APT and re-running updated figures for the school through this, and then calculating the difference between this result and the SBS actually paid. This column should only be used if you are retrospectively adjusting previous year rates amounts in 2023 to 2024.