cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

In the DASHBOARD Sales data is not accurate. The Sales area is only reflecting Sales Receipts I created, no sales information from sub-accounts is shown. Is there a Fix?

 
25 Comments
QuickBooks Team

Re: In the DASHBOARD Sales data is not accurate. The Sales area is only reflecting Sales Receipts...

Not all sales transactions are displayed on the dashboard, Jordan-Rosner.

 

QBO only displays the Invoices and Sales Receipts to calculate the sales amount on the Dashboard. Journal Entries posted to sales account, sales tax, and other income transactions like bank deposits will not be displayed.

 

Additionally, the data being shown there is based on the specified period. You can click the drop-down arrow in the upper right-hand corner of the graph to change the period. You can also open the Sales by Customer Summary report to review the details of your sales graph.

 

Here's how:

  1. Click Reports on the left panel.
  2. Type Sales by Customer Summary in the search box.
  3. Filter the Report period.
  4. Click the Run Report button.

You can always leave a reply if you have questions on this. 

Frequent Contributor *

Re: In the DASHBOARD Sales data is not accurate. The Sales area is only reflecting Sales Receipts...

Hi then how would that work for an ecommerce store that doesn't invoice people, and all sales come in as deposits to the bank account? Not all businesses invoice. And after reconciling all accounts and connecting everything, just to see that big feature flaw makes me want to give up. It should be a simple thing, just let all income categorized as sales show up on that dashboard! Please.

Moderator

Re: In the DASHBOARD Sales data is not accurate. The Sales area is only reflecting Sales Receipts...

Good to have you here, yvy1.

 

Since you don't invoice your customers, I'd suggest using the sales receipt instead. This shows all of your income categorized as sales.

 

Here's how:

  1. Go to the Plus sign, and under Customers choose Sales Receipts.
  2. Enter your customer's name in the Customer field.
  3. Enter Product/Service you provided for your customer.
  4. Enter the Payment Method your customer used to pay.
  5. Under Deposit to, choose the bank account.
  6. Then, click Save and close.

Once done, you'll need to record this deposit in QuickBooks. Go to the Plus icon, and select Bank Deposit. From the Account drop-down, choose the account you want to deposit the money into. Select the box for each payment. Then, Save and close.

 

Let me know how these steps work for you. I'm just around if you need more help.

Frequent Contributor *

Re: In the DASHBOARD Sales data is not accurate. The Sales area is only reflecting Sales Receipts...

Hi, so I have to manually do that for every sale? then match it up to the deposit in the bank account? That's too much work..For a store with even 30 sales a month is too much. Is tehre a way to automatically change those sales deposits as sales receipts so it can still be categorized as sales, but also show in the dahsboard and sales reports?
Frequent Contributor *

Re: In the DASHBOARD Sales data is not accurate. The Sales area is only reflecting Sales Receipts...

Not sure if my reply went through. I was asking for a bigcommerce store that has 30, 50 or 100 sales a month, that's too much work to manually input all that info every time there is a sale. IS there a way to automatically categorize all the deposits that are categorized as sales, to convert to "sales receipt" while still keeping the sales category? So they are included in the sales reports and dashboard?
QuickBooks Team

Re: In the DASHBOARD Sales data is not accurate. The Sales area is only reflecting Sales Receipts...

I appreciate your swift response, @yvy1

 

QuickBooks Online is designed as a do it yourself accounting software. Thus, the program lets you categorized each transaction to ensure that you will have an accurate report.

 

In addition to my colleague's suggestion about using the sales receipt, you can also record your total daily sales in QuickBooks Online using a single sales receipt. This way, you can enter a single sales receipt to report the total daily sales. It will help you save time while still keeping your income reports accurate.

 

To help you get started, you can refer to our help article for a step-by-step guide: Record your total daily sales

 

Let me know if you need help with anything else. We'll be glad to help in any way we can. Have a pleasant day ahead!

Frequent Contributor *

Re: In the DASHBOARD Sales data is not accurate. The Sales area is only reflecting Sales Receipts...

Hi this is related so didn't want to start a new thread. I assume rather than make it manual, a connection of sorts to my shopping cart platform will in essence perform this. So, granted I connect my bigcommerce store to quickbooks: If all my sales transactions are already being deposited into my bank as "sales" or "Product sales", if I connect my bigcommerce store and send in all sales as sales receipts for the purpose of tracking sales in the dashboard, then it will double record. Tried it, noticed that. So is this an option? : Import all sales data as sales receipts and deposit into "Undeposited Funds". That way the sale is not being recorded twice in my bank account, and I still get my sales data in the dashboard/graph. Will this work?
QuickBooks Team

Re: In the DASHBOARD Sales data is not accurate. The Sales area is only reflecting Sales Receipts...

Thanks for getting back to use, @yvy1.


Yes, depositing the sales data to the Undeposited Funds account will work. This process can help get the transactions posted on the Sales Dashboard without duplicating them.

 

Using this account is a convenient way of handling the money that comes into your business. This is because it serves as the default deposit to account when receiving payments.


For additional resources, I’m adding a link with detailed steps on how to input payments and make a deposit: Undeposited Funds.


Let me know if you have any other concerns or questions while working in QuickBooks. I’ll be right ready to help you. Wishing you the best.

 

Frequent Contributor *

Re: In the DASHBOARD Sales data is not accurate. The Sales area is only reflecting Sales Receipts...

Thank you @Rasa-LilaM So essentially I will be using the undepostied accounts as a dumping place to put all my sales since I will never really actually deposit from there (as the sales are already deposited separately) so that register will just grow and grow. I assume that's fine, then. I will just ignore it, correct?
QuickBooks Team

Re: In the DASHBOARD Sales data is not accurate. The Sales area is only reflecting Sales Receipts...

I can add more details on how to properly record your sales, yvy1.

 

It will surely duplicate the transactions if you've entered it manually in QuickBooks, and import it from BigCommerce. Not unless if you match the two transactions. Check this article as your guide: Match and categorize your downloaded transactions.

 

Also, all sales transactions will reflect on the Sales dashboard. This means, regardless of what type of account you've chosen, it'll add up on the Sales dashboard.

 

I'd suggest not to keep the transactions on the Undeposited Funds. Keeping them on the said account will affect your Profit and Loss report. You'll need to deposit it to the appropriate account. 

 

I agree to what my colleague mentioned, to record your sales as Sales Receipts is a best workaround. In creating sales receipts, you have an option to deposit it to correct account. It'll be added on the Sales dashboard as well. This article will guide you on how to record your total daily sales.

 

Should you need anything else, visit our Help page for more helpful articles. You can also post again in the Community.

Frequent Contributor *

Re: In the DASHBOARD Sales data is not accurate. The Sales area is only reflecting Sales Receipts...

@AlexV, so....about this "Also, all sales transactions will reflect on the Sales dashboard. This means, regardless of what type of account you've chosen, it'll add up on the Sales dashboard." It will not record in the sales dashboard IF it is recorded in my checking account as a deposit from Amazon Pay (for example). I categorize all deposits from Braintree and Amazon Pay as sales, but merely categorizing them as sales won't put them in the sales dashboard. Which seems absurd and above was told that is how it works, it needs to be an invoice or sales receipt (and I don't invoice customers). I suppose, then, I need to match up the sales imported from my bigcommerce connection as sales receipts to the actual deposit for that sale, but i cannot match it up since the deposits from braintree and amazon pay are bulk for the day and not individual per order. IS THERE a way to make every deposit I categorize as a sale actually show up in the sales reports and sales dashboard?? I really want to figure this out. It would be so easy if merely items categorized as sales would show in the sales report and not have to go through all these hoops. So how can I deposit into the appropriate account and not double up?? The correct bank deposit is the value after merchant fees and the correct one. If I deposit the sales receipt from bigcommerce it will be full sale value before merchant fees are removed. So using my bicommerce connection as the true deposit will be wrong in the end anyways. I would love to not have to deposit them for real, but I do want them to show in the sales dashboard. That is the reason for me looking for all these work arounds. Ugh.
Moderator

