Quickbooks Journal Entry – 7 Properties to Commercial Loan

The following is the journal entry I used to record the closing of a commercial loan.  In this transaction, I put 7 total properties under a commercial loan, 6 were originally on land contracts and 1 was fully paid off.  Here is a summary of each of the line items:

1.  Type of account: Long Term Liabilities.  The loan value was $245,000.

2.  Type of account: Other Current Liabilities.  The bank also offered me a line of credit, $4452,96 of which was contributed to closing.

3 – 8.  Type of account: Long Term Liabilities.  These were the outstanding amounts on the 6 land contracts that were paid off.  To get specific, this is the principle balance as of the start of the month that closing took place.  In this case, the closing date was July 20th, 2014 so these values were as of July 1st, 2014.  After this transaction, there is a zero balance on all of these accounts.

9 – 15.  Type of account: Expense.  When real estate changes ownership or financing changes, upcoming property taxes need to be paid as part of closing.  This was a huge expense but would have had to be paid the next September regardless.

16.  Type of account: Expense.  Closing costs due to the title company and bank.

17 – 22.  Type of account: Expense.  These line items are the interest accrued on the 6 land contracts between July 1st and July 30th.  Interest is paid in arrears and would have been paid on August 1st with my regular land contract payments.

Cash at closing.  Type of account: Checking account.  Although not noted below, the actual transaction I edited in Quickbooks was a payment for $11,010 that I brought to closing.

 

If you have questions about this transaction, feel free to comment below or contact me here.

ACCOUNTDESCRIPTIONAMOUNTBILLABLECLASS
1Commercial LoanOriginal amount for commercial loan-245000
2Line of CreditTransfer from line of credit-4452.96
3House 1 LoanPayoff of House 1 land contract25342.98House 1
4House 2 LoanPayoff of House 2 land contract31377.17House 2
5House 3 LoanPayoff of House 3 land contract33548.86House 3
6House 4 LoanPayoff of House 4 land contract48077.11House 4
7House 5 LoanPayoff of House 5 land contract28441.13House 5
8House 6 LoanPayoff of House 6 land contract73330.54House 6
9Property TaxesHouse 1 property taxes1096.81House 1
10Property TaxesHouse 2 property taxes1849.94House 2
11Property TaxesHouse 3 property taxes957.78House 3
12Property TaxesHouse 4 property taxes2613House 4
13Property TaxesHouse 5 property taxes5533.66House 5
14Property TaxesHouse 6 property taxes3813.71House 6
15Property TaxesHouse 7 property taxes1213.08House 7
16Closing Costs2136.35
17Mortgage Interest132.88House 3
18Mortgage Interest342.55House 5
19Mortgage Interest224.55House 6
20Mortgage Interest150.67House 1
21Mortgage Interest123.45House 2
22Mortgage Interest156.74House 4

Leave a Reply