Personal Finance Tracker
Monthly Summary
Month Income Expenses Fixed Costs
$ 5,185.00 $ 1,500.45 $ 1,255.48
$ 3,528.00 $ 1,756.85 $ 1,255.48
$ 3,587.00 $ 1,945.23 $ 1,255.48
$ 3,865.00 $ 1,800.64 $ 1,255.48
$ 3,746.00 $ 1,840.62 $ 1,255.48
$ 4,254.00 $ 1,921.10 $ 1,255.48
$ 3,468.00 $ 1,874.16 $ 1,255.48
$ 3,215.00 $ 1,564.29 $ 1,255.48
$ 2,421.00 $ 1,743.50 $ 1,255.48
$ 4,045.00 $ 1,304.28 $ 1,255.48
$ 2,350.00 $ 1,703.82 $ 1,255.48
$ 5,205.00 $ 1,353.57 $ 1,255.48
Total $ 44,869.00 $ 20,308.51 $ 15,065.76
December Expenses
Savings Date Expense
### Groceries, Seven-eleve
### TV, TV Warehouse
$386.29 Groceries, Spar
$808.88 Clothes, Tesco
$649.90 Shelves, Walmart
### Groceries, Spar
$338.36 Groceries, Tesco
$395.23 Take-out, Pizza Hut
### Groceries, Seven-eleven
### Groceries, Seven-eleven
### Clothes, Next
### Groceries, Tesco
### Total
Type Store Total
Groceries Seven-Eleven $ 3.32
$ 599.00
$ 9.75
$ 42.50
$ 87.99
$ 42.25
$ 200.66
$ 37.50
ven-eleven $ 8.75
ven-eleven $ 4.85
$ 132.85
$ 184.15
$ 1,353.57
Weekly Employee Timesheet
The Great Company Employee Name: Sylvia Foot
1 New Street Supervisor Name:
Oldtown Week ending:
Springfield
Date Regular [h Overtime [ Sick [h].m Vacation [ Unpaid [h] Other [h].
9/16/2024 8.3
9/17/2024 8.3
9/18/2024 8.3
9/19/2024 8.3 4.0
9/20/2024 8.3 4.0
9/21/2024 4.0
9/22/2024
Total hrs 24.8 12.0 8.3 8.3 0.0 0.0
Rate/Hour 15.3 22.9 15.3 15.3 0.0 0.0
Total Pay $ 377.44 $ 274.80 $ 125.81 $ 125.81 $ - $ -
Total Hours reported 53.25
Total Pay 903.86
Total [h].mm
8.3
8.3
8.3
12.3
12.3
4.0
0.0
53.3
$ 903.86
Weekly Sales Report
Department: FURNITURE
Product ID Description Quantity
795.090.003 Eloise Sofa 2
102.392.808 Bridger Nightstand 12
903.889.782 Agatha Armchair 6
805.050.209 Varley Table 4
904.372.383 Brimsley TV Bench 8
205.100.052 Mondrich Shelf Unit 16
705.067.467 Fife Desk 7
Totals 55
***Sales Tax 6.59%
Weekly Sales Report by Depart
Day Furniture Beds/Mattresses
Monday $ 950.62 $ 1,905.35
Tuesday $ 2,013.41 $ 2,879.24
Wednesday $ 2,322.51 $ 3,183.76
Thursday $ 1,001.88 $ 1,264.89
Friday $ 2,748.86 $ 2,942.13
Saturday $ 2,834.12 $ 3,287.52
Sunday $ 1,822.59 $ 1,564.21
Totals $ 13,693.99 $ 17,027.10
Average Daily Sales
Max. Daily Sales
Min. Daily Sales
Average Max/Min
ly Sales Report
Week ending: 09/15/24
Price per Unit Sales Tax Totals
$ 949.00
$ 79.99
$ 549.99
$ 289.99
$ 399.99
$ 79.99
$ 149.99
Report by Department
Kitchenware Home Decor Totals
$ 1,542.15 $ 3,523.46 $ 7,921.58
$ 1,862.38 $ 3,462.80 $ 10,217.83
$ 1,943.20 $ 4,850.63 $ 12,300.10
$ 864.52 $ 2,546.23 $ 5,677.52
$ 2,103.78 $ 4,527.12 $ 12,321.89
$ 2,912.56 $ 5,213.62 $ 14,247.82
$ 1,423.89 $ 3,251.92 $ 8,062.61
$ 12,652.48 $ 27,375.78
Employee Sales Report
Year 2023
Employee name Sales (Q1) Sales (Q2) Sales (Q3)
Steven 21417 20191 17734
Jim 17292 27645 24881
Melissa 19996 18470 26628
Cecilia 26885 22115 18664
Tania 23146 27872 19008
Michelle 22736 27696 23277
Katherine 21577 17516 16320
Sub total $ 153,049.00 $ 161,505.00 $ 146,512.00
Employee Performance Repo
Employee Name Target Met Work Quality Productivity
Steven 60 75
Jim 90 95
Melissa 95 95
Cecilia 95 85
Tania 85 80
Michelle 95 100
Katherine 65 95
Employee Bonus Report
Employee Name Target Work Quality Productivity
Steven
Jim
Melissa
Cecilia
Tania
Michelle
Katherine
Totals allowed 20% 20% 20%
Sales Report
Sales (Q4) Year Total Target
15547 74889 $ 83,400.00
19993 89811 $ 86,400.00
17621 82715 $ 83,400.00
21122 88786 $ 86,400.00
19811 89837 $ 86,400.00
27038 100747 $ 95,800.00
26599 82012 $ 83,400.00
$ 147,731.00 $ 608,797.00 $ 605,200.00
formance Report
Knowledge Average High Performance
75 70
85 90
100 97
90 90
95 87
95 97
70 77
Bonus Report
Knowledge High Performance Bonus eligible
0%
0%
0%
0%
0%
0%
0%
20% 20% 100%
Product ID
78-296
76-728
40-981
19-122
16-497
91-462
35-386
68-111
88-936
20-980
68-837
57-224
12-512
70-294
93-258
61-510
71-158
64-710
69-738
63-678
Inventory List
Product Name Category Supplier Reorder Level
Dynamo Dinosaur Toys Global Goods Inc. 160
UltraClean Mop Household Apex Supply Co. 272
Forgotten Histories Books Horizon Enterprises 18
Echoes of Time Books Orion Distributors 53
EverBright Lamps Household Apex Supply Co. 263
Pirate Ship Adventure Toys Quantum Supplies 217
Urban Jacket Clothing PrimeSource Ltd. 242
The Last Enchantment Books Orion Distributors 58
Rocket Racer Toys Global Goods Inc. 46
Twilight Trousers Clothing PrimeSource Ltd. 156
Castle Build Kit Toys Quantum Supplies 108
QuickFix Toolkit Household Horizon Enterprises 69
War of Winds Books Orion Distributors 61
Starlight Scarf Clothing Quantum Supplies 121
Mysteries of the Mind Books Horizon Enterprises 149
Wizard's Chess Set Toys Global Goods Inc. 63
Harmony Vase Household Apex Supply Co. 169
The Secret Gateway Books Orion Distributors 140
SilverLine Curtains Household PrimeSource Ltd. 11
Sonic Earphones Electronics Quantum Supplies 161
List
Unit Price Units Sold Revenue Last Order Date
29.79 37 1102.23 2023-05-05
18.11 97 1756.67 2023-02-19
9.99 96 959.04 2023-10-22
9.99 29 289.71 2023-01-17
65.18 62 4041.16 2023-04-02
41.24 50 2062.00 2023-01-12
120.23 87 10460.01 2023-10-02
9.99 49 489.51 2023-12-19
79.65 51 4062.15 2023-07-25
58.05 29 1683.45 2023-07-07
98.96 78 7718.88 2023-12-08
50.42 90 4537.80 2023-07-15
9.99 81 809.19 2023-07-08
27.99 78 2183.22 2023-09-14
9.99 97 969.03 2023-09-14
29.04 28 813.12 2023-09-14
25.23 37 933.51 2023-05-05
9.99 80 799.20 2023-05-05
79.99 50 3999.50 2023-07-19
54.15 4 216.60 2023-06-24
Annual Accounts
Month Income Expenses
January $ 5,185.00 $ 1,500.45
February $ 3,528.00 $ 1,756.85
March $ 3,587.00 $ 1,945.23
April $ 3,865.00 $ 1,800.64
May $ 3,746.00 $ 1,840.62
June $ 4,254.00 $ 1,921.10
July $ 3,468.00 $ 1,874.16
August $ 3,215.00 $ 1,564.29
September $ 2,421.00 $ 1,743.50
October $ 4,045.00 $ 1,304.28
November $ 2,350.00 $ 1,703.82
December $ 5,205.00 $ 1,353.57
Sub total $ 44,869.00 $ 20,308.51
ccounts
Fixed Costs Savings
$ 1,255.48 $ 2,429.07
$ 1,255.48 $ 515.67
$ 1,255.48 $ 386.29
$ 1,255.48 $ 808.88
$ 1,255.48 $ 649.90
$ 1,255.48 $ 1,077.42
$ 1,255.48 $ 338.36
$ 1,255.48 $ 395.23
$ 1,255.48 $ -577.98
$ 1,255.48 $ 1,485.24
$ 1,255.48 $ -609.30
$ 1,255.48 $ 2,595.95
$ 15,065.76 $ 9,494.73
Product ID
91-344
92-481
82-583
61-314
24-691
58-439
73-824
88-457
32-849
28-613
77-294
36-528
85-365
53-176
69-512
74-926
46-927
67-239
39-782
44-725
Inventory List
Product Name Category Supplier Reorder Level
Knight's Battle Set Toys Global Goods Inc. 90
DustMaster Vacuum Household Apex Supply Co. 253
Secrets Unveiled Paper Goods Horizon Enterprises 149
AllFix Pro Set Household Horizon Enterprises 312
Speedster Car Toys Global Goods Inc. 311
VelvetDrape Panels Household PrimeSource Ltd. 192
Aurora Wrap Clothing Quantum Supplies 265
Treasure Island Quest Toys Quantum Supplies 27
Winds of Fate Paper Goods Orion Distributors 203
Metro Jacket Clothing PrimeSource Ltd. 298
Timeless Tales Paper Goods Horizon Enterprises 79
Fantasy Fortress Kit Toys Quantum Supplies 65
EchoBuds Electronics Quantum Supplies 174
Final Journey Paper Goods Orion Distributors 116
Whispers of History Paper Goods Orion Distributors 52
Ceramic Bloom Pot Household Apex Supply Co. 87
Evening Chinos Clothing PrimeSource Ltd. 134
Robo T-Rex Toys Global Goods Inc. 238
NightGlow Lanterns Household Apex Supply Co. 41
Hidden Pathways Paper Goods Orion Distributors 158
List
Unit Price Units Sold Revenue Last Order Date
22.13 24.00 531.12 2023-10-25
14.82 84.00 1244.88 2023-08-22
44.88 96.00 4308.48 2023-08-19
31.68 68.00 2154.24 2023-05-29
52.31 67.00 3504.77 2023-09-03
25.50 55.00 1402.50 2023-07-09
48.22 71.00 3423.62 2023-10-04
29.77 82.00 2441.14 2023-06-04
9.99 38.00 379.62 2023-11-01
12.49 91.00 1136.59 2023-06-28
9.99 25.00 249.75 2023-12-05
81.60 15.00 1224.00 2023-12-17
63.47 7.00 444.29 2023-03-18
9.99 12.00 119.88 2023-04-13
9.99 49.00 489.51 2023-02-23
72.39 29.00 2099.31 2023-01-12
88.33 33.00 2914.89 2023-09-15
76.45 59.00 4510.55 2023-01-31
99.99 43.00 4299.57 2023-11-14
9.99 77.00 769.23 2023-03-07
