generating outstanding amount in excel report

in the excel report, how do i or is it possible to add a column to show the remaining or outstanding balance in the excel report?. also is it possible to display the previous term or previous year balance in the receipt book?


  • Hi viny254,

    At the moment this is not part of the spreadsheet export, to add this you'd need to edit the files yourself and make the necessary calculations/queries in the script to gather and export that data.

    Another option is the Query Builder module, you'd still need to create a query to export this data, but in this case it would only require SQL knowledge, rather than PHP/MySQL/etc. Queries are also not replaced when you update your codebase, so they're a more robust way to add custom exports.
Sign In or Register to comment.