[GNC] Importing AR invoices

Adrien Monteleone adrien.monteleone at lusfiber.net
Wed Apr 3 14:44:45 EDT 2019


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 <Teresa at 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 <Teresa at coba-em.com>
>>>  wrote:
>>> 
>>>  we invoice up to 75 recurring invoices monthly, that include one of 5 IT products that are loaded in GNUCash.
>>> 




More information about the gnucash-user mailing list