Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowI have a line of credit with my bank, that internally I would like to divide into 3 separate sub accounts for operating expenses, inventory, and building improvements. If I sell inventory, I would like to credit the inventory sub account. If I am doing services, I would like to borrow from the operating sub-account, but then pay it back when I get paid for the service.
How can I record the advance from the bank in the main LoC account, then transfer into these separate accounts, which ultimately get transferred into the bank account, then all that in reverse order?
I'm pleased to have you here, Ericf1. Let's discuss how to track advance from the bank and transfer them between accounts.
QuickBooks Online offers a way to set up and track a line of credit so you can better manage your cash flow and decide when to spend, borrow, or transfer funds.
To record your advance from the bank, you can set up liability and expense accounts to accomplish it.
Here's how you do it:
For setting up an expense account. Refer to the steps below:
For more details about the processes, please refer to this article: Manage a line of credit in QuickBooks Online.
You can record a transfer after to allocate the amount to separate accounts. Consider scanning this resource for reference: Transfer funds between accounts.
For thorough guidance in managing your accounts, you can seek an accountant's advice. If you don't have one, feel free to visit this page: Find a QuickBooks ProAdvisor.
Additionally, this material gives you information to efficiently organize and categorize your transactions in the program: Categorize online bank transactions in QuickBooks Online.
Just click the Reply button whenever you have other queries about credits. You're always welcome in the Community.
Hi Kim,
I am aware of that solution for a simple line of credit. However, it doesn't solve my issue trying to allocate the main line of credit into the sub accounts.
Thanks
You can create subaccounts (LOC - Inventory, LOC - OpEx, etc) under your main LOC liability account and use those to track the purpose of the funds drawn on the LOC. You would just assign the appropriate LOC subaccount to each deposit. Then, when you make payments, you can assign the payment to the appropriate subaccount to reduce the liability. I'm not sure about the benefit of doing that but presumably, you have your reasons.
"If I sell inventory, I would like to credit the inventory sub account. If I am doing services, I would like to borrow from the operating sub-account, but then pay it back when I get paid for the service."
See above. Once you have drawn on the LOC, there is no additional entry to be made. Until you pay back the LOC, there is nothing to reduce/credit/transfer, etc. as the actual cash is in your bank account and you owe on the full LOC. This can be tracked outside of QB but, from an accounting standpoint, I think the only option is to use LOC subaccounts. Assigning the repayments to a specific subaccount (inventory, OpEx, services, etc.) is going to be messy IMO and probably inaccurate because the payment is coming from the same pile of cash that contains income from all three sources. Just my $.02.
Thanks @Rainflurry
I think I will have to use the sub-accounts as you said. I did want record the draw into the parent account, then move to sub accounts, but I was not able to get that to work as I thought it would. I notice on the balance sheet it will summarize the all the sub accounts under the parent anyway, I just cant seem to effectively track the unallocated money that I have drawn.
It's much more important to me to track the sub accounts individually. One big reason is the building account will get "paid down", but then that will free up that money to be used for inventory. Also on the operating account, I need to watch it very closely because the main purpose is to provide cash for payroll and materials of jobs that will be paid at the end. If I dont keep that well recorded, that balance could get out of control.
E.g. if I know a current job will pay $8000 in 4 weeks, I must ensure that I dont draw more than $8000 for payroll and materials.
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