Re: [GNC] Best way to close unpaid invoices?

2021-03-10 Thread Daffy Duck
It is a discount, but the issue is:

1. It's multiple invoices to the same client
2. I want to create a new, final invoice that summarizes the expenses
that will be reimbursed and the actual services being paid for.  Two
different amounts on a single invoice, with a single total(but
separating expenses and sales).

Just doing a discount wouldn't do this, and would be harder.  There
were like 10 invoices that client had.  

So, I have paid those ten invoices from "renegotiated accounts" and
created a new invoice with expenses+sales agreed on.  

The only issue is, there is not a "bad debts" third account in this
situation.  Not sure how to implement something like that?  I had
"losses from renegotiated accounts" but that didn't seem to work.

On Tue, 2021-03-09 at 13:51 -0600, Adrien Monteleone wrote:
> On 3/9/21 12:21 PM, Daffy Duck wrote:
> > Ok, I think I have it working now.
> > 
> > So, the better way to look at the discounted situation in my case
> > was
> > "renegotiated accounts" because I want to pay expenses prior to
> > income.
> 
> Not sure I'm following here. Let's take this one step at a time.
> 
> First, I thought you had two separate cases: 1) a bad debt, 2) a 
> discount you wanted to offer after issuing an invoice. Is this not 
> correct? (the AFDA account is for case #1, the Credit Note is for
> case #2)
> 
> Second, What do your own expenses, and when you pay them, have to do 
> with giving a discount to a customer after you've invoiced them?
> 
> > So, I created a new asset account called "renegotiated accounts"
> > and
> > paid the outstanding invoices for this individual from that.
> > 
> > I then created a new invoice for the new amount, separating
> > reimbursed
> > expenses from income.  On the new invoice, the transfer account is
> > "renegotiated accounts."
> 
> This is starting to sound more complicated than the initial post.
> That's 
> fine, but please be clear about what you are trying to accomplish.
> 
> What do reimbursed expenses have to do with the discount situation?
> 
> -
> 
> My personal rule of thumb is to *always* try to create transactions
> that 
> describe the real-world events, in the same order they occurred. That
> keeps me out of trouble trying to finagle something weird just to
> make 
> the math work. The math will work if I enter what really happened.
> 
> 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
> 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.
___
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.


Re: [GNC] Best way to close unpaid invoices?

2021-03-10 Thread Adrien Monteleone

On 3/9/21 12:21 PM, Daffy Duck wrote:

Ok, I think I have it working now.

So, the better way to look at the discounted situation in my case was
"renegotiated accounts" because I want to pay expenses prior to income.


Not sure I'm following here. Let's take this one step at a time.

First, I thought you had two separate cases: 1) a bad debt, 2) a 
discount you wanted to offer after issuing an invoice. Is this not 
correct? (the AFDA account is for case #1, the Credit Note is for case #2)


Second, What do your own expenses, and when you pay them, have to do 
with giving a discount to a customer after you've invoiced them?



So, I created a new asset account called "renegotiated accounts" and
paid the outstanding invoices for this individual from that.

I then created a new invoice for the new amount, separating reimbursed
expenses from income.  On the new invoice, the transfer account is
"renegotiated accounts."


This is starting to sound more complicated than the initial post. That's 
fine, but please be clear about what you are trying to accomplish.


What do reimbursed expenses have to do with the discount situation?

-

My personal rule of thumb is to *always* try to create transactions that 
describe the real-world events, in the same order they occurred. That 
keeps me out of trouble trying to finagle something weird just to make 
the math work. The math will work if I enter what really happened.


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


Re: [GNC] Best way to close unpaid invoices?

2021-03-09 Thread Daffy Duck
Ok, I think I have it working now.

So, the better way to look at the discounted situation in my case was
"renegotiated accounts" because I want to pay expenses prior to income.

So, I created a new asset account called "renegotiated accounts" and
paid the outstanding invoices for this individual from that.

I then created a new invoice for the new amount, separating reimbursed
expenses from income.  On the new invoice, the transfer account is
"renegotiated accounts."

I had a separate account under expense for "Loss from renegotiated
accounts" to mimic what we did with the bad debts one, but that doesn't
seem to work?   

I then posted a payment to the new invoice that I received. 

Is this the best way to do this?

On Mon, 2021-03-08 at 22:14 -0600, Adrien Monteleone wrote:
> Apologies. AFDA will have to go somewhere else under Assets then. It 
> should show up after moving it.
> 
> Regards,
> Adrien
> 
> On 3/8/21 9:05 PM, Daffy Duck wrote:
> > Ok, maybe that is the issue.
> > 
> > AFDA is not listed under transfer accounts.  Both AR and AFDA are
> > not
> > listed.
> 
> ___
> 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.
___
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.


Re: [GNC] Best way to close unpaid invoices?

2021-03-08 Thread Adrien Monteleone
Apologies. AFDA will have to go somewhere else under Assets then. It 
should show up after moving it.


Regards,
Adrien

On 3/8/21 9:05 PM, Daffy Duck wrote:

Ok, maybe that is the issue.

AFDA is not listed under transfer accounts.  Both AR and AFDA are not
listed.


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


Re: [GNC] Best way to close unpaid invoices?

2021-03-08 Thread Daffy Duck
Ok, maybe that is the issue.

AFDA is not listed under transfer accounts.  Both AR and AFDA are not
listed.

?

On Mon, 2021-03-08 at 20:55 -0600, Adrien Monteleone wrote:
> Sorry if I wasn't clear.
> 
> At first, there should be no transactions in that account.
> 
> Go to Business > Customer > Process Payment.
> 
> Enter the customer in the search field at the top.
> 
> You'll see the invoice that you need to close out, select it.
> 
> Put in the appropriate date, and the amount you are charging off to
> Bad 
> Debts. (eventually)
> 
> Select the Allowance for Doubtful Accounts (AFDA) account as the 
> Transfer Account.
> 
> Put a memo if you like.
> 
> Then save the 'payment'.
> 
> After that is done, the invoice will be closed out as 'paid' by AFDA.
> 
> This then needs to be expensed, so in AFDA enter a transaction for
> the 
> same amount as the 'payment' but this time between AFDA and
> Expenses:Bad 
> Debts.
> 
> Not sure if you are using formal labels or not, but the result of the
> payment will be:
> 
> Dr. Allowance for Doubtful Accounts (left column)
> Cr. Accounts Receivable (right column)
> 
> The charge off will be:
> 
> Dr. Expenses:Bad Debts (left column)
> Cr. Allowance for Doubtful Accounts (right column)
> 
> AFDA will now be zero.
> 
> Normally, this account is populated at the beginning of an accounting
> period with a reasonable estimate of what you won't collect. It is
> then 
> converted to charged off expense at the end of that period, or
> monthly, 
> whichever you need or works for you.
> 
> Of course, you can make specific adjustments like this one as needed.
> 
> 
> Regards,
> Adrien
> 
> On 3/8/21 8:25 PM, Daffy Duck wrote:
> > Hi,
> > 
> > Thanks.
> > 
> > "For Bad Debts, set up an account called "Allowance for Doubtful
> > > Accounts" as a child of AR. (be sure to make this of type
> > > 'Asset')
> > > 
> > > You can then 'pay' the invoice using this account as the source.
> > > 
> > > This will cause the invoice to be closed by GnuCash and it will
> > > be
> > > removed from the Due Invoices Reminder."
> > 
> > This does not work.  I created an asset account under "Accounts
> > receivable" and I put the entry in for the $500, an increase.
> > 
> > I then tried to assign it as a payment to the invoice.  It said
> > "you
> > must select a transfer account from the account tree."
> 
> ___
> 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.
___
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.


