Re: [GNC] A question on loans

[Mark Phillips]

David,

Thanks for your emails and explanations. What I am really looking for, is
how to do this transaction:

Increase the loan amount by $30,000 to bring it to the current value.

I don't know where to put the offsetting entry for the $30,000. It does not
go into checking, as I don't have a windfall of $30K in the checking
account or against the Condo asset, nor in an expense account. So where
does it go?

Mark

On Wed, Nov 20, 2019 at 3:45 PM David Cousens 
wrote:

> Mark,
>
> My apologies , I thought your question referred to recording the current
> value of your property. If your accountant is getting the bank statements,
> to catch your personal copy of the accounts up you will need to obtain
> copies of the bank statements either from him or the bank, if you do not
> have them already.
>
> Your bank may alsooffer  online access to records or offer a download of
> records in OFX or a similar format (my bank provides this facility for the
> past 7 years) in which case you can import the OFX files and then reconcile
> them against your statements (I have had errors on importing on rare
> occasions - transactions may be duplicated in the records for your bank
> account and loan account for example and imported twice although GNuCash
> will try to identify duplicates) which is quicker than entering them by
> hand
> from the statements.
>
> GnuCash has a number of import data formats ( see the GnuCash Tutoria and
> Concepts Guide
> (https://www.gnucash.org/docs/v3/C/gnucash-guide/chapter_importing.html)
> or
> the Help manual
> https://www.gnucash.org/docs/v3/C/gnucash-help/trans-import.html. There is
> currently a lot of duplication here as the material in the Guide has been
> largely already beenmoved to the Help manual and I am in the process of
> rewriting the Guide section as import examples. I have found OFX to be the
> most relaible as it has a fairly tight standard and CSV to be more
> problematical because it has no real standard. QIF is generally OK as
> well.
> In most cases start with small data sets (e.g month) first to sort out any
> importing difficulties and train the import matcher then increase the
> dataset size once you have it working reliably.
>
> Another possibility is that your accountant (for a fee of course) may be
> able to provide you with exported transactions from his records if he has
> entered them digitally.
>
> 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] A question on loans

[Mark Phillips]

A PS to my last email about the mortgage accounts. My gnucash accounts are
for my financial tracking purposes only. My accountant gets bank statements
and other original documents for tax purposes. He has nothing to do with my
gnucash accounts, and is not interested in seeing them.

Just in case my earlier email sounded like I was laundering money or doing
something to cheat the IRS! Or, maybe I have been watching too many
episodes of the Black List

Mark

On Wed, Nov 20, 2019 at 11:08 AM Mark Phillips 
wrote:

> My apologies, I did a very poor job of asking my question the first time.
> Let me try again.
>
> My accounts (with simplified names)
> Asset - Condo and Checking
> Liability - Mortgage
> Expenses - Mortgage Interest
>
> I set up the accounts when I bought the condo a few years ago, made a few
> entries for mortgage payments, then stopped. Time passed, the loan changed
> banks to a line of credit, and some charges were made to the line of credit
> for some non-condo related debt consolidation.
>
> Time passed, and now I would like to get these accounts caught up. There
> is a $30,000 difference between the current Mortgage balance (larger) and
> what is in gnucash. How do I make an entry to get the Mortgage account to
> match the bank statement?
>
> Thanks, and my apologies for sending a poorly written question in
> the first place.
>
> Mark
>
> On Wed, Nov 20, 2019 at 10:02 AM Tommy Trussell 
> wrote:
>
>> On Wed, Nov 20, 2019 at 9:28 AM Mark Phillips 
>> wrote:
>>
>>> I have a rental property, and I am just setting it up in gnu cash. The
>>> property has an existing loan. I have paid down some of the loan, but am
>>> still making payments. How do I set up the accounts so I reflect the
>>> purchase price of the condo correctly, and also show the current correct
>>> loan balance?
>>>
>>> Thanks!
>>>
>>> Mark
>>>
>>
>> Have you yet read Chapter 8 of the GnuCash Tutorial and Concepts Guide?
>> It's available here:
>>
>> https://www.gnucash.org/docs.phtml
>>
>>
>>
>>
>>> -
>>> 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] A question on loans

