QuickBooks for county bookkeepers

County extension offices use QuickBooks Pro for council financial record-keeping and reporting.

Report due dates

MCHCP Subsidy Report due Jan. 15 and July 15
Export the MCHCP reports in an Excel spreadsheet (XLSX file), send to Tamra Robbins

Annual Revenue and Expense Summary Report
Due at conclusion of end-of-year accounting review. Report will be generated by the QuickBooks reviewer.

Annual Budget Reports - March 1
Export report in CSV format to Excel.
Send to regional director's office.

Training

Mary Ann Horvath provides training and technical support to county bookkeepers. There are designated regional trainers who are experienced with bookkeeping and can provide training or answer questions.

Frequently needed resources

Tools for resolving problems

Quickbooks procedures by topic

General procedures

Balances

Budgets

Submit the annual budget report to your regional director's office by March 1 as an email attachment in CSV format for review and approval.

The approved budgets in CSV format are uploaded to MU Extension before the university's deadline. The information submitted is compiled into statewide totals for both internal review and federal reporting. FTEs supported at the County level are also reported with the budget each year.

Checks

Checklists

Monthly

End-of-year

Credit cards

MU Off-Campus Credit Card  System

QuickBooks Merchant

General

Deposits

End-of-Year

Payroll

Payroll plan subscriptions

Payroll plan subscribers

Non-payroll plan subscribers

Enhanced payroll subscribers

Payroll taxes and forms

Payroll tax and benefit liabilities

Paycheck corrections

Payroll Voucher

Payroll summary report

Instead of using the Payroll Voucher forms, Bookkeepers can create a Payroll Summary Report for each employee. Under Employee Center, select employee name and click Payroll Summary at top right corner of screen. 

Reports

Quick Reports — Look for the Quick Reports button in most screens, or right click on the item name and left click on Quick Report.  Quick Reports may be created for:

  • Customer (Exception:  A customer transaction created directly in the Make Deposit screen may not display in a Quick Report. This "glitch" has been reported to Intuit.)
  • Vendor, Employee, Class, and Account.

The following reports are recommended for validating monthly financial data:

Funds Class Balance Report
Balance Sheet (compare to Funds Class Balance report)
Unclassified Transactions (for error checking)

Report configuration

Transfers

How to transfer money from one bank account to another bank account; one class to another class; one revenue account to another revenue; one expense account to another expense.

eof