Questions from the OWLS: Bank of Bob

0:00Hey everybody, welcome to the latest edition of the unofficial QuickBooks Accountant podcast. I'm your host, Alicia Katzpolic of Royalize.com. Today's episode is called Questions from the Owls, the Bank of Bob. I'm going to do a new segment, starting today, called Questions from the Owls. Many of you know that I have an entire QuickBooks training community at Royalize.com, where I teach classes and there's an on-demand recording library where you can go in to ask questions and learn how to do things on the fly. We also have forums that are really active and there's a constant question that's been coming up over the last couple of weeks about what to do when you have a client who combingles specifically when they incur business expenses, but they're doing it on personal credit cards, for example, or they paid for it out of pocket with cash.

1:04This is always a challenge because if they don't actually tell you that they incurred the expense, you don't even know. And then once you do find it out, maybe at least they thought to send you the receipt or to tell you about it, how do you enter it? And so that's where the conversation comes in about what I call the Bank of Bob. So what is the Bank of Bob? Bank of Bob is an imaginary bank account that I add to the general ledger. And I use a bank account because it's funding and so it's a place to put transactions. And you know, it's not an imaginary account because the money is getting spent. So I can't really call it like a fake account, but it is an account that just represents the owner's pockets. Now if I was being official about it, I would call it personal funds used, okay? But I like to call it Bank of Bob because it makes the owners laugh.

2:04They get the concept, you know, and so I wouldn't just call it Bank of Bob, like I'll call it Bank of Alicia or Bank of Gary or Bank of Rachel, whatever the person's name is. And that really gets the point across that it's their own money that they're spending. Now if you ask a CPA what they do with these owner investments, they say, oh, well, these are owner investments. And I make a journal entry to show what the expense was for and then put it in the books debiting and crediting the expense and the equity account. But in QuickBooks, that's not necessarily the best approach. As you know, using forms in QuickBooks is always the best approach to take because some of the reports have automatic filters according to the transaction type. And journal entries may or may not work in those circumstances. Also if you do a journal entry, all you're really capturing is the dollar amount and

3:05the account category you can put on the vendor name, but it might not even show up on the vendor's list, depending on how you have your filters set up. So I really like being able to capture the entire transaction, everything about it. The vendor named the date, the class, the location, tags, if you have the tags, the details the memo, literally everything that you could possibly put on it gets captured normally. And the only way to do that is to assign it to either a checking account or a credit card. So that's where Bank of Bob comes in. By having an account called Bank of Bob, it gives you a place to enter your real expense transactions. And it doesn't matter if they're paying by cash or by debit card or by credit card or by check, however they paid for it personally, you only need one account. Because by the time it hits the business, it's just on a equity anyway. So it's just really a dumping ground for all of these extraneous transactions.

4:08One to say extraneous though, it doesn't mean they're not material. I just mean outside the norm. Now of course we don't want them coming. We don't want them using personal expenses, but sometimes they forgot to bring their business card or they pulled the wrong one out because you know, my two Southwest credit cards look exactly the same for my business account, my personal account. So I actually have to turn it over and look at the back of the card every single time. Or if I'm doing tap to pay, it pulls up the cards and sometimes I miss tap and I wind up tapping my personal card instead of my business. Well, I don't really, I don't make this mistake, but it would be possible and I can see how people do make that mistake. So once you have created your workflow where they at least got you the receipt or told you about the expense or entered it themselves, they basically can use regular transactions in order to enter it in. So they can use an expense or they can do as a check or they can do a bill and a bill

5:11payment if that's what your workflow is, even though this is usually retroactive and you don't need the two step process. But let's just say you use an expense. So they get to put in the expense with everything about the purchase itself and then you use Bank of Bob as the funding source for it. And so you basically have a checking register of all of their personal expenses that they've incurred. Then what I do at the end of the month or the end of the year if there aren't very many of them is I'll make an adjusting entry to owner investment. And so it just gives a lump sum in equity of all of the individual transactions that they've accumulated for the year. This makes it really easy and streamlined. Your QuickBooks understands how to do the reporting on it and it makes it clear to the owner how much commingling they're actually doing. Ideally, you're just talking about one or a handful of expenses a year at the max.

6:14But if you have a business owner who's Bank of Bob is full of transactions, you know you've got a commingling issue. If that's the case, the best thing to do is to figure out how much are they spending every single month and instead of using the business for their personal expenses and their personal for their business expenses, you make sure that you have the right funds in the right place by making lump sum transfers on a monthly basis. So if they tend to put their personal expenses on their business funds, have to move all of those Spotify subscriptions and who lose subscriptions and even their PGE bill, their electric bill over to their personal and then take a monthly transfer out that covers all of those bills. So the grand total dollar amount is all still the same, but it doesn't look like they're pulling tons of money out of the company. And then when we're talking about owner investments, if they keep pulling out the wrong card,

7:14then same deal. If it's a matter of them not having enough money in the business in order to make the expenses so they're funding it personally, the reverse is true. Have them make a monthly contribution to the company, you know, 500, $1,000, $10,000, whatever their scale is. And then that way they have the money in the company and they're not commingling with all of these individual expenses going through them. Let's face it, the job market is especially tough right now, but here's the thing. Every industry needs accountants and accountants are always in demand. In fact, employment for accountants is projected to grow 10% through 2026, faster than most other professions. That's where UNC Keenan Flagler's Master of Accounting program comes in. It's one of the top ranked Mac programs in the country and for good reason. Whether you choose their 12-month on-campus program or their flexible online option,

8:19you'll gain the expertise that makes Mac graduates earn significantly more than those with just a bachelor's degree. Plus, you'll join the powerful 290,000-strong UNC alumni network, connections that will serve you throughout your career. And if you've been thinking of switching industries or want to set yourself up for a lifelong career, pick the program with proven ROI. To see why you should get your masters in accounting at the UNC Keenan Flagler Business School, head over to uqb.promo-unc. That is uqb.promo-forward-unc. When I teach Bank of Bob, one of the popular follow-up questions is, what do you do if the owners planning to pay themselves back? If you're using Bank of Bob, that's great. So the paying back just pays down Bank of Bob and you just categorize it straight back

9:20to that account and ideally it washes to zero. And then that way you don't have to make the adjusting journal entry to owner investment. What you don't want to do is have constant new transactions show up and constant payouts. That's when you know that you've got somebody who really needs some better fiscal management. If we're talking about loans and the business owner is loaning themselves money, then I don't use Bank of Bob for that. I do a shareholder loan as a liability and then every time they pay themselves back, I pay down that liability until it's zero. If it's material, you actually have to go a step further. If they are loaning the company money, like let's say $10,000, then they actually need a promissory note and terms. And they even have to have reasonable market interest on it. So you have to have a contract in order to make that legal. And that's one of those steps that a lot of business owners don't want to admit to themselves

10:21that they are loaning themselves this money. And so you have to make sure that you have some structure around it. So if the owner is loaning the company money and it is structured as a loan, it has to be really an official loan and you do have to file a $10.99K on the interest. A related topic to this is managing owner equity in general. QuickBooks out of the box doesn't have any owner draws or investment accounts and you do have to put them in. And the terminology that you use depends on the formation of the company. Are they a sole proprietor? Are they an LLC? Are they a partnership? Are they an escort? If there's only one owner, then you make an owner draw an owner investment category. And if it's a sole proprietor, that's the terminology that you use draws for the money out and investment for the money in. Once you get into any of the other entities, I prefer distribution and contribution instead.

11:26If there's more than one owner, then you actually need an owner equity section for each owner. And in that owner equity section, you need each person's own distributions and contributions. And if they're partners, then they have a partnership agreement that talks about their percentages. Are they 50? 50? Are they 75? 25 is one an equity partner and one is the labor partner. And when that's the case, you actually have to keep an eye on whether they are meeting their proportions that at the end of the year, you might have to true them up where one person has to put in or take money out of the company so that they are equal. Now at the end of the year, on December 31st, like I said, you want your bank of Bob to be zero and you do that by transferring the balance to owner investment. But there's also another step when I'm doing my year end review. Other taxes are all filed and everything is all hunky-dory.

12:28One of the last things that I do to close the year is I zero out those owner equity buckets. I'll take a look at what's in the owner draws or distributions. Now, because it's the end of the year, when I'm looking at a balance sheet, and especially when it's a balance sheet that's year over year over year, I want to see what they drew out on an annual basis and just naturally your owner draws and your owner contributions grow over time, just year over year over year because they accumulate. But it's really helpful for me to be able to see this year they took out way more than they did last year or maybe they made less on their owner contributions. So I really like seeing them happening. So what I basically do is on January 1st of the following year, you zero out those distribution and contribution accounts. We don't do it on the 31st because then everything would be zero and you wouldn't have anything

13:32to compare. So we do it on January 1st and then that way it resets for the next year. Now I take whatever is in the distributions account and I move it to retained earnings. And whatever is in the contributions account, I move it to retained earnings because your retained earnings is the cumulative of all of the money that the company has earned. But if the owner has put in some money or taken some money out, it directly affects that retained earnings. So basically what it looks like is let's say it's my owner draw, then I'll credit the owner draw on January 1st for whatever the total was on December 31st and I'll debit retained earnings. And if it's the contributions, it goes the reverse, it goes the reverse, I will debit the contributions and credit the retained earnings. Now if you really want to go deep into this topic, I have a whole class on it in my

14:32accrual accounting class. But I did mention what happens with different entities, sole proprietors and LLCs and partnership. So it would be kind of unfair to leave you hanging without, without talking about it. So as I mentioned, when you're doing these clearings at the end of the year, if it's just a sole proprietor, you can close straight to retained earnings. Really, they have no retained earnings. It's just owner equity because a sole proprietor is the company and the company is the sole proprietor. If it's an LLC or a partnership and you have multiple members, then you would distribute these draws and investments out according to their percentages. So if they were lump sum together, like I mentioned earlier, you're better if you have multiple members to actually put each person's distributions with that individual person and then just compare it to the ratio that they're supposed to have and then true it up. And then if it's an escort, it's just retained earnings, it's just what it is.

