FM8.5

Is it possible to create a sub summary report that omits specified
results. I have a Ledger. Each record is classified according to a
chart of expenses (production, shipping, bank fees etc). I want to
omit specified parts of the chart group (inter account records, wages
ect)


Thanks
Matthew

In article
<9c7a1071-67e5-43d3-b0f6-7e06a1ccc0c8 (AT) j12g2000pri (DOT) googlegroups.com>,
Buckbuck <buck.matthew74 (AT) yahoo (DOT) com> wrote:

Summaries report on the found set of data. So if you do a Find for
specific data, the summaries will report on that specific Found Set.

On Jun 12, 11:25*am, Bill <bbcoll... (AT) earthlink (DOT) net> wrote:
Perhaps some clarity is required. My ledger is a record of my bank
statements and having several banks accounts there are a lot of inter-
account transactions. I have a Chart of Accounts which defines what
tax category any credit or debit falls into. The CoA is defined
through a value list specified through a Table. I have a report layout
with summary and sub-summary fields. I want to edit out the inter-
account transfers from the Report.

Thanks

In article
<a3758c88-842b-4923-abf5-edc38d2099ce (AT) h37g2000pra (DOT) googlegroups.com>,
Buckbuck <buck.matthew74 (AT) yahoo (DOT) com> wrote:

Need more clarity on your overall structure.

Seems to me a double-entry bookkeeping system is needed, with at least
the following tables:
-Chart of Accounts
-Journal (or possibly called Ledger)
-Transaction

Relationships would be:

Transaction::TransactionID = Journal::TransactionID

Journal::AccountID = ChartOfAccounts::AccountID

With this setup, each Journal (or Ledger, if you will) entry is linked
to one transaction and one account. Each transaction is linked to
multiple Journal records, and each Account is linked to multiple Journal
records.

Any one transaction would link to multiple Journal records -- at least
two, and possibly more.

Each bank account would be individually assigned a record in the Chart
of Accounts. So would each Expense, Income, Liability, and other
accounts (bank accounts are Asset accounts, credit cards are Liability
accounts, and you would have appropriate Expense and Income accounts).
Tax accounts would be among the accounts, normally some combination of
Liability accounts for taxes owed but not paid, and Expense accounts for
taxes paid.

Money amounts in any journal record would be Debit or Credit entries.
You should have Debit and Credit fields defined in the Journal table, as
well as summary fields for total debit and credit amounts.

Debits and credits have to balance in any transaction. So, if you move
money from one bank account to another, you would create a transaction
record, and then create two related Journal records, one showing a
Credit entry for the account you are taking money out of (yes, a Credit
entry reduces money in an asset account), and the other showing a Debit
entry in equal amount for the account you are putting money into (yes, a
Debit entry increases money in an asset account).

You need to know standard, double-entry accounting practices to set this
up and do it correctly.

Once you have a system set up, you can make it produce all kinds of
reports for different purposes. Basic reports such as Balance Sheet and
Income Statement are easily done. You can also set up reconciliation
methods for reconciling bank statements, etc.

You can set up calculation fields based on related tables, for example,
fields showing total credits and total debits in any transaction, and
total net debits (or total net credits). Total debits should equal total
credits in any transaction. Calculation fields can also show the total
debits and total credits and total net credits or total net debits for
any account, thus enabling you to determine the balance in a bank
account, for instance.

It would be appropriate to set up a layout based on the Transaction
table, with a portal showing the journal records related to that
transaction. It would also be appropriate to set up a layout based on
the Chart of Accounts table, showing the journal entries related to that
account.

Other possible displays of information will suggest themselves once you
have the basic accounting system set up correctly and understand how to
use it.