Re: [GNC] Import matching

[Alan Johnson via gnucash-user]

Amazon doesn't split it into multiple invoices, but multiple payments per 
invoice. When you go into Amazon and go to Your Orders, click the *show 
invoice* link. At the bottom it will show you the payment break down (taxes, 
gift card, each CC payment made etc)

GNC will process this just fine. Just apply each CC payment to the appropriate 
open invoice.


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] Import matching

[Alan Johnson via gnucash-user]

For Amazon, your best bet is to use the vendor functions.
,
You can create the total invoice in GNC and then apply the payments to the 
invoice (which, on  orders with many items may be 3-4 payments).

Alternatively, you have to do janky things with placeholder transactions.

Apr 23, 2024 11:01:45 David Carlson :

> Gyle,
> 
> Please provide more information.  Not only have the import functions
> changed over recent releases, but there is more than one type.
> 
> Even without that information, I am sure that GnuCash cannot figure out how
> Amazon split one transaction into two.  You would have to manually check
> those and not expect a match.  My experience with matching in the OFX type
> has never been perfect and I plan on taking extra time to manually match or
> even just delete duplicates later for some transactions.  Results with some
> banks or credit cards are worse than others.
> 
> On Mon, Mar 11, 2024 at 4:06 PM Gyle McCollam  wrote:
> 
>> 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.
>> 
> 
> 
> -- 
> David Carlson
> ___
> 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] Bill total does not match real total

[Alan Johnson via gnucash-user]

I looked at the trial. The core they offer has a number of modules you
can use for free/self hosted/open source.  The accounting packages
require a subscription/paid service.  

On Mon, 2024-03-11 at 11:56 -0500, Adrien Monteleone wrote:
> 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.


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

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

[Alan Johnson via gnucash-user]

It may not wholly be a GNC problem, but a vendor software problem.

Having entered numerous bills from Amazon and Costco recently, there have been 
a few cases where the sales tax did not match. This required an additional line 
item to adjust the sales tax to make the totals match.

Entering bills from some different places with different rates on the same 
bill, I gave up and entered it all with no tax and just added a line item at 
the end (I want able to discern which items were at which rate)

It would be a different problem if you were on the selling side and for 
whatever reason the state disagreed with your sales tax figures and thus what 
you owe them.

Alan

Mar 7, 2024 09:17:18 Michael or Penny Novack :

> On 3/6/2024 12:49 PM, Carl Linkletter via gnucash-user wrote:
>> OK, Found the bug.  The problem is that the tax is totaled up using 
>> sub-penny calculations. That causes a 1.004 + 1.004 to equal 2.008 which is 
>> then rounded to 2.01.  Each line should be rounded to the penny first, then 
>> rounded up.  So if 1.004 is first rounded to 1.00, then that would cause 
>> this calculation to total 2.00, not 2.01.
>> 
>> If that makes any sense :-)  Guess I will enter a bug on this.
> 
> Does NOT solve the problem (rounding to the penny first). It is simply the 
> case that rounded(A) + rounded(B) /= rounded(A+B).
> 
> You have given an example where 1.004 + 1.004 would give 2.00 if rounded 
> first and 2.01 if rounded after adding. But how about 1.004 +  1.004 + 1.004 
> which would give 3.00 if rounded before adding and 3.01 if rounded after.
> 
> The problem is actually because of using "reals" to represent decimal 
> quantities. Now MY working days were spend with machines whose architecture 
> directly supported expressing decimals in BCD (binary coded decimal). But the 
> fact that our current CPUs don't directly support BCD representation and 
> arithmetic does not mean couldn't emulate that in software (in our higher 
> level language). Most of us using c++ are doing that so we don't have to 
> "roll our own" << c++ is actually a "pre-processor" for c >> Somebody like me 
> COULD come up with a BCD arithmetic package and I assume existing developers 
> could also.
> 
> The point is that people like the late Admr. Grace Murray Hopper (WWII 
> cryptologist, designer of COBOL) understood that using reals to express 
> decimals would have this problem and so used BCD for money amounts. That's 
> because intended for business and business implies money amounts. THEN 
> machine were made with architecture to directly support it.
> 
> Michael D Novack
> 
> PS --- BCD is essentially "integer" representation and math with the "display 
> amount" handling the editing to insert the decimal point. Now the only 
> arithmetic operation raising a rounding issue is division.
> 
> 
> ___
> 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] split transaction description field length limit

[Alan Johnson via gnucash-user]

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  
> Sent: Monday, March 4, 2024 7:43 AM
> To: David Carlson 
> Cc: timothyscu...@yahoo.com; gnucash-user  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 would need to set up an AP and AR account to post the invoices
> to.  To me, the vendor bill - payment system is the proper way to
> store the data, rather than kludging the memo fields.  Here is an
> example of a Costco receipt entered as a bill, then paid with a
> credit card through the vendor-payments section.  
>  
> I think that this would be the best way to handle the handyman
> payments as requested and job tracking (create various expense
> accounts). It would also allow for multiple types of payments - e.g.
> check, credit card, cash all on the same bill if needed.  
>  
> On Sun, 2024-03-03 at 21:41 -0600, David Carlson wrote:
> > Whatever the actual character count limit is for the memo field in
> > a transaction line, I have found the practical limit is what can be
> > printed in reports that show that field.  On the computer screen
> > you cannot directly see anything that is after a linefeed character
> > unless you scroll past that character since the 'window' is one
> > line tall.
> >  
> > I do not use business features so I don't have invoices or
> > vendors.  Another possibility would

Re: [GNC] split transaction description field length limit

[Alan Johnson via gnucash-user]

I suggest you put your handyman in as a vendor. Then you can create a bill with 
long descriptions per item, and then pay the bill with a check. If you want to 
see what was paid, right click on the payment entry in the register and choose 
jump to invoice/bill. You can also run a vendor report.

Mar 3, 2024 18:39:49 Tim via gnucash-user :

> The descriptions that I enter in GNU cash for split items get truncated. Is
> there a way to change this or is this a hard limit?
> 
> 
> 
> To provide some context, I pay a handyman to work on various projects. When
> I write the check to pay him I split the amount among the various projects
> (which correspond to line items on his timesheet)that he worked on to
> allocated it to the different expense accounts associated with those
> projects. I like to enter a fairly long description which includes things
> like the date the work was done, the location, and a brief description of
> what was done but GNU cash truncates it when producing reports or when I go
> back and look at data that I entered earlier.
> 
> 
> 
> Should I be setting up an account for the handyman in which the line items
> of his timesheet would be entered as individual transactions which add up to
> the amount he gets paid? I get the impression that I'm probably trying to
> misuse GNU cash again as I was when I paid my credit card bills with long
> split transactions. I was able to fix that by entering the transactions in
> an account for the credit card and then having a single transaction from my
> bank account to pay off the credit card. I'm not adept enough at accounting,
> to put it mildly, to know if there's something analogous I should be doing
> in this case. Can you explain it in a way that a newbie would understand?
> 
> 
> 
> Thank you
> 
> 
> 
> 
> 
> ___
> 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] Trouble importing bills via csv

[Alan Johnson via gnucash-user]

So, I was working on it and here was that worked as I was playing with
it. I'm using LibreOffice to edit the CSVs. 

Edit the filter on the "save as" dialog, then I set the field delimiter
and deleted the string delimiter and unchecked 'quote all text cells'. 

Then I was able to successfully able to import the bills.  

Alan

