Spreadsheet: 705581d1606205665-employee-monthly-salary-increased-on-their-anniversary-date-accounting
Sheet: 2020 Actuals (Detailed)

Anchore
Transaction [NAME] by  Account
January - September, 2020
 | Date | Transaction Type | Num | Name | Class | Memo/Description | Split | Amount | Balance
7000 Operations - Summary
7300 Accounting/Finance - Summary
7301 Payroll - Accounting/Finance
 | 06/30/2020 | Journal Entry | True Up Wage Exp. |  |  | True up expenses due to department reclassification | -Split- | 662.88 | 662.88
 | 06/30/2020 | Journal Entry | 0630 payroll |  |  |  | -Split- | 7291.67 | 7954.55
 | 07/31/2020 | Journal Entry | Payroll July 2020 |  |  |  | -Split- | 14583.34 | 22537.89
 | 08/31/2020 | Journal Entry | Payroll August 2020 |  |  |  | -Split- | 18125.01 | 40662.9
 | 09/30/2020 | Journal Entry | 9/30/20 Payroll Entry |  |  |  | -Split- | 21666.68 | 62329.58
Total for 7301 Payroll - Accounting/Finance |  |  |  |  |  |  |  | 62329.58
7302 Payroll Tax -Accounting/Finance
 | 06/30/2020 | Journal Entry | clear 1190 |  |  |  | -Split- | -126.95 | -126.95
 | 06/30/2020 | Journal Entry | 0630 payroll |  |  |  | -Split- | 817.63 | 690.68
 | 06/30/2020 | Journal Entry | True Up Wage Exp. |  |  | True up expenses due to department reclassification | -Split- | 77.89 | 768.57
 | 07/31/2020 | Journal Entry | Payroll July 2020 |  |  |  | -Split- | 1115.63 | 1884.2
 | 08/31/2020 | Journal Entry | Payroll August 2020 |  |  |  | -Split- | 1567.19 | 3451.39
 | 09/30/2020 | Journal Entry | 9/30/20 Payroll Entry |  |  |  | -Split- | 1997.01 | 5448.4
Total for 7302 Payroll Tax -Accounting/Finance |  |  |  |  |  |  |  | 5448.4
7303 Payroll Tax - R&D Credit - Accounting/Finance
 | 02/29/2020 | Journal Entry | 3 |  |  |  | -Split- | -37391.86 | -37391.86
 | 05/15/2020 | Journal Entry | payroll 051520 |  |  |  | -Split- | -34232.18 | -71624.04
 | 05/31/2020 | Journal Entry | payroll 053120 |  |  |  | -Split- | 0 | -71624.04
 | 06/15/2020 | Journal Entry | 0615 payroll |  |  |  | -Split- | 0 | -71624.04
 | 06/30/2020 | Journal Entry | 0630 payroll |  |  |  | -Split- | 0 | -71624.04
 | 07/31/2020 | Journal Entry | Payroll July 2020 |  |  |  | -Split- | 0 | -71624.04
Total for 7303 Payroll Tax - R&D Credit - Accounting/Finance |  |  |  |  |  |  |  | -71624.04
7304 Employer Paid Benefits - Accounting/Finance
 | 07/31/2020 | Journal Entry | True Up Wage Exp. |  |  | True up expenses due to department reclassification | -Split- | 919 | 919
 | 08/31/2020 | Journal Entry | True Up Wage Exp. |  |  | True up expenses due to department reclassification | -Split- | 1586.84 | 2505.84
 | 09/30/2020 | Journal Entry | 9/30/20 Payroll Entry |  |  |  | -Split- | 2283.42 | 4789.26
