jagomart
digital resources
picture1_Xls Formula 46512 | Business Cashflow Monthly V2


 122x       Filetype XLSX       File size 0.06 MB       Source: www.jerseybusiness.je


File: Xls Formula 46512 | Business Cashflow Monthly V2
sheet 1 cashflow business cashflow busines name if row is in colour has formula do not override apr20 may20 jun20 jul20 aug20 sep20 oct20 nov20 dec20 jan21 feb21 mar21 apr21 ...

icon picture XLSX Filetype Excel XLSX | Posted on 18 Aug 2022 | 3 years ago
Partial file snippet.
Sheet 1: Cashflow
Business Cashflow
Busines name :





















If row is in colour has formula do not override



















































Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20
Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21
Income
Notes






















Bank loan























Donation/Grant























Payroll Scheme phase 2 scheme populated from staffing sheet
- - -











































Sales excluding gst















































GST collected
- - - - - - - - -
- - - - - - - - - - - -











































































Total Income

- - - - - - - - -
- - - - - - - - - - - -

























Expenditure










































































Employee/Director Take home This feeds form Staffing tab - - - - - - - - -
- - - - - - - - - - - -

Social Contributions Q3 2020 onwards





-


-

-

-

-


Q1 & Q2 Deferred social























IT IS
- - - - - - - - -
- - - - - - - - - - - -

Other employee costs uniform, training















































Rent























Heat light & water
















































GST suffered
- - - - - - - - -
- - - - - - - - - - - -

GST return payments






-


-

-

-

-


Q1 & Q2 Deferred GST defered GST 1yr to pay















































Payments for stock/materials purchases
















































Bank charges & credit card charges
- - - - - - - - -
- - - - - - - - - - - -

Dues & subscriptions























Licenses























Rates
















































Advertising























Software subsciptions























Tel & Broadband























Insurance























Delivery charges























Professional fees























Music & entertainment























Repairs and maintenance























Other sundry costs
















































Non COVID-19 loan payments























Leased equipment payments
















































Vehicle expense








































































Cornavirus impact payouts
























Bank loan - CV scheme














































































Total Expenditure

- - - - - - - - -
- - - - - - - - - - - -

























Bank balance opening
first figure Enter from bank statement - - - - - - - - -
- - - - - - - - - - - -
Income less Expenditure

- - - - - - - - -
- - - - - - - - - - - -
Closing Bank balance

- - - - - - - - -
- - - - - - - - - - - -

Sheet 2: Staffing
NOTE: only fillin columns in grey




















































Employees / Directors
















During Cofunding payroll scheme
















Job Role Salary Monthly Salary Employee Social Employer Social IT IS rate IT IS Nett Pay (take home) Payroll co-funding scheme











6% 6.50% (employee rate) 20%










Directors
0.00 0.00 0.00
0.00 0.00 0.00

Notes





Staff
0.00 0.00 0.00
0.00 0.00 #NAME?








Staff
0.00 0.00 0.00
0.00 0.00 #NAME?

IT IS IS paid on 15th of following month of Pay e.g, Pay January by 15th of February





Staff
0.00 0.00 0.00
0.00 0.00 #NAME?

Social is paid quarterly April , July, October, January





Staff
0.00 0.00 0.00
0.00 0.00 #NAME?








Staff
0.00 0.00 0.00
0.00 0.00 #NAME?








Staff
0.00 0.00 0.00
0.00 0.00 #NAME?










0.00 0.00 0.00
0.00 0.00 #NAME?










0.00 0.00 0.00
0.00 0.00 #NAME?










0.00 0.00 0.00
0.00 0.00 #NAME?










0.00 0.00 0.00
0.00 0.00 #NAME?










0.00 0.00 0.00
0.00 0.00 #NAME?










0.00 0.00 0.00
0.00 0.00 #NAME?










0.00 0.00 0.00
0.00 0.00 #NAME?










