In a sales journal spreadsheet with multiple columns, date, invoice number, amt of inv, sales rep, etc., I want to incorporate the cash receipts by adding columns for date rec'd, check number, amt rec'd, etc. It works fine when there is one payment, which I apply to the original inv line. The question is that some payments are done in up to 8 installments. How do I apply these payments to original invoice without adding too many columns? If added on a new row, how do these installments add up and get deducted from the balance amount?