[Year 12 IT Apps] formats in a spreadsheet - subtotals

[Clare, Ian J]

Maggie

As a practising accountant before I entered teaching last year I would
agree with Geoff that Potts I correct however I would disagree with
Potts regarding Grand Totals they should have a single line above and a
double line under.

Ian Clare
Information Technology Teacher
Casterton Secondary College
Ph   03 5581 1588 Fax 03 5581 1518
clare.ian.j at edumail.vic.gov.au

-----Original Message-----
From: geoffmoss37 at optusnet.com.au [mailto:geoffmoss37 at optusnet.com.au] 
Sent: Wednesday, 30 May 2007 2:34 PM
To: Year 12 IT Applications Teachers' Mailing List
Subject: Re: [Year 12 IT Apps] formats in a spreadsheet - subtotals

Hi Maggie

It's a while since I taught accounting but I thought the convention
stated in the text is correct, though it can be interpreted differently
according to where the sub-total is displayed.

If in the same column than a line above the subtotal IMHO is correct,
particularly when adding further data from the same column.  See example
1 in attachment.

If the sub-total is in an adjacent column the line is below the column
of data - see example 2 in the attachment.

I have noted anything different in financial reports I have received
from companies.

As stated, it is quite a while (last century!!) since I last taught
accounting and I am not aware of any changes.

Geoff Moss
RMIT





> Maggie Iaquinto <IAQUIM at bialik.vic.edu.au> wrote:
> 
> The Potts and Keane book state that a spreadsheet convention for
> subtotals is a single line above the subtotal.
> 
>  
> 
> Our Accounting teachers have stated this is not the case, but rather a
> single line below is the accepted convention.
> 
>  
> 
> Can anyone comment further on this issue?
> 
>  
> 
> Maggie
> 
> **********************************************************************
> Disclaimer: This email is intended for the use of the named
> individual or entity and may contain confidential and privileged
> information. Any dissemination, distribution or copying by anyone
> other than the intended recipient of this email is strictly
> prohibited. Attachments are opened and transmitted at the user's own
> risk. Any representations or opinions expressed are those of the
> individual sender, and not necessarily those of Bialik College.
> **********************************************************************


Important - This email and any attachments may be confidential. If received=
 in error, please contact us and delete all copies. Before opening or using=
 attachments check them for viruses and defects. Regardless of any loss, dam=
age or consequence, whether caused by the negligence of the sender or not, r=
esulting directly or indirectly from the use of any attached files our liabi=
lity is limited to resupplying any affected attachments. Any representations=
 or opinions expressed are those of the individual sender, and not necessari=
ly those of the Department of Education.