cancel
Showing results for 
Search instead for 
Did you mean: 
SpacemanWill
Level 2

P&L report fails to add up deposits correctly

All 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!

5 Comments 5
MaryLurleenM
Moderator

P&L report fails to add up deposits correctly

Hello there, SpacemanWill,

 

You might want to check Banking if there are transactions under For Review or Excluded tab. Here's how:

  1. Click Banking on the left pane.
  2. Check the transactions under For Review or Excluded tab.

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.

SpacemanWill
Level 2

P&L report fails to add up deposits correctly

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.

IamjuViel
QuickBooks Team

P&L report fails to add up deposits correctly

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: 

  1. Go to the Sales menu.
  2. Choose the All Sales tab. 
  3. Select the Filter drop-down menu.
  4. From the Type drop-down menu, choose your desired transaction type and date.
  5. Hit Apply.
  6. Select the transaction.
  7. Click More and select Transaction journal.
  8. Check the posting account if it's an income account. 

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. 

SpacemanWill
Level 2

P&L report fails to add up deposits correctly

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?

SpacemanWill
Level 2

P&L report fails to add up deposits correctly

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!

Need to get in touch?

Contact us