Accounting Reports

[Jason]

I use Access to create a numbr of reports for a small
business. I have created a Balance Sheet and Income
Statement with no problem. I am having a problem with a
Statement of Cash Flows.

The statement should be as follows:
Net Income (summ of income statement)
Operations:
Details of Operating Cash Flow . . .
Cash Flow from Operations (Net Income + Sum of Operations)
Investing:
Details of Investing Cash Flow . . .
Financing:
Details of Financing Cash Flow . . .
Cash Flow (sum of Operations + Investing + Financing)
Then a section with:
Cash at beginning of period
Cash Flow
Cash at end of period

I am having problems with the correct groupings and sub-
totalling.

I have tblGLAccounts (which has a relationship to
tblGLTransactions) which has several different fields
including:
Statement: BalanceSheet or IncomeStatement
Type: Revenue, Expense, Asset, Liability
SubType: Current Asset, Current Liability, Utilities
CashFlow: NetIncome, Operating, Investing & Financing

I figured I can sort and group on CashFlow, but am having
problems with the additional sub-totals and the cash
summaries.

Any help would be appreciated.

Thanks.

 

[Immanuel Sibero]

Hi Jason,

From your description of the problem, I'm not sure I get a clear picture of
what the problem is.

I am having problems with the correct groupings and sub-
totalling.

Are you having a problem subtotaling because the transaction amounts are not
in Debit/Credit format? or Positive/Negative format?

A common design in accounting packages is to have general ledger account
number become the control logic for which amounts go to what reports. In
addition, usually all transaction amounts are stored as positive numbers,
with Debit/Credit transaction codes. So... grouping problems should be
resolved using general ledger account numbers, and subtotaling is resolved
using transaction code (i.e. Debit/Credit).

Sorry I cant help much more than this.

HTH
Immanuel Sibero

 

[Jason]

Hi Immanuel,

The sorting and grouping is not a problem, the gl is setup
to easily accomplish that. Also, the debits and credits
are handled correctly. The problem I am having, and I did
not make that clear, sorry; is that I am having problems
performing some sub-totals . . . let me try to clearify
(Operating Cash Flow, Net Cash Flow and Cash).

Accounts are sorted (and grouped) by Net Income,
Operations, Investing, Financing and Cash.
-Net Income (no detail accounts, sum of net income)
-Operations (detail accounts, with sum of operations)
-Operating Cash Flow (Net Income + Operations) . . .more a
calculation than a grouping.
-Investing (detail accounts, with sum of investing)
-Financing (detail accounts, with sum of financing)
-Net Cash Flow (Operating Cash Flow + Investing +
Financing)

-Cash at Beginning of period
-Net Cash Flow
-Cash at End of period

Hope this clarifys.

Thanks.