Re: [GNC] How to get a report in a format which is easy to edit?

[Chris Green]

On Tue, Mar 05, 2024 at 11:54:35PM -0600, Adrien Monteleone wrote:
> Yes, those PDFs are indeed reasonably editable. Even LibreOffice can 
> pull it off.
> 
Which PDFs?  All the ones I have produced are images.  What's the
'standard' route from a GnuCash report to PDF (on Linux, so
LibreOffice etc. are here by default).

-- 
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to get a report in a format which is easy to edit?

[Chris Green]

On Wed, Mar 06, 2024 at 10:09:03AM +1100, Alan Hopkins wrote:
> 
> Additionally, there are pdf editors out there that do a good job (some are
> cross-platform) - my pdf's produced from GnuCash are all editable (I use
> Linux) - not graphic images - maybe look for another driver/app to achieve
> what you need?

This is what I'm after.  I'm all Linux based but so far whatever route
I take to get from GnuCash's HTML to PDF I end up with a PDF file with
images rather than text in it.

What do you use to convert to PDF?

-- 
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to get a report in a format which is easy to edit?

[Adrien Monteleone]

Yes, those PDFs are indeed reasonably editable. Even LibreOffice can 
pull it off.


Otherwise, your answer is to either edit the HTML (which is the native 
format of the reports once rendered) or put them in a spreadsheet which 
relieves you of the HTML and leaves you with rows and cells that are 
easily customizable, manipulable, and upon which you can perform 
functions since the cell contents aren't just 'images' but rather actual 
text and/or numbers some of which have known formats.


What exactly are you asking for otherwise? Magic?

What *exactly* (with maybe an example?) do you mean by "look nice?"

I'd hazard whatever you are attempting is easily achievable via moving 
to a spreadsheet app.


But let us back up one step.

You are now speaking not of editing per se, but of presentation. That's 
a different beast entirely.


And for that, GnuCash offers some features. Look into and investigate 
(play with) stylesheets for reports. You might be able to customize an 
existing one either using its preset features, or even use the 'custom 
css' stylesheet.


Otherwise, you can of course, delve in to writing your own, but now 
you're treading into that 'dreaded HTML' ground you erroneously think is 
so treacherous.


Regards,
Adrien

On 3/5/24 4:17 PM, Chris Green wrote:

You are a glutton for punishment!!!  Who on earth would try to make a
report 'look nice' (which is what I'm trying to do) using a
spreadsheet!??



___
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] Old check

[R Losey]

Thanks! I really don't think it will be presented; I checked with the
person I sent it to, and she thinks she tore it up, but she wasn't sure.
So, I'll carry it until I close the account.


On Mon, Mar 4, 2024 at 11:22 PM David Reiser  wrote:

> Before you get tempted to pay for a stop-payment order (just to be sure…),
> check the terms and conditions written in your bank agreement. Many banks
> don’t promise to actually not pay the check. There are often weasel words
> about “best effort” etc. It happened to my sister. She paid for a
> stop-payment order. When the check arrived at the bank, they paid it. Then
> they hit her with an overdraft fee because the supposedly stopped payment
> took her balance below zero. Eventually, she got them to refund the
> stop-payment fee and the overdraft fee, but they told her she’d have to get
> the money back herself from the payee.
> --
> Dave Reiser
> dbrei...@icloud.com
>
>
> On Mar 4, 2024, at 11:25 PM, R Losey  wrote:
>
> Best wishes -- I'm still waiting for a check from 2018 to clear. I checked
> with my bank (I thought a check would not be valid after a certain time),
> and they said they'd honor it if it showed up today.  I don't want to spend
> the money to issue a stop-check order.
>
>
-- 
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
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] How to get a report in a format which is easy to edit?

[Alan Hopkins]

Chris

I support Adrien here - he is trying to assist you to get to the end-point
you want.

HTML reports can be imported into any decent word processing software. You
don't need to edit the HTML code.

And you can make financial reports look great using a spreadsheet - I've
been doing that for decades. Perhaps you might consider doing a short
course on using spreadsheets for layout?

Additionally, there are pdf editors out there that do a good job (some are
cross-platform) - my pdf's produced from GnuCash are all editable (I use
Linux) - not graphic images - maybe look for another driver/app to achieve
what you need? Years ago when using Windoze & the earliest versions of
Quickbooks which didn't print to pdf I used a free app - I think it was
called something like PDF24 creator - the pdfs produced by it were also
editable.

Anyway, keep trying & you'll find a suitable method to do what you want.

Cheers

Alan


On Wed, 6 Mar 2024, 9:18 am Chris Green,  wrote:

> On Tue, Mar 05, 2024 at 02:16:57PM -0600, Adrien Monteleone wrote:
> > You can also select-all and copy/paste into a spreadsheet while viewing
> > any report.
> >
> You are a glutton for punishment!!!  Who on earth would try to make a
> report 'look nice' (which is what I'm trying to do) using a
> spreadsheet!??
>
> --
> 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
> -
> 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] How to get a report in a format which is easy to edit?

[Chris Green]

On Tue, Mar 05, 2024 at 02:16:57PM -0600, Adrien Monteleone wrote:
> You can also select-all and copy/paste into a spreadsheet while viewing 
> any report.
> 
You are a glutton for punishment!!!  Who on earth would try to make a
report 'look nice' (which is what I'm trying to do) using a
spreadsheet!??

-- 
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to get a report in a format which is easy to edit?

[Chris Green]

On Tue, Mar 05, 2024 at 02:16:27PM -0600, Adrien Monteleone wrote:
> The standard export/save of reports is an HTML table.
> 
> You can edit that with any decent text editor, and/or open/import it 
> into a spreadsheet app for further manipulation.
> 
Editing HTML is *NOT* my favourite occupation.  Any other format,
whether markup of some sort or word-precessor is infinitely better.

-- 
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to get a report in a format which is easy to edit?

[Adrien Monteleone]

You can also select-all and copy/paste into a spreadsheet while viewing 
any report.


Regards,
Adrien

On 3/5/24 10:43 AM, Chris Green wrote:

Is there any way to get a report from GnuCash in some sort of editable
format?

I have tried various ways, including printing to file as a PDF but I
always end up with a PDF file made up of images which is quite useless
for editing.  I want to be able to change the size and typeface of
some of the entries.

Surely there's a way to get an edtable report!?



___
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] How to get a report in a format which is easy to edit?

[Adrien Monteleone]

The standard export/save of reports is an HTML table.

You can edit that with any decent text editor, and/or open/import it 
into a spreadsheet app for further manipulation.


Regards,
Adrien

On 3/5/24 10:43 AM, Chris Green wrote:

Is there any way to get a report from GnuCash in some sort of editable
format?

I have tried various ways, including printing to file as a PDF but I
always end up with a PDF file made up of images which is quite useless
for editing.  I want to be able to change the size and typeface of
some of the entries.

Surely there's a way to get an edtable report!?



___
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.

[GNC] How to get a report in a format which is easy to edit?

[Chris Green]

Is there any way to get a report from GnuCash in some sort of editable
format?

I have tried various ways, including printing to file as a PDF but I
always end up with a PDF file made up of images which is quite useless
for editing.  I want to be able to change the size and typeface of
some of the entries.

Surely there's a way to get an edtable report!?

-- 
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How can I book Sales when invoice is paid vs when posted?

[Adrien Monteleone]

On 3/4/24 11:34 PM, Blake Hannaford wrote:

1) At end of year, figure out the total dollar amount of unpaid invoices.


Check the Receivables Aging Report. This should give you the total you want.


2) Create a new Income account "unpaid sales"
3) Debit sales by the unpaid total and credit "unpaid sales" > 4) Ideally see if 
"unpaid sales" can be omitted from the income statement
report.
5) Otherwise, manually subtract "unpaid sales" from Total income to get
income tax liability


You can select which accounts appear in a report via the Accounts tab 
under Options.



