{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Start","entry_form","explanations","sample_budget_entry","sample_journal_entry","JE_samples","FAQ"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"Start","index":0,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,0,12],[28,3,28,5]]}
["ST. NORBERT COLLEGE FINANCIAL ENTRY REQUEST"]
["Select Entry Type"]
[]
["Budget Entry"]
[]
["Journal Entry"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Frequently Asked Questions"]

{"sheet":"entry_form","index":1,"n_rows":43,"n_cols":14,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,0,0,12],[1,0,1,12],[5,0,5,5],[5,7,5,11],[7,4,7,5],[7,12,17,12],[27,7,37,12],[42,9,42,12],[16,4,16,5],[17,4,17,5],[18,4,18,5],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[26,6,26,12],[8,4,8,5],[9,4,9,5],[10,4,10,5],[11,4,11,5]]}
["ST. NORBERT COLLEGE FINANCIAL ENTRY REQUEST",null,null,null,null,null,null,null,null,null,null,null,null,0]
["PLEASE FORWARD COMPLETED AND APPROVED FORM TO FINANCE DEPT:  Budget Entries to Matt Clark, Journal Entries to Sally Gazza"]
[]
["BUDGET ENTRY",null,"(For moving budget amounts)",null,null,null,null,"HELP",null,null,null,"Sample Budget Entry"]
[null,null,null,null,null,null,null,null,null,null,"  If nothing selected, permanent will be the default value"]
["FROM",null,null,null,null,null,null,"TO "]
["FUND","ORGANIZATION","ACCOUNT","(optional)\nLOCATION",null,"AMOUNT",null,"FUND","ORGANIZATION","ACCOUNT","(optional)\nLOCATION","AMOUNT","DESCRIPTION"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"SUM(E8:E18)","v":0},null,null,null,null,null,null,{"$f":"SUM(L8:L18)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E19<>L19,\"OUT OF BALANCE\",\" \")","v":" "}]
[]
[]
[]
[]
["JOURNAL ENTRY",null,"(For moving year-to-date or \"actuals\" amounts)",null,null,null,null,"HELP",null,null,null,"Sample Journal Entry"]
[]
["FUND","ORGANIZATION","ACCOUNT","(optional)\nLOCATION","* D/C","AMOUNT","DESCRIPTION"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["*  D=Debit","C=Credit","(Assets and Expenses have a normal debit balance.  Liabilities, Net Assets, and Revenue have a normal credit balance)"]
[]
[]
["Approved by:    ",null,null,null,null,null,null,"Date:",null,"    (If form emailed as a file, the email will serve as authorization in lieu of signature)"]

{"sheet":"explanations","index":2,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":false,"merged":[[12,0,12,14],[13,0,13,14],[33,0,33,5],[33,6,33,10]]}
[]
[]
[]
["Reasons to use Financial Entry Request form:",null,null,null,null,null,null,null,"Entry Form"]
["1.  The form provides a structure for collection of data elements required for Banner Finance entries."]
["2.  Errors will be reduced because necessary Banner codes should be suppled by requestors requiring fewer presumptions or questions."]
["3.  Entry type (Budget vs Journal) will be clearly indicated which should reduce errors and questions."]
["4.  Because entry type will be clear from the form, requests can be more easily routed to appropriate staff for system processing. "]
["5.  A common format will promote faster and more efficient processing of requests."]
["6.  An approval signature or email, if file sent electronically, will document a responsible person to which entry inquires can be made.  "]
[]
["Budget Entry versus Journal Entry:"]
["A budget entry moves amounts in the budget column of financial data. A journal entry moves amounts in the year-to-date or \"actuals\" column of financial data. A budget is a plan and does not represent or measure actual results of operations whereas year-to-date amounts represent actual financial transactions including revenue and expenses."]
["A common view of financial data is to show a budget (plan), year-to-date \"actuals\" (what has really occurred) and an available balance (budget minus year-to-date).  A financial entry request must specify either a budget or journal entry request."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Budget Entry Data chart - Since only Revenue and Expenses are budgeted, the Financial Entry Request form uses \"From\" and \"To\" columns for simplification.  Data is translated to debits and credits.",null,null,null,null,null,"Journal Entry Data Chart - Since all 5 account types can be affected, specific debit/credit identification is required."]
["Account Type","Account code range","From / To","debit / credit translation","Effect on Adjusted Budget","Effect on Avail Balance","Account Type","Account code range","debit / credit ","Effect on YTD (actuals)","Effect on Avail Balance"]
["Revenue","500000 - 599999","From\nTo","debit\ncredit","decrease\nincrease","n/a","Revenue","500000 - 599999","debit\ncredit","decrease\nincrease","n/a"]
["Expense","600000 - 799999","To\nFrom","debit\ncredit","increase\ndecrease","increase\ndecrease","Expense","600000 - 799999","debit\ncredit","increase\ndecrease","decrease\nincrease"]
[null,null,null,null,null,null,"Asset","100000 - 299999","debit\ncredit","increase\ndecrease","n/a"]
[null,null,null,null,null,null,"Liability","300000 - 430000","debit\ncredit","decrease\nincrease","n/a"]
[null,null,null,null,null,null,"Net Asset","470000 - 479999","debit\ncredit","decrease\nincrease","n/a"]

{"sheet":"sample_budget_entry","index":3,"n_rows":43,"n_cols":14,"rows_kept":43,"cut":false,"hidden":false,"merged":[[27,7,37,12],[42,9,42,12],[16,4,16,5],[17,4,17,5],[18,4,18,5],[26,6,26,12],[0,0,0,12],[1,0,1,12],[5,0,5,5],[5,7,5,11],[7,4,7,5],[8,4,8,5],[9,4,9,5],[10,4,10,5],[11,4,11,5],[7,12,17,12],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5]]}
["ST. NORBERT COLLEGE FINANCIAL ENTRY REQUEST",null,null,null,null,null,null,null,null,null,null,null,null,1]
["PLEASE FORWARD COMPLETED AND APPROVED FORM TO FINANCE DEPT:  Budget Entries to Matt Clark, Journal Entries to Sally Gazza"]
[]
["BUDGET ENTRY",null,"(For moving budget amounts)",null,null,null,null,"HELP",null,null,null,"Entry_Form"]
[null,null,null,null,null,null,null,null,null,null,"  If nothing selected, permanent will be the default value"]
["FROM",null,null,null,null,null,null,"TO "]
["FUND","ORGANIZATION","ACCOUNT","(optional)\nLOCATION",null,"AMOUNT",null,"FUND","ORGANIZATION","ACCOUNT","(optional)\nLOCATION","AMOUNT","DESCRIPTION"]
[100200,123456,710740,null,2000,null,null,100200,123456,710764,null,2000,"Budget reallocation per J. Doe.  "]
[100200,234567,710400,null,33.33,null,null,100200,234567,710281,null,33.33]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"SUM(E8:E18)","v":2033.33},null,null,null,null,null,null,{"$f":"SUM(L8:L18)","v":2033.33}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E19<>L19,\"OUT OF BALANCE\",\" \")","v":" "}]
[]
[]
[]
[]
["JOURNAL ENTRY",null,"(For moving year-to-date or \"actuals\" amounts)",null,null,null,null,"HELP",null,null,null,"Entry_Form"]
[]
["FUND","ORGANIZATION","ACCOUNT","(optional)\nLOCATION","* D/C","AMOUNT","DESCRIPTION"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["*  D=Debit","C=Credit","(Assets and Expenses have a normal debit balance.  Liabilities, Net Assets, and Revenue have a normal credit balance)"]
[]
[]
["Approved by:    ",null,null,null,null,null,null,"Date:",null,"    (If form emailed as a file, the email will serve as authorization in lieu of signature)"]

{"sheet":"sample_journal_entry","index":4,"n_rows":43,"n_cols":14,"rows_kept":43,"cut":false,"hidden":false,"merged":[[27,7,37,12],[42,9,42,12],[16,4,16,5],[17,4,17,5],[18,4,18,5],[26,6,26,12],[0,0,0,12],[1,0,1,12],[5,0,5,5],[5,7,5,11],[7,4,7,5],[8,4,8,5],[9,4,9,5],[10,4,10,5],[11,4,11,5],[7,12,17,12],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5]]}
["ST. NORBERT COLLEGE FINANCIAL ENTRY REQUEST",null,null,null,null,null,null,null,null,null,null,null,null,0]
["PLEASE FORWARD COMPLETED AND APPROVED FORM TO FINANCE DEPT:  Budget Entries to Matt Clark, Journal Entries to Sally Gazza"]
[]
["BUDGET ENTRY",null,"(For moving budget amounts)",null,null,null,null,"HELP",null,null,null,"Entry_Form"]
[null,null,null,null,null,null,null,null,null,null,"  If nothing selected, permanent will be the default value"]
["FROM",null,null,null,null,null,null,"TO "]
["FUND","ORGANIZATION","ACCOUNT","(optional)\nLOCATION",null,"AMOUNT",null,"FUND","ORGANIZATION","ACCOUNT","(optional)\nLOCATION","AMOUNT","DESCRIPTION"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"SUM(E8:E18)","v":0},null,null,null,null,null,null,{"$f":"SUM(L8:L18)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E19<>L19,\"OUT OF BALANCE\",\" \")","v":" "}]
[]
[]
[]
[]
["JOURNAL ENTRY",null,"(For moving year-to-date or \"actuals\" amounts)",null,null,null,null,"HELP",null,null,null,"Entry_Form"]
[]
["FUND","ORGANIZATION","ACCOUNT","(optional)\nLOCATION","* D/C","AMOUNT","DESCRIPTION"]
[100200,123456,710400,null,"C",400,null,"To correct prior coding error.  Account 710400 was debited and should have been 710281."]
[100200,123456,710281,null,"D",400]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["*  D=Debit","C=Credit","(Assets and Expenses have a normal debit balance.  Liabilities, Net Assets, and Revenue have a normal credit balance)"]
[]
[]
["Approved by:    ",null,null,null,null,null,null,"Date:",null,"    (If form emailed as a file, the email will serve as authorization in lieu of signature)"]

