RonMcK3 wrote:
- quote -

If I'm underdstanding your intention correctly, OFX will not do
what you want: it has no ability to handle "categories".

QIF files are the only way I know of to "import" transactions
with categories ... and there is software that can create QIF
files from Excel files: Google for "xl2qif", for example.

Not sure that will be an advantage over Dick Watson's approach.

--

John Pollard
First initial underscore Last name at mchsi dot com
Please reply to newsgroup

Hmmm? Well, the answer to my query is that when I export QIF 'loose'
transactions, I get the detail of the paychecks, not just the net amount of
each. Further, the QIF format will be pretty easy for me to build as a text
file export from MS Excel using a VBA macro that I'll write.

I'm going to try creating transactions to reverse out the "net" paychecks
and load in their 'grossed up' and 'split' data so I don't have to manually
edit in that data (4 lines times 24 payrolls).

Following your advice, I did save one of the manually split deposits in
'bills' as a pending deposit; next Tue evening, I'll post it to the account
as an expected Wed deposit and see what happens when MNY downloads from the
bank. Yee Haw!

Thanks for your advice and counsel.

Good night! (Or, good morning ;-)
---
Ron Mckenzie
Orlando, FL


"Dick Watson" wrote:

- quote -

Right. Exactly why I say that even under the absolute best circumstances the
downloaded transaction data can only get you so far.

Since I have the scheduled item and just recycle it weekly, adjusting a memo
item for pay period ending date, and any minor deduction changes--FICA and
Medicare, for instance keep wandering about by $0.01--I've never found any
reason to be interested in somehow generating and then importing it. I'm
sure it's do-able. I'm less certain of a beneficial case to do it.

"RonMcK3" <RonMcK3[at]discussions.microsoft.com> wrote in message
news:AB732AC4-6B0A-498D-ABAE-844808B57F93[at]microsoft.com...
- quote -

I *rarely* export, but there are many ways to do it and the results depend
on the method. QIF is not a method I've found useful for my data mining
purposes.

"RonMcK3" <RonMcK3[at]discussions.microsoft.com> wrote in message
news:689233E4-4D24-493A-8B33-3652907F6455[at]microsoft.com...
- quote -

Dick,

Have you ever exported data from Mny that included a 'split' paycheck? Does
the split $ amt detail come out in the file?

Guess, I'll try it and see what happens since I've entered several splits
already.

Cheers!
---
Ron Mckenzie
Orlando, FL


"Dick Watson" wrote:

- quote -

Dick,

Thanks. I'll try the matter of storing the split as you suggest; for the
time being, I'll do the same transaction edit that you are using.

FIs (Banks, if you will) have no way of knowing what the transaction details
(withholding deductions and/or earnings breakdown by type) are; the payor's
system (whether PayChex or a proprietary system) only transmits the net
payment, payee name, transit number, date, payor name, brief description.
Your (and my) bank has no way of reconstituting the detail. You and I can do
it, either manually or with a well-trained Excel spreadsheet.

I'll check out the OFX/QIF info on your website to see what else I can learn.

I found this link to everything one might want to know about the Quicken
Interchange Format (QIF):
http://web.intuit.com/support/quicken/docs/d_qif.html.

The OFX format appears to be an XML-like format. Here is the same
transaction taken from my QIF and OFX downloads, in that order:

!Type:Bank
D01/22/2008
PPUBLIX 01/20 #000001777 PURCHASE 4744 S APO
T-18.68
C*
^

<STMTTRN<TRNTYPE> DEBIT
<DTPOSTED> 20080122120000
<TRNAMT> -18.68
<FITID> 00094630120-18.680080122209.05
<NAME> PUBLIX 01/20 #000001777
</STMTTRN
The puzzle I'm wondering is whether Mny can import a OFX file of my crafting
where the FITID (financial institution transaction ID) is one of my own
creation (like simple sequential number.

There's some file header information (tags and data) that I omitted from the
OFX data for simplicity's sake.

A little searching with DogPile showed a number of vendors with tools to
convert to/from OSF and/or QIF. The most intriguing is an MS Excel add-in
that uses a spreadsheet for intermediate presentation/manipulation of one's
data. (For a paltry 49.00 USD) I also found an API on SourceForge that I'm
going to look at and see what it will do for me.

---
Ron Mckenzie
Orlando, FL


"Dick Watson" wrote:

- quote -

There is no way to automate the calculation of values in a Money transaction
with one exception: Loan Payments will calculate interst/principal. On the
other hand, Money can remember the last one paycheck for which you entered
all of this information and offer up the assumption that the next one you go
to enter with the same payee is the same set of splits. Likewise, you can
save one that you hand-entered off of your stub into the Scheduled Bills and
then just tweak that which changes from check to check when you fo to enter
it into the register. I get paid weekly. Once a week I spend about 30 seconds
editing and entering that scheduled transaction. Paychecks are one of the
best examples of the limitations of downloaded data. I'll bet fifty years
from now banks will still not pass along information about your pay stub
values from their records of it as a deposit transaction.

See http://umpmfaq.info/faqdb.php?q=8 for QIF/OFX related links. In general
only very specialized tools involved with data conversion can create these.
No general purpose app does it. The list in the ufaq is surely somewhat out
of date, but it's a start. I could spend several hours each month just
validating links like that.

"RonMcK3" wrote:

- quote -

I would like to automate converting the net pay downloaded by online banking,
grossing it up for the FICA, Medicare, and Fed W/H. FICA & Medicare are % of
gross and Fed W/H = Gross - FICA - Medicare - Net.

Things would be tres cool if I could load in the gross for the paycheck and
let MDlx do the rest. It would still be very okay, if MDlx would pre-populate
the split window with the accounts for Gross, FICA, and Medicare.

Can MDlx do any of these?

Besides the Bank and MDlx, what other apps (like MS Excel) create files in
ofx or qif format?

Are file and record layouts available to these formats? (Assuming I wanted
to write my own program to create transactions for import.)

---
Ron Mckenzie
Orlando, FL