Spreadsheet: 866912d1713820383-datedif-being-inconsistent-datedif-test
Sheet: <.2> 13010 Asset Register

Company |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Amount | Balance
Entity 1
 | Total Book Cost | Total Accumulated Depreciation
Leasehold Improvements
 |  |  |  | GL Account |  |  |  | GL Account
 |  |  |  | 13010 |  |  |  | 13099
Items | Date in Service | Book Period (Years) | Date Fully Expensed | Book Cost | Monthly Depreciation | Annual Depreciation | Remaining Balance | Accumulated Depreciation | Check
1 | 2023-10-31 00:00:00 | 7 |  | 19139.06
2 | 2023-09-12 00:00:00 | 7 |  | 67954.41
3 | 2023-08-01 00:00:00 | 7 |  | 10844.26
4 | 2023-06-11 00:00:00 | 7 |  | -45251.8
5 | 2023-06-09 00:00:00 | 7 |  | -47500
6 | 2023-04-25 00:00:00 | 7 |  | 22500
7 | 2023-04-21 00:00:00 | 7 |  | 3016.25
8 | 2023-03-15 00:00:00 | 7 |  | 22500
9 | 2023-02-07 00:00:00 | 7 |  | 115581.71
10 | 2022-12-16 00:00:00 | 7 |  | 286163.41
11 | 2022-09-21 00:00:00 | 7 |  | -16908.63
12 | 2022-08-02 00:00:00 | 7 |  | 4060.88
13 | 2022-08-02 00:00:00 | 7 |  | 40608.75
14 | 2022-08-01 00:00:00 | 7 |  | 810
15 | 2022-08-01 00:00:00 | 7 |  | 818.23
16 | 2022-08-01 00:00:00 | 7 |  | 1067.27
17 | 2022-08-01 00:00:00 | 7 |  | 1205.11
18 | 2022-08-01 00:00:00 | 7 |  | 5100
19 | 2022-07-18 00:00:00 | 7 |  | 16850
20 | 2022-07-12 00:00:00 | 5 |  | 55000
21 | 2022-07-07 00:00:00 | 7 |  | 22808.26
22 | 2022-07-01 00:00:00 | 7 |  | 130
23 | 2022-07-01 00:00:00 | 7 |  | 130
24 | 2022-07-01 00:00:00 | 7 |  | 130
25 | 2022-07-01 00:00:00 | 7 |  | 385.61
26 | 2022-07-01 00:00:00 | 7 |  | 428.51
27 | 2022-07-01 00:00:00 | 7 |  | 1700
28 | 2022-05-04 00:00:00 | 7 |  | 125
29 | 2022-05-04 00:00:00 | 7 |  | 1750.25
30 | 2022-05-04 00:00:00 | 7 |  | 7661.35
31 | 2022-04-30 00:00:00 | 7 |  | 2464.8
32 | 2022-04-20 00:00:00 | 7 |  | 744.08
33 | 2022-04-20 00:00:00 | 7 |  | 7440.75
34 | 2022-04-06 00:00:00 | 7 |  | 16586.21
35 | 2022-04-01 00:00:00 | 7 |  | 4229.88
36 | 2022-03-31 00:00:00 | 7 |  | 19306.5
37 | 2022-03-31 00:00:00 | 7 |  | 22752.25
38 | 2022-03-31 00:00:00 | 7 |  | 31500
39 | 2022-03-20 00:00:00 | 7 |  | 569
40 | 2022-03-20 00:00:00 | 7 |  | 5690
41 | 2022-03-15 00:00:00 | 7 |  | 14972.95
42 | 2022-03-13 00:00:00 | 7 |  | 350
43 | 2022-03-13 00:00:00 | 7 |  | 3500
44 | 2022-03-06 00:00:00 | 7 |  | 350
45 | 2022-03-06 00:00:00 | 7 |  | 3500
46 | 2022-03-01 00:00:00 | 7 |  | 24648
47 | 2022-02-28 00:00:00 | 7 |  | 260
48 | 2022-02-28 00:00:00 | 7 |  | 500
49 | 2022-02-28 00:00:00 | 7 |  | 805
50 | 2022-02-28 00:00:00 | 7 |  | 1225
51 | 2022-02-28 00:00:00 | 7 |  | 1540
52 | 2022-02-28 00:00:00 | 7 |  | 2600
53 | 2022-02-28 00:00:00 | 7 |  | 2625
54 | 2022-02-22 00:00:00 | 7 |  | 555.06
55 | 2022-02-17 00:00:00 | 7 |  | 2500
56 | 2022-02-17 00:00:00 | 7 |  | 3117.7
57 | 2022-02-17 00:00:00 | 7 |  | 4068.11
58 | 2022-02-17 00:00:00 | 7 |  | 5491.46
59 | 2022-02-17 00:00:00 | 7 |  | 8148
60 | 2022-02-17 00:00:00 | 7 |  | 9704.43
61 | 2022-02-17 00:00:00 | 7 |  | 10500
62 | 2022-02-17 00:00:00 | 7 |  | 11724.56
63 | 2022-02-17 00:00:00 | 7 |  | 11787.12
64 | 2022-02-17 00:00:00 | 7 |  | 14100.45
65 | 2022-02-17 00:00:00 | 7 |  | 23401.62
66 | 2022-02-16 00:00:00 | 7 |  | -2500
67 | 2022-02-14 00:00:00 | 7 |  | 24648
68 | 2022-02-08 00:00:00 | 7 |  | 200
69 | 2022-02-08 00:00:00 | 7 |  | 650
70 | 2022-02-08 00:00:00 | 7 |  | 925
71 | 2022-02-08 00:00:00 | 7 |  | 1000
72 | 2022-02-08 00:00:00 | 7 |  | 2400
73 | 2022-01-04 00:00:00 | 7 |  | 1100
74 | 2022-01-04 00:00:00 | 7 |  | 1350
75 | 2022-01-04 00:00:00 | 7 |  | 2096.7
76 | 2022-01-04 00:00:00 | 7 |  | 5917
77 | 2022-01-04 00:00:00 | 7 |  | 6250
78 | 2022-01-04 00:00:00 | 7 |  | 8050
79 | 2022-01-04 00:00:00 | 7 |  | 10710
80 | 2022-01-01 00:00:00 | 7 |  | 9500
81 | 2021-12-28 00:00:00 | 7 |  | 7580.25
82 | 2021-12-27 00:00:00 | 7 |  | 78.43
83 | 2021-12-20 00:00:00 | 7 |  | -6534
84 | 2021-12-12 00:00:00 | 7 |  | 3500
85 | 2021-12-12 00:00:00 | 7 |  | 3500
86 | 2021-11-22 00:00:00 | 7 |  | 7440
87 | 2021-11-17 00:00:00 | 5 |  | 89263.86
88 | 2021-11-11 00:00:00 | 7 |  | 707.7
89 | 2021-11-11 00:00:00 | 7 |  | 7077
90 | 2021-11-10 00:00:00 | 7 |  | 316.5
91 | 2021-11-10 00:00:00 | 7 |  | 3165
92 | 2021-11-10 00:00:00 | 7 |  | 16184.7
93 | 2021-11-03 00:00:00 | 7 |  | 1245.4
94 | 2021-11-03 00:00:00 | 7 |  | 12454
95 | 2021-10-24 00:00:00 | 7 |  | 350
96 | 2021-10-24 00:00:00 | 7 |  | 3500
97 | 2021-10-19 00:00:00 | 7 |  | 350
98 | 2021-10-19 00:00:00 | 7 |  | 3500
99 | 2021-10-18 00:00:00 | 7 |  | 1092.1
100 | 2021-10-18 00:00:00 | 7 |  | 10920.98
101 | 2021-10-14 00:00:00 | 7 |  | 1500
102 | 2021-10-11 00:00:00 | 7 |  | 50375.85
103 | 2021-10-03 00:00:00 | 7 |  | 350
104 | 2021-10-03 00:00:00 | 7 |  | 3500
105 | 2021-07-21 00:00:00 | 7 |  | 12150.88658083061
106 | 2021-05-01 00:00:00 | 5 |  | 138600
107 | 2021-05-01 00:00:00 | 5 |  | 128250
108 | 2021-05-01 00:00:00 | 5 |  | 94950
109 | 2021-05-01 00:00:00 | 5 |  | 87750
110 | 2021-05-01 00:00:00 | 5 |  | 77130
111 | 2021-05-01 00:00:00 | 5 |  | 75150
112 | 2021-05-01 00:00:00 | 5 |  | 71190
113 | 2021-05-01 00:00:00 | 5 |  | 69300
114 | 2021-05-01 00:00:00 | 5 |  | 61740
115 | 2021-05-01 00:00:00 | 5 |  | 57780
116 | 2021-05-01 00:00:00 | 5 |  | 55440
117 | 2021-05-01 00:00:00 | 5 |  | 50400
118 | 2021-05-01 00:00:00 | 5 |  | 46800
119 | 2021-05-01 00:00:00 | 5 |  | 46800
120 | 2021-05-01 00:00:00 | 5 |  | 46800
121 | 2021-05-01 00:00:00 | 5 |  | 42120
122 | 2021-05-01 00:00:00 | 5 |  | 41580
123 | 2021-05-01 00:00:00 | 5 |  | 40410
124 | 2021-05-01 00:00:00 | 5 |  | 37980
125 | 2021-05-01 00:00:00 | 5 |  | 35640
126 | 2021-05-01 00:00:00 | 5 |  | 35640
127 | 2021-05-01 00:00:00 | 5 |  | 35280
128 | 2021-05-01 00:00:00 | 5 |  | 35100
129 | 2021-05-01 00:00:00 | 5 |  | 34680
130 | 2021-05-01 00:00:00 | 5 |  | 34380
131 | 2021-05-01 00:00:00 | 5 |  | 34380
132 | 2021-05-01 00:00:00 | 5 |  | 32400
133 | 2021-05-01 00:00:00 | 5 |  | 30200
134 | 2021-05-01 00:00:00 | 5 |  | 29700
135 | 2021-05-01 00:00:00 | 5 |  | 29250
136 | 2021-05-01 00:00:00 | 5 |  | 28440
137 | 2021-05-01 00:00:00 | 5 |  | 28440
138 | 2021-05-01 00:00:00 | 6 |  | 35000
 |  |  | Total