Example

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 12

Year CY

Data
Type Sum of Paid Out Sum of Paid In Sum of Net
BP 78234.79 -78234.79
CR 64545.22 64545.22
DD 1002.53 -1002.53
DR 78 -78
Total Result 79315.32 64545.22 -14770.1

Year CY

Data
Type Description Sum of Paid Out Sum of Paid ISum of Net
BP 78,234.79 ###
HMRC CORP TAX C 8,397.05 -8,397.05
HMRC PAYE/NIC C 5,270.85 -5,270.85
Evolution Boek Bo 1,440.00 -1,440.00
MrsLOAN 57,630.24 ###
Mrscorporation ta 5,136.65 -5,136.65
MrsGPC FEE 360.00 -360.00
CR 64,545.22 ###
HMRC JRS GRANT 1,983.74 1,983.74
Finn LIMITED SVC 35,082.48 ###
Milli DAWSON Opo PEOPLE 1,225.00 1,225.00
Norway RETAIL LT Norway Op 21,781.00 ###
Norway RETAIL LT INVOICE 97 573.00 573.00
Blue LTD 325.00 325.00
Norway RETAIL LT Norway RETAIL L 3,575.00 3,575.00
DD 1,002.53 -1,002.53
COMMERCIAL CAR 487.12 -487.12
HSBC PLC LOANS 210.64 -210.64
PAYPAL PAYMENT 11.04 -11.04
Collate OF OPTOM 293.73 -293.73
DR 78.00 -78.00
TOTAL CHARGES T 6.50 -6.50
TOTAL CHARGES T 6.50 -6.50
TOTAL CHARGES T 6.50 -6.50
TOTAL CHARGES T 6.50 -6.50
TOTAL CHARGES T 6.50 -6.50
TOTAL CHARGES T 6.50 -6.50
TOTAL CHARGES T 6.50 -6.50
TOTAL CHARGES T 6.50 -6.50
TOTAL CHARGES T 6.50 -6.50
TOTAL CHARGES T 6.50 -6.50
TOTAL CHARGES T 6.50 -6.50
TOTAL CHARGES T 6.50 -6.50
Total Result 79,315.32 64,545.22 ###
Bank payment

Direct debit

Category
HMRC CT payment
HMRC PAYE
Loan?
Dividends and BBL loan and salary
HMRC CT payment
Professional fees 7 1

HMRC Grant
Income
Income
Income
Income
Income

What is this
What is this
What is this
Professional fees

