• Was this page helpful?
Intuit Blog
|
Support
Point of Sale
|
GoPayment
|
Payroll
|
Quickbooks
|
Website Services
Intuit
Sign In
Register
Banking Creating & Customizing Forms Importing & Exporting Data Inventory Journal Entries & Accounting Tasks Multicurrency Vendors & Vendor Center Printing in Quickbooks QuickBooks Installation, Update, & Conversion
Customers & Customer Center Reports & Report Center QuickBooks UPS, FedEx Shipping Manager QuickBooks Online Services & Features QuickBooks File, Edit & View Menu Tasks QuickBooks Performance Issues & Program Errors QuickBooks Networking & User Setup
QuickBooks Attached Documents QuickBooks Connect QuickBooks Enterprise Solutions QuickBooks for Mac QuickBooks Online (US) QuickBooks Online Suggestions for Improvement QuickBooks Point of Sale QuickBooks Simple Start Edition QuickBooks Time and Billing Manager Cash Register Plus Customer Manager
Customer Manager & Client Manager Desktop Intuit Commissions Manager Intuit Data Protect Intuit Websites Review Websites and Get Feedback GoPayment Intuit Sync Manager New Intuit Business Tools & Resources Quickbase Quicken Turbotax
Better Because of You Considering Buying QuickBooks? Quickbooks Educational Resources QuickBooks Service/Support Policies & Procedures Classifieds
QuickBooks Payroll (Desktop) Intuit Online Payroll ViewMyPaycheck
Builders & Contractors Non-profit Real Estate Retailers Service Industries Other Industries
QuickBooks Canada QuickBooks UK Desktop QuickBooks UK Online QuickBooks Singapore Online QuickBooks en EspaƱol QuickBooks Australia
  • QuickBooks Tasks
  • Intuit Products
  • Intuit Resources
  • Intuit Payroll
  • Industries
  • International
Leaderboard
Hide Advanced Search
 
All of these words
Any of these words
This exact phrase
None of these words
In this forum
With posts written by
With posts from
to
mm/dd/yy
mm/dd/yy
Show Advanced Search
Home   Help with Intuit Products   Quickbooks Tasks   Reports & Report Center  
hide
02/10/2012 at 03:34PM PST
Emails titled "QuickBooks security notice," "Quickbooks update" or "Tax Information Needed within 30 days" were not sent from Intuit and should be considered harmful. If you ever wonder whether an e-mail from Intuit is real or fake, please refer to the link below.

Thank you

http://security.intuit.com/security-alerts.php
70
294
doM0nT1syr3QjyacfA8pyY
Subscribe RSS
ziplock
ziplock
Questions asked: 11
Questions answered: 22
Points earned: 33
ziplock
ziplock
Questions asked: 11
Questions answered: 22
Points earned: 33
Contributor
11/19/09 8:21am PST
Viewed by asker 11/30/09 11:48am PST

Build Linked Transaction Report for Multiple Bill Payments

US QuickBooks Pro for Windows : 2007

I have vendor that generates many bills. These bills are paid on first in first out basis. The vendor has recently submitted a statement showing some bills as unpaid whereas our system shows them as paid.

I want to build a report that I can give to the vendor that would show all cheque payments made by us and the bill numbers that the check payment covered.

I know I can do this with the find feature one by one, but there are too many checks to make this feasible. I want all the checks and the corresponding bill payments on one report without duplication of the line items.

If you can tell me how to do this, I would be most grateful.

 

Thanks

 

 

Submit a reply to this question
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
 Report Abuse
3 Replies
RichardTorian
RichardTorian
Questions asked: 24
Questions answered: 7290
Points earned: 11324
Advanced Certified ProAdvisor
Advanced Certified ProAdvisor
These ProAdvisors have successfully completed extended training, distinguishing themselves as highly proficient QuickBooks experts.
Certified ProAdvisor
Certified ProAdvisor
Certified ProAdvisors have successfully completed an extensive and rigorous QuickBooks certification program.
Allstar
Allstar
Advisory council of community power users.
Certified ProAdvisor - ES
Certified ProAdvisor - ES
These ProAdvisors have successfully completed extended training, distinguishing themselves as highly proficient Enterprise Solutions experts
Certified ProAdvisor - POS
Certified ProAdvisor - POS
These ProAdvisors have successfully completed extended training, distinguishing themselves as highly proficient QuickBooks POS experts
RichardTorian
RichardTorian
Questions asked: 24
Questions answered: 7290
Points earned: 11324
Allstar
11/20/09 7:18am PST

