Deferred Expense Calculation Schedule

ERPNext Accounting
1

Can any one explain Prepaid Expense is 20,000 from 22 Aug 2024 to 31 Dec 2024
According to Schedule Aug Month Amount is 1,395 and remaining Months are 4,651/per Month
i need calculation , Thanks in Advance
image

2

any one can explain this calculation

3

any one Know Logic or formula for Calculation

4

if any one need further explanation so , i can

5

Check if the booking is based on Months or Days in Accounts Settings.
For the first month, you have only few days, hence the different calculation.

6

Thanks for reply , booking based on Days if could you help on it i need Calculation formula

7

Total amount: 20,000
Total days: 129
Per day amount = 20000/129 ~= 155.04
Total applicable days in Aug: 9
Total Aug amount: (20000/129)*9 ~= 1395.35

I guess this is the breakup.

8

Thanks for Reply, as per my calculation , please check is it logical?

Total Amount 20000
Date Days
22-Aug 10 From 22 to 31
Sep 30
Oct 31
Nov 30
Dec 31
Total No days 132
Per day Amount 151.5151515 20000/Total nof days
Aug days 1515.151515
9

Please Check my response and calculation

10

This is the formula used in the report:

11

thanks