I'll bet that made a difference to your total sales and profit. Does everything reconcile now? Check out my video on the balance sheet and month end to be sure that your books are accurate. Thanks for reaching out!
The client I serve switched invoicing software mid year in 2023. Not all line items in the Bank Deposit screen were matched to payments. A journal entry was made to "compensate" for the dollar difference. Now, the transactions are still in Bank Deposit and the journal entry is on the Bank Deposit screen as well. This video is very helpful.
I am so pleased it was helpful! You may be able to offset the journal and the transactions to make a zero dollar deposit. That would give you a nice clean deposit page! Hope that makes sense :)
Hi Jennifer, I am not sure I understand - payments to invoices? Or payments out of the account? If it is a payment from the customer, why is it incorrect? Feel free to book a session to look at together! calendly.com/kerry-11/one-hour-consultation-us
Hi and thank you for this video. Can you please tell me the GL accounts affected when undeposited funds are "deposited". I'm not sure that makes sense but I'm trying to understand which accounts in the GL are affected by this process. Thank you kindly and your videos are amazing.
Hi! Undeposited funds is reduced, and the bank is increased. The funds go from the undeposited funds account (with a credit) to the bank account (with a debit) hope that helps!
Hi, I’m currently having an issue getting my sales receipts to categorize as Cost of Goods Sold; therefore, the only option I have is to send it to Undeposited Funds. How do I move my Undeposited Funds to my Cost of Goods Sold? Here’s what I’m doing. There will be a deposit made to the bank account which will then show up in my bank feed. I create a sales receipt, match that with the deposit. This is where I need it to go to the Cost of Goods Sold account. Am I doing this correctly? Thank you!
@@joannajimenez8848 Hi JoAnna - are you selling inventory? If so, then you would set up the product or service to remove an item from inventory to cost of goods sold when you sell it. You can use either the bank account or undeposited funds to match to the bank feed. It is in the product section that you can ensure that the sale (and if it is inventory) cost are properly allocated. I hope that points you in the right direction! If not, let me know.
Yes, I am selling inventory- the inventory is cattle, so we do not track them by item per say. We usually just create a check when cattle is purchased, match that to the check in the bank feed and categorize that as inventory asset. Then, when a check is deposited for sell I create a sells receipt to match the deposit and I was hoping from here I could categorize this in COGS. Should I be handling this differently? Thank you for the advice.
@@joannajimenez8848 Hi JoAnna, when you sell the cattle you need to remove it from inventory and add an expense to cost of goods sold. You could do this using products and services. ua-cam.com/video/Oxew4w0AN7Q/v-deo.html or ua-cam.com/video/lRzk0C-xXo4/v-deo.html I hope that helps! If you would like to book a working session to look at further you can do so here: calendly.com/kerry-11/one-hour-consultation-us Cheers!
I have a question, if you move old Und Funds to bank clearing account and then record as sales, does that not overinflate the P&L and would then affect Corporate Tax Payable?
Definitely! You have to be very careful correcting old undeposited funds if you are not going to investigate and adjust for what went wrong in the first place.
I am using the first for 2022 pre taxes and 2nd to clean up 2021 filed taxes. thank you this was very helpful! I would like some videos on after the fact bookkeeping please.
Thank you so much for letting me know! Can you be more specific about what you would like to know more about? Are you a bookkeeper or a business owner? I would love to make some videos about catch up work!
We are cleaning up our cash account inQB, we have balance in books but no physical cash left as we didn’t record everything, now we have to write that off, do you have any suggestions on this.thanks
You could post it to an expense account of some sort - cash over/under would be one I suggest - unless you have an idea where the cash was spent? I hope that helps!
Hi Susie, there are so many factors to consider here I can't give you an accurate response. If you would like to book a session we can look at this together and I can be sure that I fully understand your situation. calendly.com/kerry-11/one-hour-consultation-us K
HI Gary, yes I do! You can book a time here: calendly.com/kerry-11/one-hour-consultation-us. I can look at your QBO with you, and make sure everything looks okay, and help you to find the most effective way to do things in your business! I hope to see you :)
Thankyou for this video. My problem is a little different I think. I am running QB for monthly homeowners levies and when I started at the beginning of this year, I was inserting payments manully. (This was due to people doing deposits without enough information so I couldn't allocated the payment correctly). Now i have loads of uncleared payments. If I go in and allocate them at this late stage, won't it affect the balance on their invoice? i.e. If I'ved added a monthly value of 350 and then match the payment on the bank statement, won't it reflect that they've paid 700, when in fact it's only been 350?
Hi Lucia, it sounds like you need to go back and apply the payments differently to the invoice and then match them to the deposits. Is your bank balance completely different to what's in QuickBooks? Did you see I offer a course to help you step by step clear this up? That may help. do be careful, as you've identified you don't want to affect the balance of the invoices. If you would like to book a working session you can do that too: calendly.com/kerry-11/one-hour-consultation-us good luck!
My situation is that I have two payments processed as paid through Quickbooks Online, however the funds were never received and therefore not deposited. Can I simply reverse the payment by deleting it?
Hi! I would investigate further before deleting anything. If the payments were collected and not deposited that would be highly unusual - unless there is an error in your bookkeeping I would reach out to determine why you were not paid the funds that were collected.
I am working with a non-profit in which their QBO has never been reconciled and had a lot of old undeposited funds so I created a "dummy bank account" I like your "right way of cleaning it up" so my question is how do I reverse the "dummy bank account" to put undeposited funds back?
Hi, if you created a dummy account it sounds like you went with the second option. If that is the case check out the steps at 9:10 to create an "expense" to clear the dummy account. It won't put the undeposited funds back if you have cleared them. If you no longer want to use the dummy account, and want to go back and properly classify, then you could delete the bank deposit you created into the dummy account - does any of this make sense? I hope I have answered your question! Cheers
So I see some undeposited funds from past dates that have already been reconciled. So my question is: If I do the first method to clear them up, would this put my books out of balance?
How have they been reconciled if they are sitting in Undeposited Funds? To have gone into the bank they would have cleared the undeposited funds account. Unless they have been recorded twice? I am not sure! If they are only undeposited funds - not sure what they would be reconciled to - so my answer would be - most likely not! You will be changing your results to clear them up - so how far back are they? Hope that helps :)
Please help, I just started working at a company that is so far behind with their quickbooks bookkeeping. I'm creating invoices and back date them with payments for the jobs which the checks are already deposits into the account but now since I applied payment to the invoice that I have created is in the undeposited funds so what should I do in this case.
Thank you! What would you do if it is an old undeposited funds recording for a check received (from 2021 in my case) that never ended up being deposited into the bank account. This was before I started with the company - they recorded the check into Undeposited Funds when they received it, but then for who knows what reason, they never deposited the actual check so the funds never hit the bank and it is just sitting there recorded in Undeposited Funds.
Hi! You need to look at where the opposite side was posted - was it to pay an invoice - that invoice would actually be unpaid, or was it directly to income, you would need to reverse that in a current year or you could mess up a prior year tax filing. Does that help?
question. What if you already categorized the income without matching it to the invoice and now you you are trying to match the payment to the invoice, but you can't find the invoice because when it was first received it was received with other invoices so the amount is bigger now. how can i find the invoice and attach an undo the deposit from when it was first received and now attach it to the invoice. PLEASE!!!!!!!!!!!! NO OTHE R PERSON HAS THIS VIDEO.
This is a common error, and can take a while to untangle. I have created a course to walk you through the steps: learn.mycloudbookkeeping.org/finding-fixing-duplicated-transactions-quickbooks-online that may help. You could also book a session: calendly.com/kerry-11/one-hour-consultation-us and we could look at together. It is not something I can give a quick response to unfortunately! Good luck getting it all cleared up. Until you sort it out your numbers will not be reliable.
I have a client that uses a payment called Jobber. For some reason in the undeposited funds there is "Invoice" where payment should be. Why is this the case?
I accidentally imported two months' worth of deposits (through sales receipt import) and now they are sitting in my bank deposits, but are duplicate entries. I need to delete the duplicates, but am not sure how best to do this. I I have about 200 entries I must delete. Is the only way to do this to open each one individually and delete them? Is it better to void them? Thank you!
Hi Jeff, how horrible! If you know for sure that they are duplicated you can delete them, and not void them. If you view the transactions in the bank register you may be able to select "delete" without opening the transaction, and also see the duplicated entry alongside to ensure that you are deleting a duplicate. Let me know if that works! Good luck :)
@@buildingbybrihandymantrees1318 it shouldn't be any different based on the type of computer - you go to Taxes on the left hand side, and all the sales tax information should show up.
This was so very helpful! Thank you for this video. What I've done was debit the sales and credit the undeposited clearing account.
I'll bet that made a difference to your total sales and profit. Does everything reconcile now? Check out my video on the balance sheet and month end to be sure that your books are accurate. Thanks for reaching out!
The client I serve switched invoicing software mid year in 2023. Not all line items in the Bank Deposit screen were matched to payments. A journal entry was made to "compensate" for the dollar difference. Now, the transactions are still in Bank Deposit and the journal entry is on the Bank Deposit screen as well. This video is very helpful.
I am so pleased it was helpful! You may be able to offset the journal and the transactions to make a zero dollar deposit. That would give you a nice clean deposit page! Hope that makes sense :)
Thanks!
My pleasure!! Delighted I could help 😀
Thanks for giving an overview directly on screen
My pleasure! Delighted to be able to help!
Great video. Thank you! What if you have deposits that also appear (incorrectly) as payments? What is the problem there? Exact amounts same customer.
Hi Jennifer, I am not sure I understand - payments to invoices? Or payments out of the account? If it is a payment from the customer, why is it incorrect? Feel free to book a session to look at together! calendly.com/kerry-11/one-hour-consultation-us
Hi and thank you for this video. Can you please tell me the GL accounts affected when undeposited funds are "deposited". I'm not sure that makes sense but I'm trying to understand which accounts in the GL are affected by this process. Thank you kindly and your videos are amazing.
Hi! Undeposited funds is reduced, and the bank is increased. The funds go from the undeposited funds account (with a credit) to the bank account (with a debit) hope that helps!
Thank you! Very informative. Grateful you are sharing your intelligence! Learned A LOT!
Fantastic! Thank you for letting me know!
I would love to hear which method you chose and why! Also, how much did your income change after this clean up?
Hi, I’m currently having an issue getting my sales receipts to categorize as Cost of Goods Sold; therefore, the only option I have is to send it to Undeposited Funds. How do I move my Undeposited Funds to my Cost of Goods Sold?
Here’s what I’m doing. There will be a deposit made to the bank account which will then show up in my bank feed. I create a sales receipt, match that with the deposit. This is where I need it to go to the Cost of Goods Sold account. Am I doing this correctly? Thank you!
@@joannajimenez8848 Hi JoAnna - are you selling inventory? If so, then you would set up the product or service to remove an item from inventory to cost of goods sold when you sell it. You can use either the bank account or undeposited funds to match to the bank feed. It is in the product section that you can ensure that the sale (and if it is inventory) cost are properly allocated. I hope that points you in the right direction! If not, let me know.
Yes, I am selling inventory- the inventory is cattle, so we do not track them by item per say. We usually just create a check when cattle is purchased, match that to the check in the bank feed and categorize that as inventory asset. Then, when a check is deposited for sell I create a sells receipt to match the deposit and I was hoping from here I could categorize this in COGS. Should I be handling this differently? Thank you for the advice.
@@joannajimenez8848 Hi JoAnna, when you sell the cattle you need to remove it from inventory and add an expense to cost of goods sold. You could do this using products and services. ua-cam.com/video/Oxew4w0AN7Q/v-deo.html or ua-cam.com/video/lRzk0C-xXo4/v-deo.html I hope that helps! If you would like to book a working session to look at further you can do so here: calendly.com/kerry-11/one-hour-consultation-us Cheers!
I have a question, if you move old Und Funds to bank clearing account and then record as sales, does that not overinflate the P&L and would then affect Corporate Tax Payable?
Definitely! You have to be very careful correcting old undeposited funds if you are not going to investigate and adjust for what went wrong in the first place.
Thank you so much! This was very helpful!
My pleasure! Thank you so much for letting me know!
I am using the first for 2022 pre taxes and 2nd to clean up 2021 filed taxes. thank you this was very helpful! I would like some videos on after the fact bookkeeping please.
Thank you so much for letting me know! Can you be more specific about what you would like to know more about? Are you a bookkeeper or a business owner? I would love to make some videos about catch up work!
We are cleaning up our cash account inQB, we have balance in books but no physical cash left as we didn’t record everything, now we have to write that off, do you have any suggestions on this.thanks
You could post it to an expense account of some sort - cash over/under would be one I suggest - unless you have an idea where the cash was spent? I hope that helps!
Thanks a lot, it is helpful and confirms that we are thinking in same lines.
@@meghakamra3855 Wonderful!!
How do you void those uncleared checks and if all your other account are reconciled will it affect those
Hi Susie, there are so many factors to consider here I can't give you an accurate response. If you would like to book a session we can look at this together and I can be sure that I fully understand your situation. calendly.com/kerry-11/one-hour-consultation-us K
I don't see the link for the finding and fixing duplicated deposits and or undeposited funds that are also doubled up
Thanks for letting me know, here's the link: learn.mycloudbookkeeping.org/finding-fixing-duplicated-transactions-quickbooks-online
Thank you so much for sharing.
My pleasure!
Do you offer any type of paid QBO training? The new company started in August 2023. Maybe look at my QBO, etc.
Thank you. Gary
HI Gary, yes I do! You can book a time here: calendly.com/kerry-11/one-hour-consultation-us. I can look at your QBO with you, and make sure everything looks okay, and help you to find the most effective way to do things in your business! I hope to see you :)
Thankyou for this video. My problem is a little different I think. I am running QB for monthly homeowners levies and when I started at the beginning of this year, I was inserting payments manully. (This was due to people doing deposits without enough information so I couldn't allocated the payment correctly). Now i have loads of uncleared payments. If I go in and allocate them at this late stage, won't it affect the balance on their invoice? i.e. If I'ved added a monthly value of 350 and then match the payment on the bank statement, won't it reflect that they've paid 700, when in fact it's only been 350?
Hi Lucia, it sounds like you need to go back and apply the payments differently to the invoice and then match them to the deposits. Is your bank balance completely different to what's in QuickBooks? Did you see I offer a course to help you step by step clear this up? That may help. do be careful, as you've identified you don't want to affect the balance of the invoices. If you would like to book a working session you can do that too: calendly.com/kerry-11/one-hour-consultation-us good luck!
My situation is that I have two payments processed as paid through Quickbooks Online, however the funds were never received and therefore not deposited. Can I simply reverse the payment by deleting it?
Hi! I would investigate further before deleting anything. If the payments were collected and not deposited that would be highly unusual - unless there is an error in your bookkeeping I would reach out to determine why you were not paid the funds that were collected.
I am working with a non-profit in which their QBO has never been reconciled and had a lot of old undeposited funds so I created a "dummy bank account" I like your "right way of cleaning it up" so my question is how do I reverse the "dummy bank account" to put undeposited funds back?
Hi, if you created a dummy account it sounds like you went with the second option. If that is the case check out the steps at 9:10 to create an "expense" to clear the dummy account. It won't put the undeposited funds back if you have cleared them. If you no longer want to use the dummy account, and want to go back and properly classify, then you could delete the bank deposit you created into the dummy account - does any of this make sense? I hope I have answered your question! Cheers
So I see some undeposited funds from past dates that have already been reconciled. So my question is: If I do the first method to clear them up, would this put my books out of balance?
How have they been reconciled if they are sitting in Undeposited Funds? To have gone into the bank they would have cleared the undeposited funds account. Unless they have been recorded twice? I am not sure! If they are only undeposited funds - not sure what they would be reconciled to - so my answer would be - most likely not! You will be changing your results to clear them up - so how far back are they? Hope that helps :)
Please help, I just started working at a company that is so far behind with their quickbooks bookkeeping. I'm creating invoices and back date them with payments for the jobs which the checks are already deposits into the account but now since I applied payment to the invoice that I have created is in the undeposited funds so what should I do in this case.
Have you tried "deposting" the payments? If you have correctly only recorded the payment once it should work.
Thank you! What would you do if it is an old undeposited funds recording for a check received (from 2021 in my case) that never ended up being deposited into the bank account. This was before I started with the company - they recorded the check into Undeposited Funds when they received it, but then for who knows what reason, they never deposited the actual check so the funds never hit the bank and it is just sitting there recorded in Undeposited Funds.
Hi! You need to look at where the opposite side was posted - was it to pay an invoice - that invoice would actually be unpaid, or was it directly to income, you would need to reverse that in a current year or you could mess up a prior year tax filing. Does that help?
How do you move CC payments or online QB payments from undeposited funds?
payments should be appear in undeposited funds. Undeposited funds is an option when you receive funds and have not yet "deposited" them to your bank
Would you happen to give lessons over the Internet?
Yes I do! Here is a link to my calendar: www.mycloudbookkeeping.org/training
question. What if you already categorized the income without matching it to the invoice and now you you are trying to match the payment to the invoice, but you can't find the invoice because when it was first received it was received with other invoices so the amount is bigger now. how can i find the invoice and attach an undo the deposit from when it was first received and now attach it to the invoice. PLEASE!!!!!!!!!!!! NO OTHE R PERSON HAS THIS VIDEO.
This is a common error, and can take a while to untangle. I have created a course to walk you through the steps: learn.mycloudbookkeeping.org/finding-fixing-duplicated-transactions-quickbooks-online that may help. You could also book a session: calendly.com/kerry-11/one-hour-consultation-us and we could look at together. It is not something I can give a quick response to unfortunately! Good luck getting it all cleared up. Until you sort it out your numbers will not be reliable.
I have a client that uses a payment called Jobber. For some reason in the undeposited funds there is "Invoice" where payment should be. Why is this the case?
without seeing it I am not sure. Is it possible that the invoice showing up has been "paid" into undeposited funds?
I accidentally imported two months' worth of deposits (through sales receipt import) and now they are sitting in my bank deposits, but are duplicate entries. I need to delete the duplicates, but am not sure how best to do this. I I have about 200 entries I must delete. Is the only way to do this to open each one individually and delete them? Is it better to void them? Thank you!
Hi Jeff, how horrible! If you know for sure that they are duplicated you can delete them, and not void them. If you view the transactions in the bank register you may be able to select "delete" without opening the transaction, and also see the duplicated entry alongside to ensure that you are deleting a duplicate. Let me know if that works! Good luck :)
Where do I find HSt owing on QB app
I don't know if you can do that from the app - I htink you would need to log into QuickBooks Online and look at sales taxes. I don't use the app!!!
@@MyCloudBookkeeping I know how on the laptop, but not on desk top
@@buildingbybrihandymantrees1318 it shouldn't be any different based on the type of computer - you go to Taxes on the left hand side, and all the sales tax information should show up.
@@MyCloudBookkeeping the app is completely different, platform, I wish you had so you could see
@@buildingbybrihandymantrees1318 I would suggest reaching out to QuickBooks support - they should be able to point you in the right direction.
what is your address to look at courses you offer.
Here is the link: www.mycloudbookkeeping.org/courses let me know if you have any questions, Cheers :)
Thanks a lot for video
My pleasure! I'm delighted it helped.
Chose the second option. Got a customer with lots of undeposited funds from 3 years ago. No one new why.
Delighted to help you clean them up :)