[Mark Phillips]

My apologies, I did a very poor job of asking my question the first time.
Let me try again.

My accounts (with simplified names)
Asset - Condo and Checking
Liability - Mortgage
Expenses - Mortgage Interest

I set up the accounts when I bought the condo a few years ago, made a few
entries for mortgage payments, then stopped. Time passed, the loan changed
banks to a line of credit, and some charges were made to the line of credit
for some non-condo related debt consolidation.

Time passed, and now I would like to get these accounts caught up. There is
a $30,000 difference between the current Mortgage balance (larger) and what
is in gnucash. How do I make an entry to get the Mortgage account to match
the bank statement?

Thanks, and my apologies for sending a poorly written question in the first
place.

Mark

On Wed, Nov 20, 2019 at 10:02 AM Tommy Trussell 
wrote:

> On Wed, Nov 20, 2019 at 9:28 AM Mark Phillips 
> wrote:
>
>> I have a rental property, and I am just setting it up in gnu cash. The
>> property has an existing loan. I have paid down some of the loan, but am
>> still making payments. How do I set up the accounts so I reflect the
>> purchase price of the condo correctly, and also show the current correct
>> loan balance?
>>
>> Thanks!
>>
>> Mark
>>
>
> Have you yet read Chapter 8 of the GnuCash Tutorial and Concepts Guide?
> It's available here:
>
> https://www.gnucash.org/docs.phtml
>
>
>
>
>> -
>> 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] Bank Reconciliation Report with Beginning and Ending Balances

[Mark Phillips]

Kate,

Are you trying to reconcile your account? If so, then select your account
tab and go to Actions -> Reconcile for an interactive account
reconciliation process for your account.

If you want a report post-reconciliation of your account, I normally use
Reports -> Transactions, then use the report configuration options to
define what I want in the report.

Sorry to be shooting in the dark for your answer. Your images did not come
through.

Mark

On Fri, Jan 11, 2019 at 12:11 PM eNews  wrote:

> I have run the reconciliation report for my checking account; however, it
> only shows the "funds in" and the "funds out" for the period.  I was hoping
> for a more traditional reconciliation that shows the ending balance that I
> can agree to my bank statement. If this can be done, how do I do it?  [I am
> using Windows 10 Home, Version 1803; GnuCash Version 3.2, Build ID: 3.2+
> (2018-06-24)]
>
>
>
> My comments are marked as:
>
>
>
>
>
>
>
>
>
> I searched for an existing string of comments on this matter and did not
> find any.  If it has already been discussed, perhaps you could explain how
> I
> could find it on my own.
>
>
>
> Thank you,
>
> Kate
>
>
>
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
> ___
> 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.

[GNC] How do I enter a transaction with an account not in the Gnucash ledger?

[Mark Phillips]

How do I enter the following transaction in gnucash?

I have a business checking account and a personal checking account. My
Gnucash file only tracks the business checking account. Occasionally, I
grab the wrong debit card from my wallet to pay for a business expense.

For example, let's say I use my personal debit card to pay $100 of business
expenses. For this example let's say I bought $100 of nuts and bolts (since
I feel like a nut not being able to work this out). How do I enter this
transaction into my business Gnucash ledger to account for (1) transferring
money out of my business checking to reimburse my personal checking and (2)
record the expense in the appropriate business account?

Thanks!

Mark

PS The good news is I have only done this twice since 2015!
___
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] Reconciliation Question

[Mark Phillips]

OK, I figured out how to reconcile the accounts. The account had no
activity in August 2018, so I just reconciled August so the starting
balance would be correct. I checked the three outstanding amounts, and it
reconciled.

Thanks for everyone's help!

Mark

On Sat, Sep 8, 2018 at 6:48 PM, Mark Phillips 
wrote:

