+AD4- iI +-need a vehicle loan amortization template that I can input the
+AD4- actually date paymts are received. The template that are provided
+AD4- amortizes the loan as if the customer makes the payment on the
+AD4- schedule 30 days but most often this is not true.

Here's one way, though there may be no actual loan that works like this.

In B1 put the loan amount.

In B2 put the annual interest rate.

In B3 put the starting date.

In A6 and downward will go the payment dates.

In B6 and downward will go the payment amounts.

Next,
C6 downward will be the portion of the payment that goes to interest.
D6 downward will be the portion of the payment that goes to principal.
E6 downward will be the remaining balance.

In C6 put
+AD0-IF(A6+AD0AIgAi-,+ACI-+ACI-,MIN(+ACQ-B6,+ACQ-B+ACQ-2+ACoAJA-B+ACQ-
1+ACo-(A6-+ACQ-B+ACQ-3)/365.25))

In D6 put
+AD0-IF(A6+AD0AIgAi-,+ACIAIg-,B6-C6)

In E6 put
+AD0-IF(A6+AD0AIgAi-,+ACIAIg-,+ACQ-B+ACQ-1-D6)

In C7 put
+AD0-IF(A7+AD0AIgAi-,+ACIAIg-,MIN(+ACQ-B7,+ACQ-B+ACQ-2+ACo-E6+ACo-(A7-
A6)/365.25))

In D7 put
+AD0-IF(A7+AD0AIgAi-,+ACIAIg-,B7-C7)

In E7 put
+AD0-IF(A7+AD0AIgAi-,+ACIAIg-,E6-D7)

Copy C7:E7 down as far as the list can go.