summaryrefslogtreecommitdiff
path: root/contrib
Commit message (Collapse)AuthorAgeFilesLines
...
* Improve spreadsheet and debugging output.Bradley M. Kuhn2013-02-181-6/+10
|
* This could be for any period, not just the FY.Bradley M. Kuhn2013-02-181-1/+1
|
* Correct account names due to renaming of Conference accounts in chart of ↵Bradley M. Kuhn2013-02-181-4/+4
| | | | accounts.
* Remove output of TXT files. CSV output is adequate.Bradley M. Kuhn2013-02-181-13/+0
|
* 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.
* Support for title: field, to name sheets in the ODS file.Bradley M. Kuhn2013-02-181-1/+4
| | | | | If "title:SOMETHING" occurs in the CSV file, use SOMETHING as the title of the sheet.
* Start search from date: easy way to resume searches.Bradley M. Kuhn2013-02-181-5/+5
| | | | | | Instead of always starting a search from the end date, allow a CLI option that is the data to use for the start of searching (back from the end date). This is useful when resuming a search (since they take a long time).
* Finish reporting details for STDOUT; change command line arg to bank balance.Bradley M. Kuhn2013-02-181-20/+40
| | | | | | | Report in CSV now goes to STDOUT. The command line argument that was the difference to seek is now the bank balance.
* Default to brute-force subset sum solution.Bradley M. Kuhn2013-02-181-8/+44
| | | | | | The dynamic programming version of the subset sum problem required far too much RAM for larger bank balances. Meanwhile, the brute-force is not to bad now that the loop tries the closer dates *first*.
* Support for a list of known checksums of files already copied over.Bradley M. Kuhn2013-02-181-9/+70
| | | | | | | | | | For the times when we want to make shorter names of files by doing copies of the documentation files for hyperlink usage, allow input of a new command line option which is a list in the form of: PATH_TO_FILE : sha25sum so that those files can be used rather than new copies made.
* Rename the function to note it's the dynamic programming one.Bradley M. Kuhn2013-02-181-2/+2
|
* Loop through to build smaller sets when testing.Bradley M. Kuhn2013-02-181-29/+52
| | | | | | | Usually, transactions that didn't appear are nearby in date to the statement date. This loop cycles through. Overall, this would take longer to find a solution, but since most solutions are in the early dates "back" from the statement date, this will probably be faster in typical cases.
* Basic implementation probably correct, but needs much RAM.Bradley M. Kuhn2013-02-181-9/+36
| | | | | This is the basic implementation but for large numbers, it needs a *LOT* of RAM.
* Began work on script to reconcile bank accounts.Bradley M. Kuhn2013-02-181-0/+122
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | The goal here is to take as input an account, a monthly balance amount that appears on a bank statement, and the date of that bank statement and output the list of transactions that likely weren't cleared properly as of that date that caused the balance in the accounts to fail to match the balance that appeared on the statement. Note that determining this answer requires solving the known NP-Complete problem called the subset sum problem. There is a known pseudo-polynomial dynamic programming solution to this problem, but it's still exponential in the size of the numbers you have to balance. So, if you have *big* account balances, this will make take quite a while to run. For smaller accounts, the pseudo-polynomial solution might be helpful. (BTW, the wikipedia entry on the subset sum problem isn't, at the time of this commit, particularly good, but it's "good enough" to give you a sense of what the subset sum problem is: http://en.wikipedia.org/wiki/Subset_sum_problem ) I originally wrote the subset sum problem solution implementation here: https://gitorious.org/bkuhn/small-hacks/commit/2dca069d810b61cdfad46e00abcb1a3edaf56d1b The code is just cut and pasted in here with some minor modifications. This rest of this first commit just has that aforementioned paste, plus the beginnings of the CLI and query to run to get the proper entries.
* Add --single-file-directory option: create single directory with all linked ↵Bradley M. Kuhn2013-02-181-5/+46
| | | | | | | | | | | | | | | | files. This new option copies all files to the directory specified as an argument to the --single-file-directory option, and also creates dummy shorter filenames for the files. This feature was implemented to get around a problem found when zip'ing the spreadsheet up with the supporting files for users on Windows. The Windows users encounter the error 0x80010135 related to some of the ZIP files going beyond the maximum path name length on windows. Apparently, opening ZIP files with long path names just doesn't work on Microsoft systems. I've suggested our accountants switch to a Free Software operating system, but they declined.
* Merge pull request #90 from rladams/nextJohn Wiegley2013-01-297-0/+1192
|\ | | | | Next
| * Moved over some shortcut functionsadamsrl2012-10-151-6/+136
| |
| * Added raw copies of my custom ledger scripts and elisp additions. Next need ↵adamsrl2012-08-226-0/+1057
| | | | | | | | to isolate features and make them more generic for reuse by other Ledger users.
| * Created contrib/raw for examples to be shared among advanced Ledger users ↵adamsrl2012-08-221-0/+5
| | | | | | | | and made generic to enable code reuse.
* | The restricted fund report has been almost entirely rewritten.Bradley M. Kuhn2013-01-061-70/+151
| | | | | | | | | | The previous version was somewhat confusing anyway. Now it builds a relatively clear spreadsheet of all categories. It also now outputs CSV.
* | More flexible CSV -> ODS hyperlinks and pagebreaks; csv2ods.py produces ↵Bradley M. Kuhn2013-01-063-21/+32
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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.
* | Correct sorting of output in trial balance report.Bradley M. Kuhn2013-01-061-3/+6
| |
* | Completed report on unpaid accruals.Bradley M. Kuhn2013-01-061-3/+29
| |
* | Ordering of options had always been incorrect on this call; Fixed.Bradley M. Kuhn2013-01-061-1/+1
| |
* | First crack at an unpaid accruals report.Bradley M. Kuhn2013-01-051-0/+84
| |
* | 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.
* | MANIFEST file is now also generated by general-ledger report.Bradley M. Kuhn2013-01-041-0/+10
| | | | | | | | | | We should give the sample MANIFEST for users that want to make sure they got the script working properly, and to show the sample output.
* | Updated expected test output data for general-ledger report.Bradley M. Kuhn2013-01-043-4/+6
| |
* | Corrected Trial Balance report based on discussion with accountants.Bradley M. Kuhn2013-01-041-26/+57
| | | | | | | | | | I believe this trial balance report will look "more natural" to accountants.
* | Sort of accounts was buggy; it never made the final else due to bad regexes.Bradley M. Kuhn2013-01-042-24/+33
| | | | | | | | This fix now has the sort working correctly.
* | Some minor formatting fixes for the trial balance report.Bradley M. Kuhn2013-01-031-2/+2
| |
* | Change Income and Expenses reports to generate CSV files, rather than TXT files.Bradley M. Kuhn2013-01-031-17/+18
| |
* | Add option to skip generating the page breaks.Bradley M. Kuhn2013-01-031-5/+9
| |
* | Convert trial-balance report to CSV from TXT file.Bradley M. Kuhn2013-01-031-6/+17
| | | | | | | | Also, ignore Ledger's Equity: accounts properly.
* | Changed balance sheet output from a TXT file to a CSV file.Bradley M. Kuhn2013-01-031-8/+8
| |
* | 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-032-13/+63
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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?
* | Created Trial balance report for summary reports.Bradley M. Kuhn2013-01-031-1/+30
| |
* | 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.
* | Print date in a more friendly format.Bradley M. Kuhn2012-11-261-4/+12
| | | | | | | | | | Includes issue of "ends on" date being correct for mere mortals as opposed to being right for Ledger only.
* | Adapted for use with Ledger 3.Bradley M. Kuhn2012-11-261-8/+14
| | | | | | | | Includes forcing of -V so all currency is in default.
* | Support selection of string encoding.Bradley M. Kuhn2012-11-261-2/+7
| | | | | | | | | | Allow command line option that permits specification of string encoding, passed to Python's unicode() function.
* | Expense report favors Conferences first,Bradley M. Kuhn2012-11-261-14/+15
| | | | | | | | | | then takes Travel as if it were an Other category only after categories have been handled.
* | 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
| |
* | Fixed output.Bradley M. Kuhn2012-11-261-1/+1
| |
* | Various changes to get the script working.Bradley M. Kuhn2012-11-261-10/+20
| |
* | First attempt at this cash-receipts-and-disbursments-journals.plx script,Bradley M. Kuhn2012-11-261-0/+131
| | | | | | | | | | | | | | | | | | based on general-ledger-report.plx The general-ledger-report.plx was originally found in this repository: http://gitorious.org/bkuhn/small-hacks/blobs/master/general-ledger-report.plx And these early commits on cash-receipts-and-disbursments-journals.plx were fro that repository as well, in: http://gitorious.org/bkuhn/small-hacks/blobs/master/cash-receipts-and-disbursments-journals.plx
* | Expenses report completed.Bradley M. Kuhn2012-11-261-0/+101
| |
* | Generate income report.Bradley M. Kuhn2012-11-261-14/+67
| |
generated by cgit v1.2.3 (git 2.39.1) at 2025-01-01 16:47:23 +0000