Pivot Tables

profileFrenchienoire
IT515-Assignment31.xltx
Home>Information Systems homework help>Pivot Tables

Instructions

Excel Skills | Exercises | Pivot Tables www.excel-skills.com
Instructions
Versions: Excel 2010 & Excel 2007
Our practical Excel exercises are much more than just exercises! We design our exercises in such a way that they provide the user with a mapping of the Excel features that can be used in order to complete the appropriate task in the most efficient manner possible. We also reference each step in each exercise to the appropriate tutorial that needs to be studied in order to be able to complete the step.
The solutions to our comprehensive exercises are only available to customers who have purchased either a full or training membership. If you have not purchased a membership, we unfortunately cannot provide you with any of the solutions or assist you with any of the steps that are included in the appropriate exercise.
Start the exercise by saving the workbook on your system, then complete step number 1 and each subsequent step in the order as listed on this sheet before comparing your workbook to the solution that we have provided.
Step Task Tutorial
1 Open the Expenses sheet and note that one of the column headings is blank - we will not be able to create a pivot table which includes all the data on the Expenses sheet if one of the field names that need to be used in our pivot table is blank. Select cell F4 and enter the following heading for the column: Tax Code Pivot Tables & Pivot Charts : Source Data Layout
2 Insert the data on the Expenses sheet into an Excel table. If the source data of a pivot table is included in an Excel table, you will not have to edit the source data cell range of the pivot table when you add additional transactions at the bottom of the Expenses sheet. Excel Tables : Insert Table
3 Change the table name to: ExpTable Excel Tables : About Excel Tables
4 Create a pivot table on a new worksheet which is based on all the cells that have been inserted into the new Excel table. Use the pivot table to display the total tax inclusive amount for each supplier that is included in our source data. Pivot Tables & Pivot Charts : Create a Pivot Table
5 Rename the new sheet as: Suppliers Worksheets : Rename
6 Change the number formatting in the amount section of the pivot table so that all the amounts include thousands separators and two decimal numbers. Use the pivot table feature for this purpose so that the new number formatting is retained after the pivot table is refreshed. Pivot Tables & Pivot Charts : Pivot Table Format Values
7 Change the column width of column B to 16. Row / Column Formatting : Format Column Width
8 Wrap the column heading in column B so that it is displayed in two lines and center the text. Format Cells : Wrapping Text
9 Change the pivot table settings so that the adjusted column width is retained after refreshing the pivot table. Pivot Tables & Pivot Charts : Pivot Table Column Width
10 Open the Expenses sheet and change the amount in row 16 from 13,000 to 33,000. Edit Data : Edit Data
11 Open the Suppliers sheet and note the grand total at the bottom of the pivot table. Refresh the pivot table and note the change in the grand total. Pivot Tables & Pivot Charts : Refresh a Pivot Table
12 Change the order of the supplier names in column A so that the suppliers are sorted in a descending order (from Z to A). Pivot Tables & Pivot Charts : Filter Pivot Table Data
13 Drill down to the source data that makes up the supplier total for the IAS Accountants supplier. Pivot Tables & Pivot Charts : Pivot Table Data Drill-Down
14 Rename the new sheet as: IAS Worksheets : Rename
15 Open the Expenses sheet and create another pivot table which reflects an expense total (tax inclusive amount) for each of the payment dates that are included in column I. Pivot Tables & Pivot Charts : Create a Pivot Table
16 Rename the new sheet as: Payments Worksheets : Rename
17 Complete steps 6 to 9 for the Payments sheet.
18 Filter the pivot table so that only payment dates on or after 1 January 2012 is displayed. Pivot Tables & Pivot Charts : Filter Pivot Table Data
19 Change the layout of the pivot table so that the individual bank codes are included in separate columns in the pivot table. Pivot Tables & Pivot Charts : Change Pivot Table Layout
20 Adjust the column widths of all the columns that are included in the pivot table to 16. Row / Column Formatting : Format Column Width
21 Change the formatting style of the pivot table to Pivot Style Medium 20 (Tip: Hover your mouse over the appropriate image in the Pivot Table Styles section of the appropriate ribbon tab in order to display a description for each of the pivot table styles). Pivot Tables & Pivot Charts : Pivot Table Tools Tab
The following steps only apply to Excel 2010 users - Excel 2007 users can save the workbook and compare it to the solution that we've provided.
22 Open the Suppliers sheet and insert a pivot table slicer which is based on the account code field. Pivot Table Slicers : Create a Slicer
23 Change the layout of the slicer so that it includes three columns of filter buttons. Increase the width of the slicer so that all the filter buttons are displayed properly. Pivot Table Slicers : Format Slicers
24 Change the formatting style of the slicer to Slicer Style Dark 2 (Tip: Hover your mouse over the appropriate image in the Slicer Styles section of the appropriate ribbon tab in order to display a description for each of the slicer styles). Pivot Table Slicers : Format Slicers
25 Filter the pivot table data with the slicer so that the supplier totals for only expenses that have been allocated to account IS-375 or account IS-390 are displayed in the pivot table. Pivot Table Slicers : Using Slicers
26 Save the workbook and compare your workbook to the solution that we've provided.

