Method and apparatus for managing the allocating of financial transactions into ledger accounts

52 Pages·2013·3.46 MB·English

US 20020087441A1
(19) United States
(12) Patent Application Publication (10) Pub. N0.: US 2002/0087441 A1
Wagner, JR. et al. (43) Pub. Date: Jul. 4, 2002
(54) METHOD AND APPARATUS FOR Publication Classi?cation
MANAGING THE ALLOCATING OF
FINANCIAL TRANSACTIONS INTO LEDGER (51) Int. Cl? ................................................... .. G06F 17/60
ACCOUNTS (52) Us. 01. .............................................................. .. 705/30
(76) Inventors: Charles Arthur Wagner JR., Glenn
Arm, MD (US); Joel Friedman,
Marriottsville, MD (US); Barry Kirk,
(57) ABSTRACT
SteWartstoWn, PA (US)
Correspondence Address:
Apparatus and method are disclosed for supporting a plu
R. Lewis Gable
rality of users to allocate the ?nancial transactions of each
Cowan, Liebowitz & Latman, RC.
1133 Avenue of the Americas user to a corresponding one of a plurality of ledgers. Each
New York, NY 10036 (US) of the ledgers has a plurality of accounts. The apparatus
comprises a memory comprising a plurality of storage
(21) Appl. No.: 09/916,398 locations, each of Which stores a corresponding one of the
ledgers for its user, and a server. The server is programmed
(22) Filed: Jul. 27, 2001
to determine the attributes of each of the ?nancial transac
Related US. Application Data tions, facilitate each of the users to construct its oWn
allocation policy, and to allocate each ?nancial transaction
(63) Non-provisional of provisional application No. according to the allocation policy of its user into a corre
60/221,330, ?led on Jul. 28, 2000. sponding account of that user.
Process and Data Flow for data load
o1 3
Card holders
(0° 6’ l 9 9“ Individual
Billing
|
Authorization, Master-Card . .
Merchants 4-Transaotion Processing Dally Posting 83> ——Cenlral B'llln & Reb l —
& sememem Network Sememem Card Processor 1 g a as
Y
(e y Finanlclal Transaction Date
Account Information
Vehicle Information (non leasing clients only)
,_ I'D
Access to Data
Transactional
Interactive Data Elatse we r Reference Dal
Warehouse e-Ledger Policy Sewer p
data
Na
Patent Application Publication Jul. 4, 2002 Sheet 1 0f 42 US 2002/0087441 A1
Client's PC
w/Browser
9.0
Gauntlet I
Firewall 1).
1*!
Web Server
/
MlC. l'OSOft Internet l3 0‘
Information '9
Server \
A Application
‘ Source Code
1')
Cold Fusion
Application
Sewer
A
V
Database server
Database
_.____.__l2_ raw-l
Patent Application Publication Jul. 4, 2002 Sheet 2 0f 42 US 2002/0087441 A1
50
LFilgur e
Patent Application Publication Jul. 4, 2002 Sheet 3 0f 42 US 2002/0087441 A1
Tl
22205080
Md vE20mG0mG(
9E3...2m358.25
@223
5:5
Ehowmwmuuoi
3Eum.EBwucam25Bonomom»Q-i-
@2635;
523.8
f:
22.6.8255 025x225
9:222‘
03

Patent Application Publication Jul. 4, 2002 Sheet 5 0f 42 US 2002/0087441 A1
e-Ledger Setup Process Flow
500
/
a;
V
e-Leder Setup 5 O 3’
Screen
ll
User 0'1’
Selects 5
Option
V
Accounting P _ t 5/0
Fiscal Calendar Codes rojec s
l l 7
User Adds /
User Adds / Maintains General User Adds /
Maintains Fiscal LedgerAccounting Maintains project
Periods codes and information
descriptions
{i '3- 5 I ‘l [I (p
$113M, Li“

Patent Application Publication Jul. 4, 2002 Sheet 7 0f 42 US 2002/0087441 A1
e-Ledger Transaction Download Process Flow
547
\1 ( )ggo
e-Leder
Transaction
Download
Screen
Transaction
Download
Page
ll
User Selects the
?scal period that
they would like
downloaded to
their client desktop
Patent Application Publication Jul. 4, 2002 Sheet 8 of 42 US 2002/0087441 A1
e-Ledger Transaction Maintenance Process . row
1/ 557
e~Leder
Transaction
Maintenance
Screen
Transaction
E-Mail Notify Maintencance
Screen Screen
V V
User selects the e— User reviews!
mail addresses for approves
those who should transactions. gb‘l
receive custom Additionally, the
messages user can change
indicating that is and/or spiit the
time to review! transaction to new
approve G/L accounting
transadions. code(s)
1; cjw’e, Ltd
Patent Application Publication Jul. 4, 2002 Sheet 9 0f 42 US 2002/0087441 A1
ELEDGEP Display‘! I <Ma|n S'Ubjeri Area>
trgns lml sgd fl 3
£xn_n0 int NOT NULL (F K)
spht_no tlnyinl NOT NULL
accLno' char?G) NOT NULL splitjype chaKUTIOT NULL
txn_cd ohaNZ) NOT NULL
eds_ _od. char(2) NOT NULL
lm_dt datelime NOT NULL
posi_dl daleume NOT NULL transaction ' mal
lxn_rsn_od char(2) NOT NULL txn_no‘ int NOT NULL (FK)
mioro__ref_no' char(23) NOT NULL
company_no. chads) NOT NULL enlry_amt money NOT NULL
memh_nm: varchar?s) NOT NULL company_no: char($) NOT NULL
mmeerrcdh1__aadtdyr__lnimn‘e 1v.a rvdawrad‘rn?aax)? No)O NTO NTU NLULL L hhiueerrJjvdl' c6h91a3d1s12)) NNOOTT NNUULLLL
merd1_sl_pmv_abbc char(3) NOT NULL eds_corp_od' 613(2) NOT NULL
metd'LcnlrLabbr: char?) NOT NULL polcy_spec_id‘ numeric(6) NULL
merd1_zip_cd: char?o) NOT NULL joumaljd: vandal-(100) NOT N
mmeetrdclh__idnbca__sn|am_.o vda rdcrhaarm()40 )N ONTO TN UNLULL L oproosi(e_a__dicd _d svaarr?cOh)a rNHUOL) LN ULL ~
merd\_minotity_cd chadZ) NOT NULL appr0ve__ind chaz?) NULL
merchJaxpayerJd char?O) NOT NULL 1 )
memh_c1gy_ed. char[4) NOT NULL
memh_nef_not vamhar?7) NOT NULL audit_insen_dt dateh'me NOT NULL
audlt_insed_login. vamharCiO) NOT NULL
audrt_update_dt datetime NULL
aud11_updake_login' varchar(30) NULL ledernotes
LXHJTOI int NOT NULL
notes: varchar(255) NOT NuLL
tm_hier_M. chadZ) NOT NULL auddémsedjogin: Vat'Oha?SO) NOT NULL
lxn_h|er_id. dlat(5) NOT NULL
tm_hier_nm varoharNO) NOT NULL aauuddl:tt__umpsdean1_ed_tl.o gdiant.e vlairmceh NarO(3T0 )N UNLULL L '
‘ _se<:_id vamnarus) NOT NULL aud:t_upda(e_dt: datetnne NULL
salesjaxjnd' char“) NOT NULL
Sales_1ax_amt money NOT NULL rwnhs rchain
splrjd. charm NULL
oil_eo_brancl_idi M4) NULL
metd:_c§qy_od:d1ar(4) NULL
gdcscSSSaSsa!ehhe¢PPPdPd_taao_IIaIdIdaiid_oNNNnieNna_ec1 L :n lntrdiaas aaodd_dnruuutu_nuu <aaddQndom:mciti‘:opIfntjt_dn tandL_JMLt d___:Npdoiuiet tg3gUnpndcm idmddsaLhdjn0t:'teaaaL_'d ed tdrm )t v.lv_te?eai.da a ?)?ri mtNmnmm ddme tNUhadex e)NUtaNLa a NeUdL NdlULnNUSSeLLL O‘UOLbOL LmT)Lm)Le eL NNNN UUNUULLULLLLLLL L sasaeasbdspupuupmup'lddldllusdrirnr'ra_r_t_l_d__iudJttesp_ndp\yol\jg_u\dpa_gaorpnat_tii_wnd‘s_oynncn:tndpei:_de __:_. nm?mrdMo o bd_jdctdewr:i1t3:h n:n cam ace hdmr00drhaoc.(9raa“ a 21))-cca))r3(mhh r ( ?8 NNNaaN))?8)r r)UUU)U N “ N“ LLNLNLUN))ULLULUL LU LN N L L LLLULULL L L LL jaeashehebuonpciiod<duteecensmirtcmtr__(pjy__n_ao_ad_ioMnlio:na:d:o\tj my scpdict_enh6n_h .\nat:uca v1ro2mdN:m_(a::.(oedO5(m2 nt)n1dch)T 1h6eqd aNN aa)yNasIrr OOl N)U?1(NTe52TO LOO)N)? O LNT NmUT)NN U eUL N OONLN LLUNTTULUL LO LL NNLTLLUU LLNLLU LL
merd\_phone_m: char(16) NULL frm_dt chads) NULL aud%t_msed'J ogin: vanchar??) NOT NULL
sole_proprietor_mn. char(25) NULL lO_dL (3131(8) NULL aud':t_updt_dt datetime NULL
legal_co(p_nm: chax(25) NULL audlLupdtJog'n' varchar(30) NuLL
dun_bradslree4_no‘ char“ 5) NULL
eds_eup_od. (1131(2) NOT NULL
company_no' chads) NOT NULL
audit_insext_dt dateume NOT NULL
merchant code audnt_insed_bgin: wrmaqao) NOT NULL
merca‘LctgLw‘ dial“) NOT NULL audit_updt_dt date?me NULL
audit_updl_login: varmaqsu) NULL
login: Vard‘arQO) NOT NULL
SPlN__audxl_update_login: vamhar?o) NULL
SPlN_audt__program' vardurtBO) NOT NULL