Re: In the DASHBOARD Sales data is not accurate. The Sales area is only reflecting Sales Receipts...

Hello yvy1,

 

Thank you for sharing your preference with the Sales statistics. I'm here to help share information about the dashboard in QuickBooks Online.

 

Income will only reflect on the Dashboard, sales reports, and Profit and Loss report if you use Invoice (for sales on credit) or Sales Receipt (for cash sales). At this time, using the Bank Deposit feature for recording sales will only reflect the data solely on the P&L report.

 

Since these are only the type of transactions that will reflect from the Sales dashboard, I'll be taking note of your request with the deposits. For any updates regarding the new features and options, I recommend visiting our QuickBooks Blog website.

 

To know more about the recording of sales transactions, I'm adding the article I recommend on this:

 

Should I use an Invoice or a Sales Receipt?.

 

Thanks for reaching out with regards to the sales recording process in QuickBooks. The Community is here to ensure your success.

Frequent Contributor *

Re: In the DASHBOARD Sales data is not accurate. The Sales area is only reflecting Sales Receipts...

Ok, well that I know so far, then can anyone tell me how to successfully connect my bigcommerce store, import all the sales as sales receipts so they can be properly added in the sales report, WITHOUT doubling up on the deposit that already exists for my orders???
Frequent Contributor *

Re: In the DASHBOARD Sales data is not accurate. The Sales area is only reflecting Sales Receipts...

Also, though I appreciate the links, they don't answer what I need to do> I know how to create an invoice, I know how to match transactions, but I need to know what to do in my case. I don't invoice customers. I have an ecommerce store...How can someone with an ecommerce store where people solely buy on the website able to show sales data on the dashboard and sales reports?? (considering that the deposits for those sales are automaically being made on the bank side of things)
QuickBooks Team

Re: In the DASHBOARD Sales data is not accurate. The Sales area is only reflecting Sales Receipts...

I appreciate you getting back to us, @yvy1.

 

Let me redirect you to the best support available to help you connect your Bigcommerce store to QuickBooks Online.

 

It's good to connect your Bigcommerce store to QuickBooks Online to automatically sync all order, product, and customer data. This way, you don't have to spend more time entering sales receipt manually in QuickBooks.

 

However, I suggest contacting Bigcommerce support so they can help you connect your Bigcommerce store to QuickBooks Online.

 

Also, connecting Bigcommerece to QuickBooks allows you to import and retrieve orders you would like to sync. With that being said, all sales data from Bigcommerce will show on the dashboard and sales reports in QuickBooks.

 

In case you need tips and related articles in the future, visit our QuickBooks Community help website for reference: QBO Self-help

 

I'm here anytime you have other concerns. Wishing you and your business continued success!

Frequent Contributor *

Re: In the DASHBOARD Sales data is not accurate. The Sales area is only reflecting Sales Receipts...

I am not sure if you read everything, but I AM connected with quickbooks and bigcommerce. Someone please read everything. I keep being sent to help docs to assist in things I don't need assistance in. Please read the whole thread. My problem is, the sales data comes in as sales receipts, fine, but that duplicates the amounts in the checking account that are already deposited from the sales. (deposited from the merchants that process the credit card transactions, into my bank) So i thought of importing the data from the bigcommerce connection into undeposited funds, so then the amounts are not duplicated but then that will throw off the data in the profit and loss statements. So HOW, please HOW can I make this work??? HOW can I make it so the sales data coming in from bigcommerce DOES NOT duplicate the deposits from the bank for the same sales??? If I import them as sales invoices instead of receipts, will that work? BUt I will then have a false list of thousands of dollars of unpaid invoices which is not true. I cannot "match" up with the corresponding bank deposits because the bank deposits don't match as they already remove the merchant fees, and are deposited once every couple of days. Hopefully I reiterated everything again in an understandable way. Please help. I don't need the practical HOW TO for connect, or HOW TO match transactions. I want to know WHAT TO DO to make this process work correctly.
Moderator

