Month wise allocation of AMC charges auto calculation in Excel

When an amc income is booked or billed for more than one accounting period, this should be allocated proportionately to the different accounting periods. The excel sheet provided will enable you to automatically allocate the amount to respective period based on the period of coverage of the AMC.  

Note:

1. This will calculate month wise allocation of AMC income automatically
2. Update the details invoice details period and amount etc in yellow colored cells.

Month wise allocation of AMC charges auto calculation in Excel Click here to Download.