cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 2

Line of credit setup and bank reconciliation

I routinely have issues with the way the line of credit works in QB online. Perhaps it's just me. Here's the quick situation I have now. 

I made a payment from checking account to line of credit account. For simple math, we'll make this easy. Let's say the payment was $100. $30 was principal, and $70 was interest. When the checking account syncs, it shows $100 debit. I created an expense for $100 and put $30 in an account of Line of Credit and $70 in an account of LOC Interest. 

However, when the LOC syncs, it shows $100. BUT the balance is only going down by $30 since that's the principal. So what do I do? The LOC account in QB doesn't find the expense I entered to match up because it's only $30 and the LOC sync shows $100, which isn't accurate. 

Am I doing this wrong? I'm confused. Thanks for the help.

Solved
Best answer October 15, 2018

Best Answers
Highlighted
Level 10

Line of credit setup and bank reconciliation

I noticed the same thing.

I also split the debit in the checking account, with the interest portion going to the interest expense and the rest going to the LOC liability account.

I don't think this is a QBO problem. This is how the bank sends the data to QBO. 

There is very little activity in the LOC account, so I don't need to use the bank feed (what you are calling the "sync") for the LOC.  I just ignore it.  The LOC balance is correct because of the aforementioned split entry, which correctly reduces the LOC balance.

View solution in original post

4 Comments
Highlighted
Level 10

Line of credit setup and bank reconciliation

I noticed the same thing.

I also split the debit in the checking account, with the interest portion going to the interest expense and the rest going to the LOC liability account.

I don't think this is a QBO problem. This is how the bank sends the data to QBO. 

There is very little activity in the LOC account, so I don't need to use the bank feed (what you are calling the "sync") for the LOC.  I just ignore it.  The LOC balance is correct because of the aforementioned split entry, which correctly reduces the LOC balance.

View solution in original post

Highlighted
Level 2

Line of credit setup and bank reconciliation

Makes sense. I'll just either ignore the bank sync or stop syncing all together. Then the balance will match. Thanks.
Highlighted
Level 1

Line of credit setup and bank reconciliation

So each time you transfer money from lets say an operating account, do you manually create the principal amount in the LOC's register? 

Highlighted
QuickBooks Team

Line of credit setup and bank reconciliation

Hello, @JennyP714.

 

Before going into detail, I'd like to ask if you mean to transfer money between two accounts?

 

If so, you can use the Transfer option in QB Online to transfer funds between bank accounts.

 

Here's how:

  1. Select New.
  2. Under Other, choose Transfer.
  3. From the Transfer Funds From drop-down list, click on the bank account that the funds are coming out of.
  4. In the Transfer Funds To drop-down list, pick the bank account the funds are being deposited into.
  5. In the Transfer Amount field, enter the amount being transferred.
  6. Edit the Date.
  7. Type a description of the transfer in the Memo field.
  8. Pick Save and close.

If the steps above are effective, you can refer back to this detailed article: Transfer funds between accounts.

 

I look forward to chatting with you soon. Happy Tuesday!

Need to get in touch?

Contact us