Total for 7304 Employer Paid Benefits - Accounting/Finance |  |  |  |  |  |  |  | 4789.26
7305 Accounting Fees - Accounting/Finance
 | 01/31/2020 | Journal Entry | 2 |  |  |  | -Split- | 12656 | 12656
 | 03/31/2020 | Journal Entry | 4 |  |  |  | -Split- | 4851 | 17507
 | 04/06/2020 | [NAME] | 1252 dated 3/31/20 | Gibraltar CFO Services | Finance | -Financial Services | 2000 Accounts Payable | 4095 | 21602
 | 04/06/2020 | [NAME] | March 2020 | Nasif, Hicks, Harris & Co., LLP | Operations | - | 2000 Accounts Payable | 12475 | 34077
 | 04/19/2020 | Expense | 60765516NR | Credit Card Misc. |  | XERO INC XERO INC SAN FRANCISCO CA | 2001 Credit Card - Amex | 0 | 34077
 | 04/30/2020 | [NAME] | April 2020 | Nasif, Hicks, Harris & Co., LLP | Operations | - | 2000 Accounts Payable | 6467 | 40544
 | 04/30/2020 | [NAME] | 1268 | Gibraltar CFO Services | Finance | -Financial Services | 2000 Accounts Payable | 1560 | 42104
 | 05/31/2020 | [NAME] | May 31, 2020 | Nasif, Hicks, Harris & Co., LLP | Operations | - | 2000 Accounts Payable | 3753 | 45857
 | 05/31/2020 | [NAME] | 1287 | Gibraltar CFO Services | Finance | -Financial Services | 2000 Accounts Payable | 2598.89 | 48455.89
 | 06/30/2020 | [NAME] | 1 | Clean SOX, Inc. |  |  | 2000 Accounts Payable | 11200 | 59655.89
 | 06/30/2020 | [NAME] | 1304 | Gibraltar CFO Services | Finance | -Financial Services | 2000 Accounts Payable | 5070 | 64725.89
 | 06/30/2020 | [NAME] | NHH062020 | Nasif, Hicks, Harris & Co., LLP |  | Accounting Services | 2000 Accounts Payable | 7986 | 72711.89
 | 07/31/2020 | [NAME] | 2 | Clean SOX, Inc. |  | accounting and finance consulting for July 2020 | 2000 Accounts Payable | 11800 | 84511.89
 | 07/31/2020 | [NAME] | 7312020 | Nasif, Hicks, Harris & Co., LLP |  | Accounting Services | 2000 Accounts Payable | 8709 | 93220.89
 | 07/31/2020 | [NAME] | 1321 | Gibraltar CFO Services | Finance | -Financial Services | 2000 Accounts Payable | 2925 | 96145.89
 | 08/26/2020 | [NAME] | 3 | Clean SOX, Inc. |  | Accounting and Finance Consulting for August 2020 | 2000 Accounts Payable | 5000 | 101145.89
 | 08/31/2020 | Journal Entry | [NAME] |  |  |  | -Split- | 6500 | 107645.89
 | 09/01/2020 | Journal Entry | [NAME] |  |  |  | -Split- | -6500 | 101145.89
 | 09/17/2020 | [NAME] | August 2020 | Nasif, Hicks, Harris & Co., LLP |  | Accounting Services | 2000 Accounts Payable | 3657 | 104802.89
 | 09/30/2020 | Journal Entry | 9/30/20 Accrued Exp |  |  | NHH | -Split- | 665 | 105467.89
Total for 7305 Accounting Fees - Accounting/Finance |  |  |  |  |  |  |  | 105467.89
7306 Bank Charges & Fees - Accounting/Finance
 | 01/31/2020 | Journal Entry | 2 |  |  |  | -Split- | 199 | 199
 | 01/31/2020 | Journal Entry | 2 |  |  |  | -Split- | 199.89 | 398.89
 | 02/29/2020 | Journal Entry | 3 |  |  |  | -Split- | 199 | 597.89
 | 03/31/2020 | Journal Entry | 4 |  |  |  | -Split- | 199 | 796.89
 | 04/27/2020 | Expense |  |  |  | SERVICE CHARGE ANALYSIS SERVICE CHARGE | 1002 Checking - SVB | 32.98 | 829.87
 | 05/26/2020 | Expense |  | SVB |  | SERVICE CHARGE ANALYSIS SERVICE CHARGE | 1002 Checking - SVB | 50.64 | 880.51
 | 05/29/2020 | Invoice | 80 | Blue Cube Security Limited |  |  | 1010 Accounts Receivable | 18 | 898.51
 | 06/26/2020 | Expense |  |  |  | SERVICE CHARGE ANALYSIS SERVICE CHARGE | 1002 Checking - SVB | 43.29 | 941.8
 | 07/27/2020 | Expense |  |  |  | SERVICE CHARGE ANALYSIS SERVICE CHARGE | 1002 Checking - SVB | 106.38 | 1048.18
 | 08/26/2020 | Expense |  |  |  | SERVICE CHARGE ANALYSIS SERVICE CHARGE | 1002 Checking - SVB | 121.24 | 1169.42
 | 09/28/2020 | Expense |  |  |  | SERVICE CHARGE ANALYSIS SERVICE CHARGE | 1002 Checking - SVB | 54.71 | 1224.13
Total for 7306 Bank Charges & Fees - Accounting/Finance |  |  |  |  |  |  |  | 1224.13
7307 Intercompany Support Services - Accounting/Finance
 | 08/31/2020 | Journal Entry | 8.31 Intercompany Exp |  |  |  | -Split- | 16973.3 | 16973.3
 | 09/30/2020 | Journal Entry | 9.30 Intercompany Exp |  |  |  | -Split- | 8461.78 | 25435.08
