comments inline.

"P.Constantineau" <jpconstantineau[at]gmail.com> wrote in message
news:1144034435.443992.192210[at]e56g2000cwe.googlegroups.com...
- quote -

You could also do this in memo if your plan is to grind through the data in
Excel via MoneyLink. That would be my preferred way--as opposed to gucking
up the category list--but I agree it might be hard to keep it normalized.

- quote -

I councluded that 3 and 4 were unnecessary information; but I did it in a
more rigorous--it'd balance--way.

- quote -

Sound to me like it's almost time to quit worrying about who owes who what.

- quote -

Not directly. But you can reverse engineer their DLL entry points from their
VBA code they expose in the AddIn.

- quote -

I like the MoneyLink and Excel idea.

All I would need to do is to double up some categories where we need to
distinguish between who's it is meant to be. MoneyLink would then get
the information through to excel. Since most transactions are shared,
I could assume that everything is shared unless it is in a "his" or
"hers" category/subcategory.

I could create a macro to do the grunt work of fetching the data and
performing all the calculations.

Excel would automate what we were doing prior to entering things in
Money:
A card for the balance owed and a sheet of paper with 4 columns:
1 - Shared stuff He paid
2 - Shared stuff She paid
3 - Money he took from the shared account (or put in)
4 - Money she took from the shared account (or put in)

When the sheet was filled, our calculations were simple: add all the
columns and divide the expenses.
- quote -

expenses, we could tell who owed who and add/substract that from the
balance card. That was relatively simple... All I need to to is
somewhat recreate that in excel from the data Moneylink gives us.

Of course it would be a bit more complex than that 4 column paper sheet
(we now have a mortgage...) but it would replicate pretty much what it
was doing... With more accuracy, more details and much faster... It is
also quite similar to all the equations you have indicated.

Are there user callable functions to Money link? I could call the
functions directly instead of always filling out the same popups. It
would also simplify the data analysis through VB.

Thanks a lot for the path forward...

The only way this can be done is the partnership model. This model
requires 3 accounts: His, Hers, a n d The Partnership.

The Partnership will own financial assets and liabilities. eg Bank
account and credit card. All joint expenses are paid from this. It
should be easy to open a joint checking account and credit card. You
can fund this to any percentage you guys decide perhaps based on
incomes.

arthur
==

On 2 Apr 2006 15:14:53 -0700, "P.Constantineau"
<jpconstantineau[at]gmail.com> wrote:
- quote -

There is probably no good way to sort this out once it's all in one Money
file. Likewise, there is no good way to view budgets and so forth
holistically if your accounts are in three Money files.

It hurts my head to even think about how to tackle this problem when the
data starts in Money. Excel and MoneyLink come to mind, but there's no way
to get the classification out using MoneyLink.

I think the basic model comes down to:

treat expenses as -, income as +
it doesn't matter what account the expenses and income are entered in in the
first place, only who they are assigned to

HisExpTotal = sum(HisExpTxns) + HisShare(sum(JointExpTxns))
HerExpTotal = sum(HerExpTxns) + HerShare(sum(JointExpTxns))

HisIncTotal = sum(HisIncomeTxns) + HisShare(sum(JointIncomeTxns))
HerIncTotal = sum(HerIncomeTxns) + HerShare(sum(JointIncomeTxns))

HisBal_ShouldBe = HisBegBal + HisExpTotal + HisIncTotal
HerBal_ShouldBe = HerBegBal + HerExpTotal + HerIncTotal

HisBal_Is = sum(HisAcctBals) + HisShare(sum(JointAcctBals))
HerBal_Is = sum(HerAcctBals) + HerShare(sum(JointAcctBals))

This should yield an identity function:
HisBal_ShouldBe - HisBal_Is != - (HerBal_ShouldBe - HerBal_Is)

This value and its sign indicates who owes who what. (+ came out ahead and
owes, - came out behind and is owed.) Disclaimer: no warranty offered or
implied. Drop me an email if you want the Excel sheet I just proved this
with.

You could probably come up with reports to tell you:
sum(HisExpTxns)
sum(HisIncomeTxns)
sum(HerExpTxns)
sum(HerIncomeTxns)
sum(JointExpTxns)
sum(JointIncomeTxns)
sum(HisAcctBals)
sum(HerAcctBals)
sum(JointAcctBals)

You'd probably have to separately keep track of:
HisBegBal (which is HisBal_ShouldBe from prior cycle, assuming you settled)
HerBegBal (which is HerBal_ShouldBe from prior cycle, assuming you settled)
HisShare(x)
HerShare(x)

Good luck with the problem. And the relationship.

"P.Constantineau" <jpconstantineau[at]gmail.com> wrote in message
news:1144016093.568345.69760[at]v46g2000cwv.googlegroups.com...
- quote -

Hi all,

My girlfriend and I are having trouble figuring how to use money 2005
to indicate us how much we owe each other. I have setup Money 2005
over a year ago and have been entering all our transactions and the
accounts do balance. Our problem comes when the following question
arises: "How much do I owe you?"


Here is how I have setup money 2005:

1 Money File for all personnal (his and hers) and shared accounts &
credit cards.
Every transaction is categorized (food, phone, interest, etc) and has a
classification.

In short here are our accounts:
"His" Checking Account
"Hers" Checking Account
"Ours" Checking Account

"His" Credit cards
"Hers" Credit cards
"Ours" Credit card

Most bills are paid from the "ours" account. This include "His" and
"Hers" expenses.
Some shared bills are paid from the personal checking accounts.

All shared living expenses (phone, food, power, car, etc) are divided
in two (50%/50%)
All home expenses (Mortgage, interests, improvements, strata fees) are
also shared (50%/50%) but are counted separately.

Classifications:
"His"
"Hers"
"Shared"
"Shared - Home"
"Transfer"
"Equalization"

The "transfer" classification is used for money transfers and credit
card payments.

The "equalization" classification is used when I make "fake transfers"
from the actual accounts to the "fake" asset accounts to figure out how
much one owes the other.

Asset Accounts:
"Hers" Shared Expenses
"Hers" Shared Home Expenses
"His" Shared Expenses
"His" Shared Home Expenses
"He owes Her"
"He owes Her - Home"
"She owes him"
"She owes him - Home"

How do I figure out How much is owed to who?
I have been trying to do it on a quaterly or yearly basis, however, I
have to re-figure it out every single time. I struggle with figuring
out which report I should use on each account and sorted in whatever
way.

Is there an easy way to do this?

One of the options I have seen is to create a liability account and
transfer every

transaction in and out of the account. The problems with that are:
- you cannot assign a category to these transfers.
- I have 3 years of transactions to take care of if I want to convert
it all this way.

This method would be useful for keeping track of each of our job
expenses which are reimbursed, however, I do not think it will work for
day to day expenses which must be categorized for our budget.

There must be a way to set it up such that there is an easy way to keep
track of the shared/non-shared expenses and how much we owe each other.

I am sure someone else is in a similar situation and already figured it
out.

Thanks

Thanks for