Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #10  
Old 12-20-2006, 07:54 AM
Max
Guest
 
Posts: n/a
Default Re: Importing into money

You are absolutely correct! I guess I didn't think of looking in those
settings since I don't really think of these imports as related to
anything "online".

Thank you very much.

  #9  
Old 12-19-2006, 07:04 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Importing into money

In microsoft.public.money, Max wrote:

- quote -

> Well, I took what you wrote between the ===, and put it in a text file
> and then did Import-> Downloaded Statement. And... The Memo DID NOT get
> imported! Is there sime kind of setting that can be changed to import
> or not import memos or cou it be something else???


Try Tools-> Settings-> OnlineServiceSettings-> AddADescription...Memo.

  #8  
Old 12-19-2006, 06:32 PM
Max
Guest
 
Posts: n/a
Default Re: Importing into money

Well, I took what you wrote between the ===, and put it in a text file
and then did Import-> Downloaded Statement. And... The Memo DID NOT get
imported! Is there sime kind of setting that can be changed to import
or not import memos or cou it be something else???

Thanks!

  #7  
Old 12-18-2006, 06:29 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Importing into money

In microsoft.public.money, Max wrote:

- quote -

> Well, it is cyrillic. An the thing is that money understands it and
> imports. When I do "Recover account" it imports all the informaiton.
> The only problem is, is that the transactions are not bold and I cannot
> see which ones I need to check and "accept". When I do the regular
> import, it imports all the information except the MEMO (even though the
> payee is Also in Cyrillic and is encoded the exact same way as the
> memo).


I assume that the M line is a single line in the actual file, and
that some other software modified the memo so it appears as multiple
lines in the posting.


I created this file based on yours but changing the date format and
using ASCII text:
=========================================
!Type:Bank
D12/03/2006
U-445.00
T-445.00
PTestPayee
Mthis is a test memo and the memo 2006 continues blah blah blah..
^
===================================

Doing File-> Import-> DownloadStatement in Money 2007 brings the memo
in. I tried longer memo lines, and still did not have the problem.

I don't know why your QIF import has the problem of not showing the
memo when you do File-> Import-> DownloadStatement but not when you do
File-> Import-> RecoverAccounts. I understand the downsides of using
File-> Import-> RecoverAccounts for statements.
  #6  
Old 12-18-2006, 06:15 PM
Max
Guest
 
Posts: n/a
Default Re: Importing into money

Well, it is cyrillic. An the thing is that money understands it and
imports. When I do "Recover account" it imports all the informaiton.
The only problem is, is that the transactions are not bold and I cannot
see which ones I need to check and "accept". When I do the regular
import, it imports all the information except the MEMO (even though the
payee is Also in Cyrillic and is encoded the exact same way as the
memo).

Thanks

  #5  
Old 12-18-2006, 05:34 PM
Max
Guest
 
Posts: n/a
Default Re: Importing into money

Well, it is cyrillic. An the thing is that money understands it and
imports. When I do "Recover account" it imports all the informaiton.
The only problem is, is that the transactions are not bold and I cannot
see which ones I need to check and "accept". When I do the regular
import, it imports all the information except the MEMO (even though the
payee is Also in Cyrillic and is encoded the exact same way as the
memo).

Thanks

  #4  
Old 12-18-2006, 05:33 PM
Max
Guest
 
Posts: n/a
Default Re: Importing into money

Well, it is cyrillic. An the thing is that money understands it and
imports. When I do "Recover account" it imports all the informaiton.
The only problem is, is that the transactions are not bold and I cannot
see which ones I need to check and "accept". When I do the regular
import, it imports all the information except the MEMO (even though the
payee is Also in Cyrillic and is encoded the exact same way as the
memo).

Thanks

  #3  
Old 12-18-2006, 03:42 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Importing into money

In microsoft.public.money, Max wrote:

- quote -

> Hi,
> Thanks for the help. I am using XL2QIF to export and importing it into
> Money 2007 Home & Business.
> Here are some sample lines:
> =
> !Type:Bank
> D29.03.2006
> U-445.00
> T-445.00
> P???????? ?? ????-??????
> M??????????? ???????????? (???????
> 2006?. ) ??????? ????-??????. ??? ??
> ??????????.
> ^
> D31.03.2006
> U-200.00
> T-200.00
> P???????? ? ???. ?? ??????? ?????
> ??.?.?????????.
> M???????? ?? ??????? ?????????? ?????
> ?? ???? 2006 ?. ??? ???.
> ^
> D25.04.2006
> U164790.00
> T164790.00
> P???????????? ????
> M{VO70070} ?????????? ??????? ?? ????
> ???????? ??????????.
> ^
> =


