Profit and Loss Report

Organization

Business Unit

Location

Start Date

End Date

Outstanding Revenue

▲ 207,226

Revenue

▲ 24.48%

Expenses

▼ 28.74%

Payment Status

Gross Profit Margin

Gross Profit

327,535

Net Profit Margin

Net Profit

219,960

Top 5 Expenses by Category

Revenue Trend

Customer Growth

Top 5 Revenue-Generating Countries

Income & Expenses

Item	2017/Mar	2017/Jun	2017/Sept	2017/Dec	2018/Mar
Revenue	$286,070	$264,070	$290,824	$286,070	$286,070
Subdata	Subdata	Subdata	Subdata	Subdata	Subdata
Operating Expenses	$18,549	$20,210	$21,840	$286,070	$286,070
Subdata	Subdata	Subdata	Subdata	Subdata	Subdata
Operating Profit	$63,533	$63,533	$63,390	$286,070	$286,070
Subdata	Subdata	Subdata	Subdata	Subdata	Subdata
Other Expenses	$2,672	$2,672	$2,390	$286,070	$286,070
Subdata	Subdata	Subdata	Subdata	Subdata	Subdata
Total Income	$60,869	$60,861	$74,903	$286,070	$286,070
Subdata	Subdata	Subdata	Subdata	Subdata	Subdata
Income Tax	$2,780	$2,780	$2,904	$286,070	$286,070
Subdata	Subdata	Subdata	Subdata	Subdata	Subdata
Net Income	$60,861	$58,081	$65,939	$286,070	$286,070
Subdata	Subdata	Subdata	Subdata	Subdata	Subdata
Total	$520,803	$472,217	$499,390	$428,304	$483,945

Financial Ratio

Fiscal Year

Month

Organization

Business Unit

Location

Cash Ratio

0.73

Current Ratio

1.76

Quick Ratio

1.16

Absolutely Liquidity Ratio

0.75

Cash Ratio Trend

Quick Ratio Trend

Current Ratio Trend

Absolutely Liquidity Ratio Trend

Fiscal Year

Month

Organization

Business Unit

Location

Receivable Turnover

0.95

Debators Turnover

0.83

Cash Conversion Cycle

32

Creditors Turnover

3.6

Receivable Turnover Ratio Trend

Cash Conversion Cycle Trend

Debators Turnover Ratio Trend

Creditors Turnover Ratio Trend

Fiscal Year

Month

Organization

Business Unit

Location

Operating Leverage

0.95

Financial Leverage

0.83

Debt to Equity Ratio

0.47

Interest Cover Ratio

5

Operating Leverage Trend

Debt to Equity Ratio Trend

Financial Leverage Trend

Interest Cover Ratio Trend

Fiscal Year

Month

Organization

Business Unit

Location

Earnings Margin

27%

Return on Investment

34%

Return on Equity

14%

Earnings per Share

64

Earnings Margin Trend

Return on Equity Trend

Return on Investment Trend

Earnings per Share Trend

Ratio Comparison

Select Metric 1

Select Metric 2

Fiscal Year

Month

Business Unit

Company

Location

Earnings Margin PY

27%

Return on Equity Current

14%

Earnings Margin Current

27%

Return on Equity PY

14%

Return on Equity Trend

Earnings Margin Trend

Balance Sheet

Fiscal Year

Month

Organization

Business Unit

Location

Current Ratio

1.71

Current Ratio

1.43

Inventory Turnover Ratio

9.20

Inventory to Sales Ratio

0.06

Working Capital

63.28K

Cash Balance

2.32M

Days Sales Inventory

Days Sales Outstanding

Days Inventory Outstanding

Days Payable Outstanding

Cash to Cash Cycle

Overall Cash by Year

Debt Ratios

Account Receivable Turnover Vs Accounts Payable Turnover

Overall Financial Statement

	Cash On Hands	Accounts Receivable	Inventory	Current Assets	Property & Equipment	Accounts Payable	Debts	Current Liabilities
2019	6,437	4,6404	1,000	8,626	42,557	2,971	26,519	55,675
2020	6,437	4,6404	1,000	8,626	42,557	2,971	26,519	55,675
2021	6,437	4,6404	1,000	8,626	42,557	2,971	26,519	55,675
2022	6,437	4,6404	1,000	8,626	42,557	2,971	26,519	55,675
2023	6,437	4,6404	1,000	8,626	42,557	2,971	26,519	55,675

Category	Jan	Feb	March	Apr	May	June	July	Aug	Sept	Oct	Nov	Dec
Assets	4724556	4703603	42657338	4919853	3824905	5154164	4649748	42657338	4919853	3824905	5154164	4649748
Subdata	Subdata	Subdata	Subdata	Subdata	Subdata	Subdata	Subdata	Subdata	Subdata	Subdata	Subdata	Subdata
Liabillities	4724556	4703603	42657338	4919853	3824905	5154164	4649748	42657338	4919853	3824905	5154164	4649748
Subdata	Subdata	Subdata	Subdata	Subdata	Subdata	Subdata	Subdata	Subdata	Subdata	Subdata	Subdata	Subdata
Operating Profit	4724556	4703603	42657338	4919853	3824905	5154164	4649748	42657338	4919853	3824905	5154164	4649748
Subdata	Subdata	Subdata	Subdata	Subdata	Subdata	Subdata	Subdata	Subdata	Subdata	Subdata	Subdata	Subdata
Other Expenses	4724556	4703603	42657338	4919853	3824905	5154164	4649748	42657338	4919853	3824905	5154164	4649748
Subdata	Subdata	Subdata	Subdata	Subdata	Subdata	Subdata	Subdata	Subdata	Subdata	Subdata	Subdata	Subdata
Total Income	4724556	4703603	42657338	4919853	3824905	5154164	4649748	42657338	4919853	3824905	5154164	4649748
Subdata	Subdata	Subdata	Subdata	Subdata	Subdata	Subdata	Subdata	Subdata	Subdata	Subdata	Subdata	Subdata

Fiscal Year

Month

Organization

Business Unit

Location

Total Purchase

25.2K ▲

vs prev=11.6K (+10%)

Total Payable Amount

25.2K ▲

vs prev=11.6K (+10%)

Overdue Payable

25.2K ▲

vs prev=11.6K (+10%)

Count/Volume vs Age

Payable at Par vs Discount

Department wise Outstanding amount

Top 5 Vendors by amount due

Upcoming Payments

Purchase/Account Payable vs Time

Expense type wise Outstanding amount

YTD Amount Paid

Average Age at Payment

Overdue Invoice Details

Vendor	Amount	Due Date
Tech and Software	13,622	June 23
Fashion and Apparel	9,545	May 23
Food and Beverage	7,064	Sept 23
Wellness	8,250	Oct 23

Upcoming Payment Details

Vendor	Amount	Due Date
Tech and Software	13,622	June 23
Fashion and Apparel	9,545	May 23
Food and Beverage	7,064	Sept 23
Wellness	8,250	Oct 23

Fiscal Year

Month

Organization

Business Unit

Location

Total Purchase

25.2K ▲

vs prev=11.6K (+10%)

Total Payable Amount

25.2K ▲

vs prev=11.6K (+10%)

Overdue Payable

25.2K ▲

vs prev=11.6K (+10%)

Count/Volume vs Age

Invoice Category breakdown

Top 5 Customer by amount due

Average Age at Payment

Upcoming Receivables

Sales/Accounts Receivable vs Time

Overdue Invoice Details

Invoice	Customer	Amount	Due Date
INV-001	Cust-001	$2,500	2023-02-15
INV-002	Cust-002	$3,800	2023-03-10
INV-003	Cust-003	$1,200	2023-04-5
INV-004	Cust-004	$5,000	2023-05-20

Upcoming Payment Details