Re: In the DASHBOARD Sales data is not accurate. The Sales area is only reflecting Sales Receipts...

Hi there, @yvy1.

 

I appreciate you for getting back to us with detailed information about your concern. I'm here to provide some ways to get around with your concern.

 

First, if you have an option to process invoices in BigCommerce, you can link them to the deposits after syncing the app to your QuickBooks. Let me show you how: 

  1. Click the QuickBooks Plus (+) icon.
  2. Select Receive Payment.
  3. Choose the Customer's name.
  4. The screen will show you both the invoice and the deposit.
  5. Put a check in the boxes next to the correct invoice and deposit.
  6. Mark the Amount Received as zero.
  7. Update the Payment date.
  8. Select Save and close.

Another option is using the sales receipt. Since the sales data from the BigCommerce comes in as sales receipts, you can delete the deposits to avoid duplicates. This way, the data will show on the Dashboard. 

 

Here's how: 

  1. On the left pane, select Accounting.
  2. Select Chart of Accounts.
  3. Find the bank account holding the deposit and then click View register.
  4. Search for the deposit and select it to get more details.
  5. Click on More at the bottom, and choose Delete.

Just make sure that the transactions will be deposited into your bank. If you need assistance with the mapping, I recommend reaching out to the Bigcommerce support to help you out. 

 

Additionally, there are video tutorials designed to help a user get accustomed with QBO which can be accessed at the following link: QuickBooks Tutorials

 

I'm just a post away if you should have any questions. Have a good day.

Frequent Contributor *

Re: In the DASHBOARD Sales data is not accurate. The Sales area is only reflecting Sales Receipts...

Thanks for the help but if those are my only lptions, it won't work. I mentioned earlier, that deposits are made through amazon pay and braintree and are done once a day, or once every 4 days. There is not way to match up each transaction with each order to go in and know what to delete. (Plus that's VERY manual). Secondly, deposits made to the bank are aft er merchant fees, and the correct ones. If I delete the deposits, the bank balance will never match reality. So the first won't work because I don't create invoices in bigcommerce. It is an ecommerce store. People shop and purchase via checkout and I never send them an invoice. Invoices are NEVER done or needed. Second option won't work because of what I said before. Deposits are made from my merchant accounts not per sale, but once per day (braintree) and once per 4 days (amazon pay). So it will be impossible to match up each sale with each deposited amount. PLUS the deposited amounts are already minus merchant fees. So then is it impossible to use quickbooks online with an ecommerce store??? Seems for every possible yes, there is something that breaks on the other side of it. Import sales - Yes, but then duplicate deposits. Leave deposits alone and categorize as sales, yes but then sales don't show up on the sales report. Something's gotta work. Is there another software better suited, a version of quickbooks I don't know about? Is it possible, instead of connecting to bigcommerce, rather connect to each payment gateway?? If so how do I connect to amazon pay??
Frequent Contributor *

Re: In the DASHBOARD Sales data is not accurate. The Sales area is only reflecting Sales Receipts...

To add: I don't invoice anybody. I don't carry stock on 99% of my items. It is a simple online store where people buy online. And use one of 4 payment gateways. I just want a simple way of bookeeping where i can keep track and everything will match up. With no connections at all or other hoops to jump through, it works fine - all my deposits (after merchant fees) get categorized as sales. But the ONLY thing wrong with that is that the sales reports and dashboard have no record of any sale. Which is bad for reporting when I want to see my sales at a glance. If there is any way AROUND THAT...please let me know.
QuickBooks Team

