Accounting DB
Oct 22, 2005
OK... My DB has began after looking at a few examples and after browsing a book called "Building Accounting Systems
Using Access 2002" A good book....BUT... One MAJOR item left out! The General Ledger. I have made the tables and forms to hold Vendor info, Transaction info, Job info, and a few others. Also have my forms to record checks and deposits, and record the distribution to different GL Accounts. My problem now is "How to build the General Ledger" My final goal will be to have a report that is a "Trial Balance" Showing all GL accounts, balances, and resulting in a final figure of zero. Thus being in balance.
So the question is... What is the best way to aproach this? All the info for the general ledger (at the moment) is input thru the "Checks form" or the "Deposit form" (a third to come will be for adjusting entries to the GL itself)
What is the common method? Using positive and negative numbers? A field for Debit and a second for credit?
Looking for someone to point me in the right direction before I get too far into it.
The DB is attached.... Lots of work and coding still to do... Everything is in a pretty basic form.. But it gives you a good idea of where I'm going. Any suggestions would be of value.
Thanks
View Replies
Sep 5, 2005
I have been searching the web for some examples of a double entry accounting systems made with MS Access. I havent found any that I can open... examine the tables, queries, relationships and everything else. Not that I am planning on spending a year or two building one :) But I want to know how to. So if anyone knows of any good examples please post the links for me. Thanks
View 9 Replies
View Related
Sep 7, 2005
I'm looking for someone who knows a bit about this one... maybe done one before. I've started a DB for an accounting system, I've worked with MANY of these over the years, but from a user standpoint. Now I'm trying a shot at putting one together, just for a learning experience if nothing else. But I would like someone to take a look at the beginning structure of the DB and let me know if I am on the right track. Any input and suggestions would be helpful and appreciated. Keep in mind there is ALOT not here yet... and some loose tables for future expansion. I didn't want to get too deep into it and find out I need to make a major change. I'll post the DB.
Thanks
Curtis
View 4 Replies
View Related
Mar 14, 2008
Recently I've been using QuickBooks, but I'm not very satisfied with it.
For one thing, it's got alot more features than what I'll probably ever be using. But, the main reason I don't really care for it is that there are things that it doesn't seem to be able to do "automatically", and with Access I think I would be able to add a new query and reports that would work as I want.
However, I'd hate to go through the steps of setting up an Access database if someone already had one that they'd be willing to share here. I've seen some topics here from 2006 and earlier, so I didn't want to go back and open them up again in case they were irrelevant at this time.
It just seems that Access would be a better way to go since it could be (somewhat) easily added to or modified as needs arose.
View 12 Replies
View Related
Feb 8, 2006
Within a query i am trying to run historical pension values based on 3 fields from a table:
Value
Year
Period
Period: Is aligned with the accounting year April to March rather than Jan to Dec. So I cannot define Year as 2005 and period 1 to 12.
I am looking to define year as 2005/2006 and then calculated the sum of period 1 to 12.
Has anyone experienced this before and found a solution?
Thanks
View 2 Replies
View Related
Dec 5, 2006
Is there any format that will allow a 0 to show as a - instead. It would be very useful for the situation that has arisen for me.
View 1 Replies
View Related
Aug 5, 2013
I am trying to create an accounting program on access and i got stuck on the final touches
I'll explain my situation in brief. I created two tables
/1 for the invoices (invoice number, client name, total)
/1 for the orders (order id, invoice number, subtotal)
And I made a relationship between those two and everything worked out well. I created a form/subform and put a text box in the subform to calculate the sum which worked correctly. And I exported the value of the sum to the main form and it's great.
The problem is that how can i make the Total field that belongs to the table invoice have a default value as same as the Expression (sum) so that the sum is stored with the invoice record.
i attached the picture in the attachments
View 10 Replies
View Related
Mar 24, 2014
I have a table that stores information for multiple behavioral surveys (numerical values). My goal is to add the proper fields that compose total scores value for each respective survey (do a summation of scores). Now, under design view for my table, I see that I can add a calculated field. When I create this calculated field, I can use the Expression Builder to do a sum of the proper fields (the fields that compose a total score for a survey). The only problem that I'm encountering is that if a field that is part of a survey is missing information, the summation disregards the rest of the values for that survey.
How can I account for these missing values so that, if 1 out of my 9 fields have information, I will still get a summation score for the 9 fields? I want to be able to do this without having to change the value of the missing field to 0.
In SPSS I can easily do this by computing a variable and using a code like this:
SUM.2(field1, field2, field3, etc.)
View 6 Replies
View Related
