Print out loans intrest and principale last year

I am trying to print out intrest and pricipale paid for each loan in the last year as well as intrest rate if possible.

  • Sage 50 Canadian does not have the capability of tracking each loan separately, so you would have to use the G/L.

    - Run the G/J transaction report, filtered by Source or Comment
    - Export to Excel. then,
    - Manipulate the output so as to split the entry lines into columns.

    Alternatively, assuming each payment was a blend of principal and interest as a separate journal entry:
    - Run a G/L listing of the bank, loan, and bank interest accounts
    - Use Vlookup() in two additional columns from each loan payment entry in the Loan account, to look up the journal entry number in the bank and Interest Expense accounts.

    I hope that helps, please post back.

    Randy