News & Special Offers

QuickBooks Sale!

Dell All-in-One w/touchscreen

Dell Inspiron One All-In-One Computer / AMD Athlon II X2 Processor

How to Use Checking Sub-Accounts to Track Restricted Cash Balances in QuickBooks for Nonprofits

Someone once told me that he was able to subdivide his checking account into two (or more) sub-accounts that would still roll-up into one for the purposes of the reconciliation process. In other words, (this was a nonprofit), he had one sub-account for unrestricted cash and another for restricted cash, and when he did his monthly bank reconciliation, QuickBooks recognized that the two sub-accounts both related to the same checking account. I've tried a couple of times to recreate this, but haven't succeeded. Do you know how? What other suggestions might you have for segregating cash on the balance sheet?
First, create two additional bank accounts.  Go to Lists > Chart of Accounts, click on the Accounts button, select New.  Select Bank as the type, click on Continue, name them something easy to remember (like unrestricted and restricted), check the box next to Sub-account of, and select your regular checking account.

If you’ve already setup the two new accounts, you can easily make them sub-accounts.  Begin by making sure they are directly underneath your regular checking account.  If they aren’t, right-click on the diamond next to the account and drag them to the right spot.  Then right-click on the diamond again and drag it to the right.  Be careful not to make one of the new accounts a sub-account of the other sub-account.  If done correctly, they’ll both be indented one space over underneath the checking account.  If not, one will be indented underneath the other sub-account.  If this happens, just right-click on the incorrect account and drag it to the left.  

You may get an error message that you need to put your list in the original order before you can start moving the accounts around.  This will change your list order.  If you don’t want to do this, right-click on the account you want to make a sub-account, select Edit Account, check the box next to Sub-account of, and select your regular checking account.

Now, you can reconcile either of the sub-accounts or the parent account.  When you’re ready to reconcile, select whichever account you want to reconcile.  If you choose the parent account, all the transactions within the sub-accounts will be combined in the reconcile window.


If we helped solve your problem, please consider posting a review for us!

Ruth Perryman - QuickBooks Specialist Written by +Ruth Perryman, CMA, CFE, CFM, MBA

Ruth is the president of The QB Specialists, Inc. and has provided QuickBooks help to thousands of businesses around the world since 1996. She is an Intuit Solutions Provider, an Advanced Certified QuickBooks ProAdvisor, and a member of the Intuit Trainer/Writer Network. She is also certified in QuickBooks Point of Sale and QuickBooks Enterprise Solutions.

Buying QuickBooks for a client? Call us at 800-707-0940 to discuss what we can do to help!

QuickBooks price list | QuickBooks for sale | Free trial QuickBooks POS | Free trial QuickBooks Enterprise

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>