Do you and your friends loan each other money quite a lot? We all want to help out our good friends but the problem is when loans are not repaid, if you get into arguments about what is owed, or if you let some slide, then this can cause tension or could ultimately break the friendship you were trying to support.
Well, good news, we have a solution using Microsoft Excel. If you have ever got into a tangle of loans and struggled to remember who owes what and keep track of repayments, then you need this Excel spreadsheet.
The Loan Tracking Spreadsheet
Our solution allows you to keep track of loans outstanding to multiple friends. You can download it here. The file contains two sheets. The first is the loans list and is where you store all the transactions (who made the loan, for whom, the amount, the date and any notes).
As people make loans, add who loaned what to the list, and as people repay loans record these transactions also with the names reversed to reflect the money being paid back.
Our second sheet keeps track of who owes what to whom, and is automatically updated to reflect any changes in the loans.
Obviously there are a lot of geeky Excel bits and pieces going on under the hood. If you are that way inclined do check the code out. Hopefully though the solution as it stands will show you it is possible to keep track of all the loans in your social group and reduce the fall-outs to a minimum!
My Take on Having Loans to Friends
Personally, I’m usually against loaning friends money (I’d rather give a gift), but Yoav offered a useful tool for those who due loan out. It’s very difficult to maintain your relationship when someone owes some one else money. There are other options to giving out loans:
If you are going to give a loan out, please have everything in writing to avoid more stress. Yoav’s spreadsheet solution can also be helpful.