Using Auto Filter sample 10 11 12 pg 119 120

Example 10

To get a list of uncleared bank items (assuming you have only one bank account)

Say we want to get a list of uncleared bank payments or receipts to help us in preparation of the bank reconciliation statement.

Recall that we mark open in the column BANK RECON for an uncleared bank item. So we want to select all open items from column BANK RECON. If you have only one bank, you will use only one column, so we can use a Simple AutoFilter operation.

1. Follow steps 1 to 3 in Example 1.

2. Click the small arrow which appears on the right side of column titled BANK RECON.

A list of items will appear. 3.

4. Select (Click on) open.

Now, you should see the data filtered according to the selected item (open). All the totals in row 1 will be automatically updated. You can then copy the relevant data to your bank reconciliation working sheet.

Example 11

To get a list of all unpaid invoices from all suppliers

Say we may want to get a list of all unpaid supplier invoices and its total amount. We can get it by selecting all open items in column CREDITOR STTMNT. Since we will rely on one column only (CREDITOR STTMNT), we can use a Simple AutoFilter operation.

1. Follow steps 1 to 3 in Example 1.

2. Click the small arrow which appears on the right side of column titled CREDITOR STTMNT.

3. A list of items will appear.

4. Select (Click on) open.

Now, you should see the data filtered according to the selected item (open). The total can be seen in cell J1.

119

Example 12

To get a list of all unpaid sales invoices T

We may want to get a list of all unpaid sales invoices and its total amount. We can get it by selecting all open items in column DEBTOR STTMNT. Since we will rely on one column only (DEBTOR STTMNT), we can use a Simple AutoFilter operation.

1. Follow steps 1 to 3 in Example 1.

2. Click the small arrow which appears on the right side of column titled DEBTOR STTMNT.

3. A list of items will appear.

4. Select (Click on) open.

Now, you should see the data filtered according to the selected item (open). The total can be seen in cell H1.