Re: [GNC] Modify Balance Sheet report in 4.13?
On 3/26/2023 11:35 AM, Stan Brown wrote: Thanks for this, Adrien. As I look further into it, there are some other changes I'll need to make too, so I think exporting to Excel and then editing the HTML may be easier overall. Keeping books for organizations I was always exporting and editing. Keep in mind that the SAME (logical) report would be wanted in different levels of detail for different purposes. Almost always one format/level of detail/grouping for the Board of Directors and another for tax purposes. For example, the BoD might want to see just the total cost of an event. But the treasurer needs "printing and postage" separated out form other costs because a 990/990EZ line item. The BoD might just want to see the total cost to the organizations of all interns but the treasurer needs to see each separately and those each split between "pay" and "mileage reimbursement" (to fill out possible 1099-MISC) and similarly maybe the total of "orchard mowing costs" for the BoD but how much to any neighboring farmers paid again to see if a 1099 needed. Besides, having it outside of gnucash and under the control of and editor makes it easy to add annotations to explain anything unusual. Michael ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Modify Balance Sheet report in 4.13?
Thanks for this, Adrien. As I look further into it, there are some other
changes I'll need to make too, so I think exporting to Excel and then
editing the HTML may be easier overall.
Stan Brown
Tehachapi, CA, USA
https://BrownMath.com
On 2023-03-24 12:52, Adrien Monteleone wrote:
> I don't see that you can as an option, but you can remove the Equity total.
>
> Fortunately those cells have classes, so you can hide them with CSS
> using the CSS stylesheet:
>
> .total-label-cell, .total-number-cell {
> display: none;
> }
>
>
>
> Regards,
> Adrien
>
> On 3/23/23 6:01 PM, Stan Brown wrote:
>> I'm setting up a local nonprofit with GnuCash books. It's a bare-bones
>> organization, with no liabilities.
>>
>> When I run a Balance Sheet report in 4.13, there's a final line, "Total
>> for Liability and Equity". Of course that's appropriate in most cases,
>> but in this case it's redundant with the "Total for Equity" line.
>>
>> I've tried the Display options that seem appropriate, but haven't found
>> any that suppress that line. Is there any way I can modify the report to
>> suppress the "Total for Liability and Equity" line?
>>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Modify Balance Sheet report in 4.13?
I don't see that you can as an option, but you can remove the Equity total.
Fortunately those cells have classes, so you can hide them with CSS
using the CSS stylesheet:
.total-label-cell, .total-number-cell {
display: none;
}
Regards,
Adrien
On 3/23/23 6:01 PM, Stan Brown wrote:
I'm setting up a local nonprofit with GnuCash books. It's a bare-bones
organization, with no liabilities.
When I run a Balance Sheet report in 4.13, there's a final line, "Total
for Liability and Equity". Of course that's appropriate in most cases,
but in this case it's redundant with the "Total for Equity" line.
I've tried the Display options that seem appropriate, but haven't found
any that suppress that line. Is there any way I can modify the report to
suppress the "Total for Liability and Equity" line?
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Modify Balance Sheet report in 4.13?
On 3/23/2023 7:01 PM, Stan Brown wrote: I'm setting up a local nonprofit with GnuCash books. It's a bare-bones organization, with no liabilities. When I run a Balance Sheet report in 4.13, there's a final line, "Total for Liability and Equity". Of course that's appropriate in most cases, but in this case it's redundant with the "Total for Equity" line. I've tried the Display options that seem appropriate, but haven't found any that suppress that line. Is there any way I can modify the report to suppress the "Total for Liability and Equity" line? Stan, let me ask you a question. How do you know you will never be needing to enter one side of a transactions as a liability? When you say "no liabilities" I imagine that is because there is no intention of this organization taking out loans, having organizational credit cards, etc. (even ones NOT used for credit but as "30 day net" accounts). But obvious things like those cases are not the only things that result in transactions affecting an account under liabilities. I will give you a couple examples to think about: 1) The organization is having an "event" for which various supplies will be needed. As a resident of the town, Tom can rent the town hall at a lower rate than somebody outside the town can. So he is detailed to do that. Dick and Harry will be purchasing various supplies needed for the event, At the event, Tom, Dick, and Harry turn the receipts over to the Treasurer who writes then checks to pay them back. How would you be entering all the transactions? 2) The organization is planning a trip and will be collecting from each person going for their share of the bus/driver rental. The amount needed for the bus rental deposit is far more than in the organizational treasury. Mary says, I'll got to the transit company and pay them the deposit. How did you handle that transaction? a) Mary says "I will donate the money needed for the bus deposit, but just fir that purpose, and does that" leaving to you as treasurer to go to the transit company. How did you handle those transactions? b) Begins as "a", but the trip ends up being called off and the deposit is returned. How did you handle that? 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Modify Balance Sheet report in 4.13?
On 3/23/2023 7:01 PM, Stan Brown wrote: I'm setting up a local nonprofit with GnuCash books. It's a bare-bones organization, with no liabilities. When I run a Balance Sheet report in 4.13, there's a final line, "Total for Liability and Equity". Of course that's appropriate in most cases, but in this case it's redundant with the "Total for Equity" line. I've tried the Display options that seem appropriate, but haven't found any that suppress that line. Is there any way I can modify the report to suppress the "Total for Liability and Equity" line? Let me ask you a question. How do you know your little bare-bones non-profit organization will never have a liability? Even with no intent to borrow money, no organizational credit card, etc. Think about these possibilities. a) There is going to be an event. Organization member X is assigned to pick up certain supplies, goes to the stores and does so, paying with their own funds. When they show up at the event with the goods and the receipts, you, the treasurer give then a reimbursement check. How are you entering these transactions? b) There is a major project in the works which will require far more than the organization normally has on hand. A member offers to give a donation specifically for this project << formally restricted; if the project is cancelled, that donation must be returned >> How are you entering this donation? As the Balance Sheet report stands, if you have no liabilities that is clearly shown. Meanwhile, if you really don't want that line to show, export the report form gnucash and edit it before printing. Michael D Novack -- There is no possibility of social justice on a dead planet except the equality of the grave. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
