William Johnson Email & Phone Number

Greater San Diego Area

San Diego, Ca

•Cash – Bank to Books Clear outstanding checks in INTACCT Bank Reconciliation Software, creating outstanding checks listClear deposits in INTACCT Bank Reconciliation Software, preparing proof of cash to assist in researching discrepancies: Deposits not posted, bank posting errors, and deposits in transit•Health Insurance Premiums and Employee DeductionsCreate Pivot Table from Deduction Register of monthly employee deductions for Medical, Dental, Vision, and Life InsuranceUpdate Insurance worksheet for that month’s premiums and apply deductions to audit employee medical reimbursement•Vendor Billing Company ReconciliationsReconcile deposits posted to Billing Company’s Accounts Receivable account to Billing Company’s Deposit RecordsResearch discrepancies through Task System of Billing Company•General LedgerData enter of statistics into Journal Entry TemplateData enter Journal Entry Amounts from Source Reports•DepositsOpen and sort mail, dailySeparate checks and direct deposits by Product LinePrepare Summary Cover Sheets of deposits by Billing CompanyBatch correspondence and checks and Explanation of Benefits by Product LineUse Secure Portal, uploading Deposit Information to Billing Company Use we based deposit system, scanning checks to bankPost checks to proper accounts in INTACCTAcquire daily Bank Activity Report to post EFT’s to INTACCT•Special ProjectsBudgets – in Excel, creating allocation formulas of Budget Line Items to spread across 12 months, created CSV upload file for INTACCT, uploading budget files for several departmentsUpdate Company’s Contract Comparison Files by researching amounts to apply from the Federal Register which changes annuallyAudit Private AR AccountsMonthly filing Financial Statements and Budget to Actual Comparisons in notebooksPrepare Excel spreadsheets of statistical data, creating Pivot Tables of data filesDuplicate and update the parameters of Financial and Budget Reports in INTACCT

San Diego, Ca

• Auditing the Database Updating information, making phone calls for corrections Removing expired data• Event Management and Operations Creating events for Event Calendar  Developing reports of scheduled events Troubleshooting the database• Developing member attendance reports Creating number reports based on attendance by age group Evolving graphs based on the numbers• Updating Children’s Ministry webpage• Office Assistant Work Answering phone/making phone calls Scheduling meetings