Bunch of general reports for Money Manager Ex
Lua Python Go
Switch branches/tags
Clone or download
vomikan Merge pull request #45 from Spoker/ExpenditureHistoryAllExeptVoidAndD…
…uplicate

Exclude void and duplicate transactions in ExpenditureHistory report.
Latest commit 18f6d82 Mar 18, 2018
Permalink
Failed to load latest commit information.
AccountForecast switch to ChartNew.js Oct 27, 2014
AccountSummary switch to ChartNew.js Oct 27, 2014
AccountTrend switch to ChartNew.js Oct 27, 2014
AssetForecast switch to ChartNew.js Oct 27, 2014
AssetsSummary switch to ChartNew.js Oct 27, 2014
AttachmentList New attachment May 8, 2014
BlankNotes This report will show transactions with Blank note fields Feb 28, 2015
BudgetMonitoringCurrentMonth Add base currency symbol to report and fix template variables Jun 25, 2014
BudgetMonitoringLastMonth Add base currency symbol to report and fix template variables Jun 25, 2014
CategoriesStatLast12Months Merge pull request #35 from vomikan/master Feb 3, 2016
CategoryForecast fix date to automatically choose this year Jul 26, 2014
CategoryTrend fix(SQL): Fix problem with split transactions Feb 11, 2016
CreditReport Added and updated reports Apr 5, 2014
CreditReport2 Automated variant of CreditReport Aug 14, 2017
CurrencySummary refine CurrencySummary Oct 30, 2014
DepositVsExpensesAndLoanRepaymentByMonth Typo Jan 20, 2017
ExpenditureHistory Exclude void and duplicate transactions. Nov 17, 2017
ExpenseAndRevenueByMonth fix bug transaction status #28 Apr 9, 2015
ExpenseAndRevenueByQuarter fix bug transaction status #28 Apr 9, 2015
ExpenseAndRevenueByYear fix bug transaction status #28 Apr 9, 2015
FollowUpTransactions added report Aug 17, 2014
GameOfTransferAccount add GameOfTransferAccount Dec 24, 2014
InvalidTransactions Invalid Transactions Dec 18, 2014
OneCategoryList links added Jan 14, 2015
Others Quit Count Feb 23, 2016
PayeeTrend refine PayeeTrend Oct 30, 2014
SavingsProgress Add currency conversion to SavingsProgress report May 10, 2015
StockSummary refine stock summary Oct 30, 2014
TransactionStatistics line chart Oct 30, 2014
Withdrawals New report: "Withdrawals". Feb 19, 2017
YearlyExpenseAndRevenue new report YearlyExpenseAndRevenue Apr 12, 2015
usercoloredtransactions new report Oct 12, 2014
.gitignore Update .gitignore Mar 11, 2014
.travis.yml scrip to pack general reports Jul 26, 2014
LICENSE Initial commit Mar 11, 2014
README.md Update README.md Nov 12, 2014
check_gm.py script to check gm Jul 26, 2014
grm.go init commit Jul 16, 2014
pack_gm.py scrip to pack general reports Jul 26, 2014
tables_v1.sql script to check gm Jul 26, 2014

README.md

general-reports

General reports for Money Manager Ex which can be downloaded and imported easily. Reports can be created using Money Manager Ex as well.

compose general report

Build Status

Typically, one general report contains:

  1. sqlcontent.sql (MMEX will execute this sql first to return one result set)
  • sql
select * from assets_v1;
  1. luacontent.lua (There are two APIs here)
  • handle_record
function handle_record(record)
    // Your logic to modify a record and apply this function against every record from SQL.
   record:set("extra_value", record::get("VALUE") * 2);
end
  • complete
function complete(result)
   // Put some accumulated value and apply this function after SQL completes.
   result:set("TOTAL", 1000);
end
  1. template.htt (a plain text template file powered by html template which shares the same syntax with Perl's HTML::Template)

Contributing

  1. Fork the [repository] (http://github.com/moneymanagerex/general-reports)
  2. Create your feature branch (git checkout -b my-new-feature)
  3. Commit your changes (git commit -am 'Add some feature')
  4. Push to the branch (git push origin my-new-feature)
  5. Create a new pull request

Donations

  1. Star it
  2. Donate to my Ripple address: rUY7DvWqNnSYCYiVr986W71tuaKtDCMNz3
  3. PayPal