Txn Filter to find card payments

This is an example of transaction filter to find all transfers from account A to account B. These could be for example card balance payments (not purchases).

Further info:

• Transaction Filters

• Transaction filters with shell scripts

Journal

2022-12-01 'Paid off card A
   Liabilities:Card:A  1001 USD
   Assets:Bank1:Checking

2022-12-02 'Paid off card B
   Liabilities:Card:B  1002 USD
   Assets:Bank1:Checking

2022-12-03 'Payid these with checks!
   Expences:HolidayPresents  100 USD
   Assets:Bank1:Checking

2022-12-04 'Withdrawn cash with card B
   Assets:Cash  200 USD
   Liabilities:Card:B

Filter definition

Find all credit card balance payment transactions: These transactions are moving money from Assets to the Liabilities (paying off the card), so the destination account is under Liabilities with positive amount, and the originating account is under Assets with negative amount.

two_accounts_filter () {
    flt=$(cat << EOF | base64 --wrap=0
{
    "txnFilter" : {
        "TxnFilterAND" : {
            "txnFilters" : [
                {
                    "TxnFilterPostingAmountGreater" : {
			"regex" : "^Liabilities:.*",
			"amount" : 0
                    }
                },
                {
                    "TxnFilterPostingAmountLess" : {
			"regex" : "^Assets:.*",
			"amount" : 0
                    }
                }
            ]
        }
    }
}
EOF
)
    echo "base64:$flt"
}

Register listing, without filter

tackler --config tackler.toml

REGISTER
--------
2022-12-01 Z 'Paid off card A
            Assets:Bank1:Checking                      -1001.00           -1001.00 USD
            Liabilities:Card:A                          1001.00            1001.00 USD
--------------------------------------------------------------------------------------
2022-12-02 Z 'Paid off card B
            Assets:Bank1:Checking                      -1002.00           -2003.00 USD
            Liabilities:Card:B                          1002.00            1002.00 USD
--------------------------------------------------------------------------------------
2022-12-03 Z 'Payid these with checks!
            Assets:Bank1:Checking                       -100.00           -2103.00 USD
            Expences:HolidayPresents                     100.00             100.00 USD
--------------------------------------------------------------------------------------
2022-12-04 Z 'Withdrawn cash with card B
            Assets:Cash                                  200.00             200.00 USD
            Liabilities:Card:B                          -200.00             802.00 USD
--------------------------------------------------------------------------------------

Register report with filter

tackler --config tackler.toml --api-filter-def $(two_accounts_filter)

Filter:
  AND
    Posting Amount
      account: "Liabilities:.*"
      amount > 0
    Posting Amount
      account: "Assets:.*"
      amount < 0


REGISTER
--------
2022-12-01 Z 'Paid off card A
            Assets:Bank1:Checking                      -1001.00           -1001.00 USD
            Liabilities:Card:A                          1001.00            1001.00 USD
--------------------------------------------------------------------------------------
2022-12-02 Z 'Paid off card B
            Assets:Bank1:Checking                      -1002.00           -2003.00 USD
            Liabilities:Card:B                          1002.00            1002.00 USD
--------------------------------------------------------------------------------------