I am a relatively new business owner, and have been managing the books myself. I own a small wine shop, running Square as a POS, and have the transactions automatically imported into QBO. A (real) bookkeeper helped me at the beginning with the workflow of matching the deposits and bill payments, and I have been reconciling the credit card and bank accounts every month with few issues. The undeposited funds account seemed to be humming along correctly as I matched transactions daily, so I sort of forgot about it.
However, I was recently poking around in the chart of accounts and realized it had been off by about $1600 for some time. I did some digging and found the biggest culprit was a duplicate sales receipt for $1392.92 that did not have an R in the bank feed column. I have hesitant to delete it, because I'm not really sure what the ramifications will be- there is no such duplicate in the bank account, but that month has been reconciled, and since my bookkeeping experience is pretty limited, I'm afraid of making an even bigger mess. Any suggestions?
Hey, @MirandaNMF1.
Welcome to the Community!
Based on the details you gave, we recommend speaking with an accountant to see what the best route would be to fix this problem within your QuickBooks Online account. They will advise you on how to adjust this properly.
Keep us updated on what they come up with and how they fixed it. I'm only a post away if you need me again. Take care!
If the sales receipt deposited the funds into your Undeposited Funds (UF) account, and you're sure this is a duplicate transaction, then you can and should delete it. Depending on what's on the sales receipt, your income is overstated and, if there are inventory items on it, then your inventory and COGS are off as well. Deleting the sales receipt should fix those discrepancies if you haven't already.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here