On Sat, 2024-02-24 at 19:10 -0500, Alan Johnson via gnucash-user wrote:
> I did read the manual, hence my usage of the quotes. I had done it
> before without.  
> 
> I'll make a video and send it out shortly. 
> 
> Alan
> 
> On Sun, 2024-02-25 at 10:02 +1000, David H wrote:
> > Alan,
> > 
> > Your file imports fine here after I add the vendor, create the
> > Accounts Payable liability, remove the header line and remove the
> > double quotes that you have plastered around every field for some
> > reason which probably causes the other errors.
> > 
> > It might pay to read up on Gnucash Bills Importing
> > at 
> > https://gnucash.org/docs/v5/C/gnucash-guide/busnss-imp-bills-invoices.html
> >  and the examples therein :-
> > 
> > You'll note a complete absence of double quotes in the following
> > example and no header line.
> > 
> > Hope this helps,
> > 
> > Cheers David H.
> > 
> > 
> > Note on double quotes
> > If you use the field separator character within a field, the field
> > value should be enclosed in double quotes. Only for the fields
> > description (desc) and notes, can you also include a double quote
> > within a quoted field value, by doubling the double quote.
> > E.g. "This
> > field value uses the separator, and a ""quoted"" word", would be
> > imported as This field value uses the separator, and a "quoted"
> > word.
> > 
> > Example content for two bills; one of 2 entries, and one of 3
> > entries. The first is saved and posted, the second only saved.
> > Using
> > comma field separator, decimal point and dd/mm/ date format.
> > 1204;15/12/2018;2001;PO 210220;Special delivery;16/12/2018;Pride
> > and
> > Prejudice;pc;Expenses:Books;1;30.00X;;A1;17/12/2018;17/1/2019;L
> > ia
> > bilities:Accounts Payable;;X
> > 1204;15/12/2018;2001;PO 210220;Special
> > delivery;16/12/2018;Electronic
> > principles;pc;Expenses:Books;1;50.00X;;A1;17/12/2018;17/1/2019;
> > Li
> > abilities:Accounts Payable;;X
> > 1205;15/12/2018;2044;PO 21099;;16/12/2018;Ultimate
> > Guide;pc;Expenses:Books;1;10.01;;;
> > 1205;15/12/2018;2044;PO 21099;;16/12/2018;Dinner &
> > drinks;pc;Expenses:Dining;1;10.01;;;
> > 1205;15/12/2018;2044;PO 21099;;16/12/2018;UG
> > course;pc;Expenses:Education;1;10.01;;;
> > 
> > 
> > On Sun, 25 Feb 2024 at 04:09, Alan Johnson via gnucash-user
> >  wrote:
> > > I tried that with the same result. GNC says it ignored that line,
> > > and that's fine.
> > > 
> > > I'm concerned with the error messages indicating that the vendor
> > > and accounts don't exist. Have I input that data incorrectly?
> > > 
> > > Feb 24, 2024 13:00:20 Adrien Monteleone
> > > :
> > > 
> > > > Although you should be able to have header row(s), perhaps
> > > > remove
> > > it and try again.
> > > > 
> > > > The Documentation for this is worded oddly, but the samples
> > > provided don't show header info at all.
> > > > 
> > > > 
> > > https://www.gnucash.org/docs/v5/C/gnucash-guide/busnss-imp-bills-invoices.html
> > > > 
> > > > Regards,
> > > > Adrien
> > > > 
> > > > On 2/24/24 10:15 AM, Alan Johnson via gnucash-user wrote:
> > > > > Hello,
> > > > > I'm having some issues importing a bill via CSV. I set up a
> > > trial run
> > > > > and I'm getting the below errors.  Vendor "05" does not
> > > exist,
> > > > > however that is the vendor ID for Amazon in my file.  It says
> > > account
> > > > > "Liabilities:Accounts Payable" does not exist (but it does).
> > > > > It
> > > says
> > > > > the Expense account also does not exist (but it does) and
> > > > > then
> > > it
> > > > > proceeds to ignore the line.
> > > > > How do I correct this for proper import? I've had the same
> > > > > issue
> > > on the
> > > > > Customer invoice import side as well.
> > > > 

Re: [GNC] Trouble importing bills via csv

[Alan Johnson via gnucash-user]

I did read the manual, hence my usage of the quotes. I had done it
before without.  

I'll make a video and send it out shortly. 

Alan

On Sun, 2024-02-25 at 10:02 +1000, David H wrote:
> Alan,
> 
> Your file imports fine here after I add the vendor, create the
> Accounts Payable liability, remove the header line and remove the
> double quotes that you have plastered around every field for some
> reason which probably causes the other errors.
> 
> It might pay to read up on Gnucash Bills Importing
> at 
> https://gnucash.org/docs/v5/C/gnucash-guide/busnss-imp-bills-invoices.html
>  and the examples therein :-
> 
> You'll note a complete absence of double quotes in the following
> example and no header line.
> 
> Hope this helps,
> 
> Cheers David H.
> 
> 
> Note on double quotes
> If you use the field separator character within a field, the field
> value should be enclosed in double quotes. Only for the fields
> description (desc) and notes, can you also include a double quote
> within a quoted field value, by doubling the double quote. E.g. "This
> field value uses the separator, and a ""quoted"" word", would be
> imported as This field value uses the separator, and a "quoted" word.
> 
> Example content for two bills; one of 2 entries, and one of 3
> entries. The first is saved and posted, the second only saved. Using
> comma field separator, decimal point and dd/mm/ date format.
> 1204;15/12/2018;2001;PO 210220;Special delivery;16/12/2018;Pride and
> Prejudice;pc;Expenses:Books;1;30.00X;;A1;17/12/2018;17/1/2019;Lia
> bilities:Accounts Payable;;X
> 1204;15/12/2018;2001;PO 210220;Special delivery;16/12/2018;Electronic
> principles;pc;Expenses:Books;1;50.00X;;A1;17/12/2018;17/1/2019;Li
> abilities:Accounts Payable;;X
> 1205;15/12/2018;2044;PO 21099;;16/12/2018;Ultimate
> Guide;pc;Expenses:Books;1;10.01;;;
> 1205;15/12/2018;2044;PO 21099;;16/12/2018;Dinner &
> drinks;pc;Expenses:Dining;1;10.01;;;
> 1205;15/12/2018;2044;PO 21099;;16/12/2018;UG
> course;pc;Expenses:Education;1;10.01;;;
> 
> 
> On Sun, 25 Feb 2024 at 04:09, Alan Johnson via gnucash-user
>  wrote:
> > I tried that with the same result. GNC says it ignored that line,
> > and that's fine.
> > 
> > I'm concerned with the error messages indicating that the vendor
> > and accounts don't exist. Have I input that data incorrectly?
> > 
> > Feb 24, 2024 13:00:20 Adrien Monteleone
> > :
> > 
> > > Although you should be able to have header row(s), perhaps remove
> > it and try again.
> > > 
> > > The Documentation for this is worded oddly, but the samples
> > provided don't show header info at all.
> > > 
> > >
> > https://www.gnucash.org/docs/v5/C/gnucash-guide/busnss-imp-bills-invoices.html
> > > 
> > > Regards,
> > > Adrien
> > > 
> > > On 2/24/24 10:15 AM, Alan Johnson via gnucash-user wrote:
> > >> Hello,
> > >> I'm having some issues importing a bill via CSV. I set up a
> > trial run
> > >> and I'm getting the below errors.  Vendor "05" does not
> > exist,
> > >> however that is the vendor ID for Amazon in my file.  It says
> > account
> > >> "Liabilities:Accounts Payable" does not exist (but it does). It
> > says
> > >> the Expense account also does not exist (but it does) and then
> > it
> > >> proceeds to ignore the line.
> > >> How do I correct this for proper import? I've had the same issue
> > on the
> > >> Customer invoice import side as well.
> > >> This is on Ubuntu with Flatpak 5.5
> > >> Here is the raw CSV import:
> > >>
> > "id";"date_opened";"owner_id";"billingid";"notes";"date";"desc";"ac
> > tion
> > >>
> > ";"account";"quantity";"price";"disc_type";"disc_how";"discount";"t
> > axab
> > >>
> > le";"taxincluded";"tax_table";"date_posted";"due_date";"account_pos
> > ted"
> > >> ;"memo_posted";"accu_splits"
> > >> "111-7425790-5888250";05/11/23;"05"05/11/23;"Low Profile
> > Fuse
> > >> Kit";;"Expenses:Auto:2016 Big
> > >>
> > Country:BigCountryMaintenance";1;12;;;05/11/23;05/11/23;"Liabil
> > itie
> > >> s:Accounts Payable";;"N

