| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Savings Budget Audit | ||||||||||
2 | |||||||||||
3 | |||||||||||
4 | Report Start | 1/1/2021 | Earliest Date: | 12/1/2020 | |||||||
5 | Report End | 4/5/2021 | Latest Date: | 11/24/2025 | Median Error: | #DIV/0! | |||||
6 | Balances Offset (days) | -1 | Max Range: | 365 days | |||||||
7 | |||||||||||
8 | |||||||||||
9 | |||||||||||
10 | |||||||||||
11 | |||||||||||
12 | |||||||||||
13 | |||||||||||
14 | |||||||||||
15 | |||||||||||
16 | |||||||||||
17 | |||||||||||
18 | |||||||||||
19 | |||||||||||
20 | |||||||||||
21 | |||||||||||
22 | |||||||||||
23 | |||||||||||
24 | |||||||||||
25 | Date | Account Balances | Budget Actuals | Error | % Error | ||||||
26 | 1-Jan-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
27 | 2-Jan-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
28 | 3-Jan-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
29 | 4-Jan-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
30 | 5-Jan-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
31 | 6-Jan-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
32 | 7-Jan-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
33 | 8-Jan-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
34 | 9-Jan-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
35 | 10-Jan-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
36 | 11-Jan-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
37 | 12-Jan-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
38 | 13-Jan-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
39 | 14-Jan-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
40 | 15-Jan-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
41 | 16-Jan-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
42 | 17-Jan-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
43 | 18-Jan-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
44 | 19-Jan-21 | $0 | $14,136 | -$14,136 | #DIV/0! | Accounts to Include | |||||
45 | 20-Jan-21 | $0 | $14,136 | -$14,136 | #DIV/0! | Umb Financial Corporation Loan - xxxx1207 (5B74) | |||||
46 | 21-Jan-21 | $0 | $14,136 | -$14,136 | #DIV/0! | E-Trade Savings - xxxx4580 (F5B7) | |||||
47 | 22-Jan-21 | $0 | $14,136 | -$14,136 | #DIV/0! | Cibc Bank Usa Investments - xxxx4165 (8931) | |||||
48 | 23-Jan-21 | $0 | $14,136 | -$14,136 | #DIV/0! | Td Bank, N.A. Savings - xxxx1683 (BCB5) | |||||
49 | 24-Jan-21 | $0 | $14,136 | -$14,136 | #DIV/0! | Cadence Bank Money Market - xxxx2284 (D951) | |||||
50 | 25-Jan-21 | $0 | $14,136 | -$14,136 | #DIV/0! | Cadence Bank Investments - xxxx2255 (5591) | |||||
51 | 26-Jan-21 | $0 | $14,136 | -$14,136 | #DIV/0! | Prosperity Bancshares Checking - xxxx1197 (CAC6) | |||||
52 | 27-Jan-21 | $0 | $14,136 | -$14,136 | #DIV/0! | Synchrony Financial Savings - xxxx7405 (1804) | |||||
53 | 28-Jan-21 | $0 | $14,136 | -$14,136 | #DIV/0! | Macy'S Investments - xxxx0732 (948F) | |||||
54 | 29-Jan-21 | $0 | $14,136 | -$14,136 | #DIV/0! | Citizens Financial Group Checking - xxxx0293 (2268) | |||||
55 | 30-Jan-21 | $0 | $14,136 | -$14,136 | #DIV/0! | Td Bank, N.A. Investments - xxxx6588 (F35A) | |||||
56 | 31-Jan-21 | $0 | $14,136 | -$14,136 | #DIV/0! | Cathay Bank Loan - xxxx4278 (3AB0) | |||||
57 | 1-Feb-21 | $0 | $14,136 | -$14,136 | #DIV/0! | Atlantic Union Bank Investments - xxxx9322 (11C9) | |||||
58 | 2-Feb-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
59 | 3-Feb-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
60 | 4-Feb-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
61 | 5-Feb-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
62 | 6-Feb-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
63 | 7-Feb-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
64 | 8-Feb-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
65 | 9-Feb-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
66 | 10-Feb-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
67 | 11-Feb-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
68 | 12-Feb-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
69 | 13-Feb-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
70 | 14-Feb-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
71 | 15-Feb-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
72 | 16-Feb-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
73 | 17-Feb-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
74 | 18-Feb-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
75 | 19-Feb-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
76 | 20-Feb-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
77 | 21-Feb-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
78 | 22-Feb-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
79 | 23-Feb-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
80 | 24-Feb-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
81 | 25-Feb-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
82 | 26-Feb-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
83 | 27-Feb-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
84 | 28-Feb-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
85 | 1-Mar-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
86 | 2-Mar-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
87 | 3-Mar-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
88 | 4-Mar-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
89 | 5-Mar-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
90 | 6-Mar-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
91 | 7-Mar-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
92 | 8-Mar-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
93 | 9-Mar-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
94 | 10-Mar-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
95 | 11-Mar-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
96 | 12-Mar-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
97 | 13-Mar-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
98 | 14-Mar-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
99 | 15-Mar-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||
100 | 16-Mar-21 | $0 | $14,136 | -$14,136 | #DIV/0! | ||||||