Click here to return to Accounting Menu
*** OUTLINE ***
Pretty Good Accounting System
Version 2.0 (C) May 1999
by Duane Bristow, Albany, Kentucky
1. Posting - data input?
1 Enter Transactions? (see Figure 1-1)
2 Delete Transactions?
3 Print Transactions?
4 Pay employees? (see Figure 1-4)
1 General Info?
2 Payroll Constants?
3 Tax w/h Constants?
4 Other w/h Constants?
5 Pay Employee?
6 Next Employee?
5 Print trial balance?
6 Post transactions to main accounts?
7 Rename temp. transaction file?
8 Pay payables?
9 Copy or paste transaction file?
10 Use Special input screens?
1 Access Invoices?
2 Access Time Accounts?
3 Access Inventory Received Screen?
4 Access Inventory? (see Figure 1-10-4)
5 Access Product Sales?
6 Access Log Tallies?
7 Read MDAS daysheets?
8 Access Purchase Orders?
11 Change transaction dates?
12 Reconcile bank account?
13 Access Group Transactions?
14 Trial balance by profit center?
15 Post employer's share & sales cost?
2. Reports?
1 General Ledger?
1 Balance Sheet? (see Figure 2-1-1)
2 P&L Report? (see Figure 2-1-2)
3 Audit Trails
1 Bank Account Checks (see Figure 2-1-3-1)
2 Bank Acct Ck detail
3 Payroll Cks. detail
4 Payroll Date/Emp.
5 Payroll Date/Acct.
6 Payroll Acct/Emp.
7 Payroll Acct/Date
8 Payroll Emp./Date
9 Payroll Emp./Acct
10 General Ledger
11 Audit trail 11
12 Audit trail 12
13 Audit trail 13
14 Audit trail 14
15 Audit trail 15
4 Financial Analysis & Sales Margins?
5 General Ledger?
2 Payroll?
1 Employee Payroll Report?
2 General Payroll Report?
3 Employee List?
4 Retirement Report?
3 Vendor?
1 Vendor Report? (see Figure 2-3-1)
2 Bill Vendors? (see Figure 2-3-2)
3 Vendor List? (see Figure 2-3-3)
4 Aged Accounts Report (see Figure 2-3-4)
5 Overdue Form Letters?
4 Taxes?
1 Sales Tax?
2 1099s?
3 Unemployment?
4 W-2s?
5 Cash flow & Budget?
1 Cash Flow Needs Projection?
2 Payables Report?
3 Budget Report?
6 Trend Charts & Special Reports?
1 Recent Trends?
2 Long Range Trends?
7 Inventory Reports?
1 Inventory Lists?
2 Order lists?
3 Sales Margins?
8 Status Report?
3. End Period? (see Figure 3)
4. Utilities?
1 Edit general info? (see Figure 4-1)
2 Edit help screens?
3 Reindex system?
1 Vendors?
2 Accounts?
3 Employees?
4 Transactions?
5 Inventory?
4 Add employee vac/sick time?
5 Update w/h tax tables?
6 Access GL chart of accounts?
1 Print Chart of Accounts?
2 Add New Account?
3 Edit Account?
4 Review transaction index?
5 Review $, QT. and Numbers?
6 Review Budget?
7 Save or Restore GL order code scheme?
7 Set budget?
8 Edit billing messages?
9 Review main transaction file?
10 Copy from main transaction file?
11 Edit flags? (see Flags below)
12 Edit Constants? (see Constants below)
13 Set security levels?
14 Name profit centers?
15 Edit sales tax rates?
16 Change Vendor's Carrying Charge Rate?
17 Erase Vendor Billing Recording?
18 Access auxillary Utilities?
5. Index to data input & reports?
Use [F1] and Shift F keys 2-10 for help screens.
******************************************************************************
Figure 1-1
JOE'S OLD SHOE SHOP:GUEST - T- Posting Screen 9/99
TR# .DATE. ..TYPE.. CHECK# ..AMOUNT.. ..ACCT.. VENDR PC. QUANTITY NUMBER TX
1 090299 BA 0.00 PE 0 0 0.00 0
Previous Earnings 000000 0 0
Bank Account - Previous Earnings
AMOUNT 0.00 CHECK #
[F9] - FIELD, [SHIFT TAB] - CALCULATOR
ARROWS TO MOVE, [HOME], [END], [ESC], [F1] FOR HELP
******************************************************************************
Figure 1-4
Employee: Doe, John Last Paid 00/00/00 Record 1
Active Y Profit Center 0
Standard Hours 40 Overtime Multipler 1.50
Salary 0.00 Hourly rate 6.00 Piecework rate 1.00
Cash account for net payments BA - Bank Account
Labor Account PAYROLL - Payroll
Accumulated per period
Sick hrs. 0.00 0.00
Vacation hrs. 0.00 0.00
Retirement type (H, R, blank)?
==============================================================================
Date Pd End Date Check # Piecework Hrs. Reg Hrs OT hrs
09/02/99 09/02/99 0.00 40.00 40.00 0.00
$ Salary Hourly Piecework Regular Overtime $ Gross
0.00 240.00 0.00 240.00 0.00 240.00
Tax w/h Federal State FICA MC
17.40 8.82 14.88 3.48 44.58
Deducts D1 D2 D3 D4 D5 D6
0.00 0.00 0.00 0.00 0.00 0.00 0.00
Remarks: Doe, John Net 195.42
Hrs. 40.00 0.00 $ vac. 0.00 sick 0.00 hol. 0.00 other 0.00
******************************************************************************
Figure 2-1-3-1
Bank Account Checks
Output to SCRN
FILTER:
Beginning date 090199 Ending date 090299
Beginning acct 103.00 Ending acct 103.00
Vendors to include: [BLANK] for all, 0 for N/A, or categories
Vendors to exclude: [BLANK] for none, 0 for N/A, or categories
Profit Centers to include: follow numbers with commas, [BLANK] for all
Profit Centers to exclude: follow numbers with commas, [BLANK] for none
Remarks strings to include, [BLANK] for all
Remarks strings to exclude, [BLANK] for none
Sources, follow numbers with commas
SORT:
First Sort Field: Check number
Second Sort Field: Date
REPORT FORMAT:
WDT2SHT-
[ENTER] to begin audit trail, [ESC] to abort. -----
[UA] to edit, or [HOME] for top, [F2] to reset to standard.
******************************************************************************
Figure 2-1-1
Balance Sheet
Output to SCRN
[T]ype or [A]ccount A
Level 1-8 8
2nd column Preceding Period
3rd column Difference
Beginning # months back 1
[P]ause at end of each page, [W]ide printout.
------
******************************************************************************
Figure 2-1-2
Profit & Loss
Output to SCRN
[T]ype or [A]ccount A
Level 1-4 8
2nd column YTD
3rd column Av. last 12
Beginning # months back 1
Ending # months back 1
[P]ause at end of each page, [W]ide printout.
------
******************************************************************************
Figure 2-3-3
Vendor List
Prompt for next printer page? N
Filter:
Include categories, [ENTER] for all
Exclude categories, [ENTER] for none
Include search string, [ENTER] for all
Exclude search string, [ENTER] for none
Business since date
No business since date
Sort:
[blank] for Alpha, or $ business since date
Include:
Vendor [N]umber [C]ategory [P]hone [T]in [O]wed
[A]ddress [E]mail address [R]emarks
Use A only for mailing label format NCPT
Output to SCRN -
[S]creen, [P]rinter, or [D]isk
******************************************************************************
Figure 2-3-2
Billing Vendors
Add next months carrying charges? N
Minimum billing amount? 5.00
Bill format [I]nvoice #, [Q]uantity, [3] column?
Prompt for next printer page? N
Print 130 characters per line? N
Beginning Vendor record # 1 - 50? 1
Ending Vendor record # 1 - 50? 50
Record bills (Y/N)? N
Output to SCRN
******************************************************************************
Figure 2-3-1
Vendor Report
1 Doe, John
Summarize by Category [O] summary only
Prompt for next printer page? N
[I]nvoice #, [Q]uantity
Beginning date 010185
Ending date 123150
Output to SCRN -
Remarks:
******************************************************************************
Figure 2-3-4
Aged Accounts
Prompt for next printer page? N
Sort by Alpha, Total owed, month back 1-9? A
Output to SCRN S
Categories, [ENTER] for all
******************************************************************************
Figure 3
|--------------------------------------------------------------------|
|ENDING MONTH SEPTEMBER 1999 |
| |
|BE SURE THAT: |
| No other user is using the system. |
| Bills to vendors have been printed. |
| All temporary transactions have been posted to the main accounts.|
| Current backups have been made. |
| Vendor files are properly flagged for carrying charges. |
| Periodic entry files have been updated. |
| All necessary reports have been printed. |
| Balance Sheets. |
| P&L Statements. |
| Payroll Reports. |
| Aged Accounts Reports. |
| Audit Trails. |
|--------------------------------------------------------------------|
******************************************************************************
Figure 4-1
Company Name: JOE'S OLD SHOE SHOP
Address line 1:
Address line 2:
Address line 3:
City: State: ZIP:
Phone:
Federal TIN:
State TIN:
Other PIN:
email:
URL:
Disk output:
******************************************************************************
Figure 1-10-4
Inventory 1
Code: PRECON Description: PRECONDITIONING CHOW
Units: BAG Sales Tax: Flag N Reason code
UPC number:
Accounts: Sales FEED Inventory 120.05 Cost of Sales 420.05
Source: PURINA MILLS, INC. Category: A
Vendor's Order Number: 3152C2H Order conversion multiplier: 1.0000
Date of last order: 07/17/00 Current cost each unit sold: 5.160
Sales price each: 6.450 Special:
Units on hand: 105 order kicker: 12 full stock: 96
Total Inventory cost: 541.80
Month back: 1 2 3 4 5 6 7 8
Units: 161 85 0 0 0 0 0 0
Sales: 1036 663 0 0 0 0 0 0
Month back: 9 10 11 12 13 14 15 16
Units: 161 85 0 0 0 0 0 0
Sales: 1036 663 0 0 0 0 0 0
Month back: 17 18 19 20 21 22 23 24
Units: 161 85 0 0 0 0 0 0
Sales: 1036 663 0 0 0 0 0 0
******************************************************************************
*** FLAGS ***
Security enabled? -
Logs enabled? Y
Add carrying charge to payables? N
Print payables checks? N
Print payroll checks? N
Transactions include Sales Tax? N
Skip closing confirmation? Y
Skip opening user name? Y
Skip opening graphics screen? N
Autopost emp. part FICA & MC? N
Printer lines 130 characters? N
Skip post fields flags - 522 0 1 0 1 0 0 0 0 0 1 0 0 0 0 0
Turn off automatic name reindexing N
Initialize Printer codes 0 0 0 0
Print 130 cpl Printer codes 0 0 0 0
Carry forward profit center N
Add employee OT regardless of other payN
Carrying charge statement on bill N
Question non matched qt. or number N
Expanded aged accounts report Y
Prompt for date on 1st payroll check N
*** CONSTANTS ***
# records by which to increment transactions? 500
# records by which to increment other files? 50
default carrying charge rate (decimal)? 0.015
Minimum carrying charge? 1.00
Minimum amount for carrying charge? 5.00
Social security % (decimal)? 0.0620
Social security wage base? 72600
Medicare % (decimal)? 0.0145
Medicare wage base? 9999999
FUTA % (decimal)? 0.0080
FUTA wage base? 7000
State Unemploy % (decimal)? 0.0030
State Unemploy wage base? 8000
Number minutes time out for user? 240
Minimum billing amount? 5.00
# records to search trans before date 0
default % of sale for cost of sales (.80) 0.800
W-2 number for totals (default=42) 42
Minimum payments for 1099 600.00
Don't allow post before date 00/00/00
Decimal % for KREDA payroll 0.000
KLEFPF payroll hourly rate
Hazardous retirement rate %
Regular retirement rate %
Hazardous retirement account # +
Hazardous retirement account # -
Regular retirement account # +
Regular retirement account # -
WIP - materials account # -
WIP - labor account # -
Update employee's sick & vac. monthly -
Vendor's discount account # +
Click here to return to Accounting Menu
Last revised September 13, 2004.
URL: http://www.kyphilom.com/www/acct3.html
Go to Top Menu..
..of Duane & Eva's Old Kentucky Home Page
Duane Bristow (duane@kyphilom.com)
Please send comments.
All contents copyright (C) 1999-2008, Duane Bristow. All rights reserved.