> David,
>
> I found the transactions because I was looking for them for another reason
> unrelated to the reconciliation. I am sorry I went looking for them!
>
> Mark
>
> On Sat, Sep 8, 2018 at 6:47 PM, Mark Phillips 
> wrote:
>
>> David,
>>
>> It didn't work. I entered the transactions for the correct date, and
>> tried to reconcile the account. However, the starting balance was wrong, so
>> the account would not reconcile. For some reason when I entered the
>> statement date (far in the past for the month I entered the transactions),
>> the starting balance did not change to the starting balance for that time
>> period. It is the starting balance for the current period. I continued with
>> the reconciliation and checked off the three transactions, but the account
>> won't balance because the starting balance is wrong.
>>
>> Any suggestions?
>>
>> Thanks!
>>
>> Mark
>>
>> On Thu, Sep 6, 2018 at 12:46 PM, David T.  wrote:
>>
>>> Assuming that everything else is reconciled,  all you really need to do
>>> is add the missing transactions and re-reconcile. Ignore the starting
>>> balance, and enter the same closing balance as your last statement.  Those
>>> three items will appear in the reconciliation window,  you check them off,
>>> and everything is back. Nothing too difficult.
>>>
>>> David
>>>
>>> P.S. how in goodness did you discover that you were missing three
>>> transactions from 2015 that all balanced out?
>>>
>>>
>>>
>>> On Thu, Sep 6, 2018 at 15:37, David Carlson
>>>  wrote:
>>> Mark,
>>>
>>> I suggest trying your proposed fix on a test copy of your datafile.  You
>>> may find that you also need to re-reconcile other months or "indulge" in
>>> some creative temporary offsetting transactions to get August or
>>> September
>>> reconciliations to end with the correct ending balance.  I have not tried
>>> that sort of thing in a couple of years, so my experience is very stale.
>>>
>>> Starting balances do not need to match your statements, as there is no
>>> way
>>> to view which month any particular transaction was actually reconciled
>>> to.
>>>
>>> David C
>>>
>>> On Thu, Sep 6, 2018 at 11:57 AM Mark Phillips <
>>> m...@phillipsmarketing.biz>
>>> wrote:
>>>
>>> > I was reconciling my bank statement for August 2018 the other day, and
>>> > everything balanced. Yeah!!
>>> >
>>> > However, I also discovered that three transactions were inadvertently
>>> > deleted from October 2015 - two debits and one credit. Everything
>>> balances
>>> > because magically, the sum of the debits equals the credit for these
>>> three
>>> > deleted transactions.
>>> >
>>> > I assume to fix the problem,
>>> >
>>> > (1) I would re-enter the transactions, and then
>>> > (2) re-reconcile October 2015,
>>> >
>>> > and that would be it.
>>> >
>>> > I wanted to check with those more experienced in GnuCash to make sure
>>> I am
>>> > not missing an important step to get these transactions back into
>>> GnuCash
>>> > with the satisfying little "y" in the Reconciled column.
>>> >
>>> > Thanks!
>>> >
>>> > Mark
>>> > ___
>>> > 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.
>>>
>>>
>>
>
___
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] Reconciliation Question

[Mark Phillips]

David,

I found the transactions because I was looking for them for another reason
unrelated to the reconciliation. I am sorry I went looking for them!

Mark

On Sat, Sep 8, 2018 at 6:47 PM, Mark Phillips 
wrote:

> David,
>
> It didn't work. I entered the transactions for the correct date, and tried
> to reconcile the account. However, the starting balance was wrong, so the
> account would not reconcile. For some reason when I entered the statement
> date (far in the past for the month I entered the transactions), the
> starting balance did not change to the starting balance for that time
> period. It is the starting balance for the current period. I continued with
> the reconciliation and checked off the three transactions, but the account
> won't balance because the starting balance is wrong.
>
> Any suggestions?
>
> Thanks!
>
> Mark
>
> On Thu, Sep 6, 2018 at 12:46 PM, David T.  wrote:
>
>> Assuming that everything else is reconciled,  all you really need to do
>> is add the missing transactions and re-reconcile. Ignore the starting
>> balance, and enter the same closing balance as your last statement.  Those
>> three items will appear in the reconciliation window,  you check them off,
>> and everything is back. Nothing too difficult.
>>
>> David
>>
>> P.S. how in goodness did you discover that you were missing three
>> transactions from 2015 that all balanced out?
>>
>>
>>
>> On Thu, Sep 6, 2018 at 15:37, David Carlson
>>  wrote:
>> Mark,
>>
>> I suggest trying your proposed fix on a test copy of your datafile.  You
>> may find that you also need to re-reconcile other months or "indulge" in
>> some creative temporary offsetting transactions to get August or September
>> reconciliations to end with the correct ending balance.  I have not tried
>> that sort of thing in a couple of years, so my experience is very stale.
>>
>> Starting balances do not need to match your statements, as there is no way
>> to view which month any particular transaction was actually reconciled to.
>>
>> David C
>>
>> On Thu, Sep 6, 2018 at 11:57 AM Mark Phillips > >
>> wrote:
>>
>> > I was reconciling my bank statement for August 2018 the other day, and
>> > everything balanced. Yeah!!
>> >
>> > However, I also discovered that three transactions were inadvertently
>> > deleted from October 2015 - two debits and one credit. Everything
>> balances
>> > because magically, the sum of the debits equals the credit for these
>> three
>> > deleted transactions.
>> >
>> > I assume to fix the problem,
>> >
>> > (1) I would re-enter the transactions, and then
>> > (2) re-reconcile October 2015,
>> >
>> > and that would be it.
>> >
>> > I wanted to check with those more experienced in GnuCash to make sure I
>> am
>> > not missing an important step to get these transactions back into
>> GnuCash
>> > with the satisfying little "y" in the Reconciled column.
>> >
>> > Thanks!
>> >
>> > Mark
>> > ___
>> > 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.
>>
>>
>
___
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] Reconciliation Question

[Mark Phillips]

David,

It didn't work. I entered the transactions for the correct date, and tried
to reconcile the account. However, the starting balance was wrong, so the
account would not reconcile. For some reason when I entered the statement
date (far in the past for the month I entered the transactions), the
starting balance did not change to the starting balance for that time
period. It is the starting balance for the current period. I continued with
the reconciliation and checked off the three transactions, but the account
won't balance because the starting balance is wrong.

Any suggestions?

Thanks!

Mark

On Thu, Sep 6, 2018 at 12:46 PM, David T.  wrote:

> Assuming that everything else is reconciled,  all you really need to do is
> add the missing transactions and re-reconcile. Ignore the starting balance,
> and enter the same closing balance as your last statement.  Those three
> items will appear in the reconciliation window,  you check them off,  and
> everything is back. Nothing too difficult.
>
> David
>
> P.S. how in goodness did you discover that you were missing three
> transactions from 2015 that all balanced out?
>
>
>
> On Thu, Sep 6, 2018 at 15:37, David Carlson
>  wrote:
> Mark,
>
> I suggest trying your proposed fix on a test copy of your datafile.  You
> may find that you also need to re-reconcile other months or "indulge" in
> some creative temporary offsetting transactions to get August or September
> reconciliations to end with the correct ending balance.  I have not tried
> that sort of thing in a couple of years, so my experience is very stale.
>
> Starting balances do not need to match your statements, as there is no way
> to view which month any particular transaction was actually reconciled to.
>
> David C
>
> On Thu, Sep 6, 2018 at 11:57 AM Mark Phillips 
> wrote:
>
> > I was reconciling my bank statement for August 2018 the other day, and
> > everything balanced. Yeah!!
> >
> > However, I also discovered that three transactions were inadvertently
> > deleted from October 2015 - two debits and one credit. Everything
> balances
> > because magically, the sum of the debits equals the credit for these
> three
> > deleted transactions.
> >
> > I assume to fix the problem,
> >
> > (1) I would re-enter the transactions, and then
> > (2) re-reconcile October 2015,
> >
> > and that would be it.
> >
> > I wanted to check with those more experienced in GnuCash to make sure I
> am
> > not missing an important step to get these transactions back into GnuCash
> > with the satisfying little "y" in the Reconciled column.
> >
> > Thanks!
> >
> > Mark
> > ___
> > 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.
>
>
___
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.

[GNC] Reconciliation Question

[Mark Phillips]

I was reconciling my bank statement for August 2018 the other day, and
everything balanced. Yeah!!

However, I also discovered that three transactions were inadvertently
deleted from October 2015 - two debits and one credit. Everything balances
because magically, the sum of the debits equals the credit for these three
deleted transactions.

I assume to fix the problem,

(1) I would re-enter the transactions, and then
(2) re-reconcile October 2015,

