Transaction report pass through accounts payable

[Derek Atkins]

"Maf. King" <maf at chilwell.net> writes:

> On Tue 24 April 12 15:06:23 Nate Dudenhoeffer wrote:
>> I use gnucash for business accounting, and am trying to create a report
>> from my main checking account, which shows the "other account" for each
>> transaction.  Of course, showing splits.  The problem is the majority of my
>> transactions have "Accounts Payable" as the "other account."  How can I
>> generate a report which will show the splits defined on the bills for each
>> transaction in my checking account?
>
> Hi Nate,
>
> If I understand you correctly, then I don't think you can get exactly what you 
> want reported.
>
> I think that you are trying to subtotal several different Expenses accounts, 
> based on transactions from your Bank to the A/P account.
>
> So you have bill recorded in A/P, for £150, which is split as;
>
> Expenses:Widgets   £100
> Expenses:BitsNBobs £50.
>
> But all you see in the bank account is £150 -> A/P.
>
> I can't think of a way for a report to "link" a payment of a bill with the 
> contents of that bill.  The bank account only knows about £150, there is no 
> information about how that 150 is allocated.  That info is only in the A/P 
> account.
>
> Maybe you can get something from the transaction report, running on the A/P 
> account and bank account, but filtering out transactions between the two and 
> subtotalling by "other account" 

Another option is that you could try using the Cash Flow account and
select both the Bank account *and* the AP account?

> HTH,
> Maf.

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek
-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available