Re: [GNC] Can I find transactions into an account that has only one split?

2023-11-21 Thread Adrien Monteleone

(face palm!)

Yes, thanks Chris! (not just for the suggestion, but for the awesome 
report work too!)


Regards,
Adrien

On 11/22/23 12:43 AM, Christopher Lam wrote:

Check the Transaction Report's Account tab.

On Wed, 22 Nov 2023, 2:36 pm Adrien Monteleone, <
adrien.montele...@lusfiber.net> wrote:


Yeah, that's why I started off with this would be trial and error level
effort.

The OP wants transactions where at least one split appears in set A, but
excludes any such transactions when *other splits* also appear in set B.

I *think* this is possible, but I have to admit, I've never tried.

I'm guessing that running two separate Finds, one from the Accounts
page, and one from the Find results register is the way to go, but I
could be mistaken.

I'm guessing that trying it all in one go will fall into the trap you
mention.

But if the result register is somehow 'fixed' to the original splits
found, this entire endeavor may not be possible.


___
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] Can I find transactions into an account that has only one split?

2023-11-21 Thread Christopher Lam
Check the Transaction Report's Account tab.

On Wed, 22 Nov 2023, 2:36 pm Adrien Monteleone, <
adrien.montele...@lusfiber.net> wrote:

> Yeah, that's why I started off with this would be trial and error level
> effort.
>
> The OP wants transactions where at least one split appears in set A, but
> excludes any such transactions when *other splits* also appear in set B.
>
> I *think* this is possible, but I have to admit, I've never tried.
>
> I'm guessing that running two separate Finds, one from the Accounts
> page, and one from the Find results register is the way to go, but I
> could be mistaken.
>
> I'm guessing that trying it all in one go will fall into the trap you
> mention.
>
> But if the result register is somehow 'fixed' to the original splits
> found, this entire endeavor may not be possible.
>
> Regards,
> Adrien
>
> On 11/22/23 12:00 AM, Derek Atkins wrote:
> > Keep in mind that, GENERALLY, the search is on a SPLIT basis, not a
> > TRANSACTION basis.  So if you do a search on "Account == X AND Account ==
> > Y" you will get an empty set, because it is impossible to find anything
> > where Split.account == X and Split.account ALSO equals Y.
>
> ___
> 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] Can I find transactions into an account that has only one split?

2023-11-21 Thread Adrien Monteleone
Another option is to just open the Assets:PayPal register and look over 
them one by one to see if they contain an additional split to 
Expenses:PayPal Fees, then edit the ones that do not as needed.


Regards,
Adrien

On 11/21/23 7:43 PM, David Kirkby wrote:

I often receive PayPal transactions, which get put into the PayPal account
as

Credit: Assets: Accounts Receivable (£720.00)
Debit: Assets:PayPal  (£720.00)

What I should then do is edit the PayPal account so the fees are put in the
correct place - for one example transaction

Credit: Assets: Accounts Receivable (£720)
Debit: Assets:PayPal  (£705.62)
Debit: Expenses:PayPal Fees (£21.38)

But I quite often forget to do this, so the PayPal account will not
reconcile.

Is there any way to search to find transactions going into accounts that
don't have a second split, or some other way to weed out the ones that have
gone into the PayPal account, but don't have an entry in PayPal expenses?




___
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] Can I find transactions into an account that has only one split?

2023-11-21 Thread Adrien Monteleone
Yeah, that's why I started off with this would be trial and error level 
effort.


The OP wants transactions where at least one split appears in set A, but 
excludes any such transactions when *other splits* also appear in set B.


I *think* this is possible, but I have to admit, I've never tried.

I'm guessing that running two separate Finds, one from the Accounts 
page, and one from the Find results register is the way to go, but I 
could be mistaken.


I'm guessing that trying it all in one go will fall into the trap you 
mention.


But if the result register is somehow 'fixed' to the original splits 
found, this entire endeavor may not be possible.


Regards,
Adrien

On 11/22/23 12:00 AM, Derek Atkins wrote:

Keep in mind that, GENERALLY, the search is on a SPLIT basis, not a
TRANSACTION basis.  So if you do a search on "Account == X AND Account ==
Y" you will get an empty set, because it is impossible to find anything
where Split.account == X and Split.account ALSO equals Y.


___
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] Can I find transactions into an account that has only one split?

