text inport

Robert's Avatar

Robert

07 Oct, 2024 10:43 PM

need more info for importing cvs text
have: debit acct no. debit acct description, check no., date, To, For, Memo, amount, credit acct no. , credit acct description,

you have: date, check no., description payee, acct, amt, memo, status, ignore

already make account to match what I am importing. did not work. already have text extension setup
tried and did not work. I can control the comma delimit columns but do not know how to match file columns.

"01/05/2020","","Repair Expense 1","Repair 1 Expense"," 102"," " <-- here is what I try to import . try to match what you help text had.

  1. 1 Posted by dtd on 07 Oct, 2024 10:44 PM

    dtd's Avatar

    Are you using the built in csv importer or the extension?

    I personally think the extension has more capabilities.

  2. 2 Posted by Robert Alvarez on 07 Oct, 2024 10:49 PM

    Robert Alvarez's Avatar

    yes  I can change order of the columns any way that is needed,It does have about 18 different categories .
    are you suppose to import only one category at a time or can it handle many at once?

        On Monday, October 7, 2024 at 05:44:50 PM CDT, dtd <[email blocked]> wrote:

       
    |

  3. 3 Posted by sth on 07 Oct, 2024 11:25 PM

    sth's Avatar

    In looking at your data, would that be the following for you headings to import?
    date, ignore, Description, memo, amount, ignore

    It seems that you have strings and not numbers or dates as the format for the items that are not Description or memo.

    (NOT IK Support)

  4. 4 Posted by -Kevin N. on 07 Oct, 2024 11:26 PM

    -Kevin N.'s Avatar

    Hi Robert,

    Can you attach a sample of the csv file. Make sure that there is no sensitive information in the contents. e.g. account numbers.

    With the actual file, I can try to set up the CSV Importer extension for you.

    -Kevin N. (not a member of Moneydance support)

  5. 5 Posted by Robert Alvarez on 08 Oct, 2024 12:44 AM

    Robert Alvarez's Avatar

    attached is import dialog window that I see , no instructions how that works
    "07/13/2020","1002","Excel Phone SVC","House Phone 1"," 80.89"," "
    "07/13/2020","1006","SA Water System","Utility Water"," 60.99"," "
    "07/18/2020","10012","MISC BILLS","Home repiars"," 145","EE 21" above is my cvs file. 
    so dates and number should not have parentheses

    still not sure how to match my file to your file import system?

        On Monday, October 7, 2024 at 06:25:40 PM CDT, sth <[email blocked]> wrote:

       
    |

  6. 6 Posted by -Kevin N. on 08 Oct, 2024 01:16 AM

    -Kevin N.'s Avatar

    Hi Robert,

    I was able to import your sample using both the CSV Importer extension and Moneydance's built-in importer.

    I provided a screenshot of the built-in importer. If you want to set up the CSV Importer, let me know and we can go ahead with that.

    2 points I'd like to make...
    1) Using the banks 'Categories' is OK but it may be to your advantage to create your own Categories that may be more universal across other accounts from other financial institutions. It's up to you. If so, just set the importer's 'Category' selection to 'Ignore'.
    2) You haven't provided any Deposit transactions in your sample CSV file so that could change the importer fields selections.

    Let me know how you make out. OK?

    -Kevin N. (not a member of Moneydance support)

  7. 7 Posted by Robert Alvarez on 08 Oct, 2024 01:45 AM

    Robert Alvarez's Avatar

    i got rid of parentheses and got a little better results in seeing the imported data , still something is not right

    07/13/2020,,Bank One Checking,Bank One Checking, 6000 ,Begining Balance
    07/13/2020,1001,SA Water System,Utility Water, 60.58 ,
    07/13/2020,1006,SA Water System,Utility Water, 60.75 ,
    07/13/2020,1008,Best Cell SVC Inc,Cell Phone 1, 75.85 ,

    when I see the imported i click top bar and it disappears

    attached two images, one import dialog two imported data , look strange , do not know why?

    pressing ESC or cntrl Z make data go away
    still a lot I do not understand in matched fields?

     

        On Monday, October 7, 2024 at 08:16:22 PM CDT, -Kevin N. <[email blocked]> wrote:

       
    |

  8. 8 Posted by -Kevin N. on 08 Oct, 2024 02:03 AM

    -Kevin N.'s Avatar

    Hi Robert,

    Per your most recent screenshot of the importer's settings, you have not set them up the way that I had them set in my prior screenshot.

    Date
    Check#
    Description
    Category
    Debit Amount
    Memo

    I'm assuming that EE 21 is a Memo.

    There was no need to remove the quotation marks.

    When setting up the importer fields, it is imperative that you display only the required 6 fields. Use the 'Fewer Fields' button to make it so.

    -Kevin N. (not a member of Moneydance support)

  9. 9 Posted by Robert Alvarez on 08 Oct, 2024 03:03 PM

    Robert Alvarez's Avatar

    the file I had was very large so now made smaller see below
    01/05/2020,,Repair Expense 1,Repair 1 Expense, 102 ,
    07/13/2020,1001,SA Water System,Utility Water, 60.58 ,
    07/13/2020,1007,All Time Cell SVC,Cell Phone 2, 65.55 ,
    08/14/2020,,Petty Cash 1,Petty Cash 1, 86.99 ,
    02/11/2020,,Petty Cash 1,Petty Cash 2, 21.2 ,

    the field that you show,

    Category
    Debit Amount
    Memo
    can not be selected, they no longer display in pull down tab.  do not know why , they were show before but no anymore.
    question: does the import file need a header line to define each column?

        On Monday, October 7, 2024 at 09:03:22 PM CDT, -Kevin N. <[email blocked]> wrote:

       
    |

  10. 10 Posted by -Kevin N. on 08 Oct, 2024 04:25 PM

    -Kevin N.'s Avatar

    Hi Robert,

    The field selection drop-down list is scrollable. You should be able to access all of the options by scrolling.

    The header row is optional.

    I was able to import your newest sample using the same settings as I originally posted.

    -Kevin N. (not a member of Moneydance support)

  11. 11 Posted by Robert Alvarez on 08 Oct, 2024 08:36 PM

    Robert Alvarez's Avatar

    finally got import to work but there is problemI had setup accounts ASSET > cash, petty cash 1, petty cash 2
    08/14/2020,,Petty Cash 1,Petty Cash 1, 86.99 ,
    02/11/2020,,Petty Cash 1,Petty Cash 2, 21.2 ,

    above went to account Bank One Checking instead of ASSET > petty cash 1  and petty cash 2
    those two are not expense to be put in Bank One Checking
    robert

        On Tuesday, October 8, 2024 at 11:25:54 AM CDT, -Kevin N. <[email blocked]> wrote:

       
    |

  12. 12 Posted by -Kevin N. on 08 Oct, 2024 09:05 PM

    -Kevin N.'s Avatar

    Hi Robert,

    The first screen of the importer determines which account the imported data will be sent to. (see screenshot)

    -Kevin N. (not a member of Moneydance support)

  13. 13 Posted by Robert Alvarez on 08 Oct, 2024 10:09 PM

    Robert Alvarez's Avatar

    if I include a debit category and credit category would that work to get imports to their different categories?
    thanks for the helprobert 

        On Tuesday, October 8, 2024 at 04:05:11 PM CDT, -Kevin N. <[email blocked]> wrote:

       
    |

  14. 14 Posted by dwg on 08 Oct, 2024 10:17 PM

    dwg's Avatar

    Each transaction can only have one category.

    Where that category sits in Moneydance determines if it is an income or expense category. The sign of the transaction indicates if it is a debit or a credit.

    So for example you would have an Expense category for your Internet bills. Normally this is a debit entry.

    Suppose there was a partial refund for some reason, you still use the same category but with a credit amount, so it reduces your overall Internet expense category total.

  15. 15 Posted by Robert Alvarez on 08 Oct, 2024 10:49 PM

    Robert Alvarez's Avatar

    looking around found this for petty cash imports
    is shown in bank one checking and in asset petty cash 1 and in asset petty cash 2

        On Tuesday, October 8, 2024 at 05:17:26 PM CDT, dwg <[email blocked]> wrote:

       
    |

  16. 16 Posted by -Kevin N. on 09 Oct, 2024 01:06 AM

    -Kevin N.'s Avatar

    Hi Robert,

    By creating the 2 Asset accounts 'Petty cash 1' & 'Petty cash 2' and entering/importing those accounts into the Category column of the Bank One Checking register, you have essentially created transfer transactions from Bank One Checking to the Petty cash 1 and Petty cash 2 Asset accounts.

    This is why the transactions appear in both Asset accounts and the Bank One account. They are transfer transactions.

    -Kevin N. (not a member of Moneydance support)

  17. 17 Posted by Robert Alvarez on 09 Oct, 2024 01:22 AM

    Robert Alvarez's Avatar

    any way to avoid that transfer ?just do no not include those two for Bank One account which are assets?

        On Tuesday, October 8, 2024 at 08:06:08 PM CDT, -Kevin N. <[email blocked]> wrote:

       
    |

  18. 18 Posted by dwg on 09 Oct, 2024 01:33 AM

    dwg's Avatar

    It is unclear what you are trying to achieve here. If you can elaborate we may be able to help

    It is important to note that Moneydance is based on the rules of double entry accounting, it is not a free form program that allows for fund to appear and disappear at random. Transactions in Moneydance must have both a source and a destination.

  19. 19 Posted by -Kevin N. on 09 Oct, 2024 01:48 PM

    -Kevin N.'s Avatar

    Hi Robert,

    any way to avoid that transfer?

    Try changing the names of the 2 Asset accounts so as to sever the transfer link.

    -Kevin N. (not a member of Moneydance support)

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts

Generic

? 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