Re: [GNC] Import matching

[Gyle McCollam]

Additional information.  Another credit card that can only import CSV, a 
fast-food establishment submits information the day after the actual 
transaction.  90% of the time it said there was no match, but on a few 
occasions, it actually did match the transaction.  Import information in 
preferences was not changed from the earlier submission.

BTW, it would be nice to have a reset to defaults on these preferences.


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com   email


From: gnucash-user  on 
behalf of Gyle McCollam 
Sent: Monday, March 11, 2024 3:49 PM
To: gnucash-user@gnucash.org 
Subject: [GNC] Import matching

I tried importing credit card transactions.  There were 2 with no match 
information.  Turns out Amazon split the order to 2 different transactions.  I 
changed the transaction in the account to 1 of the amounts and added a 
transaction for the other amount.  They were both dated 02/09/2024.  The 
transactions on the credit card account were 02/13/2024.  When I tried double 
clicking on the transaction in the import window it said there were not 
matching transactions.  I checked the preferences and change the # of days to 
the attached information.  It still won't find these transactions.  I tried 
closing GC and then opened and tried to import them again, still no luck.  
Obviously, I'm missing something, what am I doing 
wrong?[cid:9657ec02-19b5-48f1-a2e9-0393f5c44ecf]


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com   email
___
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] I'm getting started in Gnucash and want to list each item that I buy from one merchant

[W. Neal Lewis]

Hello Sunfish,

Yes. That is what happened.

That is a good insight that you provided.

Thank you!

Neal

On 3/11/24 12:46 PM, sunfis...@yahoo.com wrote:
I'll note that because GnuCash keeps a running really of the amount 
needed to balance the transaction, users adding a new line to that 
transaction can get confusing results.


For example, a user adds a new transaction for a grocery store and 
places a left column entry for $35 assigned to Expenses:Groceries. 
They tab off the line, intending to add another split for $15 for 
Expenses:Household and tab to the left column and enter $15. However, 
in the right column, GnuCash has already supplied the balancing $35 
for the first split. As user tabs of the line, GnuCash takes $15 and 
combines it with the $35, resulting in a right column entry for $20, 
rather than a left column entry in the intended amount.


David T.
On Mar 11, 2024, at 6:25 PM, "W. Neal Lewis"  
wrote:


David,

No, I found out very quickly that return causes that sort of result.

Best regards,
Neal

On 3/9/24 10:32 PM, David Carlson wrote:

Neal, By chance are you using the enter key during your
editing? That triggers the full transactiion calculatkions.
Use arrow keys, ta b key or mouse buttons until you are ready
to see the transaction calculation. I think calculztions
within individual amount fields happen as soon as you move out
of that field unless you are creating a scheduled
transaaction. On Sat, Mar 9, 2024, 8:36 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

I'm not certain what you are describing, but I'll hazard a
guess that you are seeing GnuCash auto-balance the
transaction. That is normal. Every transaction has to be
balanced. (Debits *must* equal Credits) You are free to
enter the transaction however you like, as long as that
holds true. If your self-entered amounts do not result in
equal Debits & Credits, GnuCash will create a split
initially not assigned to any account, but when you commit
the transaction and that split remains, it will be
assigned to the account labeled: 'Imbalance-XXX' (where
XXX is a currency code) for the difference. Please read
the GnuCash Help Manual and the Tutorial & Concepts Guide
available in the Help Menu, or online, as you are learning
the software. Then if you get stuck, come back and ask for
help here. Regards, Adrien On 3/9/24 8:18 PM, W. Neal
Lewis wrote:

When I do the View > Transaction and put in individual
numbers for each 


item in the Withdrawal column, it starts to mess with my
figures. It puts in a number at the very top. It adds
deposits to other entries. What I end up with is a
mish-mash of costs that the program seems to think that I
need for some mythical number it has come up with.

That's exactly what happened previously. I don't want
it adding numbers, 


or changing numbers. I just want to put in the correct
values for each line, including tax, hit return and have
the final value show up on the first line of the transaction.

I obviously don't know what I am doing. Help! Neal 




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. 





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 

[GNC] Import matching

[Gyle McCollam]

I tried importing credit card transactions.  There were 2 with no match 
information.  Turns out Amazon split the order to 2 different transactions.  I 
changed the transaction in the account to 1 of the amounts and added a 
transaction for the other amount.  They were both dated 02/09/2024.  The 
transactions on the credit card account were 02/13/2024.  When I tried double 
clicking on the transaction in the import window it said there were not 
matching transactions.  I checked the preferences and change the # of days to 
the attached information.  It still won't find these transactions.  I tried 
closing GC and then opened and tried to import them again, still no luck.  
Obviously, I'm missing something, what am I doing 
wrong?[cid:9657ec02-19b5-48f1-a2e9-0393f5c44ecf]


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com   email
___
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] I'm getting started in Gnucash and want to list each item that I buy from one merchant

[sunfish62--- via gnucash-user]

I'll note that because GnuCash keeps a running really of the amount needed to 
balance the transaction, users adding a new line to that transaction can get 
confusing results. 

For example, a user adds a new transaction for a grocery store and places a 
left column entry for $35 assigned to Expenses:Groceries. They tab off the 
line, intending to add another split for $15 for Expenses:Household and tab to 
the left column and enter $15. However, in the right column, GnuCash has 
already supplied the balancing $35 for the first split. As user tabs of the 
line, GnuCash takes $15 and combines it with the $35, resulting in a right 
column entry for $20, rather than a left column entry in the intended amount. 

⁣David T. ​

On Mar 11, 2024, 6:25 PM, at 6:25 PM, "W. Neal Lewis"  
wrote:
>David,
>
>No, I found out very quickly that return causes that sort of result.
>
>Best regards,
>Neal
>
>On 3/9/24 10:32 PM, David Carlson wrote:
>> Neal,
>>
>> By chance are you using the enter key during your editing?
>>
>> That triggers the full transactiion calculatkions.  Use arrow keys,
>ta b
>> key or mouse buttons until you are ready to see the transaction
>calculation.
>>
>> I think calculztions within individual amount fields happen as soon
>as you
>> move out of that field unless you are creating a scheduled
>transaaction.
>>
>> On Sat, Mar 9, 2024, 8:36 PM Adrien Monteleone <
>> adrien.montele...@lusfiber.net> wrote:
>>
>>> I'm not certain what you are describing, but I'll hazard a guess
>that
>>> you are seeing GnuCash auto-balance the transaction. That is normal.
>>> Every transaction has to be balanced. (Debits *must* equal Credits)
>>>
>>> You are free to enter the transaction however you like, as long as
>that
>>> holds true. If your self-entered amounts do not result in equal
>Debits &
>>> Credits, GnuCash will create a split initially not assigned to any
>>> account, but when you commit the transaction and that split remains,
>it
>>> will be assigned to the account labeled: 'Imbalance-XXX' (where XXX
>is a
>>> currency code) for the difference.
>>>
>>> Please read the GnuCash Help Manual and the Tutorial & Concepts
>Guide
>>> available in the Help Menu, or online, as you are learning the
>software.
>>> Then if you get stuck, come back and ask for help here.
>>>
>>> Regards,
>>> Adrien
>>>
>>> On 3/9/24 8:18 PM, W. Neal Lewis wrote:
 When I do the View > Transaction and put in individual numbers for
>each
>>> item in the Withdrawal column, it starts to mess with my figures. It
>puts
>>> in a number at the very top. It adds deposits to other entries. What
>I end
>>> up with is a mish-mash of costs that the program seems to think that
>I need
>>> for some mythical number it has come up with.
 That's exactly what happened previously. I don't want it adding
>numbers,
>>> or changing numbers. I just want to put in the correct values for
>each
>>> line, including tax, hit return and have the final value show up on
>the
>>> first line of the transaction.
 I obviously don't know what I am doing.

 Help!
 Neal
>>>
>>> ___
>>> 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.
>
>___
>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] Setting font sizes in reports (specifically in Transaction Report)

[Adrien Monteleone]

Here's the bug link: https://bugs.gnucash.org/show_bug.cgi?id=799248

Your attachment seems to be a printed version of the report, rather than 
an HTML 'export'. (Use the Export button on the toolbar, don't try to 
'print to file')


I'm spinning up a VM with 4.8 to confirm. As of 5.5 at least, that cell 
does have a class as I noted.


Perhaps switch to the 5.5 flatpak. At least you can style it using the 
method I described in my last post.


Regards,
Adrien

On 3/11/24 12:14 PM, Chris Green wrote:

I have the exported HTML.  It would appear that the section (i.e.
account) headings are in a , see:-

 
 Lloyds
  
  
 
  
 01/01/23
 
 
 
 Lloyds Current

The 'Lloyds' is what I would expect to be in a large font but there
seems to be no class to apply to it.  I have attached the whole
exported HTML file, I can see no way to specify a larger size for the
headings, it needs the HTML changing to give a class name to the
section (account) headings.


___
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] Setting font sizes in reports (specifically in Transaction Report)

[Chris Green]

Adrien,

Thanks for your continuing support with this, see further comments and
informaiton below.

On Mon, Mar 11, 2024 at 11:52:36AM -0500, Adrien Monteleone wrote:
> On 3/11/24 5:30 AM, Chris Green wrote:
> > On Fri, Mar 08, 2024 at 12:01:01PM -0600, Adrien Monteleone wrote:
> >> Chris,
> >>
> >> Once again, look into Edit > Stylesheets.
> >>
> >> For the record, I'm using defaults, and the  is 12pt
> >> bold and the  lines are 10pt normal weight. The total lines
> >> match the .
> >>
> > On my GnuCash (version 4.8 on Linux) there isn't a separate setting
> > for the , it's the same size as 'Text Cell'.
> > Chnaging the font size for 'Text Cell' changes *all* the text (i.e. the
> > individual transaction descriptions etc.) as well as the account title.
> > 
> > There are no references to 'transaction' or 'name of account' in my
> > stylesheet settings.
> > 
> > Is this something that has been changed since version 4.8?
> > 
> The total cells labels *as well as the account name* were all given a 
> CSS class:
> 
> .total-label-cell
> 
> for the labels, and
> 
> .total-number-cell
> 
> for the actual figures in the totals.
> 
> By default, the styling for those is:
> 
> td.total-number-cell { font-family: "Avenir", sans-serif; font-size: 
> 12pt; font-weight: 810;  }
> td.total-label-cell { font-family: "Avenir", sans-serif; font-size: 
> 12pt; font-weight: 780;  }
> 
> (visible if you open the exported HTML report in a text editor)
> 
I have the exported HTML.  It would appear that the section (i.e.
account) headings are in a , see:-


Lloyds
 
 

 
01/01/23



Lloyds Current

The 'Lloyds' is what I would expect to be in a large font but there
seems to be no class to apply to it.  I have attached the whole
exported HTML file, I can see no way to specify a larger size for the
headings, it needs the HTML changing to give a class name to the
section (account) headings.

> You can use the CSS stylesheet for your report, and copy those above 
> rules to it. It is probably not strictly necessary to address the td 
> element explicitly like the inline style does, just the class should work.
> 
> Or, with the Default stylesheet, simply adjust those options as desired 
> on the Fonts tab: "Total Label Cell" and "Total Number Cell".
> 
> I'll file a bug on the Account Name sharing a class that makes it 
> non-obvious what to change.
> 
> 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.
> 

-- 
Chris Green
  Transaction Report

  From 01/01/23 to 31/12/23

   Date Num Description Memo/Notes Transfer from/to Debit Credit
   Lloyds
   01/01/23 Lloyds Current [1]�1,934.97
   03/01/23 Risdales Regular Giving [2]�20.00
   03/01/23 000531 David Cope, remove branch Maintenance [3]�25.00
   11/01/23 Electricity, British Gas Utilities [4]�59.35
   12/01/23 Scarfe Trust Payments to/from Building Account [5]�750.00
   18/01/23 Vicar's expenses, invoice 368 Vicar [6]�32.85
   18/01/23 500915 Collection, 18th Dec 2022 Collections [7]�64.90
   18/01/23 500915 Collection, 24th Dec 2022 Collections [8]�156.52
   18/01/23 500915 Collection, 15th Jan Collections [9]�108.20
   18/01/23 500915 Green, rounding up donation Other Donations [10]�2.38
   18/01/23 500915 Donation box Offertory Box [11]�8.00
   20/01/23 Ronald Arthur Pomr Funeral Fees [12]�224.00
   23/01/23 Quota for Diocese Quota for Diocese [13]�300.00
   27/01/23 Extra to fulfil 2022 quota Quota for Diocese [14]�285.00
   30/01/23 An - unclear Fees [15]�282.00
   01/02/23 Gaussen Regular Giving [16]�180.00
   02/02/23 Risdales Regular Giving [17]�20.00
   06/02/23 Electricity, British Gas Utilities [18]�96.41
   09/02/23 Peter Smith funeral Fees [19]�141.00
   15/02/23 000530 J. Dundas, gutter cleaning Maintenance [20]�150.00
   20/02/23 Donation to Crisis at Christmas Donations [21]�78.00
   22/02/23 Quota for Diocese Quota for Diocese [22]�300.00
   22/02/23 Stewardship Regular Giving [23]�120.00
   02/03/23 Risdales Regular Giving [24]�20.00
   03/03/23 Ride and Stride Other Donations [25]�25.00
   03/03/23 Electricity, British Gas Utilities [26]�29.27
   06/03/23 000532 David Cope, mowing Maintenance [27]�230.00
   08/03/23 500916 Carol singing Payments to/from Building Account
   [28]�35.00
   08/03/23 500916 Collection, 19th Feb Collections [29]�105.00
   08/03/23 500916 Collection, 5th March Collections [30]�80.00
   08/03/23 500916 Green, rounding up donation Other Donations [31]�1.00
   08/03/23 500916 Donation box Offertory Box [32]�39.00
   22/03/23 Quota for Diocese Quota for Diocese [33]�300.00
   27/03/23 Church Insurance Insurance 

Re: [GNC] Bill total does not match real total

[Adrien Monteleone]

I'm not sure if it is still entirely open source, but it started that 
way. I think they've added on features that are closed. (some may simply 
be built with Odoo itself) The base package is still available as far as 
I'm aware, and it is pretty powerful, but likely overkill for most small 
businesses. They also don't make it easy to build it and get up and 
running, preferring to 'guide' you to their paid support offerings.


Odoo is more of a tool to build an app, rather than a business app itself.

Regards,
Adrien

On 3/11/24 10:33 AM, Michael or Penny Novack wrote:
Well ... if it is really "open software" they would have to make the 
source code available for free (technically can charge reasonable cost 
for a copy on medium -- the 'rule" was made before we got things by 
download). The "open software" rules do NOT forbid charging for 
providing executables, support, etc. The originally concept was that 
nobody could charge excessively for that or somebody else would step in 
and provide at a more reasonable price. Yes, I am old enough to have 
followed the original "open software" discussions real time.


___
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] Setting font sizes in reports (specifically in Transaction Report)

[Adrien Monteleone]

The total cells labels *as well as the account name* were all given a 
CSS class:


.total-label-cell

for the labels, and

.total-number-cell

for the actual figures in the totals.

By default, the styling for those is:

td.total-number-cell { font-family: "Avenir", sans-serif; font-size: 
12pt; font-weight: 810;  }
td.total-label-cell { font-family: "Avenir", sans-serif; font-size: 
12pt; font-weight: 780;  }


(visible if you open the exported HTML report in a text editor)

You can use the CSS stylesheet for your report, and copy those above 
rules to it. It is probably not strictly necessary to address the td 
element explicitly like the inline style does, just the class should work.


Or, with the Default stylesheet, simply adjust those options as desired 
on the Fonts tab: "Total Label Cell" and "Total Number Cell".


I'll file a bug on the Account Name sharing a class that makes it 
non-obvious what to change.


Regards,
Adrien

On 3/11/24 5:30 AM, Chris Green wrote:

On Fri, Mar 08, 2024 at 12:01:01PM -0600, Adrien Monteleone wrote:

Chris,

Once again, look into Edit > Stylesheets.

For the record, I'm using defaults, and the  is 12pt
bold and the  lines are 10pt normal weight. The total lines
match the .


On my GnuCash (version 4.8 on Linux) there isn't a separate setting
for the , it's the same size as 'Text Cell'.
Chnaging the font size for 'Text Cell' changes *all* the text (i.e. the
individual transaction descriptions etc.) as well as the account title.

There are no references to 'transaction' or 'name of account' in my
stylesheet settings.

Is this something that has been changed since version 4.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] Max value during year

[Adrien Monteleone]

You can take that same report and copy/paste into a spreadsheet, then 
set up a MAX() function in another cell to look at whatever column. 
(Balance, I would presume in this case)


Some spreadsheet apps have a configurable 'stats' bar at the bottom that 
can show preset analysis, such as MIN, MAX, AVG, COUNT, etc. In that 
case, just select the desired column or row (minus the header) and the 
values will auto-populate in the stats bar.


It isn't all done in GnuCash, but it at least saves manual scanning with 
your eyes.


Regards,
Adrien

On 3/10/24 11:47 PM, Fred Tydeman wrote:

Is there an easy way to find the maximum value of an account during a given
time period (such as a year)?