6) At start of next year, keep "unpaid sales" but zero out all other income
accounts (transfer to year-end equity - my usual system for income and
expenses)


No need to zero sales. Your next year's Income Statement won't take 
previous year's transactions into account anyway.



7) During the year, either move the total back to sales immediately or when
each invoice is paid, manually debit "unpaid sales" and credit "sales" for
that amount.


You can alternatively not post bills until you receive payment, or post 
them as normal so they'll show up on a Customer Report, but then unpost, 
repost with new date and apply payment when it arrives.


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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] split transaction description field length limit

[Tim via gnucash-user]

Yes that's why I set up a sole proprietorship with employer ID so I can pay all 
the payroll taxes, deduct income tax and pay it to the government, pay 
unemployment, Worker's Comp. insurance etc. I agree with you that it's very 
important to do those things properly.

 

I'm using gnucash mostly for my personal books as opposed to the sole 
proprietorship books which are so simple that we’re doing them in a spreadsheet 
right now with the exception of the payroll software we use to try to make sure 
we get all the deductions right.

 

My sole proprietorship invoices me for the fully burdened cost of each month’s 
payroll and I reimburse it fully from my personal bank account into the sole 
proprietorship bank account. It sounds as though my solution will be to set up 
AR for my sole proprietorship and enter all of the line items into an invoice 
to myself personally. Up until now I'd been using a simple paper invoice.

 

Thank you so much for the suggestion.

 

Tim

 

From: Alan Johnson  
Sent: Monday, March 4, 2024 11:01 AM
To: timothyscu...@yahoo.com; 'David Carlson' 
Cc: 'gnucash-user' 
Subject: Re: [GNC] split transaction description field length limit

 

I use GNUCash for tracking rental properties as well. You can create as many 
expense accounts to track to whatever level of detail is needed.

 

For example, I have my structure set up as:

Expenses:

Overall R

-Property 1 R

--Property 1 HVAC

--Property1 General

--Property 1 Electrical

--etc

 

-Property 2 R

--Property 2 HVAC

--Property 2 General

--Property 2 Electrical

--etc

 

When you run a P at the end of the year, it will break out how much was in 
each expense category, as well as a total for each property. 

 

Not a CPA or legal advice, but I understand that if you are paying payroll to 
employees, you still need to pay payroll tax unless they are their own 
business/1099, in which they should be paying their taxes accordingly.  

 

You can assign as many line items and expense accounts/line items to the 
invoices as you need. That's their intended function.  You can also pay line 
items into an asset or liability account (such as witheld taxes).  

 

Your handyman should provide you with a bill (or a work order).  

 

- Fixed property 1's toilet. 1 hr@ $x

 

You create a vendor in the vendor system (Handyman LLC)

Create an invoice 

Line item - Toilet repair $x Account: Expenses:Property1 R:Property1 Plumbing

Line Item - Outlet repair $y Account: Expenses:Property1 R:Property1 
Electrical

Line Item - Door knob repair $z Account: Expenses: Property2 R: 
Property2:General

Total $A

- Post invoice

 

Vendors -> Process Payment

 

Pay Handyman LLC $A from Assets:RentalCheckingAccount with check 1234 

 

 

On Mon, 2024-03-04 at 09:46 -0800, timothyscu...@yahoo.com 
  wrote:

I greatly appreciate your suggestions.

 

I don't think I framed the problem completely. I have several rental properties 
and before I migrated to GNU cash I was using Quicken to generate “itemized 
spending” reports from which I could fill out schedule E for each property. 
When I tried to do the same thing with GNU cash for the transactions associated 
with, for example maintenance on property 1 or repairs on property 2 I did get 
a list of transactions but the descriptions of them were so truncated that it 
wasn't practical for me to verify the correctness of them the way I used to be 
able to do by just looking down the column of transactions.

 

I have a tiny sole proprietorship which runs a payroll to pay my part-time 
handyman and a part-time bookkeeper to avoid nanny tax and Worker's Comp. 
problems but my sole proprietorship's income is just reimbursements from me as 
an individual.

 