Re: [GNC] Trouble importing bills via csv

[Alan Johnson via gnucash-user]

I tried that with the same result. GNC says it ignored that line, and that's 
fine.

I'm concerned with the error messages indicating that the vendor and accounts 
don't exist. Have I input that data incorrectly?

Feb 24, 2024 13:00:20 Adrien Monteleone :

> Although you should be able to have header row(s), perhaps remove it and try 
> again.
> 
> The Documentation for this is worded oddly, but the samples provided don't 
> show header info at all.
> 
> https://www.gnucash.org/docs/v5/C/gnucash-guide/busnss-imp-bills-invoices.html
> 
> Regards,
> Adrien
> 
> On 2/24/24 10:15 AM, Alan Johnson via gnucash-user wrote:
>> Hello,
>> I'm having some issues importing a bill via CSV. I set up a trial run
>> and I'm getting the below errors.  Vendor "05" does not exist,
>> however that is the vendor ID for Amazon in my file.  It says account
>> "Liabilities:Accounts Payable" does not exist (but it does). It says
>> the Expense account also does not exist (but it does) and then it
>> proceeds to ignore the line.
>> How do I correct this for proper import? I've had the same issue on the
>> Customer invoice import side as well.
>> This is on Ubuntu with Flatpak 5.5
>> Here is the raw CSV import:
>> "id";"date_opened";"owner_id";"billingid";"notes";"date";"desc";"action
>> ";"account";"quantity";"price";"disc_type";"disc_how";"discount";"taxab
>> le";"taxincluded";"tax_table";"date_posted";"due_date";"account_posted"
>> ;"memo_posted";"accu_splits"
>> "111-7425790-5888250";05/11/23;"05"05/11/23;"Low Profile Fuse
>> Kit";;"Expenses:Auto:2016 Big
>> Country:BigCountryMaintenance";1;12;;;05/11/23;05/11/23;"Liabilitie
>> s:Accounts Payable";;"N"
> 
> ___
> 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.

[GNC] Issues importing transactions (not matching)

[Alan Johnson via gnucash-user]

Hello,

I'm attempting to import transactions from a credit card QFX file /
Quicken format.  


I have the pre-entered transaction as 'LEGO' in the amount of 45.14. 
The imported transaction is "LEGO Enfeild CT" in the amount of 45.14. 

Gnucash thinks these are not the same - and there are a number of other
transactions that are the same way.  How can I manually match these? or
adjust it so they match?

Thanks,

Alan


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] Discount / Coupon question - How to apply?

[Alan Johnson via gnucash-user]

I created the income account "discounts" and did it with a manual
transfer to the expense account.  




