text inport
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.
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
1 Posted by dtd on 07 Oct, 2024 10:44 PM
Are you using the built in csv importer or the extension?
I personally think the extension has more capabilities.
2 Posted by Robert Alvarez on 07 Oct, 2024 10:49 PM
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 Posted by sth on 07 Oct, 2024 11:25 PM
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 Posted by -Kevin N. on 07 Oct, 2024 11:26 PM
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 Posted by Robert Alvarez on 08 Oct, 2024 12:44 AM
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 Posted by -Kevin N. on 08 Oct, 2024 01:16 AM
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 Posted by Robert Alvarez on 08 Oct, 2024 01:45 AM
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 Posted by -Kevin N. on 08 Oct, 2024 02:03 AM
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 Posted by Robert Alvarez on 08 Oct, 2024 03:03 PM
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 Posted by -Kevin N. on 08 Oct, 2024 04:25 PM
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 Posted by Robert Alvarez on 08 Oct, 2024 08:36 PM
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 Posted by -Kevin N. on 08 Oct, 2024 09:05 PM
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 Posted by Robert Alvarez on 08 Oct, 2024 10:09 PM
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 Posted by dwg on 08 Oct, 2024 10:17 PM
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 Posted by Robert Alvarez on 08 Oct, 2024 10:49 PM
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 Posted by -Kevin N. on 09 Oct, 2024 01:06 AM
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 Posted by Robert Alvarez on 09 Oct, 2024 01:22 AM
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 Posted by dwg on 09 Oct, 2024 01:33 AM
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 Posted by -Kevin N. on 09 Oct, 2024 01:48 PM
Hi Robert,
Try changing the names of the 2 Asset accounts so as to sever the transfer link.
-Kevin N. (not a member of Moneydance support)