Bank charges
Bank charges
Bank charges
Bank charges
Bank charges
Bank charges
Bank charges
Bank charges
Bank charges
Bank charges
Bank charges
Bank charges
Date Year Personal Type Description Paid Out
11-Mar-20 PY 1 CR Arm AND NORT Arm AND NORT
16-Mar-20 PY 1 CR Finn LIMITED STROUDVISIONCENTRE
16-Mar-20 PY 1 CR Finn LIMITED SVC
22-Mar-20 PY 1 BP Evolution Boek Boek fee 288.00
25-Mar-20 PY 1 BP MrsLOAN 2,000.00
27-Mar-20 PY 1 DR TOTAL CHARGES TO 05MAR2020 6.50
4-Apr-20 PY 1 BP MrsLOAN 2,000.00
10-Apr-20 PY 2 CR Finn LIMITED SVC
15-Apr-20 PY 2 CR Finn LIMITED STROUDVISIONCENTRE
17-Apr-20 PY 2 CR Arm AND NORT ArmNORTH
21-Apr-20 PY 2 BP HMRC PAYE/NIC CUMB 120PG005092672012 997.94
27-Apr-20 PY 2 BP MrsLOAN 5,000.00
27-Apr-20 PY 2 DR TOTAL CHARGES TO 05APR2020 6.50
4-May-20 PY 2 CR Arm AND NORT INV79
9-May-20 PY 2 BP Evolution Boek Boek fee 288.00
10-May-20 PY 2 CR Finn LIMITED SVC
12-May-20 PY 2 CR HMRC JRS GRANT
13-May-20 PY 2 CR HSBC BBL Loan
27-May-20 PY 2 DR TOTAL CHARGES TO 05MAY2020 6.50
3-Jun-20 PY 2 CR HMRC JRS GRANT
17-Jun-20 PY 2 BP Evolution Boek Boek fee 288.00
27-Jun-20 PY 2 DR TOTAL CHARGES TO 05JUN2020 6.50
15-Jul-20 CY 2 CR HMRC JRS GRANT
22-Jul-20 CY 2 BP Mrscorporation tax 5,136.65
22-Jul-20 CY 2 BP Evolution Boek Boek fee 288.00
22-Jul-20 CY 2 BP MrsLOAN 8,000.00
27-Jul-20 CY 2 DR TOTAL CHARGES TO 05JUL2020 6.50
29-Jul-20 CY 2 DD COMMERCIAL CARD 32.00
4-Aug-20 CY 2 DD PAYPAL PAYMENT 5.52
5-Aug-20 CY 2 BP MrsLOAN 6,006.20
14-Aug-20 CY 2 CR Finn LIMITED SVC
17-Aug-20 CY 2 CR HMRC JRS GRANT
20-Aug-20 CY 2 BP Evolution Boek Boek fee 288.00
27-Aug-20 CY 2 DR TOTAL CHARGES TO 05AUG2020 6.50
4-Sep-20 CY 2 BP Evolution Boek Boek fee 288.00
9-Sep-20 CY 2 BP MrsLOAN 3,383.00
11-Sep-20 CY 2 CR Finn LIMITED SVC
27-Sep-20 CY 2 DR TOTAL CHARGES TO 05SEP2020 6.50
1-Oct-20 CY 2 DD Collate OF OPTOMET 293.73
3-Oct-20 CY 2 BP Evolution Boek Boek fee 288.00
6-Oct-20 CY 2 CR Milli DAWSON Opo PEOPLE
15-Oct-20 CY 2 CR Finn LIMITED SVC
27-Oct-20 CY 2 DR TOTAL CHARGES TO 05OCT2020 6.50
29-Oct-20 CY 2 BP MrsLOAN 1,500.00
30-Oct-20 CY 2 CR Milli DAWSON Opo PEOPLE
18-Nov-20 CY 2 CR Finn LIMITED SVC
24-Nov-20 CY 2 BP MrsLOAN 1,000.00
24-Nov-20 CY 2 BP MrsLOAN 1,500.00
25-Nov-20 CY 2 BP Evolution Boek Boek fee 144.00
27-Nov-20 CY 2 DR TOTAL CHARGES TO 05NOV2020 6.50
30-Nov-20 CY 2 DD COMMERCIAL CARD 243.00
1-Dec-20 CY 2 BP MrsLOAN 1,000.00
3-Dec-20 CY 2 DD PAYPAL PAYMENT 5.52
3-Dec-20 CY 2 CR HMRC JRS GRANT
11-Dec-20 CY 2 CR Finn LIMITED SVC
18-Dec-20 CY 2 CR Norway RETAIL LT Norway Op
22-Dec-20 CY 2 CR Norway RETAIL LT Norway Op
27-Dec-20 CY 2 DR TOTAL CHARGES TO 05DEC2020 6.50
28-Dec-20 CY 2 BP Evolution Boek Boek fee 144.00
28-Dec-20 CY 2 BP MrsLOAN 3,500.00
29-Dec-20 CY 2 CR Norway RETAIL LT INVOICE 97
31-Dec-20 CY 2 DD COMMERCIAL CARD 125.90
8-Jan-21 CY 2 CR Milli DAWSON Opo PEOPLE
8-Jan-21 CY 2 CR Blue LTD
13-Jan-21 CY 2 CR Norway RETAIL LT Norway Op
13-Jan-21 CY 2 CR Finn LIMITED SVC
18-Jan-21 CY 2 BP MrsLOAN 6,000.00
25-Jan-21 CY 2 DD COMMERCIAL CARD 52.62
26-Jan-21 CY 2 BP Mrsloan 3,000.00
27-Jan-21 CY 2 DR TOTAL CHARGES TO 05JAN2021 6.50
11-Feb-21 CY 2 CR Norway RETAIL LT Norway Op
12-Feb-21 CY 2 CR Finn LIMITED SVC
20-Feb-21 CY 2 BP HMRC PAYE/NIC CUMB 1984157513K 5,270.85
21-Feb-21 CY 2 BP MrsLOAN 5,200.00
22-Feb-21 CY 2 DD COMMERCIAL CARD 33.60
27-Feb-21 CY 2 DR TOTAL CHARGES TO 05FEB2021 6.50
6-Mar-21 CY 2 BP MrsLOAN 2,000.00
6-Mar-21 CY 2 BP MrsGPC FEE 360.00
12-Mar-21 CY 2 CR Norway RETAIL LT Norway Op
12-Mar-21 CY 2 CR Finn LIMITED SVC
27-Mar-21 CY 2 DR TOTAL CHARGES TO 05MAR2021 6.50
29-Mar-21 CY 2 BP Mrsloan 2,000.00
9-Apr-21 CY 3 BP MrsLOAN 1,500.00
13-Apr-21 CY 3 CR Norway RETAIL LT Norway Op
14-Apr-21 CY 3 CR Finn LIMITED SVC
15-Apr-21 CY 3 BP MrsLOAN 4,241.04
27-Apr-21 CY 3 DR TOTAL CHARGES TO 05APR2021 6.50
28-Apr-21 CY 3 BP MrsLOAN 1,600.00
11-May-21 CY 3 BP MrsLOAN 3,000.00
21-May-21 CY 3 CR Finn LIMITED SVC
25-May-21 CY 3 CR Norway RETAIL LT Norway Op
27-May-21 CY 3 DR TOTAL CHARGES TO 05MAY2021 6.50
1-Jun-21 CY 3 BP MrsLOAN 1,200.00
11-Jun-21 CY 3 BP MrsLOAN 500.00
14-Jun-21 CY 3 DD HSBC PLC LOANS FIRST PAYMENT 210.64
21-Jun-21 CY 3 BP HMRC CORP TAX CUMB 1847619919A00121A 8,397.05
25-Jun-21 CY 3 CR Norway RETAIL LT Norway RETAIL LT
25-Jun-21 CY 3 CR Finn LIMITED SVC
27-Jun-21 CY 3 DR TOTAL CHARGES TO 05JUN2021 6.50
28-Jun-21 CY 3 BP MrsLOAN 1,500.00

