summaryrefslogtreecommitdiff
path: root/contrib/non-profit-audit-reports/general-ledger-report.plx
Commit message (Collapse)AuthorAgeFilesLines
* Use "ledger accounts" command rather than the '-F "%150A\n" reg' report ↵Bradley M. Kuhn2013-07-121-2/+1
| | | | | | | | | | | | | | | solution. Ledger has had (probably for some time) an "accounts" command that will list all the accounts from all transactions meeting the other criteria set on the command line. That's really what we're looking for here when we build this chart of accounts, and thus that should be used. Note that this corrects a subtle bug that wasn't apparent with the old solution. With the '-F "%150A\n" reg' solution, accounts that balanced out to zero for period (e.g., accrual accounts that were emptied during in the month) did not show up on the reports. This bug that I didn't know I had here is thus now fixed by switching to the "accounts" report.
* The $formattedBeginDate should derive from $beginDate, not $endDate (duh!)Bradley M. Kuhn2013-07-101-1/+1
|
* Equity and Adjustment accounts should not appear in these reports at all.Bradley M. Kuhn2013-02-191-1/+1
| | | | There were a few spots where they were still sneaking in.
* Correct regular expression for account queries to avoid inclusion of ↵Bradley M. Kuhn2013-02-181-2/+2
| | | | | | | | | | | | | sub-accounts. The previous queries had a bug whereby an account in the form "A:B" would include all transactions for sub accounts such as "A:B:C". That's not the intended effect. Entries should appear in the lowest level account, and not in their parent. The regular expression now is anchored at start and finish in both queries to ensure this works correctly.
* More flexible CSV -> ODS hyperlinks and pagebreaks; csv2ods.py produces ↵Bradley M. Kuhn2013-01-061-2/+4
| | | | | | | | | | | | | | | | | | MANIFEST. Previous version of csv2ods.py simply assumed that fields beyond five would have links to files. This obviously lacked flexibility and was a silly hard-code. Now, those CSV fields that have link:SOMETHING will cause a hyperlink to be created to SOMETHING. Meanwhile, the pagebreak support was similarly hard-coded. Now, any CSV field that has the word "pagebreak" in it will generate a pagebreak. The general ledger and cash receipts/disbursement journals have been modified to make use of these new features in csv2ods.py. Finally, the --skip-page-break option is now moot in csv2ods.py, so that is herein removed.
* Add balances for permanent (i.e., asset) accounts.Bradley M. Kuhn2013-01-051-3/+41
| | | | | | Based on a request from our accountants, I've changed the RUNNING TOTAL field (which is generally useless to accountants anyway) to be a BALANCE amount for starting and ending accounts.
* Sort of accounts was buggy; it never made the final else due to bad regexes.Bradley M. Kuhn2013-01-041-12/+17
| | | | This fix now has the sort working correctly.
* Change chart of accounts output to be a CSV file instead of TXT file.Bradley M. Kuhn2013-01-031-9/+21
| | | | This includes adding a formatted start date string too.
* Updated sorting function based on advice of auditing accountants.Bradley M. Kuhn2013-01-031-13/+33
| | | | | | | | | | | | | | | | Our auditing accounts tell us they want accounts sorted by: Assets Liabilities Net Assets Income Expenses in a general ledger report. Generally, I think we should just apply the same sorting. Since Ledger doesn't use account codes by default, this is my hack to solve this problem for now. Maybe there should be an account code tag for sorting purposes at least?
* Verify that files are not duplicated in the MANIFEST.Bradley M. Kuhn2012-11-261-1/+3
| | | | | Keep a hash so that file output to the MANIFEST file doesn't have duplicates of the same file name in it.
* Ignore <Adjustments> accounts.Bradley M. Kuhn2012-11-261-0/+1
|
* Use -V to normalize currencies in general-ledger report.Bradley M. Kuhn2012-11-261-3/+3
|
* MANIFEST output file that indicates which files are mentioned in general-ledger.Bradley M. Kuhn2012-11-261-2/+12
| | | | | | | | | Due to reporting options given to ledger, not every file will be referenced by the general-ledger spreadsheet. The generated MANIFEST file now indicates which files were actually referenced in the general-ledger. The demo.sh script now uses this MANIFEST to create a zip file that contains only those files.
* Support a broader set of possible tags to be placed into the spreadsheet.Bradley M. Kuhn2012-11-261-2/+10
| | | | | | | | | | I've now made a hard-coded list of potential tags that are supported and will be linked to in the general ledger spreadsheet. This list should probably be in a configuration file of some sort eventually, rather than hard coded. Indeed, note that the hard-coding goes into two different scripts, and thus the lists could easily get out of sync.
* Receipt/Invoice are additional information thus better if they're final columns.Bradley M. Kuhn2012-09-081-2/+2
| | | | | | | | | Change the column of Receipt and Invoice in the CSV file first, then the generated ODS file must have the same change propagated, which requires changes to the column numbers hard-coding in csv2ods.py. Perhaps if/when this application is refactored these things shouldn't be hard-coded in this way in the first place.
* First pass technical study of creating ODS from ledgerTom Marble2012-09-081-3/+2
|
* Updated copyright notice to reflect reality.Bradley M. Kuhn2012-09-071-1/+2
| | | | Both Tom and I have made copyrightable changes to this file this year.
* Changed general-ledger-report.plx to use tags for Receipt and Invoice (was %N)Tom Marble2012-09-071-2/+1
| | | | Added sample PDF artifacts for the example (see README)
* There needs to be at least 3 args here, clearly.Bradley M. Kuhn2012-09-071-1/+1
|
* A few fixes to make this work with Ledger 3.x instead of 2.6.2Bradley M. Kuhn2012-09-071-5/+5
| | | | | * --wide-register-format is no long an option, use -F * %D now must be %(date)
* Switch ledger binary to /usr/local/bin/ledger.Bradley M. Kuhn2012-09-071-1/+1
|
* General ledger reporting script, used for preparing a report for non-profit ↵Bradley M. Kuhn2012-09-071-0/+128
auditors. I developed this, and therefore have the full git commit history, in my personal "Small-Hacks" repository, which can be cloned from: git://gitorious.org/bkuhn/small-hacks.git More details on that are available by visiting: https://gitorious.org/bkuhn/small-hacks
generated by cgit v1.2.3 (git 2.39.1) at 2025-01-04 08:35:51 +0000