2023-11-21 Thread Derek Atkins
Keep in mind that, GENERALLY, the search is on a SPLIT basis, not a
TRANSACTION basis.  So if you do a search on "Account == X AND Account ==
Y" you will get an empty set, because it is impossible to find anything
where Split.account == X and Split.account ALSO equals Y.

-derek

On Tue, November 21, 2023 11:35 pm, Adrien Monteleone wrote:
> Maybe. That's a trial and error sort of situation.
>
> Certainly, you can craft a Find from the Accounts tab with multiple
> criteria, the first should likely find all transactions matching
> Assets:PayPal, then the next might exclude all other accounts, or
> specific accounts. (since it is most likely you would have had an extra
> split to Expenses:PayPal Fees, just exclude that match from the results)
>
> An alternative is to run the first find to get a list. Then with that
> resulting register list open, run another find to narrow it down as
> needed.
>
> Which is the best or shortest route - I have no idea. You'll have to try
> and then see what works best for you.
>
> -
> for the record, all transactions have at least two splits—a debit and a
> credit. I know why you used the terminology you chose, but I put this
> here for clarification. That will be important for you in the future.
>
> Regards,
> Adrien
>
> On 11/21/23 7:43 PM, David Kirkby wrote:
>> I often receive PayPal transactions, which get put into the PayPal
>> account
>> as
>>
>> Credit: Assets: Accounts Receivable (£720.00)
>> Debit: Assets:PayPal  (£720.00)
>>
>> What I should then do is edit the PayPal account so the fees are put in
>> the
>> correct place - for one example transaction
>>
>> Credit: Assets: Accounts Receivable (£720)
>> Debit: Assets:PayPal  (£705.62)
>> Debit: Expenses:PayPal Fees (£21.38)
>>
>> But I quite often forget to do this, so the PayPal account will not
>> reconcile.
>>
>> Is there any way to search to find transactions going into accounts that
>> don't have a second split, or some other way to weed out the ones that
>> have
>> gone into the PayPal account, but don't have an entry in PayPal
>> expenses?
>
> ___
> 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.
>


-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
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] Can I find transactions into an account that has only one split?

2023-11-21 Thread Adrien Monteleone

Maybe. That's a trial and error sort of situation.

Certainly, you can craft a Find from the Accounts tab with multiple 
criteria, the first should likely find all transactions matching 
Assets:PayPal, then the next might exclude all other accounts, or 
specific accounts. (since it is most likely you would have had an extra 
split to Expenses:PayPal Fees, just exclude that match from the results)


An alternative is to run the first find to get a list. Then with that 
resulting register list open, run another find to narrow it down as needed.


Which is the best or shortest route - I have no idea. You'll have to try 
and then see what works best for you.


-
for the record, all transactions have at least two splits—a debit and a 
credit. I know why you used the terminology you chose, but I put this 
here for clarification. That will be important for you in the future.


Regards,
Adrien

On 11/21/23 7:43 PM, David Kirkby wrote:

I often receive PayPal transactions, which get put into the PayPal account
as

Credit: Assets: Accounts Receivable (£720.00)
Debit: Assets:PayPal  (£720.00)

What I should then do is edit the PayPal account so the fees are put in the
correct place - for one example transaction

Credit: Assets: Accounts Receivable (£720)
Debit: Assets:PayPal  (£705.62)
Debit: Expenses:PayPal Fees (£21.38)

But I quite often forget to do this, so the PayPal account will not
reconcile.

Is there any way to search to find transactions going into accounts that
don't have a second split, or some other way to weed out the ones that have
gone into the PayPal account, but don't have an entry in PayPal expenses?


___
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] Can I find transactions into an account that has only one split?

2023-11-21 Thread David Kirkby
I often receive PayPal transactions, which get put into the PayPal account
as

Credit: Assets: Accounts Receivable (£720.00)
Debit: Assets:PayPal  (£720.00)

What I should then do is edit the PayPal account so the fees are put in the
correct place - for one example transaction

Credit: Assets: Accounts Receivable (£720)
Debit: Assets:PayPal  (£705.62)
Debit: Expenses:PayPal Fees (£21.38)

But I quite often forget to do this, so the PayPal account will not
reconcile.

Is there any way to search to find transactions going into accounts that
don't have a second split, or some other way to weed out the ones that have
gone into the PayPal account, but don't have an entry in PayPal expenses?


