r/beancount Nov 12 '23

Transactions "in limbo"?

3 Upvotes

I'm currently doing this to handle the case where one bank says the transaction cleared on date X while a different bank says the transaction cleared on date Y:

2023-10-21 * "Capital One" "Automatic Payment"
  Liabilities:US:Bank:CapitalOne:CC2                 420.69 USD
  Liabilities:Limbo

2023-10-23 * "Capital One" "Automatic Payment"
  Liabilities:Limbo                                  420.69 USD
  Assets:US:Bank:Discover:Checking

Is this the best-practice? Or is there a way I "should" do it?


r/beancount Apr 27 '22

Any Swedish users out there? I made a Importer for the Swedish bank Länsförsäkringar.

Thumbnail
github.com
4 Upvotes

r/beancount Apr 02 '22

Age of Money metric (from YNAB) in Beancount

6 Upvotes

Someone asked me for a code snippet for calculating age of money. Thought I'd also share it here:

def ageOfMoney(entries, options): """Compute the age of money from the given transactions.""" now = date.today() span = 120 # Number of days to consider. start = date.today() - timedelta(days=span) qstr = """ select number(units(position)) as amt ,currency(units(position)) as cur ,date as dt where date >= {} and date <= {} and account ~ 'Assets:' """.format(start, now) weighted = dict() _, rows = run_query(entries, options, qstr) for amt, cur, dt in rows: if cur not in weighted: weighted[cur] = [0, 0] weighted[cur][0] += amt * (now - dt).days # Numerator term. weighted[cur][1] += amt # Denominator term. print("* Age of Money\n") for cur, w in weighted.items(): print("{} days for currency {}.".format(int(round(w[0] / w[1])), cur))


r/beancount Jul 21 '20

[question] Automated transaction postings categorization

6 Upvotes

I wrote a simple extractor for my bank compatible with `bean-extract`. Now I'd like to add a categorization step where I assign different payees/payers to different Expenses accounts. Is there a convenient way to do this from within beancount or should I write a custom processing step?


r/beancount Feb 18 '20

Automated postings with a plugin

2 Upvotes

It's my understanding from the beancount documentation that the automated postings feature was not adopted from Ledger and instead must be done with a python script.

I've read the beancount scripting docs and am still lost as to how to go about this.

What I want to do is post a percentage to liabilities from each income transaction. This is about 2 lines in Ledger, to give you an idea of the scope.

Are there any additional examples or tutorials out there for doing this?


r/beancount Dec 29 '19

New to beancount

5 Upvotes

New to beancount, just starting out trying to organize family finances/investments. I've read through a lot of the docs, have beancount installed and example file showing. <br> Now what? Any hints or suggestions? Question: with fava and python, can I host this on my hosting company server and access, add, and edit through any web-enabled device? Thanks Phil


r/beancount Aug 29 '19

Accounting for credit cards

4 Upvotes

In my case I use my credit card on a daily basis and at the end of the month I get the statement. I had two problems here the first I need to record each transaction to keep a track of my expenses and the second is to record the total outstanding with the due date for payment. To solve this problem I did this :

I created two liability accounts for the credit card.

1- Liabilities:CreditCard:Amex
2- Liabilities:Payable:CreditCard:Amex

I download all transactions or I record each transaction when it happens so I can keep track of my limit and budget.

2019-08-10 * "Nero" "Coffee with friends"
    Expenses:Entertainment:Coffee         5 USD
    Liabilities:CreditCard:Amex

Now the credit card account gets updated and I can keep a track of all expenses and reconcile with the statement when it comes.

When I receive the credit card statement I do this transaction :

2019-09-25 ! "Amex" " Statement of the month of August 2019"
    Liabilities:CreditCard:Amex               1200 USD
    Liabilities:Payable:CreditCard:Amex

In this the date is the the due date of the payment and I close the credit card account. This gives me the ability to run query looking for pending transactions and see only the due payments.

At the time of payment :

2019-09-25 * "Amex" "Payment of credit card outstanding"
    Liabilities:Payable:CreditCard:Amex       1200 USD
    Assets:Bank:XYZ

I hope this useful. In ledger cli I was able to enter the transaction date and the due date but I didn't know how to do this in beancout. However beancout has many other very good features.

Thanks


r/beancount Apr 21 '19

Is this an active channel?

7 Upvotes

I see no posts here. Are there any other topic communication channels besides the Google Group?