Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowSolved! Go to Solution.
Oh, all I thought you wanted to do was segregate the received funds into the separate sub-bank accounts without making a deposit for each one.
For simplicity I would go back to the sales receipt or invoice used to initiate payment to you that you are depositing. Split your income on the sales receipt or invoice. The sub-bank accounts are asset accounts and would be used to track designated funds but not income.
If you have a single customer payment posted in undeposited funds it makes it a little more complicated but not impossible - you have to look at the income account that the check was originally posted to and one of your deposit line items will be a negative of that income account, equal to the check. Then you will add a new line item for each income account for which they must all add up to the check amount. Net deposit still equal to the single check in the deposit. If you have multiple checks you will have to review and reverse the original income accont of each.
If you are recording income on the fly (not always the best idea) by entering check data in the deposit and nowhere else you can just add a line for each income account and the total of the deposit represents the sum of the checks deposited. This is not the best, although the income will appear in your P&L you may not be able to see the income in a report by customer
A Deposit can have multiple line items. Within that, after adding deposit items, you can enter positive amounts on each line for the sub accounts and a negative amount to the parent account such that all said and done the net deposit is equal to the money being deposited
@john-pero thanks for your reply. Can you provide an example? Note: I am currently using the "Add funds to this deposit" section of a deposit entry. Within that, I need to use the "Account" column in the deposit window to record the deposit into an income account so that it appears on the P&L.
Okay, great. Now in that Add Funds you will add the splits. Example, say you have a deposit of $600 into the bank account that needs to be spread among 3 sub-accounts, A, B, C in amounts of $100, $200, $300.
deposit item parent bank $600
Added Line Account Amount
1 sub account A $100
2 sub account B $200
3 sub account C $300
4 parent bank -$600
Net deposit $600
@john-pero thanks for that info. How do I assign an income account to each of those lines? If I don't have an income account for each of those lines, the income won't appear on my P&L, right?
They are not income accounts. Not everything included in a deposit has to be income. They are the bank and sub-bank accounts in your chart of accounts. What you are doing is a one step process instead of just the deposit and then a journal entry to move funds around.
@john-pero thanks. I am looking for an option that allows me to have a single deposit that matches the single deposit I made to the bank but also allows me to assign income to each of the individual parts of the deposit. Thoughts?
Oh, all I thought you wanted to do was segregate the received funds into the separate sub-bank accounts without making a deposit for each one.
For simplicity I would go back to the sales receipt or invoice used to initiate payment to you that you are depositing. Split your income on the sales receipt or invoice. The sub-bank accounts are asset accounts and would be used to track designated funds but not income.
If you have a single customer payment posted in undeposited funds it makes it a little more complicated but not impossible - you have to look at the income account that the check was originally posted to and one of your deposit line items will be a negative of that income account, equal to the check. Then you will add a new line item for each income account for which they must all add up to the check amount. Net deposit still equal to the single check in the deposit. If you have multiple checks you will have to review and reverse the original income accont of each.
If you are recording income on the fly (not always the best idea) by entering check data in the deposit and nowhere else you can just add a line for each income account and the total of the deposit represents the sum of the checks deposited. This is not the best, although the income will appear in your P&L you may not be able to see the income in a report by customer
@john-pero thanks! Lots of options to choose from. I appreciate the help!
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.