Re: Accounting Reports in Access

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Sarah,

I think you are trying to design and develop an accounting system for
your property management company. To make things clearer to you, let
me brief you on some of the fundamental elements and concepts in
creating accounting reports.

you have to create a table for a chart of account, that contains
account no,description, account category (asset/liability/Revenue/
cost), a Parent table to store transactional posting journals, and a
group of table connecting to it. these table will represents your
individual child table that normally resemble each of your accounting
modules, namely, your inventory, AR, AP modules.

Now, in your parent table, you need to have columns to store data such
as, journal no, account code, amount, description, period and year.The
trick here is, your debit and credit amount is stored under one column
(amount), conforming to conventional accounting double-entry rules.The
period and year columns, acts as your filtering tool, you can pull
data for any period in any particular year. Most importantly, you can
generate an opening balance for last year, with currrent year
transactional journals having displayed as breakdown. The trick in
generating whatever accounting reports, is using your creativity and
skill in your sql scripting.

All the Best to you!



.

Relevant Pages

  • Re: Grocery stores banks et al.
    ... price of the machine, the installation, maintenance, security, and ... there is still a certain amount of manual labor in accounting and ...
    (rec.food.cooking)
  • Re: $10 Million Cancer Study: Data Was Fabricated
    ... >> This is a particularly heinous fraud, ... I *could* use simple accounting methods ... I don't, because it's *my* money. ... expect you to account for your expenses, even an amount as small as a ...
    (alt.true-crime)
  • RE: Multiple Spreadsheet,Not sure what to use? Vlookup works for f
    ... accounting department and column 4 is the $amount. ... In the new spreadsheet I ...
    (microsoft.public.excel.worksheet.functions)
  • Re: OT:Obamas tax plan will cost me money
    ... amount of money in our business account greater than what was in it at ... No, it isn't, but many technically trained small business owners look at it ... so the "Percentage of Completion" method of accounting was used. ... If I owed someone money, ...
    (rec.boats)
  • Re: security test question
    ... It's a trick ... > I am not trying to cheat on anything. ... > Accounting. ...
    (microsoft.public.security)