Why wrong account ?

jmorgie's Avatar


17 Jan, 2019 02:45 PM

New to MondyDance in the last week. Have set up all accounts, downloading works etc.

I just executed 'Download all Accounts'
Approx 200 transactions from my Schwab Bank checking account were posted to the *Sales Tax* account. Sales Tax is a Moneydance account that i never set up.
* Why are the transactions being posted to Sales Tax and NOT to scwab bank checking account ?
* Can I Cut/Paste these transactions to put them into schwab bank?
* Can I safely delete Sales Tax account ?

  1. 1 Posted by mhoggie on 17 Jan, 2019 03:27 PM

    mhoggie's Avatar

    just a user,

    That's a bit strange if Sales Tax is an account, not a category. Also Sales Tax is not even in the default set of MD categories so that's even weirder. Have you clicked on Tools, Accounts, and verified that it is really an account? Whatever the issue is, you should be able to select them all, do a right click batch change and change the category to your bank account.

  2. 2 Posted by jmorgie on 17 Jan, 2019 03:49 PM

    jmorgie's Avatar

    verifying that it is an account and not a category

    I will wait for actual moneydance support

  3. Support Staff 3 Posted by Sean Reilly on 22 Jan, 2019 01:39 PM

    Sean Reilly's Avatar

    That is very strange... I can't think of anything that would cause Moneydance to create a Sales Tax account or add a bunch of transactions to it unless you were importing a QIF file that declared it as a category or account.

    Would it be possible to right-click (or ctrl-click) on a transaction in that register and select the Show Transaction Details option, then copy-and-paste the contents of the window that appears into a message here? Please feel free to make this thread private if you like, or I can do so before you post it - just let me know.


    Sean Reilly
    Developer, The Infinite Kind

  4. 4 Posted by jmorgie on 22 Jan, 2019 10:27 PM

    jmorgie's Avatar

    bizarre behaviors ...
    * I have 5 broker accounts downloading from Charles Schwab and also a Checking account that downloads as a separate stream [i think].
    * when I download all accounts, schwab reports 203 transactions downloaded. 5 minutes later I download all and all accounts report 0 except schwab that reports 203 transactions.
    * the transaction[s] that mess up are duals: there is a check debited from the checking account and then a transfer reported .... should be from the master Schwab account but this is the one[s] that get recorded into *Sales Tax*. see attached screen shots. *Sales Tax* is a Category in my Quicken 2017 file with only a single entry.

    * here is the trans details you asked for:
     0.acct: 3196568
    0.acctid: 3e82e46d-b96b-4a05-bee9-7cbe2ccb9777
    0.id: 9abe0058-6e48-4c91-9fe1-4d5ef277ad70
    0.invest.splittype: xfr
    0.pamt: -10400
    0.samt: 10400
    acct: 8449957
    acctid: 93344547-64a8-420d-8496-3639b11010ef
    dt: 20190115
    dtentered: 1548194772809
    id: 54f2fb03-d277-410f-9e2e-7c2bb73d40ee
    invest.txntype: bank
    obj_type: txn
    ol.match-status: y
    ol.match-type: 4
    ol.orig-memo: OVERDRAFT TO INVESTOR CHECKING -6877
    ol.orig-payee: OVERDRAFT TO INVESTO
    ol.orig-txn: {
      "invst.subaccfund" = "CASH"
      "invst.txntype" = "bank"
      "name" = "OVERDRAFT TO INVESTO"
      "amt" = "-10400"
      "cxnaction" = "1"
      "orig_data" = "<STMTTRN>
      "fitxnid" = "6456826620190115120000201901150216332290391040"
      "dtpstd-int" = "20190115"
      "fi_id" = "ofx:Intuit:8888"
      "dtavail-int" = "20190115"
      "txntype" = "DEBIT"

    ol_fi_id: ofx:Intuit:8888
    ol_fitid_1: 6456826620190115120000201901150216332290391040
    oldid: -1
    td: 20190115
    ts: 1548194774900
    xfer_type: xfrtp_bank

    So what can I do to make this neat? can I delete *Sales Tax* from MD ? Why does schwab download gift me with 203 transactions? and I think they are all getting mapped into *Sales Tax*.

  5. System closed this discussion on 23 Apr, 2019 10:30 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac