cancel
Showing results for 
Search instead for 
Did you mean: 
Level 1

Report to include Memo from Bill from Vendor

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.

 

11 Comments
QuickBooks Team

Re: Report to include Memo from Bill from Vendor

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:

 

  1. Generate the report and then go to Custom Report button. 
  2. Go to the Display tab and go to Columns and click Memo to add a check mark beside it. 
  3. Click on OK once you're done. 

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!

Level 1

Re: Report to include Memo from Bill from Vendor

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.

QuickBooks Team

Re: Report to include Memo from Bill from Vendor

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:

 

  1. Go to the Reports menu, then choose Vendors & Payables.
  2. Select Transaction List by Vendor.
  3. Review the Memo field for each transaction.
  4. If you want to verify if a transaction has an attachment, double-click to open it.

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.

Level 1

Re: Report to include Memo from Bill from Vendor

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.

QuickBooks Team

Re: Report to include Memo from Bill from Vendor

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.

 

See this:

 

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:

 

Understand reports.

Customize reports in QuickBooks Desktop.

 

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!

 

 

Level 1

Re: Report to include Memo from Bill from Vendor

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. 

 

 

Highlighted
QuickBooks Team

Re: Report to include Memo from Bill from Vendor

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:

  1. Go to the Reports menu.
  2. Hover your mouse over to the Accountant & Taxes, then select Journal.
    journal.PNG
  3. Go to the Filters tab.
  4. Select All names under Name, then click OK.
    journal1.PNG
  5. Go back again to the Filters tab.
  6. Select the specific account under Accounts, then click OK.
    journal2.PNG

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.

Level 1

Re: Report to include Memo from Bill from Vendor

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?

QuickBooks Team

Re: Report to include Memo from Bill from Vendor

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::

 

  1. Go to Reports at the top and select Report Center. 
  2. Type in Transaction Detail by Account on the Search field. 
  3. From the results list, locate and run the report. 
  4. Click the Customize Report tab and go to Filters. 
  5. Under Filter menu, select Account and choose Multiple accounts. 
  6. From the list, select your desired GL account. 
  7. Under the Filter menu again, select Transaction type and choose Multiple Transactions. 
  8. Select your desired vendor transactions and click OK. 
  9. Click OK, set your desired date-range and click Refresh. 

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. 

Level 1

Re: Report to include Memo from Bill from Vendor

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.

 

QuickBooks Team

Re: Report to include Memo from Bill from Vendor

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

Need to get in touch?

Contact us