Re: [GNC] Best way to close unpaid invoices?

2021-03-08 Thread Adrien Monteleone

Sorry if I wasn't clear.

At first, there should be no transactions in that account.

Go to Business > Customer > Process Payment.

Enter the customer in the search field at the top.

You'll see the invoice that you need to close out, select it.

Put in the appropriate date, and the amount you are charging off to Bad 
Debts. (eventually)


Select the Allowance for Doubtful Accounts (AFDA) account as the 
Transfer Account.


Put a memo if you like.

Then save the 'payment'.

After that is done, the invoice will be closed out as 'paid' by AFDA.

This then needs to be expensed, so in AFDA enter a transaction for the 
same amount as the 'payment' but this time between AFDA and Expenses:Bad 
Debts.


Not sure if you are using formal labels or not, but the result of the 
payment will be:


Dr. Allowance for Doubtful Accounts (left column)
Cr. Accounts Receivable (right column)

The charge off will be:

Dr. Expenses:Bad Debts (left column)
Cr. Allowance for Doubtful Accounts (right column)

AFDA will now be zero.

Normally, this account is populated at the beginning of an accounting 
period with a reasonable estimate of what you won't collect. It is then 
converted to charged off expense at the end of that period, or monthly, 
whichever you need or works for you.


Of course, you can make specific adjustments like this one as needed.


Regards,
Adrien

On 3/8/21 8:25 PM, Daffy Duck wrote:

Hi,

Thanks.

"For Bad Debts, set up an account called "Allowance for Doubtful

Accounts" as a child of AR. (be sure to make this of type 'Asset')

You can then 'pay' the invoice using this account as the source.

This will cause the invoice to be closed by GnuCash and it will be
removed from the Due Invoices Reminder."


This does not work.  I created an asset account under "Accounts
receivable" and I put the entry in for the $500, an increase.

I then tried to assign it as a payment to the invoice.  It said "you
must select a transfer account from the account tree."


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


Re: [GNC] Best way to close unpaid invoices?

2021-03-08 Thread Daffy Duck
Hi,

Thanks.  

"For Bad Debts, set up an account called "Allowance for Doubtful 
> Accounts" as a child of AR. (be sure to make this of type 'Asset')
> 
> You can then 'pay' the invoice using this account as the source.
> 
> This will cause the invoice to be closed by GnuCash and it will be 
> removed from the Due Invoices Reminder."

This does not work.  I created an asset account under "Accounts
receivable" and I put the entry in for the $500, an increase.

