Itemized Payees No Date Column
jtgostars
Member ✭✭
Is there anyway to get an itemized Payee report that has a separate column for the transaction date?
It looks like the standard report currently puts the Payee and Date in a single column. This makes it difficult to sort by date even after exporting to Excel. I have to then use a complex formula to "split" the date off of the Payee into a separate column
It looks like the standard report currently puts the Payee and Date in a single column. This makes it difficult to sort by date even after exporting to Excel. I have to then use a complex formula to "split" the date off of the Payee into a separate column
0
Answers
-
I'm not sure exactly what you're referring to by "the standard report." I did a quick run through a few reports I might use to get some sort of spending by payee and they all seemed to segregate the date from the Payee/Description.If you're trying to get a report that has all spending by all Payees one other report you might try is Banking > Transactions, suitably customized, and sort that report by "Description."0
-
@jtgostars
Here is an easy way to remove the Payees from the Date Column in Excel-- Once the report is exported to Excel, clear Column A, so you will end up with a blank column A (don't delete).
- Number each of the rows in Column A, from 1 to as many rows you have in the report.
- I find that using a simple formula is easiest. In Column A, put a "1" in the first row, and then in the 2nd row type in A1+1, copy or fill this formula down to the end of your report.
- After the sequence of numbers are filled in Column A, highlight Column A by clicking on column heading and do a "Copy Paste Special" by right clicking on the highlighted column, click on "Copy" and then right click the highlighted column again and click "Paste special..." and then choose "Values" then click on "OK". Your column of numbers now should be real numbers instead of formulas.
- Sort the spreadsheet by Date. All the dates should sort at the top, and all of the non-dates should be at the bottom. Delete out all the non-date rows.
- Resort the spreadsheet back to its original sort by sorting on Column A.
5 -
I am referring to the standard report at Menu Reports-Spending-Itemized Payees. I customize it for only my credit cards (screen shot attached). When I export it to excel the Payee and date are merged into a single column (screen shot attached)0
-
> @jtgostars said:
> I am referring to the standard report at Menu Reports-Spending-Itemized Payees. I customize it for only my credit cards (screen shot attached). When I export it to excel the Payee and date are merged into a single column (screen shot attached)
And it does not appear the Banking Transactions report includes the Payee
All I need is what should be a simple report for transactions by account by payee by date that can be sorted or filtered on any of those dimensions0 -
@Jtgostars, the Banking Transaction Report does include Payee. It is called "Description" for some reason.0
-
You can run a payee report using a Transaction Report, and sort by payee, but don't categorize by payee or you will end up with Payees in the Date column, just like the Itemized Payee Report.0
-
The Banking Transaction Report should give you exactly what you want.
0
This discussion has been closed.