Transaction Detail by Account

[SJK]

We are a new user. Our company uses Quickbooks Pro 2007 for check writing only. We use the Transaction Detail by Account report to print a list of the checks that have been written.

On Tuesday our office manager wrote several checks, but when she went into Reports, Accountant & Taxes and then Transaction Detail by Account, the report was empty. Anyone have any ideas? Thanks for your help.

[suzannemead]

Perhaps the date range of the report was off. If this report always worked that would be my first guess.

[SJK]

Thanks for the suggestion. We had verified the dates on Tuesday when we tried to run the report and no data appeared. Several checks were written today and we ran a report. Data from today's checks appear, but nothing from Tuesday. The bank balance reflects the correct amount however.

Any other thoughts?

[Joe Williams]

Run the report then go to Filters. Set the Date to All and scroll down to Entered/modified and enter 4/3/2007 in both the from and through dates.
What are the dates listed on the reported data??

[SJK]

I did what you suggested. There are NO dates since there is no data for Tuesday, July 3rd -- that's my problem.

[suzannemead]

Perhaps the transactions themselves had the wrong dates on them.

[Joe Williams]

Run the Custom Transaction Detail report. Click Modify and change the Date to All and the Total by to Day. In Columns to display click "Entered/last modified.
Click the Filter button and Scroll down the Filters to Entered/Modified. Set the "From" to July 1, 3007 and the "To" to July 6, 2007.
The report will list all of the transactions entered into QuickBooks on between dates and total them bt "transaction Date". If ANY transaction was entered or modified July the 3, they will show and the column "Entered / Last Modified " is the date the transaction was entered or modified, the Date is the date used for accounting in QuickBooks.

[SJK]

That's exactly what happened! She didn't change the date on several checks. Is there anyway that I can just change the date so those checks appear as July 3rd checks for our reporting purposes only?

[SJK]

I was able to change the dates on the checks that had been actually written on July 3rd with an incorrect date of June 30th, so please disregard my last post. Thanks everyone for your help!