On Wed, 2024-01-03 at 11:16 -0600, Adrien Monteleone wrote:
> Thanks for reporting back, but for posterity, which method worked?
> 
> (assigning as payment, or using an intermediary account)
> 
> Regards,
> Adrien
> 
> On 1/2/24 11:31 AM, Alan Johnson via gnucash-user wrote:
> > Thanks, that worked.
> 
> > On Sun, 2023-12-31 at 14:36 -0600, Adrien Monteleone wrote:
> > > Is this screenshot taken while viewing the AR account? That error
> > > message usually means you don't have a split in the transaction
> > > that
> > > is
> > > AR/AP.
> > > > > Be sure to commit the transaction first, then try right-
> > > > > clicking to
> > > assign the payment.
> > > 
> > > If it still won't work, you might have to employ some
> > > intermediary
> > > accounts.
> > > 
> > > One option is to create a contra-income (sales) account for
> > > something
> > > like "Discounts & Allowances", and then issue a Credit Note for
> > > that
> > > Customer with a line item posted to that account. (the Credit
> > > Note
> > > itself will post to AR)
> > > 
> > > Then process a payment and select the Credit Note & Invoice to
> > > offset.
> > > ('pay' the invoice with the Credit Note)
> > > 
> > > Then do a manual transaction between the Discounts & Allowances
> > > account
> > > and your desired expense account. (moving the amount from contra-
> > > sales
> > > to expense)
> 
> ___
> 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] Discount / Coupon question - How to apply?

[Alan Johnson via gnucash-user]

I'm not a coder, but I've considered learning to give it a shot :)

Alan

On Tue, 2024-01-02 at 12:34 -0500, Derek Atkins wrote:
> 
> 
> On Tue, January 2, 2024 12:31 pm, Alan Johnson via gnucash-user
> wrote:
> > Thanks, that worked. 
> > 
> > Perhaps a future feature to add a coupon/discount mechanism to the
> > customer invoice interface would be in order?
> 
> Patches always welcome!  :)
> > 
> > Alan
> 
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> 
> -derek
> 


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] Discount / Coupon question - How to apply?

[Alan Johnson via gnucash-user]

Thanks, that worked. 

Perhaps a future feature to add a coupon/discount mechanism to the
customer invoice interface would be in order?

Alan

On Sun, 2023-12-31 at 14:36 -0600, Adrien Monteleone wrote:
> Is this screenshot taken while viewing the AR account? That error 
> message usually means you don't have a split in the transaction that
> is 
> AR/AP.
> 
> Can you turn on View > Transaction Journal and send another
> screenshot?
> 
> Be sure to commit the transaction first, then try right-clicking to 
> assign the payment.
> 
> If it still won't work, you might have to employ some intermediary
> accounts.
> 
> One option is to create a contra-income (sales) account for something
> like "Discounts & Allowances", and then issue a Credit Note for that 
> Customer with a line item posted to that account. (the Credit Note 
> itself will post to AR)
> 
> Then process a payment and select the Credit Note & Invoice to
> offset. 
> ('pay' the invoice with the Credit Note)
> 
> Then do a manual transaction between the Discounts & Allowances
> account 
> and your desired expense account. (moving the amount from contra-
> sales 
> to expense)
> 
> Regards,
> Adrien
> 
> On 12/31/23 1:38 PM, Alan Johnson via gnucash-user wrote:
> > Adrien,
> > 
> > I tried that and I get the below error message:
> > 
> > The selected transaction doesn't have splits that can be assigned
> > as a
> > payment
> 
> ___
> 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] Discount / Coupon question - How to apply?

[Alan Johnson via gnucash-user]

Adrien,

I tried that and I get the below error message:

The selected transaction doesn't have splits that can be assigned as a
payment



On Sat, 2023-12-30 at 21:31 -0600, Adrien Monteleone wrote:
> Alan,
> 
> Create a manual transaction between the desired expense account and 
> Accounts Receivable. (Debit the Expense, Credit AR)
> 
> Then right click the transaction after committing it, and choose
> 'Assign 
> as Payment'.
> 
> In the Process Payment window, select the invoice you want to apply
> this 
> to and any other relevant info, then commit the payment.
> 
> Regards,
> Adrien
> 
> On 12/30/23 6:16 PM, Alan Johnson via gnucash-user wrote:
> > I have a customer that I have created an invoice for.
> > 
> > How do I create a coupon/discount to pay for the invoice and charge
> > it
> > to a marketing expense? I tried to choose the expense account but
> > it
> > will only allow me to use income or liability 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.


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.

[GNC] Discount / Coupon question - How to apply?

[Alan Johnson via gnucash-user]

Hello,

I have a customer that I have created an invoice for. 