Total for 7307 Intercompany Support Services - Accounting/Finance |  |  |  |  |  |  |  | 25435.08
7308 Tax Consulting - Accounting/Finance
 | 09/30/2020 | Journal Entry | 9/30/20 Accrued Exp |  |  | BDO | -Split- | 5000 | 5000
Total for 7308 Tax Consulting - Accounting/Finance |  |  |  |  |  |  |  | 5000
7310 Continuing Education and Health - Accounting/Finance
 | 09/11/2020 | Check |  | [EMAIL] | Finance | Bond Fitness - Health and Wellness Stipend - July | 1002 Checking - SVB | 50 | 50
 | 09/11/2020 | Check |  | [EMAIL] | Finance | Bond Fitness - Health and Wellness Stipend - Aug | 1002 Checking - SVB | 50 | 100
 | 09/30/2020 | Check |  | [EMAIL] | Finance | Lifetime Fitness - September 2020 Gym Membership | 1002 Checking - SVB | 50 | 150
 | 09/30/2020 | Check |  | [EMAIL] |  | Bond Fitness - Health & Wellness - Sept | 1002 Checking - SVB | 50 | 200
Total for 7310 Continuing Education and Health - Accounting/Finance |  |  |  |  |  |  |  | 200
7311 Software and Applications - Accounting/Finance
 | 04/12/2020 | Expense |  | Capshare Inc. |  | [NAME]SOUTH JORDAN        UT XXXX-XXXXXX-21014 - BRIAN WEISBERG | 2001 Credit Card - Amex | 252 | 252
 | 04/13/2020 | Expense |  | Bill.com |  | BILL COM INC        PALO ALTO           CA XXXX-XXXXXX-21006 - SAID ZIOUANI | 2001 Credit Card - Amex | 150 | 402
 | 04/14/2020 | Expense |  | Bill.com |  | BILL COM INC        PALO ALTO           CA XXXX-XXXXXX-21006 - SAID ZIOUANI | 2001 Credit Card - Amex | 88.28 | 490.28
 | 04/14/2020 | Expense |  | Chargify, LLC |  | CHARGIFY, LLC 115244SAN ANTONIO         TX XXXX-XXXXXX-21006 - SAID ZIOUANI | 2001 Credit Card - Amex | 199 | 689.28
 | 04/20/2020 | Expense |  | [NAME] |  | XERO INC XERO INC   SAN FRANCISCO       CA XXXX-XXXXXX-21006 - SAID ZIOUANI | 2001 Credit Card - Amex | 30 | 719.28
 | 05/01/2020 | Expense |  | Simple 409A |  | SIMPLE409A* SIMPLE 4BIRMINGHAM          MI XXXX-XXXXXX-21014 - BRIAN WEISBERG | 2001 Credit Card - Amex | 170 | 889.28
 | 05/12/2020 | Expense |  | Capshare Inc. |  | [NAME]SOUTH JORDAN        UT XXXX-XXXXXX-21014 - BRIAN WEISBERG | 2001 Credit Card - Amex | 82 | 971.28
 | 05/14/2020 | Expense |  | Chargify, LLC |  | CHARGIFY, LLC 115244SAN ANTONIO         TX XXXX-XXXXXX-21006 - SAID ZIOUANI | 2001 Credit Card - Amex | 199 | 1170.28
 | 05/14/2020 | Expense |  | Bill.com |  | BILL COM INC        PALO ALTO           CA XXXX-XXXXXX-21006 - SAID ZIOUANI | 2001 Credit Card - Amex | 98.28 | 1268.56
 | 05/19/2020 | Expense |  | [NAME] |  | XERO US INV-2564012 DENVER              CO XXXX-XXXXXX-21006 - SAID ZIOUANI | 2001 Credit Card - Amex | 30 | 1298.56
 | 06/13/2020 | Expense |  | Chargify, LLC |  | CHARGIFY, LLC | 2002 Credit Card - SVB | 199 | 1497.56
 | 06/14/2020 | Expense |  | Bill.com |  | BILL COM INC        PALO ALTO           CA XXXX-XXXXXX-21006 - SAID ZIOUANI | 2001 Credit Card - Amex | 110.73 | 1608.29
 | 06/16/2020 | Expense |  | Capshare Inc. |  | [NAME]SOUTH JORDAN        UT XXXX-XXXXXX-21014 - BRIAN WEISBERG | 2001 Credit Card - Amex | 82 | 1690.29
 | 06/19/2020 | Expense |  | [NAME] |  | XERO US INV-2611918 DENVER              CO XXXX-XXXXXX-21006 - SAID ZIOUANI | 2001 Credit Card - Amex | 30 | 1720.29
 | 07/12/2020 | Expense |  | Capshare Inc. |  | [NAME]SOUTH JORDAN        UT XXXX-XXXXXX-21014 - BRIAN WEISBERG | 2001 Credit Card - Amex | 82 | 1802.29
 | 07/13/2020 | Expense |  | Chargify, LLC |  | CHARGIFY, LLC | 2002 Credit Card - SVB | 199 | 2001.29
 | 07/14/2020 | Expense |  | Bill.com |  | BILL COM INC        PALO ALTO           CA XXXX-XXXXXX-21006 - SAID ZIOUANI | 2001 Credit Card - Amex | 114.14 | 2115.43
 | 07/19/2020 | Expense |  | [NAME] |  | XERO US INV-2659067 DENVER              [NAME] ZIOUANI | 2001 Credit Card - Amex | 30 | 2145.43
 | 08/12/2020 | Expense |  | Capshare Inc. |  | [NAME]SOUTH JORDAN        UT XXXX-XXXXXX-21014 - BRIAN WEISBERG | 2001 Credit Card - Amex | 82 | 2227.43
 | 08/13/2020 | Expense |  | Chargify, LLC |  | CHARGIFY.COM | 2002 Credit Card - SVB | 199 | 2426.43
 | 08/14/2020 | Expense |  | Bill.com |  | BILL COM INC        PALO ALTO           CA XXXX-XXXXXX-21006 - SAID ZIOUANI | 2001 Credit Card - Amex | 121.22 | 2547.65
 | 08/19/2020 | Expense |  | [NAME] |  | XERO US INV-2708299 DENVER              [NAME] ZIOUANI | 2001 Credit Card - Amex | 30 | 2577.65
 | 09/12/2020 | Expense |  | Capshare Inc. |  | [NAME] | 2002 Credit Card - SVB | 82 | 2659.65
 | 09/13/2020 | Expense |  | Bill.com |  | BILL.COM, INC. | 2002 Credit Card - SVB | 154.53 | 2814.18
 | 09/13/2020 | Expense |  | Chargify, LLC |  | CHARGIFY.COM | 2002 Credit Card - SVB | 199 | 3013.18
 | 09/19/2020 | Expense |  | [NAME] |  | XERO US INV-2756949 | 2002 Credit Card - SVB | 30 | 3043.18
 | 09/29/2020 | Expense |  | Quickbooks Online |  |  | 2002 Credit Card - SVB | 150 | 3193.18
