EZ 2000 Manual - Accounting

Accounting 

EZ 2000 Plus has built-in accounting that can replace QuickBooks for small offices.
This saves you money and also allows you to use one integrated product without having
to get an external accounting software to manage your books.

In the Manage module, click Accounting.

  • Setup:  This allow syou to setup "linking automated payments" between the main EZ 2000 Plus program and the accounting section
    You may also setup payment links to Quickbooks.
  • Lock:  This allows you to lock all accounting entries on or before a specific date. This helps for example, when you are closing out the year (see below). 
  • Reports: Allows you to generate and print end of year reports.
    - General Ledger Details (generates a list of all transactions from all your accounts)
    - Balance Sheets
  • Add, Edit:  Add new or edit existing account types.
  • Close:  Closes the Accounting window.
  • Chart of Accounts:  Displays a list of account types which are already setup as well as their balance.  To see the balances as they were on a different day, you must enter the date in the As of Date field and click Refresh. You may also click Today to refresh the entire list so that it
    shows the current balances as of today. Check off the Include Inactive Accounts option to show inactive account types as well. 

If you double click on an account you may see the account's Transaction History, and to add or edit its transactions.

Set Up the Chart of Accounts
The term Chart of Accounts is an accounting term. It means a list of the accounts used to organize your finances and split expenses, revenue, assets, liabilities and equity.  If you are not accounting savvy and not familiar with how to set up the Chart of Accounts, EZ 2000 receommends that you  read a book on general accepted accounting principals (like Accounting for Dummies) or ask your accountant.

Click Add to create a new account, or you may select an existing account and click the Edit function.  

Description:  The account description.
Type: The type of account.
Bank Number: Only enter a value for Asset account types.
Inactive:  You may mark account as inactive.  It will then not appear in the Chart of Accounts list, unless you check off Show Inactive Accounts.
Row Color: Use this option for frequently used accounts, set a specific color that this account row will show in. This makes it somple to spot.  Click on the color box to select a color.

Closing Out the Year
There is no need to actually close out. Instead, just lock all accounting entries before a specific date. The User must have the Security Admin Permission  in order to do this.

In the Accounting window, click Lock in the menu.

Enter a date in the box, then click OK. Any entries that were made prior to the entered date will be locked out. 

EZ 2000 Plus never "zeroes out" your accounts. Your asset, liability, and equity accounts all carryover to the next year fully intact. Income and expense accounts will only show the accumulation since the beginning of the calendar year and do not include any previous years.

End of Year Reports
There are two reports which are available in the accounting section. 
- The General Ledger Details (which lists all transactions from every account)
- Balance Sheets

1. Click Reports in the Accounting window menu. Then click on the report.
2. For the General Ledger Details, you should use the calendars to select the date range you want.  For Balance Sheets, choose a single day. 
3. Click OK.

On the Balance Sheet, on the bottom of the Equity section, two values are shown:
- Net Income: Income less Expenses since the beginning of the year for which this report is displayed.
- Retained Earnings: This represents the sum of the Net Income from all prior years.

These are very closely related, and they incorporate the income and expense numbers into this report. These are handled automatically instead of requiring end-of-year entries to zero out the income and expense accounts.  You may still manually enter the closing transactions if you like.  If you choose to do so, when the EZ 2000 Plus software does the automatic calculations, it will just be dealing with zero amounts, so there would not be any effect anyway.

Troubleshooting
If accounts for automatic payments are not set up correctly in the Accounting Setup, then transactions may get attached to invalid accounts. In this case, you may get an error if you try to view old payments. If you follow these steps below, you may identify the problems and fix the erroneous transactions.

  1. Update to version 15.2 or greater. 
  2. In the Main Menu, click Tools, Database Maintenance.
  3. Click Fix.
  4. A message in the log will indicate how many transaction have an invalid account: "Transactions found attached to an invalid account: X.  All invalid transactions have been attached to the account called UNKNOWN, which must be fixed manually." 
  5. In the Manage module, click Accounting.  A new account called "UNKNOWN" will show.  Double click on it to view all transactions attached to an invalid account. 
  6. For each transaction correct the account.
    a. Double click on the Transaction.
    b. Uncheck the Simple box.
    c. In the Splits area, double click on the Unknown account. 
    d. Click Change and select the correct account. 
    e. Click OK to save the change and close the window.

 

  EZ 2000 Plus Dental Software * 800-273-5033