How do I create a coupon/discount to pay for the invoice and charge it
to a marketing expense? I tried to choose the expense account but it
will only allow me to use income or liability accounts.

Thanks,

Alan


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] Monthly Expense summary Report

[Alan Johnson via gnucash-user]

When I select "Expenses" and choose select children, it selects all of
the children appropriately.  When I go to Income, and then select
"Select Children" it deselects all of the expense accounts and leaves
only the Income accounts selected.  

Manually selecting via ctrl+Click deslelects the other accounts as
well.  This may be a bug - I should be able to use the select children
button repeatedly to select child accounts without it clearing the
previously selected accounts.  


On Thu, 2023-12-14 at 14:13 -0600, Adrien Monteleone wrote:
> Either of those reports (Transaction or Budget) should allow you to 
> select any accounts you want.
> 
> Regards,
> Adrien
> 
> On 12/14/23 12:19 PM, Alan Johnson via gnucash-user wrote:
> > Thanks,
> > 
> > That will work. Only annoyance is that I can't seem to select both
> > income and expense at the same time, requiring two reports.
> > 
> > The default had the asset and liability accounts selected, which
> > was
> > not needed.
> 
> ___
> 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] Monthly Expense summary Report

[Alan Johnson via gnucash-user]

Thanks,

That will work. Only annoyance is that I can't seem to select both
income and expense at the same time, requiring two reports. 

The default had the asset and liability accounts selected, which was
not needed.  

On Thu, 2023-12-14 at 10:53 -0600, Adrien Monteleone wrote:
> The Transaction Report can group by period with subtotals and totals.
> That is a listing of each transaction though. You can likely reduce 
> detail, but there should be a summary table you can turn on which
> might 
> get you close.
> 
> Also take a look at the Budget Report multi-period feature. If you
> don't 
> want the actual budget features, you can still use the report to show
> actual expenses. This report presents a column for each period by 
> account. You also get a YTD total column if you want it, and can 
> collapse previous/future periods from the one you want to focus on.
> 
> Regards,
> Adrien
> 
> On 12/14/23 9:17 AM, Alan Johnson via gnucash-user wrote:
> > Hello,
> > 
> > Is there a way to have an expense report that breaks out the
> > columns by
> > week and/or month?
> > 
> > Other software will allow me to display the expense category for
> > each
> > month/quarter/week/chosen grouping period and then sum them at the
> > end.
> > 
> > For example, In this report I could see how much I spent on
> > Expenses:Auto:Fuel for Jan/Feb/Mar.../Dec and then the Year on one
> > screen without having to run 12 different reports.
> > 
> > I don't desire to have each transaction for those months, just the
> > summary of the amount spent in each category for the
> > month/week/quarter.
> 
> ___
> 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.

[GNC] Monthly Expense summary Report

[Alan Johnson via gnucash-user]

Hello,

Is there a way to have an expense report that breaks out the columns by
week and/or month? 

Other software will allow me to display the expense category for each
month/quarter/week/chosen grouping period and then sum them at the
end. 

For example, In this report I could see how much I spent on
Expenses:Auto:Fuel for Jan/Feb/Mar.../Dec and then the Year on one
screen without having to run 12 different reports. 

I don't desire to have each transaction for those months, just the
summary of the amount spent in each category for the
month/week/quarter.

Thanks,

Alan


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] How to change date of balance on register?

[Alan Johnson via gnucash-user]

Thanks.  The Current / Current USD is what I was looking for (balance
as of today).  Playing around, I see a total (period) which shows a
negative balance but the account isn't actually negative. It looks like
it is showing the delta from the start of the 'period' - which I take
to be the start of calendar year, to today, something like a statement
of cash flows.  It would be nice of one of those options was
customizeable - say 30 or 60 days or a chosen date out.  

Alan

On Mon, 2023-12-11 at 12:31 -0500, Kalpesh Patel wrote:
> There is really not a way to specify the date range the way I think
> you want to -- like today to end-of-month or today to infinity --
> that is somewhat dynamically adjusting per se. As David mentioned,
> you can select from pre-built ones by putting a check mark in the
> ones that you want to display in the Account page. Out of those ones,
> I'll say 'Present (USD)' is likely to give you the closest one as it
> will normalize all accounts in to common USD basis rather than just
> 'Present' as you will not see the monetary value but amount of shares
> for each issue you have. If you want a bit more "custom" then you can
> enable view by 'Period' or 'Period (USD)' and then you can set the
> period range in 'Edit' -> 'Preference' -> 'Accounting Period'
> sheet.   
> 
> -Original Message-
> From: David H  
> Sent: Sunday, December 10, 2023 5:32 PM
> To: Alan Johnson 
> Cc: gnucash-user@gnucash.org
> Subject: Re: [GNC] How to change date of balance on register?
> 
> If you click on the down arrow in the header line of the accounts tab
> far right you can select lots of dates, see below - try "Present"
> 
> 
> Cheers David H.
> 
> [image: image.png]
> 
> 
> On Mon, 11 Dec 2023 at 08:12, Alan Johnson via gnucash-user <
> gnucash-user@gnucash.org> wrote:
> 
> > Hello,
> > 
> > I'm running GnuCash 5.4.1 flathub.
> > 
> > Is there a way to change the date of balance shown in the account 
> > overview?
> > 
> > For example, I have a checking account with 10,000 in it today.  I 
> > have a couple transactions that are future dated which decrease the
> > balance.
> >  On the Accounts page, it shows the lower balance of the future
> > amount.
> > Is there a way to change which date is the reference date for 
> > displaying the balance?
> > 
> > Thanks,
> > Alan
> > ___
> > 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.

