Best to use system which has inventory accounting as then you won't have to worry about accounting double entry as system will generate it for you automatically. When you enter a purchase invoice it will have a quantity purchase field so item will be put into stock at cost and quantity. Then there will be a manufacturing transaction which will take it out of raw materials and into finished stock (assemblies) at cost and quantity.. When it's sold it there will be a sales transaction in quantity and price which will generate an invoice and take item out of finished product stock in quantity and cost, and then calculate the sales less cost of goods sold so you know your margins
Hardly any of this can be done by GnuCash so you will need to use spread sheets and have a course in accounting. Plus ,a half decent accounting system which has inventory accounting would also have sales and purchase order management and a bill of material system to hold your soap recipes. David On Tue, 22 Mar 2022, 02:49 , <gnucash-user-requ...@gnucash.org> wrote: > Send gnucash-user mailing list submissions to > gnucash-user@gnucash.org > > To subscribe or unsubscribe via the World Wide Web, visit > https://lists.gnucash.org/mailman/listinfo/gnucash-user > or, via email, send a message with subject or body 'help' to > gnucash-user-requ...@gnucash.org > > You can reach the person managing the list at > gnucash-user-ow...@gnucash.org > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of gnucash-user digest..." > > > Today's Topics: > > 1. Re: Report - Income Statement - Layout problem > (Carl-Kensaku HERBORT) > 2. Re: Have you abandoned gnuCash email list? U were so > helpful! (Fran_3) > 3. Re: Have you abandoned gnuCash email list? U were so > helpful! (David Carlson) > 4. Re: Have you abandoned gnuCash email list? U were so > helpful! (Michael or Penny Novack) > 5. Re: Question about Assemblies (Adrien Monteleone) > 6. Re: Printing checks (Adrien Monteleone) > 7. Re: gnucash-user Digest, Vol 228, Issue 33 (Adrien Monteleone) > 8. Re: Question Re: Transaction Report on Expenses, All > Children, for 2021 (Adrien Monteleone) > 9. Re: How to create Transaction Report Filter on Checking to > only show Accounts Payable Transactions? (Adrien Monteleone) > 10. Re: Report Help (Adrien Monteleone) > 11. Re: Report Help (Adrien Monteleone) > 12. Re: Report - Income Statement - Layout problem > (Adrien Monteleone) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Mon, 21 Mar 2022 19:49:09 +0100 > From: Carl-Kensaku HERBORT <i...@digiene.ch> > To: gnucash-user@gnucash.org > Subject: Re: [GNC] Report - Income Statement - Layout problem > Message-ID: <de61c7f7-116c-49fd-e1fd-55b52eee6...@digiene.ch> > Content-Type: text/plain; charset=UTF-8; format=flowed > > Hello, > > Yes, it happens with all the stylesheets. > > No, I haven't modified any of the stylesheets. > > Thank you for your help > > Best regards > > Carl-Kensaku HERBORT > DIGIENE > Case postale > CH-1002 Lausanne > Suisse > > +41 (0) 21 320 22 66 > > Le 20.03.22 ? 23:02, John Ralls a ?crit?: > > I can't reproduce that here. Does that happen with all of the > stylesheets? Have you perhaps modified the Technicolor stylesheet so that > the Revenue block is smaller than the Expenses one? > > > > Regards, > > John Ralls > > > > > >> On Mar 20, 2022, at 9:51 AM, Carl-Kensaku HERBORT <i...@digiene.ch> > wrote: > >> > >> Hello, > >> > >> The effective nesting level is the same. > >> > >> No, I don't need an option to justify columns. I just need the income > statement report to look as normal as the balance sheet report (see screen > capture). > >> > >> I really don't need anything more. > >> > >> Have a nice week-end > >> > >> Best regards > >> > >> -- > >> Carl-Kensaku HERBORT > >> DIGIENE > >> Case postale > >> CH-1002 Lausanne > >> Suisse > >> > >> +41 (0) 21 320 22 66 > >> > >> Le 20.03.22 ? 16:27, Michael or Penny Novack a ?crit : > >>> On 3/20/2022 5:21 AM, Carl-Kensaku HERBORT wrote: > >>>> Hello again, > >>>> > >>>> I have tried a more recent version on MacOS (Version 4.9 / build ID > 4.9+(2021-12-18) / Finance::Quote:-). It solves the first problem of string > translation. > >>>> > >>>> But the second problem is still there: the width and column alignment > of the revenue part is not synchronized with those of the expense part. > >>>> > >>>> Do you have any ideas ? > >>> You did not say ---- is the effective nesting level of income and > expense the same? > >>> Even if so, the resulting report would not be what I wanted in a > report in the final form I would be presenting to the board at meetings or > having published in an annual report << I used to be treasurer of some > 501(c)3 organizations and used gnucash to keep the books >> > >>> I suspect that what you want (from the developers) is an option to > "justify columns from the right". That's what I would have in the "finished > product" reports. In the case of the Income Statement (Statement of > Revenues and Expenses --- what a non-profit calls this report) but also > with Balance Sheet reports. Instead of writing custom reports* I export and > then edit with full control over the level of detail in different parts, > column alignment, etc. and can add annotation as needed. There is a lot of > detail work** in producing a "pretty print" report. > >>> Michael D Novack > >>> * I am a retired pro. While not fluent in the language used to create > the reports, I can at least read LISP and so soon could be << when you have > written in half a dozen languages, what's one more >> But the first time > this came up, I was advised not to bother, just export raw reports and edit > to the finished product. Great editors already exist so why try to reinvent > the wheel. > >>> ** For example, page breaks. You don't want them at an awkward place > in the report so might want to insert some blank lines to prevent that. You > might want top levels or total lines a different font size or bold, et. > >>> _______________________________________________ > >>> 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. > >> > <2022-03-18-11h36-gnucash-balance-sheet-report.png><2022-03-18-11h37-gnucash-income-statement-report.png>_______________________________________________ > >> 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. > > > > > ------------------------------ > > Message: 2 > Date: Mon, 21 Mar 2022 18:58:15 +0000 (UTC) > From: Fran_3 <mailbox0...@yahoo.com> > To: Christopher Lam <christopher....@gmail.com>, David Carlson > <david.carlson....@gmail.com> > Cc: GnuCash users group <gnucash-user@gnucash.org> > Subject: Re: [GNC] Have you abandoned gnuCash email list? U were so > helpful! > Message-ID: <1584166493.1482161.1647889095...@mail.yahoo.com> > Content-Type: text/plain; charset=UTF-8 > > Not phishing. I use gnuCash each year for a 2 or 3 weeks to help 3 very > small entities here in Florida.They make the data inputs during the year > and I try and help them organize their annual financials for their tax guy > to do their taxes. > That said, I am not an accountant but I know enough to get by with a > little help from the great gnuCash forum members. > And, I will say that I am a big fan of the program... even though I wish > it could also generate reports on a cash basis... as opposed to an accrual > basis... but I can get there by exporting select gnuCash accounts and > Transaction Reports to cvs files and then loading them into Google Sheets > or Excel. > Thanks.Fran LeeFlorida > > > On Monday, March 21, 2022, 10:45:36 AM EDT, David Carlson < > david.carlson....@gmail.com> wrote: > > That looks to me like it was an exceptionally well crafted phishing email > > On Sun, Mar 20, 2022 at 8:20 PM Christopher Lam <christopher....@gmail.com> > wrote: > > On Sun, 20 Mar 2022 at 14:34, Fran_3 <mailbox0...@yahoo.com> wrote: > > > (snip). > > > Now I don't see you participating and it seems traffic on the list is way > > down. > > Have the developers abandoned the project? > > > > Thank you Fran; no, the project is alive as long as there is interest in > it. The number of live bugs seems to be decreasing, hence the slow decline > in traffic. It seems the community is being very helpful, thus there's > little need to intervene. > _______________________________________________ > 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. > > > > -- > David Carlson > > > ------------------------------ > > Message: 3 > Date: Mon, 21 Mar 2022 15:17:03 -0500 > From: David Carlson <david.carlson....@gmail.com> > To: Fran_3 <mailbox0...@yahoo.com> > Cc: Christopher Lam <christopher....@gmail.com>, GnuCash users group > <gnucash-user@gnucash.org> > Subject: Re: [GNC] Have you abandoned gnuCash email list? U were so > helpful! > Message-ID: > <CADYgSb=3WmCsWVpHdfBPzY0tkshCgp9AirzPhT= > so+t-yee...@mail.gmail.com> > Content-Type: text/plain; charset="UTF-8" > > Fran_3, > > I did not see your original message. Did you send it directly to > Christopher instead of the list? That is seriously discouraged, and the > primary reason that I thought that was phishing. > > On Mon, Mar 21, 2022 at 1:58 PM Fran_3 <mailbox0...@yahoo.com> wrote: > > > Not phishing. I use gnuCash each year for a 2 or 3 weeks to help 3 very > > small entities here in Florida. > > They make the data inputs during the year and I try and help them > organize > > their annual financials for their tax guy to do their taxes. > > > > That said, I am not an accountant but I know enough to get by with a > > little help from the great gnuCash forum members. > > > > And, I will say that I am a big fan of the program... even though I wish > > it could also generate reports on a cash basis... as opposed to an > accrual > > basis... but I can get there by exporting select gnuCash accounts and > > Transaction Reports to cvs files and then loading them into Google Sheets > > or Excel. > > > > Thanks. > > Fran Lee > > Florida > > > > > > > > On Monday, March 21, 2022, 10:45:36 AM EDT, David Carlson < > > david.carlson....@gmail.com> wrote: > > > > > > That looks to me like it was an exceptionally well crafted phishing email > > > > On Sun, Mar 20, 2022 at 8:20 PM Christopher Lam < > christopher....@gmail.com> > > wrote: > > > > On Sun, 20 Mar 2022 at 14:34, Fran_3 <mailbox0...@yahoo.com> wrote: > > > > > (snip). > > > > > Now I don't see you participating and it seems traffic on the list is way > > > down. > > > Have the developers abandoned the project? > > > > > > > Thank you Fran; no, the project is alive as long as there is interest in > > it. The number of live bugs seems to be decreasing, hence the slow > decline > > in traffic. It seems the community is being very helpful, thus there's > > little need to intervene. > > > > _______________________________________________ > > 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. > > > > > > > > -- > > David Carlson > > > > > > -- > David Carlson > > > ------------------------------ > > Message: 4 > Date: Mon, 21 Mar 2022 17:00:38 -0400 > From: Michael or Penny Novack <stepbystepf...@comcast.net> > To: gnucash-user@gnucash.org > Subject: Re: [GNC] Have you abandoned gnuCash email list? U were so > helpful! > Message-ID: <e258068d-2aec-6d8d-ec01-203372ce4...@comcast.net> > Content-Type: text/plain; charset=UTF-8; format=flowed > > On 3/21/2022 2:58 PM, Fran_3 via gnucash-user wrote: > > > even though I wish it could also generate reports on a cash basis... > as opposed to an accrual basis... but I can get there by exporting select > gnuCash accounts and Transaction Reports to cvs files and then loading them > into Google Sheets or Excel. > > Thanks.Fran LeeFlorida > > > Gnucash certainly can keep books on the cash basis << all the orgs I > kept books for were cash basis >> > > What it can't do is support the "business features" like invoicing > except accrual basis. That's awkward for those organizations that would > like to send members/donors "statements". Also awkward for those rare > businesses that cannot/should not consider product shipments as sales > (yet) because are on an "approval" basis. > > Michael D Novack > > > > > ------------------------------ > > Message: 5 > Date: Mon, 21 Mar 2022 19:34:56 -0500 > From: Adrien Monteleone <adrien.montele...@lusfiber.net> > To: gnucash-u...@lists.gnucash.org > Subject: Re: [GNC] Question about Assemblies > Message-ID: <t1b5jh$16ev$1...@ciao.gmane.io> > Content-Type: text/plain; charset=UTF-8; format=flowed > > Fred, please be sure to always copy the list address on all replies so > the discussion stays on the list. > > That way, others can benefit from the discussion, as well as chime in > and help out. > > Also keep in mind, we don't give accounting advice here. If you need > such advice, you need the services of an accountant. > > But once you know 'what' to do, we can help you with the 'how to do it > in GnuCash.' > > ----- > > I am not familiar with Sage so I can't explain how GnuCash works in > reference to what you were doing before. > > There is no inventory management in GnuCash. > > You can set up accounts to track the *value* of your inventory, but not > the quantity. (at least not out of the box, and without lots of work) > > You should make entries when you purchase ingredients/materials. > > Then you should make entries when you assemble or make something from > those. > > Then you make more entries when you sell the assembled products. > > Basic Accounting Generic Examples > --------------------------------- > > When you purchase ingredients for soap: > > Dr. Assets:Inventory:Raw Materials > Cr. Assets:Bank > > This 'moves' money from your bank account to 'Raw Materials'. (which is > now in the form of Inventory, so this records the value of that inventory) > > When you make the soap: > > Dr. Assets:Inventory:Work In Progress > Cr. Assets:Inventory:Raw Materials > > This moves that value from Raw Materials to inventory 'in production' > but not yet finished. (this step may be optional for you if the time > involved in production is rather short, like one day or less and you > package as part of the basic production process.) > > When you package the final product ready for sale: > > Dr. Assets:Inventory:Finished Goods > Cr. Assets:Inventory:Work In Progress > > This moves the value from 'in production' to its final state as a > Saleable Good or Finished Product. > > When you sell a finished product: > > Dr. Assets:Cash > Cr. Revenue:Sales > Dr. Expenses:Costs of Goods Sold > Cr. Assets:Inventory:Finished Goods > > For this last one, the value of the first two splits should be equal, > and the value of the last two splits should be equal. (but they will of > course be less than the first two, or else you aren't making a profit!) > > The first two splits record the receipt of payment (could be > 'Undeposited Funds' if by Credit Card or Paper Check instead of 'Cash') > and 'recognizes' the revenue earned. (by type, in this case 'Sales > Revenue') > > The second two splits move the value of the inventory sold out of > inventory entirely, and records it as an expense of doing business. > (which will eventually be subtracted from revenue to obtain 'income', > Revenue - Expenses = Income) The Profit & Loss Report or Income > Statement Report (same report - different names) will handle that math > for you. > > Your actual transactions may differ, but this is a 'big picture' > overview of the generic inventory-to-sales process. > > ------ > > The math for figuring out the value of raw materials that go into a > product that you'll need for making those 'in progress'/'finished goods' > entries in GnuCash is something you're going to have to setup outside of > GnuCash in a spreadsheet or other inventory management software. > > If you like, it is possible to export the result from the spreadsheet or > other software into GnuCash so you don't have to manually cross-enter > anything. > > If you only have one or a small handful of products you only need do the > math by hand once, and then you can just duplicate those transactions > changing the dates. > > You can also put in the Memo fields the proportions of each ingredient > as a reminder, then enter that as a math equation in the transaction > instead of just a final number. GnuCash can do the calculations for you. > > ------ > There are no shortcuts if you're going to do your own accounting. You > just have to learn it. > > It really isn't difficult, and you don't have to learn 'all' of > accounting, just what you need for your business. (and you won't learn > it all at once, most likely, as you find out you need to know it) > > Accounting is not about difficult or fancy math. The hard part is > learning 'how to account' properly for your activity. That's it. > > > Regards, > Adrien > > > On Mar 17, 2022 w12d76, at 10:20 AM, Frederick <freder...@justsoap.com> > wrote: > > > > Hi Adrian, thanks for your response. > > > > Unfortunately i am a bit confused by it, however. I am sure this comes > from being as guy who makes soap and the accounting is done, only as a > necessity and not by way of my profession. I am definitely trying to avoid > taking an accounting course (-: > > > > I am a maker of stuff that wants to track assembly-build (Sage 50 > terms) as i do now with my Sage 50 software. I set up my system to > purchase ingredients and then Assemble-Build these ingredients into > finished goods that i sell. I track quantities and value of ingredients > and finished goods. I am looking for a different platform to do this > tracking, both monetary and quantity. It sounds like you are saying the > monetary tracking is possible but the quantity/item tracking is not. Sage > 50 does both and i make use of both features. > > > > There is a response to this question by a Liz. I am not sure how to > keep the question and responses from branching out to multiple threads. I > hope the above and below responds to her questions. > > > > This was set up 10 plus years ago and i do not even recall what might be > meant by how you account for manufacturing costs when you invoice, nor how > you spread this income in your accounts. > > > > Thanks for the help and my apologies if my very limited understanding of > accounting makes your responses difficult for me to comprehend. There is > every possibility that I just need to look for a less accountant based > system. I make soap and just do the accounting to permit the soap making. > > > > ------------------------------ > > Message: 6 > Date: Mon, 21 Mar 2022 19:39:48 -0500 > From: Adrien Monteleone <adrien.montele...@lusfiber.net> > To: gnucash-u...@lists.gnucash.org > Subject: Re: [GNC] Printing checks > Message-ID: <t1b5sl$mjj$1...@ciao.gmane.io> > Content-Type: text/plain; charset=UTF-8; format=flowed > > Someone more familiar with printing checks will hopefully chime in, but > I seem to recall a recent thread where it was noted that if your > Vendor/Employee/Customer 'payee' is already set up with name and > address, *and* you try to 'Print Checks' with the existing transaction > selected, GnuCash *should* auto-populate that info for you. > > As to why you can't edit it otherwise, I'm not certain. > > Regards, > Adrien > > On 3/17/22 12:24 PM, ja...@ljmiller.com wrote: > > Just set up GNUcash. Print Check window shows a list of options, but > only the default, Quicken/QuickBooks(tm) US-Letter is available. I need to > use Quicken(tm) Wallet Checks w/side stub, as that is the paper I have on > hand, having migrated from QuickBooks. When I choose this option, I am > unable to type in a name or address-box is gray. > > I welcome any suggestions as to how to access the needed option. > > > > ------------------------------ > > Message: 7 > Date: Mon, 21 Mar 2022 19:46:24 -0500 > From: Adrien Monteleone <adrien.montele...@lusfiber.net> > To: gnucash-u...@lists.gnucash.org > Subject: Re: [GNC] gnucash-user Digest, Vol 228, Issue 33 > Message-ID: <t1b691$il9$1...@ciao.gmane.io> > Content-Type: text/plain; charset=UTF-8; format=flowed > > As I noted in another reply today, if this is just a handful of > products, you can likely set up a simple spreadsheet to do the assembly > math for you, and then import the result to GnuCash. > > While spreadsheets aren't part of GnuCash, we can help with how to set > that math up, and in a form ready for export/import if you want to go > that route. > > Otherwise, there are other inventory management apps out that that can > generate the resulting accounting transactions ready for import. Some of > them are not terribly expensive, and some are OpenSource and also Free. > (as in beer) Though the Free apps may come with features you don't need, > and will be a bit of a learning curve to set up for your business. > > Regards, > Adrien > > On 3/17/22 4:42 PM, Frederick wrote: > > Thanks for the information and suggestion David. Not on any kind of a > significant scale, just a one person operation making a modest living. I > own and am using an old version of Sage 50 currently (and happy with it!), > but they want $600 annually for the ?subscription? service now offered. > My version is having problems getting ?authorized? by Sage when i open the > program and it will not work when i switch to Windows 11. I do not make > enough to justify $600 for accounting software, but i may be my only > option. I am looking for a free or at least reasonably priced alternative. > > > > ------------------------------ > > Message: 8 > Date: Mon, 21 Mar 2022 20:01:52 -0500 > From: Adrien Monteleone <adrien.montele...@lusfiber.net> > To: gnucash-u...@lists.gnucash.org > Subject: Re: [GNC] Question Re: Transaction Report on Expenses, All > Children, for 2021 > Message-ID: <t1b760$8ie$1...@ciao.gmane.io> > Content-Type: text/plain; charset=UTF-8; format=flowed > > Fran, > > Do a bit of reading on 'Accrual' vs. 'Cash' accounting. > > The Business Features of GnuCash are designed for the Accrual method. > > With a bit of small fuss, they can be used for the Cash method too. > > Expenses in the Accrual method are 'recognized' when 'incurred'. That > is, when you 'owe' the money to whomever you purchased something (good > or service) that is when you incurred the expense, not when you happen > to get around to physically paying their invoice. The idea here is that > you are recording expenses in the same period that you use those > expenses (good or services) to generate revenue. > > A similar process takes place with Sales. You 'earn' Revenue when the > sale is made (usually upon 'good delivery') and the actual timing of the > receipt of payment is not part of when you made the sale. (your vendors > 'earn' their revenue when they deliver a good or service to you, not > when you pay them, which is why you incur the expense at their point of > 'good delivery' as that is when you legally 'owe' them.) > > Accounts Receivable and Accounts Payable are used to track actual > payments made and received, while still recording the expenses and > revenue when they are incurred and earned. > > Now, read up on the 'Matching Principle' of accounting. It will explain > why it is done this way. > > With the Cash method, you aren't concerned with when you incur expenses > or when you earn revenue, but when you make payment or receive payment. > For businesses that pay for inventory up front, and receive payment at > the exchange of goods, this makes sense. > > For businesses that purchase on credit and sell on credit, it is a mess > and makes little sense. (it also makes it difficult to analyze your > historical sales activity and expenses, because they don't match each > other.) For this reason and for these cases, Accrual accounting is > employed rather than the Cash method. > > ----- > What it appears you are describing is that you are using the Business > Features as normal, and thus using the Accrual Method, but for some > reason (not yet explained) you want an Expense Report on a Cash Basis. > > That's fine, but beware, if your accounting is supposed to be on a Cash > Basis, you should probably alter your GnuCash workflow to assist with > this and make reporting easier and more accurate. And if not, then sure, > you can still generate Cash Basis reports as you found out. > > Regards, > Adrien > > On 3/18/22 9:50 AM, Fran_3 via gnucash-user wrote: > > My Bad.?Expenses are created when the bill is posted... not when it is > paid.Here is how it works...1 - Get Bill from Vendor X2 - Post bill from > Vendor X to AP3 - Charge bill to Expense Acct Whatever4 - Pay Bill and > Charge Checking Account and relive AP > > So to get all expenses paid in 2021 you would create a Transaction > Report on the Checking Account for the time period you desire...And set the > Sorting Option Primary Key to "Other Account"And then lookup Accounts > Payable Total in the results. > > And if you know how you could set the Transaction Report Filter to only > show Checking Transactions charged to Accounts Payable...I'm posting > another thread on that... more properly titled... to help other poor > souls... like me :-) > > > > > > On Thursday, March 17, 2022, 07:58:14 PM EDT, Fran_3 via > gnucash-user <gnucash-user@gnucash.org> wrote: > > > > Situation: > > We posted a bill in 2020 but paid it in 2021. > > I need to create an Expense report for all expenses paid in 2021... > regardless of when the bill was posted... > > My attempted solution:I created a Transaction Report on "Expenses" with > "All Children"? selected...And with a date range of 1/1/2021 to 12/31/2021 > > The Problem:The payment for the 2020 bill does not show in the > report...Even though the expense was paid in paid in 2021. > > How can I create a report that will show all expenses paid in 2021 > regardless of when the bill was posted? > > > > ------------------------------ > > Message: 9 > Date: Mon, 21 Mar 2022 20:09:08 -0500 > From: Adrien Monteleone <adrien.montele...@lusfiber.net> > To: gnucash-u...@lists.gnucash.org > Subject: Re: [GNC] How to create Transaction Report Filter on Checking > to only show Accounts Payable Transactions? > Message-ID: <t1b7jk$10si$1...@ciao.gmane.io> > Content-Type: text/plain; charset=UTF-8; format=flowed > > Fran > > On the Accounts tab in Options for the report, choose "Filter Type: > Include Transactions to/from Filter Accounts" and then in Filter By... > choose the Accounts Payable account. > > You can further refine the results using the Filter tab, to specific > Description/Notes/Memo as you are already familiar doing so. > > Another option is from the Accounts tab of the main GnuCash window, do a > Find where your accounts match the bank account *and* Accounts Payable > and then any other criteria. Then run an Account Report on the search > results. > > Regards, > Adrien > > On 3/18/22 9:58 AM, Fran_3 via gnucash-user wrote: > > I struggle with the Transaction Report Filter. > > The Situation:If I create a Transaction Report on Checking for last > year...- I can enter key words from the Description field or from the > Memo/Notes field...- into Transaction Filter field...- and it works > fine...ButIf I enter "Accounts Payable" into the Transaction Filter > field... it does not work.Ditto if I enter "Transfer from/to = Accounts > Payable" > > The Question:How do I filter a Transaction Report on Checking to only > show Accounts Payable transactions? > > > > ------------------------------ > > Message: 10 > Date: Mon, 21 Mar 2022 20:24:14 -0500 > From: Adrien Monteleone <adrien.montele...@lusfiber.net> > To: gnucash-u...@lists.gnucash.org > Subject: Re: [GNC] Report Help > Message-ID: <t1b8fu$lss$1...@ciao.gmane.io> > Content-Type: text/plain; charset=UTF-8; format=flowed > > The Account Summary is a snapshot, that's why it doesn't let you select > a range. (similar to a Balance Sheet) > > Your other options are an Income Statement/P&L (which won't show > anything but Expense & Income accounts) or perhaps an Equity Statement > or the Balance Sheet which includes Equity, Assets & Liabilities. (which > again, are snapshots and rolls Income/Expense into Equity) > > The closest to the Account Summary with a date range is the Trial > Balance Report. (be sure to set Account Depth to 'All' on the Accounts > tab in Options) > > You can get sort of close with a Transaction Report if you select all > accounts on the Accounts tab, clear everything *but* Account Name & > Totals on the Display tab, set your desired date range on the General > tab, and then select "Show subtotals only (hide transactional data)" on > the Sorting tab. > > Regards, > Adrien > > On 3/19/22 10:39 AM, Brock Rycenga wrote: > > Hello, > > > > Looking for help with [custom] reports. I like the look of the Account > > Summary report, but there is no way to fully customize the date range > (only > > a starting date, or ending date - not both). I like that report format > the > > best because it shows the account hierarchy with a total for the top > level > > of any account with sub-accounts. Anyone know how to do this with a > > transactional report? Is there another report I should start with to get > > the look/feel of the Account Summary report, but with a fully custom date > > range? > > > > ------------------------------ > > Message: 11 > Date: Mon, 21 Mar 2022 20:29:58 -0500 > From: Adrien Monteleone <adrien.montele...@lusfiber.net> > To: gnucash-u...@lists.gnucash.org > Subject: Re: [GNC] Report Help > Message-ID: <t1b8qm$lss$2...@ciao.gmane.io> > Content-Type: text/plain; charset=UTF-8; format=flowed > > I have some custom reports (not my own, from other users posted on this > list) that have worked in 3.x. But they did need some tweaks to get them > working in 4.x. This is due to changes in the report system. > > Also try to reach out on IRC. The devs hang out there (as well as here) > and can assist more with tracking down the failure and maybe point you > to where to research for a solution. > > Before going any further, make sure you know how to run GnuCash from the > command line and obtain a Tracefile so you can see any errors reported. > > Regards, > Adrien > > On 3/20/22 4:28 PM, David T. via gnucash-user wrote: > > Well, I see that you put a note in that section saying it didn't work in > 4.6 last September, so you are already aware of this fact. > > > > Since in my 17 years (!) of using gnucash I have never succeeded in > creating or even loading a custom report-- and believe me, there were times > when I really tried--I will not attempt to offer you advice with your > custom report problem, whatever it may turn out to be. > > > > I *will* say that you'll have better success if you tell people what > you're trying to accomplish, and what specifically the problem is that > you've encountered. Telling us the page is broken is just noise and serves > no purpose. > > > > It's clear from the page history that you know how that content came > into being (i.e., Gnucash users), and also how it can be changed. So once > you figure out what does work, you can update the wiki for everyone else. > > > > ------------------------------ > > Message: 12 > Date: Mon, 21 Mar 2022 21:47:32 -0500 > From: Adrien Monteleone <adrien.montele...@lusfiber.net> > To: gnucash-u...@lists.gnucash.org > Subject: Re: [GNC] Report - Income Statement - Layout problem > Message-ID: <t1bdc5$k10$1...@ciao.gmane.io> > Content-Type: text/plain; charset=UTF-8; format=flowed > > I can reproduce with 4.9 on BigSur. > > Investigating using Firefox Inspector to view the HTML, I see that there > is padding being added to the Expenses section. > > For me, this only happens at depths 5,6, & ALL. > > It seems the left hand column where the labels are, is expanding to fit > the depth of accounts requested *and* the text of those account names. > > In my case, my Expense depth is greater than my Income depth. (which is > capped at 4, and thus why I see the bug appear at 5 or higher) > > I also happen to have a few accounts with long names, so the effect is > not as great for me as for the OP, but it seems this string length will > influence the calculated width. > > The effect shows up because the Expense section and the Income section > are two separate HTML tables, and thus their columns are sizing > independent of each other to contain their respective content. > > One possible fix (while still using tables) is to make the entire report > a single table though that would of course require a bit of visual > tweaking to get back to what it looks like now. > > In the meantime, I'm investigating replacing the inserted ' ' as an > account label indention mechanism, with something else. (either another > empty <td> and thus another column, or a means to pad the cells via CSS) > > There might be a 'non-table' solution, but that too would take quite a > bit of investigation and a complete re-write of the report(s) affected. > > Regards, > Adrien > > On 3/20/22 5:02 PM, John Ralls wrote: > > I can't reproduce that here. Does that happen with all of the > stylesheets? Have you perhaps modified the Technicolor stylesheet so that > the Revenue block is smaller than the Expenses one? > > > > ------------------------------ > > Subject: Digest Footer > > _______________________________________________ > > 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. > > > ------------------------------ > > End of gnucash-user Digest, Vol 228, Issue 42 > ********************************************* > _______________________________________________ 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.