Re: [GNC] Is there a Report for All Expenses Paid between Date A & Date B
On Fri, Sep 11, 2020 at 05:11:34PM -0500, Adrien Monteleone wrote: > Ah, are you using the Business features and you want to only show those > expenses (from invoices) that are paid? > > That's a tougher call. > > With accrual accounting, you book expenses when incurred, not necessarily > when paid. That transaction is separate from the payment. > Which is why cash accounting is so much simpler for small businesses (and PCCs). It's just much more like the way one understands it too. -- Chris Green ___ 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.
Re: [GNC] Is there a Report for All Expenses Paid between Date A & Date B
I'll add that if you are posting bills in order to utilize the Due Reminder feature (and track your account with a Vendor), you can still do this on a cash-basis with a work around. Let's take the example of vendor that has you on Net30 terms. You receive a bill dated today, 9/11/20, due on 9/21/20 and you reasonably expect to make payment in 30 days by 10/21/20, in full. Enter the bill as normal. Post the bill with the 10/21/20 date, which is your expected date of payment, and 30 days from the due date. But put the Date Due as the correct 9/21/20. It will now show up in the Due Reminder and in the Payables Aging report correctly. When you make actual payment, if not on 10/21/20, unpost and repost with that days date, prior to entering the payment in GnuCash, otherwise just process the payment. (If you don't pay in full, you'll have more gymnastics to do.) The expense accounts will still get posted to, but with a future date (10/21/20) to match the expected payment date. (which will eventually be the actual payment date when it happens) Those transactions in AP and in the various Expense accounts will show up underneath a blue line, indicating they are in the future. (their dates will reflect this too, but the blue line makes it easy to spot) Note, there is a preference for 'Blank Transaction before Future Transactions' so you can make new entries 'today' without having to scroll past the future dated transactions. Now, a simple Transaction Report for a date range ending in 'Today' will show you all expenses (or whatever else) that are 'paid'. You can now also run a report to show future expenses if desired. Regards, Adrien ___ 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.
Re: [GNC] Is there a Report for All Expenses Paid between Date A & Date B
The Business features were designed for accrual accounting, but you can use them on a cash basis if you don't post until you make payment. In that case, anything in your expense accounts would be paid. They won't show up otherwise. If you have bills posted that are not yet paid, you should unpost them because posting realizes the expenses as of the posting date rather than the payment date - thus violating the cash basis rule. Once that is cleared up, a simple transaction report will do the trick, or if you want it by account, then do a P with only the expense accounts selected. Note, even without unposting the bills at all, a Transaction Report set to include only accounts that both match an Expenses *and* Checking/Cash will show you those transactions that are paid. Then you'd just have to do the same for those that match Expenses and AP to see what might be left to find or filter out. To get this filtered report: 1. Go to Options > Accounts 2. Select the Expense parent account 3. Click the Select Children button 4. Set Filter > 'Include Transactions to/from Filter Accounts' 5. Select just the 'Checking' and 'Cash' accounts (and any other relevant ones where payment is made on the spot - but not AP or Credit Card accounts, unless you want to consider Credit Card use as 'paid' expenses) 6. Go to General and set your date range. Regards, Adrien On 9/11/20 6:04 PM, Fran_3 via gnucash-user wrote: Thanks Adrian. You zeroed in on the issue. This particular entity is reporting on a cash basis... not accrual.And, sadly, in this case using Invoices that were posted and paid to vendors won't get the entire picture as some incidental purchases/expenses were paid without posting an invoice from the vendor...But, in both cases... they do show up in expenses. So, I guess we are stuck with a lot of work to figure this out.I will read your last reply more carefully this weekend and see if I discover any hint's to make it easier.Thanks again for the help. ___ 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.
Re: [GNC] Is there a Report for All Expenses Paid between Date A & Date B
Thanks Adrian. You zeroed in on the issue. This particular entity is reporting on a cash basis... not accrual.And, sadly, in this case using Invoices that were posted and paid to vendors won't get the entire picture as some incidental purchases/expenses were paid without posting an invoice from the vendor...But, in both cases... they do show up in expenses. So, I guess we are stuck with a lot of work to figure this out.I will read your last reply more carefully this weekend and see if I discover any hint's to make it easier.Thanks again for the help. On Friday, September 11, 2020, 6:11:54 PM EDT, Adrien Monteleone wrote: Ah, are you using the Business features and you want to only show those expenses (from invoices) that are paid? That's a tougher call. With accrual accounting, you book expenses when incurred, not necessarily when paid. That transaction is separate from the payment. Paying a vendor may or may not completely cover any particular line item expense. The idea with accruals isn't just following the Recognition Principle, but also separating the concept of paying expenses individually. (you might be so lucky, but likely not) So you can either track each expense and if it is paid, or you can track if you've paid invoices, but not really both, at least not without lots of work. This would be similar to a credit card. You purchase using the card as payment. The expense is realized right away though technically you didn't pay for them, you used a line of credit. (similar to with vendors) When you do make payment, you track the balance of the account as a whole, not each individual use of the credit line. It is of course possible to see what invoices have been paid and with what payment transactions. Use the Vendor Report. You can run it directly and choose a vendor, or Run the Payables Aging report, then click the total amount for that Vendor (not their name) and you'll get the Vendor report for that vendor. I keep a Payables Aging tab open at all times and just click to run their reports as needed. (same for Receivables) You can go to Options and turn on Display Columns > Links > 'Simple' or 'Detailed' as desired to see the payment transaction links to each invoice. (and vice versa) From there, you can pull up those paid (or unpaid) invoices to see what was covered by payments. That sounds daunting at first, but there is a slight bit of time saving that is possible here, though it requires some spreadsheet KungFu: #1 - you need to not 'accumulate splits' when posting bills. This means that each line item on the bill will show up in the AP and associated expense registers rather than being consolidated. (so if you had multiple line items for 'supplies' each line would show up, rather than just one split for supplies) #2 - Export/Copy-Paste that Transaction Report to a spreadsheet #3 - Do the same for the Vendor Report in another sheet in the same workbook. #4 - Either on the Transaction Report sheet, or a 3rd sheet, write some IF statement formulas (or SUMIF forumals) to show you only expense splits that have matching payments for their bills (or do not) as desired. Note, the bill numbers should show up next to the date as the NUM field. (you might have to make this visible in the Transaction Report when you run it) For any expenses not paid through Bills, you then have to check to see if you made credit card payments, or you can check to see if paid by Checking or Cash and then include them in the summary data. Another option is to learn Scheme and design this report from within GnuCash, or hire someone to do so. But I'd first play with spreadsheets so you see exactly how the data appears and the minimum parts of it you need to make the determination. You can narrow down your expense list by filtering the Accounts used for the Transaction Report to only include transactions that also include say Checking or Cash, then you know those are paid. A separate report could show you expenses that also include AP, so you know those are Bills. A third could show you expenses that also include credit card accounts, so you know you'd have to handle those accordingly. Regards, Adrien On 9/11/20 4:16 PM, Fran_3 via gnucash-user wrote: > How can I limit the report to "Paid Expenses" during the period? > Thanks > > On Friday, September 11, 2020, 3:43:40 PM EDT, Adrien Monteleone > wrote: > > Use the Income Statement (Profit & Loss) but only select Expense > accounts. Set your date range as desired in the General tab. You can > then click the account links to examine which transactions were > affecting the report. > > If you instead want just a list of individual transactions, run the > Transaction report with those same options. (choose only expense > accounts and then set dates accordingly) > > The Transaction report also lets you group them, so you can group by > Payee (description) or by Month for
Re: [GNC] Is there a Report for All Expenses Paid between Date A & Date B
Michael, maybe I got my words mixed up. What we want is a report that shows paid expenses for a defined period. Thanks On Friday, September 11, 2020, 6:02:48 PM EDT, Michael or Penny Novack wrote: On 9/11/2020 5:16 PM, Fran_3 via gnucash-user wrote: > How can I limit the report to "Paid Expenses" during the period? > Thanks WHAT do you mean? The books are not a "budget". They are a record of transactions that have actually taken place. If you did not pay some expense there should not be a record of its payment in your books. What ARE you meaning by the "paid" in "paid expenses"? Michael D Novack ___ 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.
Re: [GNC] Is there a Report for All Expenses Paid between Date A & Date B
Ah, are you using the Business features and you want to only show those expenses (from invoices) that are paid? That's a tougher call. With accrual accounting, you book expenses when incurred, not necessarily when paid. That transaction is separate from the payment. Paying a vendor may or may not completely cover any particular line item expense. The idea with accruals isn't just following the Recognition Principle, but also separating the concept of paying expenses individually. (you might be so lucky, but likely not) So you can either track each expense and if it is paid, or you can track if you've paid invoices, but not really both, at least not without lots of work. This would be similar to a credit card. You purchase using the card as payment. The expense is realized right away though technically you didn't pay for them, you used a line of credit. (similar to with vendors) When you do make payment, you track the balance of the account as a whole, not each individual use of the credit line. It is of course possible to see what invoices have been paid and with what payment transactions. Use the Vendor Report. You can run it directly and choose a vendor, or Run the Payables Aging report, then click the total amount for that Vendor (not their name) and you'll get the Vendor report for that vendor. I keep a Payables Aging tab open at all times and just click to run their reports as needed. (same for Receivables) You can go to Options and turn on Display Columns > Links > 'Simple' or 'Detailed' as desired to see the payment transaction links to each invoice. (and vice versa) From there, you can pull up those paid (or unpaid) invoices to see what was covered by payments. That sounds daunting at first, but there is a slight bit of time saving that is possible here, though it requires some spreadsheet KungFu: #1 - you need to not 'accumulate splits' when posting bills. This means that each line item on the bill will show up in the AP and associated expense registers rather than being consolidated. (so if you had multiple line items for 'supplies' each line would show up, rather than just one split for supplies) #2 - Export/Copy-Paste that Transaction Report to a spreadsheet #3 - Do the same for the Vendor Report in another sheet in the same workbook. #4 - Either on the Transaction Report sheet, or a 3rd sheet, write some IF statement formulas (or SUMIF forumals) to show you only expense splits that have matching payments for their bills (or do not) as desired. Note, the bill numbers should show up next to the date as the NUM field. (you might have to make this visible in the Transaction Report when you run it) For any expenses not paid through Bills, you then have to check to see if you made credit card payments, or you can check to see if paid by Checking or Cash and then include them in the summary data. Another option is to learn Scheme and design this report from within GnuCash, or hire someone to do so. But I'd first play with spreadsheets so you see exactly how the data appears and the minimum parts of it you need to make the determination. You can narrow down your expense list by filtering the Accounts used for the Transaction Report to only include transactions that also include say Checking or Cash, then you know those are paid. A separate report could show you expenses that also include AP, so you know those are Bills. A third could show you expenses that also include credit card accounts, so you know you'd have to handle those accordingly. Regards, Adrien On 9/11/20 4:16 PM, Fran_3 via gnucash-user wrote: How can I limit the report to "Paid Expenses" during the period? Thanks On Friday, September 11, 2020, 3:43:40 PM EDT, Adrien Monteleone wrote: Use the Income Statement (Profit & Loss) but only select Expense accounts. Set your date range as desired in the General tab. You can then click the account links to examine which transactions were affecting the report. If you instead want just a list of individual transactions, run the Transaction report with those same options. (choose only expense accounts and then set dates accordingly) The Transaction report also lets you group them, so you can group by Payee (description) or by Month for example. ___ 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.
Re: [GNC] Is there a Report for All Expenses Paid between Date A & Date B
On 9/11/2020 5:16 PM, Fran_3 via gnucash-user wrote: How can I limit the report to "Paid Expenses" during the period? Thanks WHAT do you mean? The books are not a "budget". They are a record of transactions that have actually taken place. If you did not pay some expense there should not be a record of its payment in your books. What ARE you meaning by the "paid" in "paid expenses"? Michael D Novack ___ 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.
Re: [GNC] Is there a Report for All Expenses Paid between Date A & Date B
How can I limit the report to "Paid Expenses" during the period? Thanks On Friday, September 11, 2020, 3:43:40 PM EDT, Adrien Monteleone wrote: Use the Income Statement (Profit & Loss) but only select Expense accounts. Set your date range as desired in the General tab. You can then click the account links to examine which transactions were affecting the report. If you instead want just a list of individual transactions, run the Transaction report with those same options. (choose only expense accounts and then set dates accordingly) The Transaction report also lets you group them, so you can group by Payee (description) or by Month for example. Regards, Adrien On 9/11/20 11:45 AM, Fran_3 via gnucash-user wrote: > I'm looking for an easy way list all paid expenses for a defined period. > I poked around under Reports and maybe I missed it. > How can I do this? > Thanks for any help. ___ 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.
Re: [GNC] Is there a Report for All Expenses Paid between Date A & Date B
On 9/11/2020 12:45 PM, Fran_3 via gnucash-user wrote: I'm looking for an easy way list all paid expenses for a defined period. I poked around under Reports and maybe I missed it. How can I do this? Thanks for any help. If you want a report that shows, for a defined time period, the transactions in a set of accounts and the account total, you use the "Transaction Report". The options you want in this case are under "accounts" and "general". For accounts you select "expense" and then "all children" << if you wanted just some expenses, different selection criteria >> In general you can set the begin date and the end date. Michael D Novack ___ 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.
Re: [GNC] Is there a Report for All Expenses Paid between Date A & Date B
Use the Income Statement (Profit & Loss) but only select Expense accounts. Set your date range as desired in the General tab. You can then click the account links to examine which transactions were affecting the report. If you instead want just a list of individual transactions, run the Transaction report with those same options. (choose only expense accounts and then set dates accordingly) The Transaction report also lets you group them, so you can group by Payee (description) or by Month for example. Regards, Adrien On 9/11/20 11:45 AM, Fran_3 via gnucash-user wrote: I'm looking for an easy way list all paid expenses for a defined period. I poked around under Reports and maybe I missed it. How can I do this? Thanks for any help. ___ 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.