anger 2009-2-16 13:04
Mon Tue Wed Thu Fri Mon Tue Wed Thu Fri Mon Tue Wed Thu Fri Mon Tue Wed Thu Fri Mon Tue Wed Thu Fri Mon Tue Wed Thu Fri Mon Tue Wed Thu Fri Mon Tue Wed Thu Fri Mon Tue Wed Thu Fri Mon Tue Wed Thu Fri Mon Tue Wed Thu Fri Mon Tue Wed Thu Fri Mon Tue Wed Thu Fri Mon Tue Wed Thu Fri Mon Tue Wed Thu Fri
` 17-Nov 18-Nov 19-Nov 20-Nov 21-Nov 24-Nov 25-Nov 26-Nov 27-Nov 28-Nov 1-Dec 2-Dec 3-Dec 4-Dec 5-Dec 8-Dec 9-Dec 10-Dec 11-Dec 12-Dec 15-Dec 16-Dec 17-Dec 18-Dec 19-Dec 22-Dec 23-Dec 24-Dec 25-Dec 26-Dec 29-Dec 30-Dec 31-Dec 1-Jan 2-Jan 5-Jan 6-Jan 7-Jan 8-Jan 9-Jan 12-Jan 13-Jan 14-Jan 15-Jan 16-Jan 19-Jan 20-Jan 21-Jan 22-Jan 23-Jan 26-Jan 27-Jan 28-Jan 29-Jan 30-Jan 2-Feb 3-Feb 4-Feb 5-Feb 6-Feb 9-Feb 10-Feb 11-Feb 12-Feb 13-Feb 16-Feb 17-Feb 18-Feb 19-Feb 20-Feb 23-Feb 24-Feb 25-Feb 26-Feb 27-Feb
£000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's £000's
Receipts
Invoice Discounting Drawdown 412 124 198 145 242 273 225 245 216 584 262 192 203 185 244 554 196 184 222 260 215 315 226 168 245 235 234 126 (30) 64 122 530 294 43 155 205 726 301 187 205 205 205 261 185 85 205 205 261 185 205 214 214 270 194 166 234 230 292 210 220 225 217 297 197 217 97 217 297 200 220 217 217 297 173 147
Trade Account Loan Drawdowns
Other Receipts less payments to HIF 30 (30)
TOTAL RECIEPTS 412 154 168 145 242 273 225 245 216 584 262 192 203 185 244 554 196 184 222 260 215 315 226 168 245 235 234 126 (30) 64 122 530 294 43 155 205 726 301 187 205 205 205 261 185 85 205 205 261 185 205 214 214 270 194 166 234 230 292 210 220 225 217 297 197 217 97 217 297 200 220 217 217 297 173 147
Payments
Trade Loan Redemption 140 71 180 60 65 54 9 14 37 10 23 211 15 88 83 120 6 136 40 20 62 124 27 27 17 148 14 112 61 65 8
LC Redemption 66 11 109 500 23 114 237 59 331 293 238 71 176 485 131 117 116 45 122 339 98 170 396 182 181 182
Hongyi FOB 48 55 156 72 154 12 43 131 3 233 122 0 12 213 135 391 65 0 1 297 52 0 0 3 20 3 3 0 92 81 17 9 65 2 284 0 0 20 0 2 348 13 2 50 17 31 124 3 0 2 50 106 4 0 64 0
Other Suppliers FOB (119) 90 -120 15 120
Overseas Trade Suppliers 55 50 130 50 50 50 50
Stock Payments 0 87 59 0 180 680 83 120 210 169 336 86 204 0 12 269 0 191 3 256 544 15 50 88 12 506 50 83 0 135 749 115 92 1 312 822 20 62 131 52 241 0 30 163 3 20 45 240 81 139 348 65 2 284 98 184 20 112 63 348 409 2 50 17 213 309 3 0 2 231 296 4 0 64 0
Duty, VAT and Corp Tax 438 62 59 400 58 62 250 58 250 200 59 62
Exchange Rate Diffs/ Hedges -5 -44 -108 -14 -52 -14 -52 -66 -14 -52 -14 -52 -14 -52 -14 -52 -14 -52 -14 -52
H.S.B.C Interest & Charges -4 50 500 240 50 50
Rent & Rates 15 15 108 12 42 15 15
UK Trade Suppliers 3 10 15 65 72 25 85 85 70 70 70 70 70 70 70 70 70 70 70
B.G Rebates 133 208 150 150
Direct Debits 4 4 12 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 42 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5
Salaries/Pension 190 190 190 190
Expenses 10 25 50 50 20 20 20
Shanghai Salaries & Suppliers 50 25 25 25 25 25 25 25 25 25 25 25 25 25
PAYE/NIC 65 76 65 65 65
Tooling/Factory 60 95 150 65
Other Payments 569 (30) (21) 66 (47) 6 195 100 5 141 126 5 37 (9) 174 76 213 (22) 491 (47) 461 5 (22) 141 (47) 75 85 240 0 0 75 63 327 50 5 75 5 30 113 17 117 5 30 292 5 75 5 30 155 295 140 5 30 63 255 125 5 30 5 5 75 5 30 5 5 275 5 30 5 155 155 5 240 64 67
TOTAL PAYMENTS 569 57 38 66 133 686 278 220 215 310 462 91 241 (9) 186 345 213 169 494 209 1,005 20 28 229 (35) 581 135 323 0 135 824 178 419 51 317 897 25 92 244 69 358 5 60 455 8 95 50 270 236 434 488 70 32 347 353 309 25 142 68 353 484 7 80 22 218 584 8 30 7 386 451 9 240 128 67
CASH AT BANK
Opening Balance (124) (281) (184) (54) 25 134 (279) (332) (306) (306) (31) (231) (130) (168) 26 85 293 277 292 20 71 (719) (424) (226) (287) (7) (353) (254) (451) (481) (552) (1,254) (903) (1,028) (1,036) (1,198) (1,890) (1,189) (980) (1,037) (901) (1,054) (854) (653) (923) (846) (736) (581) (590) (641) (870) (1,144) (1,000) (762) (914) (1,101) (1,176) (971) (821) (680) (812) (1,072) (862) (644) (469) (470) (957) (748) (481) (288) (454) (688) (480) (422) (377)
Receipts less Payments (157) 97 130 79 109 (413) (53) 25 1 274 (200) 101 (38) 194 58 209 (17) 15 (272) 51 (790) 295 198 (61) 280 (346) 99 (198) (30) (71) (703) 352 (126) (8) (162) (692) 701 209 (57) 136 (153) 200 201 (270) 77 110 155 (9) (51) (229) (274) 144 238 (153) (187) (75) 205 150 142 (133) (259) 210 217 175 (1) (487) 209 267 193 (166) (234) 208 57 45 80
Closing Balance (281) (184) (54) 25 134 (279) (332) (306) (306) (31) (231) (130) (168) 26 85 293 277 292 20 71 (719) (424) (226) (287) (7) (353) (254) (451) (481) (552) (1,254) (903) (1,028) (1,036) (1,198) (1,890) (1,189) (980) (1,037) (901) (1,054) (854) (653) (923) (846) (736) (581) (590) (641) (870) (1,144) (1,000) (762) (914) (1,101) (1,176) (971) (821) (680) (812) (1,072) (862) (644) (469) (470) (957) (748) (481) (288) (454) (688) (480) (422) (377) (297)
Invoice Discounting Facility
Debtors - Op Bal 14,475 14,852 14,149 13,781 13,848 13,900 13,991 14,023 14,080 14,099 14,580 14,496 14,393 14,303 14,191 14,152 14,501 14,402 14,289 14,222 14,204 14,129 14,179 14,067 13,934 13,896 13,847 13,796 13,609 13,572 13,652 13,460 13,778 13,801 13,559 13,753 13,697 14,291 14,355 14,277 14,221 14,164 14,108 14,122 14,040 13,984 13,927 13,871 13,885 13,803 13,747 13,702 13,658 13,683 13,614 13,509 13,427 13,339 13,329 13,216 13,116 13,022 12,937 12,952 12,842 12,757 12,672 12,588 12,603 12,478 12,378 12,293 12,208 12,223 12,083
Masterplug UK 21 24 81 66 50 70 114 114 114 114 114 85 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 43 43 597 86 43 43 43 43 43 43 43 43 43 43 43 43 43 43 43 43 43 60 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 30
Stock clearance
BG UK 68 51 55 78 73 73 73 73 95 95 95 65 65 65 65 65 65 65 65 65 65 65 65 65 65 65 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 85 85 85 85 85 70 80 70 80 70 75 70 70 70 70 70 70 70 70 70 70 70 70 70 70
BG Export 0 0 0 100 57 75 75 75 75 70 70 70 70 90 100 100 100
Masterplug F.O.B 4 4 0 122 108 23 12 87 2 378 26 2 464 17 2 66 22 41 165 4 3 66 141 5 85 435 249 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 70 70 70 70 70 70 70 70 70 70 70 70 70 70 70 70 70 70 40
vat on uk sales 15 13 24 25 22 25 33 33 37 37 37 26 25 25 25 25 25 25 25 25 25 25 25 25 25 25 13 13 0 0 13 13 13 0 21 21 118 28 21 21 21 21 21 21 21 21 21 21 21 21 22 22 22 22 22 23 22 20 22 20 21 20 20 20 20 20 20 20 20 20 20 20 20 20 18
Total Gross Sales 108 92 160 291 253 291 232 307 248 681 246 176 191 165 242 629 182 167 231 262 206 330 169 165 243 231 229 93 0 85 88 598 337 0 199 199 850 319 199 199 199 199 269 199 199 199 199 269 199 199 210 210 280 210 150 223 217 295 217 205 211 205 305 205 205 205 205 305 205 205 205 205 305 175 118
Cash Receipts 30 749 528 200 200 200 200 200 200 200 329 275 275 275 275 275 275 275 275 275 275 275 275 275 275 275 275 275 275 275 275 237 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 300 300 300 300 300 300 285 285 285 285 285 285 285 300 300 285 285 285 285 285
Rebates Taken
Exchange adj -299
Credits for Problems 1 46 0 25 50 28 5 5 2 5 5 5 5 22 5 5 5 5 23 5 5 5 5 37 5 5 5 39 5 5 5 5 5 27 5 5 5 5 30 5 5 5 5 30 5 5 5 5 30 5 5 5 5 30 5 5 5 5 30 5 5 5 5 30 5 5 5 5 30 5
Closing Balance 14,852 14,149 13,781 13,848 13,900 13,991 14,023 14,080 14,099 14,580 14,496 14,393 14,303 14,191 14,152 14,501 14,402 14,289 14,222 14,204 14,129 14,179 14,067 13,934 13,896 13,847 13,796 13,609 13,572 13,652 13,460 13,778 13,801 13,559 13,753 13,697 14,291 14,355 14,277 14,221 14,164 14,108 14,122 14,040 13,984 13,927 13,871 13,885 13,803 13,747 13,702 13,658 13,683 13,614 13,509 13,427 13,339 13,329 13,216 13,116 13,022 12,937 12,952 12,842 12,757 12,672 12,588 12,603 12,478 12,378 12,293 12,208 12,223 12,083 11,911
Rebate Retention (800) (949) (949) (1,118) (1,118) (1,118) (1,118) (1,118) (1,118) (1,118) (1,118) (1,118) (1,118) (1,118) (1,118) (1,118) (1,118) (1,118) (1,118) (1,118) (1,118) (1,118) (1,068) (1,068) (1,068) (1,068) (1,068) (1,068) (1,068) (1,068) (1,068) (1,068) (1,068) (1,068) (1,068) (1,068) (1,068) (1,068) (1,068) (1,068) (1,068) (1,068) (1,068) (1,068) (1,218) (1,218) (1,218) (1,218) (1,218) (1,218) (1,218) (1,218) (1,218) (1,218) (1,218) (1,218) (1,218) (1,218) (1,218) (1,218) (1,218) (1,218) (1,218) (1,218) (1,218) (1,368) (1,368) (1,368) (1,368) (1,368) (1,368) (1,368) (1,368) (1,368) (1,368)
Other Retention (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462) (1,462)
Total Retention (2,262) (2,411) (2,411) (2,580) (2,580) (2,580) (2,580) (2,580) (2,580) (2,580) (2,580) (2,580) (2,580) (2,580) (2,580) (2,580) (2,580) (2,580) (2,580) (2,580) (2,580) (2,580) (2,530) (2,530) (2,530) (2,530) (2,530) (2,530) (2,530) (2,530) (2,530) (2,530) (2,530) (2,530) (2,530) (2,530) (2,530) (2,530) (2,530) (2,530) (2,530) (2,530) (2,530) (2,530) (2,680) (2,680) (2,680) (2,680) (2,680) (2,680) (2,680) (2,680) (2,680) (2,680) (2,680) (2,680) (2,680) (2,680) (2,680) (2,680) (2,680) (2,680) (2,680) (2,680) (2,680) (2,830) (2,830) (2,830) (2,830) (2,830) (2,830) (2,830) (2,830) (2,830) (2,830)
Eligible Debts 12,590 11,738 11,370 11,268 11,320 11,411 11,443 11,500 11,519 12,000 11,916 11,813 11,723 11,611 11,572 11,921 11,822 11,709 11,642 11,624 11,549 11,599 11,537 11,404 11,366 11,317 11,266 11,079 11,042 11,122 10,930 11,248 11,271 11,029 11,223 11,167 11,761 11,825 11,747 11,691 11,634 11,578 11,592 11,510 11,304 11,247 11,191 11,205 11,123 11,067 11,022 10,978 11,003 10,934 10,829 10,747 10,659 10,649 10,536 10,436 10,342 10,257 10,272 10,162 10,077 9,842 9,758 9,773 9,648 9,548 9,463 9,378 9,393 9,253 9,081
HIF Consol Current A/c 9,416 10,007 9,388 9,070 9,014 9,056 9,129 9,154 9,200 9,215 9,600 9,533 9,450 9,378 9,288 9,258 9,536 9,458 9,367 9,314 9,299 9,239 9,279 9,230 9,123 9,093 9,053 9,013 8,863 8,833 8,897 8,744 8,998 9,017 8,823 8,978 8,933 9,409 9,460 9,398 9,352 9,307 9,262 9,273 9,208 9,043 8,998 8,953 8,964 8,899 8,854 8,818 8,782 8,803 8,747 8,663 8,597 8,527 8,519 8,429 8,349 8,273 8,206 8,218 8,130 8,062 7,874 7,806 7,818 7,718 7,638 7,570 7,503 7,515 7,403
Cash Receipts 30 749 528 200 200 200 200 200 200 200 329 275 275 275 275 275 275 275 275 275 275 275 275 275 275 275 275 275 0 0 275 275 275 237 0 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 300 300 300 300 300 300 285 285 285 285 285 285 285 300 300 285 285 285 285 285
Charges 209 6 11
Closing Balance pre drawdown 9,595 9,264 8,872 8,870 8,814 8,856 8,929 8,954 9,000 9,015 9,271 9,258 9,175 9,103 9,013 8,983 9,261 9,183 9,092 9,039 9,024 8,964 9,004 8,955 8,848 8,818 8,778 8,738 8,863 8,833 8,622 8,469 8,723 8,780 8,823 8,728 8,683 9,159 9,210 9,148 9,102 9,057 9,012 9,023 8,958 8,793 8,748 8,703 8,714 8,649 8,604 8,568 8,532 8,553 8,497 8,363 8,297 8,227 8,219 8,129 8,049 7,988 7,921 7,933 7,845 7,777 7,589 7,521 7,518 7,418 7,353 7,285 7,218 7,230 7,118
Drawdown Available 477 126 225 145 242 273 225 245 216 584 262 192 203 185 244 554 196 184 222 260 215 315 226 168 245 235 234 126 (30) 64 122 530 294 43 155 205 726 301 187 205 205 205 261 185 85 205 205 261 185 205 214 214 270 194 166 234 230 292 210 220 225 217 297 197 217 97 217 297 200 220 217 217 297 173 147
Closing Balance post drawdown 10,007 9,388 9,070 9,014 9,056 9,129 9,154 9,200 9,215 9,600 9,533 9,450 9,378 9,288 9,258 9,536 9,458 9,367 9,314 9,299 9,239 9,279 9,230 9,123 9,093 9,053 9,013 8,863 8,833 8,897 8,744 8,998 9,017 8,823 8,978 8,933 9,409 9,460 9,398 9,352 9,307 9,262 9,273 9,208 9,043 8,998 8,953 8,964 8,899 8,854 8,818 8,782 8,803 8,747 8,663 8,597 8,527 8,519 8,429 8,349 8,273 8,206 8,218 8,130 8,062 7,874 7,806 7,818 7,718 7,638 7,570 7,503 7,515 7,403 7,265
CHECKS - CURRENT AVAILABLE
Euro totals (260,869) (258,651) (258,651)
£ totals (35,856) (15,895) (2,345,328)
$ Totals (32,507) 79,211 3,711,938
£ : Euro rate 1.1696 1.1696 1.1696
£ : $ Rate 1.4769 1.4769 1.4769
check MUST BE NIL (0) 0 0
LEDGERLINE INPUT
INVOICES LESS CREDIT NOTES
BG UK £ 65,976 47,325 55,252
ARLEN £ 13,890 12,628 9,313
MASTERPLUG £ 24,192 27,900 95,342
BG EXPORT $
MP FOB $ 6,290 6,074
£ EQUIVALENT SALES EX VAT 92,819 78,881 136,091
DEBIT / (CREDIT) ADJUSTMENTS
BG UK £ (44,584) (33)
ARLEN £ (12)
MASTERPLUG £ (6) (1,175)
BG EXPORT $
MP FOB $ (1,179)
£ EQUIVALENT ADJS (804) (45,771) (33)
RECEIPTS LESS DISCOUNTS
BG UK £ 4,127 12,135 291,419
ARLEN £ 14,092 13,214 11,363
MASTERPLUG £ 3,421 358,232 158,610
BG EXPORT $ 47,531
MP FOB $ 12,074 491,795 97,976
£ EQUIVALENT RECEIPTS 29,815 748,755 527,731
Stock-financing facility
Opening stock balance
Cost of sales
Purchases
Closing stock balance
Provisions @22%
Net balance
Opening facility balance
Repay
New additions
Closing balance
Stock ratio
MOVEMENT RECONCILIATIONS
BALANCE PER PRIOR DAY DAILY CASH -287 -279 -108 94 -362 -418 -344 -347 -77 -275 -174 -211 -17 41 265 248 263 -9 42 -747 -453 -255 -316 -36 -381 -282 -480 -509 -580 -1283 -931 -1057
TODAYS BALANCE (184) (54) 25 134 (279) (332) (306) (306) (31) (231) (130) (168) 26 85 293 277 292 20 71 (719) (424) (226) (287) (7) (353) (254) (451) (481) (552) (1,254) (903) (1,028)
MOVEMENT 103 226 133 40 82 86 38 42 45 44 44 44 44 44 29 29 29 29 29 29 29 29 29 29 29 29 29 29 29 29 29 29
Being:
Sales - MP UK 6 17 -21 -59 -55 -51 -47 -50 -30 -30 -30 -30 -30 -30 -30 -30 -30 -30 -30 -30 -30 -30 -30 -30 -30 -30 -30 -30 -30 -30 -30
Sales - MP FOB
Sales - BG UK -14 -14 -14 -14 -14 -14 -14 -14 -14 -14 -14 -14 -14 -14 -14 -14 -14 -14 -14 -14 -14 -14 -14 -14 -14 -14 -14 -14 -14 -14 -14
Sales - BG EXPORT -80
Cash Receipts 66 66 66 66 66 66 66 66 66 66 66 66 66 66 66 66 66 66 66 66 66 66 66 66 66 66 66 66 66 66 66
Credit Adjsutments
HIF Not drawn -27
Retention Change 135
Cheques not cleared 43 48 48 48 48 46 46 52 31 31 31 31 31 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16
Direct Debits -7 -7 -7 -7 -7 -7 -7 -7 -7 -7 -7 -7 -7 -7 -7 -7 -7 -7 -7 -7 -7 -7 -7 -7 -7 -7 -7 -7 -7 -7 -7
LC's not happened carried forward
Echange Adjs
Other:
Factory
PAYE/NIC & Corp Tax & Duty
H.S.B.C Interest & Charges -43 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13
Rebate
Import Loans -3 -3 -3 -3 -3 -3 -3 -3 -3 -3 -3 -3 -3 -3 -3 -3 -3 -3 -3 -3 -3 -3 -3 -3 -3 -3 -3 -3 -3 -3 -3 -3
LC's -1 -12 -12 -12 -12 -12 -12 -12 -12 -12 -12 -12 -12 -12 -12 -12 -12 -12 -12 -12 -12 -12 -12 -12 -12 -12 -12 -12 -12 -12 -12 -12
Drawdown 1 1
Inv Fin 30 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Shanghai 25 25 25 25 25
Ross 25 25 25
other fob 119 14 14 14 14 14 14 14 14 14 14 14 14 14 14 14 14 14 14 14 14 14 14 14 14 14 14 14 14 14 14 14
UKFOREX
hsbc -14 -14 -14 -14 -14 -14 -14 -14 -14 -14 -14 -14 -14 -14 -14 -14 -14 -14 -14 -14 -14 -14 -14 -14 -14 -14 -14 -14 -14 -14 -14
0 103 226 133 40 82 86 38 42 45 44 44 44 44 44 29 29 29 29 29 29 29 29 29 29 29 29 29 29 29 29 29 29
- - -0 -0 0 0 0 -0 -0 0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0.