+ Reply to Thread
Results 1 to 5 of 5

Calculating GST and Checking that the GST is correct

  1. #1
    Registered User
    Join Date
    11-05-2012
    Location
    Chinchilla, QLD
    MS-Off Ver
    Excel 2010
    Posts
    3

    Question Calculating GST and Checking that the GST is correct

    Hey,
    I'm stuck on a part of my assessment and the book does not really help me, I need to know how I calculate GST on to the sales so its inclusive (being 10% GST as stated in the book), and also once I've got that figure how do I 'check to ensure that the GST is correct below the data area'.
    Attached Files Attached Files

  2. #2
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: Calculating GST and Checking that the GST is correct

    just some confirmation, GST applies to total sales? or sales after Commission is deducted?
    A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
    -Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
    -To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
    If you received helpful response, please remember to hit the * of that post

  3. #3
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: Calculating GST and Checking that the GST is correct

    okayi I tried this, but not sure it is exactly what you are looking for..

    as to the GST check, i just guessed as to what you wanted as check reference
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    11-05-2012
    Location
    Chinchilla, QLD
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Calculating GST and Checking that the GST is correct

    No thats exactly what I was wanting. Thanks heaps

  5. #5
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: Calculating GST and Checking that the GST is correct

    no problem!
    Please remember to mark your thread "Solved" (go to top off page, hit thread tools and mark as solved )

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1