Home | Blog | Software | Reviews and Features | Forum | Help | Donate | About us
topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • December 08, 2016, 10:16:53 AM
  • Proudly celebrating 10 years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Author Topic: accountancy software  (Read 1848 times)

kalos

  • Member
  • Joined in 2006
  • **
  • default avatar
  • Posts: 1,473
    • View Profile
    • Donate to Member
accountancy software
« on: May 13, 2009, 04:58:46 PM »
hello

I need a software that can transform economic actions into diary entries, for example:

economic action: sell something to a customer or buy from a supplier etc
the software must find and calculate the changes in each account (suppliers, customers, cash, etc) and display them as diary entries, with Double entry bookkeeping system

in other words I need a diary builder (not sic)

anyone knows a software that can do this?

thanks

40hz

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 11,768
    • View Profile
    • Donate to Member
Re: accountancy software
« Reply #1 on: May 14, 2009, 09:09:49 AM »
Is this needed for a small or a large business?

Also, what product is this business currently using for for its accounting?


kalos

  • Member
  • Joined in 2006
  • **
  • default avatar
  • Posts: 1,473
    • View Profile
    • Donate to Member
Re: accountancy software
« Reply #2 on: May 15, 2009, 03:49:45 AM »
it is for medium business (does it have to do with the size?)
currently there is no product used, it's taken by hand
thanks

40hz

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 11,768
    • View Profile
    • Donate to Member
Re: accountancy software
« Reply #3 on: May 15, 2009, 05:33:57 PM »
It's not so much the size of the company as the number of data records I was thinking about.

My (small) company uses Peachtree Accounting. It doesn't have the function you're looking for, and I'm not sure if there are any off-the-shelf packages that do. But what almost all of them do have are data export capabilities. Some also provide integrated or 3rd party report writers that allow for fairly complex reports to be generated from the underlying data.

By way of example, we need several work order analytical reports that Peachtree doesn't provide. We get around that by exporting the relevant raw data which we then import into a series of macro driven Excel spreadsheets. MS Office Excel and Word then generate all the nifty management reports we need. The entire process is now script driven and fairly easy to do. (Note: Peachtree also has 'bigger' and more capable accounting packages available. But they're fairly expensive and border on overkill for my organization so I can't comment on how well something like that would work for your company.)

Depending on the complexity of the reports, and the size of the data sets, our simple approach may or may not be viable for your company. However, if the accounting package you use has an SQL type database underneath it, you should be able to easily extract whatever you want and have some custom programs/scripts/reports written to meet your requirements.

If you go this route, the single most important criteria for selecting an accounting product would be the degree of 'granularity' in your data sets. Your accounting app would need to keep detail records of the data you need in its database. Not all accounting packages do. Some summarize and regularly purge detail records as part of a closing process or file maintenance procedure, so you'll have to ask the package's vendor just what data is tracked, at what level of detail, and how long it's retained.

Best bet is to do a mock-up of the report(s) you want and ask "Can your package do this?" And if not, "Can I get at the data needed to do it myself?"

Many accounting package vendors can arrange to provide a working demo of their product. Take advantage of that before you buy if they offer one. Also inquire into what training and support options are available. If you're going off manual accounting and onto a computer-based system for the first time, you'll want as much help, training, and support as you can get. It's a big job. Doable, but still a lot of work.

Hope this helps. Post any other questions or concerns here and I'll do my best to help you out.



Luck! :Thmbsup: