How can I stop ALL transfers (bank fee refunds etc.) appearing as sales?

Hi innov8ive1, 

Are you able to provide a little more information on where you are seeing this issue? Is it in the Banking 'For Review' section? 

Thanks, 

Rebecca 

Hi Rebecca (Replied twice before but NOT via the title link for success!)

Banking:

1. Regardless of the size of any given bank entry (>=1cent?)
2. Regardless of how it enters the account  (transfer/over the counter (card entry)/cash deposit)
3. Regardless of which account it is 'reviewed' to! (Owners Equity/Director's Drawings etc.)

IF 'reviewed' as a 'deposit' it would seem that it will appear in the "dashboard-sales" graphs, depending on the 'x axis' of course! (hover over the tiny rings, to see amounts of smaller erroneous 'sales'!)

DESPITE this "issue" of ALL ENTRIES "reviewed " as DEPOSITS appearing in the graphs,  I believe I have found the REASON and thus the SOLUTION! (a $0.30 refund or a $37.7 bank fee refund or 3 x 37.7 = 113 will appear as a big 'hiccup' in a graph!)!)

SOLUTION: (Seems to work for me!)

• enter "reviewed"
• find the NON-SALE item, that is upsetting the "dashpanel-sales" graph
• select and "undo"
• enter "for review"
• select item and ENSURE that the item is NOT "reviewed" as a "deposit" ("review" as "transfer" seems to work just fine for me!)

Thanks for sharing your ideas, innov8ive1.

That can work when managing your bank transactions, too. Aside from that, you can manually Add or Match a transaction that is tagged automatically as Transfer. 

1. In the Banking (For Review) page, click the transaction tagged as Transfer.
2. Select Add or Find match.
3. If you select Add, categorize it to the correct income account.
   If you select Find match, select the correct transaction to match with the downloaded one.
4. Click Add or Save.

You can also use these links for reference when managing the bank transactions:

• Transfer imported bank transactions
• Categorise and match online bank transactions in QuickBooks Online

Aside from that, you can also set banking rules to easily manage the transactions: How to set and use banking rules for downloaded transactions.

Let us know if you need anything else. Have a great day!

Why is it that ALL banking, reviewed as a "DEPOSIT" ends up in the "DASHBOARD-SALES" graph? (regardless of it being assigned to a NON-SALES account?)

Hi innov8ive1,

The 'Sales' graph on the dashboard does not pull information directly from the P&L, but rather calculates based on deposits, sales receipts, and transfers. Also, the figure in 'Sales' does not represent journals, so those sales would not reflect on the dashboard. In its current state, I think it is important to view the dashboard as an indication only, with a comprehensive figure found by clicking on the graph itself to take you into your Reports tab to run the P&L. In the meantime, I would be happy to pass your feedback on to our product development team and also encourage you to do so in-product by selecting the Settings icon (top right), then Feedback. 

-Kass

Hi Kass

Thanks for your response.

As an Engineer (that likes to understand problems and fix them as well as achieve some degree of 'accuracy' in things that I am involved with!) please forgive me! ; )

Could you please confirm, for myself and others, that:

"SALES GRAPHING ERRORS WILL OCCUR, if banking transactions are 'reviewed' as 'deposit', regardless of which account the transaction is 'allocated to!" (Such receipts,  with 'deposit' attributes, set and reviewed to NON-SALES accounts, will not cause errors anywhere other than in the 'dashboard - sales' graph!)

Then we will all know if my 'workaround/temporary fix' to "undo and review as 'transfer' TO THE APPROPRIATE ACCOUNT!" is a Legislation acceptable (and therefore ATO/CPA/CA/Bookkeeper') "solution" or the only known solution, until the "sales graph" feed is corrected to come from any account with "sales" in its description?

as you will appreciate, inexperienced users like myself are somewhat scared with respect to 'report'/'reconciliation' etc.)

I appreciate that it highly possible that I am missing something more complex here! (As I am NOT 'finance/admin/accounting trained!)

Jeremy

Hi Jeremy,

This widget pulls data from deposits, sales receipts and transfers, namely incoming money - the graph is displaying these transactions correctly, although I absolutely see where you're coming from. It may be helpful to think of it as showing 'money in' - so eg, using your example of a deposit to the Owners Drawing account this would show on the graph as this is money coming in to an account that can track income. If you were to categorise a deposit to an Expense account (just another example), this would not show on the graph. 

Adding deposits indicates money entering accounts from an outside source, whereas transfers indicate money being moved between accounts existing in the file - as the sales graph is designed to represent money that is being added to the company, most often through sales, these transactions contribute to the sales graph even in situations where that may not be an accurate description of the transaction's purpose.

I am unable to tell you if your method is 'Legislation acceptable' as we are also not accountants, and we are unable to advise whether or not you should be categorising these as transfers rather than deposits. I would have to refer you to your accountant to determine the best method of recording these transactions. As suggested, I would be using the comprehensive reports provided such as your Profit and Loss statement when reporting your income, expenses and so on. The dashboard is a general overview only and is not for the purposes of detailed reporting. We understand the importance of accurate reporting and it doesn't sound like you're missing anything you need to compensate for; so in this particular instance, I would refer you to your reports rather than this graph.

-Kass