If you’re doing manual entries (or importing the invoices as regular 
transactions instead of as invoices) you determine the accounts posted to so 
assign the splits as you wish, manually after the import or adding that info to 
the CSV.

I’d recommend going to the View menu and switching to Transaction Journal mode. 
(and optionally turn on Double Line mode as well which displays a ’note’ field 
for the entire transaction so you aren’t limited to only the memos fields on 
the splits)

This will always show all split information so you can see all debits and 
credits for each transaction. It helps to be able to follow exactly which 
accounts are involved.

Note, how you have this setup here and how this would work with manual entries 
(typed in or imported) is that the A/R sub-accounts will show $0 if all 
invoices have been collected on. They won’t show you how much has been paid, 
but how much is still owed. (if anything)

The signs of the figures you show in this screenshot are backwards for the A/R 
accounts. This looks like the company owes that money to someone, not that 
someone else owes the company. A/R is an asset because it is revenue earned, 
but not yet collected. Once collected it is accounted for in whatever account 
it was paid into. (Cash, Checking, etc.)

If you have outstanding invoices you haven’t collected on, A/R should be 
positive. If someone pre-paid or overpaid, that would be a credit to A/R.

Textbook invoice transaction:

Dr. Assets:Accounts Receivable
Cr. Income:Sales

It looks like you have the preference for Reversed Balance Accounts set to 
’None’ and this is your transaction entry:

Dr. Income:Sales
Cr. Assets:Accounts Receivable

—which is backwards.

Regards,
Adrien

> On Apr 2, 2019, at 11:06 AM, Teresa <ter...@coba-em.com> wrote:
> 
> What we do is sell IT preventative maintenance for Hotels. I have GL accounts 
> set up for each item we sell, total of 5.
> 
> what I need to be able to do is import in Assets, how much to apply to each 
> gl account, I also have gl accounts set up under income for paid
> 
> Should I skip doing it as an import and just add lines and amounts under each 
> sold account. If I do this will the system create a credit entry under the 
> corresponding paid account?
> 
> Sold GL accounts are 401-9182 through 401-9185
> 
> Paid accounts are 400-9182 through 400-9185
> 
> <ncnpmedacpbmchml.png>
> 
> 
> 
> On 4/1/2019 10:47 PM, Adrien Monteleone wrote:
>> Teresa,
>> 
>> I forgot to mention, GnuCash has no facility to store ‘products’ or ’service 
>> offerings’ or any kind of ‘inventory’. You just create your own invoice line 
>> items each time. But the software does utilize auto-fill based on previous 
>> entries. So you can start typing a line item description and it will fill in 
>> the rest based on a previous entry as well as other line item info like 
>> income account, discounts, quantity, pricing, tax etc.
>> 
>> If the invoices are exact (or even near) duplicates, you can use the 
>> Duplicate Invoice button as a starting point and edit accordingly.
>> 
>> Regards,
>> Adrien
>> 
>> 
>>> On Apr 1, 2019, at 10:55 AM, Teresa <ter...@coba-em.com>
>>>  wrote:
>>> 
>>>  we invoice up to 75 recurring invoices monthly, that include one of 5 IT 
>>> products that are loaded in GNUCash.
>>> 


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

Reply via email to