Hi, if we just abstract away from the beanery language, how would you as human identify such transactions just looking at the beanqcount ledger text?
Can you as human identify right transactions? If yes, how? On Thursday, February 1, 2024 at 7:03:01 PM UTC+1 sli...@gmail.com wrote: > 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 ~ > '^Expenses:Contractors' GROUP BY payee ORDER BY payee > > but I need something that will show explicitly cash has been paid. > > Alternatively something like this gives me a balance for every payee: > SELECT payee, sum(position) WHERE ACCOUNT ~ ACCOUNT ~ '^Assets' GROUP BY > payee ORDER BY payee > > but this report includs revenues (e.g. accounts with with a positive > position). It also doesn't account for the fact that someone might be paid > in a way that should be excluded from a 1099 (e.g. if they were reimbursed > for an expense) > > Does anybody have suggestions for this use case? > > Best, > - Dan > -- 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 beancount+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/b650cdbc-b8e7-4676-b1c7-61f085adfe92n%40googlegroups.com.
