Spreadsheet: 674820d1588028265-sum-data-based-on-a-gl-code-and-month-in-year-book1-gl
Sheet: 2019

Code | Account | Group | Type | 2019-01-01 00:00:00 | 2019-02-01 00:00:00 | 2019-03-01 00:00:00 | 2019-04-01 00:00:00 | 2019-05-01 00:00:00 | 2019-06-01 00:00:00 | 2019-07-01 00:00:00 | 2019-08-01 00:00:00 | 2019-09-01 00:00:00 | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | Total
200 | Sales 1 |  |  | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000
210 | Sales 2 |  |  | 40000 | 40000 | 40000 | 40000 | 40000 | 40000 | 40000 | 40000 | 40000 | 40000 | 40000 | 40000
211 | Sales 3 |  |  | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000
212 | Sales 4 |  |  | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000
213 | Sales 5 |  |  | 13000 | 13000 | 13000 | 13000 | 13000 | 13000 | 13000 | 13000 | 13000 | 13000 | 13000 | 13000
214 | Sales 6 |  |  | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000
215 | Sales 7 |  |  | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000
220 | Sales 8 |  |  | 14000 | 14000 | 14000 | 14000 | 14000 | 14000 | 14000 | 14000 | 14000 | 14000 | 14000 | 14000
400 | Market Research | Overhead | Expense | -500 | -500 | -500 | -500 | -500 | -500 | -500 | -500 | -500 | -500 | -500 | -500
401 | Accountancy fees | Overhead | Expense | -1000 | -1000 | -1000 | -1000 | -1000 | -1000 | -1000 | -1000 | -1000 | -1000 | -1000 | -1000
402 | Bad Debt | Overhead | Expense | -4000 | -4000 | -4000 | -4000 | -4000 | -4000 | -4000 | -4000 | -4000 | -4000 | -4000 | -4000
403 | Conferences/Fairs/Networking | Expense | Expense | -3000 | -3000 | -3000 | -3000 | -3000 | -3000 | -3000 | -3000 | -3000 | -3000 | -3000 | -3000
404 | Bank Fees | Overhead | Expense | -2000 | -2000 | -2000 | -2000 | -2000 | -2000 | -2000 | -2000 | -2000 | -2000 | -2000 | -2000
406 | Audit Fees | Overhead | Expense | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1
407 | Tax Fees | Overhead | Expense | -200 | -200 | -200 | -200 | -200 | -200 | -200 | -200 | -200 | -200 | -200 | -200
408 | Cleaning | Overhead | Expense | -829 | -829 | -829 | -829 | -829 | -829 | -829 | -829 | -829 | -829 | -829 | -829
409 | Public Relations | Overhead | Expense | -654.07142857143 | -654.07142857143 | -654.07142857143 | -654.07142857143 | -654.07142857143 | -654.07142857143 | -654.07142857143 | -654.07142857143 | -654.07142857143 | -654.07142857143 | -654.07142857143 | -654.07142857143
410 | Outsourced Finance | Overhead | Expense | -479.14285714286 | -479.14285714286 | -479.14285714286 | -479.14285714286 | -479.14285714286 | -479.14285714286 | -479.14285714286 | -479.14285714286 | -479.14285714286 | -479.14285714286 | -479.14285714286 | -479.14285714286
411 | Service Fee | Overhead | Expense | -304.21428571429 | -304.21428571429 | -304.21428571429 | -304.21428571429 | -304.21428571429 | -304.21428571429 | -304.21428571429 | -304.21428571429 | -304.21428571429 | -304.21428571429 | -304.21428571429 | -304.21428571429
412 | Consulting | Expense | Expense | -129.28571428571 | -129.28571428571 | -129.28571428571 | -129.28571428571 | -129.28571428571 | -129.28571428571 | -129.28571428571 | -129.28571428571 | -129.28571428571 | -129.28571428571 | -129.28571428571 | -129.28571428571
416 | Depreciation Expense | Overhead | Expense | -500 | -500 | -500 | -500 | -500 | -500 | -500 | -500 | -500 | -500 | -500 | -500
419 | Gifts | Overhead | Expense | -1000 | -1000 | -1000 | -1000 | -1000 | -1000 | -1000 | -1000 | -1000 | -1000 | -1000 | -1000
420 | Entertainment-100% business | Overhead | Expense | -4000 | -4000 | -4000 | -4000 | -4000 | -4000 | -4000 | -4000 | -4000 | -4000 | -4000 | -4000
421 | Entertainment - Staff | Overhead | Expense | -3000 | -3000 | -3000 | -3000 | -3000 | -3000 | -3000 | -3000 | -3000 | -3000 | -3000 | -3000
424 | Entertainment - 0% | Expense | Expense | -2000 | -2000 | -2000 | -2000 | -2000 | -2000 | -2000 | -2000 | -2000 | -2000 | -2000 | -2000
425 | Postage, Freight & Courier | Overhead | Expense | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1
429 | General Expenses | Expense | Expense | -200 | -200 | -200 | -200 | -200 | -200 | -200 | -200 | -200 | -200 | -200 | -200
433 | Insurance | Overhead | Expense | -829 | -829 | -829 | -829 | -829 | -829 | -829 | -829 | -829 | -829 | -829 | -829
437 | Interest Paid | Overhead | Expense | -654.07142857143 | -654.07142857143 | -654.07142857143 | -654.07142857143 | -654.07142857143 | -654.07142857143 | -654.07142857143 | -654.07142857143 | -654.07142857143 | -654.07142857143 | -654.07142857143 | -654.07142857143
441 | Legal Expenses | Overhead | Expense | -479.14285714286 | -479.14285714286 | -479.14285714286 | -479.14285714286 | -479.14285714286 | -479.14285714286 | -479.14285714286 | -479.14285714286 | -479.14285714286 | -479.14285714286 | -479.14285714286 | -479.14285714286
442 | Professional Fees | Overhead | Expense | -304.21428571429 | -304.21428571429 | -304.21428571429 | -304.21428571429 | -304.21428571429 | -304.21428571429 | -304.21428571429 | -304.21428571429 | -304.21428571429 | -304.21428571429 | -304.21428571429 | -304.21428571429
445 | Light, Power, Heating | Overhead | Expense | -129.28571428571 | -129.28571428571 | -129.28571428571 | -129.28571428571 | -129.28571428571 | -129.28571428571 | -129.28571428571 | -129.28571428571 | -129.28571428571 | -129.28571428571 | -129.28571428571 | -129.28571428571
450 | Penalties & Late Payments Fees | Overhead | Expense | -500 | -500 | -500 | -500 | -500 | -500 | -500 | -500 | -500 | -500 | -500 | -500
451 | Office and FF&F Equipment (Expensed) | Overhead | Expense | -1000 | -1000 | -1000 | -1000 | -1000 | -1000 | -1000 | -1000 | -1000 | -1000 | -1000 | -1000
452 | Office Telecommunication System | Overhead | Expense | -4000 | -4000 | -4000 | -4000 | -4000 | -4000 | -4000 | -4000 | -4000 | -4000 | -4000 | -4000
453 | Mobile Phones | Overhead | Expense | -3000 | -3000 | -3000 | -3000 | -3000 | -3000 | -3000 | -3000 | -3000 | -3000 | -3000 | -3000
458 | Office Refreshments | Expense | Expense | -2000 | -2000 | -2000 | -2000 | -2000 | -2000 | -2000 | -2000 | -2000 | -2000 | -2000 | -2000
461 | Printing & Stationery | Overhead | Expense | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1
462 | IT Service & Maintenance | Overhead | Expense | -200 | -200 | -200 | -200 | -200 | -200 | -200 | -200 | -200 | -200 | -200 | -200
463 | IT Software and Consumables | Overhead | Expense | -829 | -829 | -829 | -829 | -829 | -829 | -829 | -829 | -829 | -829 | -829 | -829
465 | Rates | Overhead | Expense | -654.07142857143 | -654.07142857143 | -654.07142857143 | -654.07142857143 | -654.07142857143 | -654.07142857143 | -654.07142857143 | -654.07142857143 | -654.07142857143 | -654.07142857143 | -654.07142857143 | -654.07142857143
466 | Rent - New Office | Overhead | Expense | -479.14285714286 | -479.14285714286 | -479.14285714286 | -479.14285714286 | -479.14285714286 | -479.14285714286 | -479.14285714286 | -479.14285714286 | -479.14285714286 | -479.14285714286 | -479.14285714286 | -479.14285714286
467 | Service Charge - New Office | Overhead | Expense | -304.21428571429 | -304.21428571429 | -304.21428571429 | -304.21428571429 | -304.21428571429 | -304.21428571429 | -304.21428571429 | -304.21428571429 | -304.21428571429 | -304.21428571429 | -304.21428571429 | -304.21428571429
468 | Rates - New Office | Overhead | Expense | -129.28571428571 | -129.28571428571 | -129.28571428571 | -129.28571428571 | -129.28571428571 | -129.28571428571 | -129.28571428571 | -129.28571428571 | -129.28571428571 | -129.28571428571 | -129.28571428571 | -129.28571428571
469 | Rent | Overhead | Expense | -500 | -500 | -500 | -500 | -500 | -500 | -500 | -500 | -500 | -500 | -500 | -500
470 | Service charge | Expense | Expense | -1000 | -1000 | -1000 | -1000 | -1000 | -1000 | -1000 | -1000 | -1000 | -1000 | -1000 | -1000
473 | Repairs & Maintenance | Overhead | Expense | -4000 | -4000 | -4000 | -4000 | -4000 | -4000 | -4000 | -4000 | -4000 | -4000 | -4000 | -4000
476 | Bonus | Overhead | Expense | -3000 | -3000 | -3000 | -3000 | -3000 | -3000 | -3000 | -3000 | -3000 | -3000 | -3000 | -3000
477 | Salaries | Overhead | Expense | -2000 | -2000 | -2000 | -2000 | -2000 | -2000 | -2000 | -2000 | -2000 | -2000 | -2000 | -2000
478 | Directors' Remuneration | Overhead | Expense | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1
479 | Employers National Insurance | Overhead | Expense | -200 | -200 | -200 | -200 | -200 | -200 | -200 | -200 | -200 | -200 | -200 | -200
480 | Staff Training | Expense | Expense | -829 | -829 | -829 | -829 | -829 | -829 | -829 | -829 | -829 | -829 | -829 | -829
481 | Sundry Expenses | Expense | Expense | -654.07142857143 | -654.07142857143 | -654.07142857143 | -654.07142857143 | -654.07142857143 | -654.07142857143 | -654.07142857143 | -654.07142857143 | -654.07142857143 | -654.07142857143 | -654.07142857143 | -654.07142857143
482 | Pensions Costs | Overhead | Expense | -479.14285714286 | -479.14285714286 | -479.14285714286 | -479.14285714286 | -479.14285714286 | -479.14285714286 | -479.14285714286 | -479.14285714286 | -479.14285714286 | -479.14285714286 | -479.14285714286 | -479.14285714286
483 | Medical Insurance | Overhead | Expense | -304.21428571429 | -304.21428571429 | -304.21428571429 | -304.21428571429 | -304.21428571429 | -304.21428571429 | -304.21428571429 | -304.21428571429 | -304.21428571429 | -304.21428571429 | -304.21428571429 | -304.21428571429
484 | Subsistence | Expense | Expense | -129.28571428571 | -129.28571428571 | -129.28571428571 | -129.28571428571 | -129.28571428571 | -129.28571428571 | -129.28571428571 | -129.28571428571 | -129.28571428571 | -129.28571428571 | -129.28571428571 | -129.28571428571
485 | Subscriptions | Overhead | Expense | -500 | -500 | -500 | -500 | -500 | -500 | -500 | -500 | -500 | -500 | -500 | -500
487 | Office Consumables | Expense | Expense | -1000 | -1000 | -1000 | -1000 | -1000 | -1000 | -1000 | -1000 | -1000 | -1000 | -1000 | -1000
488 | Recruitment Expenditure | Overhead | Expense | -4000 | -4000 | -4000 | -4000 | -4000 | -4000 | -4000 | -4000 | -4000 | -4000 | -4000 | -4000
489 | Telephone & Internet | Overhead | Expense | -3000 | -3000 | -3000 | -3000 | -3000 | -3000 | -3000 | -3000 | -3000 | -3000 | -3000 | -3000
491 | Medical Claims | Overhead | Expense | -2000 | -2000 | -2000 | -2000 | -2000 | -2000 | -2000 | -2000 | -2000 | -2000 | -2000 | -2000
493 | Travel / Accommodation / Subsistence - National | Overhead | Expense | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1
494 | Travel / Accommodation / Subsistence - International | Overhead | Expense | -200 | -200 | -200 | -200 | -200 | -200 | -200 | -200 | -200 | -200 | -200 | -200
495 | Website Design | Overhead | Expense | -829 | -829 | -829 | -829 | -829 | -829 | -829 | -829 | -829 | -829 | -829 | -829
520 | Placement Agent Retainer |  |  | -654.07142857143 | -654.07142857143 | -654.07142857143 | -654.07142857143 | -654.07142857143 | -654.07142857143 | -654.07142857143 | -654.07142857143 | -654.07142857143 | -654.07142857143 | -654.07142857143 | -654.07142857143
530 | Placement Agent Retainer2 |  |  | -479.14285714286 | -479.14285714286 | -479.14285714286 | -479.14285714286 | -479.14285714286 | -479.14285714286 | -479.14285714286 | -479.14285714286 | -479.14285714286 | -479.14285714286 | -479.14285714286 | -479.14285714286
270 | Interest Income | Other Income | Income | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400
 |  | 2019-12-01 00:00:00
 | Expense