I currently do:  Reports: Assets & Liabilities: Asset chart:
Options:
   Accounts:  the account I care about
   Display: Show table
   General:  Start and End of previous year (or specific dates);
   Step size:  One Day
and then scan the table for the maximum.


___
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] trying to use good gnucash billing in personal books

[Alan Johnson via gnucash-user]

As others have said, you will want to talk to a CPA about how your
books are set up.  I'll share how I have mine set up. 

I also have a sole proprietorship/LLC with its own EIN. That entity has
its own set of books in GNUCash.  The LLC has its own bank accounts and
credit cards.  The preferred way of entering expenses is through the
vendor and customer interfaces.  As also mentioned, GNC doesn't really
do payroll, but you could set it up to enter the amounts.  I would set
up each employee as a vendor in GNC and then for each payroll copy the
values from your payroll service.  

For rentals, they also had their own account (under its EIN).  You
would receive the rents/other income into the biz account, pay the
bills out, and then take draws (against the equity account) when you
take funds out back to your personal accounts.  When you close the
books at the end of the year, you would close out to Retained Earnings.
 GNC would create a Profit and Loss, Balance Sheet, and Cash Flow
statement which your CPA would use to populate the Schedule C on your
personal return.  

On your personal books, you could represent the value of your SPP as an
Asset account (Assetts:MyOwnLLC) and adjust it's value to match the
equity amount on the balance sheet to reflect your net worth.  

Hope that helps.

On Sat, 2024-03-09 at 15:10 -0800, timothyscu...@yahoo.com wrote:
> I started down the path of setting up accounts payable to hold the
> bills that my sole proprietorship sends to me which I then pay. I
> created a first bill, assigning the line items to various expense
> accounts in my personal books, which is where I want those line items
> to be allocated. I'm apparently running into a problem where GNU cash
> insists on having the complete business system set up before you can
> use any part of it. And then it seems to be set up assuming that the
> business accounts are all for the business and are completely
> separate from my personal accounts. I tried to put liabilities and
> accounts payable under my personal equity account and then tried to
> post my first bill to accounts payable but the gnucash wouldn't let
> me do that. It wouldn't let me choose any existing account it wanted
> me to create a new one. When I created a new account under accounts
> payable then the account type field was unavailable. I was not able
> to select any account type for the accounts payable subaccount. So
> I'm apparently trying to pervert the design that was intended by the
> authors of good gnucash.
>  
> My first dumb question as if I set up a separate set of books for my
> business to hold the accounts receivable for the business which will
> consist of its bills to me, that I don't see how I can assign the
> line items in that bill to accounts in my personal books which was
> the whole point of the exercise from my point of view.
>  
> I was hoping there was a way I could set up accounts payable that
> would hold bills inside my personal books with line items that
> referred to expense accounts in my personal books. Is there a way to
> do that and I'm I just not seeing it?
>  
> Tim
>  
> From: timothyscu...@yahoo.com  
> Sent: Tuesday, March 5, 2024 6:52 AM
> To: 'Alan Johnson' ; 'David Carlson'
> 
> Cc: 'gnucash-user' 
> Subject: RE: [GNC] split transaction description field length limit
>  
> 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 

Re: [GNC] Bill total does not match real total

[Michael or Penny Novack]

On 3/11/2024 10:13 AM, Alan Johnson via gnucash-user wrote:

I've looked at odoo, but haven't decided to pull the trigger on it. To
use the sales/accounting features you need to subscribe and I'm not
ready for that yet with my business needs.

Well ... if it is really "open software" they would have to make the 
source code available for free (technically can charge reasonable cost 
for a copy on medium -- the 'rule" was made before we got things by 
download). The "open software" rules do NOT forbid charging for 
providing executables, support, etc. The originally concept was that 
nobody could charge excessively for that or somebody else would step in 
and provide at a more reasonable price. Yes, I am old enough to have 
followed the original "open software" discussions real time.



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] I'm getting started in Gnucash and want to list each item that I buy from one merchant

[W. Neal Lewis]

David,

No, I found out very quickly that return causes that sort of result.

Best regards,
Neal

On 3/9/24 10:32 PM, David Carlson wrote:

Neal,

By chance are you using the enter key during your editing?

That triggers the full transactiion calculatkions.  Use arrow keys, ta b
key or mouse buttons until you are ready to see the transaction calculation.

I think calculztions within individual amount fields happen as soon as you
move out of that field unless you are creating a scheduled transaaction.

On Sat, Mar 9, 2024, 8:36 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:


