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


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
ARTICLESHIP 23 October 2026
CA Articleship / Article Assistant

M N Rao & Associates LLP

Vijayawada

CA Inter

View Details
Company
Featured ARTICLESHIP 18 November 2026
Articles

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Foundation

View Details
Company
12 November 2026
Tax Product Specialist

BharatX.ai

Gurgaon

B.Com

View Details
Company
ARTICLESHIP 16 November 2026
Audit Executives

Loonker Godawat And Company

Bengaluru

B.Com

View Details
Company
ARTICLESHIP 18 November 2026
Articled Assistant

A.Singhi & Co

Kolkata

CA Inter

View Details
Company
ARTICLESHIP 17 November 2026
Vacancy for Articleship

Promptitude Accounting Services Private limited

Bengaluru

B.Com

View Details
Company
Featured 27 October 2026
semi-qualified CA

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Final

View Details
Company
30 October 2026
Asst Manager Accounts

Goodwin Pumps India Pvt Ltd

Chengalpattu

CA Inter

View Details