Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jun 2002
    Location
    Barnsley, Yorkshire, England
    Posts
    108
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Question on Design?? (Access2K/Win2K)

    I have a sales/marketing database for my business well under construction. I have it entering orders, prinitng out invoices via Word etc. All working to plan.

    I have a table to hold data of expenses/invoices paid, i.e. suppliers, shipping etc. tblInvoices holds data like to whom, date recd, date paid etc. A linked table, tblInvoiceDetails hold details of Expense Catorgory, amount etc. so i can split any invoice e.g. I pay the post office for shipping and i buy supplies.

    My question relates to Income. Should i take the easy way out and flag each order when it is paid?? Or should i try to record the data a little like the Invoices paid structure??

    Is there an accepted data model for an accounts system?? I guess if i get it right the database could also reconcile my company bank account too..

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Question on Design?? (Access2K/Win2K)

    Actually there are a number of commercial and some shareware/freeware accounting packages based on Access. In addition there are numerous custom applications that include an accounting module much like what you are considering. You might want to visit Tony Toews webpage where he has considerable information on accounting systems based on Access - the URL is http://www.granite.ab.ca/accsacct.htm.

    By all formal accounting standards, you should use a double-entry journal system, which complicates things more than a little - if you do that you should handle income as a separate transaction, rather than simply marking an invoice as paid (which is what we do in our invoicing system - but it doesn't try to do any real accounting). As far as an accepted data model, it is pretty well defined by accounting standards, though when you look under the cover, you may find fairly wide variations. One of the systems I worked with used a single table for customers, suppliers and employees, while another put each in a separate table. Hope this helps.
    Wendell

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Question on Design?? (Access2K/Win2K)

    Record payments in a payments table. You can use the invoice key as a foreign key in the payments table, but invoices and payments are two quite different things and just marking something as "paid" doesn't provide for partial payments, refunds, returns, etc. Double entry bookkeeping isn't as hard as it looks but it can be confusing if you aren't well grounded in the basics. You probably would be better off following Wendell's advice and finding something already built for that purpose.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •