Show theme settings Shopping cart Download trialFree Trial
Segoe UI
Change Theme Settings
Change Theme Settings
Themes
 
Show All Themes
v
...v

Profit and Loss

H
AA
AD
AE
FO
V
X
C
FN
FF
FS
FG
FK
1
2
3
AF
B
FC
FC
AG
FA
AT
AM
AB
AL
AC
AR
5
6
W
M
FM
AH
AN
P
K
0
9
AI
I
D
O
AJ
U
FI
E
S
FD
AK
T
N
E
PI
T
F
P
K
C
N
Q
B
A
D
O
G
I
P
A
B
M
O
SZ
C
D
PG
PH
M
A
U
I
L
T
E
O
G
Q
C
X
B
J
A
A
SA
SD
T
C
Y3
B
V
R
A
C
T
D
D
W
A
B
C
D
VG
VH
E
G
H
F
JT
B
A
D
G
E
O
T
R
C
N
U
F
H
JP
B
AF
AE
JC
A
C
B
W
E
D
L
F
S
JA
A
B
C
D
E
F
G
H
JO
B
AF
AE
AN
A
F
I
B
E
V
C
L
H
DE
A
T
G
P
B
C
W
H
R
U
  • Undo

    Undo
    po
  • Clipboard

    Clipboard
    po
  • v
    v
    popopopo
    Font

    Font
    po
  • Alignment

    Alignment
    po
  • po
    dialogboxlauncherNumber

    Number
    po
  • Cells

    Cells
    po
  • Editing

    Editing
    po
  • Styles

    Styles
    po
  • dialogboxlauncherPage Setup

    Page Setuppo
  • dialogboxlauncherPrint

    Print
    po
  • Document Views

    Document Viewspo
  • Show

    Show
    po
  • View

    View
    po
  • Window

    Window
    po
  • Properties

    Properties
    po
  • Tools

    Tools
    po
  • Table Style Options

    Table Style Optionspo
  • Table Style Options

    Table Style Optionspo
  • Layout

    Layout
    po
  • PivotTable Style Options

    PivotTable Style Optionspo
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
AA
AB
AC
AD
AE
AF
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
Revenue
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
DEC
YTD
Sales
$50,000
$63,098
$55,125
$23,881
$60,775
$44,500
$50,000
$62,500
$44,850
$51,000
$53,250
$59,000
$617,979
Sales Returns (Reduction)
$0
($500)
$0
$0
($234)
$0
$0
$0
$0
$0
$0
$0
($734)
Sales Discounts (Reduction)
($5,000)
($5,250)
($5,513)
($5,788)
($6,078)
($5,250)
($5,200)
($5,500)
($5,750)
($5,800)
($5,000)
($4,856)
($64,985)
Other Revenue 1
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Other Revenue 2
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Other Revenue 3
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Net Sales
$45,000
$57,348
$49,612
$18,093
$54,463
$39,250
$44,800
$57,000
$39,100
$45,200
$48,250
$54,144
$552,260
Cost of Goods Sold
$20,000
$21,000
$22,050
$23,153
$24,310
$22,150
$20,000
$21,000
$22,050
$23,000
$20,500
$22,000
$261,213
Gross Profit
$25,000
$36,348
$27,562
($5,060)
$30,153
$17,100
$24,800
$36,000
$17,050
$22,200
$27,750
$32,144
$291,048
$114,500
2024
NET INCOME
DevAV
PROFIT AND LOSS STATEMENT
Operation Expenses
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
DEC
YTD
Salaries & Wages
$7,500
$7,875
$8,269
$8,682
$9,116
$8,500
$8,000
$8,500
$7,950
$9,000
$8,650
$7,950
$99,992
Depreciation
$500
$525
$551
$579
$608
$560
$500
$525
$550
$610
$580
$590
$6,678
Rent
$1,500
$1,575
$1,654
$1,736
$1,823
$1,620
$1,700
$1,750
$1,680
$1,820
$1,690
$1,725
$20,273
Office Supplies
$475
$499
$524
$550
$577
$525
$500
$499
$550
$525
$577
$475
$6,276
Utilities
$123
$123
$123
$123
$123
$123
$123
$123
$123
$123
$123
$123
$1,476
Telephone
$68
$68
$68
$68
$68
$68
$68
$68
$68
$68
$68
$68
$816
Insurance
$125
$125
$125
$125
$125
$125
$125
$125
$125
$125
$125
$125
$1,500
Travel
$250
$263
$276
$289
$304
$285
$250
$275
$285
$260
$270
$250
$3,256
Maintenance
$100
$105
$110
$116
$122
$105
$100
$110
$120
$115
$100
$110
$1,313
Advertising
$200
$210
$221
$232
$243
$250
$225
$210
$240
$235
$225
$200
$2,690
Other 1
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Other 2
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Other 3
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Total Operation Expenses
$10,841
$11,367
$11,920
$12,500
$13,109
$12,161
$11,591
$12,185
$11,691
$12,881
$12,408
$11,616
$144,270
Income From Operations
$14,159
$24,981
$15,642
($17,560)
$17,044
$4,939
$13,209
$23,815
$5,359
$9,319
$15,342
$20,528
$146,777
Did this demo address your needs?
If you’d like us to extend this demo further, please describe your needs below.
Thank you in advance for your cooperation.
SEND FEEDBACK


The DevExpress ASP.NET MVC Spreadsheet can load a wide variety of formatted Excel documents. The spreadsheet documents used in this demo section are based on popular Microsoft Excel templates that you can download from Microsoft's Templates for Excel page.

In this demo, the Spreadsheet programmatically opens an XLSX document representing a profit and loss statement. This demo tracks company income and expenses. You can view how expenses compare against gross profits in the line chart. Change revenue and expense amounts, and notice that the totals are recalculated automatically. The chart is updated as well.

Collapse/Expand
Local Copy of this Demo
To inspect the source code for this demo on your machine, you must first install our components via the DevExpress Component Installer.
You can open a local copy of this online demo directly from this webpage (if using v20.2.8, 21.1.4 or higher).
Open CS Solution
The source code files for this demo are installed (by default) in the following directory:
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\CS\MVCxSpreadsheetDemos