By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,543 Members | 2,116 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,543 IT Pros & Developers. It's quick & easy.

Accounting

P: n/a
Anybody had experience with the commerical (or open source) Access based
accounting packages out there.

I'm looking to replace a small business accounting package (Peachtree) that
I can't customize enought to do what I need
Nov 13 '05 #1
Share this Question
Share on Google+
16 Replies


P: n/a
Take a look at what Tony Toews has at http://www.granite.ab.ca/accsacct.htm

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Paul" <ca*****@hotmail.com> wrote in message
news:0_POe.9676$137.4345@trnddc08...
Anybody had experience with the commerical (or open source) Access based
accounting packages out there.

I'm looking to replace a small business accounting package (Peachtree)
that I can't customize enought to do what I need

Nov 13 '05 #2

P: n/a
Douglas J. Steele wrote:
Take a look at what Tony Toews has at http://www.granite.ab.ca/accsacct.htm

He has a nice long list. I wonder how many of them provide source code
and for what added cost??

Bob
Nov 13 '05 #3

P: n/a
On Tue, 23 Aug 2005 21:07:19 -0500, Bob Alston
<tu****************@cox.net> wrote:

If you provide him with that information, he might well want to add it
to his page.

-Tom.

Douglas J. Steele wrote:
Take a look at what Tony Toews has at http://www.granite.ab.ca/accsacct.htm

He has a nice long list. I wonder how many of them provide source code
and for what added cost??

Bob


Nov 13 '05 #4

P: n/a
On Wed, 24 Aug 2005 01:23:08 GMT, "Paul" <ca*****@hotmail.com> wrote:
Anybody had experience with the commerical (or open source) Access based
accounting packages out there.

I'm looking to replace a small business accounting package (Peachtree) that
I can't customize enought to do what I need


Have any of you tried to export into Quickbooks? We have had quite a
few requests from clients and get many inquiries from potential ones
to get data from our lodge software into Quickbooks. Our application
basically just tracks revenues. I have no idea how to do this.

I have also thought about offering a 3rd party accounting system as a
module they could purchase (would have to be customizable most
likely), but QB seems to be the way to go (although we aren't big fans
of QB, especially because of their expensive and required web only
updates, etc....).

I will certainly check into the ones listed at this web site. I don't
see any advertised any more in Access Advisor (just FMS tools).

-pw

use paulwilliamson at spamcop dot net for e-mail
Nov 13 '05 #5

P: n/a
Yes I have experimented with Quickbooks Pro

The problem is, like Peachtree, it gets me 80% there and there is no way to
customize some of the forms or add some of the fields I need in invoices,
quotes, etc.

Like Peachtree, Quickbooks appears to be set up for a products (inventory).
I sell services and need a system the recognzies this and allows me to
customize it.
<pa******************@removespamcop.net> wrote in message
news:q1********************************@4ax.com...
On Wed, 24 Aug 2005 01:23:08 GMT, "Paul" <ca*****@hotmail.com> wrote:
Anybody had experience with the commerical (or open source) Access based
accounting packages out there.

I'm looking to replace a small business accounting package (Peachtree)
that
I can't customize enought to do what I need


Have any of you tried to export into Quickbooks? We have had quite a
few requests from clients and get many inquiries from potential ones
to get data from our lodge software into Quickbooks. Our application
basically just tracks revenues. I have no idea how to do this.

I have also thought about offering a 3rd party accounting system as a
module they could purchase (would have to be customizable most
likely), but QB seems to be the way to go (although we aren't big fans
of QB, especially because of their expensive and required web only
updates, etc....).

I will certainly check into the ones listed at this web site. I don't
see any advertised any more in Access Advisor (just FMS tools).

-pw

use paulwilliamson at spamcop dot net for e-mail

Nov 13 '05 #6

P: n/a
QB provides for the ability to import transactions. See the help file
"importing data, IIF file format" for information on the file format.
However the client needs to run the File - Import menu option from QB.

