Skip to main content
C
chuck27p
October 16, 2018
Solved

Line of credit setup and bank reconciliation

  • October 16, 2018
  • 2 replies
  • 0 views

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.

    Best answer by Malcolm Ziman

    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.

    2 replies

    M
    Malcolm ZimanAnswer
    October 16, 2018

    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.

      C
      chuck27pAuthor
      October 16, 2018
      Makes sense. I'll just either ignore the bank sync or stop syncing all together. Then the balance will match. Thanks.
      C
      christine4form
      April 28, 2021

      How did you set up your LOC to begin synching? Did you just designate it as a credit card since that's the only option that's a liability?

      C
      christine4form
      April 28, 2021

      @chuck27p forgot to tag you. did you set up the LOC initially as a credit card so that you could synch?

      R
      Ryan_M
      April 28, 2021

      Hi @christine4form,

       

      As the user @Malcolm Ziman stated above, he ignores these bank feeds since they're already recorded in QuickBooks Online (QBO).

       

      To start tracking a line of credit in QBO, you'll need two accounts. One is for the principal, and the other is an expense account for the interest.

       

      Follow these steps to create an account for the principal:

      1. Click the Accounting tab.
      2. Select New.
      3. Set the Account Type to Other Current Liabilities, and the Detail Type to Line of Credit.
      4. Enter a different account name if you want.
      5. Hit Save and Close.

      Here's how to create the expense account:

      1. Go to the Accounting tab.
      2. Tap New.
      3. Set the Account Type to Expenses, and the Detail Type to Interest Paid.
      4. Type in a different account name if you want. 
      5. Press Save and Close.

      Take a look at this article for additional information on this process: Set up and track a line of credit.

       

      Don't hesitate to drop a comment below if you have other questions about tracking LOC in QBO. I'll be sure to take care of it. 

      Terms & ConditionsAccessibility statement