We would like to run a report that includes the Memo field that we populate on the bill when Entering Vendor bills. We desire to run a report for specific expense account. We have 2 memo fields. One that is on the top portion of the bill entering screen. That is the one we want to add to a report. There is also a memo field on the bottom half of the screen next to the GL Account. That field is on the reports we run, but not the other memo field. The two fields both appear to be called Memo, but can contain different data.
You can customize the column to add the memo column on the report, @MichelleSCR.
If you’re referring to the Memo field below Terms you just have to customize the report after generating it.
Just go to the Display tab, go to Columns section and click on Memo to add in the report. Follow the steps below:
Check this report for more information: Customize reports in QuickBooks Desktop.
Keep me posted if there’s anything else that I can help with your reports by leaving a comment below. Take care and have a wonderful day!
Yes, I am wanting the Memo that is under the Terms.
We have already customized our reports to include the Memo Column. However that is showing the data in the Memo field that is between the Amount and Customer job fields in your screenshot. We have different data in those 2 fields.
Glad to have you back, @MichelleSCR,
You can pull up a Transaction List by Vendor report to view expenses with Memos attached to them. This report pull the information from the field below the bill's Terms.
Here's how to generate the report:
I've included an article to help you modify reports: Customize reports in QuickBooks Desktop
If you need additional assistance, please leave a comment below. I'll be here to help you anytime. Have a wonderful day! Take care.
Thanks. I see that this report does pull in the Memo field that we want. However we want to run a report that includes all transactions in a particular g/l expense account (Truck repairs to be exact). So it will include multiple vendors. The column that includes the debit account for the transaction in this report is titled "Split", but I can't see where we can filter on this column in the Vendor Transaction Report.
Thanks for your help.
Welcome back, @MichelleSCR,
The Transaction List by Vendor report lists all the vendor-related transactions (bills, bill payments, checks, credit card charges, and etc.) that occurred within a period of time. All expenses are grouped under each contractor's name.
You can find the Split filter on the Columns section of the Display tab. Simply click Customize Report button to apply the field on the report.
If you'd like to view the report again without going through all the customization, use the Memorize button at the top. To access them, go to Reports menu and select Memorized Report.
I'm adding some articles which has all the information about reports in QuickBooks Desktop and how to use them:
If you need further help with the reports or anything about QuickBooks, drop me a comment below. I'll be more than happy to provide additional help whenever you need one. Have a wonderful day!
I do have the "Split" column in the Transaction List by Vendor Report, but I want to filter on it.
Here is where I am at:
The Transaction List by Vendor Report will give me the info I need for only 1 vendor and it includes every g/l account.
I need the info for every vendor, but for only for 1 specific g/l account.
Also I want the Memo field that is under the terms to be included.
I could choose "All Names" in the filter for the name (vendor) field, but then the report would be monstrous because I can't select only 1 g/l account.
Hello there, MichelleSCR,
We're unable to filter the split transaction to show 1 specific G/L account in the Transaction List by Vendor report.
You can pull up the Journal report and filter the account from there to show the information you need. Let me show you how:
To learn more about filtering reports in QuickBooks Desktop, check this out: Customize reports . It includes additional detailed steps and instructions to guide you with the process.
Keep me posted if you have follow-up questions and I'd be glad to help you out.
I was able to filter on the account for Journal Report. Unfortunately, the Memo that is showing in that report is the wrong memo field. This is where I started yesterday when I was running a Trial Balance and drilling down to the G/L Account.
Is there a way to get both Memo fields to appear? I am confused by why there are 2 fields that are both called Memo on the same Bill Inputting screen. Does one of them go by a different name when we are choosing columns to include on the reports?
I know a report that can display all the data you’ve mention, MichelleSCR.
To get all these, you can run and customize the Transaction Detail by Account. Here’s how::
You can also save this customization by clicking the Memorize tab. Once done, access the same report again through Reports > Memorized Reports.
Keep posting those questions you have in mind. We'll be around to take care of them.
This report is still reporting the wrong Memo field, just like all the others besides the Transaction List by Vendor Report. The Transaction List by Vendor report did show the Memo field that we want, but then we can not pick just one g/l account.
Hello there, @MichelleSCR,
You're on the right track in running the Transaction List by Vendor report, however, there isn't a way to select one specific G/L account. It only shows the Memo field under the Terms section of the bill. The recommended method is to separately pull up the Journal report to get the split transactions under 1 particular G/L account. You can refer to the steps provided by my peer MaryLandT above on how to run this report.
Getting the transactions under one G/L account on a single report helps you get the information you need for your business. In line with this, I'll take note of your suggestion. I can also submit this directly to our product engineers so they can consider it for future updates.
If you're using the Enterprise 2019 version, you can visit this website: What's New. Just go to the QuickBooks Desktop Enterprise section to view our product improvements.
You can also check out this website: Customize Reports. You'll find steps on how to run, filter, and sort the information to appear on the reports.
You can count me in if there's anything else you need. Take care always, @MichelleSCR.