Can I create a special report for debit card use?

jah47Ed

My credit union (paper statement) does not show end of month debit card use. Can you create a special report in Quicken to track? Nice to have - not a "show-stopper".

Sherlock

If the debit card transactions are distinguishable from the other transactions in the register, you should be able to create reports that excludes the other transactions.

Sherlock

jah47Ed said:

I went to Reports-Banking-Transactions, selected the appropriate checking account and "Month to Date" and created a transactions report. I went into this report and deleted everything that was not a debit card transaction. Doable, but tedious if you have multiple non-debit card transactions. A more "elegant" way would be to generate a report based on "Debit Cd" that you find the in the banking register's "Check #" column. Less tedious - faster. Anybody else besides Sherlock have any suggestions. Tnx to Sherlock for the idea of using Banking transactions...

Open the account register, select Last Month in the first pull-down menu at the top left of the register view (or whatever the desired date range is), enter Debit Cd in the search text box at the top right of the register view.

J_Mike

jah47Ed said:

Jim_Harmon's method works - no "total", but just subtract the ending amount from the beginning amount. Easy enough - format is good enough. Tnx!

Look in the lower left margin of the register. There is a transaction count and a total for the filtered items displayed.

Sherlock

If the debit card transactions are distinguishable from the other transactions in the register, you should be able to create reports that excludes the other transactions.

jah47Ed

I went to Reports-Banking-Transactions, selected the appropriate checking account and "Month to Date" and created a transactions report. I went into this report and deleted everything that was not a debit card transaction. Doable, but tedious if you have multiple non-debit card transactions. A more "elegant" way would be to generate a report based on "Debit Cd" that you find the in the banking register's "Check #" column. Less tedious - faster. Anybody else besides Sherlock have any suggestions. Tnx to Sherlock for the idea of using Banking transactions...

Sherlock

jah47Ed said:

I went to Reports-Banking-Transactions, selected the appropriate checking account and "Month to Date" and created a transactions report. I went into this report and deleted everything that was not a debit card transaction. Doable, but tedious if you have multiple non-debit card transactions. A more "elegant" way would be to generate a report based on "Debit Cd" that you find the in the banking register's "Check #" column. Less tedious - faster. Anybody else besides Sherlock have any suggestions. Tnx to Sherlock for the idea of using Banking transactions...

Open the account register, select Last Month in the first pull-down menu at the top left of the register view (or whatever the desired date range is), enter Debit Cd in the search text box at the top right of the register view.

Jim_Harman

Be careful deleting transactions from the Banking Transactions report - I think that deletes the actual transactions from Quicken, not just the report! 

Instead try this::
--Go to the account's register
--Below the account name there is a search bar.
--Set This month or whatever as the date range.
--Select Payment in the Any Type dropdown
--Type Debit Cd in the search box. This will select all the Payment transactions with that string anywhere in the transaction. Hopefully that only appears in the Check Num field.

Go to File > Print <account name> to generate the filtered report. The format is not the greatest, but it should be OK

jah47Ed

Jim_Harmon's method works - no "total", but just subtract the ending amount from the beginning amount. Easy enough - format is good enough. Tnx!

jah47Ed

Jim_Harmon's "Be careful..." caution is correct. If you delete transactions from a report, you also are deleting from the checking register. You would think the report would be sort of a "stand-alone" temporary file and not be linked to the register - not so. This might be a deficiency that Quicken developers could/should fix. I'd made a back-up file previously to this report and deletion of non-debit card transactions, so no real problem here - load the back-up file and I think I had to reinput two transactions. No biggie...

J_Mike

jah47Ed said:

Jim_Harmon's method works - no "total", but just subtract the ending amount from the beginning amount. Easy enough - format is good enough. Tnx!

Look in the lower left margin of the register. There is a transaction count and a total for the filtered items displayed.

jah47Ed

Got it! Left hand corner of bottom margin bar. Item count and negative $ amount in a red font. good stuff...