Steven Zuch

<pa******************@removespamcop.net> wrote in message
news:q1********************************@4ax.com...

<snip>
Have any of you tried to export into Quickbooks? We have had quite a
few requests from clients and get many inquiries from potential ones
to get data from our lodge software into Quickbooks. Our application
basically just tracks revenues. I have no idea how to do this.

Nov 13 '05 #7

P: n/a
I alread looked at this list -- it's pretty old.

Most of the software listed hasn't been updated for a year or two. The
demos I downloaded were'nt much help

That's why I asked if anyone has personal experience

"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
news:0Z********************@rogers.com...
Take a look at what Tony Toews has at
http://www.granite.ab.ca/accsacct.htm

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Paul" <ca*****@hotmail.com> wrote in message
news:0_POe.9676$137.4345@trnddc08...
Anybody had experience with the commerical (or open source) Access based
accounting packages out there.

I'm looking to replace a small business accounting package (Peachtree)
that I can't customize enought to do what I need


Nov 13 '05 #8

P: n/a
On Wed, 24 Aug 2005 15:26:28 -0400, "Steve" <st***@nospam.net> wrote:

That's one option, but QB now promotes a more direct xml-based option.
They have an SDK with the details.

-Tom.

QB provides for the ability to import transactions. See the help file
"importing data, IIF file format" for information on the file format.
However the client needs to run the File - Import menu option from QB.

Steven Zuch

<pa******************@removespamcop.net> wrote in message
news:q1********************************@4ax.com.. .

<snip>
Have any of you tried to export into Quickbooks? We have had quite a
few requests from clients and get many inquiries from potential ones
to get data from our lodge software into Quickbooks. Our application
basically just tracks revenues. I have no idea how to do this.


Nov 13 '05 #9

P: n/a
The SDK for Quicbooks works well and is a free download from the Intuit
site.

An excellent product for working with Peachtree data can be found at:
http://www.multiwareinc.com/pawcom.htm

I have found both to be excellent for getting data in and out of Access
and/or Excel.



Tom van Stiphout wrote:
On Wed, 24 Aug 2005 15:26:28 -0400, "Steve" <st***@nospam.net> wrote:

That's one option, but QB now promotes a more direct xml-based option.
They have an SDK with the details.

-Tom.

QB provides for the ability to import transactions. See the help file
"importing data, IIF file format" for information on the file format.
However the client needs to run the File - Import menu option from QB.

Steven ZuchYou

<pa******************@removespamcop.net> wrote in message
news:q1********************************@4ax.com.. .

<snip>
Have any of you tried to export into Quickbooks? We have had quite a
few requests from clients and get many inquiries from potential ones
to get data from our lodge software into Quickbooks. Our application
basically just tracks revenues. I have no idea how to do this.


Nov 13 '05 #10

P: n/a
Tom,

Thanks for the info.

When you say direct, does that mean the end-user does not need to import the
file into QB?

If all they are doing is changing the format of the import file from IIF to
XML, from an end-user point of view, why would they care?

Steven
"Tom van Stiphout" <no*************@cox.net> wrote in message
news:nn********************************@4ax.com...
On Wed, 24 Aug 2005 15:26:28 -0400, "Steve" <st***@nospam.net> wrote:

That's one option, but QB now promotes a more direct xml-based option.
They have an SDK with the details.

-Tom.

QB provides for the ability to import transactions. See the help file
"importing data, IIF file format" for information on the file format.
However the client needs to run the File - Import menu option from QB.

Steven Zuch

<pa******************@removespamcop.net> wrote in message
news:q1********************************@4ax.com. ..

<snip>
Have any of you tried to export into Quickbooks? We have had quite a
few requests from clients and get many inquiries from potential ones
to get data from our lodge software into Quickbooks. Our application
basically just tracks revenues. I have no idea how to do this.

Nov 13 '05 #11

P: n/a
On Fri, 26 Aug 2005 16:57:08 -0400, "Steve" <st***@nospam.net> wrote:

