Generating a list of vendor payments (for 1099s)

[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 ~ '^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

[Chary Chary]

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?

[Martin Michlmayr]

* Daniel Schultz <sli...@gmail.com> [2024-02-01 13:02]:

> 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?

I'd write a Python script that handles the exceptions.

--
Martin Michlmayr
https://www.cyrius.com/