Re: [GNC] report cutoffs - Trial Balance opening date

[David T. via gnucash-user]

Per the documentation:


10.3.5.11. Trial Balance


Trial Balance lists the ending balances in all accounts as of a particular 
date. It is typically run at the end of an accounting period and is primarily 
used to ensure that the total of all debits equals the total of all credits.


By definition, that means there *isn't* a start date. 

⁣David T. ​

On May 18, 2023, 11:38 PM, at 11:38 PM, "Rogier F. van Vlissingen" 
 wrote:
>somehow or other I had a discrepancy between my trial balance and my
>P
>and it turns out that the 22 trial balance is picking up transactions
>from
>20 and 21.
>
>What I cannot figure out is where to set the opening date for the trial
>balance.
>___
>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.

[GNC] invoice not showing sales in income account

[Thelma Sabim]

Hi,
I had set up my invoice to show "Income:sales" under Income Account. Today
I tried to issue another invoice and the field only shows "Income:interest"
and it seems to freeze when I click on the arrow down. Also, the field
Action only shows 'hours'. Before I had the option for 'word'.
I still can see my four invoices issued and correctly posted to Accounts
Receivable and if I jump to invoices, they show Income:sales for Income
account.
What should I do? Recreate a new template for invoice? What options are
available in this scenario?
Thank you.

-- 
*Thelma L Sabim*
Tradutora Juramentada JUCEPAR
Certified Translator Eng < > Por
ABRATES, ATA
+55 (41) 3276 5659 Cel: (41) 9 9676 7297 (BR)
+1 (512) 837 5708 (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.

Re: [GNC] Accounting Help - Credit Card transfer

[Chris Ledbetter via gnucash-user]

Thank you - my issue is closed.

> On May 18, 2023, at 5:50 PM, Derek Atkins  wrote:
> 
> Hi,
> 
> 
> 
> On Thu, May 18, 2023 5:38 pm, Chris Ledbetter via gnucash-user wrote:
>> Hi,
>> Currently using GnuCash 4.14.  I have Credit Card A with an opening
>> balance (transfer Equity:Opening Balances) and subsequent transactions.  I
>> set up Credit Card B.  I transfer the majority of the balance to Credit
>> Card B but still keep Credit Card A.  How do I set up Credit Card B
>> transactions?  In Credit Card A is move the balance as a transaction
>> (transfer Liabilities:Credit Card:Credit Card B) and in Credit Card B the
>> initial transaction is (transfer Liabilities:Credit Card:Credit Card A).
>> Is this the correct way to transfer?  Should Credit Card B have on
>> Equity:Opening Balance?
> 
> Equity:Opening Balance is only used when you start GnuCash.
> If you open an account after that, then no, you don't use Eq:O-B
> 
> What you suggest is correct.  If you are transferring a balance from A to
> B, then it's just a regular transaction from A to B.
> 
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> 
> -derek
> 
> -- 
>   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] Accounting Help - Credit Card transfer

[Derek Atkins]

Hi,



On Thu, May 18, 2023 5:38 pm, Chris Ledbetter via gnucash-user wrote:
> Hi,
> Currently using GnuCash 4.14.  I have Credit Card A with an opening
> balance (transfer Equity:Opening Balances) and subsequent transactions.  I
> set up Credit Card B.  I transfer the majority of the balance to Credit
> Card B but still keep Credit Card A.  How do I set up Credit Card B
> transactions?  In Credit Card A is move the balance as a transaction
> (transfer Liabilities:Credit Card:Credit Card B) and in Credit Card B the
> initial transaction is (transfer Liabilities:Credit Card:Credit Card A).
> Is this the correct way to transfer?  Should Credit Card B have on
> Equity:Opening Balance?

Equity:Opening Balance is only used when you start GnuCash.
If you open an account after that, then no, you don't use Eq:O-B

What you suggest is correct.  If you are transferring a balance from A to
B, then it's just a regular transaction from A to B.

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   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] Accounting Help - Credit Card transfer

[Michael or Penny Novack]

On 5/18/2023 5:38 PM, Chris Ledbetter via gnucash-user wrote:

Hi,
Currently using GnuCash 4.14.  I have Credit Card A with an opening balance 
(transfer Equity:Opening Balances) and subsequent transactions.  I set up 
Credit Card B.  I transfer the majority of the balance to Credit Card B but 
still keep Credit Card A.  How do I set up Credit Card B transactions?  In 
Credit Card A is move the balance as a transaction (transfer Liabilities:Credit 
Card:Credit Card B) and in Credit Card B the initial transaction is (transfer 
Liabilities:Credit Card:Credit Card A).  Is this the correct way to transfer?  
Should Credit Card B have on E even if thequity:Opening Balance?


a0 When you set up credit card B (with the bank issuing it) was there a 
balance already?  If not, you just create the account with zero starting 
balance.


NOTE --- you can always do this even if there is a balance in some new 
account you are creating. The "wizard" allowing you to create an account 
with a balance WITHOUT an explicit transaction putting it there is just 
a shortcut, useful when opening new books, LOTS of accounts with a 
starting balance. But when adding an account to your CoA might as well 
do it the old fashioned way with an initial transaction.


b) The transferring X dollars liability from Credit Card A to Credit 
Card B is a transaction debit A and credit B for $X If you are using 
the supposedly "user friendly" column titles, I will leave it to you to 
figure out which is debit and which credit. But essentially this 
transaction is just a transfer of a liability.,



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.

[GNC] report cutoffs - Trial Balance opening date

[Rogier F. van Vlissingen]

somehow or other I had a discrepancy between my trial balance and my P
and it turns out that the 22 trial balance is picking up transactions from
20 and 21.

What I cannot figure out is where to set the opening date for the trial
balance.
___
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] Custom GnuCash 5.x Transaction Report with Tags

[Vincent Dawans]

Hello. I am sharing with the list a custom report (based on the Transaction
Report) that provides some basic features related to the long-discussed
request of being able to use orthogonal categories, classes, tags or
"analytical dimensions" to retrieve and group transactions across several
general ledger accounts. See https://bugs.gnucash.org/show_bug.cgi?id=113772

This proof of concept only focuses on producing a transaction report sorted
and grouped by user-defined tags. Whether a final version of this report
makes it to the official GnuCash release depends on a lot of factors and a
lot more testing, user feedback and documentation.

In the meantime I am making these changes available as a custom report so
that users can start using it (if they wish) and provide feedback. For now
the best place to provide feedback if there is any is on the official Pull
Request itself Gnucash/gnucash#1623

Because this is designed as a custom report, it can be easily installed and
uninstalled and does not modify the core GnuCash files nor the data file
(beyond the user-defined tags added manually by the users themselves of
course). This is for version 5.0 and above only.

See basic documentation, screenshots and installation instructions here:
https://github.com/dawansv/gnucash-transaction-tags

Limitations
This custom report is not a feature-rich solution. It only provides one
type of report (similar to the existing transaction report) and does not
provide any feature to "bulk manage" existing or future user-defined tags.
So there is no feature to bulk rename, bulk move or bulk delete tags for
instance. All changes to the data file (adding and changing tags) are done
manually by the user. This feature only provides a custom report that uses
tags as created by the user.

Sincerely,

Vincent Dawans
___
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] Tax report options (flywire)

[Gyle McCollam]

Brad,
As fr as banks with FDIC Insurance and OFX/QFX downloads, I can think of 3 off 
the top of my head.  Presidential Bank in MD, good rate, but only on the 1st 
$25,000 in checking with conditions.  2nd, Bask Bank/Texas Capital, limited to 
2 savings accounts and CDs.  Last. but not least CIT Bank (not CITI).  I'm sure 
there are many others and even if they only offer CSV downloads, that is almost 
as easy once you've done it once.


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com   email


From: gnucash-user  on 
behalf of Brad Morrison 
Sent: Thursday, May 18, 2023 5:56 AM
To: gnucash-user@gnucash.org 
Cc: fdxmemberservi...@financialdataexchange.org 
; 
fdxsupp...@financialdataexchange.org 
Subject: Re: [GNC] Tax report options (flywire)

Hi Alex/all,