Correct.

There is more to it than that. Happy studying the SDK.

-Tom.

Tom,

Thanks for the info.

When you say direct, does that mean the end-user does not need to import the
file into QB?

If all they are doing is changing the format of the import file from IIF to
XML, from an end-user point of view, why would they care?

Steven
"Tom van Stiphout" <no*************@cox.net> wrote in message
news:nn********************************@4ax.com.. .
On Wed, 24 Aug 2005 15:26:28 -0400, "Steve" <st***@nospam.net> wrote:

That's one option, but QB now promotes a more direct xml-based option.
They have an SDK with the details.

-Tom.

QB provides for the ability to import transactions. See the help file
"importing data, IIF file format" for information on the file format.
However the client needs to run the File - Import menu option from QB.

Steven Zuch

<pa******************@removespamcop.net> wrote in message
news:q1********************************@4ax.com ...

<snip>

Have any of you tried to export into Quickbooks? We have had quite a
few requests from clients and get many inquiries from potential ones
to get data from our lodge software into Quickbooks. Our application
basically just tracks revenues. I have no idea how to do this.


Nov 13 '05 #12

P: n/a
Hi Paul !
How do you do? tell me what do you want to customize in Peachtree
(which is not available in it). I am programmer of VB, ACCESS and
EXCEL.
Take care Bye

MASQ.
Paul wrote:
Anybody had experience with the commerical (or open source) Access based
accounting packages out there.

I'm looking to replace a small business accounting package (Peachtree) that
I can't customize enought to do what I need


Nov 13 '05 #13

P: n/a
Basically I resell services at an hourly or daily rate to large defense
contractors.

I need the customize invoices to show dates and hours worked.

I need to customize the time tracking feature so I can pay subcontractors
based on the time entered in the time tickets.

I need to have additional fields in the inventory tracking that are unique
to labor, not material.

I used to be a programmer (a long time ago) and have written a few VBA
access programs, so I figured Access would do what I want.

My evaluation of some of the commercial MS access programs ( People's
Choice, etc.) doesn't impress me so far.

I also looked at Microsoft's newsmall business accounting. Very
disappointing. It's a warmed over version of Quickbooks

<as*******@gmail.com> wrote in message
news:11*********************@o13g2000cwo.googlegro ups.com...
Hi Paul !
How do you do? tell me what do you want to customize in Peachtree
(which is not available in it). I am programmer of VB, ACCESS and
EXCEL.
Take care Bye

MASQ.
Paul wrote:
Anybody had experience with the commerical (or open source) Access based
accounting packages out there.

I'm looking to replace a small business accounting package (Peachtree)
that
I can't customize enought to do what I need

Nov 13 '05 #14

P: n/a
Paul,

Don't know how you are keeping track of your time tickets but why not

A.) Build an application in Access to keep track of the time.

B.) Use pawcom (for Peachtree) to post the time/billing data from
Access to Peachtree.

This way you can use all the accounting features of Peachtree but
customize your billing in the Access application.

Nov 13 '05 #15

P: n/a
I thought of that, but it requires me to fool around with 2 program.

And it doesn't help the poor choice of fields for incoices and payments to
subs

I was trying to find an canned Access program that was close and provided
the source code so I can create the forms and reports I need
<ot**@bellsouth.net> wrote in message
news:11*********************@g49g2000cwa.googlegro ups.com...
Paul,

Don't know how you are keeping track of your time tickets but why not

A.) Build an application in Access to keep track of the time.

B.) Use pawcom (for Peachtree) to post the time/billing data from
Access to Peachtree.

This way you can use all the accounting features of Peachtree but
customize your billing in the Access application.

Nov 13 '05 #16

P: n/a
"Paul" <ca*****@hotmail.com> wrote:
I alread looked at this list -- it's pretty old.


Yup. If you know of any new ones please let me know and I'll add them.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 13 '05 #17

This discussion thread is closed

Replies have been disabled for this discussion.