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....@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@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@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.
_______________________________________________
gnucash-user mailing list
gnucash-user@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.