Total for 7311 Software and Applications - Accounting/Finance |  |  |  |  |  |  |  | 3193.18
7312 Team Outing and Meals - Accounting/Finance
 | 09/11/2020 | Check |  | [EMAIL] |  | Restaurant Connection - all hands lunch | 1002 Checking - SVB | 16 | 16
Total for 7312 Team Outing and Meals - Accounting/Finance |  |  |  |  |  |  |  | 16
7319 Internet/Phone Subsidy - Accounting/Finance
 | 09/11/2020 | Check |  | [EMAIL] | Finance | cox cable - Internet Stipend - $50 - July | 1002 Checking - SVB | 50 | 50
 | 09/11/2020 | Check |  | [EMAIL] | Finance | AT&T - Cell Phone [NAME] | 1002 Checking - SVB | 50 | 100
 | 09/11/2020 | Check |  | [EMAIL] |  | Cox Cable - internet stipend - $50 | 1002 Checking - SVB | 50 | 150
 | 09/11/2020 | Check |  | [EMAIL] |  | AT&T - cell phone bill | 1002 Checking - SVB | 50 | 200
 | 09/30/2020 | Check |  | [EMAIL] |  | Cox Communications - internet stipend - Sept | 1002 Checking - SVB | 50 | 250
 | 09/30/2020 | Check |  | [EMAIL] |  | AT&T - cell phone bill - Aug | 1002 Checking - SVB | 50 | 300
 | 09/30/2020 | Check |  | [EMAIL] | Finance | Optimum Online - September 2020 Internet Reimbursement | 1002 Checking - SVB | 50 | 350
Total for 7319 Internet/Phone Subsidy - Accounting/Finance |  |  |  |  |  |  |  | 350
7320 PTO Expense - Accounting/Finance
 | 06/30/2020 | Journal Entry | Reclass PTO Expense 6 |  |  |  | -Split- | 465.97 | 465.97
 | 07/31/2020 | Journal Entry | Reclass PTO Expense 7 |  |  |  | -Split- | 220.04 | 686.01
 | 08/31/2020 | Journal Entry | Reclass PTO Expense 8 |  |  |  | -Split- | 1022.93 | 1708.94
 | 09/30/2020 | Journal Entry | Reclass PTO Expense 9 |  |  |  | -Split- | 596.15 | 2305.09
Total for 7320 PTO Expense - Accounting/Finance |  |  |  |  |  |  |  | 2305.09
Total for 7300 Accounting/Finance - Summary |  |  |  |  |  |  |  | 144134.57