USA Amortization schedule and credits received

[besoccer]

Hi

I am setting up a liability amortization schedule. The issue is that this amortization schedule works for credits that are received fully, but I have partial credits that are being received, causing my LT balance to be incorrect.

Theoretically, there should be no LT piece for these partial credits that are received throughout the period of the contract.

Please help

Type	Total																			July 2022																																			june 2025	Total	ST	LT	Expensed
Usage	$ 27,850,000.00	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ 773,611.11	$ 773,611.11	$ 773,611.11	$ 773,611.11	$ 773,611.11	$ 773,611.11	$ 773,611.11	$ 773,611.11	$ 773,611.11	$ 773,611.11	$ 773,611.11	$ 773,611.11	$ 773,611.11	$ 773,611.11	$ 773,611.11	$ 773,611.11	$ 773,611.11	$ 773,611.11	$ 773,611.11	$ 773,611.11	$ 773,611.11	$ 773,611.11	$ 773,611.11	$ 773,611.11	$ 773,611.11	$ 773,611.11	$ 773,611.11	$ 773,611.11	$ 773,611.11	$ 773,611.11	$ 773,611.11	$ 773,611.11	$ 773,611.11	$ 773,611.11	$ 773,611.11	$ 773,611.11	$ 27,850,000.00	$ 9,283,333.33	$ 13,925,000.00	$ 4,641,666.67
Credits	$ (27,850,000.00)																					$ (2,286,500.00)			$ (2,286,500.00)		$ (2,286,500.00)			$ (2,286,500.00)			$ (2,299,250.00)			$ (2,299,250.00)			$ (2,299,250.00)			$ (2,299,250.00)			$ (2,376,750.00)			$ (2,376,750.00)			$ (2,376,750.00)			$ (2,376,750.00)		$(27,850,000.00)	$ (9,171,500.00)	$(14,105,500.00)	$ (4,573,000.00)

 

[kirby]

Your question is insufficient in detail for us to discern the issue. Sorry