Advertise here    

QuickBooks Forums      

Go Back   QuickBooks Forums > Other QuickBooks Forums > Suggestion Box

Thread Tools Rating: Thread Rating: 4 votes, 5.00 average. Display Modes
Old 02-07-2008, 08:57 PM
JTAlves JTAlves is offline
Registered User
Join Date: Dec 2004
Location: Honolulu
Posts: 322
Send a message via AIM to JTAlves Send a message via Yahoo to JTAlves
Report and export of bill detail

On some bills I enter portions of the bill through out the month and then get a summary invoice from the vendor at the end of the month,

For instance we have a vendor that does printing for us and bills us at the end of the month for all charges that occurred during the month. For each printing order he gives us a "charge slip" for the cost of that print job. Those charges then become reimbursable items for invoicing to our customers. There could be hundreds of these charges in a month.

When I get the consolidated or summary invoice at the end of the month the total that I have for the bill rarely matches the invoice total - mostly because I have entered a charge that was later reversed and I didn't know that, I entered an amount incorrectly, I never got a charge slip on a print order, etc.

When the total s don't agree I need to match the charges I entered during the month against what is on the invoice. A painstaking task to do visually. If I could export the bill data to excel I could then sort it by job number or amount, sort the data on the invoice the same way and do a quick compare! Would take me 5 minutes rather than the hour+ it takes me now,
Reply With Quote
Old 02-09-2008, 06:35 AM
Joe Williams Joe Williams is offline
Registered User
Join Date: Jan 2006
Location: Oklahoma
Posts: 9,384
If you use the Custom Transaction Detail report and modify it. In Columns to display, uncheck name and check Source Name. You can also check Item to see the individual items. Click Filter and set Account=All, Transaction=Bill, Detail Level=All except summary. Set teh date range and run it. The report will list all of the billed information by Customer:job. The source name is the vendor the bill is from.
Joe Williams
Piedmont, Ok
Reply With Quote

Bookmark and Share
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

All times are GMT -5. The time now is 11:30 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
All contents copyright (c) by AccountingUsers Inc.
You Rated this Thread: