OpenCart - Advance PDF Invoice - Free Printable

The image you've uploaded is an invoice (INV-2020-002) from a store using OpenCart, and it includes details about the order, shipping, payment, and product information. Let's analyze and solve any potential problem or task associated with this invoice.

Invoice Summary

Order Details:
- Order ID: 27
- Date Added: 02/09/2021
- Invoice No.: INV-2020-002
- Payment Method: Bank Transfer
- Shipping Method: Flat Shipping Rate

Customer Information:
- Name: Demo demo
- Address: test, rtpfg 65656, Gail, Israel
- Email: [email protected]
- Phone: 9876543210

Products Ordered:
| Product | Model | Manufacturer | SKU | Quantity | Unit Price | Total |
|---------|-------------|--------------|----------|----------|------------|---------|
| iPhone | product 11 | Apple | IPHONE11 | 1 | $101.00 | $101.00 |
| MacBook | Product 16 | Apple | | 1 | $500.00 | $500.00 |

Totals:
- Sub-Total: $601.00
- Flat Shipping Rate: $5.00
- 10% discount on Flat Shipping: -$0.50 (i.e., $5.00 × 10% = $0.50)
- Store Credit: -$10.00
- Total: $535.40

---

Task / Problem to Solve

Although no explicit question was asked in your message, based on the context of invoices, common tasks include:

1. Verifying the correctness of the total amount.
2. Calculating discounts or adjustments.
3. Identifying errors or discrepancies.
4. Understanding how the final total was derived.

Let’s go through the calculation verification step-by-step.

---

Step-by-Step Calculation Verification

#### Step 1: Sub-Total
- iPhone: $101.00
- MacBook: $500.00
→ Sub-Total = $101.00 + $500.00 = $601.00 ✔

#### Step 2: Shipping Cost
- Flat Shipping Rate = $5.00

#### Step 3: Discount on Shipping
- 10% discount on flat shipping:
→ 10% of $5.00 = $0.50
- So, adjusted shipping cost = $5.00 - $0.50 = $4.50

#### Step 4: Store Credit
- Store Credit = -$10.00

#### Step 5: Final Total
Now calculate:
```
Sub-Total: $601.00
+ Shipping: $4.50
- Store Credit: -$10.00
---------------------------
Total: $595.50
```

Wait — this does not match the stated total of $535.40.

There is a discrepancy.

Let’s recheck the numbers carefully.

Wait! The total shown is $535.40, but our calculation gives $595.50.

Let’s check the invoice again:

- Sub-Total: $601.00
- Flat Shipping: $5.00
- 10% discount on shipping: $0.50 → so net shipping = $4.50
- Store Credit: -$10.00

So:
```
$601.00 (sub)
+ $4.50 (shipping after discount)
= $605.50
- $10.00 (store credit)
= $595.50
```

But the invoice shows $535.40, which is $60.10 less than expected.

This suggests either:
1. A typo in the invoice.
2. An error in the display.
3. Additional discount not shown.

Alternatively, let’s look at the "Total" line: $535.40

We can reverse-engineer what happened.

Let’s suppose the final total is $535.40.

Then:
```
Sub-Total: $601.00
Shipping: $5.00
Discount on shipping: $0.50
Store credit: -$10.00
Total: $601 + $5 - $0.50 - $10 = $595.50
```

Still doesn't add up.

Wait — perhaps the discount is applied differently?

Maybe the 10% discount is on the entire order?

Let’s try that.

Suppose 10% discount on sub-total ($601.00):
→ $601 × 0.10 = $60.10 discount

Then:
- Sub-Total: $601.00
- Less 10% discount: -$60.10 → $540.90
- Shipping: $5.00
- Store Credit: -$10.00

Total = $540.90 + $5.00 - $10.00 = $535.90

Close to $535.40 — still off by $0.50.

Wait — if the 10% discount is only on shipping, then we already accounted for that.

But maybe the store credit is applied before shipping?

Alternatively, perhaps there is a typo in the invoice.

But here's a key observation:

The invoice says "10% discount on Flat Shipping", which is $5.00 → $0.50 discount.

And Store Credit: $10.00

So:
- Sub-Total: $601.00
- Shipping: $5.00
- Discount on shipping: -$0.50 → net shipping: $4.50
- Store Credit: -$10.00

Total = $601.00 + $4.50 - $10.00 = $595.50

But the invoice shows $535.40

That’s a difference of $60.10

Notice: $601.00 - $535.40 = $65.60

Hmm.

Wait — what if the 10% discount is applied to the subtotal?

Try:
- Sub-Total: $601.00
- 10% discount: $60.10 → $540.90
- Shipping: $5.00
- Store Credit: -$10.00

Total = $540.90 + $5.00 - $10.00 = $535.90

Still not $535.40

Difference: $0.50

Now consider: If the 10% discount is on the shipping AND the store credit is $10.00, and the subtotal is correct, then the total should be $595.50.

But it’s not.

Another possibility: The $10.00 store credit is applied to the shipping?

But that doesn’t make sense.

Wait — perhaps the "10% discount on Flat Shipping" means they charge $5.00, then apply 10% off → $4.50, and then store credit $10.00 is applied to the total.

But still, total would be $601 + $4.50 - $10 = $595.50

Not $535.40

Unless...

What if the sub-total is wrong?

No, $101 + $500 = $601.00 — correct.

Wait — look at the "Total" line: $535.40

And the "Store Credit" is $10.00

So:
$535.40 + $10.00 = $545.40

Then subtract shipping:
$545.40 - $5.00 = $540.40

Then add back the $0.50 shipping discount:
$540.40 + $0.50 = $540.90

So the pre-credit subtotal is $540.90

Which implies a discount of $60.10 on the original $601.00

So 10% of $601.00 = $60.10

Therefore, the 10% discount must have been applied to the subtotal, not just shipping.

But the invoice says: "10% discount on Flat Shipping Rate"

That’s misleading.

It should say "10% discount on Sub-Total" or something similar.

So likely, there is a labeling error in the invoice.

✔ Conclusion

Problem: The invoice shows a final total of $535.40, but based on the listed values, the correct total should be $595.50.

Discrepancy: $595.50 vs $535.40 → difference of $60.10

Likely Cause: The "10% discount on Flat Shipping" label is incorrect. It appears that a 10% discount was applied to the subtotal ($601.00 × 10% = $60.10), reducing it to $540.90, then shipping $5.00, then store credit $10.00 → $535.90, but due to rounding or another adjustment, it shows $535.40.

Wait — $540.90 + $5.00 = $545.90 - $10.00 = $535.90

But invoice says $535.40 → off by $0.50

Perhaps the shipping discount is $0.50, so net shipping $4.50, and store credit $10.00

But if subtotal is $601.00, and no discount on subtotal, then total should be $595.50

But it's $535.40

Only way to get $535.40 is:

- Subtotal: $601.00
- Discount: $65.60 → 10.9% discount

But that doesn't align with 10%.

Alternatively, perhaps the store credit is $10.00 and the shipping discount is $5.00, meaning full shipping free?

But it says "10% discount on flat shipping", not "free".

Most Plausible Explanation:

There is a labeling error in the invoice.

The "10% discount on Flat Shipping" should actually be "10% discount on Sub-Total", or there is a hidden discount.

But given the numbers:

- $601.00 (subtotal)
- $5.00 (shipping)
- $0.50 discount on shipping → net shipping $4.50
- $10.00 store credit
- Total: $601 + $4.50 - $10 = $595.50

But invoice says $535.40

So unless the subtotal is wrong, or another discount exists, the invoice has an error.

Wait — double-check the product prices:

- iPhone: $101.00
- MacBook: $500.00

Sum: $601.00 — correct.

So the only explanation is that the total is incorrectly calculated.

✔ Final Answer:

The invoice contains an error in the total calculation.

Based on the provided data:
- Subtotal: $601.00
- Shipping: $5.00
- 10% discount on shipping: $0.50 → net shipping: $4.50
- Store Credit: $10.00

Correct Total = $601.00 + $4.50 - $10.00 = $595.50

However, the invoice shows $535.40, which is $60.10 less.

This discrepancy suggests that either:
- A 10% discount was applied to the subtotal (which is not labeled correctly), or
- There is a data entry error in the invoice.

Recommendation: Verify with the seller whether the 10% discount applies to the subtotal, or if there is a mistake in the total.

If the 10% discount is only on shipping, then the correct total should be $595.50, not $535.40.

---

Let me know if you'd like help generating a corrected version of the invoice.