Spreadsheet: 102413d1300358179-advanced-vlookup-pri14
Sheet: Priam Report

14MAR11 08:40 AM ~ RU
Trial Balance Report / NL46
Year: 2011  Period: JAN11 to MAR11
Do not consolidate companies
Do not consolidate cost centres
Show nominal ledger values
Cost Centre: 01001 - RUCraft - Online
Current Assets
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
1100 | Debtors |  |  | 0 | 15554.72 |  | 15554.72
1230 | [NAME] |  |  | 0 | 41.93 |  | 41.93
1240 | Postal Orders Recd |  |  | 0 | 8 |  | 8
1280 | Charged Credit Cards |  |  | 0 | 57715.29 |  | 57715.29
1300 | Stock Holding |  |  | 0 |  | 30487.64 | -30487.64
Current Assets |  |  |  | 0 | 42832.3 |  | 42832.3
Current Liabilities
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
2100 | Creditors |  |  | 0 |  | 1021.46 | -1021.46
2201 | VAT liability |  |  | 0 |  | 9081.32 | -9081.32
9920 | SOP Payment Methods Control |  |  | 0 | 3 |  | 3
Current Liabilities |  |  |  | 0 |  | 10099.78 | -10099.78
Cost of Sales
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
8000 | Product Cost of Sales - Chart |  |  | 0 | 18.7 |  | 18.7
8010 | Product Cost of Sales - CD |  |  | 0 | 118.32 |  | 118.32
8020 | Product Cost of Sales - DVD |  |  | 0 | 215.15 |  | 215.15
8030 | Product Cost of Sales - Kit |  |  | 0 | 4186.47 |  | 4186.47
8040 | Product Cost of Sales - Other Prod |  |  | 0 | 18422.82 |  | 18422.82
8050 | Product Cost of Sales - Drop Ship |  |  | 0 | 996.68 |  | 996.68
8060 | Product Cost of Sales - Puzzles |  |  | 0 | 124.5 |  | 124.5
8100 | Book Cost of Sales UK - D&C |  |  | 0 | 3069.8 |  | 3069.8
8105 | Book Cost of Sales UK - RD |  |  | 0 | 19.8 |  | 19.8
8110 | Book Cost of Sales UK - Other Publ |  |  | 0 | 3486.07 |  | 3486.07
8115 | Book Cost of Sales US - F&W |  |  | 0 | 483.04 |  | 483.04
8125 | Book Cost of Sales US - Krause |  |  | 0 | 330.54 |  | 330.54
8135 | Book Cost of Sales US - Other Publ |  |  | 0 | 36.7 |  | 36.7
8200 | Download Cost of Sales - D&C |  |  | 0 | 0.51 |  | 0.51
Cost of Sales |  |  |  | 0 | 31509.1 |  | 31509.1
Expenses
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
6400 | [NAME] |  |  | 0 | 12.41 |  | 12.41
6500 | Sales discounts |  |  | 0 | 581.39 |  | 581.39
Expenses |  |  |  | 0 | 593.8 |  | 593.8
Sales
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
4000 | Product Sales - Chart |  |  | 0 |  | 43.14 | -43.14
4010 | Product Sales - CD |  |  | 0 |  | 287.59 | -287.59
4020 | Product Sales - DVD |  |  | 0 |  | 107.15 | -107.15
4030 | Product Sales - Kit |  |  | 0 |  | 9376.02 | -9376.02
4040 | Product Sales - Other Product |  |  | 0 |  | 33869.21 | -33869.21
4050 | Product Sales - Drop Ship Product |  |  | 0 |  | 1893.68 | -1893.68
4060 | Product Sales - Puzzles |  |  | 0 |  | 160.89 | -160.89
4100 | Book Sales UK - D&C |  |  | 0 |  | 7718.6 | -7718.6
4105 | Book Sales UK - RD |  |  | 0 |  | 29.97 | -29.97
4110 | Book Sales UK - Other Publishers |  |  | 0 |  | 7304.17 | -7304.17
4115 | Book Sales US - F&W |  |  | 0 |  | 1154.39 | -1154.39
4130 | Book Sales US - Krause |  |  | 0 |  | 899.91 | -899.91
4135 | Book Sales US - Other Publishers |  |  | 0 |  | 98.48 | -98.48
4200 | [NAME] |  |  | 0 |  | 114.86 | -114.86
4900 | Post & Packing - Standard |  |  | 0 |  | 1674.75 | -1674.75
4910 | Post & Packing - Express |  |  | 0 |  | 102.61 | -102.61
Sales |  |  |  | 0 |  | 64835.42 | -64835.42
Total for RUCraft - Online |  |  |  | 0 |  |  | 0
Cost Centre: 01002 - RUCraft - Offline
Current Assets
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
1100 | Debtors |  |  | 0 | 53653.22 |  | 53653.22
1200 | Bank |  |  | 0 |  | 395.78 | -395.78
1230 | [NAME] |  |  | 0 | 13282.19 |  | 13282.19
1240 | Postal Orders Recd |  |  | 0 | 803.64 |  | 803.64
1255 | DTC Cash Recd |  |  | 0 | 15 |  | 15
1280 | Charged Credit Cards |  |  | 0 | 28117.53 |  | 28117.53
1300 | Stock Holding |  |  | 0 |  | 36261.37 | -36261.37
Current Assets |  |  |  | 0 | 59214.43 |  | 59214.43
Current Liabilities
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
2100 | Creditors |  |  | 0 |  | 58.57 | -58.57
2201 | VAT liability |  |  | 0 |  | 11482.39 | -11482.39
2300 | Overpayments |  |  | 0 |  | 396.7 | -396.7
9920 | SOP Payment Methods Control |  |  | 0 |  | 368.6 | -368.6
Current Liabilities |  |  |  | 0 |  | 12306.26 | -12306.26
Cost of Sales
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
8000 | Product Cost of Sales - Chart |  |  | 0 | 17.05 |  | 17.05
8010 | Product Cost of Sales - CD |  |  | 0 | 15.4 |  | 15.4
8020 | Product Cost of Sales - DVD |  |  | 0 | 710.26 |  | 710.26
8030 | Product Cost of Sales - Kit |  |  | 0 | 3965.81 |  | 3965.81
8040 | Product Cost of Sales - Other Prod |  |  | 0 | 22134.89 |  | 22134.89
8050 | Product Cost of Sales - Drop Ship |  |  | 0 | 58.57 |  | 58.57
8060 | Product Cost of Sales - Puzzles |  |  | 0 | 749.71 |  | 749.71
8100 | Book Cost of Sales UK - D&C |  |  | 0 | 2835.87 |  | 2835.87
8105 | Book Cost of Sales UK - RD |  |  | 0 | 22.4 |  | 22.4
8110 | Book Cost of Sales UK - Other Publ |  |  | 0 | 5139.73 |  | 5139.73
8115 | Book Cost of Sales US - F&W |  |  | 0 | 289.17 |  | 289.17
8125 | Book Cost of Sales US - Krause |  |  | 0 | 329.99 |  | 329.99
8135 | Book Cost of Sales US - Other Publ |  |  | 0 | 51.05 |  | 51.05
8200 | Download Cost of Sales - D&C |  |  | 0 | 0.04 |  | 0.04
Cost of Sales |  |  |  | 0 | 36319.94 |  | 36319.94
Expenses
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
6500 | Sales discounts |  |  | 0 | 156.44 |  | 156.44
Expenses |  |  |  | 0 | 156.44 |  | 156.44
Sales
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
4000 | Product Sales - Chart |  |  | 0 |  | 42.11 | -42.11
4010 | Product Sales - CD |  |  | 0 |  | 38.32 | -38.32
4020 | Product Sales - DVD |  |  | 0 |  | 84.47 | -84.47
4030 | Product Sales - Kit |  |  | 0 |  | 9073.3 | -9073.3
4040 | Product Sales - Other Product |  |  | 0 |  | 42244.72 | -42244.72
4050 | Product Sales - Drop Ship Product |  |  | 0 |  | 98.09 | -98.09
4060 | Product Sales - Puzzles |  |  | 0 |  | 937.15 | -937.15
4100 | Book Sales UK - D&C |  |  | 0 |  | 7218.32 | -7218.32
4105 | Book Sales UK - RD |  |  | 0 |  | 43.96 | -43.96
4110 | Book Sales UK - Other Publishers |  |  | 0 |  | 13059.6 | -13059.6
4115 | Book Sales US - F&W |  |  | 0 |  | 746.91 | -746.91
4130 | Book Sales US - Krause |  |  | 0 |  | 945.76 | -945.76
4135 | Book Sales US - Other Publishers |  |  | 0 |  | 171.54 | -171.54
4200 | [NAME] |  |  | 0 |  | 14.97 | -14.97
4900 | Post & Packing - Standard |  |  | 0 |  | 8656.84 | -8656.84
4910 | Post & Packing - Express |  |  | 0 |  | 8.49 | -8.49
Sales |  |  |  | 0 |  | 83384.55 | -83384.55
Total for RUCraft - Offline |  |  |  | 0 |  |  | 0
Cost Centre: 01004 - RUCraft - CS Requests
Current Assets
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
1300 | Stock Holding |  |  | 0 |  | 173.38 | -173.38
Current Assets |  |  |  | 0 |  | 173.38 | -173.38
Cost of Sales
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
8030 | Product Cost of Sales - Kit |  |  | 0 | 5.19 |  | 5.19
8040 | Product Cost of Sales - Other Prod |  |  | 0 | 123.04 |  | 123.04
8100 | Book Cost of Sales UK - D&C |  |  | 0 | 35.4 |  | 35.4
8110 | Book Cost of Sales UK - Other Publ |  |  | 0 | 5.75 |  | 5.75
8125 | Book Cost of Sales US - Krause |  |  | 0 | 4 |  | 4
Cost of Sales |  |  |  | 0 | 173.38 |  | 173.38
Total for RUCraft - CS Requests |  |  |  | 0 |  |  | 0
Cost Centre: 02001 - RUBooks - Online
Current Assets
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
1100 | Debtors |  |  | 0 | 701.08 |  | 701.08
1280 | Charged Credit Cards |  |  | 0 | 7371.96 |  | 7371.96
1300 | Stock Holding |  |  | 0 |  | 4955.14 | -4955.14
Current Assets |  |  |  | 0 | 3117.9 |  | 3117.9
Current Liabilities
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
2201 | VAT liability |  |  | 0 |  | 415.46 | -415.46
9920 | SOP Payment Methods Control |  |  | 0 |  |  | 0
Current Liabilities |  |  |  | 0 |  | 415.46 | -415.46
Cost of Sales
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
8020 | Product Cost of Sales - DVD |  |  | 0 | 479.94 |  | 479.94
8040 | Product Cost of Sales - Other Prod |  |  | 0 | 1566.87 |  | 1566.87
8100 | Book Cost of Sales UK - D&C |  |  | 0 | 836 |  | 836
8105 | Book Cost of Sales UK - RD |  |  | 0 | 2.6 |  | 2.6
8110 | Book Cost of Sales UK - Other Publ |  |  | 0 | 1799.47 |  | 1799.47
8115 | Book Cost of Sales US - F&W |  |  | 0 | 114.8 |  | 114.8
8135 | Book Cost of Sales US - Other Publ |  |  | 0 | 155.46 |  | 155.46
Cost of Sales |  |  |  | 0 | 4955.14 |  | 4955.14
Expenses
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
6500 | Sales discounts |  |  | 0 | 80.6 |  | 80.6
Expenses |  |  |  | 0 | 80.6 |  | 80.6
Sales
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
4020 | Product Sales - DVD |  |  | 0 |  | 223.91 | -223.91
4040 | Product Sales - Other Product |  |  | 0 |  | 1883.18 | -1883.18
4100 | Book Sales UK - D&C |  |  | 0 |  | 1514.94 | -1514.94
4105 | Book Sales UK - RD |  |  | 0 |  | 9.98 | -9.98
4110 | Book Sales UK - Other Publishers |  |  | 0 |  | 3106.52 | -3106.52
4115 | Book Sales US - F&W |  |  | 0 |  | 251.22 | -251.22
4135 | Book Sales US - Other Publishers |  |  | 0 |  | 181.66 | -181.66
4500 | Prize Draw |  |  | 0 | 100 |  | 100
4900 | Post & Packing - Standard |  |  | 0 |  | 660.94 | -660.94
4910 | Post & Packing - Express |  |  | 0 |  | 5.83 | -5.83
Sales |  |  |  | 0 |  | 7738.18 | -7738.18
Total for RUBooks - Online |  |  |  | 0 |  |  | 0
Cost Centre: 02002 - RUBooks - Offline
Current Assets
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
1100 | Debtors |  |  | 0 | 4090.56 |  | 4090.56
1200 | Bank |  |  | 0 |  | 75.52 | -75.52
1230 | [NAME] |  |  | 0 | 2710.94 |  | 2710.94
1235 | D&C Cheques Recd |  |  | 0 | 60.96 |  | 60.96
1240 | Postal Orders Recd |  |  | 0 | 114.63 |  | 114.63
1280 | Charged Credit Cards |  |  | 0 | 6106.06 |  | 6106.06
1300 | Stock Holding |  |  | 0 |  | 6524.71 | -6524.71
Current Assets |  |  |  | 0 | 6482.92 |  | 6482.92
Current Liabilities
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
2201 | VAT liability |  |  | 0 |  | 958.13 | -958.13
2300 | Overpayments |  |  | 0 |  | 19.96 | -19.96
9920 | SOP Payment Methods Control |  |  | 0 |  |  | 0
Current Liabilities |  |  |  | 0 |  | 978.09 | -978.09
Cost of Sales
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
8020 | Product Cost of Sales - DVD |  |  | 0 | 319.97 |  | 319.97
8030 | Product Cost of Sales - Kit |  |  | 0 | 19.84 |  | 19.84
8040 | Product Cost of Sales - Other Prod |  |  | 0 | 3568.67 |  | 3568.67
8060 | Product Cost of Sales - Puzzles |  |  | 0 | 54.15 |  | 54.15
8100 | Book Cost of Sales UK - D&C |  |  | 0 | 1041.33 |  | 1041.33
8110 | Book Cost of Sales UK - Other Publ |  |  | 0 | 1432.76 |  | 1432.76
8115 | Book Cost of Sales US - F&W |  |  | 0 | 79.6 |  | 79.6
8135 | Book Cost of Sales US - Other Publ |  |  | 0 | 8.39 |  | 8.39
Cost of Sales |  |  |  | 0 | 6524.71 |  | 6524.71
Expenses
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
6500 | Sales discounts |  |  | 0 | 28.95 |  | 28.95
Expenses |  |  |  | 0 | 28.95 |  | 28.95
Sales
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
4020 | Product Sales - DVD |  |  | 0 |  | 80.9 | -80.9
4030 | Product Sales - Kit |  |  | 0 |  | 27.47 | -27.47
4040 | Product Sales - Other Product |  |  | 0 |  | 4384.32 | -4384.32
4060 | Product Sales - Puzzles |  |  | 0 |  | 87.75 | -87.75
4100 | Book Sales UK - D&C |  |  | 0 |  | 2883.8 | -2883.8
4110 | Book Sales UK - Other Publishers |  |  | 0 |  | 3167.58 | -3167.58
4115 | Book Sales US - F&W |  |  | 0 |  | 253.86 | -253.86
4135 | Book Sales US - Other Publishers |  |  | 0 |  | 9.99 | -9.99
4900 | Post & Packing - Standard |  |  | 0 |  | 1154.5 | -1154.5
4910 | Post & Packing - Express |  |  | 0 |  | 8.32 | -8.32
Sales |  |  |  | 0 |  | 12058.49 | -12058.49
Total for RUBooks - Offline |  |  |  | 0 |  |  | 0
Cost Centre: 02004 - RUBooks - CS Requests
Current Assets
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
1300 | Stock Holding |  |  | 0 |  | 80.65 | -80.65
Current Assets |  |  |  | 0 |  | 80.65 | -80.65
Cost of Sales
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
8040 | Product Cost of Sales - Other Prod |  |  | 0 | 76.85 |  | 76.85
8100 | Book Cost of Sales UK - D&C |  |  | 0 | 3.8 |  | 3.8
Cost of Sales |  |  |  | 0 | 80.65 |  | 80.65
Total for RUBooks - CS Requests |  |  |  | 0 |  |  | 0
Cost Centre: 03001 - Hobby Warehouse - Online
Current Assets
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
1100 | Debtors |  |  | 0 | 1178.36 |  | 1178.36
1280 | Charged Credit Cards |  |  | 0 | 12885.66 |  | 12885.66
1300 | Stock Holding |  |  | 0 |  | 7984.37 | -7984.37
Current Assets |  |  |  | 0 | 6079.65 |  | 6079.65
Current Liabilities
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
2201 | VAT liability |  |  | 0 |  | 1790.46 | -1790.46
9920 | SOP Payment Methods Control |  |  | 0 |  |  | 0
Current Liabilities |  |  |  | 0 |  | 1790.46 | -1790.46
Cost of Sales
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
8010 | Product Cost of Sales - CD |  |  | 0 | 12.76 |  | 12.76
8020 | Product Cost of Sales - DVD |  |  | 0 | 510.46 |  | 510.46
8030 | Product Cost of Sales - Kit |  |  | 0 | 74.81 |  | 74.81
8040 | Product Cost of Sales - Other Prod |  |  | 0 | 4064.42 |  | 4064.42
8060 | Product Cost of Sales - Puzzles |  |  | 0 | 2038.76 |  | 2038.76
8100 | Book Cost of Sales UK - D&C |  |  | 0 | 595.72 |  | 595.72
8105 | Book Cost of Sales UK - RD |  |  | 0 | 6.72 |  | 6.72
8110 | Book Cost of Sales UK - Other Publ |  |  | 0 | 580.74 |  | 580.74
8115 | Book Cost of Sales US - F&W |  |  | 0 | 87 |  | 87
8120 | Book Cost of Sales US - Adams |  |  | 0 | 6.76 |  | 6.76
8135 | Book Cost of Sales US - Other Publ |  |  | 0 | 6.22 |  | 6.22
Cost of Sales |  |  |  | 0 | 7984.37 |  | 7984.37
Expenses
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
6400 | [NAME] |  |  | 0 | 6.16 |  | 6.16
Expenses |  |  |  | 0 | 6.16 |  | 6.16
Sales
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
4010 | Product Sales - CD |  |  | 0 |  | 13.32 | -13.32
4020 | Product Sales - DVD |  |  | 0 |  | 83 | -83
4030 | Product Sales - Kit |  |  | 0 |  | 92.32 | -92.32
4040 | Product Sales - Other Product |  |  | 0 |  | 5051.97 | -5051.97
4060 | Product Sales - Puzzles |  |  | 0 |  | 3600.61 | -3600.61
4100 | Book Sales UK - D&C |  |  | 0 |  | 992.15 | -992.15
4105 | Book Sales UK - RD |  |  | 0 |  | 12.49 | -12.49
4110 | Book Sales UK - Other Publishers |  |  | 0 |  | 1089.48 | -1089.48
4115 | Book Sales US - F&W |  |  | 0 |  | 147.71 | -147.71
4120 | Book Sales US - Adams |  |  | 0 |  | 5.98 | -5.98
4135 | Book Sales US - Other Publishers |  |  | 0 |  | 11.99 | -11.99
4900 | Post & Packing - Standard |  |  | 0 |  | 1151.57 | -1151.57
4910 | Post & Packing - Express |  |  | 0 |  | 27.13 | -27.13
Sales |  |  |  | 0 |  | 12279.72 | -12279.72
Total for [NAME] |  |  |  | 0 |  |  | 0
Cost Centre: 03002 - Hobby Warehouse - Offline
Current Assets
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
1100 | Debtors |  |  | 0 |  |  | 0
1200 | Bank |  |  | 0 |  | 3.51 | -3.51
1230 | [NAME] |  |  | 0 | 12.5 |  | 12.5
1300 | Stock Holding |  |  | 0 |  | 1.23 | -1.23
Current Assets |  |  |  | 0 | 7.76 |  | 7.76
Current Liabilities
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
2300 | Overpayments |  |  | 0 |  |  | 0
9920 | SOP Payment Methods Control |  |  | 0 |  |  | 0
Current Liabilities |  |  |  | 0 |  |  | 0
Cost of Sales
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
8040 | Product Cost of Sales - Other Prod |  |  | 0 | 1.23 |  | 1.23
Cost of Sales |  |  |  | 0 | 1.23 |  | 1.23
Sales
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
4040 | Product Sales - Other Product |  |  | 0 |  | 5.99 | -5.99
4900 | Post & Packing - Standard |  |  | 0 |  | 3 | -3
Sales |  |  |  | 0 |  | 8.99 | -8.99
Total for [NAME] |  |  |  | 0 |  |  | 0
Cost Centre: 03003 - Hobby Warehouse - Retail
Current Assets
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
1100 | Debtors |  |  | 0 |  |  | 0
1250 | [NAME] |  |  | 0 | 5414.75 |  | 5414.75
1285 | Shop Charged Credit Cards |  |  | 0 | 6986.68 |  | 6986.68
1300 | Stock Holding |  |  | 0 |  | 5306.27 | -5306.27
Current Assets |  |  |  | 0 | 7095.16 |  | 7095.16
Current Liabilities
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
2201 | VAT liability |  |  | 0 |  | 1141.68 | -1141.68
9000 | Unused Nominal |  |  | 0 | 366.79 |  | 366.79
Current Liabilities |  |  |  | 0 |  | 774.89 | -774.89
Cost of Sales
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
8010 | Product Cost of Sales - CD |  |  | 0 | 7.94 |  | 7.94
8020 | Product Cost of Sales - DVD |  |  | 0 | 65.54 |  | 65.54
8030 | Product Cost of Sales - Kit |  |  | 0 | 194.59 |  | 194.59
8040 | Product Cost of Sales - Other Prod |  |  | 0 | 2554.63 |  | 2554.63
8050 | Product Cost of Sales - Drop Ship |  |  | 0 | 14.53 |  | 14.53
8060 | Product Cost of Sales - Puzzles |  |  | 0 | 823.85 |  | 823.85
8100 | Book Cost of Sales UK - D&C |  |  | 0 | 440.5 |  | 440.5
8105 | Book Cost of Sales UK - RD |  |  | 0 | 19.8 |  | 19.8
8110 | Book Cost of Sales UK - Other Publ |  |  | 0 | 992.44 |  | 992.44
8115 | Book Cost of Sales US - F&W |  |  | 0 | 76.57 |  | 76.57
8120 | Book Cost of Sales US - Adams |  |  | 0 | 2.73 |  | 2.73
8125 | Book Cost of Sales US - Krause |  |  | 0 | 47.25 |  | 47.25
8135 | Book Cost of Sales US - Other Publ |  |  | 0 | 65.9 |  | 65.9
Cost of Sales |  |  |  | 0 | 5306.27 |  | 5306.27
Sales
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
4010 | Product Sales - CD |  |  | 0 |  | 10.84 | -10.84
4020 | Product Sales - DVD |  |  | 0 |  | 21.63 | -21.63
4030 | Product Sales - Kit |  |  | 0 |  | 385.56 | -385.56
4040 | Product Sales - Other Product |  |  | 0 |  | 4480.62 | -4480.62
4050 | Product Sales - Drop Ship Product |  |  | 0 |  | 19.54 | -19.54
4060 | Product Sales - Puzzles |  |  | 0 |  | 1183.39 | -1183.39
4100 | Book Sales UK - D&C |  |  | 0 |  | 896.68 | -896.68
4105 | Book Sales UK - RD |  |  | 0 |  | 29.97 | -29.97
4110 | Book Sales UK - Other Publishers |  |  | 0 |  | 4308.53 | -4308.53
4115 | Book Sales US - F&W |  |  | 0 |  | 124.66 | -124.66
4120 | Book Sales US - Adams |  |  | 0 |  | 3.5 | -3.5
4130 | Book Sales US - Krause |  |  | 0 |  | 90.18 | -90.18
4135 | Book Sales US - Other Publishers |  |  | 0 |  | 61.44 | -61.44
4400 | [NAME] |  |  | 0 |  | 10 | -10
Sales |  |  |  | 0 |  | 11626.54 | -11626.54
Total for [NAME] |  |  |  | 0 |  |  | 0
Cost Centre: 04001 - Painters-books.co.uk
Current Assets
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
1100 | Debtors |  |  | 0 |  | 108.29 | -108.29
1200 | Bank |  |  | 0 |  | 91.36 | -91.36
1230 | [NAME] |  |  | 0 | 3813.75 |  | 3813.75
1240 | Postal Orders Recd |  |  | 0 | 137.57 |  | 137.57
1280 | Charged Credit Cards |  |  | 0 | 12877.89 |  | 12877.89
1300 | Stock Holding |  |  | 0 |  | 6980.65 | -6980.65
Current Assets |  |  |  | 0 | 9648.91 |  | 9648.91
Current Liabilities
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
2201 | VAT liability |  |  | 0 |  | 441.06 | -441.06
2300 | Overpayments |  |  | 0 |  | 68.49 | -68.49
9920 | SOP Payment Methods Control |  |  | 0 |  | 81.89 | -81.89
Current Liabilities |  |  |  | 0 |  | 591.44 | -591.44
Cost of Sales
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
8020 | Product Cost of Sales - DVD |  |  | 0 | 78.68 |  | 78.68
8040 | Product Cost of Sales - Other Prod |  |  | 0 | 1871.63 |  | 1871.63
8100 | Book Cost of Sales UK - D&C |  |  | 0 | 1927.29 |  | 1927.29
8110 | Book Cost of Sales UK - Other Publ |  |  | 0 | 2864.05 |  | 2864.05
8115 | Book Cost of Sales US - F&W |  |  | 0 | 239 |  | 239
Cost of Sales |  |  |  | 0 | 6980.65 |  | 6980.65
Expenses
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
6400 | [NAME] |  |  | 0 | 1.77 |  | 1.77
6500 | Sales discounts |  |  | 0 | 76 |  | 76
Expenses |  |  |  | 0 | 77.77 |  | 77.77
Sales
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
4020 | Product Sales - DVD |  |  | 0 |  | 171.1 | -171.1
4040 | Product Sales - Other Product |  |  | 0 |  | 2064.37 | -2064.37
4100 | Book Sales UK - D&C |  |  | 0 |  | 5741.06 | -5741.06
4110 | Book Sales UK - Other Publishers |  |  | 0 |  | 6264.08 | -6264.08
4115 | Book Sales US - F&W |  |  | 0 |  | 669.01 | -669.01
4900 | Post & Packing - Standard |  |  | 0 |  | 1201.28 | -1201.28
4910 | Post & Packing - Express |  |  | 0 |  | 4.99 | -4.99
Sales |  |  |  | 0 |  | 16115.89 | -16115.89
Total for Painters-books.co.uk |  |  |  | 0 |  |  | 0
Cost Centre: 05002 - Mail Life Craft
Current Assets
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
1100 | Debtors |  |  | 0 | 19.99 |  | 19.99
1200 | Bank |  |  | 0 |  | 11.99 | -11.99
1230 | [NAME] |  |  | 0 | 37.97 |  | 37.97
1280 | Charged Credit Cards |  |  | 0 | 177.93 |  | 177.93
1300 | Stock Holding |  |  | 0 |  | 143.12 | -143.12
Current Assets |  |  |  | 0 | 80.78 |  | 80.78
Current Liabilities
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
2201 | VAT liability |  |  | 0 |  | 29.42 | -29.42
9920 | SOP Payment Methods Control |  |  | 0 | 12.99 |  | 12.99
Current Liabilities |  |  |  | 0 |  | 16.43 | -16.43
Cost of Sales
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
8030 | Product Cost of Sales - Kit |  |  | 0 | 12.46 |  | 12.46
8040 | Product Cost of Sales - Other Prod |  |  | 0 | 108.11 |  | 108.11
8100 | Book Cost of Sales UK - D&C |  |  | 0 | 11.84 |  | 11.84
8110 | Book Cost of Sales UK - Other Publ |  |  | 0 | 10.71 |  | 10.71
Cost of Sales |  |  |  | 0 | 143.12 |  | 143.12
Sales
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
4030 | Product Sales - Kit |  |  | 0 |  | 17.29 | -17.29
4040 | Product Sales - Other Product |  |  | 0 |  | 187.44 | -187.44
4900 | Post & Packing - Standard |  |  | 0 |  | 2.74 | -2.74
Sales |  |  |  | 0 |  | 207.47 | -207.47
Total for Mail Life Craft |  |  |  | 0 |  |  | 0
Cost Centre: 06001 - Amazon Marketplace
Current Assets
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
1100 | Debtors |  |  | 0 |  |  | 0
1200 | Bank |  |  | 0 |  | 5671.6 | -5671.6
1270 | Amazon Payment |  |  | 0 | 24046.93 |  | 24046.93
1300 | Stock Holding |  |  | 0 |  | 5945.06 | -5945.06
Current Assets |  |  |  | 0 | 12430.27 |  | 12430.27
Current Liabilities
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
2201 | VAT liability |  |  | 0 |  | 1840.45 | -1840.45
9920 | SOP Payment Methods Control |  |  | 0 | 25.86 |  | 25.86
Current Liabilities |  |  |  | 0 |  | 1814.59 | -1814.59
Cost of Sales
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
8010 | Product Cost of Sales - CD |  |  | 0 | 65.31 |  | 65.31
8020 | Product Cost of Sales - DVD |  |  | 0 | 201.16 |  | 201.16
8030 | Product Cost of Sales - Kit |  |  | 0 | 256.68 |  | 256.68
8040 | Product Cost of Sales - Other Prod |  |  | 0 | 2647 |  | 2647
8060 | Product Cost of Sales - Puzzles |  |  | 0 | 314.19 |  | 314.19
8100 | Book Cost of Sales UK - D&C |  |  | 0 | 559.45 |  | 559.45
8105 | Book Cost of Sales UK - RD |  |  | 0 | 19.8 |  | 19.8
8110 | Book Cost of Sales UK - Other Publ |  |  | 0 | 1708.07 |  | 1708.07
8115 | Book Cost of Sales US - F&W |  |  | 0 | 160.6 |  | 160.6
8135 | Book Cost of Sales US - Other Publ |  |  | 0 | 12.8 |  | 12.8
Cost of Sales |  |  |  | 0 | 5945.06 |  | 5945.06
Expenses
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
6400 | [NAME] |  |  | 0 | 5 |  | 5
Expenses |  |  |  | 0 | 5 |  | 5
Sales
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
4010 | Product Sales - CD |  |  | 0 |  | 145.81 | -145.81
4020 | Product Sales - DVD |  |  | 0 |  | 323.69 | -323.69
4030 | Product Sales - Kit |  |  | 0 |  | 675.99 | -675.99
4040 | Product Sales - Other Product |  |  | 0 |  | 6066.17 | -6066.17
4060 | Product Sales - Puzzles |  |  | 0 |  | 529.66 | -529.66
4100 | Book Sales UK - D&C |  |  | 0 |  | 1410.1 | -1410.1
4105 | Book Sales UK - RD |  |  | 0 |  | 30 | -30
4110 | Book Sales UK - Other Publishers |  |  | 0 |  | 3910.26 | -3910.26
4115 | Book Sales US - F&W |  |  | 0 |  | 341.65 | -341.65
4135 | Book Sales US - Other Publishers |  |  | 0 |  | 52.75 | -52.75
4900 | Post & Packing - Standard |  |  | 0 |  | 3079.66 | -3079.66
Sales |  |  |  | 0 |  | 16565.74 | -16565.74
Total for Amazon Marketplace |  |  |  | 0 |  |  | 0
Cost Centre: 07001 - CraftBookStore
Current Assets
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
1100 | Debtors |  |  | 0 |  |  | 0
1280 | Charged Credit Cards |  |  | 0 | 1793.39 |  | 1793.39
1300 | Stock Holding |  |  | 0 |  | 727.91 | -727.91
Current Assets |  |  |  | 0 | 1065.48 |  | 1065.48
Current Liabilities
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
2201 | VAT liability |  |  | 0 |  | 5.65 | -5.65
9920 | SOP Payment Methods Control |  |  | 0 |  |  | 0
Current Liabilities |  |  |  | 0 |  | 5.65 | -5.65
Cost of Sales
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
8040 | Product Cost of Sales - Other Prod |  |  | 0 | 17.88 |  | 17.88
8100 | Book Cost of Sales UK - D&C |  |  | 0 | 253.53 |  | 253.53
8110 | Book Cost of Sales UK - Other Publ |  |  | 0 | 399.36 |  | 399.36
8115 | Book Cost of Sales US - F&W |  |  | 0 | 46.07 |  | 46.07
8120 | Book Cost of Sales US - Adams |  |  | 0 | 1.68 |  | 1.68
8125 | Book Cost of Sales US - Krause |  |  | 0 | 4.79 |  | 4.79
8135 | Book Cost of Sales US - Other Publ |  |  | 0 | 4.6 |  | 4.6
Cost of Sales |  |  |  | 0 | 727.91 |  | 727.91
Sales
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
4040 | Product Sales - Other Product |  |  | 0 |  | 24.42 | -24.42
4100 | Book Sales UK - D&C |  |  | 0 |  | 573.67 | -573.67
4110 | Book Sales UK - Other Publishers |  |  | 0 |  | 889.06 | -889.06
4115 | Book Sales US - F&W |  |  | 0 |  | 131.36 | -131.36
4120 | Book Sales US - Adams |  |  | 0 |  | 2.99 | -2.99
4130 | Book Sales US - Krause |  |  | 0 |  | 8.49 | -8.49
4135 | Book Sales US - Other Publishers |  |  | 0 |  | 11.46 | -11.46
4900 | Post & Packing - Standard |  |  | 0 |  | 146.29 | -146.29
Sales |  |  |  | 0 |  | 1787.74 | -1787.74
Total for CraftBookStore |  |  |  | 0 |  |  | 0
Cost Centre: C93 - Puzzles Plus
Current Assets
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
1100 | Debtors |  |  | 0 | 31979.13 |  | 31979.13
1200 | Bank |  |  | 0 |  | 221.81 | -221.81
1230 | [NAME] |  |  | 0 | 12397.7 |  | 12397.7
1240 | Postal Orders Recd |  |  | 0 | 722.82 |  | 722.82
1280 | Charged Credit Cards |  |  | 0 | 17242.86 |  | 17242.86
1300 | Stock Holding |  |  | 0 |  | 24156 | -24156
Current Assets |  |  |  | 0 | 37964.7 |  | 37964.7
Current Liabilities
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
2201 | VAT liability |  |  | 0 |  | 9772.89 | -9772.89
2300 | Overpayments |  |  | 0 |  | 89.3 | -89.3
9920 | SOP Payment Methods Control |  |  | 0 |  | 2215.44 | -2215.44
Current Liabilities |  |  |  | 0 |  | 12077.63 | -12077.63
Cost of Sales
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
8020 | Product Cost of Sales - DVD |  |  | 0 | 281.62 |  | 281.62
8030 | Product Cost of Sales - Kit |  |  | 0 | 17.3 |  | 17.3
8040 | Product Cost of Sales - Other Prod |  |  | 0 | 2692.41 |  | 2692.41
8060 | Product Cost of Sales - Puzzles |  |  | 0 | 20739.71 |  | 20739.71
8100 | Book Cost of Sales UK - D&C |  |  | 0 | 126.37 |  | 126.37
8110 | Book Cost of Sales UK - Other Publ |  |  | 0 | 286.59 |  | 286.59
8115 | Book Cost of Sales US - F&W |  |  | 0 | 12 |  | 12
Cost of Sales |  |  |  | 0 | 24156 |  | 24156
Expenses
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
6400 | [NAME] |  |  | 0 | 30.69 |  | 30.69
6500 | Sales discounts |  |  | 0 | 22.81 |  | 22.81
Expenses |  |  |  | 0 | 53.5 |  | 53.5
Sales
Nominal Code | Description |  |  | Opening | Debits | Credits | Closing
4020 | Product Sales - DVD |  |  | 0 |  | 61.25 | -61.25
4030 | Product Sales - Kit |  |  | 0 |  | 20.8 | -20.8
4040 | Product Sales - Other Product |  |  | 0 |  | 3154.25 | -3154.25
4060 | Product Sales - Puzzles |  |  | 0 |  | 39438.57 | -39438.57
4100 | Book Sales UK - D&C |  |  | 0 |  | 234.13 | -234.13
4110 | Book Sales UK - Other Publishers |  |  | 0 |  | 508.08 | -508.08
4115 | Book Sales US - F&W |  |  | 0 |  | 19.96 | -19.96
4900 | Post & Packing - Standard |  |  | 0 |  | 6659.53 | -6659.53
Sales |  |  |  | 0 |  | 50096.57 | -50096.57
Total for Puzzles Plus |  |  |  | 0 |  |  | 0
Total for Company |  |  |  | 0 |  |  | 0