Montana Association of School Business Officials Summer Conference

Montana Association of School Business Officials Summer Conference 2019

Quickbooks Users Agenda Welcome and Introductions Audit Trail Chart of Accounts/Classes Fund Balance Budget Clearing Funds ACH Payments Reports Fixed Assets Your Choice

Quickbooks Users Meeting • Audit Trail • Automatically turned on in newer versions • Old versions – may require selection under preferences • Useful for error hunting • Shows all activity by account, entry, date, you pick how you want to look at it

Audit Trail – How to Get There • Reports • Accountants & Taxes • Audit Trail • Pick date range – I usually use the date I entered, not the date of the transaction. It is easier to find. • Customize Report makes it easy to filter by dates, accounts, class, amount, etc.

Audit Trail - example Num 17 -71 18 -52 Entered/Last Modified 05/23/2019 9: 34: 21 05/23/2019 9: 27 Last modified by Admin State Latest Prior Date 06/30/2018 Memo Account Split Amount ADJUST FB 3900 · Retained Earnings -SPLIT- -20, 861. 60 ADJUST FB 101 -970 · GEN-FUND BAL 3900 · Retained Earnings -1, 526. 41 ADJUST FB 110 -970 · TRANS-FUND BAL 3900 · Retained Earnings 0. 00 ADJUST FB 114 -970 · RET-FUND BAL 3900 · Retained Earnings -715. 91 ADJUST FB 115 -970 · MISC-FUND BAL 3900 · Retained Earnings 27, 141. 21 ADJUST FB 128 -970 · TECH - FUND BAL 3900 · Retained Earnings -289. 48 ADJUST FB 129 -970 · FLEX-FUND BAL 3900 · Retained Earnings -6, 503. 30 ADJUST FB 160 -970 · BLDG-FUND BAL 3900 · Retained Earnings 2, 755. 49 ADJUST FB 3900 · Retained Earnings -SPLIT- ADJUST FB 101 -970 · GEN-FUND BAL 3900 · Retained Earnings -1, 526. 41 ADJUST FB 110 -970 · TRANS-FUND BAL 3900 · Retained Earnings 0. 00 ADJUST FB 114 -970 · RET-FUND BAL 3900 · Retained Earnings -715. 91 ADJUST FB 115 -970 · MISC-FUND BAL 3900 · Retained Earnings 27, 141. 21 ADJUST FB 128 -970 · TECH - FUND BAL 3900 · Retained Earnings -289. 48 ADJUST FB 129 -970 · FLEX-FUND BAL 3900 · Retained Earnings -1, 992. 00 ADJUST FB 160 -970 · BLDG-FUND BAL 3900 · Retained Earnings 2, 755. 49 -25, 372. 90

Chart of Accounts • Classes • • • Needed for Fund Accounting Unique for each fund Must be used for all transactions involving Funds Caution – QB does not care if class matches fund or coding Use the Profit & Loss by Class Report to find misclassified entries Easiest is to use fund names (General, Retirement, etc. )

Chart of Accounts – cont. • Accounts • Use OPI numbering system (with some modifications due to system limitations) • For this to be successful, you must be familiar with the OPI system so you can crosswalk some of the numbers. Go to the website and print the chart of accounts if you do not have a copy. • Such as: • Fund: 101 – General Fund • Balance Sheet Account: 101 -101 – General Cash • Revenue: 01 -3110 – Direct State Aid • Expenditures: 10 – 120 – Instruction Teacher Salary • Sped 28 – 920 – RSBG Transferred to Coop • For an example, see the Balance Sheet and Profit & Loss Reports

Chart of Accounts – cont. • Use Control Accounts to get Totals on Reports • 101 - General Revenues –Totals Revenues by Fund • 101 – General Expenditures – Totals Expenditures by Fund • 10 – Instruction – Totals Expenditures by Function • The trick is in how each account is built in relation to the others. • This system also helps with completion of the TFS • For an example, see the Profit and Loss Report • The Profit and Loss by Class Report can show misclassified expenditures

Fund Balance • Quickbooks uses Retained Earnings and Net Income to arrive at equity. • Fund Accounting uses Fund Balance and the effects of revenues, expenditures and changes in encumbrances to reflect equity. • If you encumber, it is easier to do it using journal entries since there will probably not be many entries. • The following will be done for year end closing:

Fund Balance – cont. • Record any encumbrances using the Journal Entry Function. • Company – Make Journal Entries • Create a Claim or Purchase order to keep track of the transaction. • Write the GJ number on the document or attach a copy for ease in documentation. • Record the transaction according to the following example:

Fund Balance – cont.

Fund Balance – cont. • Adjusting Fund Balance in Quickbooks • The Balance Sheet Report at 6/30 will show Retained Earnings and Net Income • If you have adjusted your Fund Balance in the prior year, the R. E. and N. I. Should be the same numbers but one negative and the other positive • Fund Balance should usually be equal to Cash adjusted for any Due From/Due To/Encumbrances • See Balance Sheet Example

Fund Balance – cont. • Quickbooks Balance Sheet at 6/30/18 General Fund Transportation Fund Cash 12, 155. 82 Cash 505. 51 Encumb -453. 94 Due to Other Gov 232. 75 FB Should be 11, 701. 88* FB Should Be 272. 76* QB FB is 10, 175. 47 QB FB is 272. 76 Adjust Needed 1, 526. 41 Adjust needed -0*Must match TFS

