Jump to content

  •  

Photo

Complete Accounting System in FileMaker with Source Code

accounting system source code

  • Please log in to reply
15 replies to this topic

#1 transpower  Pooh-Bah

transpower
  • Members
  • 1,443 posts
  • LocationTrevose, PA
  • FM Application:11 Advance
  • Platform:Windows 7
  • Skill Level:Expert
  • Certification:7
  • Time Online: 4h 49m 39s

Posted 21 February 2013 - 10:21 AM

I looked all around FMForums and the Internet for a complete accounting system written in FileMaker with the source code available.  I haven't found anything, except for one at FileMaker.com's Web site--except it doesn't have payroll and general ledger.  I thought that there would be a number of these available. 


  • 0
Transpower (www.transpowercorp.com)

#2 Rick Whitelaw  Time Saver

Rick Whitelaw
  • Members
  • 724 posts
  • LocationToronto, Canada
  • FM Application:13 Advance
  • Platform:Mac OS X Lion
  • Skill Level:Intermediate
  • Time Online: 23d 6h 19m 14s

Posted 21 February 2013 - 05:26 PM

There probably several accounting systems available, but not unlocked. A system like this requires a huge amount of work and developers have to eat too. I suspect if you look around to purchase such a package you might have better luck, although I doubt you'll be able to access the "source code".
  • 0

#3 transpower  Pooh-Bah

transpower
  • Members
  • 1,443 posts
  • LocationTrevose, PA
  • FM Application:11 Advance
  • Platform:Windows 7
  • Skill Level:Expert
  • Certification:7
  • Time Online: 4h 49m 39s

Posted 22 February 2013 - 09:38 AM

Years ago I did a complete accounting system in filePro and was able to customize it for quite a few different clients.  Of course now I'm using FileMaker and would like to have a complete accounting system to customize it for new clients.  Quickbooks is not appropriate for every situation; I did purchase a FileMaker solution which can work with Quickbooks but it's really not very convenient.  I would expect that a complete FileMaker accounting package with source code would cost a few thousand bucks.


  • 0
Transpower (www.transpowercorp.com)

#4 BruceR  consultant

BruceR
  • Members
  • 3,346 posts
  • LocationRedmond WA
  • FM Application:13 Advance
  • Platform:Mac OS X Mountain Lion
  • Skill Level:Expert
  • Certification:9, 11, 12
  • Membership:TechNet
  • Time Online: 32d 13h 21m 30s

Posted 22 February 2013 - 01:00 PM

You're not going to get the source code for this: but they are the pros:

 

New Millenium Genesis Accounting

 

http://www.newmillen...are_GA_Overview


  • 0

#5 Wim Decorte  Carpal Tunnel

Wim Decorte
  • Moderators
  • 3,597 posts
  • LocationToronto
  • FM Application:13 Advance
  • FMGo:iPhone / iPod Touch, iPad
  • Platform:Cross Platform
  • Skill Level:Expert
  • Certification:7, 8, 9, 10, 11, 12, 13
  • Membership:TechNet
  • Time Online: 34d 21h 38m 46s

Posted 22 February 2013 - 05:24 PM

+1 for Genesis.

And what Rick said: programming an accounting system is a ton of work because of the rules involved.  You're never going to find one that is open source.  Those rules also always change so it is a continuous task.


  • 0

#6 transpower  Pooh-Bah

transpower
  • Members
  • 1,443 posts
  • LocationTrevose, PA
  • FM Application:11 Advance
  • Platform:Windows 7
  • Skill Level:Expert
  • Certification:7
  • Time Online: 4h 49m 39s

Posted 23 February 2013 - 12:29 PM

The Genesis program doesn't have Payroll.  Besides, it cannot be customized....


  • 0
Transpower (www.transpowercorp.com)

#7 IdealData  IdealData