Hi ziplock,

Try the custom transaction detail report.

Filter on the vendor. Also, filter on transaction type = bill and bill payment.

Sort the amount field, so that bill and payment amounts come together.

Your check number should be shown in the “Num” field on the bill pmt-check line. You can drill down to see the check and bill detail.

Richard
 

I am available to work on projects.
http://www.AccountingForBusinessesOnline.com/
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
ziplock
ziplock
Questions asked: 11
Questions answered: 22
Points earned: 33
ziplock
ziplock
Questions asked: 11
Questions answered: 22
Points earned: 33
Contributor
11/22/09 5:58pm PST

Hi Richard

Thanks for your reply, but it is precisely the drill down that I do not want to do, I am looking for a way to generate a report that already has all the postings on the report, that is, equivalent to doing a find on a payment, then highlighting the payment and clicking print, except I want multiple payments on the same report.

Thanks

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
RichardTorian
RichardTorian
Questions asked: 24
Questions answered: 7290
Points earned: 11324
Advanced Certified ProAdvisor
Advanced Certified ProAdvisor
These ProAdvisors have successfully completed extended training, distinguishing themselves as highly proficient QuickBooks experts.
Certified ProAdvisor
Certified ProAdvisor
Certified ProAdvisors have successfully completed an extensive and rigorous QuickBooks certification program.
Allstar
Allstar
Advisory council of community power users.
Certified ProAdvisor - ES
Certified ProAdvisor - ES
These ProAdvisors have successfully completed extended training, distinguishing themselves as highly proficient Enterprise Solutions experts
Certified ProAdvisor - POS
Certified ProAdvisor - POS
These ProAdvisors have successfully completed extended training, distinguishing themselves as highly proficient QuickBooks POS experts
RichardTorian
RichardTorian
Questions asked: 24
Questions answered: 7290
Points earned: 11324
Allstar
11/23/09 6:22pm PST
Latest post

Hi Ziplock,

You do not have to drill down to see the check number. The check number should be in the “Num” field on the bill pmt-check line of the report.

Richard
 

I am available to work on projects.
http://www.AccountingForBusinessesOnline.com/
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
   
 
Submit a reply to this question
 
Subscribe RSS
Tags for this topic
    Help other users find this post by tagging it
Use commas to add multiple tags
Add tags
Latest Site Activity
Pause Feed
woneill1450
8 mins ago
woneill1450
replied to
Password
woneill1450
10 mins ago
woneill1450
replied to
registration of qb 2010 tha...
woneill1450
12 mins ago
woneill1450
replied to
multiple computers
AngelBK
12 mins ago
AngelBK
posted
what quickbook product is b...
AngelBK
13 mins ago
AngelBK
posted
what quickbook product is b...
Community Home Help with Intuit Products Start & Grow Your Business Help for Accountants Small Business Blog Join us on Facebook Follow us on Twitter Watch us on YouTube Meet us on LinkedIn
About Intuit | Careers | Register Your QuickBooks | QuickBooks Affiliate Program | Privacy | Legal | Contact Us | Our Hosts
© 2012 Intuit, Inc. All rights reserved. Intuit and QuickBooks are registered trademarks of Intuit, Inc.
Terms and conditions, features, support, pricing and service options subject to change without notice.
TRUSTe - Privacy Standards and Principles
Intuit Websites - Create the perfect site
Intuit Small Business
QuickBooks Accounting Software
Small Business Grants
QuickBooks Online Accounting
Intuit Payroll Services
Intuit Credit Card Processing
Intuit Business Directory
Intuit GoPayment
Intuit Small Business Education
Intuit Small Business Blog
Love a Local Business