Showing results for 
Search instead for 
Did you mean: 

Reply to message

View discussion in a popup

Replying to:
Level 3

Reply to message

Not sure if this will help but a generic approach to handling the kind of thing you describe -- and not only deposits, but payments too, where you have, say, multiple payments going out as a single combined ACH -- is to use a "clearing" account. Undeposited Funds is really just one example of such a clearing account, made special only by QuickBooks knowing to use it for a specific set of circumstances.


But for the general case, we have created another account of type Bank, whose sole purpose is to act as a "buffer" between the register corresponding to our real bank account, and the internal accounts such as A/R, A/P and so on. So in your case, you would create your two deposits as transactions between the actual bank and the clearing account. So your bank register matches your actual bank account exactly. And then  you can post the seven sales transactions between A/R (or wherever) and the clearing account. Another example we often use it for is in our multi currency environment where currency exchange rounding errors can often occur because QuickBooks doesn't have enough precision in its currency arithmetic. We often have to artificially chop an FX transaction into a couple of parts, and so rather than do that in the foreign currency bank account register, we hide away the mess in a clearing account. 


So a clearing account is really just a form of suspense account, but with a suspense account you may have a non-zero balance live there for some time, usually until you figure out how to "unsuspend" the relevant transactions. That is in contrast with the clearing account where as soon as you post a transaction that creates a balance of some sort, you are going to immediately post the "other side" transactions to clear out that balance. So a clearing account should always have a zero balance (well, except for the few seconds it takes you to put in the other side!) 


One final point. Very often, you will be posting in and out of clearing accounts using journal entries. QuickBooks occasionally has restrictions such that some transactions that are permissible simply cannot be done. So to use a clearing account effectively, you'd have to be comfortable journaling things. It's not hard, but can be a bit scary at first if you've never done it before.


Need to get in touch?

Contact us