When I review my bank deposits I categorize them as product sales, services, etc. but they don't show up when I run a report on income. Why do only sales receipts show?

Hello @benh100 :

Are you running in Accounts Receivable type report? When you post directly to income that’s not accounts receivable.

Or are you running a profit and loss report that’s on Accrual basis and the date range does not include the deposits to income?

lynda

Hi Lynda!  Thank you for the quick reply.  I'm afraid I may have really messed this up. Basically, I ran a Profit & Loss Detail report like you suggested and YEAH!! the income is showing there.  Everything is disorganized though and I have to pull out sales from different spreadsheets now to bring them over to a master spreadsheet for my accountant.  There has to be an easier way than what I'm doing.  My setup is this..

I have product sales and I do training classes.  I set up a class label for each so I can see where the income is coming from and also to track product sales that sometimes require sales tax.  Most of my sales are processed by PayPal online.  I have a chart of accounts for PayPal and when the sales are downloaded, I review them and give them the category of 'product' or 'training'.  That all works fine because when I put in the customer's name, it makes a Sales Receipt and it easily shows up in the All Sales tab and reports.  When I withdraw PayPal money to my checking bank account, I simply record the money as a transfer because I don't want it double counted as income and I've already accounted for it in the PayPal account. 

Here's where it gets tricky.  If I accept cash or checks and deposit them to the checking account, or use Venmo, Square, etc. that gets electronically deposited to the checking account, then it's going to just show up as a 'deposit'.  So when I review and reconcile my checking bank account, I choose the type of income it is (Sales of Products, Services, etc.) and then do the same thing as before and choose the appropriate class category.  But these transactions that are coming in directly to the bank aren't generating a Sales Receipt and so they don't show up in those reports.  Only PayPal sales are automatically making Sales Receipts.  Do I have to make a Sales Receipt for each and every customer first and then wait until the bank account downloads deposited transactions to try and match them up?  I'm so confused.  I don't know if it will allow me to match them up or if it will end up recording the sale twice (once is Sales Receipts and once in income where I see it in the Profit & Loss reports). 

All I want is to be able to have all my sales come up in once place and divided by class in one report.  As it is now, the Profit Loss report shows PayPal Sales as a separate section and it has a mix of my product and training income.  Then there's separate sections for Sales of Product Income and Training where the bank deposit transactions are showing up.  I hope this all makes sense because it's very confusing to me.  Thank you so much for your expertise!