General Ledger: L.A.W.S. Documentation Manual General Ledger
General Ledger: L.A.W.S. Documentation Manual General Ledger
General Ledger: L.A.W.S. Documentation Manual General Ledger
Documentation Manual
General Ledger
GENERAL LEDGER
TABLE OF CONTENTS
GENERAL LEDGER
298
G/L MAINTENANCE
298
299
300
302
302
304
304
307
307
309
309
Print/View Button
Post Journal Entries
Out Of Balance Journal Entries
Sample: Journal Entry Edit List
310
310
310
311
313
314
315
317
317
TRIAL BALANCE
318
320
320
320
322
322
CHART OF ACCOUNTS
323
325
325
325
FINANCIAL STATEMENTS
327
327
Sample:
Sample:
Sample:
Sample:
Sample:
Sample:
333
333
333
333
333
333
DAILY ACTIVITY
340
340
Inquiry Option
Daily Cash Inquiry Option
A/R Inquiry Option
WIP Inquiry Option
Daily Activity Report Options
Sample: Daily Cash, Accounts Receivable and WIP Activity
Sample: Monthly Summary of Cash, A/R and WIP
341
341
342
343
344
344
344
41
General Ledger
GENERAL LEDGER
The L.A.W.S. General Ledger module is fully integrated with all other systems within L.A.W.S. Revenue is
automatically posted from cash receipts processing. Expenses are posted through cash disbursements. Trust
activity may, or may not, be posted to the general ledger based on the firms accounting desires. Manual Journal
Entries may be posted through the General Ledger system to account for all non-system generated entries.
L.A.W.S. utilizes the cash basis accounting method. Accordingly, WIP, A/R and open payable balances are not
maintained within the general ledger. If accrual basis accounting is desired, journal entries may be generated at
month end recording the desired accrual activity.
The General Ledger contains a variety of standard General Ledger reports that summarize or analyze firm
performance. Income Statements, Balance Sheets and supporting schedules are all user defined allowing these
statements to be customized to the firms specific needs.
After selecting GENERAL LEDGER from the MASTER MENU, the following form is displayed.
42
General Ledger
Major Account
500
501
Description
Auto Expense
Insurance
1
1
501
501
Description
Auto Expense-Gas and Oil
Auto Expense-Leasing
Auto Expense-Parking
01
02
Insurance-Liability
insurance-Malpractice
Atty
Description
JJK
Auto Expense-JJK
PDK
Auto Expense -PDK
VJC
Auto Expense-VJC
The use of Sub Accounts and Attorneys provide very useful accumulation and reporting tools, but be sure not to
make the chart more complex than it needs to be.
43
General Ledger
Identify the desired Profit Centers and assign Profit Center Numbers.
In this example, the profit centers would correspond to physical location, Detroit and Chicago. The Profit
Center codes should be numeric usually starting with one. In this example the profit centers are set
defined as follows:
Detroit - 01
Chicago - 02
2)
Create General Ledger Account Numbers utilizing Profit Centers for all relevant accounts.
Since the firm wants to capture productivity by location, the firm must identify general ledger accounts by
profit center. In this instance, the Sub Account identifies the Profit Center. A sampling of the account
structure follows:
3)
Account Number
Firm - Major Account - Profit Center
1
400
1
400
01
1
400
02
Description
Fees
Fees - Detroit
Fees - Chicago
1
1
1
500
500
500
01
02
Client Costs
Client Costs - Detroit
Client Costs - Chicago
1
1
501
501
01
02
1
1
Etc.
502
502
01
02
Utilities - Detroit
Utilities - Chicago
4)
45
General Ledger
G/L MAINTENANCE
General Ledger Maintenance allows the creation of, or modification to, account numbers constituting the firms
Chart of Accounts. The account number consists of four sections including the Firm Number, Major Account, Sub
Account and Attorney code. The Firm Number and Major Account are required, but the Sub Account and
Attorney are not required.
After Selecting the G/L MAINTENANCE option, the following form is displayed:
Account Type
Asset
Liability
Equity
Revenue
Expense
(See the above explanation of the General Ledger Account Number for detailed review.)
46
General Ledger - G/L Maintenance
47
General Ledger - G/L Maintenance
48
General Ledger - G/L Maintenance
Actual Charges
$1200
$1000
$ 3600
$ 5800
Budget Amount
$ 6000
0
0
$ 6000
When the Budget Report prints, a single line item will print showing auto expense of $5800 and a corresponding
budget amount of $6000 with a computed variance of -$200.
If desired, budget values could have been entered for each individual account within the line item, but is not
necessary.
ACCOUNT NUMBER
The account number for which budget values are being entered. This field is informational only.
BUDGET PERIOD
The budget period carried over from the prior screen. This field is informational only.
ANNUAL BUDGET
Allows the entry of an annual budget value. This annual budget value will be divided by 12 and inserted into
each months budget value.
The annual budget distribution will be performed only if the existing monthly distribution values total zero. If
monthly budget distribution values have previously been entered, an error message is displayed and the annual
budget distribution is canceled. If unwanted values exist, use the Clear Monthly Totals button to clear the
existing totals, then enter the annual budget amount.
Note: Budget values must be entered consistent with the natural storage of values in the general ledger.
Budget values associated with revenue accounts must be posted as credits (negative values), and
expenses must be entered as debits (positive values).
MONTH / AMOUNT (Monthly Distributions)
Specifies the budget dollar values assigned to each month within the budget period. L.A.W.S. will automatically
distribute the Annual Budget value evenly between months. If desired, the monthly amounts may be entered
differently to reflect seasonal fluctuations.
TOTAL
The total of the monthly budget amounts. This is informational and visual verification purposed only.
49
General Ledger - G/L Maintenance
50
General Ledger - G/L Maintenance
51
General Ledger
Journal Entry Source Maintenance
52
General Ledger
Journal Entry Source Maintenance
53
General Ledger-Journal Entry Processing
NoYes-
Will cancel the posting and return to the journal entry processing form.
Will post the journal entry to the general ledger, then delete this journal entry from the system.
54
General Ledger-Journal Entry Processing
Out-of-balance entries MAY be posted, but be aware that out-of-balance entries might cause the trial balance not
to balance.
Out-of-balance entries may be useful to correct a system posting error. For example, suppose a deposit is being
processed, and for some reason, the fee account is not defined in the firm file. The system generated journal
entry may be out of balance by the fee amount. An offsetting out of balance manual journal entry may be
produced to correct this system entry.
When posting adjusting entries, it is a good idea to always refer to the original Journal Entry Source and Source
number creating a viable audit trail.
A Sample Journal Entry is displayed on the following page.
Sample: Journal Entry Edit List
55
General Ledger-Journal Entry Processing
Date
(Firm#: 1)
G/L Number
Acct Description
Debit
Credit
Description
_________________________________________________________________________________________________________________________________________________________________________
46
04/30/1998
Record Bank Service Charge - April 1998
1 100
Cash In Bank - General
($15.32)
_______________________________________________________________________________________________________________________________________________________
1 510
Office Expense
$15.32
_______________________________________________________________________________________________________________________________________________________
Journal Entry Total:
$15.32
($15.32)
_________________________________________________________________________________________________________________________________________________________________________
Copyright 1998 L.A.W.S. Corporation
4/23/98 1:05:13 PM
1
rptGLJE Journal Edit Listing
56
This is simply an informational message stating that the Year End Close option was selected. If it was selected in
error, simple answer No to return to the G/L Menu, otherwise, select Yes to display the Year End Close
Processing Screen displayed below.
57
General Ledger-Year End Close
58
General Ledger-Year End Close
Answering Yes will post the generated year end closing entry. No will return to the prior form.
A sample Year End Close Journal Entry is displayed on the following page.
Sample: Year End Close Journal Entry
59
General Ledger-Year End Close
(Firm#: 1)
_________________________________________________________________________________________________________________________________________________________________________
Source
YE
Date
12/31/1998
G/L Number
400
400
400
400
400
400
401
402
500
500
500
502
506
507
508
508
508
509
509
510
598
1300
01
AAA
CCC
FIRM
PDK
AAA
01
02
AAA
PDK
01
02
01
Acct Description
Debit
Credit
$8,620.50
$3,710.00
$3.00
$149.32
$49,119.54
$475.00
$1,420.99
$3,340.00
$362.36
($5.00)
$2,162.50
$175.00
($359.81)
($5,453.35)
($125.00)
$2,500.00
$161.50
($5.00)
$327.50
($140.32)
$50.00
($66,488.73)
_________________________________
$72,577.21
($72,577.21)
________________________________________________________________________________________________________________________________________________________________________
Copyright 1998 L.A.W.S. Corporation
12/31/1998 0:00:00
4/23/98 2:56:19 PM
1
rptGLYE - Year End Close Journal Entry
60
Cash Disbursements
Trust Disbursements
Manual Journal Entries
Year End Close
CR
TR
PR
Cash Receipts
Trust Receipts
Payroll
61
General Ledger-J/E Summary Report
62
General Ledger-J/E Summary Report
J/E Source: CR
Source No: * ALL *
(Firm#: 1)
G/L Number
Detail
Source
Date
Maj Sub Atty
Check#
Acct Description
Debit
Credit
Ref#
Description
_________________________________________________________________________________________________________________________________________________________________________
Cash Receipts
CR 115
02/03/1998
100
500
02
Firm Total: 1
$2,690.00
($2,190.00)
_________________________________________________________________________________________________________________________________________________________________________
Copyright 1998 L.A.W.S. Corporation
4/23/98 3:24:36 PM
rptGLJESum - Journal Entry Summary Report
1
63
TRIAL BALANCE
The purpose of the trial balance is to list selected general ledger accounts, along with the beginning of the period
balance, current period debit, current period credit and the ending balance. The report balances if the beginning
and ending of period balances are zero. The Trial Balance is sorted by the general ledger user defined sub-total
code within the account type. After selecting TRIAL BALANCE, the following form is displayed:
64
General Ledger-Trial Balance
(Firm#1)
Beginning Balance
1/31/98
Description
02/01/1998
Current
Debit
Thru
02/28/1998
Current
Credit
Ending Balance
2/28/98
_________________________________________________________________________________________________________________________________________________________________________
Assets
1
1
1
1
1
100
100
101
102
103
$3,788.57
$2,690.00
$6,478.57
($65.00)
($65.00)
$511.75
$511.75
$1,125.00
$1,125.00
$9,675.00
$9,675.00
Total Assets:
$15,035.32
$2,690.00
$0.00
$17,725.32
_________________________________________________________________________________________________________________________________________________________________________
01
Liabilities
1
1
1
1
1
200
201
202
203
270
($592.18)
($592.18)
($311.75)
($311.75)
$0.00
$0.00
($4,500.00)
($4,500.00)
($100.00)
($100.00)
Total Liabilities:
($5,503.93)
$0.00
$0.00
($5,503.93)
_________________________________________________________________________________________________________________________________________________________________________
Equity
1 300
Retained Earnings
$51,362.90
$51,362.90
Total Equity:
$51,362.90
$0.00
$0.00
$51,362.90
_________________________________________________________________________________________________________________________________________________________________________
Revenue
1
1
1
1
1
1
1
1
1
1
400
400
400
400
400
400
400
400
401
402
($7,466.50)
($500.00)
($7,966.50)
($3,710.00)
($3,710.00)
($3.00)
($3.00)
($149.32)
($149.32)
$0.00
$0.00
($47,476.60)
($220.00)
($47,696.60)
($5.00)
($470.00)
($475.00)
$0.00
$0.00
($1,380.99)
($1,380.99)
($2,340.00)
($2,340.00)
Total Revenue:
($62,531.41)
$0.00
($1,190.00)
($63,721.41)
_________________________________________________________________________________________________________________________________________________________________________
Firm Total:
($1,637.12)
$2,690.00
($1,190.00)
($137.12)
AAA
CCC
FIRM
JJK
PDK
01 AAA
01 PDK
_________________________________________________________________________________________________________________________________________________________________________
Copyright 1998 L.A.W.S. Corporation
4/23/98 4:24:47 PM
rptGLTB
65
66
General Ledger-Detail General Ledger
REPORT FORMAT
Enter the form in which the data should be presented. The available options include:
Detail
Prints each individual transaction
Summary
Summarizes transactions into a single line item by date within the G/L source code for
each account.
SORT OPTION
Specifies the method by which the report should be sorted. The available options include:
Source Type Subtotals activity on the report by Source Type Code.
Date
Subtotals activity on the report by Source Type Code within the transaction month.
For example: The date range for the report may be 01/01/98 through 02/28/98. If the sort option is
"Date", then Januarys activity will be totaled, and Februarys activity will also be totaled. Within each
month, activity will be sorted and subtotaled by source type.
A sample of the Detail General Ledger report is displayed on the following page.
Sample: Detail General Ledger Report
67
General Ledger-Detail General Ledger
Vendor
Date
Src Je#
Debit
Start Date:
End Date:
Credit
Check#
Client
01/01/1998
04/30/1998
Matter
Atty
_________________________________________________________________________________________________________________________________________________________________________
100
Cash In Bank - General
Balance Forward:
$116,550.21
(52) Delivery Service
United Parcel Service (UPS)
04/21/1998 CD 104
($100.00)
48802
(51) Contract Labor - Yard Work
Geroge Hanson (MISC)
04/21/1998 CD 104
($100.00)
48803
Total (CD):
($200.00)
($200.00)
CR Ref# 1 - 1
02/03/1998 CR 115
$500.00
0
CR Ref# 1 - 3
02/05/1998 CR 116
$500.00
0
CR Ref# 4 - 6
02/06/1998 CR 117
$845.00
0
CR Ref# 4 - 6
02/06/1998 CR 119
$845.00
0
CR Ref# 1 - 3
03/01/1998 CR 123
$1,292.94
0
CR Ref# 1 - 3
03/07/1998 CR 123
$2,500.00
0
CR Ref# 1 - 3
03/25/1998 CR 123
$364.00
0
CR Ref# 9 - 11
04/03/1998 CR 121
$1,340.00
0
CR Ref# 2 - 4
04/03/1998 CR 122
$1,340.00
0
Total (CR ):
$9,526.94
$9,526.94
balance cash
01/01/1998 JE 45
($112,761.64)
0
Record Bank Service Charge - April 1998
04/30/1998 JE 46
($15.32)
0
Total (JE):
($112,776.96)
($112,776.96)
03/31/1998 PR 5
($323.25)
0
04/15/1998 PR 6
($1,318.27)
0
Total (PR):
($1,641.52)
($1,641.52)
Account Total:
$9,526.94
($114,618.48)
$11,458.67
Firm Total: Bal Fwd:
$116,550.21
$9,526.94
($114,618.48)
$11,458.67
_________________________________________________________________________________________________________________________________________________________________________
Copyright 1998 L.A.W.S. Corporation
4/23/98 4:49:41 PM
Detail G/L activity For Each Account Between the Start and Ending G/L No. Subtotaled by G/L Source Type. rptGlDet_Det
68
CHART OF ACCOUNTS
The CHART OF ACCOUNTS lists all non-financial general ledger account information in account number order.
After selecting CHART OF ACCTS, the following form is displayed.
69
General Ledger-Chart of Accounts
(Firm#1)
_________________________________________________________________________________________________________________________________________________________________________
Copyright 1998 L.A.W.S. Corporation
Type of Account: 1=Asset 2=Liability 3=Equity 4=Revenue
4/23/98 5:14:18 PM
rptGLChart - Chart of Accounts
70
FINANCIAL STATEMENTS
L.A.W.S. allows for the creation of User Defined Financial Statements. User defined statements allow the firm
to design customized income statements, balance sheets, budgets, and supporting statements. These
statements may be as detailed, or as summarized, as the firm desires. Many people find the setup and design of
Financial Statements unnecessarily confusing. Take time to review the associated examples, especially relating
to the total lines. Within a little time and experimentation your financial statements will not only look
professional, but also balance.
After specifying FINANCIAL STATEMENTS, the following form is displayed.
71
General Ledger - Financial Statements
72
General Ledger - Financial Statements
73
General Ledger - Financial Statements
GL Type
Income/Budget Statements:
Assets
Liabilities
Equity
Revenue
Expenses
Assets
Liabilities
Equity
Revenue &
Expenses
Added
Added
Added
Balance Sheet:
Not Reversed
Reversed
Reversed
Please review the add/subtract and reverse sign options associated with the sample line items below:
Revenue
Fee Income
Client Expense Recovered
Other Income
Total Income
Expenses
Client Costs
Administrative Expenses
Total Expense
Net Income
If Subtract is used to subtract expense amounts from the net income total, then the subtotal of expenses will be
a negative number and should be reversed prior to printing. The example associated with the Sub Total option
displays running totals that reinforce the concepts associated with these codes.
TOTAL OPTION
Copyright 1999 L.A.W.S. Corporation
74
General Ledger - Financial Statements
Revenue
Fee Income
Client Expense
Recovery
Other Income
Total Income
Total/Add
Option
H
Blank/Add
Blank/Add
Blank/Add
1
Cur Month
Line Item
Amount
$
0
$ 45,130
Level 1
$
0
$ 45,130
Level 2
$
0
$ 45,130
Level 3
$
0
$ 45,130
Level 4
$
0
$ 45,130
Level 5
$
0
$ 45,130
Level 6
$
0
$ 45,130
$
50
$ 1,000
$ 46,180
$ 45,180
$ 46,180
$ 46,180
$ 45,180
$ 46,180
$ 46,180
$ 45,180
$ 46,180
$ 46,180
$ 45,180
$ 46,180
$ 46,180
$ 45,180
$ 46,180
$ 46,180
$ 45,180
$ 46,180
$ 46,180
The total income line is classified as Total, Level 1. Accordingly, the current value of the level 1 total will be used as the total
amount, then cleared after it is printed.
Total Values
After Printing
Expenses
Client Costs
Administrative
Expenses
Total Expense
$ 46,180
$ 46,180
$ 46,180
$ 46,180
$ 46,180
0
7,700
$
0
$ -7,700
$ 46,180
$ 38,480
$ 46,180
$ 38,480
$ 46,180
$ 38,480
$ 46,180
$ 38,480
$ 46,180
$ 38,480
Blank/Sub $ 16,765
1 (rev sign) $ 24,465
$-24,465
$-24,465
$ 21,715
$ 21,715
$ 21,715
$ 21,715
$ 21,715
$ 21,715
$ 21,715
$ 21,715
$ 21,715
$ 21,715
H
Blank/Sub
$
$
The total expense line is also classified as a level 1 total. Since the level 1 total was cleared after Total Income,
the value of level 1 represents the sum total of all detail line items processed since the last level 1 total.
Expenses are coded as being subtracted from totals. The value of the Level 1 Total is therefore negative and
must be reversed prior to printing.
The total expense line is classified as Total, Level 1. Accordingly, the current value of the level 1 total will be used as the
total amount, then cleared after it is printed.
Total Values
After Printing
Net Income
$ 21,715
$ 21,715
$ 21,715
$ 21,715
$ 21,715
$ 21,715
$ 21,715
$ 21,715
$ 21,715
$ 21,715
$ 21,715
The Net Income Total number could have been any level number greater than 1 since level 2 - 6 contain equal values and
there are no additional line items in this sample format. After the net income is printed, the value of the level, 2, and all
lower levels are automatically cleared as noted below.
Total Values
After Printing
$ 21,715
$ 21,715
$ 21,715
$ 21,715
75
General Ledger - Financial Statements
76
General Ledger - Financial Statements
77
General Ledger - Financial Statements
Add
Sub
Line Description
Rev
Sign Total Space Page
Lower
GL #
Upper
GL #
Ref No.
_________________________________________________________________________________________________________________________________________________________________________
0 Income Statement
10 Revenue
20
Fee Income
22
Client Expenses Recovered
27
Other Income
30
Total Income
33 Expenses
35
Client Costs
40
Administrative Expenses
50
Total Expenses
60
Net Income
A
A
A
A
A
S
S
N
N
Y
Y
Y
N
N
N
N
Y
N
H
H
1
H
1
2
2
1
1
1
1
2
1
1
1
2
1
1
1
1
2
2
1
2
2
2
2
2
1400
1401
1402
140001PDK
1500
1502
150002PDK
1999999
_________________________________________________________________________________________________________________________________________________________________________
Copyright 1998 L.A.W.S. Corporation
4/24/98 4:12:15 PM
Financial Statement Format contains the Instructions used to print financial statements.
rptGlFinStmt_Fmt
78
46
47
48
93
94
49
73
92
53
96
97
Add
Sub
Line Description
Rev
Sign Total Space Page
Lower
G/L #
Upper
G/L #
Ref No.
_________________________________________________________________________________________________________________________________________________________________________
0 Balance Sheet
10 ASSETS
20
Cash in Bank
30
Cash in Bank - Trust Accounts
40
Total Assets
50 LIABILITIES
55
Payroll Withholdings
60
Other Liabilities
A
A
A
A
A
65
Total Liabilities
70 EQUITY
80
Year to Date Income
85
Retained Earnings
86
Total Equity
90
Total Equity and Liabilities
A
A
N
N
N
N
N
Y
Y
Y
Y
N
N
Y
Y
N
N
H
H
6
H
1
H
1
6
1
1
1
1
2
1
1
1
1
2
2
1
1
2
2
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1100
1101
110001
1103
1200
1203
1270
1202
1400
1300
1598
_________________________________________________________________________________________________________________________________________________________________________
Copyright 1998 L.A.W.S. Corporation
4/24/98 4:29:53 PM
Financial Statement Format contains the Instructions used to print financial statements.
rptGlFinStmt_Fmt
79
98
79
80
81
82
83
56
84
84
89
85
86
88
100
87
Start G/L#:
End G/L #:
1300
1598
Account Description
Sequence #'s
_________________________________________________________________________________________________________________________________
Account Description
Retained Earnings
_________________________________________________________________________________________________________________________________
Account Description
_________________________________________________________________________________________________________________________________
4/24/98 4:55:53 PM
Copyright 1998 L.A.W.S. Corporation
rptFmtErr - Financial Statement Format List
80
INC
Income Statement
Revenue
Fee Income
Client Expenses Recovered
Other Income
Total Income
$45,130
$50
$1,000
$46,180
$44,673
$146
($90)
$44,728
$458
($96)
$1,090
$1,452
1%
-66%
-999%
3%
$48,267
$40
$1,000
$49,307
$56,580
$1,381
$2,340
$60,301
($8,313)
($1,341)
($1,340)
($10,994)
-15%
-97%
-57%
-18%
Expenses
Client Costs
Administrative Expenses
Total Expenses
$7,700
$16,765
$24,465
$11,927
$23,369
$35,295
($4,227)
($6,603)
($10,830)
-35%
-28%
-31%
$6,700
$15,110
$21,810
$11,765
$23,506
$35,271
($5,065)
($8,396)
($13,461)
-43%
-36%
-38%
Net Income
$21,715
$9,433
$12,281
130%
$27,497
$25,030
$2,466
10%
_________________________________________________________________________________________________________________________________________________________________________
Copyright 1998 L.A.W.S. Corporation
4/24/98 5:17:22 PM
1
Financial Statement Format printed in Income Statement Format. rptGlFinStmt_Inc
81
Budget
INC
Income Statement
Month to Date ( Apr 30 1998 )
Actual M-T-D Budget M-T-D
Variance %
____________________________________________
Revenue
Fee Income
Client Expenses Recovered
Other Income
Total Income
$45,130
$50
$1,000
$46,180
$10,000
$0
$0
$10,000
$35,130
$50
$1,000
$36,180
Expenses
Client Costs
Administrative Expenses
Total Expenses
$7,700
$16,765
$24,465
$0
$0
$0
$7,700
$16,765
$24,465
Net Income
$21,715
$10,000
$11,715
351%
362%
117%
$40,000
$0
$0
$40,000
$8,267
$40
$1,000
$9,307
$6,700
$15,110
$21,810
$0
$0
$0
$6,700
$15,110
$21,810
$27,497
$40,000
($12,503)
21%
23%
-31%
_________________________________________________________________________________________________________________________________________________________________________
Copyright 1998 , L.A.W.S. Corporation
4/24/98 5:24:31 PM
1
Financial Statement Format printed in Budget Statement Format.
rptGlFinStmt_Bgt
82
BS
Balance Sheet
As of April 30, 1998
ASSETS
Cash in Bank
Cash in Bank - Trust Accounts
Total Assets
LIABILITIES
Payroll Withholdings
Other Liabilities
Total Liabilities
___________________________________
________________________________
$11,393.67
$11,001.33
$118,592.86
$11,311.75
$22,395.00
$1,274.25
$4,672.60
$129,904.61
$311.75
$4,500.00
$5,946.85
$4,811.75
EQUITY
Year to Date Income
Retained Earnings
Total Equity
$27,496.76
($11,048.61)
$25,030.27
$97,444.09
$16,448.15
$122,474.36
$22,395.00
$127,286.11
_________________________________________________________________________________________________________________________________
Copyright 1998 L.A.W.S. Corporation
4/24/98 5:31:21 PM
Financial Statement Format printed in Balance Sheet Format. rptGlFinStmt_Bs
83
DAILY ACTIVITY
The DAILY ACTIVITY button summarizes Cash, Accounts Receivable and Work In Process. The Daily Activity
inquiry functions always display the Cash, A/R or WIP balance forward amount along with individual line items
summarizing activity per day. The ending balance always displays the Cash, A/R or WIP balance as of the
specified End Date. The Daily Activity Report has the option of summarizing data by either day or by month.
After selecting Daily Activity, the following form is displayed.
84
General Ledger - Daily Activity
Information Displayed
DATE
The date on which cash activity occurred. Only dates on which cash activity was posted will be displayed. The
first entry on the form represents the balance forward date. All other dates on the form represent the summary of
daily activity.
85
General Ledger - Daily Activity
86
General Ledger - Daily Activity
Information Displayed
DATE & BALANCE / DAILY CHANGE
The Date and Balance / Daily Change columns are as described with the Cash Inquiry option. Only days on
which WIP activity is posted are displayed. The Daily Change is computed by subtracting the Billing from the
Entry / Adjustments.
ENTRY / ADJUSTMENT
The dollar value of WIP entered into the system through Time Entry and Check Writing , net of the adjustments
to WIP entered through the WIP adjustment program.
87
General Ledger - Daily Activity
88
General Ledger - Daily Activity
Start:
End:
02/28/1998
03/01/1998
03/02/1998
03/03/1998
03/04/1998
03/05/1998
03/06/1998
03/07/1998
03/09/1998
03/10/1998
03/12/1998
03/17/1998
03/25/1998
03/31/1998
04/03/1998
04/15/1998
04/21/1998
04/24/1998
Receipts
Disb's
J/E's
Balance
______________________________________________________
1,293
0
0
0
0
0
2,500
0
0
0
0
364
0
2,680
0
0
0
Firm Total:
6,837
Accounts Payable Due:
0
0
0
0
0
0
0
0
0
0
0
0
-323
0
-1,318
0
0
6,414
7,707
7,707
7,707
7,707
7,707
7,707
10,207
10,207
10,207
10,207
10,207
10,571
10,247
12,927
11,609
11,409
11,409
200
-1,642
0 - 7 Days:
8 - 14 Days:
15 - 21 Days:
22 - 28 Days:
Over 28 Days:
Total Due:
11,409
$977.00
$0.00
$0.00
$0.00
$0.00
$977.00
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
200
0
Accounts Receivable
Receipts
Adj's
Billing
Balance
Entry/Adj
_____________________________________________________
0
0
0
0
0
0
0
0
0
599
0
0
0
0
0
0
555
1,293
0
0
0
0
0
0
0
0
0
0
364
0
590
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
44,454
43,161
43,161
43,161
43,161
43,161
43,161
43,161
43,161
43,161
43,760
43,760
43,396
43,396
42,806
42,806
42,806
43,361
1,154
2,247
43,361
Mar 01,1998
Apr 28,1998
Work In Process
Billing
Balance
_______________________________________
688
390
800
1,050
1,750
750
520
900
53
0
3
0
-500
-500
0
125
0
0
0
0
0
0
0
0
0
0
599
0
0
0
0
0
0
555
36,378
37,066
37,456
38,256
39,306
41,056
41,806
42,326
43,226
43,278
42,679
42,682
42,682
42,182
41,682
41,682
41,807
41,252
6,028
1,154
41,252
_________________________________________________________________________________________________________________________________________________________________________
Copyright 1998 L.A.W.S. Corporation
4/28/98 12:49:19 PM
1
rptDayBal - 'Daily Activity' from G/L Menu
Start Date:
End Date:
89
January 01 1998
April 28 1998
Jan
Feb
Mar
April
May
June
July
Aug
Sept
Oct
Nov
Dec
_________________________________________________________________________________________________________________________________________________________________________
CASH
Balance Fwd:
$116,485.21
CR $2,690.00
Disbursements
J/E Adj
($112,761.64)
$3,723.57
$4,156.94
$6,413.57
$2,680.00
($323.25)
$10,247.26
$0.00
($200.00)
($1,318.27)
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
Ending Balance:
$3,723.57
$6,413.57
$10,247.26
$11,408.99
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
_________________________________________________________________________________________________________________________________________________________________________
Receivables
Balance Fwd:
Billing
Receipts
Write Up/Down
$45,396.88
$0.00
$0.00
$0.00
$45,396.88
$97.00
($1,040.00)
$0.00
$44,453.88
$598.85
($1,656.94)
$0.00
$43,395.79
$555.00
($590.00)
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
Ending Balance:
$45,396.88
$44,453.88
$43,395.79
$43,360.79
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
_________________________________________________________________________________________________________________________________________________________________________
Work In Process:
Balance Fwd:
Billing
Wip Entry/Adj
$36,524.75
$0.00
$503.75
$37,028.50
$0.00
($650.00)
$36,378.50
($598.85)
$6,402.50
$42,182.15
($555.00)
($375.00)
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
Ending Balance:
$37,028.50
$36,378.50
$42,182.15
$41,252.15
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
_________________________________________________________________________________________________________________________________________________________________________
_________________________________________________________________________________________________________________________________________________________________________
4/28/98 2:02:26
90
Page 1 of 1