[GNC] How to change date of balance on register?

[Alan Johnson via gnucash-user]

Hello,

I'm running GnuCash 5.4.1 flathub.  

Is there a way to change the date of balance shown in the account
overview?

For example, I have a checking account with 10,000 in it today.  I have
a couple transactions that are future dated which decrease the balance.
 On the Accounts page, it shows the lower balance of the future amount.
Is there a way to change which date is the reference date for
displaying the balance?

Thanks,
Alan


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] Dealing with escrow account

[Alan Johnson via gnucash-user]

Your mortgage payment should be fixed, adjusting one a year for escrow
review. 

You can automate / enter a year's worth of payments from bank to
mortgage account.  

You should also have a the 360 (or other) payment amortization table as
part of your loan packet which shows you what each payment will be for
Principal and Interest.  Unless you are paying extra, you can just
follow that to pre-enter your transactions. 

Alternatively, you can enter 12 mos of payments from bank, enter 12 mos
of escrow (which should be fixed unless it adjusts) and approximate the
interest and then reconcile with your statement.  Interest will likely
decline a few dollars each payment.  

When you get your bills for taxes and insurance, if they are escrowed,
then you can enter/pay them out of the escrow asset account.  

On Thu, 2023-11-02 at 12:41 -0400, Jediator wrote:
> One way to automate the bill generation would be to create a payment 
> plan in a spreadsheet.  It should be fairly easy to calculate
> principal 
> and interest in each installment in a spreadsheet, and convert that 
> spreadsheet in to csv format for bill generation in GC, and import
> the 
> csv file to GC to populate the bills.  You may have to create two
> CSVs, 
> one with PMI and the other without PMI (i.e., when your principal 
> reaches 10% of your loan as in the US).
> 
> On 11/2/23 9:00 AM, Michael or Penny Novack wrote:
> > a) The amounts principal vs interest going to be changing each
> > payment 
> > (if here in the US with amortizing mortgages). How to automate that
> > not easy especially as the lender may have calculated the
> > amortization 
> > table differently (chance you and they used same method very small)
> > . 
> 
> ___
> 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] Dealing with escrow account

[Alan Johnson via gnucash-user]

I structure my mortgage accounts like thus:

- Asset account representing the property value (sub accounts for land
/ buildings as needed)
- Loan/Liability account representing the amount borrowed which is
transferred to the Property Asset account
- Closing costs from the HUD-1 should also be accounted for as
expenses, along with contributions from checking/cash for down payments
- Asset account for escrow (initial transfer from purchase transaction
/ liability account to fund the account at closing)

- Payment from checking goes to the mortgage liability account
- I assess interest expense as an increase in the liability account
- Transfer escrow payment to escrow account out of (increase) liability
account

Although not expressly listed, the balance applied to the loan balance
is the principle payment that reduces the outstanding amount.  The
balance of the loan account should then be the pay off amount of the
loan, adjusted for accrued interest since the last statement/entry.  

Escrow account pays out expenses (property taxes, hazard insurance,
etc.) as expense line items. 

Tracking the escrow balance separately is also useful for tracking
refunds due to you when you sell and/or pay off the loan.  

Alan

