A B A C U S
Financial Accounting Package of
the Millennium
“IT
can NEVER go WRONG”
Jayman
Dalal
Gagan
Deep Gupta
Sachin
Khurana
Jayant
Kumar
The whole world
revolves round finance. The management of money plays a pivotal role not only
for huge business houses, but also for small-scale industries and in household.
There is where our Financial Accounting System – “ABACUS” comes handy. A
customized accounting system to handle, at present, small-scale businesses,
provides a full-scale fully controlled accounting with customizable reports.
The Backend
We have created
three tables named Ledger, Trans and Acgroups.
The structure
of the three tables is as follows:
Ledger Table:
Code |
Name |
Bal |
|
|
|
This table
contains the information of all the accounts created by the user.
Code: This column contains unique code generated internally when
a new account is created.
Name: This column contains the name of the account.
Bal: This column contains the balance (Credit or Debit) of the
account.
Trans Table:
Tno |
Tdate |
Crcode |
Drcode |
Tamt |
|
|
|
|
|
This table
stores various transactions that occur between the accounts.
Tdate: This column contains the date on which the transaction
occurred.
Crcode: This column contains Crcode, which is a
foreign key that references the primary key, Code in Ledger table. It
represents the code of account, which is being credited in the transaction.
Drcode: This column contains Drcode, which is a foreign key that
references the primary key, Code in Ledger table. It represents the code of
account, which is being debited in the transaction.
Tamt: The amount, which is transacted between
the accounts, is stored in this column. This amount is subtracted from the
creditor’s balance and added to the debtor’s balance.
.
Acgroups Table:
Grcode |
Grname |
Grcount |
|
|
|
Information
regarding type of accounts that can be created is stored in this table.
Grcode: In this column two digit code is stored. Different codes
represent different type of accounts. Eg. ‘00’ is for Capital accounts
‘08’ is for Sales accounts.
This two-digit
code is used in the starting two bits of the records in code column in ledger
table.
Grname: This column contains the names of 12
different type of accounts.
Grcount: This is a count that indicates the total number of accounts
of each type. Initially it is zero and is incremented each time a new account
of that type is created.
We have developed 10 forms, 5 reports and 2 menus.