Re: In the DASHBOARD Sales data is not accurate. The Sales area is only reflecting Sales Receipts...

Hi there, yvy1.

 

Since the sales data that are coming from Bigcommerce duplicates the deposits, you might want to visit our Intuit App Store. Then, look for a Transaction Importer app, that can help you import sales receipt only from Bigcommerce.

 

Once done, please contact the Amazon pay and Braintree technical support to help you connect the payments via Banking page in QuickBooks Online.

 

Then, match the downloaded banking transactions to the imported sales receipt from Bigcommerce.

 

You can always reply to this thread if you have questions on this. 

Frequent Contributor *

Re: In the DASHBOARD Sales data is not accurate. The Sales area is only reflecting Sales Receipts...

@RCV, Hi, how do you suggest then I choose the deposit for the transactions connected to bigcommerce? I have tried many and I NEED to tie in each transaction with a bank to deposit them to. So do I deposit un undeposited funds in the mean time? Or are you trying to say in this order: 1. Add Amazon pay as a bank. 2. Add Braintree as a bank. 3. Add klarna as a bank. etc. for all my payment gateways THEN match up each transaction to their respective banks? Quickbooks only lets me add banks as banks so You suggest it IS possible if I ask the respective merchant account how to do it? The only think with that is: Transactions imported from bigcommerce using the bigcommerce app connector come in as gross sales amount. Transactions in amazon pay, braintree, etc all come through after merchant fees AND in many cases once per every few days. How can I even match up each one if the totals won't be exact 1-1? Or will it not even matter since I won't be using those banks? Will it affect my sales reports if I have deposits into Braintree bank and deposits into my actual bank - hence still duplicating in the end?
Moderator

Re: In the DASHBOARD Sales data is not accurate. The Sales area is only reflecting Sales Receipts...

I can share with you a recommended workflow to your special scenario, yvy1.

 

I agree with my colleague @RCV to add all the payment gateway as a bank type. Then, check if they support the WebConnect file to get the transactions.

 

You need to ensure that the imported transactions from Bigcommerce should be sales receipts. Then, deposit it to Undeposited Funds. To match all gateway payments you need to add the fees. Here's how:

 

  1. Select the sales receipt from the Select the payments from this deposit.
  2. Under Add funds to this deposit, enter the fee as a line item.
  3. Enter the fee as negative number.
  4. Review the deposit total with the bank fee.
  5. Click Save and close.

Then, match the deposit to your bank feeds.


I've added screenshot of our recommended workflow:
big commerce.PNG

 

Let us know if you need clarifications about this process. We're always here to help you out.

Frequent Contributor *

Re: In the DASHBOARD Sales data is not accurate. The Sales area is only reflecting Sales Receipts...

I tried answering but it didn't post. I apologize if this duplicates. Thank you for trying. But honestly, that's TOO many hoops to jump through, and still wont work: I've spoken to my merchants and they do not have the ability to add as a bank. Also to calculate the merchant fees for each sale?? The purpose of quickbooks is to make things easier and automate them to an extent. That would be as manual as keeping a spreadsheet. Also, my use case isn't that unique. How many ecommerce stores are there? Ecommerce stores don't usually use an invoice/receipt system. People buy on the website - and that's a sale. Period. So it would be much much easier for quickbooks to allow all bank deposits that are categorized as sales to show on the dashboard under "Sales" and "Income". As it is, IF I keep quickbooks it would have to be without the ability to see that data at a glance. And that really sucks.
Experienced Member

Re: In the DASHBOARD Sales data is not accurate. The Sales area is only reflecting Sales Receipts I created, no sales information from sub-accounts is shown. Is there a Fix?

I have a similar issue, although from the opposite side.  I just posted this question:

 

Why did journal entries(for missed CC bill payments) cause the cumulative value of the JE's to be subtracted from the monthly sales total (dashboard), but not from sales?

 

Help...

Need to get in touch?

Contact us