{"sheet":"JE_samples","index":5,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Sample Journal Entry Requests"]
[1,"A payment of $1,000 was made to the Widget Company based on a department's Requisition.  The $1,000 was coded to organization\ncode 100001 but later the department decides the expense should be coded to department 100002."]
[]
[2,"Supply expenses of $3,000 were coded to a department's Office Supply account in the Non-Personnel fund.  Later, it is agreed that a grant will\nbe charged for half of the expenses.  "]
[]
[3,"A department purchased $4,000 of equipment.  Some of the items valued at $1,000 are distributed to each of 2 other departments.  The expenses now need to be allocated proportionately to all of the departments that received the equipment.  "]

{"sheet":"FAQ","index":6,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[[4,0,4,11],[6,0,6,11],[16,0,16,11],[8,0,8,11],[10,0,10,11],[12,0,12,11],[14,0,14,11]]}
["Financial Entry Request Form - Frequently Asked Questions:",null,null,null,null,null,null,"BACK"]
[]
[]
[]
["What is the preferred process for submitting budget or journal entries?  The most efficient method for submitting entries is by completing a Financial Entry Request Form and emailing it as an attachment to the appropriate contact in the Finance Department.  The form provides a standardized structure for collecting data elements required by the Banner system.  Emailing the file allows cutting and pasting data into Banner whereas data from hardcopy forms must be completely retyped."]
[]
["What if I have more entries than the form allows:  The Financial Entry Request Form is an Excel document so additional rows can be added as needed or, alternatively, multiple forms could be used.  "]
[]
["What's the difference between a temporary and permanent budget transfer:  A permanent budget transfer will carry over to the following year while a temporary budget transfer will not. Budget transfer requests are presumed to be permanent unless specifically noted otherwise when communicated to the Finance Department for processing."]
[]
["How long does it take to process a budget transfer or journal entry? If an entry is appropriately justified and contains proper FOAPAL elements and amounts, it will usually be processed within 5 business days of receipt in the Finance Department. Unclear and/or incomplete entries will cause delays. "]
[]
["Can I transfer a revenue budget to an expense budget?  No. Only revenue to revenue or expense to expense budget transfers are allowed.  "]
[]
["How would I use the Financial Entry Request Form to request a budget increase to both revenue and expense?  First, this type of transfer is unusual and would only be allowed under certain conditions and with the approval of the Finance Director.  If approved, the best way to accomplish this using the Financial Entry Request Form would be to use the \"To\" column for both revenue and expense entries and clearly indicate in the description area the intent to increase both revenue and expense budgets.  "]
[]
["How often should I review my budget? It depends on personal preferences and the volume and frequency of transactions. Like changing the oil in your car, a good rule of thumb is to do it at least once every 3 months."]
[]
[]
["BACK"]