Request assistance for importing invoice/bill payments

[Nelson Handcock]

Hi,

On checking the transactions that I imported, I have used "Assets:Accounts
Receivable" and "Income:Sales" when importing the qif file - I should have
used "Assets:Current Assets:Trading Account" instead of "Income:Sales".

I set the transactions up in that account and hey presto the "Assign as
Payment" pop-up worked.


Thanks for your advice, Derek!



Thanks & Regards,

Nelson Handcock
0409 149919

http://www.linkedin.com/in/nelsonhandcockaustralia

On Mon, Sep 29, 2014 at 2:19 PM, Nelson Handcock <nelson.handcock at gmail.com>
wrote:

> Thanks Derek - I'll look into your suggestions further as soon as I can,
> and will let you know how I get on.
>
> Thanks & Regards,
>
> Nelson Handcock
>
> <http://www.linkedin.com/in/nelsonhandcockaustralia>
>
> On Mon, Sep 29, 2014 at 10:11 AM, Derek Atkins <warlord at mit.edu> wrote:
>
>> Hi,
>>
>> Nelson Handcock <nelson.handcock at gmail.com> writes:
>>
>> > Hello Geert,
>> >
>> > Thanks for responding. As per my screenshots on my dropbox (refer to my
>> > original email). - I am successfully importing Bills and Invoices using
>> the
>> > importer tool, and I'd like to do similar with payments for the
>> > transactions.
>>
>> Unforuntely there is an importer for bills and invoices, but there is no
>> importer for "payments".
>>
>> [snip]
>> > The "Assign as Payment..." does literally nothing. I am in the list of
>> > transactions for the Expenses:Accounts Receivable account - I highlight
>> a
>>
>> And *THIS* is your problem.   The imported payment is going to EXPENSES
>> and not ASSETS.  The payment is from ASSETS:A/R to Cash, not from
>> EXPENSE (or Income).  That's why the "Assign" isn't working.
>>
>> [snip]
>> > When I used the qif importer it automatically creates entries in the
>> > Expenses and Income accounts. With the csv transaction importer I
>> expect I
>> > will have to build both these transactions separately, and maybe even
>> have
>> > them in separate import files (one for each account).
>>
>> You're just putting them into the wrong place.
>>
>> > So at this stage the qif importer looked to be the better tool (2
>> > transactions based on a single data source - no mucking around getting
>> the
>> > data into the correct columns, etc).
>>
>> It is, IMHO, the "better tool."   :)
>>
>> > I've exported transactions into a csv file and I imagine I'd have to
>> build
>> > a csv file that has the same layout to use for imports. I'm happy to
>> > explore the transaction importer approach more, if that's going to be
>> the
>> > best thing to do.
>> >
>> > Your advice will be appreciated...
>>
>> > Please remember to CC this list on all your replies.
>> > You can do this by using Reply-To-List or Reply-All.
>>
>> -derek
>>
>> --
>>        Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>>        Member, MIT Student Information Processing Board  (SIPB)
>>        URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
>>        warlord at MIT.EDU                        PGP key available
>>
>
>