I then tried to assign it as a payment to the invoice.  It said "you
must select a transfer account from the account tree."



On Mon, 2021-03-08 at 09:50 -0600, Adrien Monteleone wrote:
> *note* none of the below is accounting or tax advice, but how to use 
> GnuCash to accomplish the goal of 'clearing' the invoices while 
> following general accounting practices.
> 
> Here's how to handle both using the Business Features so GnuCash
> sorts 
> everything properly and can 'see' what you are doing.
> 
> -
> For Bad Debts, set up an account called "Allowance for Doubtful 
> Accounts" as a child of AR. (be sure to make this of type 'Asset')
> 
> You can then 'pay' the invoice using this account as the source.
> 
> This will cause the invoice to be closed by GnuCash and it will be 
> removed from the Due Invoices Reminder.
> 
> Then make a manual entry zeroing out this amount between Allowance
> for 
> Doubtful Accounts and Expenses:Bad Debts account.
> 
> -
> For the reduced invoice, you can either edit the original after 
> un-posting and adding in the eventually issued discount and re-
> posting. 
> (which of course, alters the original amount, but you see the
> discount 
> so you can figure out what it was if needed)
> 
> *or*
> 
> You can issue a credit note for the discount and link it with the 
> invoice when recording as a payment. (thus offsetting the original 
> balance) That way, both the credit note and the original will
> disappear 
> from the Invoices Due Reminder as they are now both 'closed'
> entirely. 
> Personally, I like this method as it preserves everything as
> originally 
> done, rather than making edits.
> 
> Regards,
> Adrien
> 
> On 3/6/21 10:35 PM, Daffy Duck wrote:
> > Hello,
> > 
> > I have some clients that, for whatever reason, I didn't finish work
> > for
> > because something happened, so we ended the transaction without the
> > full payment.
> > 
> > They continue popping up on invoice reminder, etc.
> > 
> > I have another client who I have agreed to settle for a lesser
> > price
> > than that which was billed.
> > 
> > In these cases, how do "close" the invoice but still have the
> > ability
> > to see the details if you ever have to?  What is the recommended
> > way to
> > do this?
> 
> ___
> 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.
___
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.


Re: [GNC] Best way to close unpaid invoices?

2021-03-08 Thread Daffy Duck
The issue is, this solution does not have a relationship to the
invoice.  As such, the invoice still pops up in invoices due reminder.

On Sun, 2021-03-07 at 21:06 -0800, Keith Fetterman wrote:
> I recall the original question was how to make the open invoices
> disappear from the “Due Invoices Reminder” dialog.  Based on the
> explanation below, do the open invoices still appear in the dialog? 
> If so, how does one make them disappear? 
> 
> 
> > 
> > 
> > --
> > 
> > Message: 7
> > Date: Sun, 7 Mar 2021 16:53:56 -0600 (CST)
> > From: David Cousens 
> > To: gnucash-user@gnucash.org
> > Subject: Re: [GNC] Best way to close unpaid invoices?
> > Message-ID: <1615157636594-0.p...@n4.nabble.com>
> > Content-Type: text/plain; charset=us-ascii
> > 
> > There is no need to zero out the invoice. It remains as it
> > originally was and
> > the debt remains on the books.  What the debt write off does is
> > correct your
> > income for the amount of income you expected to but didn't receive
> > and
> > adjusts the accounts receivable to reflect that you do not expect
> > to receive
> > that income. 
> > 
> > If you cancel out the invoice and at some future time the client
> > coughs up
> > the money, you will have no way of accounting for how that money
> > was
> > received but a simple adjustment allows you to reverse the bad debt
> > write
> > off and then record the payment against the original invoice.   
> > 
> > When you make a payment against an invoice normally, you do not
> > change the
> > amount of the invoice, itself but you increase the amount of an
> > asset(bank
> > account) and decrease the amount of the Accounts receivable (also
> > an asset )
> > by the same amount.
> > 
> > The invoice creates an increase in an income account  and an
> > increase in the
> > Accounts receivable when it is posted to you accounts. In the case
> > of a bad
> > debt you do not adjust the income but an expense account which has
> > the same
> > effect on your profit. Expense accounts can be regarded as contra
> > income
> > accounts.
> > 
> > This way your accounts contain a record of the events as they
> > affected your
> > finances at the time the events occurred. If they are annotated
> > well enough
> > anyone can reconstruct the sequence of events as recorded
> > 
> > David Cousens
> > 
> > 
> > 
> > -
> > David Cousens
> > --
> > Sent from:
> > http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> > 
> > 
> > --
> > 
> > Subject: Digest Footer
> > 
> > ___
> > 
> > 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.
> > 
> > 
> > --
> > 
> > End of gnucash-user Digest, Vol 216, Issue 17
> > *
> 
> ___
> 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.
___
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.


Re: [GNC] Best way to close unpaid invoices?

2021-03-08 Thread Alan Hopkins
Fair comment Adrien.

On Tue, 9 Mar. 2021, 2:55 am Adrien Monteleone, <
adrien.montele...@lusfiber.net> wrote:

> You should refrain from making manual entries or edits in AR/AP. It
> isn't that you can't or that anything will blow up, but you may forget
> that the Business Features will not see those edits/transactions where
> you might expect them to.
>
> If you really need to make manual edits/entries, create an 'Other AR/AP'
> account, as a child of the main account, and make sure it is of type
> 'Asset/Liability' and *not* of type 'AR/AP'. (there can be only 1 of
> each of those)
>
> With the method listed below, the Business Features (and their reports)
> 'think' the customer paid when they did not.
>
> See my other reply describing how to close these out properly in GnuCash.
>
> Regards,
> Adrien
>
> On 3/8/21 2:33 AM, Alan Hopkins wrote:
> > Hi all
> > I'm new to GNU Cash but I just tested a method that worked and I
> think
> > is valid.
> > I went to the client's invoice and paid the full amount ($120) which
> > then was entered by GNUCash into the Accounts Receivable.
> > I then went into the Accounts Receivable account, located the
> payment,
> > looked at the Splits (DR $120 Assets:CashOnHand, CR $120 A/R) and
> > changed the splits to be Debit CashOnHand $60 Debit Bad Debts $60
> > Credit Accounts Receivable $120.
> > The invoice is recorded as paid and no longer appears in reminders
> and
> > all the accounts are in the correct state.
> > Maybe that may be of help!
>
> ___
> 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.
>
___
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.


Re: [GNC] Best way to close unpaid invoices?

2021-03-08 Thread Derek Atkins
Adrien,

On Mon, March 8, 2021 10:54 am, Adrien Monteleone wrote:
> You should refrain from making manual entries or edits in AR/AP. It
> isn't that you can't or that anything will blow up, but you may forget
> that the Business Features will not see those edits/transactions where
> you might expect them to.
>
> If you really need to make manual edits/entries, create an 'Other AR/AP'
> account, as a child of the main account, and make sure it is of type
> 'Asset/Liability' and *not* of type 'AR/AP'. (there can be only 1 of
> each of those)
>
> With the method listed below, the Business Features (and their reports)
> 'think' the customer paid when they did not.

I would suggest that the method Alan used below is EXACTLY the RIGHT thing
to do, and indeed it's exactly how I would (and have) handled bad debts in
the past.

Manual adjustment of payment transactions is explicitly allowed, so long
as you don't change the split tied to the AR/AP account.  But changing the
transfer account from Cash to Expenses:Bad Debt, or even splitting the
Cash split like Alan did, is perfectly acceptable.

> See my other reply describing how to close these out properly in GnuCash.

-derek

> Regards,
> Adrien
>
> On 3/8/21 2:33 AM, Alan Hopkins wrote:
>> Hi all
>> I'm new to GNU Cash but I just tested a method that worked and I
>> think
>> is valid.
>> I went to the client's invoice and paid the full amount ($120) which
>> then was entered by GNUCash into the Accounts Receivable.
>> I then went into the Accounts Receivable account, located the
>> payment,
>> looked at the Splits (DR $120 Assets:CashOnHand, CR $120 A/R) and
>> changed the splits to be Debit CashOnHand $60 Debit Bad Debts $60
>> Credit Accounts Receivable $120.
>> The invoice is recorded as paid and no longer appears in reminders
>> and
>> all the accounts are in the correct state.
>> Maybe that may be of help!
>
> ___
> 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.
>


-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
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.


Re: [GNC] Best way to close unpaid invoices?

2021-03-08 Thread Adrien Monteleone
You should refrain from making manual entries or edits in AR/AP. It 
isn't that you can't or that anything will blow up, but you may forget 
that the Business Features will not see those edits/transactions where 
you might expect them to.


If you really need to make manual edits/entries, create an 'Other AR/AP' 
account, as a child of the main account, and make sure it is of type 
'Asset/Liability' and *not* of type 'AR/AP'. (there can be only 1 of 
each of those)


With the method listed below, the Business Features (and their reports) 
'think' the customer paid when they did not.


See my other reply describing how to close these out properly in GnuCash.

Regards,
Adrien

On 3/8/21 2:33 AM, Alan Hopkins wrote:

Hi all
I'm new to GNU Cash but I just tested a method that worked and I think
is valid.
I went to the client's invoice and paid the full amount ($120) which
then was entered by GNUCash into the Accounts Receivable.
I then went into the Accounts Receivable account, located the payment,
looked at the Splits (DR $120 Assets:CashOnHand, CR $120 A/R) and
changed the splits to be Debit CashOnHand $60 Debit Bad Debts $60
Credit Accounts Receivable $120.
The invoice is recorded as paid and no longer appears in reminders and
all the accounts are in the correct state.
Maybe that may be of help!


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


Re: [GNC] Best way to close unpaid invoices?

2021-03-08 Thread Adrien Monteleone
*note* none of the below is accounting or tax advice, but how to use 
GnuCash to accomplish the goal of 'clearing' the invoices while 
following general accounting practices.


Here's how to handle both using the Business Features so GnuCash sorts 
everything properly and can 'see' what you are doing.


