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/8d334f81-c7b9-4614-9f80-e78f215e9a4e%40Canary.
