On Tue, Jun 22, 2010 at 01:58:06PM -0700, ed wrote: > Working towards establishing my first ledger system and wondering how > to go about version control, backups, security etc. > > How do people enter and manage their data? emacs, gnucash, other? I > want to check out gnucash and am wondering about maintaining a > database in mysql/sqlite/postgres so I can get some form of integrity > checking and audit trail. > > Just curious what other people are using. > > Ed >
Alright, I'll weigh in. The most complicated use of Ledger I have is my extensive expense reporting. As I spend money on my client's behalf while traveling, I have to create itemized reports to seek reimbursement. While it sounds simple, having different clients, sources of money, classifications, the complexity adds up. I have a single directory tree which is stored in Bazaar. I use CSV2Ledger to process my incoming CSV data from my credit card into Ledger entries, which are written to Queue.dat in my base directory. My main ledger file ".ledger" contains nothing but "!include" lines for each subsequent file. I assign transactions to expense reports (ie: AISER0000) using metadata in the Queue file. Once the pending transactions are tagged, I run a shell script which relocates any transactions from Queue.dat to Reports/AISER0000.dat, adds any new report files to Bazaar, and updates the include list in the main file. I have additional data files in my Data/ directory by year, bin/ for scripts, Archive/ for previously imported CSV files, and PDF/ for the resulting PDF expense reports from the ledger data. The workflow goes pretty smoothly nowadays, I'm happy with it. I know my data is a specific use case, but it works great! ------------------------------------------------------------------ Russell Adams [email protected] PGP Key ID: 0x1160DCB3 http://www.adamsinfoserv.com/ Fingerprint: 1723 D8CA 4280 1EC9 557F 66E8 1154 E018 1160 DCB3
