On Sun, Sep 3, 2023 at 11:07 AM Eric Altendorf <[email protected]> wrote:
> > > On Sun, Sep 3, 2023 at 09:58 Martin Blais <[email protected]> wrote: > >> On Mon, Jul 24, 2023 at 12:47 PM Eric Altendorf <[email protected]> >> wrote: >> >>> [changing subject line] >>> >>> On Sat, Jul 22, 2023 at 3:41 AM Daniele Nicolodi <[email protected]> >>> wrote: >>> >>>> On 19/07/23 22:03, Eric Altendorf wrote: >>>> > In a related vein, are there other reporting tools I can use with v3 >>>> > to generate even non-interactive reports? >>>> >>>> It really depends on what you intend for reporting tools. I use >>>> beanquery for extracting data from my ledgers, but it is not exactly >>>> what most people would call a reporting tool. >>>> >>> >>> Thanks, I have played around a bit more with bean-doctor and also seen >>> in the documentation what look like a lot of capabilities for reporting. >>> >>> What I would like is a human readable and auditable report of asset >>> transactions, with booking decisions, that justify profit/loss and capital >>> gains numbers. I'm not an accountant so I don't really know if there's a >>> typical format for that type of report. My guess is that a report which >>> shows transactions and how sales are booked against the inventory, with a >>> snapshot of the inventory interleaved every n lines, might be roughly what >>> I want. >>> >>> Any recommendations on what a CPA might want to look at to audit, or >>> which Beancount tools I should investigate to build such a report, would be >>> most appreciated! >>> >> >> I think a Form 8949 equivalent is what they'd be looking for (a >> spreadsheet). >> You'd have to build it yourself (I did something like that in Johnny.) >> > > Fwiw, I talked to my tax preparer about this, and for his purposes all he > needs are the final numbers, like an 8949. My issue with the 8949 is it > doesn’t seem really auditable — if you do the sales as “various” lots then > you can’t verify the gains, and if you split out every single lot the > report becomes a hundred pages and you can’t holistically verify it’s > correctness. I at least want to be able to review and spot check > correctness myself :) > > He said if I took it to an accounting firm to audit, they’d probably want > the underlying trade data to do their own analysis. And he said if the irs > audits, it’s unpredictable, likely they wouldn’t be sophisticated enough to > process raw trade data so it sounded like grokkable reports could be > helpful there. > I think I've mentioned this in person but it's worth adding a link to future readers of this thread finding themselves here: "TradeLog" is likely the most sophisticated tool for doing something like this for retail traders in general: https://tradelog.com/ I don't know how well it supports crypto but it has some pages here: https://support.tradelogsoftware.com/hc/en-us/articles/360001914193-How-TradeLog-Handles-Cryptocurrency-Digital-Currency- These accountants recommend using it for their clients: https://greentradertax.com/ >>> Thanks, >>> eric >>> >>> >> -- >>> 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 [email protected]. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/beancount/CAFXPr0ud5YP-xCqc9jSX%3Dn2X%2Bx9Xjn5g9VKoEpXsU%3Do%2BM38%2BWQ%40mail.gmail.com >>> <https://groups.google.com/d/msgid/beancount/CAFXPr0ud5YP-xCqc9jSX%3Dn2X%2Bx9Xjn5g9VKoEpXsU%3Do%2BM38%2BWQ%40mail.gmail.com?utm_medium=email&utm_source=footer> >>> . >>> >> -- >> 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 [email protected]. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/beancount/CAK21%2BhPoebYAuM7L-rzXy9vNpHt3%2BCrHrD4Afk4QujGJc2726g%40mail.gmail.com >> <https://groups.google.com/d/msgid/beancount/CAK21%2BhPoebYAuM7L-rzXy9vNpHt3%2BCrHrD4Afk4QujGJc2726g%40mail.gmail.com?utm_medium=email&utm_source=footer> >> . >> > -- > 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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/beancount/CAFXPr0v-_cf0gvnzajoycwDPmhWWP-Wd4h3-qu0%2B5AHZGGmR7A%40mail.gmail.com > <https://groups.google.com/d/msgid/beancount/CAFXPr0v-_cf0gvnzajoycwDPmhWWP-Wd4h3-qu0%2B5AHZGGmR7A%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/CAK21%2BhN4GtmHdcp5ANxa_g15ZfsUubbNwOvQzHXp%2BCT0VYR05A%40mail.gmail.com.
