Spreadsheet: 151210d1334831542-pivot-table-how-to-sort-drop-down-lists-da6126-ctreconciler-redacted
Sheet: CT 734 735 831 832 833

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Version |  | 2012-04-16-01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MWH Ref
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3rd party ref |  |  |  |  |  |  | s.419/455 analysis | DLA total | DLA | DLA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Control account |  | CT (734, 735, 831, 832, 833) |  |  |  |  | Total | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Visible subtotal | 0 | 0 | 0
0 | 0 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 1 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0
1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1
 |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | Total: |  | 0 |  | 3800 | 66.68 | 0 | -3866.68 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | Visible subtotal: |  | 0 |  | 3800 | 66.68 | 0 | -3866.68 | 0 | 0 | 0 | 0 | 0
 |  | Default | Default | Default | Default |  | Default | Default | Default |  | Default | Default |  | Default | Default |  |  |  |  | Default | Default | Default | Default | Default | Default | Default | Default | Default
 |  | <[NAME] | <[NAME] | <[NAME] | Movement £ |  | Transaction | APE | CTPE |  | Processed? | Reconciled? |  | HMRC description | Account |  |  |  |  | CT £ P&L (501, 502) | CT Interest £ P&L (417, 485) | CT Penalties £ P&L | Bank £ B/S | Reallocations £ B/S | S.419/455 £ B/S (Short term) | S.419/455 £ B/S (Long term) | Accruals £ B/S | Suspense £ P&L
6 | 0 |  | 0 |  |  | 0 |  |  |  |  | 0 | 0 |  |  |  | 0 | 0 | 0
 |  | Date | Boolean | Comment |  |  | Date | Date | Date |  | Boolean | Boolean |  | Comment | Comment
CountA | UsedRow? | <[NAME] | <[NAME] | <[NAME] | Movement £ | RowVisible? | Transaction | APE | CTPE | Boolean Divider | Processed? | Reconciled? | Comment Divider | HMRC description | Account | Total bal £ (Dr)/Cr | Visible bal £ | Movement total £ Dr/(Cr) | Blank Col | CT £ P&L (501, 502) | CT Interest £ P&L (417, 485) | CT Penalties £ P&L | Bank £ B/S | Reallocations £ B/S | S.419/455 £ B/S (Short term) | S.419/455 £ B/S (Long term) | Accruals £ B/S | Suspense £ P&L | End Col
11 | 1 |  | 0 |  |  | 1 | 2010-04-30 00:00:00 | 2010-04-30 00:00:00 | 2010-04-30 00:00:00 |  | 1 | 1 |  | Self assessment | 501 PL CY CT | 3800 | 3800 | 3800 |  | 3800
11 | 1 |  | 0 |  |  | 1 | 2011-04-30 00:00:00 | 2011-04-30 00:00:00 | 2011-04-30 00:00:00 |  | 1 | 0 |  | Provision | 501 PL CY CT | 3800 | 3800 | 0 |  | 0
11 | 1 |  | 0 |  |  | 1 | 2011-04-30 00:00:00 | 2011-04-30 00:00:00 | 2011-04-30 00:00:00 |  | 1 | 0 |  | Provision | 502 PL PY CT | 3800 | 3800 | 0 |  | 0
11 | 1 |  | 0 |  |  | 1 | 2011-07-07 00:00:00 | 2012-04-30 00:00:00 | 2010-04-30 00:00:00 |  | 0 | 1 |  | Electronic payment | 771 BS Bank | 3544 | 3544 | -256 |  |  |  |  | -256
11 | 1 |  | 0 |  |  | 1 | 2011-08-05 00:00:00 | 2012-04-30 00:00:00 | 2010-04-30 00:00:00 |  | 0 | 1 |  | Electronic payment | 771 BS Bank | 2204 | 2204 | -1340 |  |  |  |  | -1340
11 | 1 |  | 0 |  |  | 1 | 2011-09-07 00:00:00 | 2012-04-30 00:00:00 | 2010-04-30 00:00:00 |  | 0 | 1 |  | Electronic payment | 771 BS Bank | 864 | 864 | -1340 |  |  |  |  | -1340
11 | 1 |  | 0 |  |  | 1 | 2011-10-07 00:00:00 | 2012-04-30 00:00:00 | 2010-04-30 00:00:00 |  | 0 | 1 |  | Late payment interest | 485 PL Int | 930.68 | 930.68 | 66.68 |  |  | 66.68
11 | 1 |  | 0 |  |  | 1 | 2011-10-07 00:00:00 | 2012-04-30 00:00:00 | 2010-04-30 00:00:00 |  | 0 | 1 |  | Electronic payment | 771 BS Bank | 0 | 0 | -930.68 |  |  |  |  | -930.68