How to find overdue CORGI’s - Part I

Rules of the game: How to find overdue CORGI’s - Part I of II

=== AIM: ===

To ensure that all outstanding CORGI’s of a given period, are dealt with.

You have to do this report for every calendar month – make a report, export it to excel, delete any unnecessary column, export it to excel, sort out columns, delete surplus or any unnecessary column / entry – i.e. if you know that it’s definitely not going to be a CORGI this time around, and then fill in telephone numbers, if they are missing.

Create report on a monthly basis in QuickBooks, from the Memorised Report: “Overdue_CORGI_list” On the top toolbar go to Reports, choose Memorised Reports, then click on "Customers / Pacedream", then click on " CORGI Report".

Then fill in the appropriate dates e.g. from 01/01/04 to 31/12/04 and press enter.

Ensure that the list is for all names i.e. all landlords - customers.

If it is not, for example, it is only for Clarestar; go to Modify Report, Filter and under Current filter choice, where it says: Name; Clearstop Management - click on it and then press on Remove Selected Filter.

Then click on OK and you will have all the CORGI’s - of all landlords.

Also under Modify Report, tick Source Name.

See step-by step instructions below:

===== Create a new Report =====

To create a report from scratch, follow the instructions below:

1. Press Ctrl+F (=Find),

2. Enter the first day of the month you want a report for in the first Date Field, then enter the first day of the following month,

3. Press ENTER.

4. Click on Report,

5. Delete the “Invoice” column,

6. Widen the “Name” Column until the full telephone number and company names become visible,

7. Widen the “Memo” Column until the full address becomes visible,

8. Delete the “Account”, “Clr”, “Split”, “Amount “and “Balance” columns,

9. Click on “Modify Report…”, unTick the “Left Margin”, then unTick all the options in the “Header/Footer” Tab.

10. Press ENTER.

11. Save the report as “Overdue_CORGI_list”: Click on “Memorise”, type “Overdue_CORGI_list” (don’t paste this text!), Tick the Save in Memorised Reports Group and select “Customers”.

12. Press ENTER

13. The report is now saved under Reports->Memorised Reports->Customers In QuickBooks it is quite difficult to move around with the data so the information has to be exported to excel where it is much easier to work in. to do that go to Export, Basic, then click on a new excel workbook, OK.
Now on the Taskbar you should see a new excel document titled Book (and an Ampersand symbol) and this is the spreadsheet on which you will be *some text missing here*