Excel Sample Sheet 33110 | Fit All Receivable Collection Remittance Report

Partial file snippet.

Sheet 1: FIT-All Report Form

	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		

		MONTHLY FIT-ALL RECEIVABLE, COLLECTION & REMITTANCE REPORT
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Billing/Collection Entity:
		

		

		

		

		

		

		

		Date Prepared:
		

		

	
	
		

		

		mm/dd/yyyy
		

		

	
	
		

		Address:
		

		

	
	
		

		

		

		

	
	
		

		Actual Energy Sold with FIT-All Charge, kWh:
		FIT-All Rate, (Php/kWh):
		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		FIT-All RECEIVABLE MONITORING
		

		

	
	
		

		

		

	
	
		

		

		Consumption Period
		

		

		

	
	
		

		From
		To
		

		

		

	
	
		

		mm/dd/yyyy
		mm/dd/yyyy
		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		 FIT-All Receivable-beginning, Php 
		

		

		

		

		

		

		

		

		

	
	
		

		

		 Add: FIT-All Receivable, for the Consumption Period 
		

		

		

		

		 -   
		

		

		

		

	
	
		

		

		 Total FIT-All Receivable, Php 
		

		

		

		

		 -   
		

		

		

		

	
	
		

		

		 Less: FIT-All Collection, for Collection Period 
		

		

		

		

		

		

		

		

		

	
	
		

		

		 FIT-All Receivable-ending, Php 
		

		

		

		

		 -   
		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		FIT-All COLLECTION MONITORING
		

		

	
	
		

		

		

	
	
		

		

		Collection Period
		

		

		

	
	
		

		From
		To
		

		

		

	
	
		

		mm/dd/yyyy
		mm/dd/yyyy
		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		 Unremitted FIT-All Collection- beginning, Php 
		

		

		

		

		

		

		

		

		

	
	
		

		

		 Add: Total FIT-All Collection, for the Collection Period 
		

		

		

		

		 -   
		

		

		

		

	
	
		

		

		 Total FIT All Collection for Remittance Excluding Interest/Penalty 
		

		

		

		

		 -   
		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		FIT-All  REMITTANCE MONITORING
		

		

	
	
		

		

		

	
	
		

		

		Remittance Date
		

		

		

	
	
		

		mm/dd/yyyy
		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		 Total FIT All Collection for Remittance Excluding Interest/Penalty 
		

		

		

		

		 -   
		

		

		

		

	
	
		

		

		 Add: Total Interest/Penalty Due* 
		

		

		

		

		

		

		

		

		

	
	
		

		

		 Total FIT-All Collection Due for Remittance 
		

		

		

		

		 -   
		

		

		

		

	
	
		

		

		 Total Actual FIT-All  Remittance on Remittance Date 
		

		

		

		

		

	
	
		

		

		 Applied to FIT-All Collection 
		 -   
		

		

		

		

	
	
		

		

		 Applied to Interest/Penalty 
		 -   
		

		

		

		

	
	
		

		

		Unremitted FIT-All Collection- ending, Php
		 -   
		

		

		

		

	
	
		

		

		 *Computation to be provided by TransCo 
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Remarks (if any):
		

		

	
	
		

		

		

		

	
	
		

		

		Printed Name & Signature
		Position/Title
		Date Signed
		

		

	
	
		

		Prepared by
		

		

		

		

		`
	
	
		

		Approved by
		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		TransCo Acknowledgment
		

		

		

	
	
		

		

		Printed Name & Signature
		Position/Title
		Date Signed
		

		

	
	
		

		Received by
		

		

		

		

		

	
	
		

		Reviewed by
		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		 FM-T-FA-02 Rev 0 
		

		

		

	



Sheet 2: DescrtnofVars_Fit-Al

	
	
	
		MONTHLY FIT-ALL RECEIVABLE, COLLECTION & REMITTANCE REPORT
		
	
		DESCRIPTION OF VARIABLES
		
	
		

		

	
	
		 TERMS 
		DESCRIPTION
	
	
		 Consumption Period 
		Period over which the consumption of customers that are billed the FIT-All are measured
	
	
		 Collection Period 
		Period over which remittance to the FIT-All Fund is collected from customers
	
	
		 Remittance Date 
		Date of actual remittance to the FIT-All Fund
	
	
		 Actual Energy Sold with FIT-All Charge 
		For DUs, this refers to actual energy sold to customers that are billed the FIT-All for the Consumption Period. For RES, this refers to the metered quantity that is similarly used in the computation of Universal Charge payment. For NGCP, this pertains to energy delivered to its direct connect customers and which is the same basis as its billing for the Universal Charge.
	
	
		 FIT-All Receivable-beginning 
		FIT-All previously billed to customers but not collected during the previous Collection Period
	
	
		 FIT-All Receivable, for the Consumption Period  
		FIT-All billed to customers for their consumption during the current Consumption Period
	
	
		 Total FIT-All Receivable 
		Sum of FIT-All Receivable-beginning and  FIT All Receivable for the Consumption Period
	
	
		FIT-All Collection, for the Collection Period
		Actual collection of the FIT-All for the Collection Period
	
	
		FIT-All Receivable-ending
		Difference between Total FIT-All Receivable  and FIT-All Collection for the Collection Period; Becomes the FIT-All Receivable-beginning for the following Consumption Period
	
	
		Unremitted FIT-All Collection- beginning, Php
		Actual collection for previous period(s) which was not remitted to the FIT-All Fund on previous Remittance Date
	
	
		Total FIT-All Collection for Remittance Excluding Interest/Penalty
		Sum of Unremitted FIT-All Collection-beginning and the Total FIT-All Collection for the Collection Period, excluding Interest/penalty, if any
	
	
		Total Interest/Penalty Due
		Total Interest and Penalty incurred due to failure to remit  FIT All Collection on time; As computed by TransCo
	
	
		Total FIT-All Collection Due for Remittance
		Total amount of FIT-All Collection for remittance including interest/penalty, if any
	
	
		Total Actual FIT-All  Remittance on Remittance Date 
		Actual amount remitted to the FIT-All Fund on Remittance Date
	
	
		Applied to FIT-All Collection
		Amount of remittance that is considered remittance of FIT-All collection (exclusive of interest/penalty)
	
	
		Applied to Interest/Penalty
		Amount of remittance that is considered payment for Interest/Penalty; Considered first in the application of payment
	
	
		Unremitted FIT-All Collection- ending, Php
		Difference between the Total FIT-All Collection Due for Remittance (including Interest/Penalty) and Total Actual FIT-All Remittance on Remittance Date; Pertains to collected amount that was not remitted; Becomes Unremitted FIT-All Collection-beginning for the following Remittance Date

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet fitall report form monthly receivable collection amp remittance billingcollection entity date prepared mmddyyyy address actual energy sold with charge kwh rate phpkwh monitoring consumption period from to receivablebeginning php add for the total less receivableending unremitted beginning fit all excluding interestpenalty due on applied ending computation be provided by transco remarks if any printed name signature positiontitle signed approved acknowledgment received reviewed fmtfa rev descrtnofvars fital description of variables terms over which customers that are billed measured fund is collected dus this refers res metered quantity similarly used in universal payment ngcp pertains delivered its direct connect and same basis as billing previously but not during previous their current sum difference between becomes following s was remitted collectionbeginning interest penalty incurred failure remit time computed amount including considered exclusive first application...

Related files

Share

Help

MONTHLY FIT-ALL RECEIVABLE, COLLECTION & REMITTANCE REPORT
DESCRIPTION OF VARIABLES

TERMS	DESCRIPTION
Consumption Period	Period over which the consumption of customers that are billed the FIT-All are measured
Collection Period	Period over which remittance to the FIT-All Fund is collected from customers
Remittance Date	Date of actual remittance to the FIT-All Fund
Actual Energy Sold with FIT-All Charge	For DUs, this refers to actual energy sold to customers that are billed the FIT-All for the Consumption Period. For RES, this refers to the metered quantity that is similarly used in the computation of Universal Charge payment. For NGCP, this pertains to energy delivered to its direct connect customers and which is the same basis as its billing for the Universal Charge.
FIT-All Receivable-beginning	FIT-All previously billed to customers but not collected during the previous Collection Period
FIT-All Receivable, for the Consumption Period	FIT-All billed to customers for their consumption during the current Consumption Period
Total FIT-All Receivable	Sum of FIT-All Receivable-beginning and FIT All Receivable for the Consumption Period
FIT-All Collection, for the Collection Period	Actual collection of the FIT-All for the Collection Period
FIT-All Receivable-ending	Difference between Total FIT-All Receivable and FIT-All Collection for the Collection Period; Becomes the FIT-All Receivable-beginning for the following Consumption Period
Unremitted FIT-All Collection- beginning, Php	Actual collection for previous period(s) which was not remitted to the FIT-All Fund on previous Remittance Date
Total FIT-All Collection for Remittance Excluding Interest/Penalty	Sum of Unremitted FIT-All Collection-beginning and the Total FIT-All Collection for the Collection Period, excluding Interest/penalty, if any
Total Interest/Penalty Due	Total Interest and Penalty incurred due to failure to remit FIT All Collection on time; As computed by TransCo
Total FIT-All Collection Due for Remittance	Total amount of FIT-All Collection for remittance including interest/penalty, if any
Total Actual FIT-All Remittance on Remittance Date	Actual amount remitted to the FIT-All Fund on Remittance Date
Applied to FIT-All Collection	Amount of remittance that is considered remittance of FIT-All collection (exclusive of interest/penalty)
Applied to Interest/Penalty	Amount of remittance that is considered payment for Interest/Penalty; Considered first in the application of payment
Unremitted FIT-All Collection- ending, Php	Difference between the Total FIT-All Collection Due for Remittance (including Interest/Penalty) and Total Actual FIT-All Remittance on Remittance Date; Pertains to collected amount that was not remitted; Becomes Unremitted FIT-All Collection-beginning for the following Remittance Date

Related files

Share

Share to social media

Help

Login Area