Monthly Report -November 2016

ACCOUNTING ~

  • Financial Reports:
    • Completed November Month End Close on December 9, 2016 – No adjustments.
    • Click here to view City Financial reports with Google Docs
    • Click here for the Interactive Financial Reports with OpenGov
  • Working on department web pages
    • Creating – Utility Billing and HR – Employment
    • Updating – Court, City Recorder, Election and Finance

FRONT COUNTER ~

  • Implementing new security monitoring system at the front counter areas
  • Updated city hall signs

STATISTICAL INFORMATION ~ 

Accounts Payable 

  • City
    • Payment Total – $776,281.36
    • Checks issued  209
    • Bank Draft – 62
    • EFT/ACH Payments 35
  • Senior Center
    • Payment Total – $11,998.54
    • Checks issued – 43

Municipal Court

  • Total Violations: 146
    • Closed – 49, Collections – 41, Dismissed – 5, Fail to Appear – 15, Pending – 5, Payment Plans -29 and Trials – 2

Utility Billing

  • New Accounts – 73, Disconnects – 61, and Active – 4,077

Human Resources ~

  • Continual working updating Personnel Handbook to review with Benefits Committee
  •  Payroll
    • Representing 81 employees, 0 hires, 0 Separations
    • 76 Direct deposits and 12 paper checks

TTIncode Financial Software~

  • Moblie Service Orders – Pending
  • Accounts Receivable – Live
  • Purchasing – Pending
  • Utility Billing and Court Noticfication – Pending

Monthly Report ~ October 2106

ACCOUNTING ~

  • Financial Reports:
    • Completed October closing on November 16, 2016 – No adjustments.
    • Click here to view reports with Google Docs
    • Click here for the Interactive Financial Reports with OpenGov
  • Attend Oregon Governement Finance Officers Assocation Conference in Salem

AUDIT ~ 

  • CAFR and URA Financial Reports presentation to Council is scheduled for November 21, 2016

ELECTION ~ 

Click here to view the certified candidates running in the November 8th General Election.

Congratulations to Council Elected Positons:

Mayor  – Willam (Bill) King, Council Position 3 – John Hamblin, Council Position 4 – Donald Hollis, and Council Postion 4 – Olga Gerberg

Filed Ballot Measures – 

3-499 – Prohibits Certain Marijuana Registrants and Licenses in Sandy -YES

3-500 – Authorizing Tax on Recreational Retail Sales of Marijuana Items – YES

STATISTICAL INFORMATION ~ 

Accounts Payable 

  • City
    • Payment Total – $896,037.16
    • Checks issued  122
    • Bank Draft – 61
    • EFT/ACH Payments 20
  • Senior Center – 19 checks

Municipal Court

  • Total Violations: 187
    • Closed – 69, Collections – 41, Dismissed – 8, Fail to Appear – 23, Pending – 9, Payment Plans -37 and Trials – 2

Utility Billing

  • New Accounts – 73, Disconnects – 61, and Active – 4,077

Human Resources ~

  • Offer Flu Shot Clinic at City Hall on 10/25/16
  • Working updating Personnel Handbook
  • Completed Open Enrollment for 2017 Medical & Dental Benefits
  •  Payroll
    • Representing 81 employees, 0 hires, 0 Separations
    • 76 Direct deposits and 12 paper checks

TTIncode Financial Software~

  • Accounts Receivable – Pending 
  • Purchasing – Pending
  • Utility Billing and Court Noticfication – Pending

Monthly Report ~ August 2016

ACCOUNTING ~

  • Current Finance Reports, click here to view FY 15-16 as June 30, 2016.
  • Click here for the NEW Interactive Financial Reports with OpenGov.

AUDIT ~ 

  • Completed FY 15-16 audit fieldwork.  It went well, no adjustments
  • No Single Audit required in FY 15-16
  • Financials will be drafted the week of October 3rd
  • CAFR presentation to Council is scheduled for October 17, 2016

ELECTIONS ~

Click here to view the certified candidates running in the November 8th General Election. Filed Ballot Measures –
3-499 – Prohibits Certain Marijuana Registrants and Licenses in Sandy

3-500 – Authorizing Tax on Recreational Retail Sales of Marijuana Items

STATISTICAL INFORMATION ~ 

Accounts Payable 

  • City
    • Checks issued  156
    • Bank Draft – 62
    • EFT/ACH Payments 22
  • Senior Center – 41 checks

Municipal Court

  • Total Violations: 163
    • Closed – 48, Collections – 0, Dismissed – 5, Fail to Appear – 44, Pending – 4, Payment Plans -59 and Trials – 3

Utility Billing

  • Receive approximately 300 UT payments through online bill payment systems through customer’s banking system being transmitted as individual paper checks to the City.  Implemented a FREE digital UT payment service with FIS.  There are zero fees, cos or charges associated with the service.  The file is upload directly in Incode which increases the accuarcy and efficiency of posting UT payments to accounts.  
  • Automated Bulk Water Utility Billing

Human Resources ~

  • Representing 83 mployees
  • 0 new hires
  • 1 Retirement ~ Police
  • 69 Direct deposits and 14 paper checks

TTIncode Financial Software~

  • Accounts Receivable – Pending
  • Purchasing – Pending
  • Fixed Assets – Live
  • Employee Self-Service – Live
  • General Ledger – Live
  • Accounts Payable – Live
  • Time Attendance – Live
  • Court – Live
  • Project Accounting – Live

Monthly Report – July 2016

ACCOUNTING ~

  • Current Finance Reports, click here for FY 15-16 as June 30, 2016.
  • Click here for the NEW Interactive Financial Reports with OpenGov
    • Working on the year-end close for FY 15-16
    • Audit Field – August 29th – September 2nd
  • Attended a 2-day Incode Court training at West Linn City Hall
  • RFP – Municipal Advisor for City of Sandy and URA
  • Working on archiving finance files

ELECTIONS ~

Prepare Election Packets; Calendar, nomination forms, public notice and council goal. August 19th – Last day nominations maybe received by the City Recorder.

STATISTICAL INFORMATION ~ 

Accounts Payable 

July 2016 ~ $941,263

  • Checks issued 193 – 61%
  • EFT/ACH Payments 73 -39%
  • Invoices 441

Utility Billing

  • Working on automating Bulk Water Utility Billing

Human Resources ~

  • Attended CIS Employer Open Enrollment in Tualatin July 21st
  • Completed CIS Benefits Request for Coverage Calendar Year 2017
  • Total wages paid: $536, 017
  • Representing 82 mployees
  • 1 new hire ~ Police
  • 2 Retirements ~ Finance and Public Works
  • 67 Direct deposits and 15 paper checks

TTIncode Financial Software~

  • Employee Self-Service – Live
  • General Ledger – Live
  • Accounts Payable – Live
  • Time Attendance – Live
  • Court – Live
  • Project Accounting – Live

Monthly Report – April 2016

ACCOUNTING ~

  • Current Finance Reports, click here.
  • Completed Bank Reconciliation and month-end close by May 9th, meet goal and sent out a Budget/Actual Monthly Report to all Department Directors.
  • New Finance staff member – Jayme Wantowski, Utility Billing Clerk.
  • Staff access to Incode Software (view only – Utility Billing, Accounts Payable, Project Accounting, Finance Reports, Cash Receipting) other then Finance staff: 15
  • Member of League of Oregon Cities Committees:
    • Finance and Taxation – April 15
    • General Government – April 20

STATISTICAL INFORMATION ~ 

Human Resources ~

  • Representing 80 employees
  • 1 new hire ~ Finance
  • 2 Retirements ~ Finance and Public Works
  • 66 Direct deposits and 14 paper checks

TTIncode Financial Software~

  • Employee Self-Service – Live
  • General Ledger – Live
  • Accounts Payable – Live
  • Time Attendance – Live
  • Court – Live
  • Project Accounting – Live
  • Purchase Orders – Scheduled June
  • Accounts Receivable – Scheduled June

Monthly Report – March 2016

ACCOUNTING ~

  • Finance Reports as of February 29, 2016, click here.
  • Our goal is to complete the monthly close and bank reconciliation by the 10th of the each month.  March 2016 will be completed by April 15th.  As the finance staff is getting more familiar with the new software, the goal of closing each month by the 10th is realistic.
  • Received the Government Finance Officers Association award for Excellence in Financial Reporting for its comprehensive annual financial report for the fiscal year ended June 30, 2015.

HUMAN RESOURCES ~

Intern ~ Nicole Clodfelter is a Human Resource Intern from Clackamas Community College. She will be working 12 hours a week through June 2016.  She has already made an impact on assisting with and completing various HR and Risk Management projects.

Retirement ~ Sandy Bernhardt, Utility Billing Clerk, will be retiring on April 29, 2016. There will be a retirement party on Thursday, April 28th at the Senior Center from noon to 2:00 PM.  A light lunch will be served.

STATISTICAL INFORMATION ~ 

Utility Billing

  • 62 new customers
  • 40 shut offs in March

Human Resources ~

  • Representing 79 employees
  • 1 new hire ~ SandyNet
  • 2 Separation ~ SandyNet and Public Works
  • 65 Direct deposits and 14 paper checks

Accounts Payable ~

March 2016 ~ $1,609,805

  • Checks issued 167
  • ACH Payments 38
  • Invoices 358

March 2015 ~ $1,099,944

  • Checks issued 259
  • ACH Payments 0
  • Invoices 461

TTIncode Financial Software~

  • Employee Self-Service – Live
  • General Ledger – Live
  • Accounts Payable – Live
  • Time Attendance – Live
  • Court – Schedule for May 2016

Monthly Report – December 2015

ACCOUNTING ~

  • Finance Reports…coming soon.  Still working on reconciling data in Springbrook  and Incode. Thank you for your patience.

STATISTICAL INFORMATION ~ 

Utility Billing

  • No Shut offs in December
  • 11 new move-ins

HUMAN RESOURCES ~

December 16 ~ Holiday Potluck and First Annual Ugly Sweater contest . The winners were Traditional – Joe Knapp, Original – Muna Rustam and  Christmas -Thomas Fisher.  Thank you to Mayor King for assisting with the judging.

  • Representing 79 employees
  • 1 new hire ~ Account/Court Clerk
  • 1 Separation ~ Library Clerk
  • 66 Direct deposits and 13 paper checks

Accounts Payable

November 2015 ~ $1,609,805

  • Checks issued 167
  • ACH Payments 38
  • Invoices 358

November 2014 ~ $1,099,944

  • Checks issued 259
  • ACH Payments 0
  • Invoices 461

TTIncode Financial Software~

  • Employee Self-Service – Live
  • GL – Work in Progress
  • AR – Work in Progress
  • Time Attendance – Work in Progress

Conference/Training ~

  • Training at Clackamas County Justice Court in Happy Valley.

Monthly Report ~ November 2015

ACCOUNTING ~

  • Finance Reports…coming soon.  Still working on reconciling data in Springbrook  and Incode.

HUMAN RESOURCES ~

  • Departmental Presentations on Benefits and Workers’ Compensation ~ Finance & Administration – October 1, Senior Center  – October 5, and Public Works – October 7
  • Benefits Open Enrollment for 2016 from October 5  to 16
  • 1st Annual Flu Shot Clinic @ City Hall, October 26, 2015

STATISTICAL INFORMATION ~ 

Utility Billing

  • 33 Shut offs
  • 27 New water customers

Human Resources

Attended PERS town hall meeting in Gresham.  Director discussed future employer contribution rates and the dynamics associated with pending changes, including the current system funding status.

City of Sandy can expect substantial employer contribution rate increases over the next several bienna as  PERS rates are updated every two years.  More detailed information to come in the near future.

  • Representing 82 employees
  • 0 new hires
  • 0 Separations
  • 67 Direct deposits and 13 paper checks
  • 1 Open Position – Resulting in 1 job offer (Account/Court Clerk)

Accounts Payable

November 2015

  • Checks issued 136
  • ACH Payments 69

November 2014

  • Checks issued 204
  • ACH Payments 0
  • TTIncode Financial Software~
  • LIVE with Payroll system
  • LIVE with Accounts Payable
  • LIVE with Utility Billing
  • GL – Work in Process
  • AR – Work in Process

Conference/Training ~

  • Attended Bureau of Labor Industries (BOLI) annual conference November 11th & 12th in Salem.
  • Attended Oregon Government Finance Officers Association Education Committee.
  • Attended webinar offered by Government Finance Officers Association (GFOA) – Annual GAAP update.
  • Attended CIS webinar ~ The Benefits of Your Employee Assistance Program

Monthly Report ~ October 2015

ACCOUNTING ~

  • October 2015 Finance Reports…coming soon.  Working on reconciling data in Springbrook  and Incode.

HUMAN RESOURCES ~

  • Departmental Presentations on Benefits and Workers’ Compensation ~ Finance & Administration – October 1, Senior Center  – October 5, and Public Works – October 7
  • Benefits Open Enrollment for 2016 from October 5  to 16
  • 1st Annual Flu Shot Clinic @ City Hall, October 26, 2015

STATISTICAL INFORMATION ~ 

Human Resources

  • Representing 82 employees
  • 0 new hires
  • 4 Separations (Admin, Library, and 2 SandyNet)
  • 68 Direct deposits and 14 paper checks
  • 1 Open Position – Municipal Court Clerk

Accounts Payable

  • 4 weekly check runs totaling $574,284
  • 319 checks, 25 bank drafts, 13 EFT’s
  • TTIncode Financial Software~
  • LIVE with Payroll system
  • LIVE with Accounts Payable
  • LIVE with Utility Billing

 

Conference/Training ~

  • Attended Oregon Government Finance Officers Association Fall Conference, October 5-7 at the Lloyd Center in Portland.