Allow rounding when all value amounts are fixed

2024-01-21 Thread Daniel
I am trying to use this entry that beangulp exports: 2023-12-22 * "Buy XYZ" "Buy 86.546 XYZ with 6987.69 USD @ 80.74 USD/XYZ" Assets:Account:USD -6987.69 USD Assets:Account:XYZ 86.546 XYZ @ 80.74 USD But when I run bean-check, I get: Transaction does not balance: (0.03404 USD) XYZ is tracked to

Re: Is Python >=3.5 okay?

2016-10-25 Thread Daniel Clemente
Devuan (and Debian) stable includes Python3.4, and that's what I'm using, but I enabled the „testing“ repository and could install python3.5 easily without dependency hell. Building the parser requires more libraries but they seem to be easy to install too. I'm ok with keeping beancount on the

Re: org-mode + beancount, how to quickly reorganize?

2017-02-05 Thread Daniel Clemente
> The problem here is, how do I quickly get to where I want it to go? Under a > Type->Institution heading I have a chronologically sorted list > of transactions, and I'd want the newer ones to be somewhere near the end > (especially for large files with lots of transactions). Currently > I have

Re: Balance, Pad, and 'why should I use an equity account'?

2017-04-14 Thread Daniel Clemente
> > My question is - should my 'unaccounted transactions' be considered > an equity transfer or an expense? My previous reason for listing > this as an expense is that the cashflow tracked here is almost > always actually a (forgotten) expense, and should thus show up as > something I've spent. I

Re: Recording in-kind (ACATS) transfers

2017-08-25 Thread Daniel Clemente
> However, if you have lots of lots having to list them all (twice!) is a bit > painful. Is there a shorter syntax that I haven't found? > > The scenario is: imagine after doing years of monthly purchases you switch to > a new brokerage. You might have 100+ lots. Ideally you > just want to type

Re: Recording in-kind (ACATS) transfers

2017-08-26 Thread Daniel Clemente
El Fri, 25 Aug 2017 16:30:05 -0700 (PDT) Justus Pendleton va escriure: > > When I need to move all lots, I write the transaction without the lots > (so it doesn't balance) > > How do you write this? I tried a few variants but I must be dim this > morningbecause I couldn't make it not bal

Re: Reports

2018-04-03 Thread Daniel Clemente
I use bean-report for a few commands, mainly to get the price database, and all balances. For most operations I use bean-query or the web interface, which is fast and reliable. I don't use Fava and I feel it adds too much complexity. It depends on a lot of external code that I don't have time to r

Re: Reports

2018-04-10 Thread Daniel Clemente
y prefer it. For instance, I like my way of moving through links with the keyboard, but some clickable things in fava are not , but something different like . And more. JS well used (to bring more exploratory interactivity to graphs and tables) could still be useful. On Sun, Apr 8, 2018 at 1:42 PM

Re: How to account for a partial reimbursement

2019-05-09 Thread Daniel Clemente
In your example, from the 1500 CAD only 500 CAD are from your money, so that's the only expense (and I guess it's the only part you can deduct when filing taxes). The other 1000 CAD are like a loan you're making to your insurance (you're lending them money to pay the bill and you later recover it).

Re: Goodbye bean-web, bean-bake, bean-report. What about bean-price?

2020-07-06 Thread Daniel Clemente
> Checkout branch "v2" if you really must have those right now. > Let me know if you care for those, at this stage I could easily fork a copy to a separate repository (for others to maintain). I still use bean-web from time to time, though I don't depend on it since I have my own scripts to extrac

Beanquery - Return the other account involved in a transaction

2022-11-12 Thread Daniel González
Hi, I'm interested in querying an account for transactions made agains another account in particular. For example let's say I have: 2022-10-01 * "Gas bofa" Assets:BofA:Checking Expenses:Gas 40 USD 2022-10-02 * "Gas WF" Assets:WellsFargo:Checking Expenses:Gas 20 USD

Re: Beanquery - Return the other account involved in a transaction

2022-11-13 Thread Daniel González
gt; 2022-10-03,Gas WF,Expenses:Gas,Assets:WellsFargo:Checking,40,USD > > But if you have more complicated transactions with multiple expenses, > you'll also potentially end up with rows with multiple accounts like this: > > > 2022-07-26,GasAndEat,Expenses:Gas

Aggregate accounts on income statement

2023-03-11 Thread Daniel González
Hi, I'm generating an income statement (with only my expenses) like this: SELECT account, sum(position) FROM OPEN ON 2023-03-01 CLOSE ON 2023-03-30 WHERE account ~ "Expenses" GROUP BY 1 ORDER BY 1 But I have some subdivisions of my accounts that I would like to report one level up. For example

Re: Aggregate accounts on income statement

2023-03-12 Thread Daniel González
: > On 11/03/23 20:27, Daniel González wrote: > > Hi, > > I'm generating an income statement (with only my expenses) like this: > > > > SELECT account, sum(position) FROM OPEN ON 2023-03-01 CLOSE ON > > 2023-03-30 WHERE account ~ "Expenses"

Converting earnings to owner equity

2023-03-14 Thread Daniel Schultz
s / keep track of owner equity using Beancount? Best, - Dan -- Daniel Schultz (he / him) @slifty -- You received this message because you are subscribed to the Google Groups "Beancount" group. To unsubscribe from this group and stop receiving emails from it, send an email to beancou

How should I define linked documents when using includes?

2023-05-05 Thread Daniel Schultz
unt` everything works just fine (but I'd like to be able to organize my transactions) Anybody have ideas what might be going on and how I might be able to resolve it? Best, Dan -- Daniel Schultz (he / him) P: (215) 400-1233 (file:///Applications/Canary%20Mail.app/(null)) T: @slifty W: htt

Additional cookbooks?

2023-08-16 Thread Daniel Schonfeld
Hello, I was wondering if the Taxes part of the cookbook has ever been completed and also if there's a similar cookbook for how to run a typical small business operation(s) as well as the owner entries for putting money into the business and taking distributions from it. Thanks! -- You recei

Re: Additional cookbooks?

2023-08-28 Thread Daniel Schonfeld
Fair enough! But is the taxes section ready? it says in the existing cookbook that's coming soon... On Sunday, August 27, 2023 at 10:16:22 AM UTC-4 Martin Blais wrote: > What's there is all we got. > > > On Wed, Aug 16, 2023 at 5:33 PM Daniel Schonfeld > wrote

Generating a list of vendor payments (for 1099s)

2024-02-01 Thread Daniel Schultz
Hello all, I'm using beancount for my company's books. We use accrual accounting, but I want to generate a report of cash payments to vendors in order to populate 1099s. I can use the following query to calculate *accrued* expenses: SELECT payee, sum(position) WHERE ACCOUNT ~ ACCOUNT ~ '^Expens

Re: Branching transaction import logic (i.e. partially automating imports)

2024-02-10 Thread Daniel Farnand
Thank you all for super helpful answers! I hadn't realized that smart importer wouldn't touch already categorized transactions (obvious in retrospect though!). Thinking about it with that in mind, I'm going to give it a try: import -> rules -> smart_importer. >From there I'll pass everything to so

Filtering accounts by a subquery

2024-10-24 Thread Daniel Schultz
Hello all, I'm generating a campaign finance report, which means I need to load any journal entries for accounts whose *total balance* exceeds $50.00 I figure this is not going to be possible via BQL directly but figured it cannot hurt to ask. The query I would love to use is something along t