[GNC] How to run report on Paid Sales for a period? (Cash Accounting Method)

[Fran_3]

 OK, here is the  problem I see when I run a Transaction Report originating from the Accounts Receivable Account and filtered to the Checking Account...
I see, for example...

Line 1:
Account = Assets:Accounts ReceivableTransfer from/to = Assets:Current Assets:Checking AccountAmount = $(80.00)

Line 2:Account = Assets: Accounts ReceivableTransfer from/to = Income:SalesAmount = $80.00
Line 2 shouldn't be there if the report is being filtered first by A/R and then by the Checking Account... right?
With Line 2 there the paid sale gets eliminated from the total "paid" sales for the period.
Any suggestions?
Thanks for the help.

fyi, I'm running gnuCash v2.6.19... 



    On Tuesday, October 1, 2019, 11:25:29 AM EDT, Christopher Lam <christopher.lck at gmail.com> wrote:  
 
 Try transaction report, originating from a/receivable account, filtered to bank account only. Business reports typically prefer to use invoice posted dates rather than payment dates.
On Tue, 1 Oct 2019, 23:17 Fran_3 via gnucash-user, <gnucash-user at gnucash.org> wrote:

Sorry for the flurry of questions but I should be done with project in a few days.
When I run.. Reports > Income & Expenses > Income Statementfor a given period and then selectOptions > Accounts > Sales > ApplyI get total "Sales" for that period weather they are paid or not.
I need to know how much money was actually collected from sales during that period as our small business is accounted for on a "Cash" basis as apposed to an "Accrual" basis.
How can I do this?
Thanks for any help.
PS - I considered this process...
- running the Income Statement for the period (last year)- this gives me Total Sales for Last Year no matter weather paid or unpaid... right?
- then runningReports > Business > Receivable Aging > Options > End of Last Year- that should give me how much money was owed us and unpaid at the End of Last Year- I would then rerun the Receivable Aging Report usingOptions > End of year before Last Year- Now if I subtract Receivables at the end of Last Year from Receivables at the end the year before that I will get the amount owed us and not paid for Last Years sales... right?
- Then I could subtract that from last years sales to get total paid sales last yearor is their a more simple way to do this?



_______________________________________________
gnucash-user mailing list
gnucash-user at gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.