I'm not certain what you are describing, but I'll hazard a guess that
you are seeing GnuCash auto-balance the transaction. That is normal.
Every transaction has to be balanced. (Debits *must* equal Credits)

You are free to enter the transaction however you like, as long as that
holds true. If your self-entered amounts do not result in equal Debits &
Credits, GnuCash will create a split initially not assigned to any
account, but when you commit the transaction and that split remains, it
will be assigned to the account labeled: 'Imbalance-XXX' (where XXX is a
currency code) for the difference.

Please read the GnuCash Help Manual and the Tutorial & Concepts Guide
available in the Help Menu, or online, as you are learning the software.
Then if you get stuck, come back and ask for help here.

Regards,
Adrien

On 3/9/24 8:18 PM, W. Neal Lewis wrote:

When I do the View > Transaction and put in individual numbers for each

item in the Withdrawal column, it starts to mess with my figures. It puts
in a number at the very top. It adds deposits to other entries. What I end
up with is a mish-mash of costs that the program seems to think that I need
for some mythical number it has come up with.

That's exactly what happened previously. I don't want it adding numbers,

or changing numbers. I just want to put in the correct values for each
line, including tax, hit return and have the final value show up on the
first line of the transaction.

I obviously don't know what I am doing.

Help!
Neal


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


___
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] I'm getting started in Gnucash and want to list each item that I buy from one merchant

[W. Neal Lewis]

Thank you Adrien,

That's what I will need to do - do some in depth reading of the Help 
Manual and Tutorial.


Best regards,

Neal

On 3/9/24 8:35 PM, Adrien Monteleone wrote:
I'm not certain what you are describing, but I'll hazard a guess that 
you are seeing GnuCash auto-balance the transaction. That is normal. 
Every transaction has to be balanced. (Debits *must* equal Credits)


You are free to enter the transaction however you like, as long as 
that holds true. If your self-entered amounts do not result in equal 
Debits & Credits, GnuCash will create a split initially not assigned 
to any account, but when you commit the transaction and that split 
remains, it will be assigned to the account labeled: 'Imbalance-XXX' 
(where XXX is a currency code) for the difference.


Please read the GnuCash Help Manual and the Tutorial & Concepts Guide 
available in the Help Menu, or online, as you are learning the 
software. Then if you get stuck, come back and ask for help here.


Regards,
Adrien

On 3/9/24 8:18 PM, W. Neal Lewis wrote:
When I do the View > Transaction and put in individual numbers for 
each item in the Withdrawal column, it starts to mess with my 
figures. It puts in a number at the very top. It adds deposits to 
other entries. What I end up with is a mish-mash of costs that the 
program seems to think that I need for some mythical number it has 
come up with.


That's exactly what happened previously. I don't want it adding 
numbers, or changing numbers. I just want to put in the correct 
values for each line, including tax, hit return and have the final 
value show up on the first line of the transaction.


I obviously don't know what I am doing.

Help!
Neal



___
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] Bill total does not match real total

[Alan Johnson via gnucash-user]

I've looked at odoo, but haven't decided to pull the trigger on it. To
use the sales/accounting features you need to subscribe and I'm not
ready for that yet with my business needs. 


On Sun, 2024-03-10 at 13:58 -0500, Mark via gnucash-user wrote:
> Mar 10, 2024 11:01:45 Michael or Penny Novack
> :
> 
> > AFAIK no team in the open software world is trying to organize a
> > "business system" project.
> 
> There's Odoo ( https://www.odoo.com/ ). I haven't used it and don't
> know much about it. (I think someone on this list mentioned it awhile
> back.)
> ___
> 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.


smime.p7s
Description: S/MIME cryptographic 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] Setting font sizes in reports (specifically in Transaction Report)

[Chris Green]

On Fri, Mar 08, 2024 at 12:01:01PM -0600, Adrien Monteleone wrote:
> Chris,
> 
> Once again, look into Edit > Stylesheets.
> 
> For the record, I'm using defaults, and the  is 12pt 
> bold and the  lines are 10pt normal weight. The total lines 
> match the .
> 
On my GnuCash (version 4.8 on Linux) there isn't a separate setting
for the , it's the same size as 'Text Cell'.
Chnaging the font size for 'Text Cell' changes *all* the text (i.e. the
individual transaction descriptions etc.) as well as the account title.

There are no references to 'transaction' or 'name of account' in my
stylesheet settings.

Is this something that has been changed since version 4.8?

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