I have written a plugin that allows me to split expenses across tax years and assign fractions of each expense to a tax reporting account as needed. (For example to recover home office expenses) As for dealing with reporting in the other (non-native) currency I do what Martin said - assuming I can write a query that shows all relevent amounts, I just convert the position to CAD while ensuring that I have appropriate pricing data to support the conversions. TBH this made tax-time this year much easier than prior years and very fragile large sheets Alan
On Tuesday, July 20, 2021 at 12:48:44 AM UTC+1 [email protected] wrote: > * Ben Luey <[email protected]> [2021-07-19 08:14]: > > 1) Do this all on the query side. Is there a sql query I can run > > that would do a convert for each transaction that matches some > > criteria and then sum that? Let's assume I've already input the > > USD/CAD exchange rate for all transaction dates into beancount. > > This query will convert from USD to CAD on the date of the > transaction: > > SELECT date, narration, CONVERT(position, 'CAD', date) WHERE account ~ > 'Expenses:Test' > > -- > Martin Michlmayr > https://www.cyrius.com/ > -- 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/821592ad-00c3-4c49-81d6-8284889324b9n%40googlegroups.com.
