Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I hope someone can help me here in understanding the LOC in QB desktop(pro premier 2019). We have a LOC, which we use to transfer funds into our checking account as needed. What is the process to balancing the LOC to match our bank statement? When we pay to the LOC, we were creating a bill but just found yesterday that I could just use the transfer funds. My LOC is totally off from what I show on the bank statement. I haven't been reconciling the LOC. Could I be missing a transaction? The ending balance is way , way higher in QB compared to what I have on the bank statement. So, if I have the bank statement that shows the principal and interest , how would I record that in QB? I hope this makes sense, I am so confused and would appreciate if anyone can help . Thank you !
Thanks for posting here, @Suarez-L,
The process of recording Line of Credit in QuickBooks can be confusing, but once you get a hang of it, then it should be easy for you. I want you to know that I’m happy to explain anything in more detail so you're guided properly.
For the first step, we need to create the Line of Credit account in the COA. Here's how:
Regarding the process of how you record and which transactions to create depends on how you use the line of credit for. If you use the LOC to put money into your account, use the Transfer Funds or Make Deposits option to increase the bank balance.
If you're paying the LOC, you can simple write checks from the Banking menu. To do that, follow the steps below:
When you use the LOC to purchase something, you can use journal entries or other expense transactions in QuickBooks. Then when you pay, use a check so it's easier to record and trace the payment.
By following this, you should be able to match and balance the entries in the register.
If you have any questions about the steps or the process, just reply to this thread and it will come right back to me. Have a good one!
@Jen_D Thank you so much for your quick response ! I truly appreciate it :) As you can see I am a newbie and II am so glad to have found this community. I'm such a newbie. Let me tell you my situation, we have a LOC set up already and we use to transfer money to our checking acct. When we pay the LOC, I have been creating a Bill. I didn't know about the "transfer funds". Currently our LOC in QB shows a totally different amount than what I show in our bank statement. So is my " ending balance" in QB for the LOC, supposed to match my bank LOC account?
I am so lost.
Yes, @Suarez-L.
In terms of reconciling your Bank account and LOC, it should match each period of reconciliation to make sure that your reporting and books are accurate. Here's how to reconcile your account:
For your reference, see our Reconciliation guide page.
Also, it is recommended to always create a backup copy of your company file before making any changes. This is to make sure you have an original copy that you can restore at any time in case of data loss or damage.
Then, to review your past reconciliations, you can pull up the Previous Reconciliation report.
Let me know by posting a comment below if you need further assistance in managing your accounts in QuickBooks. I'm always here to help. Have a good one.
Thank you so much for your input. I am current' using QuickBooks Desktop pro 2019. I have never reconciled our LOC or Credit Card accounts. I'm glad to know this information for when I have converted to QBO.
I know this is a bit old, but I am setting a LOC up just as above and the entries are backwards. When I transfer from the LOC to my bank account it adds to the balance of the LOC and when I write a check from my bank account to the LOC it deducts from the LOC balance. I'm hoping I missed something simple, I do transfers between other accounts all the time without issues. Using Enterprise Desktop 2021
Good day, SB_77.
I appreciate the detailed information about your issue with LOC.
The unexpected behavior might be caused by a corrupted file. Running the Verify/Rebuild utility can detect data damage in QuickBooks Desktop. Here's how:
To verify:
To Rebuild:
You can also check this link for more details about the process: Verify and Rebuild Data in QuickBooks Desktop.
I've also included here a guide on resolving any possible data issues: Fix data damage.
Keep me posted on your results after trying these steps. I'm here to ensure your success.
You may have entered the Line of Credit as an Other Current Asset instead of an Other Current Liability. That would create the issue you're having.
If you accidentally set up the account as an other current asset instead of an other current liability, it would create this issue as well. Please check that first.
I came across these steps, and they're very well explained. thank you
If I could ask, is it best to add a beginning amount/ LOC principal? I've been recording my transaction just as you've mentioned but noticed I never added the principal amount.
Can someone please guide me through the steps to adding the principal if possible?
Lastly, if I have two different LOC from the same bank but each has its account number. "When recording payment/writing check-in QB desktop is it best to write check PAY TO THE ORDER Of the bank name or use the name of the bank and last four of the account number to separate both loans.?
Thank you
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here