-- 
Dr David Kirkby Ph.D
Kirkby Microwave Ltd
Email: drkir...@kirkbymicrowave.co.uk
Web: https://www.kirkbymicrowave.co.uk/
Telephone 07910 441670 (UK) or +44 7910 441670 (international)
Registered in England and Wales, company number 08914892.
Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Essex, CM3 6DT
___
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] Account reconciliation -- Gnucash's beginning balance is incorrect.

2023-11-21 Thread John Ralls
Oops, I guess you don't *quite* get how to use the mailing list: Always use 
reply-all so that your reply goes to the list, not just to the person you're 
replying to.

Regards,
John Ralls

> On Nov 21, 2023, at 4:23 PM, sailing  wrote:
> 
> Great! Thank you.
> 
> 
> 
> +}
> 
> 
>  Original message 
> From: John Ralls 
> Date: 11/21/23 6:49 PM (GMT-05:00)
> To: Elven Decker 
> Cc: gnucash-user@gnucash.org
> Subject: Re: [GNC] Account reconciliation -- Gnucash's beginning balance is 
> incorrect.
> 
> 
> 
> > On Nov 21, 2023, at 12:35 PM, Elven Decker  wrote:
> > 
> > Not sure how to use this help thread, but I have had a similar problem 
> > years ago which recently started happening again.  I solve it by exiting 
> > the reconciliation window and then re-opening it. When the small reconcile 
> > information window opens, I click on the "Statement Date" drop-down and 
> > choose the correct date by hand. This forces some kind of re-computation of 
> > the beginning and ending balances.
> 
> You seem to have figured out the mailing list.
> 
> No need to quit and restart the reconcile, though: You can edit the reconcile 
> information with Reconcile>Reconcile Information... from the reconcile 
> window's menu.
> 
> Regards,
> John Ralls
> 

___
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] Account reconciliation -- Gnucash's beginning balance is incorrect.

2023-11-21 Thread John Ralls



> On Nov 21, 2023, at 12:35 PM, Elven Decker  wrote:
> 
> Not sure how to use this help thread, but I have had a similar problem years 
> ago which recently started happening again.  I solve it by exiting the 
> reconciliation window and then re-opening it. When the small reconcile 
> information window opens, I click on the "Statement Date" drop-down and 
> choose the correct date by hand. This forces some kind of re-computation of 
> the beginning and ending balances.

You seem to have figured out the mailing list.

No need to quit and restart the reconcile, though: You can edit the reconcile 
information with Reconcile>Reconcile Information... from the reconcile window's 
menu.

Regards,
John Ralls

___
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] Account reconciliation -- Gnucash's beginning balance is incorrect.

2023-11-21 Thread Elven Decker
Not sure how to use this help thread, but I have had a similar problem 
years ago which recently started happening again.  I solve it by exiting 
the reconciliation window and then re-opening it. When the small 
reconcile information window opens, I click on the "Statement Date" 
drop-down and choose the correct date by hand. This forces some kind of 
re-computation of the beginning and ending balances.


+-}

___
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] Hidden and duplicated accounts.

2023-11-21 Thread Fred Bone
On 21 November 2023 at 18:37, David Kirkby said:

> I have a couple of questions related to accounts, and my ability to see
> them and delete them.
> 
> 1) I have some accounts for fees - you can see PayPal (GBP), PayPal (USD)
> and bank fees.
> 
> [image: image.png]
> 
> I remember creating some more to include eBay fees, but since I so rarely
> use eBay, I think I set them to hidden. But when I tried to edit the
> Expenses account, I can see the other entries But I do I unhide these? I
> tried clicking on other accounts, but none show hidden, and all are marked
> as placeholder, so I don't think that's the way to edit their visability.

Have you tried setting View->Filter by, Other, Show hidden accounts?


___
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] Can I set accounts to read-only?

2023-11-21 Thread Mark at Lorimark
You can set an account to 'placeholder' after you have transactions in 
it.  This will prevent you from double-click in the accounts view to 
open it, you'll have to right-click to view it's contents.


But, it will also remove it from your pick-lists in the registries.

~mark

On 11/21/23 12:46, David Kirkby wrote:

I have a few accounts that I will use very occasionally, but not normally.
Can I set them to read-only, so I just mark them writable when I need to?
This will avoid transactions accidentally getting put in there. I
discovered something in the Travel account the other day that should not
have been there. I will probably use that account once per year, so it
makes sense to stop things accidentally going into them.

