Automated Prepaid Expenses JV in Excel



Hello All,

Attached is a file which contains the automated prepaid calculation. No Hassles of working out how much is accrued, how much is pending, etc. Just Update the table in the first sheet. And rest will happen automatically. Of course, you are free to open the hood and check out how it works.

Step:1- Go the last row of the blue table and add a serial number 5, which will automatically extend the table. Fill up other fields as well. All fields are mandatory. Once you complete your entry, make sure that the Checkpoint column (H column is ZERO). If it’s not, there is some error in the input.

Step:2- Go the next tab – “Journal Entry”

Change the date in D2 cell. Make sure it’s the first day of the month only. Refresh the Pivot and you will have the JV ready. Classified by Type of Expenses and by Cost Center.

Under the hood:-

Unhide the columns from “I” onwards and you will see a range of formulas- date, sumifs, min, max, etc. You are free to meddle with it.  wink

File is below:

/editor_upload/162174689prepaid calculation.xlsx


Daily Limit Reached

You have reached your daily limit of 2 Free Articles

Subscribe to CCI PRO for unlimited access

Why Upgrade to CCI PRO?
  • No Ads
  • WhatsApp Community
  • Daily E-Newsletter
  • Unlimited Articles Access
  • Profile Visitors
  • Link Social Profiles
  • Featured Job Posts
  • Pro Badge
  • Expert GST Guidance
  • Unlimited Forum Replies
  • Download Content in PDF
1 Year PLAN
1999
(Excl. of GST ₹359)

2 Years PLAN
3499
(Excl. of GST ₹629)

BEST VALUE
3 Years PLAN
4999
(Excl. of GST ₹899)

View all CCI PRO benefits

Already a PRO member? Login here for an ad-free experience. 07941056694


35109 Views 1 Likes Comment   Share Technology & Tools   Report


About the Author

Chartered Accountant

Comments :

Related Articles


Loading


Popular Articles





CCI Pro

CCI Articles

submit article


Company
10 November 2026
FP&A Executive

Gujarat Guardian

Ankleshwar

CA Final

View Details
Company
ARTICLESHIP 16 November 2026
Audit Executives

Loonker Godawat And Company

Bengaluru

B.Com

View Details
Company
14 November 2026
Manager - Indirect Tax (GST)

Westbridge Consulting LLP

New Delhi

CA

View Details
Company
Featured ARTICLESHIP 31 October 2026
CA Articleship

apricus india

Navi Mumbai

CA Inter

View Details
Company
12 November 2026
Tax Product Specialist

BharatX.ai

Gurgaon

B.Com

View Details
Company
16 November 2026
Assistant Article

ZAK & Co. Chartered Accountants

Bengaluru

CA Inter

View Details
Company
10 November 2026
Direct Tax Manager

CAAQ CONSULTANCY PVT LTD

New Delhi

CA Final

View Details
Company
ARTICLESHIP 22 October 2026
Articleship intern

Srinath Manikanta

Hyderabad

CA Inter

View Details