Schema for accounting system

[Peter Mount]

Hello

Where can I find a good source for schemas in Access for doing accounting
systems or simlar? I'm currently looking to develop some database tables for
a simple accounting setup using invoices for customers and ordering new
stock items etc.

I've studied manual accounting as well as computerised accounting (in MYOB)
some years ago in my course of studies but I'm very rusty with it.

Thanks

Peter Mount
in**@petermount.au.com

[Tony Toews]

"Peter Mount" <in**@petermount.au.com> wrote:

Where can I find a good source for schemas in Access for doing accounting
systems or simlar?

See if any of the vendors at the Access Based Accounting Systems page at my website
have downloads available. Then poke about in the backend MDB to get a feel for how
they do things.

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

[Mark]

Building Accounting Systems Using Access97, ISBN 0-324-01617-4
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Peter Mount" <in**@petermount.au.com> wrote in message
news:40********@news.iprimus.com.au...

Hello

Where can I find a good source for schemas in Access for doing accounting
systems or simlar? I'm currently looking to develop some database tables for
a simple accounting setup using invoices for customers and ordering new
stock items etc.

I've studied manual accounting as well as computerised accounting (in MYOB)
some years ago in my course of studies but I'm very rusty with it.

Thanks

Peter Mount
in**@petermount.au.com

[DCM Fan]

Use Quicken or QuickBooks...That's alot cheaper than trying to make an Access
application.

[Steve]

On Sat, 17 Jan 2004 17:59:26 +1000, "Peter Mount"
<in**@petermount.au.com> wrote:

Hello

Where can I find a good source for schemas in Access for doing accounting
systems or simlar? I'm currently looking to develop some database tables for
a simple accounting setup using invoices for customers and ordering new
stock items etc.

Given the cost of QuickBooks and similar systems, why?
I've studied manual accounting as well as computerised accounting (in MYOB)
some years ago in my course of studies but I'm very rusty with it.

Even such a basic system can trigger so many issues. Are you tracking
cash, payables? Are you aging the receivables (then must track cash
receipts)? Are you tracking inventory by quantity, by cost (then must
track inventory payments, and deal with inventory flow .. FIFO, LIFO,
Average Cost, Specific Lot ....)?

Even the simple customer and inventory master tables can require
relationships for multiple addresses (customers), or location
(warehouse) and categories.

And then comes the situation of returns, credits, backorders. And
lets not forget the concept of entering in estimates and orders,
before they are shipped and become invoices.

Are you going to want to generate profit and loss statements, sales
reports, and so on?

Make sure you have fully defined the scope of your project, before
starting it, and really consider getting an off the shelf system if
one can handle your needs.

Steven R. Zuch, CPA
Cogent Management Inc.

[Peter Mount]

Hello

To explain why I need to do this, I'm actually developing a CRM system in
ColdFusion MX and I want to put a demo version of it on my business web
site. For my "demo" version of the CRM I will be using Access but for
production versions I will be using SQL Server 2000.

I've actually studied both manual and computerised accounting (with MYOB) as
part of my studies but I'm very rusty with it now. I anticipate I will need
to go over my old school notes.

The accounting component of the "demo CRM" is display a credible accounting
system for sales and inventory. I anticipate a live producition CRM
(together with the accounts section) would be customised for different
clients. I have a personal friend who's worked in the Accounting field so he
could help me with pointing out what I need to revise on.

I really need to look at sample schemas for doing this in Access 2000 so I
can get a kick start on it while I go over my old school notes.

Thanks

Peter Mount
in**@petermount.au.com

"Steve" <st***@nospam.com> wrote in message
news:40****************@news.westnet.com...

On Sat, 17 Jan 2004 17:59:26 +1000, "Peter Mount"
<in**@petermount.au.com> wrote:

Hello

Where can I find a good source for schemas in Access for doing accounting
systems or simlar? I'm currently looking to develop some database tables fora simple accounting setup using invoices for customers and ordering new
stock items etc.

Given the cost of QuickBooks and similar systems, why?

I've studied manual accounting as well as computerised accounting (in MYOB)some years ago in my course of studies but I'm very rusty with it.

Even such a basic system can trigger so many issues. Are you tracking
cash, payables? Are you aging the receivables (then must track cash
receipts)? Are you tracking inventory by quantity, by cost (then must
track inventory payments, and deal with inventory flow .. FIFO, LIFO,
Average Cost, Specific Lot ....)?

Even the simple customer and inventory master tables can require
relationships for multiple addresses (customers), or location
(warehouse) and categories.

And then comes the situation of returns, credits, backorders. And
lets not forget the concept of entering in estimates and orders,
before they are shipped and become invoices.

Are you going to want to generate profit and loss statements, sales
reports, and so on?

Make sure you have fully defined the scope of your project, before
starting it, and really consider getting an off the shelf system if
one can handle your needs.

Steven R. Zuch, CPA
Cogent Management Inc.