Business Cases - Vendor Prepayment Issues

Business Cases

These are common real-life situations where users face issues with Vendor Prepayment and how this article helps resolve them.

---

1. “My Balance Sheet is correct, but Vendor Prepayment doesn’t match”

What happens

You fix a Vendor Prepayment difference using a Journal Entry.

Everything looks fine in:

• Balance Sheet ✅

• Trial Balance ✅

But:

• Vendor Prepayment Centre still shows old numbers ❌

---

Why this is confusing

You expect everything to match—but only one report is correct.

---

What this article helps you understand

• Vendor Prepayment cannot be adjusted using Journal Entries

• It is linked to vendor-level transactions

---

What you should do instead

• Use a placeholder account if it’s an overall adjustment

• Or use vendor transactions if it’s vendor-specific

---

---

2. “I adjusted prepayment, but vendor balances are still wrong”

What happens

You reduce Vendor Prepayment using a Journal Entry.

But:

• Vendor still shows incorrect balance

• Reports don’t align

---

Why this happens

Journal Entry updates only accounting numbers, not vendor-level data.

---

What this article helps you do

• Identify that the issue is caused by incorrect adjustment method

• Correct it using proper vendor transactions

---

Correct way

• Create a bill and apply prepayment

• Or create a new prepayment if needed

---

---

3. “Reports and exports don’t match”

What happens

• System reports show one number

• Excel export shows another

• Vendor Prepayment Centre shows something else

---

Why this happens

Vendor Prepayment was adjusted directly through Journal Entry.

---

What this article helps you understand

• Why different reports are showing different values

• Where the mismatch is coming from

---

How to fix

• Stop using Vendor Prepayment in Journal Entries

• Use:

  • Placeholder accounts

  • Vendor transactions

---

4. “I just wanted to quickly fix the balance”

What happens

You try to fix a small difference quickly using a Journal Entry.

It works initially.

Later:

• Reports stop matching

• Vendor balances look incorrect

---

Why this happens

Quick fixes ignore how the system actually tracks Vendor Prepayment.

---

What this article helps you do

• Avoid incorrect shortcuts

• Use the correct process from the start

---

Correct approach

• Always check:

  • Is this vendor-specific?

  • Or overall adjustment?

Then:

• Use the appropriate method

---

---

5. “Audit or review is showing mismatches”

What happens

During audit or internal review:

• Vendor Prepayment totals don’t match financial reports

---

Why this happens

Vendor Prepayment was adjusted through Journal Entries earlier.

---

What this article helps you do

• Identify the exact cause of mismatch

• Correct the balances properly

---

Correct approach

• Reverse incorrect entries (if needed)

• Recreate adjustments using:

  • Vendor transactions

  • Placeholder accounts

---

---

Simple Rule to Remember

👉 Never use Vendor Prepayment account in Journal Entries

---

Instead:

• For overall adjustment → Use Placeholder Account + JE

• For vendor-specific adjustment → Use Vendor Transactions

---

What This Solves for You

• Reports start matching

• Vendor balances become accurate

• No confusion between screens

• Less time spent on reconciliation

---

If Vendor Prepayment is involved, always use transactions—not Journal Entries.