90,203.26

Start bank 5,328.92


Out -90,203.26
In 96,587.82
Expected closing 11,713.48

Closing 11,713.48
0.00

Start bank a/c year 26,483.58


Out -79,315.32
In 64,545.22
Expected closing 11,713.48

Closing 11,713.48
0.00
Paid In Balance Net Balance
3,985.00 9,313.92 3,985.00
1,443.52 12,652.44 1,443.52 10,757.44 -1,895.00
1,895.00 14,547.44 1,895.00 14,547.44 0.00
12,364.44 -288.00 14,259.44 1,895.00
10,364.44 -2,000.00 10,364.44 0.00
10,357.94 -6.50 10,357.94 0.00
8,357.94 -2,000.00 8,357.94 0.00
2,461.00 10,818.94 2,461.00 10,818.94 0.00
1,443.52 12,262.46 1,443.52 12,262.46 0.00
3,300.00 15,562.46 3,300.00 15,562.46 0.00
14,564.52 -997.94 14,564.52 0.00
9,558.02 -5,000.00 9,564.52 6.50
9,551.52 -6.50 9,551.52 0.00
2,400.00 11,958.02 2,400.00 11,951.52 -6.50
11,670.02 -288.00 11,670.02 0.00
1,443.52 13,113.54 1,443.52 13,113.54 0.00
954.78 14,068.32 954.78 14,068.32 0.00
11,869.00 25,937.32 11,869.00 25,937.32 0.00
25,930.82 -6.50 25,930.82 0.00
847.26 26,778.08 847.26 26,778.08 0.00
26,490.08 -288.00 26,490.08 0.00
26,483.58 -6.50 26,483.58 0.00
847.26 27,330.84 847.26 27,330.84 0.00
13,906.19 -5,136.65 22,194.19 8,288.00
13,618.19 -288.00 13,618.19 0.00
5,618.19 -8,000.00 5,618.19 0.00
13,899.69 -6.50 5,611.69 -8,288.00
13,867.69 -32.00 13,867.69 0.00
13,862.17 -5.52 13,862.17 0.00
7,855.97 -6,006.20 7,855.97 0.00
4,892.48 12,748.45 4,892.48 12,748.45 0.00
289.85 13,038.30 289.85 13,038.30 0.00
12,750.30 -288.00 12,750.30 0.00
12,743.80 -6.50 12,743.80 0.00
12,455.80 -288.00 12,455.80 0.00
9,072.80 -3,383.00 9,072.80 0.00
3,625.00 12,697.80 3,625.00 12,697.80 0.00
12,691.30 -6.50 12,691.30 0.00
12,397.57 -293.73 12,397.57 0.00
12,109.57 -288.00 12,109.57 0.00
600.00 12,709.57 600.00 12,709.57 0.00 Opo
2,975.00 15,684.57 2,975.00 15,684.57 0.00
15,678.07 -6.50 15,678.07 0.00
14,178.07 -1,500.00 14,178.07 0.00
300.00 14,478.07 300.00 14,478.07 0.00
5,460.00 19,938.07 5,460.00 19,938.07 0.00
17,438.07 -1,000.00 18,938.07 1,500.00
15,938.07 -1,500.00 15,938.07 0.00
17,294.07 -144.00 15,794.07 -1,500.00
17,287.57 -6.50 17,287.57 0.00
17,044.57 -243.00 17,044.57 0.00
16,044.57 -1,000.00 16,044.57 0.00
16,885.68 -5.52 16,039.05 -846.63
846.63 17,732.31 846.63 17,732.31 0.00
3,625.00 20,510.68 3,625.00 21,357.31 846.63
325.00 20,835.68 325.00 20,835.68 0.00
2,925.00 23,760.68 2,925.00 23,760.68 0.00 Op
23,754.18 -6.50 23,754.18 0.00
20,110.18 -144.00 23,610.18 3,500.00
16,610.18 -3,500.00 16,610.18 0.00
573.00 20,683.18 573.00 17,183.18 -3,500.00
20,557.28 -125.90 20,557.28 0.00
325.00 21,207.28 325.00 20,882.28 -325.00
325.00 21,532.28 325.00 21,532.28 0.00
3,256.00 26,788.28 3,256.00 24,788.28 -2,000.00
2,325.00 29,113.28 2,325.00 29,113.28 0.00
20,788.28 -6,000.00 23,113.28 2,325.00
20,735.66 -52.62 20,735.66 0.00
17,735.66 -3,000.00 17,735.66 0.00
17,729.16 -6.50 17,729.16 0.00
3,250.00 20,979.16 3,250.00 20,979.16 0.00
2,975.00 23,954.16 2,975.00 23,954.16 0.00
18,683.31 -5,270.85 18,683.31 0.00
13,483.31 -5,200.00 13,483.31 0.00
13,449.71 -33.60 13,449.71 0.00
13,443.21 -6.50 13,443.21 0.00
11,083.21 -2,000.00 11,443.21 360.00
10,723.21 -360.00 10,723.21 0.00
3,900.00 17,308.21 3,900.00 14,623.21 -2,685.00
2,325.00 19,633.21 2,325.00 19,633.21 0.00
17,301.71 -6.50 19,626.71 2,325.00
15,301.71 -2,000.00 15,301.71 0.00
13,801.71 -1,500.00 13,801.71 0.00
4,225.00 18,026.71 4,225.00 18,026.71 0.00
2,555.00 20,581.71 2,555.00 20,581.71 0.00
16,340.67 -4,241.04 16,340.67 0.00
16,334.17 -6.50 16,334.17 0.00
14,734.17 -1,600.00 14,734.17 0.00
11,734.17 -3,000.00 11,734.17 0.00
2,325.00 14,059.17 2,325.00 14,059.17 0.00
3,900.00 17,959.17 3,900.00 17,959.17 0.00
17,952.67 -6.50 17,952.67 0.00
16,752.67 -1,200.00 16,752.67 0.00
16,252.67 -500.00 16,252.67 0.00
16,042.03 -210.64 16,042.03 0.00
7,644.98 -8,397.05 7,644.98 0.00
3,575.00 13,219.98 3,575.00 11,219.98 -2,000.00
2,000.00 15,219.98 2,000.00 15,219.98 0.00
13,213.48 -6.50 15,213.48 2,000.00
11,713.48 -1,500.00 11,713.48 0.00

96,587.82
Opening Balance Change
ID DR CR DR CR
Accounting Category
m; n Cash A 0 115,440.00 80,750.00
d, g, k; a Arm AND NORT Arm AND NOY 9695 1188.41 13.000.
l; b Finn LIMITED L 8686.56 1.000. 2.200.
Evolution Book Book fee E 864 0
Mrs Loan L 9000 0
a Bank Charges EX 26 0 100,000.00
d HMRC A 0 804.1 1.000.
e HSBC BBL L 0 11,869.00 120
Corporation Tax EX 0 900.00
l; c Commercial Card EX 0 4.400. 240.00
Paypal Payment EX 0 64.000.
g. k Collate OF OPTOMET EX 0 8.141.5
Milli Dawson Opo People 0 0 196.190. 196.190.
Norway Retail LT Norway Op
Blue LTD
Mrs GPC FEE
HSBC PLC LOANS
Year-Ending
DR CR

34690
11.811.59
1,200.00
0
0
100,000.00
1,000.00
120
900
4.160.00
64.000.00
8.141.59
113.011.59 113.011.59

You might also like