Open Sourcing the Accountants by ghkgkyyt

VIEWS: 5 PAGES: 45

									        Open Sourcing the Accountants
                                                   Jethro Carr

                                           <jethro.carr@amberdms.com>


                 A guide to open source accounting applications, how to integrate,
               things-that-you-should-never-never-do and other useful information.




Open Sourcing the Accountants // Jethro Carr
About Me

●   Run Amberdms Ltd, a startup company based here in Wellington!

●Develops the AGPL Amberdms Billing System web-based
accounting/timekeeping/billing system application.

●Background with supporting both proprietary and open source accounting
platforms for companies including ISPs.

●   IANAA + IANAL

●Can be found online at www.jethrocarr.com, jethro.carr@amberdms.com or twitter
@jethrocarr




Open Sourcing the Accountants // Jethro Carr
                       Double-Entry Accounting




Open Sourcing the Accountants // Jethro Carr
       “Money can not be created nor destroyed.”




Open Sourcing the Accountants // Jethro Carr
All transactions “credit” the source account and
“debit” the destination account

The total credits must match the total debits.

Everything always balances.




Open Sourcing the Accountants // Jethro Carr
Transfer between Bank Accounts




  Doing a transfer between actual bank accounts is easy – here I'm transferring
  money from a savings account to current/cheque account.




Open Sourcing the Accountants // Jethro Carr
Invoices are more interesting...




Open Sourcing the Accountants // Jethro Carr
And then the customer makes payment:




Open Sourcing the Accountants // Jethro Carr
     Yes, it is that easy! ;-)




Open Sourcing the Accountants // Jethro Carr
                                 Accounting
                                  Software                       ERP




                                               Billing Systems




Open Sourcing the Accountants // Jethro Carr
 What open source accounting application exist?




And heaps more, see http://en.wikipedia.org/wiki/Comparison_of_accounting_software
Amberdms Billing System
●   Double-Entry Accounting System

●Designed for both small businesses and
service providers.

●   Web-based, PHP/MySQL application.

● In addition to accounting, includes
timekeeping and service billing features.

●Designed to be easy to integrate other
applications and scripts via SOAP API.




www.amberdms.com/billing
SQL-Ledger // Ledger-SMB




 ●   Double-Entry Accounting System

 ●Designed for small business as well
 as including an inventory handling
 system (eg for warehouses/shipments).

 ●Web-based, Perl/PostgreSQL
 application.




www.sql-ledger.org && www.ledgersmb.org
●   Double-Entry Accounting System

●   Suitable for small business

●Includes some nice extras such as inventory handling systems and
bond/stocks.

●   Desktop-Based C/GTK application.




www.gnucash.org
Open Sourcing the Accountants // Jethro Carr
We need a billing system
for our new ISP service!




                           No worries, I'll whip one up tonight
                             It's just a bit of math, easy as.
                              Right, all done, awesome new
                                   application built :-D




  Have you added support
for $complex_tax_situation?




                                      Ah crap.....
2 Months Later....
Please.... kill.... me...
SQL-Ledger Integration

●Official integration limited to writing your own code to run as part of the
application or passing values via HTTP or CLI

●Database Triggers are one option.

●Amberdms has documented large parts of the SQL-Ledger database schema as
of the 2.6 series – email jethro@amberdms.com if you want a copy.




Open Sourcing the Accountants // Jethro Carr
Amberdms Billing System Integration

●   Fully documented SOAP API

●ABS can run on one server, with scripts or other applications on other servers
connecting to it.

●   Strong security controls.




Open Sourcing the Accountants // Jethro Carr
Amberdms Billing System Integration

●General SOAP API developer's documentation:
http://tinyurl.com/yeyty4s

●Data accounting developer/integrator documentation:
http://tinyurl.com/y8utbp6


●Whole bunch of sample code and pre-made scripts to get you started:
http://www.amberdms.com/?cms=opensource_billing_download




Open Sourcing the Accountants // Jethro Carr
What about integrating with proprietary
applications?
●   Database Triggers are your friend

●   Export to a format they can handle, maybe CSV?

●   Migrate to something better! ;-)




Open Sourcing the Accountants // Jethro Carr
     Common Mistakes with Accounting
     Software & what you should look for




Open Sourcing the Accountants // Jethro Carr
                       Scratching your own itch




Open Sourcing the Accountants // Jethro Carr
              Make love to your accountants




Open Sourcing the Accountants // Jethro Carr
           Use proper accounting practices




Open Sourcing the Accountants // Jethro Carr
      Handling crazy habits of customers




Open Sourcing the Accountants // Jethro Carr
Understand your taxation requirements




Open Sourcing the Accountants // Jethro Carr
                          ISP? Hosting Provider?

             Make sure you understand data
                   accounting well.



Open Sourcing the Accountants // Jethro Carr
Open Sourcing the Accountants // Jethro Carr
Data Traffic Accounting

Maximum number in a signed 32-bit integer: 2,147,483,647

That's only 2,147 MB...

On a 10mbit connection, it only takes 28mins to hit that limit...




Open Sourcing the Accountants // Jethro Carr
Please use 64-bit integers!!

Maximum number in a signed 64-bit integer:
9,223,372,036,854,775,807

Unsigned is even more:
18,446,744,073,709,551,615

Much better!




Open Sourcing the Accountants // Jethro Carr
Make sure that you:

Easiest fix is usually just to run a 64-bit of the software on a 64-
bit host.

But not always possible - consider:




Open Sourcing the Accountants // Jethro Carr
             Mwhahaa, I downloaded the
              entire Fedora repo and
               I won't get billed! :-D
                                                      Well, if the router says 4GB,
                                                        that's what it must be.

                                                          I'll make the invoice!




                                     I can only see
                                        4GB... :-(




Open Sourcing the Accountants // Jethro Carr
I HAZ FREE INTERNETS!!! MWHAHAAHHAHA
Make sure you properly understand
your platform!

●   Running 64-bit versions of your application is usually the easiest fix.

●   Make sure database int types are BIGINT.

●If you're running anything on 32bit OS, do your homework – some languages have
64bit extensions (eg perl Math::BigInt) but others like PHP don't.

●   Can cheat – use the DB to do 64bit integer calculations for you.




Open Sourcing the Accountants // Jethro Carr
                              Areas that need help




Open Sourcing the Accountants // Jethro Carr
                                               Payroll




Open Sourcing the Accountants // Jethro Carr
                                       Paymaster OSS Payroll (NZ)

                                http://www.treshna.com/paymaster/




Open Sourcing the Accountants // Jethro Carr
          Busting open proprietary formats




Open Sourcing the Accountants // Jethro Carr
                                               Advocacy




Open Sourcing the Accountants // Jethro Carr
Thank you!

The slides from talk will be available online at www.amberdms.com later today.


You can email me jethro.carr@jethrocarr.com, on twitter @jethrocarr or hunt me
down during the conference if you have any further questions.

My open source accounting application can be found at
www.amberdms.com/billing




PS: if you're an openoffice.org developer, I'd really like to speak to you about some bugs....

								
To top