Fund Balance – cont. • Please see the examples: • Balance Sheet before adjustments • Spreadsheet calculating adjustment • Balance Sheet after adjustment

Budgeting – How to Get There • Company • Planning & Budgeting • Set Up Budgets

Budgeting – cont. • Create New Budget • Select Year • Budget Type (Should be Profit and Loss) • Next • Criteria – Choose Class • Create Budget from Scratch • Finish • Enter all items in the July column (QB wants to spread by month and we all know that our revenue and expenditures are not that exact. )

Budgeting – cont. • Enter Revenues from the OPI Budget Document. • Enter Expenditures for the areas that will have expenditures. • Hint: Use the previous year’s Profit and Loss Report and adjust for inflation, raises, etc. • Super Hint: Be very sure that the budgeted revenues and expenditures match the budget document. • How do you do this? • Run a budget report and check. You can always go back into the budget creation function and make corrections/adjustment.

Budgeting – cont. • Where is the Budget Report? • Reports • Budget vs. Actual • Choose budget for the appropriate fiscal year. QB will hold them all. • Next • Choose Account by Month • Next • Finish

Budgeting – cont. • • • When the report comes up Choose the date range you want (month, quarter, fiscal year) In Show Columns choose year That will reduce the budget report to four columns CAUTION This report is different than we are used to This report has a column”$ Over Budget” For Revenues a Negative Balance means amounts not yet collected This is normal for a budget report For Expenditures a Negative Balance means Expenditures not yet made This is the reverse of most budget reports Be sure to explain this to your Board of Trustees or other users so no one has heart failure Write an explanation in the column addressing this issue and again tell them when they see it

Clearing Fund • A Clearing Fund is much easier to use than writing multiple warrants. • You can use one fund and one warrant series. • Quickbooks has a transfer function to use for moving cash from the various fund to cover the warrants written during the month. • Monthly reconciliation with the County Treasurer is easy. • Ask the Board of Trustees to permit the establishing of a clearing fund. • Inform the County Treasurer of the need for the fund ask that it be added.

Clearing Fund – cont. • When writing warrants. Use the class designation on each expenditure line. This will spread the expenditures to the various funds. • At month end, run a Profit and Loss Report for the Month. The total for each fund should be the transfer needed to cover the warrants written from the clearing fund. • Run a balance sheet at month end. The balance in the clearing fund after transfers should be equal to the warrants written plus any quarterly withholdings not yet remitted. (State Income Tax, Work Comp, Unemployment)

ACH Payments • For a while I was using a General Journal Entry to record ACH transfers. • Then the light came one and now I write a check using a dummy check number (so it does not goof up my warrant series). • The number I use is year/month/number i. e. 190601 would be the first dummy check written in June of 2019 for the Federal Deposit. • These numbers now show up on my check listing that I provide to the County Treasurer and the Board of Trustees. • Be sure to let the Treasurer know each time you are making or receiving an ACH transaction. They really appreciate it.

Reports • There are many reports available in Quickbooks. • Common ones that are helpful are: • Company and Financial • Balance Sheet • Profit & Loss • Accountants and Taxes • Transaction Detail by Account • Audit Trail • Banking • Check Detail • Budgets • Budget vs Actual

Fixed Assets • Quickbooks does have a fixed asset application. • That will be a discussion for a future meeting. • At this point, I am using an Excel Spreadsheet to maintain fixed asset records. • A copy is included in the packet and on the MASBO Website

Fixed Assets – cont. SCHOOL DISTRICT 86 CUSTER COUNTY, MONTANA FIXED ASSETS $200 Capitalization CATEGORY DESCRIPTION LAND School Site 1954 LAND Fence IMPROVEMENTS Septic Tank 9/30/2003 9/15/2005 DATE PURCHASED Total BUILDINGS School Building Water Line Furnace Insulation Storage Building Flooring Hotwater Tank/Shower Bathroom Remodel Building exterior repairs Bathroom Remodel Exterior Paint Siding/Windows/Paint Re-Wire School Remodel Kitchen/Bath Total COST VENDOR WT SOURCE COMMENTS 0. 00 Ed Love 2, 985. 95 Big R 4, 000. 00 Muggli Contracting Leased 9629 General 10222 General 6, 985. 95 1954 3/18/2005 5/11/2005 4/20/2006 6/13/2006 8/18/2006 9/5/2006 6/25/2007 7/24/2007 8/14/2006 6/30/2015 9/30/2015 1/13/2016 6/29/2017 9/29/2017 500. 00 Unknown 674. 28 Regan Plum & Heat 6, 390. 00 Regan Plum & Heat 713. 50 Wilson Construction 950. 00 Star Structures 769. 84 Paxon Flooring 512. 53 Steadmans 348. 64 UBC 1, 739. 00 Wilson Construction 1, 980. 00 Wilson Construction 1, 370. 00 Wilson Construction 6, 500. 00 Steve Price Construction 8, 159. 00 Glader Electric 4, 000. 00 RC Contracting 6, 910. 07 RC Contracting 1, 212. 22 RC Contracting 49, 229. 08 Est. - Moved in 9881 General 9898 General 10323 General 10352 General 10377 General 10386 General 10387 General 10358 General 10553 General 10376 General 2009 General 1980 General 2049 OTO 2258 OTO 2265 OTO 2274 OTO Deposit Final Payment Deposit Progress Payment Final Payment

Questions? Contact Information Robert Martelle rjmartelle@midrivers. com 406 -351 -1340

THANK YOU Have a Great Conference