1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
|
FibuSQL 0.4
-----------
(c) 2002, 2003 Martin Pitt (martin@piware.de)
This software is protected by the GNU General Public License. See file
COPYING for the complete text of the license.
What is FibuSQL?
----------------
FibuSQL is a system for double-entry accounting. It has been designed
mainly for private use, it currently does not offer special support
for commercial use (particular support for tax accounts, etc.),
although the author appreciates any hints how to improve this program
for this purpose.
The system uses only free software. The data management is done by a
database. The web interface is implemented in PHP4
(http://www.php.net). FibuSQL can be completely controlled with a web
browser; no special software is necessary on on client computers.
Features
--------
* implements the system of double-entry accounting
* easy installation on the server; clients only need a web browser
* web interface can handle arbitrary many books; the concrete
database can be chosen at the login
* data is kept in a database; this means speed, reliability,
integrity, and proper authentication; in addition, this approach
guarantees access to the data also to other applications
* Login data (username, password, etc.) may be preselected partly
or completely for a convenient login
* freely definable account tree; accounts can be added and removed
at any time (if they do not contain bookings)
* automatic maintenance of the ledger, which is always up to date
* support for recurring bookings (every n days or months)
* statistics modules: currently there is a monthly overview over
balances and balance changes
* integrated backup and recovery; supports the formats CSV (appropriate to
import/export from/to spreadsheet programs) and XML
* export of ledger in XML format; reports can be generated by applying an
XSLT stylesheet
* support for multiple languages; new languages can be added easily
because the strings to translate are separated from the actual
pages
* uses only validated XHTML 1.1 standard to ensure maximum browser
compatibility
* FibuSQL is distributed under the terms and conditions of the GNU
General Public License (see file COPYING), thus is free.
The following features are not supported (yet):
* combined bookings
* special acconts (tax accounts, etc.)
* explicit annual financial statement
Databases
-----------
FibuSQL uses the PEAR::DB database abstraction layer which supports
(in principle!) many database systems. FibuSQL has been developed
to comply to the ANSI SQL 1992 standard. However, by now only
PostgreSQL and mySQL have been tested. I will appreciate a note how
FibuSQL gets along with other databases.
Documentation
-------------
FibuSQL contains an online documentation in HTML format in the
directory doc-en/. It describes installation, usage and administration
and also contains some advice to developers wanting to improve
FibuSQL.
Upgrading from version 0.3
--------------------------
The database format did not change between 0.3 and 0.4, so there are no
compatibility problems. If you are upgrading, you only have to convert the
former 'logindata.php' (that was directly included) to the new ini file
'fibusql.conf'. This new configuration file does not only contain the database
login data, but also other configuration options that affect the interface.
It is still not required, you can still set all options at the login form.
|
