Balance for each line item to be stated in special report

[Kevin_Johnson]

Is it possible to configure a special report so that it has columns for debit, credit and balance for each line?

That is, a balance stated after each debit or credit, and not only at the end of the report. A running balance in the far right-hand corner, it might be described as, I guess.

[Tut]

No. Custom reports include details of individual transactions, not account balances. (Balances are processed results of a defined set of transactions.) You can obtain totals by grouping with appropriate report design. But those will not be account balances.

But there might be other ways to get the information you seek. Many of Manager’s displays include running balances; and those can be copied to spreadsheets. What exactly are you looking for?

[Kevin_Johnson]

I’ve configured a report as attached. (It is a totally fictitious business and fictitious names therein!) In far right hand column, I would hope to show a balance for each line. So if in the attached next line were a debit of $400, bal shown in far right column would be 300 CR.

But I think perhaps this cannot be done.

Thanks as always for your kind assistance, Tut.

[lubos]

@Kevin_Johnson this has been requested before and is in ideas category.

Custom Reports - Progressive Balance

Dear @lubos, would it be possible to show progressive balances (opening, progressive and closing) also in custom reports?

However, I think you are trying to make custom report for something I believe should be in fact generic report. Is this something you require for special account or capital account?

[Kevin_Johnson]

Many tks, Iubos, for letting me know that this is in the pending ideas category.

I’m generating ‘custom’ reports for ‘special accounts’, and I’m using those terms specifically, and I hope correctly

The special accounts are law firm clients’ individual trust money ledger accounts.

[lubos]

Ability to print statements for special accounts has been also requested and is in ideas.

I believe this is exactly what you require rather than custom report.

Printing Control Accounts with Special Accounts

I have set up a Control Account for Listed Investments and selected Special Accounts. I have added Special Accounts and posted transactions. In the Balance Sheet and Trial Balance I have one line - Listed Investments $xxxx All that is great and works very well. I can print the Balance Sheet and Trial Balance but I cannot find a report for the control account. If I drill down in the Trial Balance I can right-click and print a list but there are no headings, dates etc. In customise “Special…

[Kevin_Johnson]

Thank you so much, Iubus. Will study that past thread (and the published guidance). I do think as to that which I’ve done so far, an easily understood report can be produced, especially if you give a good heading to the far right hand column, such as “Amts & final bal held in trust for you (Cr) ($)”, as below: