Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowAll my deposits were imported from my bank. They all fall under the same "Sales" account and same payee. If I add them up manually, I get $18,281 for the month of December. The P&L report shows total sales as $9,421 for December. All other months are correct. I though maybe some deposits are being excluded, so I removed one at a time, running the P&L report each time to see how it changed total sales. All but 2 deposits reduced total sales by the expected amount. Two deposits reduced sales by less than the expected amount (off by $937). Still can't figure out where $8,860 in missing deposits went. Yes, I'm a newbie, but this is basic arithmetic! Please help!
Hello there, SpacemanWill,
You might want to check Banking if there are transactions under For Review or Excluded tab. Here's how:
If the transactions are still missing, they might not have been downloaded or cleared from your bank yet.
You can also manually upload the transactions: Manually upload transactions into QuickBooks Online.
Let me know if you need further assistance.
Thanks for the quick reply, Mary but it's not that simple. If I go to chart of accounts and open the register of my primary checking account, then look at the month of December 2019, I have $18,281.29 in deposits. They are all there as they should be. I've added them up manually and the total matches my bank statement. But when I run a P&L report, and show monthly's, it reports only $9,421 for sales deposits in December. All other months report accurately except December. There's nothing different about the December deposits that I can tell. They are all categorized under the Sales account, and share the same payee. Doesn't matter if they are bank verified or not. Spent 3 days trying to solve this mystery to no avail.
I appreciate the complete details you've provided, @SpacemanWill.
Some items on your transactions may not be categorized under the correct income account which leads to missing transactions on your Profit and Loss report. Let's review your sales transactions and make sure the correct income account is selected.
Here's how:
Also, you can review the income account associated with each item listed in the sales transactions. If the account is incorrect, you need to change the account for that product/service item.
You can use these articles to help you locate your income transactions are missing from your profit and loss report:
I'd be glad to continue assisting if you should have any additional questions. Wishing you and your organization continued success.
Problem solved!
I keep an account called "Cash for Till" which is cash withdrawn from checking to keep our till at $200/day. However, I wasn't recording daily till deductions in the form of cash back for money tendered, and tip payouts. Instead, I had foolishly made a payment from this account to my Sales account for the full balance at the end of the year. This was the $8,860 that was missing from my Sales account.
Like I said, I'm a newbie. I think my Cash for Till account needs daily debits for tips and cash back, but this adds a whole 'nother level of record keeping. Is this how it's suppose to be done?
Thanks, @IamjuViel I finally deleted all transactions for December 2019 and noticed the P&L sales for that month went to -8,860, the amount I was off! That led me to a deduction I made to my sales account (why didn't I look there first?) for that amount, which happened to be the balance of my "Cash for Till" account at the end of the year. I thought it should be zero'd out for the new year because I wasn't deducting that account for cash back for money tendered, and tip payouts.
As I said, I'm a newbie. Is a cash till normally treated as an account with daily deductions for cash back and tip payouts (I have a hair salon)? If so, that adds a whole 'nother level of maintanance to my accounting! Thanks again!
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.