I  believe setting them to placeholder accounts will achieve the same
effect, but I'm not sure.


___
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] Hidden and duplicated accounts.

2023-11-21 Thread Mark at Lorimark

Look for;

View-> Filter by-> Other

~mark
On 11/21/23 12:37, David Kirkby wrote:

I have a couple of questions related to accounts, and my ability to see
them and delete them.

1) I have some accounts for fees - you can see PayPal (GBP), PayPal (USD)
and bank fees.

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


[GNC] Can I set accounts to read-only?

2023-11-21 Thread David Kirkby
I have a few accounts that I will use very occasionally, but not normally.
Can I set them to read-only, so I just mark them writable when I need to?
This will avoid transactions accidentally getting put in there. I
discovered something in the Travel account the other day that should not
have been there. I will probably use that account once per year, so it
makes sense to stop things accidentally going into them.

I  believe setting them to placeholder accounts will achieve the same
effect, but I'm not sure.

-- 
Dr David Kirkby Ph.D
Kirkby Microwave Ltd
Email: drkir...@kirkbymicrowave.co.uk
Web: https://www.kirkbymicrowave.co.uk/
Telephone 07910 441670 (UK) or +44 7910 441670 (international)
Registered in England and Wales, company number 08914892.
Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Essex, CM3 6DT
___
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] Hidden and duplicated accounts.

2023-11-21 Thread David Kirkby
I have a couple of questions related to accounts, and my ability to see
them and delete them.

1) I have some accounts for fees - you can see PayPal (GBP), PayPal (USD)
and bank fees.

[image: image.png]

I remember creating some more to include eBay fees, but since I so rarely
use eBay, I think I set them to hidden. But when I tried to edit the
Expenses account, I can see the other entries But I do I unhide these? I
tried clicking on other accounts, but none show hidden, and all are marked
as placeholder, so I don't think that's the way to edit their visability.

[image: image.png]
2) As you can see I two accounts called Depreciation. Why I would have
created two for this I have no idea. These are both shown if I edit the
Expenses account, but not when I look normally. How can I delete one of
the?

-- 
Dr David Kirkby Ph.D
Kirkby Microwave Ltd
Email: drkir...@kirkbymicrowave.co.uk
Web: https://www.kirkbymicrowave.co.uk/
Telephone 07910 441670 (UK) or +44 7910 441670 (international)
Registered in England and Wales, company number 08914892.
Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Essex, CM3 6DT
___
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] Auto-complete of Memo field suffers short term memory

2023-11-21 Thread R Losey
That would appear to be my case; it will remember previously entered data
from the same session, but not across sessions (as it used to be able to
do).

On Mon, Nov 20, 2023 at 8:48 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> Through further testing as I noted in the bug report followups, I have
> narrowed this down to GnuCash only auto-filling whatever has been
> previously entered in the same session.
>
> Restarting the app causes the amnesia.
>
> And this is for both Memo and Notes fields.
>
> My next two steps are to test a fresh book and to test that and my
> existing book in Linux. (I'm on MacOS)
>
> Regards,
> Adrien
>
> On 11/20/23 8:43 PM, R Losey wrote:
> > Yes, I am running 5.3 and I have this same problem. I had hoped it was
> > fixed in 5.4, and I'm saddened to learn that it is still with us.
>
> ___
> 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.
>


-- 
_
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] Can I produce a trial balance as a simple CSV file?

2023-11-21 Thread Michael or Penny Novack

On 11/21/2023 7:58 AM, David Kirkby wrote:

I was a bit concerned about the complexity of the CSV files exported from
GnuCash, since they contain information my accountant does not want. I
wrote to him and received this as a response (slightly edited from his
reply)

*Thank you for your email. Do not worry about sending me over complicated
CSV files - we are very used to this. *

*The way in which we normally work is that a client sends across the trial
balance, we make relevant adjustments to which we use for the accounts and
send these adjustments back to you to make within your software. *


Check what he/she REALLY wants. Ask that question, "How would you really 
like them?" As opposed to asking "Could you accept the data in xyz format?"


Also keep in mind that .cvs (comma separated variable) is a basic level 
description of the data. Thus typically a spreadsheet application is 
using this basic level format to store its data BUT that does not mean 
that any file in .cvs format would be meaningful data for a spreadsheet.


