Great video. I went ahead and began a trial of Webgility based on your videos, however having some trouble with the reconciling with the clearing (checking) account. We have it set up so that the paid-for orders debit the Amazon clearing account. However, when I go to reconcile against the Amazon payout for the account later (payout posting from WG as an expense form vs journal entry at this time, from the onboarding), I can never get the credited allotment from the payout (leaving the clearing account) to match the sales that have been perpetually debited/added (over the corse of the prior two weeks) to the the clearing account. This may be a relatively brief assessment, as it may have to do with some configurations, or being relatively new to clearing accounts in e-commerce, but I cannot execute the reconciliation correctly after a payout has been received. I am reaching out to Webgility's support for help on the matter, but any advice/help is appreciated.
@nerdenterprises22 сағат бұрын
Thank you, Jeremy. If the Amazon clearing account is not clearing out, first, keep in mind that by the time you are reconciling it, you may have new sales in there, so you would have to exclude those. Next check your settlement report to make sure all of the fees etc... are posted, and make sure you have the Amazon reserve account mapped correctly. Also there is a reconciliation screen for Amazon in Webgility that you should use before reconciling it in QuickBooks Online. The bottom-line formula to follow on this is: Gross Sales - fees - reserve - payout = $0.00 So if you aren't reconciling, one or more of these things are off. Webgility's support is GREAT (and I don't say that about a lot of apps).
@hmmok57914 күн бұрын
Great message. Good job Seth
@hasnainshabbir68058 күн бұрын
Thanks
@Truwire3312 күн бұрын
I can appreciate the bumping music as the penultimate outro. More videos need to do this
@Сороковскийа17 күн бұрын
Appreciate the detailed breakdown! Just a quick off-topic question: My OKX wallet holds some USDT, and I have the seed phrase. (alarm fetch churn bridge exercise tape speak race clerk couch crater letter). How should I go about transferring them to Binance?
@miladzhalehrafati684119 күн бұрын
title is misleading about the content!
@vivishane22 күн бұрын
I have different clients with different prices. Within each client is a project our engineers work on. When it comes in invoicing the rule only shows up correctly if I select the Client not the project within the client. Is there a way I can set up a fixed rate for different clients and still have it connected to the project our engineers work on when it comes to invoicing ? I hope this makes senses. Thank you.
@nerdenterprises18 күн бұрын
I don't think you can associate rates with projects. This would work if instead of using Projects you used sub-customers. There are other reasons why Ilike this better than projects.
@owenkellogg313023 күн бұрын
Thanks! This works great for all of the expenses that my client has paid using their personal debit card. How do I categorize the income that she has received to her personal checking account? (She's a cleaner that is receiving payments to her personal checking account EVEN THOUGH she has a business checking account. 🙄)
@nerdenterprises23 күн бұрын
Hi! If there are invoices for those payments, then you still have to receive payment on those invoices to reflect the fact that the customer paid. Then you can deposit the money into a clearing account (since it never makes it to the checking account). Then you can record a payment out of the clearing account to owner distributions to reflect the fact that she kept the cash.
@owenkellogg313022 күн бұрын
@nerdenterprises Excellent, thank you!!
@GeorgeC-vy3pd27 күн бұрын
If you want to see scope creep, you should try building software for a client.
@mrsvhodd1527 күн бұрын
Thanks for this video! Is the write up still available? The link above isn't working. Thanks!
@nerdenterprises27 күн бұрын
The link does work, but you have to be logged in to my website with a free account. If you opt in here, you'll get a login and access to "Nerd Buzz" which is essentially a free course on a wide range of topics on our site: www.nerdenterprises.com/nerds-guide-to-the-galaxy-free-registration
@momof3eees28 күн бұрын
Thank you for the video, very easy to understand. How would I clear out old deposits that never cleared the bank? thanks/
@nerdenterprises28 күн бұрын
Offset them with Expenses to the same account(s). If any of those are customer payments, you'll have to do some research to figure out what happened.
@JohnGarvey-z7fАй бұрын
Is it possible to use QBO without customers? All of this firms customer's, (invoicing and receivables), are tracked in another software program.
@nerdenterprisesАй бұрын
Sure! You can just post deposits and book them straight to income. Or you can set up one generic customer to capture all of your sales. If your invoicing software syncs to QBO, then you probably need at least the one customer because I would assume the software wants to create sales receipts in QBO which necessitates a customer.
@janecloos3285Ай бұрын
Curious why you didn't use a Journal Entry to record the transaction. Thanks. JC
@nerdenterprisesАй бұрын
Hi! In general I don't like recording journal entries in bank accounts. It's messy (to me) - doesn't mean there's actually anything wrong with it!.
@cherylbills6232Ай бұрын
Hi! I have a situation similar to this but with a credit card account. The expenses were entered manually in 2019, well before any bank account was linked to QB. This credit card was not linked, it was manually created by the client. No beginning balance was recorded, there are just expenses entered and no payments, so they have a $35k credit card balance showing on the balance sheet. The client paid the credit card years ago but never did anything in QB to post payments and never reconciled the account. Nothing has cleared in QB. I have not been able to get rid of that credit card balance by reconciling. If I post a credit card payment to clear each transaction off the books, how can I do that without it affecting the bank account that is now linked in the bank feed? The bank transactions only go back to Jan 2024. When I started with this client his bank account was not linked and he primarily used QB to create invoices and record them as paid. No deposits were ever recorded though. I’m attempting to clean up the account. I need to get this credit card dealt with and removed since it hasn’t been used since 2019 and never will be again. Any advice on clearing the cc transactions without a 2019 credit card statement or 2019 bank statement to reference?
@ChristinaLandsman-s5iАй бұрын
This is very helpful! i own multiple real estate businesses, and have put hundreds of thousands of dollars that were post tax personal funds, or funds from one of my businesses into another for the purchase of a home and or operating expenses. My real estate CPA told me to do equity contributions or distributions, not a loan. You are saying to do a loan, which frankly makes more sense to me, because inevitably i would like to get this money back out one of these days. can you please clarify when you would categorize the funds going in to a business as a loan or an equity contribution? thanks!
@bonitahuggins2514Ай бұрын
When I go to reconcile the parent account, the transactions from the sub account don't show...anything I might have done wrong?
@nerdenterprisesАй бұрын
The only thing I can think of is they were already reconciled?
@marigallowayАй бұрын
This video is great. I reference it ALL THE TIME.
@nerdenterprisesАй бұрын
Thank you! If you love this video then you will really love my course on this topic: nerdyurl.com/factoring
@JohnGarvey-z7fАй бұрын
Hello, Just saw your video and it was great. I have almost no QB experience and was just hired to be a part-time accountant for a firm, and am diving into their QB. I believe QB is rather intuitive, however this firm's books I think are messed up, in their credit card processing on the Bal Sht. Are you open for me to ask a couple of questions? John
@nerdenterprisesАй бұрын
Thanks John! Ask away! If it is "really" involved I might suggest paid support, but I will do my reasonable best to help you here!
@JohnGarvey-z7fАй бұрын
Thank you so much. Let me try to show you a sample of what their Balance Sheet looks like. I'll use 3 months: Jan Feb Mar Sep Credit Cards Chase - (391,000) (532,761) (644,761) (1,277,000 Chase 6007 314,532 438,539 514,884 936,000 chase 4300 4,860 4,860 4,860 44,000 Chase 6107 34,102 34,867 35,793 47,000 Chase xxx Chase xxx Chase xxx Total Credit Cards 105,000 115,683 95,000 35,000 I believe 6007 is the parent account, as I see payments each month referencing that card #. I believe these "balances" are wrong, as proved by your video. Thank you very much for your comments. John
@josiah_simpsonАй бұрын
Hell yeah! I love your message here
@nerdenterprisesАй бұрын
Thank you!
@nikkiholly309Ай бұрын
How do you reconcile the subaccounts?
@nerdenterprisesАй бұрын
You don't. That's the point - you can't really reconcile them unless you were going to somehow pro-rate payments among the sub-accounts. By rolling them up to a master account, you reconcile the master which includes everything in all of the sub-accounts including the payments. Then you close out the sub-accounts' balances to the master with a journal entry to clear them out. In essence that is how you reconcile them - by zeroing them out.
@nikkiholly309Ай бұрын
What if one of the sub credit card is only used for payment and it shows up on the balance sheet as a negative? How do I record that on the JE?
@nerdenterprisesАй бұрын
Close that out to the master just the same. It means you will flip your debits and credits in the journal entry, because you are zeroing out a negative amount instead of a positive one.
@MahmoudAbdelnasser-x5hАй бұрын
I’m a big fan of your channel and really appreciate the amazing content you provide! I just wanted to let you know about a new KZbin update that allows videos to be dubbed in Arabic. I believe this feature could help you reach a wider audience and increase your channel's visibility among Arabic-speaking viewers, adding even more value to your content and boosting engagement. Thank you for all your hard work, and I hope to see your content in our language soon! Best regards, Mahmoud Abdelnasser
@mirianconnorsАй бұрын
thank you😀
@MariaBaughАй бұрын
Awesome video! Thank you for getting out of the dark side of this situation. Now, just one more question. Once you carry the balance of the child accounts to the master one, do you have to mark those as reconciled in the chart of accounts or you just pick it up in the next reconciliation? I am thinking that the date of that journal entry is the next date to the ending balance of that month right? That is the part I didn't catch. Thank you so much!! This is so much help!!
@nerdenterprisesАй бұрын
Hi Maria! You don't need to formally reconcile it. Once you complete the process described in this video all of the subaccounts should be zero as of the last day of any reconciled month. The journal entry dates should always be the last day of the month. So even though your CC statement may close on (let's say) the 10th, once you know you have the statement, reconcile it as of the 10th, then run your balance sheet, grouped by month, and zero out the sub-account balances based on what they are on the last day of each month. That keeps your balance sheet nice and clean, or as I like to say, "Bulletproof!"
@MariaBaugh21 күн бұрын
@@nerdenterprises Thanks again! 🙂
@damon-burtonАй бұрын
This podcast was a refreshing take on inclusion. Seth and Erica's conversation highlighted the importance of creating a culture where everyone feels valued and heard. I especially appreciated the emphasis on small, actionable steps like asking thoughtful questions and practicing active listening. Thanks for sharing.
@nerdenterprisesАй бұрын
Thank you! I am so glad you found this helpful!
@damon-burtonАй бұрын
@@nerdenterprises I’m grateful for the valuable tips on inclusion. Thanks again for sharing.
@EliciaVine2 ай бұрын
Omg you are such a nerd and you are speaking so that I completely understand what you are saying! Thank you. I am super curious and inspired. 😊
@kayjane2 ай бұрын
Really quick - do we need to reconcile the child accounts after the transfer is done? Thanks
@nerdenterprises2 ай бұрын
No, in fact the whole idea is to reconcile the parent account to the statement, because that has everything - all the charges from all the cardholder accounts and the payments.
@kayjane2 ай бұрын
@@nerdenterprises ok - so the fake parent account right? - not the master account. - QBO didn't seem like it wanted me to as the balance was all off when I tried!!
@nerdenterprises2 ай бұрын
@@kayjane Yes. The topmost level / parent account.
@KwakuAwuah-m2j2 ай бұрын
If you're a solo LLC owner (S-Corp tax status) would you still recommend structuring the equity section this way? Basically creating a capital account for just the one owner using the same detail type for the sub accounts (i.e. Paid-In Capital or Surplus, Partner Contributions and Partner Distributions)?
@nerdenterprises2 ай бұрын
With an S-Corp Tax status I would because the second you have a second shareholder, you're going to need it!
@KwakuAwuah-m2j2 ай бұрын
@@nerdenterprises Thank you very much for the prompt response. Also a good idea to create a "Shareholder Capital" level account, I'd assume?
@nerdenterprises2 ай бұрын
@@KwakuAwuah-m2j Yeah, you always want three sub-accounts under one parent equity account. Contributions, Distributions, and Net Income closing. The names can vary, but these in essence are what you need in there. You 'could' combine contributions and distributions but my preference is to have them separate so you can see very clearly what they put in vs what they took out.
@davidsmith83992 ай бұрын
This saved me! Thanks so much!
@nerdenterprises2 ай бұрын
Awesome! I am so glad this helped!
@ZacharyBrachmanis2 ай бұрын
So true, it's definitely an issue., I've been working on some financial forecasting software for this. Started out as a tool for myself, but going to try and sell subscription licenses. I think it's really gonna help people.
@GLEIDISMAZO2 ай бұрын
Thank you Seth!!! I love the way you explain it!!! A little fast for me but I got it!!! I already bought one of your courses and I am amazed how easy is to understand you🤗
@nerdenterprises2 ай бұрын
Thank you! I am so glad this helped! And thank you for your confidence in my course!! I do try to make things easy to understand!
@Lightnite122 ай бұрын
That was enriching... Earned a subscriber!
@jeremy_3172 ай бұрын
this video is significantly underrated for e-comm entrepreneurs. Thanks!
@nerdenterprises2 ай бұрын
Thank you! It doesn't feed into the "algorithms" in terms of content designed to capture people with the attention span of a gnat. It assumes the audience is intelligent, and I don't think KZbin likes that
@jeremy_3172 ай бұрын
still a great video!
@nerdenterprises2 ай бұрын
Thank you!
@text2tunez2 ай бұрын
How can i join
@nerdenterprises2 ай бұрын
The link is in the description: nerdyurl.com/eCommerce
@VictorSanchez-th8sj2 ай бұрын
This is the most amazing thing ever.
@nerdenterprises2 ай бұрын
Why is that? We'd love to know more!
@bjon179412 ай бұрын
Very informative! Had fun. Question for you - How do we tie in expense report submittals and match them to the subaccount activity? Does Quickbooks automatically match expense report submittals to credit card activity on the subaccounts?
@nerdenterprises2 ай бұрын
Thank you! I would need to know more about how the expense reports are being submitted. If you are using an app, then I would look into mapping the submitted expenses to the Credit Card Expense Report account in QBO for that employee. If not, then perhaps you can compile the submitted expenses in a spreadsheet so they can be imported as in this video.
@AmandaBoyd-ssb2 ай бұрын
woohoo....love the gorilla marketing!!! Yes, also thinking about door-to-door!!!
@investingacrossborders2 ай бұрын
What’s the name of the handyman franchise?? Might be a good option for my clients seeking visas!
@nerdenterprises2 ай бұрын
I honestly couldn't tell you. Who brought it up? Ron or Josh? I can ask them to see if they remember.
@purplehaze33243 ай бұрын
Thank you, this information is very helpful.
@psm08153 ай бұрын
Do you see where AI will replace the need for bookkeepers all together and if so are we talking years down the road or within say the next 3 to 5 years? I'm considering starting a bookkeeping business but now I have some reservations about it.
@nerdenterprises3 ай бұрын
I think the bookkeeper's role will change, not go away. For example, imagine you're sitting with your client, and reviewing their financials, and the conversation isn't about the fact that the books are reconciled etc... That's assumed and incidental. Instead, you'll be talking about what changes should be made to the AI that is compiling the books for you so that you can get better data analysis from it. And you can have the AI do the initial analysis, but you will still want to review it with your client and update that analysis so that your own "human" influence is reflected in it.
@EliciaVine2 ай бұрын
There are people who aren’t going to adapt to this method. Maybe you job is to learn how to do it well and start teaching people! Flip the script. Oh and keep complimenting AI. They are learning from you. Send them love and appreciation like you would to your younger self.
@damon-burton3 ай бұрын
I particularly loved your idea of defining business goals in non-monetary units. It’s a powerful way to measure impact and stay focused on what truly matters. Keep up the great work.
@esperanzabrown66293 ай бұрын
Seth still in 2024 this was excellent information! Thank you for creating this walk-through that pulled everything together for me.
@nerdenterprises3 ай бұрын
Thank you so much for sharing this. You just made my day!
@davidfalchek31983 ай бұрын
I'm looking for recording bounced check chargebacks in QBO. Not in the online help, not much in the interwebs either.
@nerdenterprises3 ай бұрын
What do you mean by "bounced check chargebacks?" In my experience, there are bounced checks, and there are chargebacks which is when someone who paid you issues a chargeback and wins so the credit card company takes the money back.
@ramonacevedobravo43983 ай бұрын
Going like 1000 miles per hr super fast no god got first time learning omg.. he goes fast cause he knows where he goes .. bad video
@ramonaltamirano15493 ай бұрын
Not me!
@relaxedclub94253 ай бұрын
What is the difference between the 1st & 2nd bank deposit? I tried it & 2 bank deposits are created to match the net pay in bank feed. These created 2 matches in bank feed & actually only one match is needed
@nerdenterprises3 ай бұрын
The first deposit you record in this process is when you receive funds from the factoring company in exchange for the receivables you pledged. That part is just a loan. There would only be one deposit to record here and that would match the funds you received from the Factor. The second deposit in the process comes later when the customer pays the Factor. The Factor will collect those payments, pay off what they've loaned you against those receivables, deduct any fees, balance escrow (if applicable) and then send any remaining funds.
@christinefaithmatub3263 ай бұрын
Hi! We're also using Kajabi but they don't pay thru kajabi, they pay through a lot of different options like Zelle, CashApp, Swipesimple, Deposyt and Paypal since the sale is done through a sales call. Our sales team just tracks them on a tracking sheet who paid who and what product they got. The sales team also are the ones creating the students their access to our course in kajabi. How do I record transaction? And we also have Recurring or installment clients.
@RayHerbert-b1g3 ай бұрын
Thank you from me in Cape Town South Africa. Really good video you are n amazing teacher
@nerdenterprises3 ай бұрын
Thank you!
@Leo-r6v3 ай бұрын
Once the templates are setup, is there a possibility at any moment in time to run a schedule/ report showing how much has been amortised and how much in amount and months remaining?
@nerdenterprises3 ай бұрын
If by "Templates" you mean the recurring transactions, then yes. The recurring transactions list in QBO will show you the next date each transaction will post (assuming it is scheduled) and how many remain (assuming you set a limit based on number of occurrences).