Revenue Report

Revenue Report


The Revenue Report shows the total amount of revenue you are likely to receive within a specified date range based on the invoices and credit notes that have been raised during that time. For each child you will be able to see the total amount of the invoices and discounts on their account; if the child is entitled to funded hours from your LEA you will also see the total amount you are able to reclaim on their behalf.

To view the Revenue Report, do the following:
  1.  Click on the Reports button and select 'Finance'.
     This will display the Reports Menu page:



  2.  Click on 'Revenue Report'.
     This will display the Report Selection page:



  3.  Choose if you want to run the report by 'Created Date' or 'Document Date'
    1. 'Created Date' will include all invoices and credit notes that were created within the selected date range.
    2. 'Document Date' will include all invoices and credit notes that are dated within the selected date range.
  4.  Select if you want the report to include both invoices and credit notes.
  5.  Select a date range to run the report for.
  6.  Choose if you want the report to include registered children, children who have left during the selected date range and/or children who are on your waiting list. 
  7.  Choose if you want to run the report for a specific room or all rooms.
  8.  Choose how you would like the data in the report to be sorted; by default the report will be sorted by child surname. 
  9.  Click on the 'Go' button.
     An example of the report output is as follows:



    Understanding the Revenue Report:
    1. For each child you can see their name and account number. If more than one invoice and/or credit note has been added to the child's account during the selected date range you will see their name listed multiple times in the report.
    2.  The 'Type' column displays 'Inv' for invoices and 'Cr' for credit notes.
    3.  For each invoice you will see the invoice number and date.
    4.  For each credit note you will see the credit note number and date, along with the related invoice number and date.
    5.  The 'Sales' column shows the total amount charged to the child's parents/carers for each invoice. Credit notes will show as £0.00.
    6.  The 'LEA Reclaim Value' column shows the total amount you are able to reclaim from your LEA for providing funded hours; this amount is calculated based on the value entered for the funding group the child is assigned to multiplied by the number of funded hours the child has attended.
    7.  The 'Total Sales Including LEA Reclaim Value' is the sum of the 'Sales' column plus the 'LEA Reclaim Value'. 
    8.  The 'Discounts' column shows the amount of any discounts on each invoice.
    9.  The 'Revenue' column shows 'Total Sales Including LEA Reclaim Value' minus 'Discounts'.
    10.  At the bottom of the report you can see the 'Total Sales' (total number of invoices), the 'Total Credit Notes' and the 'Total Revenue' (Revenue Total - Credits Total) for the selected date range. 




    • Related Articles

    • Hours Booked Report

      The Hour Booked Report details the number of paid and funded hours booked for each child within a selected date range. To view the Hours Booked Report, do the following: Click on the Reports button and select 'Finance'. This will display the Reports ...

    • Detailed Invoice Summary Report

      The Detailed Invoice Summary Report shows details of all invoices generated within a selected period displaying a breakdown of the charges on each invoice, any payments that have been allocated to the invoice and the outstanding balance.  To view the ...

    • Credit Notes

      If you have generated an invoice and noticed it is incorrect, you will need to raise a credit note before you are able to generate a new invoice. To credit note an invoice, do the following:  Click on the Children button and select 'Accounts': ...

    • Tip of the Month #12 - All About Funding

      For this months Tip of the Month, we're going to be taking a look at Funding! Now that the new school year is upon us, why not brush up on how funding works on Abacus and what things you might be missing! We will cover reports, funding terms and ...

    • Product Report

      The Product Report lists all products that have been added to a child's account within a selected date range. If a product has been invoiced, you will be able to see the corresponding invoice date and number. This report allows you to see how many of ...