{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Transaction Log","Reconciliation Summary"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Transaction Log","index":0,"n_rows":44,"n_cols":9,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
["TRANSACTION LOG"]
["FUND XXXXXXXXXX / FUND CENTER XXXXXXXXXX",null,null,"M&O Budget"]
["Transaction     Date","Name of Payee / Department / Or Payor (if revenue)","Item Description ","Identifying Document # \n(PO, Voucher, Journal, Etc.)","Additions/Adjustments to Available Balance (\"+\" Amt)","Subtractions From Available Balance \n(\"-\" Amt)","Budget Balance","Period Cleared in SAP","SAP Transaction Number / Notes"]
[null,"BEGINNING BALANCE (Original Budget)"]
[{"$nulls":6},{"$f":"+G4+E5+F5","v":0}]
[{"$nulls":6},{"$f":"+G5+E6+F6","v":0}]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]

{"sheet":"Reconciliation Summary","index":1,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Monthly Reconciliation of SAP to Transaction Log"]
["FY20XX"]
["[INSERT COST CENTER/FUND]"]
[null,"SEP","OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG"]
[null,"(PERIOD 1)","(PERIOD 2)","(PERIOD 3)","(PERIOD 4)","(PERIOD 5)","(PERIOD 6)","(PERIOD 7)","(PERIOD 8)","(PERIOD 9)","(PERIOD 10)","(PERIOD 11)","(PERIOD 12)"]
["Insert Month End Balance from Log here"]
["SAP Available Balance"]
["Difference between Log and SAP",{"$f":"+B6-B7","v":0},{"$f":"+C6-C7","v":0},{"$f":"+D6-D7","v":0},{"$f":"+E6-E7","v":0},{"$f":"+F6-F7","v":0},{"$f":"+G6-G7","v":0},0,0,0,0,0,0]
["Total of uncleared items (add together unchecked items from log here)"]
["Reconciling Difference - If Not $0, See Note Below",{"$f":"+B8-B9","v":0},{"$f":"+C8-C9","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
["Note - If Reconciling Difference is not $0, something has not been included either in the chart above or on the Log.  Check the following:"]
[]
["- Are all transactions and activity from the SAP on the Transaction Log?"]
[]
["-Are transactions correctly marked as Cleared?  Are any transactions marked as Cleared that are not in the SAP?  Are any transactions in the SAP not marked as Cleared?"]
[]
["-Ensure all uncleared transactions are listed above."]