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 nowHow do I create a loan account that has an initial amount where a portion goes to a fee, another portion pays off a credit card account, and the balance is deposited into the checking account?
Solved! Go to Solution.
@Brenda369 Steps 2 and 3 have some degree of overlap; this causes the issue you describe.
As a general rule, it's best not to use Journal Entries in QB unless you absolutely have to. If nothing else, Journal Entries do not play well with a lot of reports.
Instead, you have the option to take care of all of your needs in one deposit transaction.
In the first line of the deposit, for the From Account column, select the loan account you are using. Enter the full amount of the loan in the Amount column.
In the second line of the deposit, for the From Account column, select the appropriate expense account for the fee that a portion of the loan is being used to pay. Enter the amount of the fee in the Amount column as a negative value.
In the third line of the deposit, for the From Account column, select the credit card that a portion of the loan is being used to pay. Enter the amount of the credit card that is being paid off in the Amount column as a negative value.
This will have four effects.
The first line will establish the original balance of the loan.
The second line will lower the total deposit by the amount of the fee being paid while recognizing said fee expense.
The third line will lower the total deposit by the amount of the credit card being paid off while also lowering the balance due of said credit card.
The amount that remains after all deductions will then show up a deposit into the checking account you selected.
Hi, @Brenda369. You can set up a loan account in QuickBooks Desktop and record the initial loan amount while allocating portions to fees, a credit card payment, and depositing the remaining balance into your checking account. Follow these steps:
Step 1: Set up a loan account:
Step 2: Record the loan amount and its allocation:
Step 3: Allocate portions of the loan using journal entries:
Step 4: Verify you accounts:
I’ll share this article as your reference for recording a loan and properly accounting for its parts: Manually track loans in QuickBooks Desktop.
Let us know if there are any additional questions.
Thank you for the response! When I performed these steps, it created the initial deposit into the checking account per Step 2. Then an additional deposit for the actual deposited amount, as per Step 3 debiting the checking account. It did zero out the credit card which is good, but then it doubled the amount in the liability account created in Step 1, as per the instruction in Step 3 crediting this account. Was the initial deposit step necessary or did I do something wrong?
@Brenda369 Steps 2 and 3 have some degree of overlap; this causes the issue you describe.
As a general rule, it's best not to use Journal Entries in QB unless you absolutely have to. If nothing else, Journal Entries do not play well with a lot of reports.
Instead, you have the option to take care of all of your needs in one deposit transaction.
In the first line of the deposit, for the From Account column, select the loan account you are using. Enter the full amount of the loan in the Amount column.
In the second line of the deposit, for the From Account column, select the appropriate expense account for the fee that a portion of the loan is being used to pay. Enter the amount of the fee in the Amount column as a negative value.
In the third line of the deposit, for the From Account column, select the credit card that a portion of the loan is being used to pay. Enter the amount of the credit card that is being paid off in the Amount column as a negative value.
This will have four effects.
The first line will establish the original balance of the loan.
The second line will lower the total deposit by the amount of the fee being paid while recognizing said fee expense.
The third line will lower the total deposit by the amount of the credit card being paid off while also lowering the balance due of said credit card.
The amount that remains after all deductions will then show up a deposit into the checking account you selected.
Beautiful, and simple, 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