&9Page &P of &N

http://www.excel-skills.com/excel.asp

Expenses

Example Limited
Expenses
Document Date Supplier Reference Description Tax Inclusive Amount Bank Code Account Code Payment Date
2/14/11 XY Solutions S77782 Opening Balance 5,100.00 A B1 BS-500 3/2/11
3/1/11 IS Communications Invoice EXP22 Internet Service Provider 179.00 A B1 IS-380 3/31/11
3/2/11 Newscorp I381119 Subscriptions 478.00 A B1 IS-375 4/1/11
3/5/11 EAG Brokers Debit Order Insurance 340.00 A B1 IS-340 3/5/11
3/15/11 Capital Bank Bank Statement Service Fees 50.00 A B1 IS-315 3/15/11
3/15/11 Capital Bank Bank Statement Service Fees 35.00 A B2 IS-315 3/15/11
3/15/11 IAS Accountants Invoice Bookkeeping 1,000.00 A B1 IS-305 4/2/11
3/15/11 Interflora Cash Flowers 90.00 A PC IS-345 3/15/11
3/18/11 QQ International TR6998 Parking 200.00 A B1 IS-390 3/18/11
3/20/11 Example (Pty) Ltd Transfer Inter Account Transfer -15,000.00 E B2 BS-399 3/20/11
3/20/11 Example (Pty) Ltd Transfer Inter Account Transfer 15,000.00 E B1 BS-399 3/20/11
3/26/11 Example (Pty) Ltd Payroll Salaries 13,000.00 E B2 IS-365 3/26/11
3/26/11 HP Finance Debit Order Capital repayment 220.00 E B1 BS-700 3/26/11
3/26/11 HP Finance Debit Order Interest paid 100.00 E B1 IS-500 3/26/11
3/26/11 PR Properties Debit Order Rent 6,400.00 A B1 IS-350 3/26/11
3/31/11 Example (Pty) Ltd Bank Statement Petty Cash Reimbursement 100.00 E B1 BS-399 3/31/11
3/31/11 Example (Pty) Ltd Bank Statement Petty Cash Reimbursement -100.00 E PC BS-399 3/31/11
4/1/11 IS Communications Invoice EXP23 Internet Service Provider 179.00 A B1 IS-380 5/1/11
4/5/11 EAG Brokers Debit Order Insurance 340.00 A B1 IS-340 4/5/11
4/12/11 Interflora Cash Flowers 87.00 A PC IS-345 4/12/11
4/15/11 Capital Bank Bank Statement Service Fees 80.00 A B1 IS-315 4/15/11
4/15/11 Capital Bank Bank Statement Service Fees 35.00 A B2 IS-315 4/15/11
4/15/11 IAS Accountants Invoice Bookkeeping 1,000.00 A B1 IS-305 5/3/11
4/20/11 Example (Pty) Ltd Transfer Inter Account Transfer -20,000.00 E B2 BS-399 4/20/11
4/20/11 Example (Pty) Ltd Transfer Inter Account Transfer 20,000.00 E B1 BS-399 4/20/11
4/25/11 Inland Revenue Return Sales Tax 1,300.00 E B1 BS-600 4/25/11
4/26/11 Example (Pty) Ltd Payroll Salaries 20,000.00 E B2 IS-365 4/26/11
4/26/11 Furniture City Invoice Furniture 3,000.00 A B1 BS-100 5/26/11
4/26/11 HP Finance Debit Order Capital repayment 220.00 E B1 BS-700 4/26/11
4/26/11 HP Finance Debit Order Interest paid 100.00 E B1 IS-500 4/26/11
4/26/11 PR Properties Debit Order Rent 6,400.00 A B1 IS-350 4/26/11
4/29/11 GF Supplies IN1179 Consumables 41.00 A PC IS-325 5/29/11
4/30/11 Example (Pty) Ltd Bank Statement Petty Cash Reimbursement 100.00 E B1 BS-399 4/30/11
4/30/11 Example (Pty) Ltd Bank Statement Petty Cash Reimbursement -100.00 E PC BS-399 4/30/11
5/1/11 IS Communications Invoice EXP24 Internet Service Provider 179.00 A B1 IS-380 5/31/11
5/1/11 Training Inc Invoice Course 220.00 A B1 IS-385 5/31/11
5/5/11 EAG Brokers Debit Order Insurance 340.00 A B1 IS-340 5/5/11
5/7/11 City Lodge S50037 Accommodation 563.00 A B1 IS-390 5/7/11
5/7/11 Waltons Invoice Stationery 982.00 A B1 IS-370 6/6/11
5/15/11 Capital Bank Bank Statement Service Fees 80.00 A B1 IS-315 5/15/11
5/15/11 Capital Bank Bank Statement Service Fees 35.00 A B2 IS-315 5/15/11
5/15/11 IAS Accountants Invoice Bookkeeping 1,000.00 A B1 IS-305 6/2/11
5/20/11 Example (Pty) Ltd Transfer Inter Account Transfer -20,000.00 E B2 BS-399 5/20/11
5/20/11 Example (Pty) Ltd Transfer Inter Account Transfer 20,000.00 E B1 BS-399 5/20/11
5/26/11 Example (Pty) Ltd Payroll Salaries 20,000.00 E B2 IS-365 5/26/11
5/26/11 HP Finance Debit Order Capital repayment 220.00 E B1 BS-700 5/26/11
5/26/11 HP Finance Debit Order Interest paid 100.00 E B1 IS-500 5/26/11
5/26/11 PR Properties Debit Order Rent 6,400.00 A B1 IS-350 5/26/11
5/29/11 Interflora Cash Flowers 65.00 A PC IS-345 5/29/11
5/31/11 Example (Pty) Ltd Bank Statement Petty Cash Reimbursement 100.00 E B1 BS-399 5/31/11
5/31/11 Example (Pty) Ltd Bank Statement Petty Cash Reimbursement -100.00 E PC BS-399 5/31/11
6/1/11 IS Communications Invoice EXP25 Internet Service Provider 179.00 A B1 IS-380 7/1/11
6/5/11 EAG Brokers Debit Order Insurance 340.00 A B1 IS-340 6/5/11
6/15/11 Capital Bank Bank Statement Service Fees 80.00 A B1 IS-315 6/15/11
6/15/11 Capital Bank Bank Statement Service Fees 35.00 A B2 IS-315 6/15/11
6/15/11 IAS Accountants Invoice Bookkeeping 1,000.00 A B1 IS-305 7/3/11
6/20/11 Example (Pty) Ltd Transfer Inter Account Transfer -20,000.00 E B2 BS-399 6/20/11
6/20/11 Example (Pty) Ltd Transfer Inter Account Transfer 20,000.00 E B1 BS-399 6/20/11
6/22/11 Interflora Cash Flowers 110.00 A PC IS-345 6/22/11
6/25/11 Inland Revenue Return Sales Tax 8,700.00 E B1 BS-600 6/25/11
6/26/11 Example (Pty) Ltd Payroll Salaries 20,000.00 E B2 IS-365 6/26/11
6/26/11 HP Finance Debit Order Capital repayment 220.00 E B1 BS-700 6/26/11
6/26/11 HP Finance Debit Order Interest paid 100.00 E B1 IS-500 6/26/11
6/26/11 PR Properties Debit Order Rent 6,400.00 A B1 IS-350 6/26/11
6/26/11 SA Airlines SA11235 Travel 1,782.00 A B1 IS-390 6/26/11
6/30/11 Example (Pty) Ltd Bank Statement Petty Cash Reimbursement 100.00 E B1 BS-399 6/30/11
6/30/11 Example (Pty) Ltd Bank Statement Petty Cash Reimbursement -100.00 E PC BS-399 6/30/11
7/1/11 IS Communications Invoice EXP26 Internet Service Provider 179.00 A B1 IS-380 7/31/11
7/2/11 Waltons Invoice Stationery 761.00 A B1 IS-370 8/1/11
7/5/11 EAG Brokers Debit Order Insurance 340.00 A B1 IS-340 7/5/11
7/15/11 Capital Bank Bank Statement Service Fees 80.00 A B1 IS-315 7/15/11
7/15/11 Capital Bank Bank Statement Service Fees 35.00 A B2 IS-315 7/15/11
7/15/11 IAS Accountants Invoice Bookkeeping 1,000.00 A B1 IS-305 8/2/11
7/16/11 Interflora Cash Flowers 29.00 A PC IS-345 7/16/11
7/17/11 GF Supplies IN1181 Consumables 937.00 A B1 IS-325 8/16/11
7/20/11 Example (Pty) Ltd Transfer Inter Account Transfer -20,000.00 E B2 BS-399 7/20/11
7/20/11 Example (Pty) Ltd Transfer Inter Account Transfer 20,000.00 E B1 BS-399 7/20/11
7/25/11 ACC Institute M00321037 Annual Membership 2,000.00 A B1 IS-375 8/24/11
7/26/11 Example (Pty) Ltd Payroll Salaries 20,000.00 E B2 IS-365 7/26/11
7/26/11 HP Finance Debit Order Capital repayment 220.00 E B1 BS-700 7/26/11
7/26/11 HP Finance Debit Order Interest paid 100.00 E B1 IS-500 7/26/11
7/26/11 PR Properties Debit Order Rent 6,400.00 A B1 IS-350 7/26/11
7/31/11 Example (Pty) Ltd Bank Statement Petty Cash Reimbursement 50.00 E B1 BS-399 7/31/11
7/31/11 Example (Pty) Ltd Bank Statement Petty Cash Reimbursement -50.00 E PC BS-399 7/31/11
8/1/11 IS Communications Invoice EXP27 Internet Service Provider 179.00 A B1 IS-380 8/31/11
8/5/11 EAG Brokers Debit Order Insurance 340.00 A B1 IS-340 8/5/11
8/9/11 Interflora Cash Flowers 78.00 A PC IS-345 8/9/11
8/13/11 XY Traders Invoice 9987 Commission 747.00 A B1 IS-320 9/12/11
8/15/11 Capital Bank Bank Statement Service Fees 80.00 A B1 IS-315 8/15/11
8/15/11 Capital Bank Bank Statement Service Fees 35.00 A B2 IS-315 8/15/11
8/15/11 IAS Accountants Invoice Bookkeeping 1,000.00 A B1 IS-305 9/2/11
8/15/11 SA Airlines SA11988 Travel 1,278.00 A B1 IS-390 8/15/11
8/20/11 Example (Pty) Ltd Transfer Inter Account Transfer -20,000.00 E B2 BS-399 8/20/11
8/20/11 Example (Pty) Ltd Transfer Inter Account Transfer 20,000.00 E B1 BS-399 8/20/11
8/21/11 JSE Brokers Remittance Share investment 3,750.00 E B1 BS-200 8/21/11
8/25/11 Inland Revenue Return Sales Tax 6,600.00 E B1 BS-600 8/25/11
8/26/11 Example (Pty) Ltd Payroll Salaries 20,000.00 E B2 IS-365 8/26/11
8/26/11 HP Finance Debit Order Capital repayment 220.00 E B1 BS-700 8/26/11
8/26/11 HP Finance Debit Order Interest paid 100.00 E B1 IS-500 8/26/11
8/26/11 PR Properties Debit Order Rent 6,400.00 A B1 IS-350 8/26/11
8/27/11 Waltons Invoice Stationery 234.00 A B1 IS-370 9/26/11
8/31/11 Example (Pty) Ltd Bank Statement Petty Cash Reimbursement 50.00 E B1 BS-399 8/31/11
8/31/11 Example (Pty) Ltd Bank Statement Petty Cash Reimbursement -50.00 E PC BS-399 8/31/11
8/31/11 Inland Revenue Return Provisional Tax 2,600.00 E B1 IS-600 8/31/11
9/1/11 IS Communications Invoice EXP28 Internet Service Provider 179.00 A B1 IS-380 10/1/11
9/5/11 EAG Brokers Debit Order Insurance 340.00 A B1 IS-340 9/5/11
9/13/11 Training Inc Invoice Course 277.48 A B1 IS-385 10/13/11
9/15/11 Capital Bank Bank Statement Service Fees 80.00 A B1 IS-315 9/15/11
9/15/11 Capital Bank Bank Statement Service Fees 35.00 A B2 IS-315 9/15/11
9/15/11 IAS Accountants Invoice Bookkeeping 1,000.00 A B1 IS-305 10/3/11
9/18/11 Municipality Statement Rates 5,620.00 A B1 IS-395 9/18/11
9/18/11 QA Attorneys Invoice Legal advice 12,500.00 A B1 IS-360 9/18/11
9/20/11 Example (Pty) Ltd Transfer Inter Account Transfer -20,000.00 E B2 BS-399 9/20/11
9/20/11 Example (Pty) Ltd Transfer Inter Account Transfer 20,000.00 E B1 BS-399 9/20/11
9/21/11 Interflora Cash Flowers 90.00 A PC IS-345 9/21/11
9/24/11 XY Traders Invoice11203 Commission 4,242.00 A B1 IS-320 10/24/11
9/26/11 Example (Pty) Ltd Payroll Salaries 20,000.00 E B2 IS-365 9/26/11
9/26/11 HP Finance Debit Order Capital repayment 220.00 E B1 BS-700 9/26/11
9/26/11 HP Finance Debit Order Interest paid 100.00 E B1 IS-500 9/26/11
9/26/11 PR Properties Debit Order Rent 6,400.00 A B1 IS-350 9/26/11
9/30/11 Example (Pty) Ltd Bank Statement Petty Cash Reimbursement 100.00 E B1 BS-399 9/30/11
9/30/11 Example (Pty) Ltd Bank Statement Petty Cash Reimbursement -100.00 E PC BS-399 9/30/11
10/1/11 IS Communications Invoice EXP29 Internet Service Provider 179.00 A B1 IS-380 10/31/11
10/4/11 GF Supplies IN1185 Consumables 62.00 A PC IS-325 11/3/11
10/4/11 SA Airlines SA12741 Travel 1,887.00 A B1 IS-390 10/4/11
10/5/11 EAG Brokers Debit Order Insurance 340.00 A B1 IS-340 10/5/11
10/15/11 Capital Bank Bank Statement Service Fees 80.00 A B1 IS-315 10/15/11
10/15/11 Capital Bank Bank Statement Service Fees 35.00 A B2 IS-315 10/15/11
10/15/11 IAS Accountants Invoice Bookkeeping 1,000.00 A B1 IS-305 11/2/11
10/20/11 Example (Pty) Ltd Transfer Inter Account Transfer -20,000.00 E B2 BS-399 10/20/11
10/20/11 Example (Pty) Ltd Transfer Inter Account Transfer 20,000.00 E B1 BS-399 10/20/11
10/22/11 Waltons Invoice Stationery 289.00 A B1 IS-370 11/21/11
10/25/11 Inland Revenue Return Sales Tax 3,300.00 E B1 BS-600 10/25/11
10/26/11 Example (Pty) Ltd Payroll Salaries 20,000.00 E B2 IS-365 10/26/11
10/26/11 HP Finance Debit Order Capital repayment 220.00 E B1 BS-700 10/26/11
10/26/11 HP Finance Debit Order Interest paid 100.00 E B1 IS-500 10/26/11
10/26/11 PR Properties Debit Order Rent 6,400.00 A B1 IS-350 10/26/11
10/28/11 Interflora Cash Flowers 218.00 A PC IS-345 10/28/11
10/31/11 Example (Pty) Ltd Bank Statement Petty Cash Reimbursement 200.00 E B1 BS-399 10/31/11
10/31/11 Example (Pty) Ltd Bank Statement Petty Cash Reimbursement -200.00 E PC BS-399 10/31/11
11/1/11 IS Communications Invoice EXP30 Internet Service Provider 179.00 A B1 IS-380 12/1/11
11/5/11 EAG Brokers Debit Order Insurance 340.00 A B1 IS-340 11/5/11
11/5/11 XY Traders Invoice 12987 Commission 982.00 A B1 IS-320 12/5/11
11/15/11 Capital Bank Bank Statement Service Fees 80.00 A B1 IS-315 11/15/11
11/15/11 Capital Bank Bank Statement Service Fees 35.00 A B2 IS-315 11/15/11
11/15/11 IAS Accountants Invoice Bookkeeping 1,000.00 A B1 IS-305 12/3/11
11/19/11 Interflora Cash Flowers 102.00 A PC IS-345 11/19/11
11/20/11 Example (Pty) Ltd Transfer Inter Account Transfer -20,000.00 E B2 BS-399 11/20/11
11/20/11 Example (Pty) Ltd Transfer Inter Account Transfer 20,000.00 E B1 BS-399 11/20/11
11/26/11 Example (Pty) Ltd Payroll Salaries 20,000.00 E B2 IS-365 11/26/11
11/26/11 HP Finance Debit Order Capital repayment 220.00 E B1 BS-700 11/26/11
11/26/11 HP Finance Debit Order Interest paid 100.00 E B1 IS-500 11/26/11
11/26/11 PR Properties Debit Order Rent 6,400.00 A B1 IS-350 11/26/11
11/30/11 Example (Pty) Ltd Bank Statement Petty Cash Reimbursement 170.00 E B1 BS-399 11/30/11
11/30/11 Example (Pty) Ltd Bank Statement Petty Cash Reimbursement -170.00 E PC BS-399 11/30/11
12/1/11 IS Communications Invoice EXP31 Internet Service Provider 179.00 A B1 IS-380 12/31/11
12/5/11 EAG Brokers Debit Order Insurance 340.00 A B1 IS-340 12/5/11
12/6/11 Interflora Cash Flowers 96.00 A PC IS-345 12/6/11
12/15/11 Capital Bank Bank Statement Service Fees 80.00 A B1 IS-315 12/15/11
12/15/11 Capital Bank Bank Statement Service Fees 35.00 A B2 IS-315 12/15/11
12/15/11 IAS Accountants Invoice Bookkeeping 1,000.00 A B1 IS-305 1/2/12
12/17/11 Newscorp M00353051 Subscriptions 120.00 A B1 IS-375 1/16/12
12/17/11 Waltons Invoice Stationery 310.00 A B1 IS-370 1/16/12
12/17/11 XY Traders Invoice 13432 Commission 962.00 A B1 IS-320 1/16/12
12/20/11 Example (Pty) Ltd Transfer Inter Account Transfer -20,000.00 E B2 BS-399 12/20/11
12/20/11 Example (Pty) Ltd Transfer Inter Account Transfer 20,000.00 E B1 BS-399 12/20/11
12/22/11 GF Supplies IN1192 Consumables 61.00 A PC IS-325 1/21/12
12/25/11 Inland Revenue Return Sales Tax 8,400.00 E B1 BS-600 12/25/11
12/26/11 Example (Pty) Ltd Payroll Salaries 20,000.00 E B2 IS-365 12/26/11
12/26/11 HP Finance Debit Order Capital repayment 220.00 E B1 BS-700 12/26/11
12/26/11 HP Finance Debit Order Interest paid 100.00 E B1 IS-500 12/26/11
12/26/11 PR Properties Debit Order Rent 6,400.00 A B1 IS-350 12/26/11
12/31/11 Example (Pty) Ltd Bank Statement Petty Cash Reimbursement 100.00 E B1 BS-399 12/31/11
12/31/11 Example (Pty) Ltd Bank Statement Petty Cash Reimbursement -100.00 E PC BS-399 12/31/11
1/1/12 IS Communications Invoice EXP32 Internet Service Provider 179.00 A B1 IS-380 1/31/12
1/5/12 EAG Brokers Debit Order Insurance 340.00 A B1 IS-340 1/5/12
1/15/12 Capital Bank Bank Statement Service Fees 80.00 A B1 IS-315 1/15/12
1/15/12 Capital Bank Bank Statement Service Fees 35.00 A B2 IS-315 1/15/12
1/15/12 IAS Accountants Invoice Bookkeeping 1,000.00 A B1 IS-305 2/2/12
1/16/12 Interflora Cash Flowers 105.00 A PC IS-345 1/16/12
1/20/12 Example (Pty) Ltd Transfer Inter Account Transfer -20,000.00 E B2 BS-399 1/20/12
1/20/12 Example (Pty) Ltd Transfer Inter Account Transfer 20,000.00 E B1 BS-399 1/20/12
1/26/12 Example (Pty) Ltd Payroll Salaries 20,000.00 E B2 IS-365 1/26/12
1/26/12 HP Finance Debit Order Capital repayment 220.00 E B1 BS-700 1/26/12
1/26/12 HP Finance Debit Order Interest paid 100.00 E B1 IS-500 1/26/12
1/26/12 PR Properties Debit Order Rent 6,400.00 A B1 IS-350 1/26/12
1/26/12 Training Inc Invoice Training 389.25 A B1 IS-385 1/31/12
1/28/12 XY Traders Invoice 14278 Commission 514.00 A B1 IS-320 2/27/12
1/31/12 Example (Pty) Ltd Bank Statement Petty Cash Reimbursement 170.00 E B1 BS-399 1/31/12
1/31/12 Example (Pty) Ltd Bank Statement Petty Cash Reimbursement -170.00 E PC BS-399 1/31/12
2/1/12 IS Communications Invoice EXP33 Internet Service Provider 179.00 A B1 IS-380
2/5/12 EAG Brokers Debit Order Insurance 340.00 A B1 IS-340 2/5/12
2/11/12 Waltons Invoice Stationery 289.00 A B1 IS-370
2/15/12 Capital Bank Bank Statement Service Fees 80.00 A B1 IS-315 2/15/12
2/15/12 Capital Bank Bank Statement Service Fees 35.00 A B2 IS-315 2/15/12
2/15/12 IAS Accountants Invoice Bookkeeping 1,000.00 A B1 IS-305
2/20/12 Example (Pty) Ltd Transfer Inter Account Transfer -20,000.00 E B2 BS-399 2/20/12
2/20/12 Example (Pty) Ltd Transfer Inter Account Transfer 20,000.00 E B1 BS-399 2/20/12
2/25/12 Inland Revenue Return Sales Tax 2,200.00 E B1 BS-600 2/25/12
2/25/12 Interflora Cash Flowers 75.00 A PC IS-345 2/25/12
2/26/12 DF Equipment Invoice Office equipment 10,000.00 A B1 BS-100
2/26/12 Example (Pty) Ltd Payroll Salaries 20,000.00 E B2 IS-365 2/26/12
2/26/12 HP Finance Debit Order Capital repayment 220.00 E B1 BS-700 2/26/12
2/26/12 HP Finance Debit Order Interest paid 100.00 E B1 IS-500 2/26/12
2/26/12 PR Properties Debit Order Rent 6,400.00 A B1 IS-350 2/26/12
2/29/12 Example (Pty) Ltd Bank Statement Petty Cash Reimbursement 70.00 E B1 BS-399 2/29/12
2/29/12 Example (Pty) Ltd Bank Statement Petty Cash Reimbursement -70.00 E PC BS-399 2/29/12
2/29/12 Inland Revenue Return Provisional Tax 3,700.00 E B1 IS-600 2/29/12