How do I get my Gross Sales or Total Gross Receipts received or deposited into my bank account or from Sales Receipts?

yes, income on the P&L does not include sales tax.

Sales tax is a payable when received and is not income to the company.  Basically you collect it, hold it, and pay it - nothing hits the P&L

"But this still does not include the Sales Tax amount. It includes only the amount deposited into the Bank Acct"

The one is the offset of the other.

Amounts Deposited are Because of Sales (income) + Tax collection (liability).

"Ok so here is what I did, I entered all my Sales Receipts into QB from an Event noting 'Payment Type' (ex. Cash, Visa, etc.)"

You just leaped over How you listed the Charges for Sales. The Sales Receipt uses item(s). These are linked to Income. They have a Tax Status. Or, for generic, then perhaps you are managing the Tax to a Liability account as an item you are controlling?

Look here for a method that Summarizes Sales:

http://longforsuccess.com/2011/09/20/daily-sales-summary-for-retailers-restaurants-ecommerce-and-mor...

Banking is the Destination of funds, but income + taxes is the WHY people are paying you. Items = what they paid you for, such as Event tickets, merchandise, etc.

Then, Payment methods are HOW they paid, such as checks and credit cards.

"and included Sales Tax amount"

If your total Generic Sales is Inclusive of Sales taxes, that is something you need to tell us you are doing.

Sales Taxes are handled as Liability when collected and clear that liability when you paid it out.

OR, you are tracking it as part of Gross Revenue, and the pay out of taxes will be Expense for you.

"all of which was setup to be deposited into 'Bank Account'. So now I am trying to get a report (really just a complete Total of Sales for that day/Event) to confirm I am not missing anything, which that total I will compare with the total I actually deposited into my Real Bank. I am checking my amounts, which is something I do after all Events, but QB seems to automatically not account for "Sales Tax Collected" "

You run a Sales Report and change the filter from All Sales items, or all Income/expense accounts, to ALL items and/or All Accounts (remove the Account filter). It depends on the Report you are using.

QB doesn't automatically include or not include anything. As long as the data is in the file, you run reports to view your data and analyze it. That means the right report for the specific data, with the specific options.

"which is cool to know and opens my mind to a diffferent way of tracking Sales Tax info and such, but doesnt really help me when reconciling old records that I am entering into QB. I'm new to QB and considering switching to it from Excel which has worked for me for 10+ years, but I like some of the other features available in QB."

QB is more powerful and the data is a true relational database, as Compared to Excel, which is more like a listing.

For example, your Customer Name on the Sales Receipt can be your Event Name, so that Sales reporting gives you comparisons across all of your events. And, the Costs for every event can be Job Tracked as specific to that event. Now you can run Job Profitability reports and P&L by Job, to see your Costs directly associated to your Revenue for Each job, specifically related.

"I hope this helps in what I am trying to accomplish here re: a report that tells me the Total of all money received from Event Sales at an event."

You have to understand how to separate or include Sales from Taxes. Taxes are not Sales. Taxes are collections Because of Taxable Sales.

"Also I am noticing that despite putting in "Payment Type" when I add this field to be shown in a report it is blank for some strange reason. Do you know why this would be? Thanks."

It depends on where and how you used this concept. But you should be looking at Payment METHODs, not Payment Type.

A Payment Method is something you set up, name and Use. It is linked to a Payment Type. Then, you might be using a Payment TYPE ITEM, if you Summarized Sales per that link I provide. Or, it is a provision for reporting on the Transaction of the Sales Receipt, if you used the Icons for Payment Method.

"So Payment Method doesn't work, basically and useless?"

It works and reports where that function applies.

Not everything available for selection on every report applies to the perspective of that report. For example:

Run Transaction List by Customer. Select to see:

Paid

Clr

Pay Meth

By Definition, Sales Receipts are PAID. This report shows that is not the case for the data. By Definition, only entries to Balance Sheets are Cleared as part of a reconciliation. And now you see your Payment Method, for those transaction TYPES where this applies and was selected or assigned.

"PLEASE tell me how to generate a report"

Run your Balance Sheet report. Assets, Liability and Equity are Balance Sheet, not P&L.

P&L in only 1 of Three reports, at a minimum, that you need to see the full financial picture:

P&L

Balance Sheet

Statement of Cash Flow

Sales Reports would include taxes if you set it for show All charges, not just income and expense.

---

@lindak1119 wrote:

My Gross Receipts, P&L Amounts do not include Sales Tax Amount. Is this normal, and if so PLEASE tell me how to generate a report or such that shows True Total Gross Receipts from my understanding, i.e Sales amount including Sales Tax collected. The equivalent of the "Total" field on Sales Receipts and Invoices alike. I'm sorry but I am Fully Frustrated after searching here and all the answers say goto P&L or such for Gross Receipts amount or for Gross Sales and I do but it still only shows me the total before Sales Tax.

---

First of all, Yes, this is normal. Your Profit & Loss Report will not include Sales Tax collected. Your Profit & Loss reports shows revenue your company has earned and expenses that it has incurred. The bottom line is the difference between the two.

Sales Tax collected becomes a liability to your company. It is recorded in a QuickBooks created liability account called Sales Tax Payable. The amount you currently owe in Sales Tax will show on your Balance Sheet, not on your Profit & Loss.

When you balance your bank account in QuickBooks against the monthly Bank Statement provided by your bank, you will be able to match your deposits in QB to the deposits on the statement. You go to Banking/Reconcile to balance your bank account.

Your Sales Receipts should not be set up to deposit all funds into your Bank Account unless that is what occurs in real life. If every time you receive revenue, it gets deposited directly to the bank account, then this is fine and will match your bank statement. However, if you make manual deposits and you group several customer payments together to make a deposit, then the sales receipts should be deposited into the Undeposited Funds account created by QB. When you go to Make Deposits, you can manually select the amounts that were actually deposited into your bank account.

Tip: Run the Sales Tax Liability report to show the amount of sales tax you owe.

I hope this clears things up for you. Please let me know if it helps and if you have other questions.