15:37Now while I'm talking about Bank of Bob, I should probably talk about bartering as well because I find a lot of that bartering is when you're trading goods or services with a client. It might be business to business where you're trading business services. It could be you're providing bookkeeping and they are paying you with chickens. So there's a business in a personal and it could be them doing the business service for your business, but you're paying them with something personal. Like maybe you're an artist and you give them a piece of art. The thing with bartering is that it is business activity and it does count as income and it does count as tax deductions. And if you are doing it under the table, you may think to yourself, oh well, I'm keeping it off of my books, but that's actually a red flag. That's technically illegal. Not only does it flag you with the IRS indefinitely, but it also means that you're under valuing

16:39your income and your company in general. So let's say you were applying for a bank loan, you would want to see that total income that you would have earned. And when you're finding your taxes, of course, you want as many deductions as possible. And bartering is also 1099able as well. So you're still paying and getting paid. It's just not with legal tender, it's with other trades and services. So as far as the how to do this in QuickBooks, if it's a straight trade, you can just do this through a zero dollar check or a zero dollar sales receipt depending on whether you are receiving the income or the or incurring the expense. And so basically you put in the expense as, let's say you're doing it as an expense, you would put in the expense as normal. And then you would subtract the income category or the product or service that you're trading for. And then a negative expense is income.

17:42So it works perfectly well. Or if it's a customer and you are providing services for the customer, but they are paying you with their services, you could do the same thing with the zero dollar sales receipt where you're tracking the product or service that they are getting from you. And then you subtract your expense category. Now you do have to make a product or service that is double-sided, meaning it can show up as an expense in order for it to work. But if you subtract an expense on an income category, then you incur that expense. So it works really, really nicely. If either side is personal, you would use owner draw or owner investment as the offset. But having a zero dollar sales receipt or a zero dollar check means that the income and the expense are included on all of the different reports. So it works really nicely. Now, all of that works really well if the barter is just straight across. But what if there's an unequal value and there's several activities involved, then doing

18:46it in your memory gets really, really complicated and really hard to ever know who owes who. And so what I do is I create in my QuickBooks a bank account called barter clearing. So it's kind of like bankable, but it's just for the barters. When you are doing it this way, you do need to use a customer and not a vendor because the reports only work on the customer side. And it doesn't matter if you are having an expense with the customer that parts totally fine. I also create a payment method in the payment methods list for bartering so that I can track them that way as well. Then what I basically do is incur the income as normal and deposit the sales receipt into the barter clearing account or I would incur the expense as normal and put the expense in the clear as being paid by the clearing account. And then that way you can see their exact balance. You can even run a report drilling into the balance sheet into the barter clearing and

19:50see all of the barters. And then when they're equal when the money in and the money out are satisfied, then it equals zero. So I do this, this extra little trick that after a barter is finished, I'll reconcile the barter clearing account and all the money in and all the money out, all of the trade offsets each other and equals zero. And then in that report, I actually filter the report so it only shows me transactions that are not reconciled. So you find filter and then you do status and you say not reconciled and then you see all of your current open barters and the ones that are complete fall away. So it's a very elegant solution. Those were some big topics in the royal wise owls for the last few weeks. The bartering section is in my class called tricky situations. And Bank of Bob is in my class called a cruel accounting. Both of those are three to four hour classes with like everything about all kinds of these

20:54complicated situations. But I thought I would share some of these takeaways with you because the Bank of Bob in particular really, really, really makes it easier to manage all of those personal, personally paid expenses. If you're interested in seeing it all in action with actual demos of how to do these things, definitely check out the classes and I will have the links in the show notes. This is Alicia Katz Pollock and I will see you in the next one. Hey there, this is Alicia. The unofficial QuickBooks Accountants podcast just surpassed 75,000 downloads. We've cracked the top 5% of all podcasts worldwide. And according to accountingpodcast.com, we're in the top three. We thank you for being a dedicated listener and sharing your favorite episodes with your colleagues.

21:55We also wanted to let you know about a few opportunities related to this podcast. First, we have a LinkedIn group where you can discuss our episodes. And we have a YouTube channel, which is particularly helpful when we're deep diving into QuickBooks features so that you can see what we see. The links to both are in the show notes. And of course, you can just search for the unofficial QuickBooks Accounts podcast on both LinkedIn and YouTube. If you would like to reach out to us directly, our email address is easy to remember. It's unofficial QuickBooks podcast at gmail.com. We love listening to mail and we might just read your letter on the air. Third, did you know that you can get CPE for listening to our podcast? Head over to earmark.app, answer a few questions, and you'll earn CPE for each episode you listen to. Next, please do take the time to support our sponsors. If you hear an ad that solves a pain point for your practice, check it out by clicking the links in their show notes. You'll get special offers and keep our show going long into the future.

22:55And last, don't forget to click that subscribe button wherever you listen to podcasts. With every new listener, our community grows, and so does our impact. With your help, we're not just learning about software. We're reshaping the future of accounting. This podcast is independently operated and is not affiliated with or endorsed by QuickBooks or Intuit Inc. Many reference to Intuit and QuickBooks products are made solely for the purpose of discussing the topics related to the company and its software.