CDK Accounting

Main Menu

The Main Menu is the starting point in the program from which each user can log in and then, depending on the permissions assigned to that user, perform any of the program's many functions.

Purchasing

The Purchasing screen is used to create, view, edit, and print purchase orders.

Select Purchase Orders to View

This Window is used to select which purchase orders are to be viewed in the navigation pane. Purchase Orders can be selected based on vendor, year, payment status, or other factors.

Edit Purchase Order Lines

Hitting the "Edit PO Lines" button on the Purchasing Screen will display the "View and Edit PO Lines" window. This window provides more detailed information and allows you to edit, delete or add lines to the current purchase order.

Edit Purchase Order Line Details

This Window is used for adding details to purchase order lines. The system automatically calculates the total of the line details, and sets the amount of the purchase order line to that total.

Expense Reclassifications

This window is used to reclassify expenditures. Expense reclassifications can be viewed and deleted from this window as well.

Accounts Payable - Checks

The View Checks Tab on the Accounts Payable screen is used to create, view, edit, and print checks and non-checks. Unpaid purchase orders can be displayed and paid from this tab. Checks can be written against purchase orders, balance sheet accounts, or a combination of both.

Mark POs for Payment

Create Check Run

Original Budget

The Original Budget tab on the Budgeting screen provides an extremely user-friendly method of entering expense and revenue budgets as well as entering/modifying balance sheet opening entries. Simply double-click on any original budget or opening entry amount and then enter the new value.

Budget Adjustments

The Budget Adjustment Tab in the Budgeting screen is used to enter budget adjustments. Appropriations of fund balances, increase/decrease in revenues, and expenditure account transfers are all entered on this tab. All budget adjustments in the system can be displayed, sorted by date, or only those affecting a certain expenditure or revenue account can be displayed at the user's request.

Deposits

The deposit screen is used to record all deposits. There is no limit to the number of line items that can be included on a single deposit.

Journal Entries

This window is used to create journal entries. Journal entries can also be viewed and deleted from this window.

Payroll Merge

The payroll merge function of CDK will allow you to import your payroll data directly from your payroll company's data files or from a data disk provided by your payroll company for this purpose. When using the payroll merge function, the check or non-check expenditure will automatically entered into the system. The system can automatically adjust any line in your payroll purchase order that is not sufficiently encumbered for the current payment.

Revenue Accruals

This window is used to create reveune accruals. Accruals can also be viewed and deleted from this window.

Invoices

the invoices tab of the invoicing screen is used to create, edit, view, print, and delete invoices. You can view the payments made against the invoice, including the date and check number, on a tab at the bottom of the window.

Receive Payments

This tab on the Invoicing screen is used to receive payments agains invoices. When you receive payments, the receivable is cleared and funds received are placed in "Cash on Hand" (Balance Sheet 102). When receiving payments against invoices, the system will warn you if the payment date is earlier than the invoice date and offer to change the invoice date.

Vendors

The Vendor screen allows all information to be added about the vendors. This information is used for the printing of Purchase Orders and Checks as well as for recording the source of cash receipts. A list of all vendors sorted either by Ordering Name or Vendor Number can be printed from the Vendor screen.

Special Vendor Actions

The Special Vendor Actions window is accesed from the Vendor window, and can be used to delete large numbers of vendors as well as to print mailing labels and file labels.

Merge Vendors

Using this window, duplicate vendors in the vendor list can be merged into one vendor with all of the activity that was recorded for each of the original duplicate vendors.

Current Data Reports

With "Current Data" selected on the Reporting screen, users can view reports that can be printed reflecting the current status of accounts. All of the transactions (purchase orders, checks, deposits, etc.) are posted to the current data file as they are entered. The CDK Accounting user may at any time view the reports to instantly see the districts current financial status.

Special Reports

The "Special Reports" tab contains various reports that are infrequently run but are useful for finding a particular piece of data, checking for overexpended accounts, finding improperly entered data, etc.

Historical Data Reports

The "Historical Data" tab provides the ability to post the districts data to some date in the past (usually the end of the previous month) and print a complete board secretary's report or any of its components as well as some reports with additional levels of detail.

Reports - Print Transactions

The "Print Transactions" tab allows the CDK for Windows user to print lists of virtually any type of transactions that have been entered into the system. Most of these lists are selectable by date. Some are also selectable by status (such as PO status). Many options have been added to these reports to meet the needs/wishes of all of our users.

Status Reports

The "Status Reports" tab provides detailed status of expenditure, revenue and balance sheet accounts as well as vendor histories.

Invoicing Reports

The "Invoicing Reports" tab allows you to view, print, and export invoices, as well as to view and print statements.

Auditor Reports

The "Auditor Reports" tab provides allows you to view and print various reports needed for auditing.

Search Reports by Name

Charter School Reports

Charter Schools will see an additional tab on the reports menu. From the "Charter Schools" tab, they can print a 108 Line Budget to Actual report and the Cash Flow Forecast.

Ship To

This window is used to enter and update the "Ship-to" addresses for use on Purchase Orders.

Edit User List

This screen is used to create, edit, and delete user accounts, as well as to assign user permissions and reset passwords.

Restricted Users

This window is used to assign expense account permissions to resticted users. All restricted users have their own list of expense accounts that they are allowed to access.

Export Data

This screen is used to export CDK data to an excel spreadsheet.

Vendor Certifications

This screen is used to create, view, edit, and delete vendor certifications.

Change Password

This screen allows users to change their passwords.

Edit Fund List

The Edit Fund List utility is used to add, change, delete, and move funds. This window is also used to select which funds are included on certain reports.

Charter Schools - Budget to Actual

The "Budget to Actual" utility allows you to view and edit your budget to actual statement.

Charter Schools - Cash Flow Schedule

The "Cash Flow Schedule" utility allows you to view and edit your cash flow schedule.

Complete Board Secretary's Report
The Complete board secretary's report can be printed for any fund and includes the balance sheet, revenue/sources, expense summaty, revenue summary, and minimum expense ledger. All of these reports are combined and presented in the format recommended by the state when converting to GAAP in 1993. This report can include an individual fund or

S1710 Transfer Analysis
This report shows the percentage of the Original Budget transferred in or out. The report will show the remaining amount which may still be transferred without exceeding the 10% limit. Calculations reflect the limitation of transfers in as well as out.

Available Balances
The available balances report will print the current available balances for all current expense funds or by everextended current expense funds. Users can select which funds and locations to run the report for. The information in the report includes the current expense fund, account title and available balance.

Cash Status
The cash status report gives the current status of cash for a given balance sheet fund or for all funds combined. Cash account activity to date is summarized. The information presented includes the year opening cash balance, total receipts to date, total payments to date, and the current cash balance. The current cash balance is the broken down to show the current Capital Reserve deposits, long-term investments, short-term investments, and cash in checking.

Show PO Lists
The show PO Lists report can be used to show a wide variety of PO lists. When you click on the report, another window sill open where you will chose the options for your report. You can choose whether or not to include Open and Incomplete POs, Paid POs, All Payables, or Unpaid Payable only. The report can also be limited by PO Date, PO Number, Contact, and PO Amount.

Show Check Register
This report shows a list of checks for a given period of time. You can select to print the check register for a single fund, or any number of funds. The check register lists all selected checks by date and check number. Alternately, the list can be printed and sorted by vendor ordering name. At the end of the report, there is a subtotal of all checks by fund, and a grand total of all checks for the period.

Combined Deposit/Refunds
This report lists all cash receipts for any specified period of time for any or all funds. The information presented in this report includes date, deposit and/or account number, account title, amount, vendor name, and comments. All cash receipts are subtotaled by date. At the end of the report a subtotal is given for each balance sheet fund, and a grand total of all cash receipts.

Show List of Budget Adjustments
The list of budget adjustments provides a list of all transactions directly affecting the budget. This does not include the Original budget or prior year encumbrances. Included on the report are the date of adjustment, source account, target account, amount of adjustment, and comments. You will be prompted for a date range for included transactions, and whether or not to only include board-approved budget adjustments or not.

Show Invoice List
The list of invoices provides a list of invoices for any or all vendors. You will have the option to choose if you want to only include invoices that are not paid in full, and whether or not you want each vendor on a separate page. The report shows the invoice number, Date, Ordering Name, Revenue account, Receivable, Line Amount, and Description.

Show Reclassification List
This Report shows a list of transactions directly affecting expenditure accounts that were reclassified. This report gives you the option to choose a date range. The report will show the Date, PO number effected, Ordering Name, Amount, and Reclassification Details and Comments.

Single Expenditure Account Detail
The single expenditure account detail shows beginning budget, changes to budget, and the current budget of the selected account. All PO lines and check lines are printed. The records are arranged so that the check lines are printed directly below the PO lie they are paying; all refunds to the expenditure account are shown last on the list. PO amounts, check amounts, and refunds are all totaled and the outstanding encumbrances and available balance are printed.

Revenue Account Detail
The revenue account detail lists all transactions affecting the budget of the revenue account along with all deposited or accrued revenues for the account. Actual revenues are compared with budgeted revenues in order to show any amounts still expected or overages.

Balance Sheet Account Detail
The balance sheet account detail shows all transactions that directly affect a balance sheet.

Activity Report for All Vendors with over $X in Activity
This report allows the user to select an amount, and then prints the activity for all vendors with activity totaling more than that amount. Specified vendors can be excluded (such as the payroll PO and Utility PO).

1099 Vendor Payments

Prior Year Payables Details
The prior year payables details report will print out a detail report on all payables that were carried over from the previous year. You have an option to give an amount the payable must exceed in order to be included on the report or enter a zero to include all prior tear payables.

Prior Year PO Details
This is a detail report on all encumbrances that were carried over from the previous year. You have the option to give an amount that the payable must exceed in order to be included on the report.

PO Payments Over Original Amount
This report will show any payments made in excess of the originally approved PO amount. The report includes all payments made within a selected date range. Specified vendors can be excluded from the report. You can include an approval signature line at the end of the report.

Charter School Budget to Actual Report

Charter School Cash Flow Report