IdealData
  • Members
  • 2,613 posts
  • FM Application:12 Advance
  • Platform:Mac OS X Snow Leopard
  • Time Online: 8d 19h 45m 41s

Posted 23 February 2013 - 02:21 PM

I have also been researching the same accounting requirement, and like you have come up with nothing suitable - although Genesis is the closest for bolting on other FM solutions.

 

Obviously there's a gap in the market?


  • 0
Ideal Data - Coherent systems for a chaotic world
I'm available for hire, e-mail me

#8 BruceR  consultant

BruceR
  • Members
  • 3,346 posts
  • LocationRedmond WA
  • FM Application:13 Advance
  • Platform:Mac OS X Mountain Lion
  • Skill Level:Expert
  • Certification:9, 11, 12
  • Membership:TechNet
  • Time Online: 32d 13h 21m 30s

Posted 23 February 2013 - 03:10 PM

Perhaps you can clarify what you mean. The gap in the market is what - that the market does not offer a highly specialized complex product for free? 


  • 1

#9 Rick Whitelaw  Time Saver

Rick Whitelaw
  • Members
  • 724 posts
  • LocationToronto, Canada
  • FM Application:13 Advance
  • Platform:Mac OS X Lion
  • Skill Level:Intermediate
  • Time Online: 23d 6h 19m 14s

Posted 23 February 2013 - 05:08 PM

Some years ago I went looking for a product that would handle my very specialized business and couldn't find one. So I wrote one. Especially as I was learning as I went, it took an untold number of hours. Hundreds for sure, more likely thousands. However, this solution now SAVES ME an untold number of hours and a lot of drudgery. If you don't pay for a product with dollars pay for it with your time if you can spare some.
  • 0

#10 Zed  newbie

Zed
  • Newbies
  • PipPipPipPipPip
  • 5 posts

Posted 23 February 2013 - 10:31 PM

You're not going to get the source code for this: but they are the pros:

 

New Millenium Genesis Accounting

 

http://www.newmillen...are_GA_Overview

 

Yikes, that's one old and outdated looking interface.


  • 0

#11 transpower  Pooh-Bah

transpower
  • Members
  • 1,443 posts
  • LocationTrevose, PA
  • FM Application:11 Advance
  • Platform:Windows 7
  • Skill Level:Expert
  • Certification:7
  • Time Online: 4h 49m 39s

Posted 25 February 2013 - 10:28 AM

Just to clarify, I'm not looking for a "free system."  As stated above, I (or more precisely my clients) would expect to pay a few thousand dollars for a comprehensive FileMaker Accounting System with source code (i.e., unlocked).  Then it's a matter of customizing the program to the specific requirements of each client, for which I would charge my regular consulting fee.  The whole point of this is to avoid starting from scratch.


  • 0
Transpower (www.transpowercorp.com)

#12 Wim Decorte  Carpal Tunnel

Wim Decorte
  • Moderators
  • 3,597 posts
  • LocationToronto
  • FM Application:13 Advance
  • FMGo:iPhone / iPod Touch, iPad
  • Platform:Cross Platform
  • Skill Level:Expert
  • Certification:7, 8, 9, 10, 11, 12, 13
  • Membership:TechNet
  • Time Online: 34d 21h 38m 46s

Posted 25 February 2013 - 06:27 PM

The Genesis program doesn't have Payroll.  Besides, it cannot be customized....

 

It does not do Payroll, but there are several payroll applications it can interface with.  Payroll is not accounting so it has a million different variances unlike accounting that adheres to strict standards.

 

The core of Genesis can not be customized, because it follows those accounting standards.  There is nothing to customize.  However it does allow for a front end to be hooked up to it which is how it does customization.


  • 1

#13 Bob Minteer  novice

Bob Minteer
  • Members
  • 21 posts
  • LocationDallas, TX
  • FM Application:12 Advance
  • Platform:Cross Platform
  • Skill Level:Expert
  • Membership:TechNet
  • Time Online: 7h 35m 47s

Posted 25 February 2013 - 09:35 PM

The success of integrating a "bolt on" accounting system with an existing system is dependent upon the level of customization that is needed to implement the business logic that represents your specific industry.   

 

We attempted to integrate Genesis with our (very mature) solution.   We liked the idea that Genesis was developed and maintained consistent with accounting standards.   New Millennium (NMCI) did a good job creating a system which is consistent with standard practices.

 

Unfortunately, we found that we were unable to completely obtain the functionality that we wanted.   Partly for the same reason that Wim mentions, "Those rules also always change so it is a continuous task.", and partly because expensive licensing and lack of source accessibility did not afford us the flexibility in usage that we needed (our reports change, I provide web service, etc.).

 

In the end, we just put the "bolt-on" system away, stopped paying annual maintenance on an add-on that we didn't own and built our own custom, completley self maintained General Ledger/POS/stock leveling/Work Order and Change Order system.   Payroll for our labor force is managed through our solution.   I have considered possibly adding the ability to use Freshbooks for invoicing if we expand our business into other areas where we may bill hourly.   Flexability!

 

If you have the resources or know-how, I recommend a DIY solution.   The next best, if your bookkeeping department isn't too big, is to use commercial off the shelf software such as Quickbooks via a plugin such as the FMBooks Connector (http://www.productiv...ng.com/fm-books).   With the plugin, you still have ALOT of control but will have to put in some time on the interface between the two to manage the business logic.

 

Those are my thoughts on the topic.  :-)


  • 1

#14 transpower  Pooh-Bah

transpower
  • Members
  • 1,443 posts
  • LocationTrevose, PA
  • FM Application:11 Advance
  • Platform:Windows 7
  • Skill Level:Expert
  • Certification:7
  • Time Online: 4h 49m 39s

Posted 26 February 2013 - 11:14 AM

I have written complete accounting systems in the past, but at this point it's not a good use of my time.  And yes I do have the FMBooks Connector but I found that it was rather clunky to use.  Quickbooks does work for many of my clients, but the others need a lot of customization which Quickbooks does not allow (other than addition of a few fields).


  • 0
Transpower (www.transpowercorp.com)

#15 Sydney@Aeon  newbie

Sydney@Aeon
  • Members
  • 15 posts
  • LocationHACKENSACK, NJ
  • FM Application:13 Advance
  • Platform:Cross Platform
  • Skill Level:Expert
  • Membership:TechNet, FileMaker Business Alliance
  • Time Online: 4d 13h 19m 16s

Posted 20 January 2014 - 07:44 PM

Years ago I did a complete accounting system in filePro and was able to customize it for quite a few different clients.  Of course now I'm using FileMaker and would like to have a complete accounting system to customize it for new clients.  Quickbooks is not appropriate for every situation; I did purchase a FileMaker solution which can work with Quickbooks but it's really not very convenient.  I would expect that a complete FileMaker accounting package with source code would cost a few thousand bucks.

 

I thought I was the only FileMaker developer that used to develop in filePro. I have one client left on filePro and has 1 of the 3 companies he owns moved off filePro and about to have the remaining 2 moved to FileMaker within a month. His old SCO Unix (OpenServer) machine is just barely moving along.


  • 0

#16 John Dunberg  newbie

John Dunberg
  • Newbies
  • PipPipPipPip
  • 4 posts
  • FM Application:12
  • Platform:Mac OS X Mountain Lion
  • Skill Level:Novice

Posted 26 July 2014 - 11:04 AM

I got Easy Accounting from Advance Database Systems and got some tech support from David. He helped me intergrate the solution into mine and shared some helpful technical knowledge that I am very appreciative for. The solution was very clean and easy to use. I would recommend you check it out and I hope it works for you too.

 

If you read this....

Thank you David from Advance Database Systems!


  • 0




FMForum Advertisers