You have been asked by your supervisor to develop a central team document for calculating GST paid
Fantastic news! We've Found the answer you've been seeking!
Question:
- You have been asked by your supervisor to develop a central team document for calculating GST paid from goods purchased in the quarter 1 Jul - 30 Sep from the listed invoice amounts.
- In an Excel worksheet calculate the GST paid in each of the following transactions and the total to be paid for the quarter
- Use formulas to calculate your answers
- In your answers show your calculations.
Invoice Number | Goods purchased inclusive of GST | GST paid |
#16576 | $1245.00 | |
#87679 | $2562.00 | |
#32345 | $1691.00 | |
#54762 | $1573.00 | |
#37686 | $1780.00 | |
#78680 | $2639.00 | |
#45657 | $956.00 | |
#98972 | $834.00 | |
TOTAL | $13280.00 |
Related Book For
Intermediate Accounting
ISBN: 978-0077400163
6th edition
Authors: J. David Spiceland, James Sepe, Mark Nelson
Posted Date: