CID Accounting Setup

Modified on Mon, 20 Jul 2015 12:28 by tpaeglis — Categorized as: General Ledger

Table of Contents [Hide/Show]


General Information

Default Menu Location Maintain >> System >> CID Maintenance

Screen Name CID

Function The Company ID (CID) Maintenance Screen is used to maintain general system and accounting information for your company. For further detail on CID options throughout the set up see the CID Setup Options page.

Accounting Backend

The Accounting Backend tab contains information about a third party accounting package if one is in use.

The Posting Window field controls when transactions can be posted in the system. Any transaction (invoice, cash receipt, check, inventory transfer, production, etc) must be executed with an accounting date that falls within the posting window.

Click here for CID Accounting Backend Screen

Fields

Name: Name of the accounting software

Backend Type: Server type

Path to SYS Files: Location of accounting software on server

Company ID: ID of the company in accounting software

Database Name: Name of the accounting database

WIP Account: Work in Process account number

PR Clearing: Payroll Clearing account number

Equip Clearing: Equipment Clearing account number

Path to PR SYS Files: Location of payroll software on server

PR Company ID: ID of company in payroll software

PR Database Name: Name of the payroll database

Posting Window: Transactions may only be posted within the dates entered here.

Default Costing Method: The costing method that Adjutant will use to value your inventory.

Accounts

The Accounts tab contains the system default GL accounts for many different transactions.

It also allows you to setup the GL Mask and Number of Periods in a Fiscal Year.

The GL Mask determines the account structure (how many segments and how many digits within each segment).

You must set up the GL Mask before doing anything else in the General Ledger. You will not be able to change the mask or number of periods after they've been saved.

Click here for CID Accounts Screen

Clearing

Work in Progress: The default WIP account for Production and Job Cost. WIP helps us define live snapshots of our inventory value. We use it to capture inventory items in between shipments and production.

Payroll: Payroll clearing account.

Equipment: Equipment clearing account. This is the accrual account for the cash amount of the asset transactions.

Inventory: Clearing account used in Inventory Adjustments. This is the accrual account for the cash amount of the inventory transactions.

Purchase Orders: Clearing account used between PO Receipt and AP Invoice entry. This account is also commonly referred to as Accrued AP.

Suspense: Suspense account used if the batch generator cannot match a transaction to a valid GL Account.

Over/Under Billing: Revenue contra account for draw billing transactions from Project Control. Difference between Over/Under Billings and Variances: Over/Under Billings are only for Projects/Job Files. Variances are catch-all’s for regular, every day transactions. (The same account can be used for both of these.)

Retainage: Clearing account for retainage billings from Project Control. Retainage is used primarily in the construction industry. Means that you do not have to pay the entire amount due when buying or selling. Ex: If you build a 4 story building that won’t be done for 2 years, only 30% of the steel is purchased initially, then the rest is paid when the building is completed. (Allows a company to do business even if they don’t have the cash flow to support it.)

Retained Earnings: Earnings account for year end close.

Accounts Payable

Payables: The default AP account for all AP Invoices. This account is always used unless another account is specified on the Sold From screen.

Discounts: Discounts taken on AP invoices.

Adjustments: Adjustments made to AP invoices.

Checking: Default checking/cash account when Approving AP Invoices and Printing AP Checks. Also the default account in the Bank Rec.

Purchase Variance: Default variance/balancing account when PO Receipt does not match AP Invoice amount.

Prepay Expense: The default Prepaid Expense account when printing a prepaid check.

Accounts Receivable

Accounts Receivable: AR account for all AR Invoices. This account is always used unless another account is specified on the Bill To screen.

Sales Tax: Default Sales Tax account for AR invoices. This account will be used unless another account is specified in the STATES rule.

Cash Receipts: Default Checking/Cash account for cash receipts.

Payment Discounts: Discounts taken on AR Invoices.

Payment Adjustments: Default adjustment account during cash receipts.

Fiscal Calendar

The fiscal calendar shows each accounting period per fiscal year.

The Current Year and Current Period fields show the corresponding information according to what periods and years have been closed.

You can close a Period/Year by going to: Transaction >> General Ledger >> Close Period/Year.

To set up a new Fiscal Year, type the year in the Fiscal Year field and click Yes when asked if you want to add the year. Fill out the calendar according your company's fiscal calendar or simply click the Fill out DefCalYear button to fill out the calendar according to a normal calendar year.

Click here for CID Fiscal Calendar Image