Cost of Sales Account
Enter the cost of sales account to be used for this inventory item. If this ledger is departmentalized, you will also see:
Dept Filter Type (0,1)
Enter 0 if you do not want to use a department filter. Enter 1 if this calculation should be applied only to sales account(s) for a specific department.
Department Filter
If you selected a department filter, enter the appropriate department number here.
If you selected Calculation Type 2 above:
Beginning Inventory Account Purchase Accounts: From…To Ending Inventory Account
Enter the beginning inventory account, range of purchase accounts, and ending inventory account. If there is only one purchases account, enter the same account at both the from and to prompts. If this ledger is departmentalized, you will also see:
Dept Filter Type (0,3)
Enter 0 if you do not want to use a department filter. Enter 1 if this calculation should be applied only to sales and purchase accounts for a specific department. Enter 2 if only sales accounts should be filtered by department. Enter 3 if only purchase accounts should be filtered by department.
Department Filter
If you selected a department filter, enter the appropriate department number.
Accept or Escape? (A,Esc)
Press A to accept the account ranges, or press Esc to return to the Revise Basic Ledger Setup Information menu.
Inventory calculation 1 has been updated.
CLS updates the inventory calculation and returns to the Calculation No. prompt. Press Esc to return to the Revise Basic Ledger Setup Information menu.
Define Income Tax Calculations (6)
Use this routine to define estimated income tax calculations (federal, state and other) for the current ledger. To use these calculations, select program CT, Menu Selection 6, to create the estimated income tax transactions each period. The tax transactions will be created in reverse order so, for example, net income can be adjusted by the calculated state tax before the federal tax is computed.
For each of the tax calculations you wish to use, respond to the following prompts:
Tax Table I.D. … or Tax Rate
Select the tax table to be used for the calculation, or simply enter the tax rate to be used (as a percentage, not a decimal).
Notes:
• A federal tax table has already been defined for you using program SI, Menu Selection 6. You must define state and any other tax tables you need before they can be used here. • The standard federal tax table I.D. is “**”. Use “*1” … “*9” as the I.D.s for alternate federal
tax tables.
• The standard state tax table I.D. will be the state’s postal code (e.g., CA, GA, TX). Alternate state tax tables I.D.s must begin with a letter (e.g., C1, G1, T1).
• Tax table I.D.s for the Other tax calculation must be numeric.
Description
Enter a description (up to 15 characters) to be associated with this calculation. Calculations which are based on a tax table will use the Tax Description given to the table. Calculations which are based on a tax rate will use the description entered here.
Expense A/C
Enter the expense account to be used when the transactions are created in the CT program.
Liability A/C
Enter the liability account to be used when the transactions are created in the CT program.
Net Income Adj
If you wish to adjust the net income on which the tax calculation should be based, enter the amount of the adjustment here. Use (+) for an amount which should be added to net income; use (-) for an amount which should be subtracted from net income. If the amount entered is below $1.00, (e.g., 0.75), the tax calculation will be based on a portion of net income (e.g., 75%); the sign will be ignored.
Tax Adjustment
If you wish to adjust the tax which has been calculated, enter the amount of that adjustment here. Use (+) for an amount which should be added to the computed tax, or (-) for an amount which should be subtracted from it.
Ledger Initialization (LI) 1-85
Deduct Before (0-1) or (0-3)
For state and other taxes only: Indicate whether net income should be adjusted be the amount of this tax before computing the next tax. Enter 0 if you do not want net income adjusted. Enter 1 (the default) if you do want net income adjusted. For other taxes only: Enter 2 if only the federal tax calculation is affected; enter 3 if only the state tax calculation is affected. Press F1 for your choices.
Excl. H-Opt A/C
Enter Y (the default) if you want to exclude from the tax calculation any accounts which you assigned an H option in program MF, Menu Selection 1, (e.g., Officers Life Insurance, Penalties, etc.). Enter N if you do not want these accounts excluded.
Limit Tax Credit (Y,N)
In the event of a loss, you may cap the amount of any tax credit which might be generated by the
CT program. Enter N (the default) if you want CLS to generate a tax credit for any losses which might occur. Enter Y if you want to place a limit on the calculated tax credit.
Maximum Credit
If you answered Y to Limit Tax Credit, enter the maximum tax credit CLS is allowed to generate. If you don’t want CLS to calculate any tax credits, enter zero.
Minimum Tax
If there is a minimum tax amount due, regardless of net income, enter the minimum tax here.
Zero if below
If the tax owed is assumed to be zero if the computed tax falls below a certain minimum, enter the minimum amount here.
Accept or Escape? (A,Esc)
Press A to accept the changes, or press Esc to return to the Revise Basic Ledger Setup Information menu.
Define Special Format P&L's (7)
If you plan to print a Special Format Income Statement on a recurring basis using Batch Processing (BP), use this selection to enter the format. The Special Format P&L also allows access to history and budget amounts by period. You may reference specific and relative (trailing) periods for current period and year-to-date balances.
Special Format (1-4)
Select the number of the first available format. Press F1 to select from a pop-up list.
Format Description
Format
Enter the report format, or press F1 to select from a pop-up list of format options. Following are the special format P&L column codes and the codes which allow you to access budget and history amounts by period:
Current Period Balances:
@b (Budget) e.g., This Year: @b1, @b2...@b12
Relative: @b0, @b-1, @b-2, etc.
@l (Last Year) e.g., @l1, @l2...@l12, etc.
@p (By Period) e.g., This Year: @p1, @p2...@p12
Relative: @p0, @p-1, @p-2, etc.
Year-to-Date Balances:
@B (Budget) e.g., This Year: @B1, @B2...@B12
Relative: @B0, @B-1, @B-2, etc.
@L (Last Year) e.g., @L1, @L2...@L12, etc.
@P (By Period) e.g., This Year: @P1, @P2...@P12
Relative: @P0, @P-1, @P-2, etc.
Notes:
• You may use numbers between one and nine as codes to insert spaces between columns on
a special format P&L. For example, the format 99AB will produce a year-to-date-only P&L with 18 additional spaces between the account description and the year-to-date columns. • A colon (:) may be used to sum current period balances for a range of periods (e.g., @p1:3
sums periods 1-3, @p-2:0 sums the last three periods).
Special Format P&L Column Codes
Current Period Code Column Description Year-to-Date Code
a THIS YEAR Current period A
b THIS YEAR Current percent B
c THIS YEAR Current ratio C
d LAST YEAR Current period D
e LAST YEAR Current variance E
f LAST YEAR Current variance % F
g LAST YEAR Current percent G
h LAST YEAR Current ratio H
i BUDGET Current period I
j BUDGET Current variance J
k BUDGET Current variance % K
l BUDGET Current percent L
m BUDGET Current ratio M
n TOTAL BUDGET Current period N
o TOTAL BUDGET Current variance O
p TOTAL BUDGET Current variance % P
q TOTAL BUDGET Current percent Q
r TOTAL BUDGET Current ratio R
Ratio Description Current Ratio Divisor YTD Ratio Divisor
If the Special Format Income Statement for this ledger will contain ratio columns, you may enter a ratio description (up to 25 characters) and current and year-to-date ratio divisors (0-
Ledger Initialization (LI) 1-87 office space, to get a dollar breakdown per square foot. If the ratio divisor is zero, the ratio
description will not be printed on the financial statements. If you prepare a Special Format P&L with ratio columns and you use a zero ratio divisor, the ratio columns will default to percent of sales.
Note: Separate P&L Ratio Divisors/Descriptions are available for Departmental Income
Statements (see program DF).
Ratio Decimals (1,2)
Press 1 if you want ratios to be shown to one decimal place. Press 2 if you want two decimal places.
Accept or Escape? (A,Esc)
Press A to accept the report format. Press Esc to return to the Special Format (1-4) prompt without updating the format.
Format '1' has been updated.
CLS updates the report format and returns to the Special Format (1-4) prompt. Press Esc to return to the Revise Basic Ledger Setup Information Menu. Press Esc again to return to the LI
menu.