-
For Bad Debts, set up an account called "Allowance for Doubtful 
Accounts" as a child of AR. (be sure to make this of type 'Asset')


You can then 'pay' the invoice using this account as the source.

This will cause the invoice to be closed by GnuCash and it will be 
removed from the Due Invoices Reminder.


Then make a manual entry zeroing out this amount between Allowance for 
Doubtful Accounts and Expenses:Bad Debts account.


-
For the reduced invoice, you can either edit the original after 
un-posting and adding in the eventually issued discount and re-posting. 
(which of course, alters the original amount, but you see the discount 
so you can figure out what it was if needed)


*or*

You can issue a credit note for the discount and link it with the 
invoice when recording as a payment. (thus offsetting the original 
balance) That way, both the credit note and the original will disappear 
from the Invoices Due Reminder as they are now both 'closed' entirely. 
Personally, I like this method as it preserves everything as originally 
done, rather than making edits.


Regards,
Adrien

On 3/6/21 10:35 PM, Daffy Duck wrote:

Hello,

I have some clients that, for whatever reason, I didn't finish work for
because something happened, so we ended the transaction without the
full payment.

They continue popping up on invoice reminder, etc.

I have another client who I have agreed to settle for a lesser price
than that which was billed.

In these cases, how do "close" the invoice but still have the ability
to see the details if you ever have to?  What is the recommended way to
do this?


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


Re: [GNC] Best way to close unpaid invoices?

2021-03-08 Thread Christopher Lam
Hi David, nice to see the documented method of writing off bad debts.
However it seems hackish. It would be good to formalise the methods via a
menu item or toolbar button.

Similarly, processing refunds is currently done afaiu via credit notes.
Numerically it's fine, but does it pass the tax audit test?

On Mon, 8 Mar 2021, 11:15 am David Cousens, 
wrote:

> My description of the process has been from an accounting perspective.
>
> According to the Help Manual GnuCash cannot process the write off as a
> payment in the simple manner of a manual transaction entry as I described
> it
> because the accounts in the payment logic are restricted and the use of
> lots
> for processing partial payments complicates the issue.
>
> Section 7.6.3 of the Help manual
> (https://www.gnucash.org/docs/v4/C/gnucash-help/busnss-ar-payment1.html)
> gives a process for writing off a bad debt to a Bad Debt expense account
> which will achieve the desired result within GnuCash which AFAIK is still
> valid.
>
> David
>
>
>
> -
> David Cousens
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> 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.
>
___
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.


Re: [GNC] Best way to close unpaid invoices?

2021-03-08 Thread Alan Hopkins
   Hi all
   I'm new to GNU Cash but I just tested a method that worked and I think
   is valid.
   I went to the client's invoice and paid the full amount ($120) which
   then was entered by GNUCash into the Accounts Receivable.
   I then went into the Accounts Receivable account, located the payment,
   looked at the Splits (DR $120 Assets:CashOnHand, CR $120 A/R) and
   changed the splits to be Debit CashOnHand $60 Debit Bad Debts $60
   Credit Accounts Receivable $120.
   The invoice is recorded as paid and no longer appears in reminders and
   all the accounts are in the correct state.
   Maybe that may be of help!
   Cheers
   Alan

   On 8/3/21 4:06 pm, Keith Fetterman wrote:

I recall the original question was how to make the open invoices disappear from
the “Due Invoices Reminder” dialog.  Based on the explanation below, do the open
 invoices still appear in the dialog?  If so, how does one make them disappear?




--

Message: 7
Date: Sun, 7 Mar 2021 16:53:56 -0600 (CST)
From: David Cousens [1]
To: [2]gnucash-user@gnucash.org
Subject: Re: [GNC] Best way to close unpaid invoices?
Message-ID: [3]<1615157636594-0.p...@n4.nabble.com>
Content-Type: text/plain; charset=us-ascii

There is no need to zero out the invoice. It remains as it originally was and
the debt remains on the books.  What the debt write off does is correct your
income for the amount of income you expected to but didn't receive and
adjusts the accounts receivable to reflect that you do not expect to receive
that income.

If you cancel out the invoice and at some future time the client coughs up
the money, you will have no way of accounting for how that money was
received but a simple adjustment allows you to reverse the bad debt write
off and then record the payment against the original invoice.

When you make a payment against an invoice normally, you do not change the
amount of the invoice, itself but you increase the amount of an asset(bank
account) and decrease the amount of the Accounts receivable (also an asset )
by the same amount.

The invoice creates an increase in an income account  and an increase in the
Accounts receivable when it is posted to you accounts. In the case of a bad
debt you do not adjust the income but an expense account which has the same
effect on your profit. Expense accounts can be regarded as contra income
accounts.

This way your accounts contain a record of the events as they affected your
finances at the time the events occurred. If they are annotated well enough
anyone can reconstruct the sequence of events as recorded

David Cousens



-
David Cousens
--
Sent from: [4]http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html


--

Subject: Digest Footer

___

gnucash-user mailing list
[5]gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
[6]https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see [7]https://wiki.gnucash.org/wiki/Ma
iling_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.


--

End of gnucash-user Digest, Vol 216, Issue 17
*

___
gnucash-user mailing list
[8]gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
[9]https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see [10]https://wiki.gnucash.org/wiki/M
ailing_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.

References

   1. mailto:davidcous...@bigpond.com
   2. mailto:gnucash-user@gnucash.org
   3. mailto:1615157636594-0.p...@n4.nabble.com
   4. http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
   5. mailto:gnucash-user@gnucash.org
   6. https://lists.gnucash.org/mailman/listinfo/gnucash-user
   7. https://wiki.gnucash.org/wiki/Mailing_Lists
   8. mailto:gnucash-user@gnucash.org
   9. https://lists.gnucash.org/mailman/listinfo/gnucash-user
  10. https://wiki.gnucash.org/wiki/Mailing_Lists
___
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.


Re: [GNC] Best way to close unpaid invoices?

2021-03-07 Thread Keith Fetterman
I recall the original question was how to make the open invoices disappear from 
the “Due Invoices Reminder” dialog.  Based on the explanation below, do the 
open invoices still appear in the dialog?  If so, how does one make them 
disappear? 


> 
> 
> --
> 
> Message: 7
> Date: Sun, 7 Mar 2021 16:53:56 -0600 (CST)
> From: David Cousens 
> To: gnucash-user@gnucash.org
> Subject: Re: [GNC] Best way to close unpaid invoices?
> Message-ID: <1615157636594-0.p...@n4.nabble.com>
> Content-Type: text/plain; charset=us-ascii
> 
> There is no need to zero out the invoice. It remains as it originally was and
> the debt remains on the books.  What the debt write off does is correct your
> income for the amount of income you expected to but didn't receive and
> adjusts the accounts receivable to reflect that you do not expect to receive
> that income. 
> 
> If you cancel out the invoice and at some future time the client coughs up
> the money, you will have no way of accounting for how that money was
> received but a simple adjustment allows you to reverse the bad debt write
> off and then record the payment against the original invoice.   
> 
> When you make a payment against an invoice normally, you do not change the
> amount of the invoice, itself but you increase the amount of an asset(bank
> account) and decrease the amount of the Accounts receivable (also an asset )
> by the same amount.
> 
> The invoice creates an increase in an income account  and an increase in the
> Accounts receivable when it is posted to you accounts. In the case of a bad
> debt you do not adjust the income but an expense account which has the same
> effect on your profit. Expense accounts can be regarded as contra income
> accounts.
> 
> This way your accounts contain a record of the events as they affected your
> finances at the time the events occurred. If they are annotated well enough
> anyone can reconstruct the sequence of events as recorded
> 
> David Cousens
> 
> 
> 
> -
> David Cousens
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> 
> 
> --
> 
> Subject: Digest Footer
> 
> ___
> 
> 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.
> 
> 
> --
> 
> End of gnucash-user Digest, Vol 216, Issue 17
> *

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


Re: [GNC] Best way to close unpaid invoices?

2021-03-07 Thread David Cousens
My description of the process has been from an accounting perspective.

According to the Help Manual GnuCash cannot process the write off as a
payment in the simple manner of a manual transaction entry as I described it
because the accounts in the payment logic are restricted and the use of lots
for processing partial payments complicates the issue.

Section 7.6.3 of the Help manual
(https://www.gnucash.org/docs/v4/C/gnucash-help/busnss-ar-payment1.html)
gives a process for writing off a bad debt to a Bad Debt expense account
which will achieve the desired result within GnuCash which AFAIK is still
valid. 

David



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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.


Re: [GNC] Best way to close unpaid invoices?

2021-03-07 Thread Daffy Duck
David,

So if I add an entry in bad debt for

$500 from expense, transfer from assets:accounts receiveable

can I "assign" it to the specific invoice, or no?

On Sun, 2021-03-07 at 19:16 -0600, Daffy Duck wrote:
> David,
> 
> Thank you.  I realized what was happening from an accounting
> perspective, but I was wondering if I can do anything that addresses
> the reference in due invoices reminder?
> 
> On Sun, 2021-03-07 at 16:53 -0600, David Cousens wrote:
> > There is no need to zero out the invoice. It remains as it
> > originally was and
> > the debt remains on the books.  What the debt write off does is
> > correct your
> > income for the amount of income you expected to but didn't receive
> > and
> > adjusts the accounts receivable to reflect that you do not expect
> > to receive
> > that income. 
> > 
> > If you cancel out the invoice and at some future time the client
> > coughs up
> > the money, you will have no way of accounting for how that money
> > was
> > received but a simple adjustment allows you to reverse the bad debt
> > write
> > off and then record the payment against the original invoice.   
> > 
> > When you make a payment against an invoice normally, you do not
> > change the
> > amount of the invoice, itself but you increase the amount of an
> > asset(bank
> > account) and decrease the amount of the Accounts receivable (also
> > an asset )
> > by the same amount.
> > 
> > The invoice creates an increase in an income account  and an
> > increase in the
> > Accounts receivable when it is posted to you accounts. In the case
> > of a bad
> > debt you do not adjust the income but an expense account which has
> > the same
> > effect on your profit. Expense accounts can be regarded as contra
> > income
> > accounts.
> > 
> > This way your accounts contain a record of the events as they
> > affected your
> > finances at the time the events occurred. If they are annotated
> > well enough
> > anyone can reconstruct the sequence of events as recorded
> > 
> > David Cousens
> > 
> > 
> > 
> > -
> > David Cousens
> > --
> > Sent from:
> > http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> > ___
> > 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.
___
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.


Re: [GNC] Best way to close unpaid invoices?

2021-03-07 Thread Daffy Duck
David,

Thank you.  I realized what was happening from an accounting
perspective, but I was wondering if I can do anything that addresses
the reference in due invoices reminder?

On Sun, 2021-03-07 at 16:53 -0600, David Cousens wrote:
> There is no need to zero out the invoice. It remains as it originally
> was and
> the debt remains on the books.  What the debt write off does is
> correct your
> income for the amount of income you expected to but didn't receive
> and
> adjusts the accounts receivable to reflect that you do not expect to
> receive
> that income. 
> 
> If you cancel out the invoice and at some future time the client
> coughs up
> the money, you will have no way of accounting for how that money was
> received but a simple adjustment allows you to reverse the bad debt
> write
> off and then record the payment against the original invoice.   
> 
> When you make a payment against an invoice normally, you do not
> change the
> amount of the invoice, itself but you increase the amount of an
> asset(bank
> account) and decrease the amount of the Accounts receivable (also an
> asset )
> by the same amount.
> 
> The invoice creates an increase in an income account  and an increase
> in the
> Accounts receivable when it is posted to you accounts. In the case of
> a bad
> debt you do not adjust the income but an expense account which has
> the same
> effect on your profit. Expense accounts can be regarded as contra
> income
> accounts.
> 
> This way your accounts contain a record of the events as they
> affected your
> finances at the time the events occurred. If they are annotated well
> enough
> anyone can reconstruct the sequence of events as recorded
> 
> David Cousens
> 
> 
> 
> -
> David Cousens
> --
> Sent from:
> http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> 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.
___
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.


Re: [GNC] Best way to close unpaid invoices?

2021-03-07 Thread David Cousens
There is no need to zero out the invoice. It remains as it originally was and
the debt remains on the books.  What the debt write off does is correct your
income for the amount of income you expected to but didn't receive and
adjusts the accounts receivable to reflect that you do not expect to receive
that income. 

If you cancel out the invoice and at some future time the client coughs up
the money, you will have no way of accounting for how that money was
received but a simple adjustment allows you to reverse the bad debt write
off and then record the payment against the original invoice.   

When you make a payment against an invoice normally, you do not change the
amount of the invoice, itself but you increase the amount of an asset(bank
account) and decrease the amount of the Accounts receivable (also an asset )
by the same amount.

The invoice creates an increase in an income account  and an increase in the
Accounts receivable when it is posted to you accounts. In the case of a bad
debt you do not adjust the income but an expense account which has the same
effect on your profit. Expense accounts can be regarded as contra income
accounts.

This way your accounts contain a record of the events as they affected your
finances at the time the events occurred. If they are annotated well enough
anyone can reconstruct the sequence of events as recorded

David Cousens



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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.


Re: [GNC] Best way to close unpaid invoices?

2021-03-07 Thread Daffy Duck
I'm having a little trouble with this one.

For the "Bad Debts" one, I created expense - bad debts

I then added, in this case, $500(which they owe me $500) under Bad
Debts - expense

I then, to close out the invoice, applied it as payment to the invoice,
but then it switches over to rebate?

I guess that is wrong?  I just want to make sure I zero out the invoice
and have a record of it.

Thanks

On Sat, 2021-03-06 at 23:56 -0600, David Cousens wrote:
> The methodology is a little different for each case.
> 
> Where they have not paid the full amount of the invoice without your
> acquiesence, then you would generally regard the unpaid amount as a
> bad
> debt.  In a direct write off, you would create an "Expense:Bad Debts"
> account and you would credit the Account Receivable account  by the
> amount
> of the write off and debit the Expense:Bad Debts account by the
> amount of
> the write off. Your income is unaltered at the amount recorded on the
> invoice and you are compensated by t the reduction in your Profit (
> and
> hence taxable income) by the amount of the bad debt.  The receivable
> in the
> form of the invoice is still active and you are still legally
> entitled to
> collect on the debt.  If the customer eventually paid you at some
> time
> later, you would create a transaction for the Bad Debt entry between
> Expenses:Bad Debts and Accounts Receivable at the time you receive
> the money
> and record the payments as usual.  Depending on whether your
> accounting is
> on an accrual or cash basis you may need further adjustments.  There
> are a
> number of ways of accounting for bad debts other than a direct write
> off
> where this is a regular feature in your business operations and you
> really
> need accounting advice if you need to implement them. 
> 
> if you agree to reduce the invoice amount, you could unpost the
> invoice,
> alter it appropriately and then repost it. This however does not
> record that
> you have offered the client a discount on the original agreed price.
> 
> An alternative would be to treat it as a discount on the sale. In
> this case,
> you would use a contra account to your :Income:Sales Revenue  account
> i.e.
> "Income:Sales Revenue:Sales Discounts". To record the discount,  you
> would
> credit the Accounts Receivable for the amount of the Discount you are
> applying to the invoice and debit " Income:Sales Revenue:Sales
> Discounts"
> for the amount you are discounting the invoice by. Again the Invoice
> remains
> at its original value and in this case your income is adjusted  by
> the
> amount of the discount.  
> 
> The above are possible accounting treatments. Whether they are
> allowable
> will be jurisdiction dependent and you should seek local accounting
> advice
> as to whether the above approaches or another methodology is
> applicable for
> the reporting arrangements you need to comply with.
> 
> 
> 
> -
> David Cousens
> --
> Sent from:
> http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> 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.
___
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.


Re: [GNC] Best way to close unpaid invoices?

2021-03-07 Thread Daffy Duck
Thanks to you and Ron!

On Sat, 2021-03-06 at 23:56 -0600, David Cousens wrote:
> The methodology is a little different for each case.
> 
> Where they have not paid the full amount of the invoice without your
> acquiesence, then you would generally regard the unpaid amount as a
> bad
> debt.  In a direct write off, you would create an "Expense:Bad Debts"
> account and you would credit the Account Receivable account  by the
> amount
> of the write off and debit the Expense:Bad Debts account by the
> amount of
> the write off. Your income is unaltered at the amount recorded on the
> invoice and you are compensated by t the reduction in your Profit (
> and
> hence taxable income) by the amount of the bad debt.  The receivable
> in the
> form of the invoice is still active and you are still legally
> entitled to
> collect on the debt.  If the customer eventually paid you at some
> time
> later, you would create a transaction for the Bad Debt entry between
> Expenses:Bad Debts and Accounts Receivable at the time you receive
> the money
> and record the payments as usual.  Depending on whether your
> accounting is
> on an accrual or cash basis you may need further adjustments.  There
> are a
> number of ways of accounting for bad debts other than a direct write
> off
> where this is a regular feature in your business operations and you
> really
> need accounting advice if you need to implement them. 
> 
> if you agree to reduce the invoice amount, you could unpost the
> invoice,
> alter it appropriately and then repost it. This however does not
> record that
> you have offered the client a discount on the original agreed price.
> 
> An alternative would be to treat it as a discount on the sale. In
> this case,
> you would use a contra account to your :Income:Sales Revenue  account
> i.e.
> "Income:Sales Revenue:Sales Discounts". To record the discount,  you
> would
> credit the Accounts Receivable for the amount of the Discount you are
> applying to the invoice and debit " Income:Sales Revenue:Sales
> Discounts"
> for the amount you are discounting the invoice by. Again the Invoice
> remains
> at its original value and in this case your income is adjusted  by
> the
> amount of the discount.  
> 
> The above are possible accounting treatments. Whether they are
> allowable
> will be jurisdiction dependent and you should seek local accounting
> advice
> as to whether the above approaches or another methodology is
> applicable for
> the reporting arrangements you need to comply with.
> 
> 
> 
> -
> David Cousens
> --
> Sent from:
> http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> 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.
___
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.


Re: [GNC] Best way to close unpaid invoices?

2021-03-06 Thread David Cousens
The methodology is a little different for each case.

Where they have not paid the full amount of the invoice without your
acquiesence, then you would generally regard the unpaid amount as a bad
debt.  In a direct write off, you would create an "Expense:Bad Debts"
account and you would credit the Account Receivable account  by the amount
of the write off and debit the Expense:Bad Debts account by the amount of
the write off. Your income is unaltered at the amount recorded on the
invoice and you are compensated by t the reduction in your Profit ( and
hence taxable income) by the amount of the bad debt.  The receivable in the
form of the invoice is still active and you are still legally entitled to
collect on the debt.  If the customer eventually paid you at some time
later, you would create a transaction for the Bad Debt entry between
Expenses:Bad Debts and Accounts Receivable at the time you receive the money
and record the payments as usual.  Depending on whether your accounting is
on an accrual or cash basis you may need further adjustments.  There are a
number of ways of accounting for bad debts other than a direct write off
where this is a regular feature in your business operations and you really
need accounting advice if you need to implement them. 

if you agree to reduce the invoice amount, you could unpost the invoice,
alter it appropriately and then repost it. This however does not record that
you have offered the client a discount on the original agreed price.

An alternative would be to treat it as a discount on the sale. In this case,
you would use a contra account to your :Income:Sales Revenue  account i.e.
"Income:Sales Revenue:Sales Discounts". To record the discount,  you would
credit the Accounts Receivable for the amount of the Discount you are
applying to the invoice and debit " Income:Sales Revenue:Sales Discounts"
for the amount you are discounting the invoice by. Again the Invoice remains
at its original value and in this case your income is adjusted  by the
amount of the discount.  

The above are possible accounting treatments. Whether they are allowable
will be jurisdiction dependent and you should seek local accounting advice
as to whether the above approaches or another methodology is applicable for
the reporting arrangements you need to comply with.



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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.