0.00 0.00 0.00
0.00 0.00 #NAME?










0.00 0.00 0.00
0.00 0.00 #NAME?










0.00 0.00 0.00
0.00 0.00 #NAME?










0.00 0.00 0.00
0.00 0.00 #NAME?










0.00 0.00 0.00
0.00 0.00 #NAME?










0.00 0.00 0.00
0.00 0.00 #NAME?










0.00 0.00 0.00
0.00 0.00 #NAME?








Totals 0.00 0.00 0.00 0.00
0.00 0.00 0.00












































Social
















Q1 0















Q2 0















Q3 0















Q4 0























































































After PCF








Year 2021






Job Role Salary Monthly Salary Employee Social Employer Social IT IS rate IT IS Nett Pay/Take home

Increase Monthly Salary Employee Social Employer Social IT IS rate IT IS Nett Pay/take home



6% 6.50%
£


2%
6% 6.50%
£

Directors
0.00 0 0
0 0

0 0.00 0 0 0% 0 0
Staff
0.00 0 0
0 0

0 0.00 0 0 0% 0 0
Staff
0.00 0 0
0 0

0 0.00 0 0 0% 0 0
Staff
0.00 0 0
0 0

0 0.00 0 0 0% 0 0
Staff
0.00 0 0
0 0

0 0.00 0 0 0% 0 0
Staff
0.00 0 0
0 0

0 0.00 0 0 0% 0 0
Staff
0.00 0 0
0 0

0 0.00 0 0 0% 0 0


0.00 0 0
0 0

0 0.00 0 0 0% 0 0


0.00 0 0
0 0

0 0.00 0 0 0% 0 0


0.00 0 0
0 0

0 0.00 0 0 0% 0 0


0.00 0 0
0 0

0 0.00 0 0 0% 0 0


0.00 0 0
0 0

0 0.00 0 0 0% 0 0


0.00 0 0
0 0

0 0.00 0 0 0% 0 0


0.00 0 0
0 0

0 0.00 0 0 0% 0 0


0.00 0 0
0 0

0 0.00 0 0 0% 0 0


0.00 0 0
0 0

0 0.00 0 0 0% 0 0


0.00 0 0
0 0

0 0.00 0 0 0% 0 0


0.00 0 0
0 0

0 0.00 0 0 0% 0 0


0.00 0 0
0 0

0 0.00 0 0 0% 0 0


0.00 0 0
0 0

0 0.00 0 0 0% 0 0


0.00 0 0
0 0

0 0.00 0 0 0% 0 0
Totals 0 0 0 0
0 0

0 0 0 0
0 0




































Social








Social






Q1 defered







Q1 0





Q2 defered







Q2 0





Q3 0







Q3 0





Q4 0







Q4 0






Sheet 3: Loan calculator
Simple Loan Calculator





Enter values


Loan amount £-


Annual interest rate 6%


Loan period in years 5.00


Start date of loan 7/1/2020









Monthly payment


Number of payments -


Total interest


Total cost of loan


No. Payment
Date
Beginning
Balance
Payment Principal Interest Ending
Balance









































































































































































































































































































































































The words contained in this file might help you see if this file matches what you are looking for:

...Sheet cashflow business busines name if row is in colour has formula do not override apr may jun jul aug sep oct nov dec jan feb mar income notes bank loan donationgrant payroll scheme phase populated from staffing sales excluding gst collected total expenditure employeedirector take home this feeds form tab social contributions q onwards amp deferred it other employee costs uniform training rent heat light water suffered return payments defered yr to pay for stockmaterials purchases charges credit card dues subscriptions licenses rates advertising software subsciptions tel broadband insurance delivery professional fees music entertainment repairs and maintenance sundry non covid leased equipment vehicle expense cornavirus impact payouts cv balance opening first figure enter statement less closing note only fillin columns grey employees directors during cofunding job role salary monthly employer rate nett cofund...

no reviews yet
Please Login to review.