On Wed, 2023-11-01 at 11:10 -0400, Michael or Penny Novack wrote:
> On 11/1/2023 12:03 AM, Edwin Booth wrote:
> > Hi. How do y’all deal with a mortgage escrow account? Specifically,
> > each
> > month I pay into the escrow account along with my monthly PMI
> > payment. It
> > is all an expense. But when the mortgage company pays out money
> > from that
> > escrow account (for taxe and insurance payments) how do you account
> > for
> > them in GnuCash? Or do you just wait until tax time and record it
> > on your
> > return w/o even putting into GC?
> > 
> > Thanks, Edwin
> 
> 
> "each month I pay into the escrow account along with my monthly PMI
> payment. It
> is all an expense."
>   
> No it is not. In order to learn bookkeeping you need to unlearn the
> mental habit "if money leaves my pocket, an expense  and if money
> not leaving my pocket, not an expense."
> 
> When you make a mortgage payment it is a SPLIT transaction. What you
> pay (a credit against your bank account) and debits to THREE
> accounts. Only one of these, mortgage interest would be an expense
> account. The escrow account is an ASSET, your money being safely set
> aside in order to pay expenses when they come due. Expenses like real
> estate tax, water and sewer bills, property insurance bills, etc. It
> is quite possible that the lender will send you a statement for that
> account just once a year. You might want to be using the previous
> statement to enter ESTIMATED transactions on estimated dates and then
> reconcile (manually) when your next statement gives actuals.
> 
> 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.


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] I need basic help

[Alan Johnson via gnucash-user]

You need to assign each CC transaction to an expense account. E.g. McDonalds is 
"dining".

When you pay down your CC, you make a transfer from you checking (or cash/etc) 
to the cc account.

The expense categories will allow you to run reports and see what you are 
spending your money on.

Your checking / cash is an asset. Your CC is a liability (something that you 
owe).

Go into the credit card account register and assign expense categories to all 
transactions that are assigned to imbalance.

The imbalance account should be empty. If it's not, then something is not 
assigned properly. 

Hope this helps.

Oct 18, 2023 14:21:34 Edwin Booth :

> Hi. New to this. I just downloaded an OFX file for a credit card I have. I
> imported it into my “Unsaved Book.” That worked. It is now on the Accounts
> Page with an amount under the “Total” column. But there is also a line that
> says “Imbalance-USD” with the same same amount under Total. I understand (I
> think) that that Imbalance is due to the fact that I have no other account
> in there and so there is nothing to balance my CC account with.
> 
> So, I obviously need to enter some new accounts. I haven’t paid off all of
> that CC account, but I have paid some of it. The unpaid portion would be
> under “Liability” I assume, and the paid part under “Expense.”
> 
> Not sure what to do next. I’m running GnuCash on a MacBook Pro, which I’m
> also pretty new at.
> 
> Thanks,
> 
> Edwin
> ___
> 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.

[GNC] Issue with default invoice template

[Alan Johnson via gnucash-user]

Hello,

I'm using GNUCash 5.4, flathugb 5.4.1, finance quote 1.58 on Ubuntu
23.04. 

I edited the template for invoices successfully.  However, when I go to
a customer account and go to print an invoice, it changes to the
default invoice template every time. 

I've made the changes under Options and Applied / hit OK.  I've tried
Save Config, but alas it does not stick.  

How can I make it so when I print an invoice it will use my selected
template every time by default?

Thanks,
Alan


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: Applying Customer overpayments

[Alan Johnson]

*replying to the list

Geert,

Thanks. That worked. However it wanted to apply the funds to the 
checking account (which were already deposited/received). I deleted that 
part of the transaction from the AR register, and the balance offset 
still works, just does not reflect as a payment on the customer report. 
Is there a better account to debit the funds? In the balance sheet / P 
I don't see any sort of customer funds held/liability that would be 
where the offset would go.


Also, this feature wasn't in the documentation (at least that I could 
find). The documentation merely states that GnuCash would keep track of 
any overpayment. It sounds like a feature like QuickBoox payment system 
check box "Apply customer balance to invoice" is needed.

Alan


On 2/8/2018 1:09 PM, Geert Janssens wrote:

Op donderdag 8 februari 2018 18:41:56 CET schreef Alan Johnson:

Hello, I'm having an issue with GnuCash. A customer has a
overpayment/credit balance. How do I apply it to an invoice so that it
comes out of the AR report at the bottom of the customer report? The
total due / sums are correct, but the customer report has a 91+ day
balance of (0.03). I would like to apply the payment to an invoice / fix
the AR box on the customer report. This is on version 2.6.19.


- Go to Business->Customer->Process Payment
- Select the customer you refer to above
- You should get a list of open invoices and overpayments
- Select both the 0.03 overpayment and the invoice you want to apply it to
(using shift- or ctrl-click)
- If you only want to apply this 0.03, adjust the amount to exactly that 0.03
- Click Ok

Regards,

Geert




___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Applying Customer overpayments

[Alan Johnson]

Hello, I'm having an issue with GnuCash. A customer has a 
overpayment/credit balance. How do I apply it to an invoice so that it 
comes out of the AR report at the bottom of the customer report? The 
total due / sums are correct, but the customer report has a 91+ day 
balance of (0.03). I would like to apply the payment to an invoice / fix 
the AR box on the customer report. This is on version 2.6.19.


Thanks,

Alan

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.