How to Process Payment after import of bank transactions

Tue May 10 06:52:52 EDT 2016

I’ve never processed payments after importing bank transactions, however I have processed payments after they’ve been entered in other ways.
In register view, with the transaction selected, I go to the transaction menu, and part way down is “assign payment” or some similar wording.

Select that, and you get to select the customer, and then the customer’s invoices will show up, and you can select which invoice or invoices to associate the payment with.

Also works for payments you made, only select a vendor.

Not sure whether this is what you seek, but it hasn’t been mentioned.

On May 9, 2016, at 7:52 AM, John <hoppejrjr at gmail.com> wrote:

> Thanks to Keith for his suggestion / work around for using a clearing account.
> This means the original import data is retained and ensures no deletions are required, which is open to errors.
> However this is still not ideal and I would like to submit a development request if possible, assuming it is not possible to post directly from the imported transaction.
> 
> Many thanks,
> John
> 
> -----Original Message----- From: gnucash-user-request at gnucash.org
> Sent: Thursday, May 5, 2016 5:00 PM
> To: gnucash-user at gnucash.org
> Subject: gnucash-user Digest, Vol 158, Issue 14
> 
> Send gnucash-user mailing list submissions to
> gnucash-user at gnucash.org
> 
> To subscribe or unsubscribe via the World Wide Web, visit
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> or, via email, send a message with subject or body 'help' to
> gnucash-user-request at gnucash.org
> 
> You can reach the person managing the list at
> gnucash-user-owner at gnucash.org
> 
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of gnucash-user digest..."
> 
> 
> Today's Topics:
> 
>  1. How to Process Payment after import of bank transactions (John)
>  2. Re: How to Process Payment after import of bank transactions
>     (kjbean+keith)
>  3. Re: Customer report (Wendell)
>  4. Re: Projected Balances? (Phil Longstaff)
> 
> 
> ----------------------------------------------------------------------
> 
> Message: 1
> Date: Thu, 5 May 2016 11:17:53 +0100
> From: John <hoppejrjr at gmail.com>
> To: <gnucash-user at gnucash.org>
> Subject: How to Process Payment after import of bank transactions
> Message-ID: <3679E826ECE748CEA9D6CD7D2FF70BF1 at johnR>
> Content-Type: text/plain; charset="iso-8859-1"
> 
> I import bank transactions using the standard QIF file and under the Transfer column the entries require to be allocated to accounts.
> For a lot of entries I then want to allocate various payments and receipts to Vendors and Customers (matching to invoices so the Ageing reports work),
> but the only way I can see how to do this is manually enter the bank transaction again via Business> Customer / Vendor>Process Payment and delete the imported entry!
> There must be an easier way!
> Nb. allocating just to Accounts Receivable or Payable is insufficient as no matching to a specific customer / vendor invoice takes place.
> Can you please help.
> 
> ------------------------------
> 
> Message: 2
> Date: Thu, 05 May 2016 12:05:54 +0100
> From: kjbean+keith <keith at kjbean.plus.com>
> To: <gnucash-user at gnucash.org>
> Subject: Re: How to Process Payment after import of bank transactions
> Message-ID: <a93ebd4dfb6f1c4851638b042f0feac9 at imap.plus.net>
> Content-Type: text/plain; charset=UTF-8; format=flowed
> 
> I created a current asset called Cash and Cheque Clearing Account.
> All receipts are posted to this account when imported. The clearing
> account can then be used as the source of funds when allocating the
> money to invoices.
> 
> Regards
> Keith
> 
> On 05.05.2016 11:17, John wrote:
>> I import bank transactions using the standard QIF file and under the
>> Transfer column the entries require to be allocated to accounts.
>> For a lot of entries I then want to allocate various payments and
>> receipts to Vendors and Customers (matching to invoices so the Ageing
>> reports work),
>> but the only way I can see how to do this is manually enter the bank
>> transaction again via Business> Customer / Vendor>Process Payment and
>> delete the imported entry!
>> There must be an easier way!
>> Nb. allocating just to Accounts Receivable or Payable is insufficient
>> as no matching to a specific customer / vendor invoice takes place.
>> Can you please help.
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at 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.
> 
> 
> 
> ------------------------------
> 
> Message: 3
> Date: Thu, 5 May 2016 06:18:02 -0600
> From: Wendell <wkrause at ncodesys.com>
> To: Lewis Balentine <lewis at keywild.com>
> Cc: gnucash-user at gnucash.org
> Subject: Re: Customer report
> Message-ID: <572B39FA.6000102 at ncodesys.com>
> Content-Type: text/plain; charset=windows-1252; format=flowed
> 
> Hello Lewis,
> 
> Thank you.
> I use Ubuntu 14.4 and the Open Office suite including all updates. I
> have a dual boot with Winders 8 which I haven't booted to in a couple of
> years.
> 
> Wendell
> 
> On 05/04/2016 08:53 PM, Lewis Balentine wrote:
>> OK Wendell ...
>> A little information, then:
>> What Operating System are you using?
>> What Office Suite are you using?
>> Fair warning ... I not set hands on an Apple MAC in more than two
>> decades ...
>> 
>> Lewis
>> 
>> 
>> On 05/04/2016 11:25 AM, Wendell wrote:
>>> Hello all,
>>> I find it odd that I cannot generate a customer or vendor list.
>>> The customer ID has separators in it to differentiate the town they
>>> live in. I would like to be able to separate specific towns to
>>> receive emails pertaining to their location.
>>> That and the ability to print updated customer lists.
>>> Has anyone found a solution to this? If so, is there a tutorial for
>>> dummies that I can go to?
>>> 
>>> Thanks in advance,
>>> Wendell
>> 
>> 
>> 
> 
> 
> 
> ------------------------------
> 
> Message: 4
> Date: Thu, 5 May 2016 09:19:00 -0400
> From: Phil Longstaff <phil.longstaff at gmail.com>
> To: Gnucash user list <gnucash-user at gnucash.org>
> Subject: Re: Projected Balances?
> Message-ID:
> <CAJcsxFHOxAzovoBUAkiyQKRvnpMW=CrqHtFQArVcODZWFmvu6w at mail.gmail.com>
> Content-Type: text/plain; charset=UTF-8
> 
> On Wed, May 4, 2016 at 11:13 PM, Lewis Balentine <lewis at keywild.com> wrote:
> 
>> I was just looking at the DB tables. There is one "schedxactions" but
>> there is no data in it for the transaction itself. There is one field
>> labelled "template_act_guid" (32 character text). I am going to make a wild
>> guess that it is using a previous transaction as its template ... thus
>> editing the 'template' would lead to other problems.
>> 
> 
> No, I think that's the template transaction that you can edit using the
> Sched Transaction editor. When you apply a scheduled transaction, gnucash
> uses that transaction to create the new instance.
> 
> 
> ------------------------------
> 
> Subject: Digest Footer
> 
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> 
> 
> ------------------------------
> 
> End of gnucash-user Digest, Vol 158, Issue 14
> ********************************************* 
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at 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.