Thank you for the overarching explanations about how GnuCash Tax Report
Options work and some of the issues behind that.

As I covered in my April 25 post
(https://lists.gnucash.org/pipermail/gnucash-user/2023-April/106671.html),
I have been trying to find US based FDIC insured banks that allow for
transactional data to be downloaded in the OFX file format
(https://en.wikipedia.org/wiki/Open_Financial_Exchange). I have still
not been able to find any that do, so I dug a bit deeper (the ICBA and
several other banking associations did not respond to my inquiries) and
noticed that the Financial Data Exchange group that hosts the "OFX Work
Group" (https://financialdataexchange.org/ofx) seems to be quite out of
date (copyright date at the bottom lists 2020 as the year, 2019 is the
last date on the timeline, etc.). The Financial Data Exchange homepage
(https://financialdataexchange.org/) looks better maintained and seems
to have several news items from the last month, but also has that 2020
copyright date at the bottom. FDX also has this Tax Data Exchange
section
(https://financialdataexchange.org/FDX/FDX/US-Tax/US-Tax-Forms.aspx?hkey=00bae613-7ec8-4c93-8e37-4712f09ae255)
under the "Resources" tab, but it also looks a bit stale. You may be
able to parse the technical information there better than I can, but it
might be worth a look as that Tax Data Exchange page also seems to
acknowledge what you are saying about TXF code being abandoned
("Standards-based JSON files are superior to both CSV and TXF files CSV
files require proprietary programs to process. Documentation and support
of the TXF standard has dwindled and has now been fully-replaced by new
standards.")

I do not know if GnuCash is already a member of FDX, but that maybe
something to consider...?

Brad

On 5/17/23 12:08, Alex Aycinena wrote:
> On Wed, May 17, 2023 at 9:00 AM  wrote:
>
>> -- Forwarded message --
>> From: flywire
>> To: Gnucash Users
>> Cc:
>> Bcc:
>> Date: Wed, 17 May 2023 17:17:45 +1000
>> Subject: Re: [GNC] Tax report options
>> https://lists.gnucash.org/pipermail/gnucash-user/2023-May/107018.html
>> flywire wrote:
>>
>>> It is a spreadsheet process to add share/franking credits to etf/franking
>>> credits (Distribution:13Q) and similar for capital gains
>>> (Distribution:18H:18A) since the components are the same tax item. Any
>>> thoughts of how I could sum them in reports from different account trees?
>>>
>> lol In the heat of the moment preparing tax I'd never thought of just
>> transferring the total to the main account for that item.
>>
>> https://lists.gnucash.org/pipermail/gnucash-user/2023-May/107020.html
>> flywire wrote:
>>
>>> ...there are 13 annual returns
>>>
>> To be clear, the items on the return map to different tax codes, eg
>> franking credits is 13Q on a personal return and 8D on a trust return. I'd
>> expect a table would need to be maintained for each return type. Australian
>> codes hardly change over time which likely means there would be no active
>> maintenance.
>>
>> Is it as simple as just using a unique tax code as account code and then
>> reporting by account code? (Assume one return type.)
>>
>> ___
>>
>>
> Some questions have been asked about  Tax Report Options in the past couple
> of weeks. I have been away and not able to respond or make comments. Let me
> make these points, which may not necessarily apply to this thread, but to
> others (sorry):
>
> - The Tax Report Options and associated US Income Tax Report are only
> intended to be used for US Income Taxes.
>
> - Some time ago, someone in Germany used the US version and made
> adjustments for use in Germany; I'm not familiar with that and don't know
> if it works and is being maintained.
>
> - Initially it was intended primarily to generate a file that could be
> uploaded to Income Tax Preparation software (and a report was sort of
> secondary) and so a key element of the design was the use of TXF codes that
> the Tax software could understand; the specification for those codes was
> abandoned some time ago so the ability to expand the system is 

Re: [GNC] [GNC-dev] Finance::Quote on Mac M1 OSX Ventura

[Bruce Schuck]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 5/18/23 8:12 AM, John Ralls wrote:

>> On the virgin OS out of the box, Test2 module is in the included Perl
>> but its version is 1.302162 (at least on 13.3.1). But if you look at
>> the file /System/Library/Perl/Extras/5.30/Test2/Plugin/NoWarnings.pm,
>> line 9 is

> Indeed, /System/Library/Perl/5.30/Test2.pm version is 1.302167. 1.302193
> is the version in /Library/Perl/5.30/Test2.pm meaning that I installed
> it via cpan. I added it to gnc-fq-update a couple of years ago to deal
> with https://bugs.gnucash.org/show_bug.cgi?id=798180
> .

I was going to look if gnc-fq-update installed other modules before 
F::Q. Adding Test2 to the requisites of F::Q may not work. If the CPAN 
process attempts to install DateTime::Locale before Test2, it would 
fail. The dependency isn't directly in F::Q, it's a few layers deep. 
Finance::Quote -> DateTime::Locale -> Test2::Plugin::NoWarnings -> Test2.


I'll add it to the F::Q prereqs in the next release.

Thanks.

Bruce S.
-BEGIN PGP SIGNATURE-
Comment: GPGTools - http://gpgtools.org

iHkEARECADkWIQRzL0H5rBaeDPnpeL1IjAeprJFQBwUCZGZGkxscYnNjaHVja0Bh
c2dhcmQtc3lzdGVtcy5jb20ACgkQSIwHqayRUAfQ/QCeJLQ2oJoZOSf4iWmb4BoP
IuaqMKQAoJ4WvZfKaI33xw0gQz5QPeARNZ85
=D6J8
-END PGP SIGNATURE-
___
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] [GNC-dev] Finance::Quote on Mac M1 OSX Ventura

[John Ralls]

> On May 17, 2023, at 22:34, Bruce Schuck  wrote:
> 
> On 5/17/23 7:02 PM, John Ralls wrote:
> 
>> That's interesting, but running your test from the end of that GitHub issue 
>> I get:
>> ```
>> $ Hector:/Users/john> perl -MTest2::Plugin::NoWarnings -e 'print 
>> "$Test2::Plugin::NoWarnings::VERSION\n"'
>> 0.09
>> $ Hector:/Users/john> perl -MTest2 -e 'print "$Test2::VERSION\n"'
>> 1.302193
>> ```
>> DateTime::Locale also installs without error including passing all of its 
>> tests. Mind, I've had F::Q installed on it for a while.
>> I'm running the current 13.4 developer beta.
> 
> On the virgin OS out of the box, Test2 module is in the included Perl but its 
> version is 1.302162 (at least on 13.3.1). But if you look at the file 
> /System/Library/Perl/Extras/5.30/Test2/Plugin/NoWarnings.pm, line 9 is
> 
> use Test2 1.302167;
> 
> One would think that if the OS supplied bundle has a Perl module that 
> requires at minimum version of another module, the required module would be 
> that version or later. Not the case. The key here is until doing this testing 
> ** no other additional perl modules were installed **.
> 
> Either 13.4 has more recent modules in the OS supplied Perl, or you updated 
> Test2 at some point in the past.
> 
> I probably should have add the output of
> 
> perl -MTest2 -e 'print "$Test2::VERSION\n"'
> 
> in my comment, but before I installed *any* additional modules, it was 
> 1.302162 as noted above.
> 
> I didn't want remove the OS supplied Test2::Plugin::NoWarnings, but I would 
> bet reinstalling it would trigger the correct dependency of Test2 also 
> getting installed. The 0.09 version already installed/included is the most 
> current release.

Bruce,

Indeed, /System/Library/Perl/5.30/Test2.pm version is 1.302167. 1.302193 is the 
version in /Library/Perl/5.30/Test2.pm meaning that I installed it via cpan. I 
added it to gnc-fq-update a couple of years ago to deal with 
https://bugs.gnucash.org/show_bug.cgi?id=798180.

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] Tax report options (flywire)

[Brad Morrison]

Hi Alex/all,

Thank you for the overarching explanations about how GnuCash Tax Report 
Options work and some of the issues behind that.


As I covered in my April 25 post 
(https://lists.gnucash.org/pipermail/gnucash-user/2023-April/106671.html), 
I have been trying to find US based FDIC insured banks that allow for 
transactional data to be downloaded in the OFX file format 
(https://en.wikipedia.org/wiki/Open_Financial_Exchange). I have still 
not been able to find any that do, so I dug a bit deeper (the ICBA and 
several other banking associations did not respond to my inquiries) and 
noticed that the Financial Data Exchange group that hosts the "OFX Work 
Group" (https://financialdataexchange.org/ofx) seems to be quite out of 
date (copyright date at the bottom lists 2020 as the year, 2019 is the 
last date on the timeline, etc.). The Financial Data Exchange homepage 
(https://financialdataexchange.org/) looks better maintained and seems 
to have several news items from the last month, but also has that 2020 
copyright date at the bottom. FDX also has this Tax Data Exchange 
section 
(https://financialdataexchange.org/FDX/FDX/US-Tax/US-Tax-Forms.aspx?hkey=00bae613-7ec8-4c93-8e37-4712f09ae255) 
under the "Resources" tab, but it also looks a bit stale. You may be 
able to parse the technical information there better than I can, but it 
might be worth a look as that Tax Data Exchange page also seems to 
acknowledge what you are saying about TXF code being abandoned 
("Standards-based JSON files are superior to both CSV and TXF files CSV 
files require proprietary programs to process. Documentation and support 
of the TXF standard has dwindled and has now been fully-replaced by new 
standards.")


I do not know if GnuCash is already a member of FDX, but that maybe 
something to consider...?


Brad

On 5/17/23 12:08, Alex Aycinena wrote:

On Wed, May 17, 2023 at 9:00 AM  wrote:


-- Forwarded message --
From: flywire
To: Gnucash Users
Cc:
Bcc:
Date: Wed, 17 May 2023 17:17:45 +1000
Subject: Re: [GNC] Tax report options
https://lists.gnucash.org/pipermail/gnucash-user/2023-May/107018.html
flywire wrote:


It is a spreadsheet process to add share/franking credits to etf/franking
credits (Distribution:13Q) and similar for capital gains
(Distribution:18H:18A) since the components are the same tax item. Any
thoughts of how I could sum them in reports from different account trees?


lol In the heat of the moment preparing tax I'd never thought of just
transferring the total to the main account for that item.

https://lists.gnucash.org/pipermail/gnucash-user/2023-May/107020.html
flywire wrote:


...there are 13 annual returns


To be clear, the items on the return map to different tax codes, eg
franking credits is 13Q on a personal return and 8D on a trust return. I'd
expect a table would need to be maintained for each return type. Australian
codes hardly change over time which likely means there would be no active
maintenance.

Is it as simple as just using a unique tax code as account code and then
reporting by account code? (Assume one return type.)

___



Some questions have been asked about  Tax Report Options in the past couple
of weeks. I have been away and not able to respond or make comments. Let me
make these points, which may not necessarily apply to this thread, but to
others (sorry):

- The Tax Report Options and associated US Income Tax Report are only
intended to be used for US Income Taxes.

- Some time ago, someone in Germany used the US version and made
adjustments for use in Germany; I'm not familiar with that and don't know
if it works and is being maintained.

- Initially it was intended primarily to generate a file that could be
uploaded to Income Tax Preparation software (and a report was sort of
secondary) and so a key element of the design was the use of TXF codes that
the Tax software could understand; the specification for those codes was
abandoned some time ago so the ability to expand the system is not there
unless we invented our own new TXF code (ugh!).

- That is why there is nothing for Form 1116.

- If someone wanted to do what was done for Germany for another
jurisdiction, they would have to deal with this TXF issue; I certainly
don't recommend trying it.

- The US version could/should be re-written to not depend on TXF codes but
this would not be trivial.

- One can use the 'No Tax code' tag to include accounts on the US Income
Tax Report, just not sorted by Form/Schedule; you could use the account
name and/or description for that purpose for those accounts to give you
totals (example: for Form 1116).

- The system assumes that each 'book' (i.e., gnucash file) is for one
reporting entity (individual, partnership, corporation, etc.) and that one
file is not used to track the accounts of more than one tax
reporting entity.

- You can certainly use your account structure design and other available
reports to get your tax