ledger register account grouping plus subtotal rollup ?

2018-12-13 Thread Jim Robinson
I've got a flat set of account codes I'm using in my timelog, and I will sometimes annotate them with payee details. So for example, in the snippet below SYS-5576 is a general account id for general recurring meetings (ones not tied to a specific project), and so I use the payee to call out whi

Re: Auto-Categorizing Transactions

2018-12-13 Thread Brett Wyrick
You can do all of this within Google Sheets, using two different tabs. *One tab will be for your keywords that will match to Categories.* - The AutoCategories tab will have two columns: Name one range "AutoKeywords" and the other column "AutoCats" (short for Auto-Category). - In the "Au

Re: Tracking payables / finding missing payments

2018-12-13 Thread o1bigtenor
On Thu, Dec 13, 2018 at 8:11 AM Martin Michlmayr wrote: > > I just had a light bulb moment and wanted to share. (This idea is > obviously to many but I am a bit slow ;) > > I have an Assets:Transfer account which I use for transfers. So when I > transfer from bank A to B it goes A -> Assets:Tran

Tracking payables / finding missing payments

2018-12-13 Thread Martin Michlmayr
I just had a light bulb moment and wanted to share. (This idea is obviously to many but I am a bit slow ;) I have an Assets:Transfer account which I use for transfers. So when I transfer from bank A to B it goes A -> Assets:Transfer and Assets:Transfer -> B. Same for credit card payments, etc.

Re: Question on Commodity trading and Capital Gains/Losses

2018-12-13 Thread Martin Michlmayr
* vaibhav.g...@gmail.com [2018-12-12 07:57]: >13.00 CAD Assets:Holdings > > This does not look correct. Shouldn't cash be $50,000? Why does it say > $130,000 (original buying price)? $130,000 is the cash you received ($50,000) plus the capital loss you made ($80,000). You need t