Prepaid AMC Calculation Sheet

With Automatic Expense Split & Journal Entry Format

Struggling to calculate prepaid expenses correctly at year end?

This ready-to-use Prepaid Expense / AMC Calculation Excel Template helps you automatically split expenses between:

✔ Current Financial Year Expense

✔ Prepaid Expense (Next Year Portion)

✔ Proper Journal Entry Format

✔ Payment Entry Format

✔ Next Year Adjustment Entry

Designed specially for Accountants, CA Firms, and Finance Professionals.

✅ What This Template Does

Enter:

1. Invoice Date
2. Amount
3. Start Date
4. End Date
5. Financial Year

The template automatically calculates:

✔ Total Number of Days

✔ Current Year Expense Portion

✔ Prepaid Expense Portion

✔ Exact Journal Entries

✔ Next Year Adjustment Entry

No manual calculation required.

📌 Why This Template Is Valuable

Most accountants:

❌ Calculate prepaid expense manually

❌ Make mistakes in day calculation

❌ Waste time preparing journal entries

❌ Forget next year reversal entry

This template solves everything in one place.

💼 Key Features

🔹 Financial Year Control

🔹 Automatic Day Calculation

🔹 Auto Expense Allocation

🔹 Ready-Made Journal Entry Format

🔹 Payment Entry Format

🔹 Next Year Reversal Entry

🔹 Clean & Professional Layout

🔹 Modify Only Required Cells

Perfect for:

1. AMC Contracts
2. Insurance Premium
3. Rent Advance
4. Annual Software Subscription
5. Service Contracts

📦 What You Will Receive

1. Editable Excel Template
2. Built-in Calculation Formula
3. Journal Entry Format
4. Sample Working Example
5. Print-Friendly Layout
6. Lifetime Use

🎯 Ideal For

1. CA Articles
2. Chartered Accountants
3. Tax Consultants
4. Audit Firms
5. Corporate Accounts Team
6. Tally Users who need working papers