Thus when he/she is saying "Do not worry about sending me overly 
complicated CVS files" perhaps saying don't worry about sending me the 
data from a spreadsheet that has additional, extraneous columns.


The point here is that people are telling you that you can export into 
an HTML file that a typical spreadsheet app can open and then save that 
in a more normal format (for a spreadsheet). And THAT is perhaps what 
your accountant wants (because can edit in the changes as he/she 
described and send back to you)


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] Import Bills & Invoices

2023-11-21 Thread Adrien Monteleone

Malformed CSV.

See the Tutorial & Concepts Guide §18.1 Importing Bills and Invoices.

The columns need to be in that exact order and format.

Regards,
Adrien

On 11/21/23 9:02 AM, Mark at Lorimark wrote:

I am trying to run File | Import | Import Bills & Invoices.

The file-type to pick is *.csv and I've got a good-looking csv file with 
a bunch of invoices in it, and when I select it, nothing shows in the 
"preview" area.


I've used other importers to grab transactions from my bank, but this 
one just seems to be not working?


___
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] Can I produce a trial balance as a simple CSV file?

2023-11-21 Thread Adrien Monteleone

David,

It may take a bit of setup, but there are other options:

1. html2csv - a python CLI app that will extract the table in the report 
to a CSV

2. online converters (some may be simply using the above python script)

The first option keeps everything on your machine.
The second allows drag and drop of files for less technical overhead.

Of course, a handful of clicks incorporating a spreadsheet app isn't too 
painful either.


Regards,
Adrien

On 11/21/23 8:38 AM, David Kirkby wrote:

Thank you. I'll probably just give him the spreadsheet in that  case - it
will be easier to read than a csv file.


___
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] Can I produce a trial balance as a simple CSV file?

2023-11-21 Thread David Kirkby
On Tue, 21 Nov 2023 at 13:22, Maf. King  wrote:

> On Tuesday, 21 November 2023 12:58:32 GMT David Kirkby wrote:
>
> >
> > I can see I can produce the trial balance as a PDF, but I can't see a way
> > to convert it to a CSV file, which I think he would prefer.
>
> The usual advice is the either:
>
> a. save the report as HTML
> b. select and copy the text of the report
>
> then open with / paste into a spreadsheet (LibreOffice Calc opens HTML
> just fine)
> and save as CSV from there, with any format / line-up tinkering needed
> first,
> of course,.
>

Thank you. I'll probably just give him the spreadsheet in that  case - it
will be easier to read than a csv file.
___
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] Can I produce a trial balance as a simple CSV file?

2023-11-21 Thread Maf. King
On Tuesday, 21 November 2023 12:58:32 GMT David Kirkby wrote:

> 
> I can see I can produce the trial balance as a PDF, but I can't see a way
> to convert it to a CSV file, which I think he would prefer. 

The usual advice is the either:

a. save the report as HTML
b. select and copy the text of the report

then open with / paste into a spreadsheet (LibreOffice Calc opens HTML just 
fine) 
and save as CSV from there, with any format / line-up tinkering needed first, 
of course,.

YMMV
Maf.



___
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] Can I produce a trial balance as a simple CSV file?

2023-11-21 Thread David Kirkby
I was a bit concerned about the complexity of the CSV files exported from
GnuCash, since they contain information my accountant does not want. I
wrote to him and received this as a response (slightly edited from his
reply)

*Thank you for your email. Do not worry about sending me over complicated
CSV files - we are very used to this. *

*The way in which we normally work is that a client sends across the trial
balance, we make relevant adjustments to which we use for the accounts and
send these adjustments back to you to make within your software. *

I can see I can produce the trial balance as a PDF, but I can't see a way
to convert it to a CSV file, which I think he would prefer. I can find
online converters for this, but can't see an open-source project to do it.
There are sufficiently few entries that I could do this myself in a
spreadsheet, but it would be a bit tedious.

-- 
Dr David Kirkby Ph.D
Kirkby Microwave Ltd
Email: drkir...@kirkbymicrowave.co.uk
Web: https://www.kirkbymicrowave.co.uk/
Telephone 07910 441670 (UK) or +44 7910 441670 (international)
Registered in England and Wales, company number 08914892.
Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Essex, CM3 6DT
___
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.