Shared expenses with shared assets

General
1

I am going insane trying to select the best approach to include in my ledger shared accounts with my partner. I began to trace my personal finances with my personal assents, liabilities, expenses and income. However, now I need to track also shared accounts with my partner. I do not want to track the personal finances of my partner, only shared accounts with me. And what I think is different from the examples of plaintextaccounting.org is that we have not only shared expenses but also shared assets: one shared bank account and some cash in a wallet.

I am considering two setups:

  • 1 unique ledger with my personal accounts and shared accounts (this is my current setup).
  • 2 independent ledgers, on for personal accounts and one for shared accounts.

1 unique ledger (current setup)

This is my personal ledger where I add also the shared assets (assets:partner:bank and assets:partner:cash). But to reflect that I own the half of shared assets I also have a liabilities account (liabilities:partner).

So these is an example of my transactions

2024-01-01 my contribution
    assets:partner:bank  100.00 EUR
    assets:bank

2024-01-01 my partner contribution
   assets:partner:bank  100.00 EUR
   liabilities:partner  

2024-01-02 pay shared bill
    assets:partner:bank  -100.00 EUR
    expenses:house  50.00 EUR
    liabilities:partner  50.00 EUR

This way I have the assets and liabilities of the shared accounts I owe added to my personal wealth. I have better understanding of the expenses. Expenses are the half of the real expense, because my contribution to this partnership is 1/2. Handicap is that transaction may be a bit more complex but I was able to automate most of them with hledger import .

2 independent ledgers

Another solution would be to have two independent ledgers. One ledger for my personal finances where my contribution to shared accounts is an expense:

2024-01-01 my contribution
     expenses:partner  100.00 EUR
     assets:bank

One additional ledger with shared income where contributions are income and then we have the shared expenses:

2024-01-01 my contribution
     assets:bank  100.00 EUR
     income:me 

2024-01-01 my partner contribution
     assets:bank  100.00 EUR
     income:partner

2024-01-02 pay shared bill
     expenses:house  100.00 EUR
     assets:bank

I like this approach because the two ledgers symbolize the wealth of two different concepts: my personal wealth and the wealth of our partnership. However, I see difficult to have an overall view of my personal expenses because the account expenses:partner of my personal ledger lacks of the details of the real expenses of the second shared ledger.

What do you think?

2

You can also think your partner as a shareholder and use Equity as corporate finance does.

1 Like
3

One of my auto impossed requirements is to use hledger import to import the CSV of the shared bank account in the assets:partner:bank because this way I can verify that there is no error. The registers and balance of the assets:partner:bank must be the same that those shown in the web page of the bank. Due to this, then I need a liability or a contra-asset account to reduce to the half value this account. So, in this case I think is not possible to use one equity account. Correct me if I am wrong.

4

I haven't (successfully) tracked shared assets like this, only shared expenses. I think I'd need a stronger separation of those accounts to avoid confusion. Eg if I really wanted both my and household transactions in one journal, I might do the following
(I've just used equity for household as @KoreanCPA suggested):

# me+household.journal

2024-01-01 my contribution
    me:assets:bank                              -100.00 EUR
    me:expenses:household                        100.00 EUR
    household:equity:me                         -100.00 EUR
    household:assets:bank                        100.00 EUR

2024-01-01 my partner contribution
    household:equity:partner                    -100.00 EUR
    household:assets:bank                        100.00 EUR

2024-01-02 pay shared bill
    household:assets:bank                       -100.00 EUR
    household:equity:me                           50.00 EUR
    household:equity:partner                      50.00 EUR

Or, I'd go the extra step and split the files:

# me.journal

2024-01-01 my contribution
    assets:bank                                 -100.00 EUR
    expenses:household                           100.00 EUR

# household.journal

2024-01-01 me contribution
    equity:me                                   -100.00 EUR
    assets:bank                                  100.00 EUR

2024-01-01 partner contribution
    equity:partner                              -100.00 EUR
    assets:bank                                  100.00 EUR

2024-01-02 pay shared bill
    assets:bank                                 -100.00 EUR
    equity:me                                     50.00 EUR
    equity:partner                                50.00 EUR

Or, if I needed more detailed reports from household's point of view, I could record expense categories:

# household.journal

2024-01-01 me contribution
    equity:me                       -100.00 EUR
    assets:bank                      100.00 EUR

2024-01-01 partner contribution
    equity:partner                  -100.00 EUR
    assets:bank                      100.00 EUR

2024-01-02 pay shared bill
    assets:bank                     -100.00 EUR
    expenses:foo                     100.00 EUR

#2024-01-31 retain earnings (splitting them 50-50)
#    expenses                                    ==* 0 EUR
#    equity:me                         50 EUR
#    equity:partner                    50 EUR

I haven't done it, but I think all of those could be generated with (multiple runs of) CSV rules (except retaining earnings).

2 Likes
5

Great. If I summarize, I think you are proposing to follow the second proposal, in other words, to clearly separate the accounts in two different ledgers:

  • if one journal file is used, first level accounts (me and household) are used to separate the ledgers.
  • if multiple journal files are used, no need to use the first level account

Another issue that suprises me is the use of equity accounts for the household journal/ledger. From my point of view, from the point of view of the household, there are monthly incomes from contributions and monthly expenses. I do not see the point of equity accounts. Is it a preference over income?

1 Like
6

Think of your household as a company. You(and your partner) invest in a company and the company recognizes the investment as an asset(and equity). Incomes are only for things that are related to business earnings. Liabilities, are, well, liabilities. In corporate finance, it goes into capital stock on the company side and you as an investor get stocks in return. But since it's just personal finance, you mark it as an expense, not an asset, although I would personally mark expense not as me:expenses:household but as me:expenses:{shared expense name}.

I didn't think through this much(I don't live with partner yet) until I read @simonmic's way and that seems like the perfect way to address this, almost perfectly in align with corporate accounting.

2 Likes
7

So household is the worst company I would never invest in! all expenses and no income :sweat_smile: :rofl:

1 Like
8

In the past I probably would have anthropomorphised Household more, imagining it as a third "person" with their own income (gifts from me and partner). That's intuitive, and there'd be nothing wrong with doing it that way. I would always start with the most intuitive arrangement. If journaling from the beginning of Household's bank account, you wouldn't need equity to account for starting balances, and you could avoid mentioning equity at all.

But now, with Household's "income" not being very important, I'd prefer the conventional use of equity, to provide starting balances and also to track ownership ongoingly. In some situations that's a pretty good feature when there's a real shared bank account with a possibly large balance.

In my household we have so far done without the shared asset (bank account) - just tracking a liability back and forth, which if one trusts the accounting (we do :tada:) simplifies things a bit. But I guess there are times when that real bank account is useful; eg it's a more certain cash reserve, as with envelope budgeting.

2 Likes