Report: End of Day

Yes you are. The type of payment is not that easy to obtain because an invoice can be paid by a combination of methods, cash, check, credit card, barter, and first born, specail favors, etc.

So I can't pull an end of day report saying John Doe paid for his widgets with his second first born son?

And Jane Doe paid for her widgets with $21.24 cash?

Meh! MEH! Waaaaaaaa . . .

The closest you can get is a Sales By Item Detail report.

Add in column for Paid (while there's a column for payment method it doesn't show the method for some strange reason).

Take out any extraneous columns you don't want like Balance.

For the date select Today. Memorize the report.

Thanks, Tara.

As far as I can tell, there's no way to do a custom report (from scratch). Is that true?

Second verse same as the first.

Lets say John purchased 100 different items for $1,000. 30 days after the sale John paid 200 in cash. 60 days later he paid another 200 by credit card. 65 days later he wrote a check for 500. etc etc. How do you suppose a custom report can help?

It takes very little effort to confuse an issue. Trying to help might be more of a challenge; but, perhaps we ask for too much from you.

Allan Mart> > Thanks, Tara.

This might work:

We ask he go away and stay away, he agrees that is too much.

Gosh, am I the only one who has a clue on this?

Take that report of invoices or whatever and click on the modify report button. Click the filters tab. Under type of transaction, change it from invoice to selected types. Now select the types of things you want, like receipts, credit memos and the like. Here is the trick: In the filters click on the paid by. Set the date range. Click the okay button. Presto bingo. If you like it, memorize it, if not modify it some more until it is too your liking.

I've got a report saved on a machine I don't have access to tonight. I'll double check tomorrow try and post if I forgot anything.

That did the trick. I use the Check Detail report (REPORTS > BANKING >

CHECK DETAIL) to get the payments and payment types received, modified p. the filers you mentioned. Thanks much.

Sorry, rather than just tell you that the report you want can't be created in QB I made the mistake of explaining the reason why it can't be done. I gave you far to much credit. I forgot that most users simply what to know what buttons to click.

Who wants to bet if the OP was from India or China they would have responded differently to my post?

Stop giving yourself a good time. Read your inital post. The report you wanted and the one describe above are completely different.

Below is the report wished for by the OP:

I've tried to generate an end-of-day report, but can't seem to get it right. I basically want a report that lists:

Item, Customer, Payment Received for Item, Type of Payment (Cash, Credit Card), like:

Red Widget, John Doe, $43.21, Credit Blue Widget, Jane Doe, $21.24, Cash

Looks like it is you that does not have a clue.

Well, while you are giving out thanks you might want to send some to Allan. Check detail is the report link he sent you to in his post 6/9/05 at 7:51 in this thread. (Time is my zone of EST)

Thanks L, but I did not send the link. The report the OP wanted in the original post, makes no sense and can't be created in QB.