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 Emplo
The Great Company
1 New Street
Oldtown
Springfield

Date
###
###
###
###
###
###
###
Total hrs
Rate/Hour
Total Pay
Weekly Employee Timesheet
he Great Company Employee Name: Sylvia Foot
New Street Supervisor Name:
Week ending:

Regular [h Overtime [ Sick [h].m Vacation [ Unpaid [h] Other [h]. Total [h].mm
8.3 8.3
8.3 8.3
8.3 8.3
8.3 4.0 12.3
8.3 4.0 12.3
4.0 4.0
0.0
24.8 12.0 8.3 8.3 0.0 0.0 53.3
15.3 22.9 15.3 15.3 0.0 0.0
$ 377.44 $ 274.80 $ 125.81 $ 125.81 $ - $ - $ 903.86

Total Hours reported 53.25

Total Pay 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%
 Inventory List
Product ID Product Name Category Supplier
78-296 Dynamo Dinosaur Toys Global Goods Inc.
76-728 UltraClean Mop Household Apex Supply Co.
40-981 Forgotten Histories Books Horizon Enterprises
19-122 Echoes of Time Books Orion Distributors
16-497 EverBright Lamps Household Apex Supply Co.
91-462 Pirate Ship Adventure Toys Quantum Supplies
35-386 Urban Jacket Clothing PrimeSource Ltd.
68-111 The Last Enchantment Books Orion Distributors
88-936 Rocket Racer Toys Global Goods Inc.
20-980 Twilight Trousers Clothing PrimeSource Ltd.
68-837 Castle Build Kit Toys Quantum Supplies
57-224 QuickFix Toolkit Household Horizon Enterprises
12-512 War of Winds Books Orion Distributors
70-294 Starlight Scarf Clothing Quantum Supplies
93-258 Mysteries of the Mind Books Horizon Enterprises
61-510 Wizard's Chess Set Toys Global Goods Inc.
71-158 Harmony Vase Household Apex Supply Co.
64-710 The Secret Gateway Books Orion Distributors
69-738 SilverLine Curtains Household PrimeSource Ltd.
63-678 Sonic Earphones Electronics Quantum Supplies
Inventory List
Reorder Level Unit Price Units Sold Revenue Last Order Date
160 29.79 37 1102.23 2023-05-05
272 18.11 97 1756.67 2023-02-19
18 9.99 96 959.04 2023-10-22
53 9.99 29 289.71 2023-01-17
263 65.18 62 4041.16 2023-04-02
217 41.24 50 2062.00 2023-01-12
242 120.23 87 10460.01 2023-10-02
58 9.99 49 489.51 2023-12-19
46 79.65 51 4062.15 2023-07-25
156 58.05 29 1683.45 2023-07-07
108 98.96 78 7718.88 2023-12-08
69 50.42 90 4537.80 2023-07-15
61 9.99 81 809.19 2023-07-08
121 27.99 78 2183.22 2023-09-14
149 9.99 97 969.03 2023-09-14
63 29.04 28 813.12 2023-09-14
169 25.23 37 933.51 2023-05-05
140 9.99 80 799.20 2023-05-05
11 79.99 50 3999.50 2023-07-19
161 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
 Inventory List
Product ID Product Name Category Supplier
91-344 Knight's Battle Set Toys Global Goods Inc.
92-481 DustMaster Vacuum Household Apex Supply Co.
82-583 Secrets Unveiled Paper Goods Horizon Enterprises
61-314 AllFix Pro Set Household Horizon Enterprises
24-691 Speedster Car Toys Global Goods Inc.
58-439 VelvetDrape Panels Household PrimeSource Ltd.
73-824 Aurora Wrap Clothing Quantum Supplies
88-457 Treasure Island Quest Toys Quantum Supplies
32-849 Winds of Fate Paper Goods Orion Distributors
28-613 Metro Jacket Clothing PrimeSource Ltd.
77-294 Timeless Tales Paper Goods Horizon Enterprises
36-528 Fantasy Fortress Kit Toys Quantum Supplies
85-365 EchoBuds Electronics Quantum Supplies
53-176 Final Journey Paper Goods Orion Distributors
69-512 Whispers of History Paper Goods Orion Distributors
74-926 Ceramic Bloom Pot Household Apex Supply Co.
46-927 Evening Chinos Clothing PrimeSource Ltd.
67-239 Robo T-Rex Toys Global Goods Inc.
39-782 NightGlow Lanterns Household Apex Supply Co.
44-725 Hidden Pathways Paper Goods Orion Distributors
Inventory List
Reorder Level Unit Price Units Sold Revenue Last Order Date
90 22.13 24.00 531.12 2023-10-25
253 14.82 84.00 1244.88 2023-08-22
149 44.88 96.00 4308.48 2023-08-19
312 31.68 68.00 2154.24 2023-05-29
311 52.31 67.00 3504.77 2023-09-03
192 25.50 55.00 1402.50 2023-07-09
265 48.22 71.00 3423.62 2023-10-04
27 29.77 82.00 2441.14 2023-06-04
203 9.99 38.00 379.62 2023-11-01
298 12.49 91.00 1136.59 2023-06-28
79 9.99 25.00 249.75 2023-12-05
65 81.60 15.00 1224.00 2023-12-17
174 63.47 7.00 444.29 2023-03-18
116 9.99 12.00 119.88 2023-04-13
52 9.99 49.00 489.51 2023-02-23
87 72.39 29.00 2099.31 2023-01-12
134 88.33 33.00 2914.89 2023-09-15
238 76.45 59.00 4510.55 2023-01-31
41 99.99 43.00 4299.57 2023-11-14
158 9.99 77.00 769.23 2023-03-07