Exercise 1
Exercise 1
Exercise 1
Aristos, S.A
Month January-16
Expenditure
Motor Travelling, Professional, Public Printing, Computer Books, Bank Charges Transfers to Corporation Directors
Bank ref/ Company Cash/Personal Company Expenses Or Accommodation and Employers Company PAYE & NIC Cost of Postage & Internet & Assets Related Journals & & Interest Deposit VAT paid to Tax paid to Loan Business
Date Details Cheque No Bank Expenses Credit Card VAT Mileage Claims & Subsistence Liability Insurance Pension Net salary paid paid to HMR&C Dividends Goods sold Stationery Telephone Purchased Costs Subscriptions Accountancy Payable Use of Home Account HMC&E HMR&C Account Entertainment Sundries error line?
Bal b/f 0.00 0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
. 0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Total 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
C/fwd 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Check Totals - E202 & H202 should agree 0.00 0.00 0.00
0
Bank Reconciliation - use this section to check your spreadsheet reconciles to your bank statements
Bank Reconciliation Current Account Deposit Account
1 of 34
0
Aristos, S.A
Month February-16
Expenditure
Motor Travelling, Professional, Public Printing, Computer Books, Bank Charges Transfers to Corporation Directors
Company Cash Company Expenses Or Accommodation and Employers Company PAYE & NIC Cost of Postage & Internet & Assets Related Journals & & Interest Deposit VAT paid to Tax paid to Loan Business
Date Details Cheque No Bank Expenses Credit Card VAT Mileage Claims & Subsistence Liability Insurance Pension Net salary paid paid to HMR&C Dividends Goods sold Stationery Telephone Purchased Costs Subscriptions Accountancy Payable Use of Home Account HMC&E HMR&C Account Entertainment Sundries error line?
Balance b/f 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Total 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
C/fwd 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Check Totals - E202 & H202 should agree 0.00 0.00 0.00
0
Bank Reconciliation - use this section to check your spreadsheet reconciles to your bank statements
Bank Reconciliation Current Account Deposit Account
2 of 34
0
Aristos, S.A
Month March-16
Expenditure
Motor Travelling, Professional, Public Printing, Computer Books, Bank Charges Transfers to Corporation Directors
Company Cash Company Expenses Or Accommodation and Employers Company PAYE & NIC Cost of Postage & Internet & Assets Related Journals & & Interest Deposit VAT paid to Tax paid to Loan Business
Date Details Cheque No Bank Expenses Credit Card VAT Mileage Claims & Subsistence Liability Insurance Pension Net salary paid paid to HMR&C Dividends Goods sold Stationery Telephone Purchased Costs Subscriptions Accountancy Payable Use of Home Account HMC&E HMR&C Account Entertainment Sundries error line?
Balance b/f 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Total 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
C/fwd 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Check Totals - E202 & H202 should agree 0.00 0.00 0.00
0
Bank Reconciliation - use this section to check your spreadsheet reconciles to your bank statements
3 of 34
Aristos, S.A
Month April-16
Expenditure
Motor Travelling, Professional, Public Printing, Computer Books, Bank Charges Transfers to Corporation Directors
Company Cash Company Expenses Or Accommodation and Employers Company PAYE & NIC Cost of Postage & Internet & Assets Related Journals & & Interest Deposit VAT paid to Tax paid to Loan Business
Date Details Cheque No Bank Expenses Credit Card VAT Mileage Claims & Subsistence Liability Insurance Pension Net salary paid paid to HMR&C Dividends Goods sold Stationery Telephone Purchased Costs Subscriptions Accountancy Payable Use of Home Account HMC&E HMR&C Account Entertainment Sundries error line?
Balance b/f 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Total 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
C/fwd 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Check Totals - E202 & H202 should agree 0.00 0.00 0.00
0
Bank Reconciliation - use this section to check your spreadsheet reconciles to your bank statements
4 of 34
0
Aristos, S.A
Month May-16
Expenditure
Motor Travelling, Professional, Public Printing, Computer Books, Bank Charges Transfers to Corporation Directors
Company Cash Company Expenses Or Accommodation and Employers Company PAYE & NIC Cost of Postage & Internet & Assets Related Journals & & Interest Deposit VAT paid to Tax paid to Loan Business
Date Details Cheque No Bank Expenses Credit Card VAT Mileage Claims & Subsistence Liability Insurance Pension Net salary paid paid to HMR&C Dividends Goods sold Stationery Telephone Purchased Costs Subscriptions Accountancy Payable Use of Home Account HMC&E HMR&C Account Entertainment Sundries error line?
Balance b/f 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Total 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
C/fwd 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Check Totals - E202 & H202 should agree 0.00 0.00 0.00
0
Bank Reconciliation - use this section to check your spreadsheet reconciles to your bank statements
5 of 34
0
Aristos, S.A
Month June-16
Expenditure
Motor Travelling, Professional, Public Printing, Computer Books, Bank Charges Transfers to Corporation Directors
Company Cash Company Expenses Or Accommodation and Employers Company PAYE & NIC Cost of Postage & Internet & Assets Related Journals & & Interest Deposit VAT paid to Tax paid to Loan Business
Date Details Cheque No Bank Expenses Credit Card VAT Mileage Claims & Subsistence Liability Insurance Pension Net salary paid paid to HMR&C Dividends Goods sold Stationery Telephone Purchased Costs Subscriptions Accountancy Payable Use of Home Account HMC&E HMR&C Account Entertainment Sundries error line?
Balance b/f 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Total 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
C/fwd 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Check Totals - E202 & H202 should agree 0.00 0.00 0.00
0
Bank Reconciliation - use this section to check your spreadsheet reconciles to your bank statements
6 of 34
Aristos, S.A
Month July-16
Expenditure
Motor Travelling, Professional, Public Printing, Computer Books, Bank Charges Transfers to Corporation Directors
Company Cash Company Expenses Or Accommodation and Employers Company PAYE & NIC Cost of Postage & Internet & Assets Related Journals & & Interest Deposit VAT paid to Tax paid to Loan Business
Date Details Cheque No Bank Expenses Credit Card VAT Mileage Claims & Subsistence Liability Insurance Pension Net salary paid paid to HMR&C Dividends Goods sold Stationery Telephone Purchased Costs Subscriptions Accountancy Payable Use of Home Account HMC&E HMR&C Account Entertainment Sundries error line?
Balance b/f 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Total 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
C/fwd 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Check Totals - E202 & H202 should agree 0.00 0.00 0.00
0
Bank Reconciliation - use this section to check your spreadsheet reconciles to your bank statements
7 of 34
0
Aristos, S.A
Month August-16
Expenditure
Motor Travelling, Professional, Public Printing, Computer Books, Bank Charges Transfers to Corporation Directors
Company Cash Company Expenses Or Accommodation and Employers Company PAYE & NIC Cost of Postage & Internet & Assets Related Journals & & Interest Deposit VAT paid to Tax paid to Loan Business
Date Details Cheque No Bank Expenses Credit Card VAT Mileage Claims & Subsistence Liability Insurance Pension Net salary paid paid to HMR&C Dividends Goods sold Stationery Telephone Purchased Costs Subscriptions Accountancy Payable Use of Home Account HMC&E HMR&C Account Entertainment Sundries error line?
Balance b/f 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Total 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
C/fwd 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Check Totals - E202 & H202 should agree 0.00 0.00 0.00
0
Bank Reconciliation - use this section to check your spreadsheet reconciles to your bank statements
8 of 34
0
Aristos, S.A
Month September-16
Expenditure
Motor Travelling, Professional, Public Printing, Computer Books, Bank Charges Transfers to Corporation Directors
Company Cash Company Expenses Or Accommodation and Employers Company PAYE & NIC Cost of Postage & Internet & Assets Related Journals & & Interest Deposit VAT paid to Tax paid to Loan Business
Date Details Cheque No Bank Expenses Credit Card VAT Mileage Claims & Subsistence Liability Insurance Pension Net salary paid paid to HMR&C Dividends Goods sold Stationery Telephone Purchased Costs Subscriptions Accountancy Payable Use of Home Account HMC&E HMR&C Account Entertainment Sundries error line?
Balance b/f 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Total 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
C/fwd 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Check Totals - E202 & H202 should agree 0.00 0.00 0.00
0
Bank Reconciliation - use this section to check your spreadsheet reconciles to your bank statements
9 of 34
0
Aristos, S.A
Month October-16
Expenditure
Motor Travelling, Professional, Public Printing, Computer Books, Bank Charges Transfers to Corporation Directors
Company Cash Company Expenses Or Accommodation and Employers Company PAYE & NIC Cost of Postage & Internet & Assets Related Journals & & Interest Deposit VAT paid to Tax paid to Loan Business
Date Details Cheque No Bank Expenses Credit Card VAT Mileage Claims & Subsistence Liability Insurance Pension Net salary paid paid to HMR&C Dividends Goods sold Stationery Telephone Purchased Costs Subscriptions Accountancy Payable Use of Home Account HMC&E HMR&C Account Entertainment Sundries error line?
Balance b/f 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Total 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
C/fwd 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Check Totals - E202 & H202 should agree 0.00 0.00 0.00
0
Bank Reconciliation - use this section to check your spreadsheet reconciles to your bank statements
10 of 34
0
Aristos, S.A
Month November-16
Expenditure
Motor Travelling, Professional, Public Printing, Computer Books, Bank Charges Transfers to Corporation Directors
Company Cash Company Expenses Or Accommodation and Employers Company PAYE & NIC Cost of Postage & Internet & Assets Related Journals & & Interest Deposit VAT paid to Tax paid to Loan Business
Date Details Cheque No Bank Expenses Credit Card VAT Mileage Claims & Subsistence Liability Insurance Pension Net salary paid paid to HMR&C Dividends Goods sold Stationery Telephone Purchased Costs Subscriptions Accountancy Payable Use of Home Account HMC&E HMR&C Account Entertainment Sundries error line?
Balance b/f 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Total 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
C/fwd 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Check Totals - E202 & H202 should agree 0.00 0.00 0.00
0
Bank Reconciliation - use this section to check your spreadsheet reconciles to your bank statements
11 of 34
0
Aristos, S.A
Month December-16
Expenditure
Motor Travelling, Professional, Public Printing, Computer Books, Bank Charges Transfers to Corporation Directors
Company Cash Company Expenses Or Accommodation and Employers Company PAYE & NIC Cost of Postage & Internet & Assets Related Journals & & Interest Deposit VAT paid to Tax paid to Loan Business
Date Details Cheque No Bank Expenses Credit Card VAT Mileage Claims & Subsistence Liability Insurance Pension Net salary paid paid to HMR&C Dividends Goods sold Stationery Telephone Purchased Costs Subscriptions Accountancy Payable Use of Home Account HMC&E HMR&C Account Entertainment Sundries error line?
Balance b/f 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00
0.00
0.00 0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Total 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Yearly Totals 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Check Totals - E202 & H202 should agree 0.00 0.00 0.00
0
Bank Reconciliation - use this section to check your spreadsheet reconciles to your bank statements
12 of 34
Aristos, S.A
Year End Summary December-16 Corporation Tax estimate 0.00 Maximum dividends remaining estimate 0.00
Sales Invoices Bank Receipts IR35 Salary & PAYE Financial planners VAT Account
For use if you fall inside IR35 Max
From Int received Other Trf Int received PAYE & NI Deemed salary Corporation Dividends
Month IR35 Non IR35 Gross VAT Date Sales on Curr A/c Bankings Dep A/C on Dep A/c estimate available Tax estimate remaining est. Month Payable Paid
Bal b/f Bal b/f 0.00
January-16 0.00 0.00 0.00 0.00 January-16 0.00 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 January-16 0.00 0.00
February-16 0.00 0.00 0.00 0.00 February-16 0.00 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 February-16 0.00 0.00
March-16 0.00 0.00 0.00 0.00 March-16 0.00 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 March-16 0.00 0.00
April-16 0.00 0.00 0.00 0.00 April-16 0.00 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 April-16 0.00 0.00
May-16 0.00 0.00 0.00 0.00 May-16 0.00 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 May-16 0.00 0.00
June-16 0.00 0.00 0.00 0.00 June-16 0.00 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 June-16 0.00 0.00
July-16 0.00 0.00 0.00 0.00 July-16 0.00 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 July-16 0.00 0.00
August-16 0.00 0.00 0.00 0.00 August-16 0.00 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 August-16 0.00 0.00
September-16 0.00 0.00 0.00 0.00 September-16 0.00 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 September-16 0.00 0.00
October-16 0.00 0.00 0.00 0.00 October-16 0.00 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 October-16 0.00 0.00
November-16 0.00 0.00 0.00 0.00 November-16 0.00 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 November-16 0.00 0.00
December-16 0.00 0.00 0.00 0.00 December-16 0.00 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 December-16 0.00 0.00
TOTAL 0.00 0.00 0.00 0.00 TOTAL 0.00 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00
Company Expenditure
13
Aristos, S.A
Accountant's Calculations
Year ended December-16
Total Gross Salaries (enter total gross salaries for all employees)
Total Employer's NI (enter total employer's NI for all employees)
Flat Rate Scheme Turnover Calculation (for Corporation Tax and Dividend Estimator)
January-16 - - -
February-16 - - -
March-16 - - -
April-16 - - -
May-16 - - -
June-16 - - -
July-16 - - -
August-16 - - -
September-16 - - -
October-16 - - -
November-16 - - -
December-16 - - -
- - -
(this excludes bank interest)
January-16 - 0 0 0 0
February-16 - 0 0 0 0
March-16 - 0 0 0 0
April-16 - 0 0 0 0
May-16 - 0 0 0 0
June-16 - 0 0 0 0
July-16 - 0 0 0 0
August-16 - 0 0 0 0
September-16 - 0 0 0 0
October-16 - 0 0 0 0
14
November-16 - 0 0 0 0
December-16 - 0 0 0 0
- 0 0 0 0
Cash Expenses
Credit Card
15
16
17
Aristos, S.A Prepared By:
Working Papers Date: 16-Nov-17
Year ended December-16
Bal b/f -
- -
- OK
Bal b/f -
Interest Received -
- -
- OK
18
19
20
21
Aristos, S.A Prepared By:
Working Papers Date: 16-Nov-17
Year ended December-16
VAT Account
Bal b/f
- - -
OK
VAT Analysis: (unhide)
Bal b/f
- -
- OK
Bal b/f
22
- -
- OK
23
24
25
Aristos, S.A Prepared By:
Working Papers Date: 16-Nov-17
Year ended ###
FRS
Other
NET VAT GROSS Income Total FLAT RATE Paid O/S
b/f -
Qtr 1 - - - -
- - - -
- - - -
- - - - - - -
Qtr 2 - - - -
- - - -
- - - -
- - - - - - -
Qtr 3 - - - -
- - - -
- - - -
- - - - - - -
Qtr 4 - - - -
- - - -
- - - -
- - - - - - -
Adjs - - - -
- - - -
- - - -
- - - - - - -
Total - - - - - - - -
Per summary
Diff - - - -
(Should be nil)
Standard
Sales Purchases
NET
NET VAT GROSS VAT PAYABLE Paid O/S
b/f
Qtr 1 - - -
- - -
- - -
- - - - - -
Qtr 2 - - -
- - -
- - -
- - - - - -
Qtr 3 - - -
- - -
- - -
- - - - - -
Qtr 4 - - -
- - -
- - -
- - - - - -
Adjs - - -
- - -
- - -
- - - - - -
Total - - - - - -
Per summary
Dif - - - -
(Should be nil)
26
Aristos, S.A Prepared By:
Working Papers Date: 16-Nov-17
Year ended December-16
Employee 1
Employee 2
- - - -
27
28
Aristos, S.A Prepared By:
Working Papers Date: 16-Nov-17
Year ended December-16
Apr-11 - - -
May-11 - - -
Jun-11 - - - - -
Jul-11 - - -
Aug-11 - - -
Sep-11 - - - - -
Oct-11 - - -
Nov-11 - - -
Dec-11 - - - - -
Jan-12 - - -
Feb-12 - - -
Mar-12 - - - - -
- - - - - - - - -
29
Aristos, S.A Prepared By:
Working Papers Date: 16-Nov-17
Year ended ###
At 1 April 10 -
Additions -
Disposals -
At 31 March 11 - - - -
Depreciation
At 1 April 10 -
Disposals -
At 31 March 11 - - - -
At 31 March 11 - - - -
At 1 April 10 - - - -
Asset Schedule
Year Bal b/f Additions Total Depn bfwd Charge for year Total Depn NBV
2011 - - - -
2012 - - - - - -
2013 - - - - - -
2014 - - - - -
- - - - - - -
Disposals Schedule
Details Date Cost Acc Dep NBV Proceeds Profit/Loss
Additions Schedule
Details Date Cost
30
Description Nominal Code Dr Cr
Sales 2 -
Tarde Debtors - Invoices Raised 586 -
VAT 735 -
VAT 735 -
Motor Exps/ Mileage 266 -
Travel/ Accomodation & Subs 266 -
Company Insurance 270 -
Company Pension 220/8 -
Net Salary Paid 270/1*1 -
PAYE Paid to HMR&C 755 -
Dividends 471/1 -
Cost of Goods Sold 269 -
Stationery 264 -
Telephone 263 -
Assets Purchased 526/2 -
Computer Costs 262 -
Books & Journals 278 -
Accountancy 285 -
Bank Charges 378 -
Use of Home 273 -
Transfer to deposit Acc 673 -
VAT Paid to HMR&C 735 -
Corporation Tax Paid to HMR&C 747 -
Directors Loan Account 727/21*1 -
Business Entertainment 321 -
Sundries 280 -
31
Check Should be Zero
32
Compatibility Report for Copy of Copy of SJD-Spreadsheet-2012-2013 -
Updated September v2.xlsm
Run on 25/09/2012 11:40
The following features in this workbook are not supported by earlier versions of
Excel. These features may be lost or degraded when opening this workbook in
an earlier version of Excel or if you save this workbook in an earlier file format.
Some cells have more conditional formats than are supported by the selected 14
file format. Only the first three conditions will be displayed in earlier versions of
Excel. Month 1'! Excel 97-2003
G82:G198
Month 2'! Excel 97-2003
G79:G196
Month 3'! Excel 97-2003
G79:G196
Month 4'! Excel 97-2003
G79:G196
Month 5'! Excel 97-2003
G79:G196
Month 6'! Excel 97-2003
G79:G207
Month 7'! Excel 97-2003
G79:G196
Month 8'! Excel 97-2003
G79:G196
Month 9'! Excel 97-2003
G79:G207
Month 10'! Excel 97-2003
G79:G196
Month 11'! Excel 97-2003
G79:G207
Month 12'! Excel 97-2003
G79:G196
One or more cells in this workbook contain a conditional formatting type that is 14
not supported in earlier versions of Excel, such as data bars, color scales, or
icon sets. Month 1'! Excel 97-2003
G82:G198
Month 2'! Excel 97-2003
G79:G196
Month 3'! Excel 97-2003
G79:G196
Month 4'! Excel 97-2003
G79:G196
Month 5'! Excel 97-2003
G79:G196
Month 6'! Excel 97-2003
G79:G207
Month 7'! Excel 97-2003
G79:G196
Month 8'! Excel 97-2003
G79:G196
33
Month 9'! Excel 97-2003
G79:G207
Month 10'! Excel 97-2003
G79:G196
Month 11'! Excel 97-2003
G79:G207
Month 12'! Excel 97-2003
G79:G196
Some cells contain conditional formatting with the 'Stop if True' option cleared. 2
Earlier versions of Excel do not recognize this option and will stop after the first
true condition.
Month 1'!I6 Excel 97-2003
Summary'!N3 Excel 97-2003
Some cells or styles in this workbook contain formatting that is not supported 6 Excel 97-2003
by the selected file format. These formats will be converted to the closest
format available.
34