[GNC] Transaction reports with only debits or credits

[Adrien Monteleone]

There are two ways. One involves adding a ’tag’ to each transaction, the other involves using a spreadsheet.

If you want GnuCash to produce the report directly, you would need some sort of ’tag’ (this if figurative here, GnuCash doesn’t have a ’tag’ feature) in either the Description, Notes, or Memo of each transaction that you can use to set a filter for the report. So you could tag debit transactions with the word “Debit” or “Dr.” or simply “D”, similar for credit transactions.

When you run the transactions report, use the Transaction Filter option on the Filter tab to include only transactions with the desired tag.

The downside here is you need to edit all historical transactions to add this tag. (but this won’t un-reconcile any since you can change those fields safely.)

If you don’t mind using a spreadsheet to manipulate the data, you can instead use the Sorting tab of the report. Set your primary key to Amount. (the secondary can be anything you want). Apply or run the report again.

Now your transactions will be sorted by debit and credit. Depending on the account type, for example an Asset account like Checking, the negative amounts will be credits and the positive amounts, debits. (Assets & Expenses work this way, Income, Liabilities & Equity are the opposite) Copy and paste the entire report into a spreadsheet and simply delete the rows with the set of accounts you don’t want. (you can alternately save the report as is, and then open it with a spreadsheet app)

Regards,
Adrien

> On Aug 15, 2018, at 5:56 PM, AC <gnucash at acarver.net> wrote:
> 
> Is there a way to configure a transaction report (or any of the
> available reports) to show only the debits or the credits (but not both)
> of an account?
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>