Entering a Loan You've Made to Someone Else in QuickBooks Online
I recently loaned some cash from my business to another person. While not specifically an Airbnb thing, it was an opportunity to grow my cash reserve a little, so I thought I'd give it a try. I wrote an agreement, we signed it, and I issued a check.
The next day, when doing my daily reconciliation in QuickBooks Online, I had to do a surprising amount of Googling to figure out how the heck to enter this transaction correctly. It seemed like all the examples I could fine assumed you were RECEIVING loan proceeds, and not that you were the actual LENDER.
Anyway, I finally figured it out, and thought I'd do a quick blog post on the subject, in hopes it helps someone else down the line:
- Go to Chart of Accounts, and make a new Account, choosing Account Type 'Other Current Assets'.
- In the Account popup window, choose a Detail Type of 'Loans to Others'
- Name the account something descriptive. I chose 'Loans Disbursed'.
- Select New, and then Check
- For Payee, enter the loan recipient
- For Bank Account, choose the account you're withdrawing the funds from
- For Category, choose the new 'Loans Disbursed' account we just created
- Enter the Payment Date, Amount, Description, etc. as needed
- Save and Close
- On the Account you withdrew from, you should see the loan disbursement as a Transfer, and your balance should have decreased by the loan amount.
- On your Balance Sheet, you should see the 'Loans Disbursed' account listed as an Asset.
- On your P&L, you should NOT see the loan listed as an Expense.
- Select New, and then Bank Deposit
- For Account (at the top of the screen), choose the account you're depositing the funds to
- Under 'Add funds to this deposit':
- For the Principal portion of the payment, enter a line item as follows:
- For Received From, enter the person or company who received the loan proceeds
- For Account, choose 'Loans Disbursed'
- Enter the remaining info (Amount, Description, Payment Method, etc.)
- For the Interest portion of the payment, enter another line item:
- Enter the info as above, except choose 'Interest Earned' for Account
- Save and Close
- In the Account you deposited the funds to, the balance should have increased by the total payment amount (principal + interest).
- On your Balance Sheet, the 'Loans Disbursed' account balance should have decreased by the amount of the principal portion of the payment
- On your P&L, your Income should have increased by the amount of the interest portion of the payment
Comments
Post a Comment