Invoice	Customer	Amount	Due Date
INV-001	Cust-001	$2,500	2023-02-15
INV-002	Cust-002	$3,800	2023-03-10
INV-003	Cust-003	$1,200	2023-04-5
INV-004	Cust-004	$5,000	2023-05-20

Fiscal Year

Month

Organization

Business Unit

Location

Original Cost

50.6K

vs prev=25.2K (100%)

Purchase Value

20.4K

vs prev=10.2K (100%)

Book Value

2.4K

vs prev=1.6K (100%)

Fixed Assets

15.2K

vs prev=90 (100%)

Fixed Assets Balance Trend

Assets Turnover Ratio Trend

Fixed Assets Movements by Month

Fixed Assets by Category

Customers	Amount Due
Vendor1	4035
Vendor2	2222
Vendor3	1800
Vendor4	1700
Vendor4	1600

Fiscal Year

Month

Organization

Business Unit

Location

Quick Ratio

00.80

vs prev=0.40 (100%)

Current Ratio

2.00

vs prev=1.00 (100%)

Cash In

50K

vs prev=25K (100%)

Cash Out

50K

vs prev=25K (100%)

Current Ratio MOM Trend

Net Working Capital by Month

Quick Ratio MOM Trend

Assets vs Liabilities

Inventory Turnover Ratio MOM Trend

Fiscal Year

Month

Organization

Business Unit

Location

Title goes here

Category	Baseline	Comparison	Variance	%Variance
Assets	17827	235287	-56560	-24%
Current Assets	91614	67027	24587	37%
Cash	18334	24974	-6640	-27%
Inventory	54555	79274	-24719	-31%
-Liabilities	343994	257262	86732	34%
Current Liabilities	94629	25615	69014	269%
Payables	98444	69392	29052	42%
Provisions	81426	63065	18361	29%
Provisions	81426	63065	18361	29%
Loans	69495	99190	-29695	-30%
-Equity	234102	273861	-39759	-15%
Owner	87934	38697	49237	127%
Common	24167	64933	-40766	-63%
Preferred	79450	85659	-6209	-7%

Baseline vs Comparison

Budget Vs Actual

Fiscal Year

Month

Organization

Business Unit

Location

Income

▲17,587

Actual Income

39,515

Current Month

21,918

Previous Month

Income % of Budget

Expenses

▲17,041

Actual Expenses

31,890

Current Month

14,849

Previous Month

Expense % of Budget

Income Budget	Actual Income	Difference
760,464	672,630	87,834

Expense Budget	Actual Expense	Difference
542,890	455,212	87,678

Category	Budget	Actual	Difference	Avg % of Budget
Financial Aid	108,306	100,258	8,048	93%
Investment	108,306	92,232	16,224	85%
Loan	106,480	98,477	8,003	92%
Other Income	108,832	86,175	22,657	79%
Product A	110,977	98,803	12,174	89%

Category	Budget	Actual	Difference	Avg % of Budget
Advertising Expenses	109,712	98,074	11,638	93%
Other Expenses	108,306	76,844	32,145	71%
Rent	109,789	93,598	16,191	85%
Tax	108,007	97,969	10,038	91%
Transportation	106,393	88,727	17,666	83%

Financial Performance

Fiscal Year

Month

Organization

Business Unit

Location

Revenue

11.30M

Accounts Received

3.73

Accounts Payable

1.30

Equity Ratio

65.02

Current Ratio

2.77

Burn Rate

213.69

Days Sales Outstanding

Days Inventory Outstanding

Days Payable Outstanding

Profit and Loss Summary

Net Vs Gross Working Capital

AR Turnover Vs AP Turnover

Inventory

Accounts Payable by Payment Target

Expenses Breakdown

Invoice Due Details by Customer

Customer Name	Invoice Number	Due Date	Amount Due	Due Split
Hamilton Smith Ltd.	INV-0029	5/18/2023	550	Over 90
Hoyt Productions	Aug-23	3/24/2023	4.59	Over 90
Marine Systems	INV-0027	3/20/2023	396	Over 90
MCO Cleaning Services	5679	3/5/2023	87	Over 90
Net Connect	9781	3/11/2023	876	Over 90

Profit and Loss Summary

Transaction	Amount
Sales	2.07K
Total Income	2.07K
Cost of Sales
Purchases	775.98
Total Cost of Sales	775.98
Gross Profit	1,291.62
Operating Expenses
Gross Profit	1,291.62
Advertising	2,309.47
Bank Fees	2,656.00
Cleaning	2,180.00
Consulting & Accounting	989.00
Entertainment	3,768.00
Freight & Courier	1,453.00
General Expenses	768.00
Light Power, Heating	999.00
Motor Vehicle Expenses	878.00
Office Expenses	107.11
Printing & Stationery	789.00
Rent	1,091.22
Repairs and Maintenance	657.00
Total Operating Expenses	4,516.27
Net Profit	3,224.65

Executive Summary

Metrics	Current Month	Previous Month	Variance(%)
Cash received	519.4	11627.06	-100.00%
Cash spent	1592.6	11980.87	-86.70%
Cash surplus (deficit)	-1592.6	-353.81	-350.10%
Closing bank balance	1760.54	3353.14	-47.50%
Direct costs	775.98	4723.23	0.00%
Expenses	4516.27	56963.8	-49.60%
Gross profit (loss)	1291.62	8710.89	85.20%
Income	2067.6	8710.89	-76.30%
Other Income	1291.62	8710.89	42.90%
Pront (loss)	9-3224.65	252.91	-1179007
Balance Sheet
Creditors	8386.76	92223.1	277.30%
Debtors	59194.51	6946.33	32.40%
Net assets	3029.68	6254.33	-51.60%
Income
Average Value of Invoices	519.4	967.88	-46.60
Number of Invoice Issued	4	9	-55.60
Performance
Gross Profit Margin	62.50%	100%	-37.50%
Net Profit Margin	-156.00%	-2.90%	-5271.70%
Return on Investment(p.a)	-1277.20%	-48.50%	-2532.10%
Position
Average creditors days	47.541745	7.688268368	518.40%
Average debtore days	133.4084446	24.72034775	439.70%
Current assets to Habilities	0.867819529	1.520569342	-42.90%
Short term case forecast	807.75	4723.23	-82.90%
Term assets to liabilities	4516.27	6946.33	0.00%

Subscription

Organization

Business Unit

Location

Start Date

End Date

Avg. Customer Lifetime Value

96.99

Avg. Revenue per Subscriber

24.25

Customers

173

Total

127

Active

Subscriptions

191

Total

85

Active

Invoices

150

Total

61

Overdue

Churn Rate

Subscription Cancellation Rate

Monthly Recurring Revenue

Top 5 Customers by Monthly Recurring Revenue

Top 5 Customers by Revenue

Top 5 Companies by Monthly Recurring Revenue

Customer Account Status Breakdown

Payment Method Breakdown

Customer Subscription by Status

Subscriptions by Plan and Status

Accounts Receivable by Payment Target

Payments by Month

Transaction Count by Month and Type

Monthly Recurring Revenue Trend Analysis

Annual Run Rate Trend Analysis

Monthly Recurring Revenue Churn Rate

Customer Churn Rate Trend Analysis

Avg. Revenue per Account(ARPA)

Invoice Summary Details

Invoice ID	Invoice Date	Invoice Type	Invoice Amount	Invoice
inv_001	9/16/2023	Subscription	2.50	Success
inv_002	9/16/2023	One Time	50.88	Success
inv_003	12/20/2023	Subscription	30	Failed
inv_004	9/16/2023	Subscription	2.50	Success
inv_005	9/16/2023	One Time	50.88	Success
inv_006	12/20/2023	Subscription	30	Failed
inv_007	12/20/2023	Subscription	30	Failed