Creating a Simple Report that lists Invoices and Credit notes for a given period

Filed Under (FAQ, QuickBooks) by moirapottow on 03-04-2010

Tagged Under : , ,

Often Clients request a simple report to List Invoices/Credit Notes for a given period. QuickBooks doesn’t provide a report that displays a simple listing of invoices (Date, Invoice Number, Customer, and Amount on a single line). You can create this report using the following steps:
1. Choose Reports | Banking | Missing Checks (yes, that’s right, it’s not a typo).
2. Click OK in the Specify Account dialog that opens (it doesn’t matter what bank account is displayed).
3. When the Missing Checks report opens, click Modify Report.
4. Set The Date Range for the report e.g. “Last Month”
5. Move to the Header/Footer tab and change the text in the Report Title field to Invoice/Credit Note Listing.
6. Move to the Filters tab and make the following changes:
In the Current Filter Choices box, select the Amount filter and click “Remove Selected Filter”.
In the Filter list, select Account and then select your Accounts Receivable account from the Account drop-down list.
In the Filters tab select Transaction Type, choose Multiple Transaction Types in the drop-down list, and then select both Invoice and Credit Memo.
7. Move to the Display tab and deselect all columns except the following:Type, Date, Num, Name, Amount
8. Click OK to save your changes.
A simple list of invoices and credit notes appears, and QuickBooks inserts data about missing invoice numbers or duplicate invoice numbers in the appropriate places
Memorise the report so you don’t have to go through this again each month.