GST Bill Format & GST Invoice Maker | GST Bill Online | Refrens - Free Printable
Educational worksheet: GST Bill Format & GST Invoice Maker | GST Bill Online | Refrens. Download and print for classroom or home learning activities.
WEBP
2049×2686
202 KB
Free · Personal Use
Quality Assured by Worksheets Library Team
Reviewed for educational accuracy and age-appropriateness
ID: #1943311
⭐
Show Answer Key & Explanations
Step-by-step solution for: GST Bill Format & GST Invoice Maker | GST Bill Online | Refrens
▼
Show Answer Key & Explanations
Step-by-step solution for: GST Bill Format & GST Invoice Maker | GST Bill Online | Refrens
The image you've uploaded is an invoice from Foobar Labs to Donald Clinton. The task appears to be analyzing or verifying the correctness of the invoice, particularly focusing on the total due amount and ensuring all calculations are accurate.
Let’s break it down step by step and verify whether the Total Due Amount of $12,000 is correct based on the provided details.
---
#### 1. Printing Circuit Board
- Quantity: 50
- Unit Price: $100
- Subtotal: 50 × $100 = $5,000
- Tax Rate: 10%
- Tax Amount: 10% of $5,000 = $500
- Total Amount: $5,000 + $500 = $5,500 ✔ (Matches)
#### 2. Laser Printer
- Quantity: 2
- Unit Price: $350
- Subtotal: 2 × $350 = $700
- Tax Rate: 10%
- Tax Amount: 10% of $700 = $70
- But the invoice shows $60 tax → ✘ Inconsistency!
Wait — this is a problem.
> The tax should be:
> - 10% of $700 = $70, not $60.
>
> So the Tax Amount for Laser Printer is incorrect.
But let's check the Total Amount listed: $660
That implies:
- $660 – $60 (tax) = $600 (pre-tax amount)
- But we have 2 units at $350 = $700
So there's a mismatch in the unit price or quantity?
Wait — the unit price is $350, quantity is 2 → $700 subtotal
Then tax at 10% = $70 → total = $770
But the invoice says:
- Total Amount: $660
- Tax Amount: $60
- So pre-tax = $600
This suggests that either:
- The unit price is wrong, or
- The quantity is wrong, or
- There’s a typo in the invoice
But the unit price is listed as $350, and quantity is 2 → must be $700 before tax.
So if tax is $60, then:
- Pre-tax = $600
- That would mean unit price = $300 (not $350), or quantity = 1.71… which doesn’t make sense.
So there is an error in the invoice.
Let’s assume the unit price is correct ($350) and quantity is 2, so:
> Correct subtotal: $700
> Correct tax (10%): $70
> Correct total: $770
But the invoice shows $660 total → $110 short
---
| Item | Amount |
|------|--------|
| Amount (before tax & shipping) | $5,600 |
| TAX | $560 |
| Shipping Cost | $140 |
| Total Due | $12,000 |
Let’s reverse-engineer:
- $5,600 (line item totals)
- $560 (tax)
- $140 (shipping)
- Total = $5,600 + $560 + $140 = $6,300
But the Total Due is shown as $12,000, which is way higher.
So something is clearly wrong here.
---
From the table:
- Printing Circuit Board: $5,500
- Laser Printer: $660
- Sum of line items = $5,500 + $660 = $6,160
But the summary says "Amount" = $5,600 → ✘ mismatch
Wait — $5,600 vs $6,160 — big discrepancy.
Let’s recompute:
- Printing: $5,500 ✔
- Laser Printer: $660 ✔
Sum = $5,500 + $660 = $6,160
But summary says "Amount" = $5,600 → off by $560
Also, the TAX is listed as $560 → which is exactly the difference.
And Shipping Cost = $140
So:
- $5,600 (amount) + $560 (tax) + $140 (shipping) = $6,300
But Total Due = $12,000 → still off by $5,700
---
There are multiple inconsistencies:
1. Line Item Total Mismatch
- Printing: $5,500 ✔
- Laser Printer: Should be $700 + $70 = $770, but listed as $660 → understated by $110
- But even with $660, sum = $6,160
- Summary says "Amount" = $5,600 → $560 less than actual line item sum
2. Tax Calculation
- Printing: $500 tax ✔
- Laser Printer: $60 tax → should be $70 → understated by $10
- Total tax should be $500 + $70 = $570, but shown as $560 → off by $10
3. Summary Box
- "Amount" = $5,600 (but actual line item total is $6,160)
- "TAX" = $560 (should be $570)
- "Shipping" = $140 ✔
- Total = $5,600 + $560 + $140 = $6,300
- But Total Due = $12,000 → $5,700 more
---
The only way the total could be $12,000 is if:
- The line item totals were misread or duplicated
- Or there is a hidden cost not listed
But looking at the invoice:
- The only two items are:
- Printing Circuit Board: $5,500
- Laser Printer: $660
- Total: $6,160
- Tax: $560
- Shipping: $140
- Grand Total: $6,160 + $560 + $140 = $6,860
But the Total Due Amount is $12,000, which is twice $6,000 — close to $6,160.
Wait — what if the "Amount" in the summary box is meant to be before tax and shipping, but it’s wrongly written as $5,600 instead of $6,160?
Let’s suppose:
- Correct line item total = $6,160
- Tax = $560 (but should be $570)
- Shipping = $140
- Total = $6,160 + $560 + $140 = $6,860
Still far from $12,000.
Unless...
It says:
> "Six Thousand Three Hundred Dollars Only"
But $6,300 ≠ $12,000
So the written amount is $6,300, but the boxed total is $12,000
This is a major inconsistency.
---
Here are the problems:
| Issue | Description |
|------|-------------|
| 1. Line Item Mismatch | The sum of line items is $6,160, but the summary says "$5,600" — off by $560 |
| 2. Tax Error | Laser printer tax should be $70 (10% of $700), not $60 |
| 3. Total Due Mismatch | The calculated total is ~$6,860, but it shows $12,000 |
| 4. Written Total vs Boxed Total | "Six Thousand Three Hundred Dollars" vs "$12,000" — contradiction |
---
Let’s recalculate correctly:
#### 1. Printing Circuit Board
- Qty: 50
- Unit Price: $100
- Subtotal: 50 × $100 = $5,000
- Tax (10%): $500
- Total: $5,500 ✔
#### 2. Laser Printer
- Qty: 2
- Unit Price: $350
- Subtotal: 2 × $350 = $700
- Tax (10%): $70
- Total: $770 ✘ (but invoice says $660)
So unless the unit price is actually $330, the laser printer total is wrong.
But the invoice says $350 → so likely a data entry error.
Assume unit price is $330:
- 2 × $330 = $660
- Tax: 10% × $660 = $66 → but invoice says $60 → still off
No — $60 tax → pre-tax = $600 → unit price = $300
So maybe the unit price is $300, not $350?
But it’s clearly written as $350.
So either:
- The unit price is wrong, or
- The tax rate is wrong, or
- The quantity is wrong
But the most likely issue is a typo in the Total Amount for the laser printer.
Let’s suppose the unit price is $330, then:
- 2 × $330 = $660
- Tax: 10% × $660 = $66 → but shown as $60 → still off
Alternatively, maybe tax rate is not applied consistently?
But no — both items have 10% tax.
---
#### ✔ Corrected Total Should Be:
| Item | Amount |
|------|--------|
| Printing Circuit Board | $5,500 |
| Laser Printer | $770 |
| Subtotal | $6,270 |
| Tax | $570 |
| Shipping | $140 |
| Total Due | $6,980 |
But the invoice says $12,000, which is incorrect.
Additionally, the written amount ("Six Thousand Three Hundred Dollars") is also incorrect.
---
The invoice has critical errors in:
- Line item totals
- Tax calculation
- Final total
You should contact Foobar Labs to correct the invoice before payment.
---
1. Laser Printer Unit Price/Quantity/Tax Error: $350 × 2 = $700 → tax $70 → total $770, not $660
2. Line Item Sum: $5,500 + $660 = $6,160, but summary says $5,600
3. Tax Total: Should be $570, not $560
4. Total Due: Should be ~$6,980, not $12,000
5. Written Amount: "Six Thousand Three Hundred" ≠ $12,000
---
Let me know if you'd like a revised version of the invoice.
Let’s break it down step by step and verify whether the Total Due Amount of $12,000 is correct based on the provided details.
---
🔍 Step 1: Review the Line Items
#### 1. Printing Circuit Board
- Quantity: 50
- Unit Price: $100
- Subtotal: 50 × $100 = $5,000
- Tax Rate: 10%
- Tax Amount: 10% of $5,000 = $500
- Total Amount: $5,000 + $500 = $5,500 ✔ (Matches)
#### 2. Laser Printer
- Quantity: 2
- Unit Price: $350
- Subtotal: 2 × $350 = $700
- Tax Rate: 10%
- Tax Amount: 10% of $700 = $70
- But the invoice shows $60 tax → ✘ Inconsistency!
Wait — this is a problem.
> The tax should be:
> - 10% of $700 = $70, not $60.
>
> So the Tax Amount for Laser Printer is incorrect.
But let's check the Total Amount listed: $660
That implies:
- $660 – $60 (tax) = $600 (pre-tax amount)
- But we have 2 units at $350 = $700
So there's a mismatch in the unit price or quantity?
Wait — the unit price is $350, quantity is 2 → $700 subtotal
Then tax at 10% = $70 → total = $770
But the invoice says:
- Total Amount: $660
- Tax Amount: $60
- So pre-tax = $600
This suggests that either:
- The unit price is wrong, or
- The quantity is wrong, or
- There’s a typo in the invoice
But the unit price is listed as $350, and quantity is 2 → must be $700 before tax.
So if tax is $60, then:
- Pre-tax = $600
- That would mean unit price = $300 (not $350), or quantity = 1.71… which doesn’t make sense.
So there is an error in the invoice.
Let’s assume the unit price is correct ($350) and quantity is 2, so:
> Correct subtotal: $700
> Correct tax (10%): $70
> Correct total: $770
But the invoice shows $660 total → $110 short
---
🔍 Step 2: Check the Summary Table
| Item | Amount |
|------|--------|
| Amount (before tax & shipping) | $5,600 |
| TAX | $560 |
| Shipping Cost | $140 |
| Total Due | $12,000 |
Let’s reverse-engineer:
- $5,600 (line item totals)
- $560 (tax)
- $140 (shipping)
- Total = $5,600 + $560 + $140 = $6,300
But the Total Due is shown as $12,000, which is way higher.
So something is clearly wrong here.
---
🔍 Step 3: Recheck the Line Item Total Amounts
From the table:
- Printing Circuit Board: $5,500
- Laser Printer: $660
- Sum of line items = $5,500 + $660 = $6,160
But the summary says "Amount" = $5,600 → ✘ mismatch
Wait — $5,600 vs $6,160 — big discrepancy.
Let’s recompute:
- Printing: $5,500 ✔
- Laser Printer: $660 ✔
Sum = $5,500 + $660 = $6,160
But summary says "Amount" = $5,600 → off by $560
Also, the TAX is listed as $560 → which is exactly the difference.
And Shipping Cost = $140
So:
- $5,600 (amount) + $560 (tax) + $140 (shipping) = $6,300
But Total Due = $12,000 → still off by $5,700
---
🔍 Step 4: Identify the Error
There are multiple inconsistencies:
1. Line Item Total Mismatch
- Printing: $5,500 ✔
- Laser Printer: Should be $700 + $70 = $770, but listed as $660 → understated by $110
- But even with $660, sum = $6,160
- Summary says "Amount" = $5,600 → $560 less than actual line item sum
2. Tax Calculation
- Printing: $500 tax ✔
- Laser Printer: $60 tax → should be $70 → understated by $10
- Total tax should be $500 + $70 = $570, but shown as $560 → off by $10
3. Summary Box
- "Amount" = $5,600 (but actual line item total is $6,160)
- "TAX" = $560 (should be $570)
- "Shipping" = $140 ✔
- Total = $5,600 + $560 + $140 = $6,300
- But Total Due = $12,000 → $5,700 more
---
🔍 Step 5: Possible Explanation
The only way the total could be $12,000 is if:
- The line item totals were misread or duplicated
- Or there is a hidden cost not listed
But looking at the invoice:
- The only two items are:
- Printing Circuit Board: $5,500
- Laser Printer: $660
- Total: $6,160
- Tax: $560
- Shipping: $140
- Grand Total: $6,160 + $560 + $140 = $6,860
But the Total Due Amount is $12,000, which is twice $6,000 — close to $6,160.
Wait — what if the "Amount" in the summary box is meant to be before tax and shipping, but it’s wrongly written as $5,600 instead of $6,160?
Let’s suppose:
- Correct line item total = $6,160
- Tax = $560 (but should be $570)
- Shipping = $140
- Total = $6,160 + $560 + $140 = $6,860
Still far from $12,000.
Unless...
🚨 Key Observation: Invoice Total In Words
It says:
> "Six Thousand Three Hundred Dollars Only"
But $6,300 ≠ $12,000
So the written amount is $6,300, but the boxed total is $12,000
This is a major inconsistency.
---
✔ Conclusion: The Invoice Has Errors
Here are the problems:
| Issue | Description |
|------|-------------|
| 1. Line Item Mismatch | The sum of line items is $6,160, but the summary says "$5,600" — off by $560 |
| 2. Tax Error | Laser printer tax should be $70 (10% of $700), not $60 |
| 3. Total Due Mismatch | The calculated total is ~$6,860, but it shows $12,000 |
| 4. Written Total vs Boxed Total | "Six Thousand Three Hundred Dollars" vs "$12,000" — contradiction |
---
🔧 Corrected Calculation
Let’s recalculate correctly:
#### 1. Printing Circuit Board
- Qty: 50
- Unit Price: $100
- Subtotal: 50 × $100 = $5,000
- Tax (10%): $500
- Total: $5,500 ✔
#### 2. Laser Printer
- Qty: 2
- Unit Price: $350
- Subtotal: 2 × $350 = $700
- Tax (10%): $70
- Total: $770 ✘ (but invoice says $660)
So unless the unit price is actually $330, the laser printer total is wrong.
But the invoice says $350 → so likely a data entry error.
Assume unit price is $330:
- 2 × $330 = $660
- Tax: 10% × $660 = $66 → but invoice says $60 → still off
No — $60 tax → pre-tax = $600 → unit price = $300
So maybe the unit price is $300, not $350?
But it’s clearly written as $350.
So either:
- The unit price is wrong, or
- The tax rate is wrong, or
- The quantity is wrong
But the most likely issue is a typo in the Total Amount for the laser printer.
Let’s suppose the unit price is $330, then:
- 2 × $330 = $660
- Tax: 10% × $660 = $66 → but shown as $60 → still off
Alternatively, maybe tax rate is not applied consistently?
But no — both items have 10% tax.
---
💡 Final Answer: The Invoice Contains Errors
#### ✔ Corrected Total Should Be:
| Item | Amount |
|------|--------|
| Printing Circuit Board | $5,500 |
| Laser Printer | $770 |
| Subtotal | $6,270 |
| Tax | $570 |
| Shipping | $140 |
| Total Due | $6,980 |
But the invoice says $12,000, which is incorrect.
Additionally, the written amount ("Six Thousand Three Hundred Dollars") is also incorrect.
---
✔ Recommendation
The invoice has critical errors in:
- Line item totals
- Tax calculation
- Final total
You should contact Foobar Labs to correct the invoice before payment.
---
📝 Summary of Issues
1. Laser Printer Unit Price/Quantity/Tax Error: $350 × 2 = $700 → tax $70 → total $770, not $660
2. Line Item Sum: $5,500 + $660 = $6,160, but summary says $5,600
3. Tax Total: Should be $570, not $560
4. Total Due: Should be ~$6,980, not $12,000
5. Written Amount: "Six Thousand Three Hundred" ≠ $12,000
---
✔ Final Verdict: The invoice is incorrect. Do not pay $12,000. Request a corrected invoice.
Let me know if you'd like a revised version of the invoice.
Parent Tip: Review the logic above to help your child master the concept of printable invoice with gst template.