Hi,James,
1) I believe it is better to have a table for account
numbers, and the fields should be: account_number,
account_title, account_type (such as current asset,
fixed asset, other asset, current liability,long-term
liability, equity, income,cost of goods sold, expense,
other income, and other expense), and
active_or_inactive. Account numbers should not be
deleted if they have been used.
For the two tables, payment and receipt, it is better
to add a field for account numbers. It is not
necessary to have a field for taxable/non-taxable if
account numbers are used.
With these information, it is easier to generate
income statement and balance sheet.
I can create the general ledger report without the
account_number table. However, the balance sheet
accounts should show beginning balance and ending
balance, but income statement accounts should show
only the total amounts for each income statement
accounts, for the selected period such as 01-01-2003
thru 12-31-2003.
*******
2) From dates.php:
<select name="startday">
<?
for ($i = 1; $i < 32; $i++) {
?>
<option value="<? echo $i ?>"><? echo $i
?></option>
<?
}
?>
</select>
Users may make some stupid mistakes, such as choosing
02-30-2003, 04-31-2003, 06-31-2003, 09-31-2003, or
11-31-2003. These are incorrect dates. There may be
some problems if these errors are stored in database.
3)For the equity section of the balance sheet: it is
different for different type of businesses (sole
proprietorship, partnership, LLC, C-corporation,
S-corporation, and trust). It is better to add a table
for keeping the business information, including the
name of the business, address, phone, fax,
website,email,type of business, accounting method,
year-end date, user-names and passwords,etc.
Thanks,
Kenny Jeong
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
|
