The ClerkBooks Desktop Edition consists of:
Click each header for a full description.
- General Ledger / General Journal
- Accounts Receivable
- Accounts Payable
Discount! Cities who already use QuickBooks may qualify for a discount. Ask your ClerkBooks Representative for more information.
While QuickBooks is the #1 small business accounting software package, it is not designed for Local Government right out of the box. Therefore, we have created a custom file for Local Government including a Chart of Accounts as recommended by your State Auditor’s Office along with Fund tracking capabilities.
We have also added: a custom payroll system to split wages into the appropriate expense lines and funds; several memorized transactions for non-recurring transactions such as bounced checks, as well as recurring transactions such as property tax deposits; Over 30 custom reports categorized for municipal use; several custom items for utility billing invoices and detailed revenue tracking.
Our custom file works in-sync with our Utility Billing Module and Closing Tools Module. By creating this custom file, we have converted QuickBooks into a full-function Fund-Based Municipal Accounting System.
Discount! The first City in a new State or Country receive additional support at no extra cost. Ask your ClerkBooks Representative for more information.
The Custom QuickBooks File expands upon the QuickBooks Payroll System giving you the power to split payroll between different Functions, Departments, Objects and Funds – all on one paycheck!
- Calculates gross wages from hours or annual salaries.
- Calculates Federal and State Withholdings, Medicare, Social Security, retirement, health insurance, child support and other optional deductions to accurately calculate Net Pay.
- Tracks available vacation and sick time.
- Includes direct deposit for paychecks and tax payments
- Prints 941s, W2s and other payroll forms on plain paper
- Electronically submits Federal and State forms and payments for you.
- Sets reminders for tax payments & form filings
- Includes 24 hour Free support from payroll experts
The Custom File and the Enhanced Payroll Subscription gives you the added security that your payroll is compliant with current tax laws.
(Debit Card, Credit Card, or Direct Bank Draft is Required for Monthly Billing)
The Utility Billing Module works in connection with QuickBooks. All customer information is entered into QuickBooks, then synchronized with the Utility Billing Module, thus eliminating the need for, and errors of, a dual entry system.
The Utility Billing module features a spreadsheet-like tool for entering in readings manually. The module also syncs with all handheld reader systems such as Badger and Sensus, so you can import bulk readings easily.
The Utility Billing Module calculates usage and rates, including minimum charges and tiered utilization levels, based on multiple customer types. The system also calculates late charges, surcharges and discounts. After making calculations, just one click sends the invoices back to QuickBooks to be printed. QuickBooks then manages all customer payments and deposits.
QuickBooks is the world’s #1 accounting software for small business. However, it was not designed for municipal Fund accounting. It does not follow Governmental Accounting Standards Board (GASB) directives. Therefore, the database structure and the coding does not complete all the necessary accounting steps. ClerkBooks has done everything we can within the QuickBooks software to make it meet GASB directives. We have:
- added a custom chart of accounts designed specifically for each state and streamlined for every municipality
- added custom Items for utility billing and payroll to match the custom chart of accounts
- added custom reports for Council, Auditor, and State reporting
However, this is still not enough.
The following document describes the Fund Accounting issues that QuickBooks has. It also describes how the Closing Tools module was created to finish the Fund Accounting tasks that QuickBooks cannot do on its own: Closing Tools Information
During your remote set-up and customization, we work hand-in-hand with your City Clerk, Finance Officer, and Auditor to make sure that the ClerkBooks Municipal Accounting System is ready to work for your City specifically. While ClerkBooks has the full chart of accounts designed for the largest cities in your State, we work directly with you to scale it back to be applicable and easy to use within your municipality.
All you need is a compatible computer, high speed internet connection, and a phone with hands-free capabilities. We will need remote access to your current systems, as well as access, via text or short phone calls, to your City Clerk, Finance Officer, and Auditor for periodic assistance.
Data Conversion includes importing and converting: customer billing & meter accounts, utility rates, customer beginning balances, sales tax & payroll items, employee records including year-to-date payroll information, beginning bank and fund balances, current fiscal year budgets, and more.
Remote Customization includes: streamlining the chart of accounts, utility bill invoice design, Council report design, and more. We sometimes get a month or two worth of accounting done in the system as well. (depends on timing of install within your current fiscal year)
Remote Orientation includes: one-on-one remote review of your specific accounting system including your chart of accounts, budget, payroll, paying bills, utility billing, making deposits, closing the month, and preparing reports for the Council. Orientation is spread across 3 days, over 3 weeks, during your first month of using the new system. Everyone learns by repetition. This approach allows you to learn the system, use the system, learn, use and learn again, as we try our best to help you get comfortable with the system.
(On-Site Set-up & Customization is also available)
All of the general training from our 2-Day On-Site Comprehensive Training course compressed into 45 4-10 minute videos. The videos allow you to skip to specific topics as needed. They are great for learning at your own pace, or as a refresher after installation.
Log into our online knowledge base to access step-by-step instructions on everyday accounting tasks. Enter a phrase describing what you want help with and the system gives you the top articles related to your question. You also have the ability to print individual topics as your own personal set of “cheat sheets.”
Your Council will have access to 2 hours of video training focusing on understanding the financials, using the financials to make informed decisions, and preventing and monitoring fraud.
Municipal accounting has never been easier!