I have attached two Excel files: "Company GL" file and "Homework" file. Please open the Excel file.
The "Company GL" Excel file shows the company's prepaid expense data and related information. The "Homework" file is the prepaid account reconciliation workbook.
I need to build the prepaid account reconciliation in the "Homework" Excel file. Therefore, I am confused how to build the prepaid account reconciliation by using the data from the "Company GL" Excel file?
1200 Prepaid Expenses Date Transaction Type Num Adj Beginning Balance Total for 1200 Prepaid Expenses 01/01/2020 Journal Entry 115 No 01/01/2020 Journal Entry 114 No 01/31/2020 Journal Entry 75 No 01/31/2020 Journal Entry 75 No 01/31/2020 Journal Entry 74 No 01/31/2020 Journal Entry 75 No 02/29/2020 Journal Entry 85 No 02/29/2020 Journal Entry 85 No 02/29/2020 Journal Entry 85 No 02/29/2020 Journal Entry 84 No 03/31/2020 Journal Entry 98 No 03/31/2020 Journal Entry 98 No 03/31/2020 Journal Entry 98 No 03/31/2020 Journal Entry 97 No 04/01/2020 Journal Entry 144 No 04/01/2020 Journal Entry 142 No 04/01/2020 Journal Entry 141 No 04/02/2020 Expense No 04/02/2020 Expense No 04/03/2020 Expense 04/30/2020 Journal Entry 108 No 04/30/2020 Journal Entry 109 No 04/30/2020 Journal Entry 109 No 04/30/2020 Journal Entry 109 No 05/31/2020 Journal Entry 124 No 05/31/2020 Journal Entry 138 No 05/31/2020 Journal Entry 124 No 05/31/2020 Journal Entry 124 No 05/31/2020 Journal Entry 124 No No General Ledger January - May, 2020 Name Embroker.com Embroker.com Chubb General Ledger January - May, 2020 Memo/Description Reclass Lever annual fee to prepaid expenses Reclass payment to HUB International to Prepaid Expenses Directors & Officers - Private - 11/14/19 - 11/13/20 Business Owner - 5/31/19 - 5/30/20 Lever Hire Professional Annual Fee 9/30/19 - 9/29/20 Life insurance - Rob Pardo - 12/8/19 - 12/7/20 Life insurance - Rob Pardo - 12/8/19 - 12/7/20 Directors & Officers - Private - 11/14/19 - 11/13/20 Business Owner - 5/31/19 - 5/30/20 Lever Hire Professional Annual Fee 9/30/19 - 9/29/20 Business Owner - 5/31/19 - 5/30/20 Directors & Officers - Private - 11/14/19 - 11/13/20 Life insurance - Rob Pardo - 12/8/19 - 12/7/20 Lever Hire Professional Annual Fee 9/30/19 - 9/29/20 To adjust Nov 19 - April 20 prepaid expenses (HUB) To adjust January - March 2020 prepaid expenses (CHUBB) To adjust 2019 prepaid expenses - CHUBB under recorded embroker.com embroker.c ST-L2R9J embroker.com embroker.c STL2R9J3E8N2S1 BONFIRE STUDIOS INC embroker.com embroker.c ST-I4Z2I embroker.com embroker.c STI4Z2I9P5Y7U9 BONFIRE STUDIOS INC CHUBB CHUBB01 032011227230001 CHUBB CHUBB01 032011227230001 BONFIRE STUDIOS, INC. Lever Hire Professional Annual Fee 9/30/19 - 9/29/20 Life insurance - Rob Pardo - 12/8/19 - 12/7/20 Business Owner - 5/31/19 - 5/30/20 Directors & Officers - Private - 11/14/19 - 11/13/20 Life insurance - Rob Pardo - 12/8/19 - 12/7/20 Lever Hire Professional Annual Fee 9/30/19 - 9/29/20 Business Owner - 5/31/19 - 5/30/20 Embroker Directors & Officers - Private - 11/14/19 - 11/13/20 Split Amount Balance 1,261.79 -Split- 3,000.00 4,261.79 -Split- 16,056.78 20,318.57 -Split- -1,338.07 18,980.50 -Split- -228.00 18,752.50 -Split- -250.00 18,502.50 -Split- -225.00 18,277.50 -Split- -225.00 18,052.50 -Split- -1,338.07 16,714.43 -Split- -228.00 16,486.43 -Split- -250.00 16,236.43 -Split- -228.00 16,008.43 -Split- -1,338.07 14,670.36 -Split- -225.00 14,445.36 -Split- -250.00 14,195.36 -Split- 0.01 14,195.37 -Split- -387.75 13,807.62 -Split- -1,034.00 12,773.62 1001 SVB Checking x0978 1,581.00 14,354.62 1001 SVB Checking x0978 10,862.93 25,217.55 1001 SVB Checking x0978 4,507.00 29,724.55 -Split- -250.00 29,474.55 -Split- -225.00 29,249.55 -Split- -357.25 28,892.30 -Split- -1,338.07 27,554.23 -Split- -225.00 27,329.23 -Split- -250.00 27,079.23 -Split- -375.58 26,703.65 -Split- -1,037.00 25,666.65 -Split- -1,338.07 24,328.58 $ 23,066.79 GL Account Threshold Guidance Date 1001 - Prepaids Vendor Description From To Expense Class Amount Jan-20 Credit Debit 1/1/2018 Total - GL Variance - Jan-20 Balance - - Feb-20 Credit Debit - Balance - - - Mar-20 Credit Debit - Balance - - - Apr-20 Credit Debit - Balance - - - Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 May-20 Credit Debit - - Balance - - Jun-20 Credit Debit - Balance - - - Jul-20 Credit Debit - Aug-20 Balance - - - Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Debit - Aug-20 Credit Balance - - - Sep-20 Credit Debit - Balance - - - Oct-20 Credit Debit - Balance - - - Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Nov-20 Credit Debit - - Nov-20 Balance - - Dec-20 Credit Debit - Balance - - - Err:504 Err:504 Err:504 Err:504