If I were to pervert the gnucash vendor bill payment system to detail the work 
my part-time employees do, would I be able to assign line items on an invoice 
to different GNU cash expense accounts associated with the different properties 
people worked on? And would reports generated by GNU cash be able to list the 
detail for the line items? That's my ultimate goal. I want to be able to 
generate reports from the gnucash for each calendar year, which also happens to 
be my tax year, so I can use that information to fill out schedule E for each 
rental property. I'm comfortable with doing that manually but I have been 
spoiled by having reports from Quicken that provide the detail associated with 
each expense account in a form that's easy to double check.

 

Thank you again for trying to help with my problem.

 

Tim

 

From: Alan Johnson mailto:a...@argentwolf.org> > 
Sent: Monday, March 4, 2024 7:43 AM
To: David Carlson mailto:david.carlson@gmail.com> >
Cc: timothyscu...@yahoo.com  ; gnucash-user 
mailto:gnucash-u...@lists.gnucash.org> >
Subject: Re: [GNC] split transaction description field length limit

 

You don't have to have 'a business' to use the business features.  You 

Re: [GNC] How can I book Sales when invoice is paid vs when posted?

[Michael or Penny Novack]

I'm not going to comment on "does that sound right?" The accounts used 
and workflow to temporarily convert accrual to cash are an accounting 
matter, not a gnucash matter. As for there not being a "setting", that 
make no sense. The difference between "cash" and "accrual" is LOGICAL 
(the timing when certain financial events are considered to have happened).


In other words, suppose you were keeping books on the "cash basis". You 
sold a customer some goods or services and sent them an invoice (maybe 
just typed one out). At this point, for legal purposes that amount IS a 
"receivable", and you could sue in court if the purchaser refused to pay 
(or say died -- you are asking the estate to pay). That you do not 
record this in the books as a "sale" until paid is besides the point.


Note also that whether you can freely choose to report on the cash basis 
or accrual basis or be forced to use one or the other may depend on the 
rules for your jurisdiction.


Michael D Novack


On 3/5/2024 12:34 AM, Blake Hannaford wrote:

Thank you all for helpful responses so far.   It is too bad that accrual vs
cash invoice accounting is not a setting.   At any rate I usually only have
a handful of outstanding invoices at a time.I propose the following:

1) At end of year, figure out the total dollar amount of unpaid invoices.

2) Create a new Income account "unpaid sales"
3) Debit sales by the unpaid total and credit "unpaid sales"
4) Ideally see if "unpaid sales" can be omitted from the income statement
report.
5) Otherwise, manually subtract "unpaid sales" from Total income to get
income tax liability
6) At start of next year, keep "unpaid sales" but zero out all other income
accounts (transfer to year-end equity - my usual system for income and
expenses)
7) During the year, either move the total back to sales immediately or when
each invoice is paid, manually debit "unpaid sales" and credit "sales" for
that amount.

Does that sound right?
BH



--
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.

Re: [GNC] gnucash-user Digest, Vol 252, Issue 3

[Michael or Penny Novack]

On 3/4/2024 11:25 PM, R Losey wrote:

Best wishes -- I'm still waiting for a check from 2018 to clear. I checked
with my bank (I thought a check would not be valid after a certain time),
and they said they'd honor it if it showed up today.  I don't want to spend
the money to issue a stop-check order.


The amount of time a (personal or small business) ordinary check remains 
valid depends on the institution. The bank MAY use six months as the 
period before declaring stale (the "uniform") but is allowed to use a 
longer amount of time AND is not liable for damage it might cost you if 
they allow a "stale check".


This is a "check with your bank" situation. It is important to know if 
your bank uses moire than six months.


Michael D Novack

PS -- This is for the US. I have no idea about what the time period 
might be for other jurisdictions. And even here note I said personal or 
small business. Large businesses often have specified on the check "void 
after" and Treasury checks by law are good for one year. Also, 
things like certified checks, cashier's checks, etc. have different rules.



___
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.