Invoicing Statistics
All statistics reports work in a similar
way.
To delete a
selection, highlight the value required and click the "Remove" button. Sorting Options
A typical use of "invoicing" statistics is to establish
the "deferred" sales at the end of an accounting period.
Deferred Sales/Forward Income
This clearly overstates the income in January and in
order to more accurately reflect the true sales for the month, it would be
necessary to defer 11 months of the income (£11,000) to future accounting
periods.
As £12,000 will have been credited to sales from the
posting of the invoice, the deferred value of £11,000 is correctly shown in the
column of 01/02/13. If forward bookings go into 2014, then this value will need
adding to 2013.
DO NOT BE TEMPTED TO USE
THE £1000 AS SALES FOR THE MONTH!
HOW? Before running the
Deferred Income report, ensure all proformas for arrivals up
to the period end date have been converted to invoices. Statistics Sorting
Invoice Date Range Category If sales need to be "Grossed Up", then a separate report
(just for the single period) should be created using "Discount".
Journals can be created in total or by element, as
required. Examples of other
reports General Information on statistical values:
To include a selection, click on the tab for the category
required and click the "Add" button.
A selection form
will allow you to choose the value required, eg. for territories.
Up to 5 fields may be defined as Sort Fields.
These will determine the sequence of records on the
report.
For each sort field added, sub totals can be
produced.
General
income from
invoices/credit is normally credited to the P&L account in the month the
invoice is produced, meaning an invoice dates 01/01/13 for £12,000 on a course
from 01/01/13 to 31/12/13 will initially show as £12,000 income in January
2013.
This is achieved by running a Statistics
(Invoicing) report to calculate the amount of deferred income.
Although it is tempting to get
Class to just show (invoiced) income on a month by month basis by spreading net
income over the duration of the course and using this as the basis for the
accounts, it is not the most accurate and best way to achieve correct figures.
The best way to produce the
required figures is to create a statistics report that shows annual totals based
on the start date of the current accounting period, eg. if account are being
produced for the month of January 2013, then the report should start with
01/02/13 for say 4 years. This will show income for the example above as
follows:
For the next accounting period, simply
move the date to 01/03/13.
Although in
many cases this may be the correct value, it will not accurately reflect all
retrospective changes to bookings (a frequent occurrence in language schools).
It is also easier to prove the forward sales figure by producing an audit list
of all the forward bookings (by name, invoice number etc).
This is done by
running the Batch Invoice process, and dating the invoices as at the period end
date (as below).
Go into Reports > Reporting Module > Invoicing
Statistics.
Click on Add.
Name - As
appropriate
Basis - Use Date
Spread (will spread values over their duration)
Period Type - Years
From Date - The start of the current accounting
period
Include Cancelled - Yes, this allows for cancellation
feeds to be included, if charged
The above example shows 'Invoice Line Category'
(Tuition/Accommodation etc) and Nominal and the Price Item Name (Course).
At year ends, the student ID/name or invoice
number may be added to provide a much more detailed report for audit
purposes.
Leave the start date unchanged, but set the end date to
the period eg. 31 January 2013.
This will ensure
invoices/credits raised after 31/01/13 are not included in the calculation.
Each category (Tuition/Accommodation/Transfers/Sundry)
can be run separately, but by including the invoice line category in "Sorting",
one report will suffice for all categories.
Packages - Include
Include Type - All
Include Invoices - Only select
invoiced. Proformas should not be included, although if invoicing had not been
run for week, a separate run for proformas would have provided figures for
"Sales not yet invoiced".
Value
Used - Agent Net (Gross-Discount). This is the amount transferred to debtors
and should be used for deferred sales.
A journal can then be created - Credit Sales, Debit,
Discounts/Commissions.
In the above example, all income from column
01/02/13 onwards is forward income ie. deferred income as at 31/01/13.
Country by Territory Totals (with Sub-Totals by
Territory)
The key values Class will only
accurately report on is:
Other values:
Student Counts and Enrolment Counts
These variables can be misleading and confusing
depending on how Class is operated.
Results can vary
depending on time ranges, selection criteria, and the impact of
cancellations.
For this reason, these 2 values are not
recommended for statistical reporting.
Student Count
We acknowledge that there is a general interest in
"how many students" (defined as the number of unique student ID's in the period
being reported on).
The only place where student counts
should be used is the "Agent Stats" tab and the "All School Stats".
Enrolment Counts
If required, can be obtained from the "Statistics
Generator" (Enrolment Bookings).
Other place where "counts", "numbers" etc are indicated are
purely computer counts and may
not necessarily reconcile with any other figures.
Copyright 2013
Infospeed Limited