and that would be it.

I wanted to check with those more experienced in GnuCash to make sure I am
not missing an important step to get these transactions back into GnuCash
with the satisfying little "y" in the Reconciled column.

Thanks!

Mark
___
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: What's the best way to model "in-flight" transactions?

[Mark Phillips]

One way to think about the float is to, well, not think about it. When you
pay you credit card company with bill pay, those funds are "gone" in the
sense you really should not use them for another transaction. So, enter the
transaction as you have been doing. Your gnucash bank balance will be
correct, as you have earmarked those credit card funds for the credit card
payment. When you reconcile your bank account, those funds will either be
gone or not, it doesn't matter, as your gnucash balance will still reflect
the correct amount of disposable cash in your bank account.

Mark

On Sep 28, 2017 7:17 AM, "David Carlson" 
wrote:

> I think the answer is "What works best for you."
>
> When most of our bank account transactions were checks (cheques in many
> countries) we entered each check by date and number in the checkbook
> register.  When the bank statement came we compared it to our register,
> checking off each one that appeared on the statement.  Then we made a list
> of the checks (and deposits) that did not match the bank statement, added
> them up and compared sum of those and the statement balance to our
> checkbook register balance.  Since we did it all by hand, there were months
> when we would tear our hair out trying to find out why they did not agree.
>
> I personally use a pair of special accounts that I call Checking A-R and
> Checking A-P to hold items that are in float, but I only use them when I
> want to account for float, say, over the transition from month to month, or
> when there is an unusual issue with a missing check or whatever as each
> transaction gets entered twice.
>
> I only consider doing this for bank accounts, credit card accounts, and
> sometimes for medical bills if I am trying to track what I owe there.
>
> David C
>
> On Thu, Sep 28, 2017 at 7:39 AM, replicon  wrote:
>
> > Hey all,
> >
> > I've been using/loving GNUCash for almost a year now, and one thing I'm
> > sure
> > I'm doing wrong is how I'm showing credit card payments.
> >
> > For paying credit card bills, I just use my bank's bill pay. The bank is
> > different from the credit card provider, so there's some "in-flight" time
> > for that money. The day the withdrawal shows up on my checking account is
> > not the same as the day the payment shows up when I login to my credit
> card
> > provider and check transactions there.
> >
> > Right now, in GNUCash, I just do a transaction from checking account to
> > credit card, and by convention, always adjust the time to reflect
> checking
> > account, but I wonder if there's a more correct way to do it.
> >
> > The best I can think of is to have a separate account for "in-flight"
> > transactions between establishments, and turn the credit card payment
> into
> > two transactions that go through this account. Is that the best way to do
> > it? If so, what account type would that be? Would it be an asset, because
> > in
> > a way, it's like I'm loaning money to some imaginary entity for a while,
> > which it will repay to my other account a day or two later? :)
> >
> > Thanks!
> >
> >
> >
> > --
> > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-
> f1415819.html
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Is there a way to set an account's beginning balance AFTER having created it in GnuCash?

[Mark Phillips]

Just open the account tab and change the opening balance entry - the one at
the top.

Mark

On Thu, Jul 27, 2017 at 1:33 PM,  wrote:

> I’ve searched the help and can’t find anything that addresses this
> question.
>
> Thanks!
>
> Bob
>
> Sent from Mail for Windows 10
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: accounting for estate?

[Mark Phillips]

Jay,

There is no gnucash organized template for estate accounting. With that
said, gnucash is a general purpose accounting tool, so it is well suited to
estate accounting. I have used to to keep a set of books for an estate
where i was the executor. However, the annual accounting report required by
my attorney, and so I assume the courts in the US, are not available as a
template for gnucash. Instead, I exported the transactions from the
relevant accounts and used a spreadsheet to create the report in the
correct format.

If you are truly an accounting noob, then I strongly suggest you get some
professional help for the estate accounting. I don't know how large the
estate is, or what country you are in, but in the US the executor has a
fiduciary responsibility to the beneficiaries for all the
money/assets/liabilities in the estate. Any mistakes, and you can be sued
and or go to jail. Money can make even the closest of familys fight - and
fighting in court is nothing but a waste of your estate's money. The small
cost of a professional book keeper/accountant who can keep the books and
create the annual report for the estate is peanuts compared to the time you
will need to invest in learning to be the estate accountant.