It came thru garbled, as you can see above. I don't know if that is
an artifact of the message process, or what. The header says
'Content-Type: text/plain; charset="utf-8"'

Looking at
http://groups.google.com/group/micro...0c80e7f9546cd0
it comes thru in what looks like maybe Cyrillic.

So anyway, I wonder if this is some coding that Money is not
understanding.



  #2  
Old 12-18-2006, 08:40 AM
Max
Guest
 
Posts: n/a
Default Re: Importing into money

Hi,
Thanks for the help. I am using XL2QIF to export and importing it into
Money 2007 Home & Business.

Here are some sample lines:
=
!Type:Bank
D29.03.2006
U-445.00
T-445.00
PКомиссия за Банк-Клиент
MЕжемесячное обслуживание (Февраль
2006г. ) системы Банк-Клиент. НДС не
облагается.
^
D31.03.2006
U-200.00
T-200.00
PКомиссия в руб. за ведение счета
Юр.л.*езиденты.
MКомиссия за ведение расчетного счета
за март 2006 г. Без НДС.
^
D25.04.2006
U164790.00
T164790.00
PНевыясненные сумм
M{VO70070} Зачисление средств на счет
согласно приложения.
^
=

Thanks.
  #1  
Old 12-15-2006, 04:17 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Importing into money

In microsoft.public.money, Max wrote:

- quote -

> My bank uses a non standard way to export my transactions. I bring
> these into Excel, then perform some manupulations and export using
> XL2QIF. My QIF file contains: Date, Payee, Amount, Memo
> When I try to import the resulted file into Money using
> "Import-> Downloaded Statement", it imports, shows all the transactions
> as Unaccepted BUT it does not import the memo field for some reason!
> If I import the file using "Import-> Recover Accounts" it does import
> all the fields, but in this case, the transactions are not market in
> bold, to let me know that they need to be accepted (It is very useful
> to have them marked so that I can categorize them and make sure I don't
> miss any transfers.)
> Does anyone have any ideas why the Memo field does not get imported
> during regular import?


You might try including one of the QIF file contents into a reply
post. Just put the contents between lines of equal signs rather than
using an attachment. You can change descriptions if you like.

I assume you have memo lines starting with M.

You might also identify what program you are using.


 
Old 12-15-2006, 03:34 PM
Max
Guest
 
Posts: n/a
Default Re: Importing into money

Anyone? I'll take any ideas or suggestions

  #-1  
Old 12-07-2006, 07:24 AM
Max
Guest
 
Posts: n/a
Default Importing into money

My bank uses a non standard way to export my transactions. I bring
these into Excel, then perform some manupulations and export using
XL2QIF. My QIF file contains: Date, Payee, Amount, Memo
When I try to import the resulted file into Money using
"Import-> Downloaded Statement", it imports, shows all the transactions
as Unaccepted BUT it does not import the memo field for some reason!
If I import the file using "Import-> Recover Accounts" it does import
all the fields, but in this case, the transactions are not market in
bold, to let me know that they need to be accepted (It is very useful
to have them marked so that I can categorize them and make sure I don't
miss any transfers.)
Does anyone have any ideas why the Memo field does not get imported
during regular import?

Thanks.

 

Tags
importing, money
Similar Threads
Thread Forum Replies Last Post
Importing budgets into money
CalamanteA: I would like to import a previously prepare budget into Money. Money has the ability to export a budget from Money into a CSV file (or Excel)....
Microsoft Money 7 11-23-2005 01:58 PM
Importing Data to Money
SrividhyaAnand: hi I am trying to import data from my brank to money. Theproblem i have it the date in the bank statement is of the form dd/mm/yy... so i get an...
Microsoft Money 1 09-09-2004 04:51 AM
Importing data into money
Lew Shepley: I recently purchased Money to replace, hopefully, a DOS- based system I wrote myself. I have years of transactional data which I want to...
Microsoft Money 2 02-22-2004 02:05 AM
importing from Managing Your Money
Marshall St. Clair: Is it possible to import from Managing Your Money?
Microsoft Money 2 01-02-2004 10:46 PM
Importing Money files
Steve M: I just purchased MS Money 2004 and wanted to import my existing files on MS Money 3.0. Having trouble doing this. Have any suggestions?
Microsoft Money 1 12-07-2003 05:11 PM



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT. The time now is 10:14 PM.