I think you'll need a row or column for each month individually, being very careful to get the
outstanding principal balance right at the start of each month, to understand exactly how your lender is calculating interest, to understand exactly how your lender is recalculating payments amounts, and to
match these through appropriate use of PMT, IPMT, PPMT, etc functions.
Now, I know most loans» Payment Histories are chock full of rounding errors, for example
Outstanding Principal almost never
matches Principal Balance for a loan with more a few payments, sometimes it's off by 10 or 20 cents.