Good luck!

Mark

On Mon, Jun 26, 2017 at 8:14 AM,  wrote:

> hello...
>
> new to this list...  & total noob regarding accounting & gnucash
> software...
>
> am pretty sure there must be some sort of organised template out there
> to make job as estate executor "easy" & am making a plea for help in its
> locating...
>
> any help rcv'd gratefully & ALL advice appreciated...
>
> jay c
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Reconciling an account

[Mark Phillips]

Is your opening balance for this account correct?

Mark

On Tue, Jun 6, 2017 at 2:20 PM, EngineInstitute 
wrote:

> Yes I tried the manual way using the transaction report to check against
> both
> the Gnu reconciliation as well as the statement.  Nothing is obvious.
> I also checked by applying the filter without the reconciled items and what
> came up are the items in the to be reconciled in the reconcile register.
> Finally I also did a global search for $195.14 and $97.57 no entries of
> those amounts.
> I thought I would upload images so it is easier to discuss.
> As you can see the dialog shows what it expects as the final amount:
> $5265.69 (my statement balance)
> The next is the reconcile page that shows the reconciled balance with a
> difference of $97.57 (there are no outstanding items past 3/11).
> After reconciling the totals at the bottom of each white box (funds in and
> funds out) agree with the statement.
> So why the ($195.14) difference? I note that is double the difference of
> $97.57 in the pre-reconciled sum.
> I am sure it is something obvious but I can't for the life of me see it.
> Dialog1.jpg  Dialog1.jpg>
> PreReconciled.jpg
> 
> Reconciled.jpg
> 
>
>
>
>
>
>
>
> -
> China Blue
> --
> View this message in context: http://gnucash.1415818.n4.
> nabble.com/Reconciling-an-account-tp4691993p4692059.html
> Sent from the GnuCash - User mailing list archive at Nabble.com.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Reconciling an account

[Mark Phillips]

I seriously doubt you have found a bug. You probably have a transaction in
GnuCash that does not match the bank's transaction. Digits are transposed,
debits/credits are reversed, a transaction is in the wrong account (so not
in the one you are reconciling) or something like that.

I have had this problem in the past. The best way for me to solve it is to
get away from the computer screen and use paper and pencil to find the
errant transaction(s). In GNUCash, go to Reports (top line menus) and
select Transaction Report. Run a transaction report for the account in
question for the date range in question. Include the option to include the
reconciliation date for each transaction. Print it out. Take a highlighter,
and compare each transaction on the GnuCash report with the bank statement.
Cross out the ones on BOTH sheets of paper that 100% MATCH - be sure the
column for the reconciliation date is blank (or correct for the current
period you are working on) for that transaction, or you have reconciled
that transaction in an earlier reconciliation (an aha - you have found one
error). At the end of this exercise, you should have found the error(s) -
either on the bank or on you. ;) Remember, the $195.14 is the SUM of ALL
the errors in this reconciliation.

Good luck!

Mark

On Mon, Jun 5, 2017 at 5:08 PM, EngineInstitute 
wrote:

> Colin,
>
> I was thinking it was a version problem so I updated my software to make
> sure this was not the case.
>
> I love your suggestion. I did not know about the filter option. So I
> implemented it and cleared the reconciled items, then went back to the
> reconcile for that month and all agrees. Yeh for you!
>
> But don't celebrate totally yet. I am at the next and final month to
> reconcile. I go to do the reconcile dialog box and check everything and all
> of the items are ok: date, starting and ending balance all agree with final
> statement. When this happens it should be a cake walk right? Not for me.
>
> I check off all of the credits and debits and compare their totals
> (reflected on the bottom) with the statement and everything is in order yet
> I am faced with a difference of $195.14. This is definitely not correct.
> Have I found a bug?
>
>
>
> -
> China Blue
> --
> View this message in context: http://gnucash.1415818.n4.
> nabble.com/Reconciling-an-account-tp4691993p4692053.html
> Sent from the GnuCash - User mailing list archive at Nabble.com.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
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.