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.